Databases and their types
In this section, we will cover the various types of databases that are commonly used to create modern data engineering solutions. We will also try to explore the possible scenario when a specific type of database will be used.
A database is a systematic collection of data or information that’s stored in such a way that it can easily be accessed, retrieved, and managed. In modern-day data engineering, primarily, databases can be broadly classified into two categories, as follows:
- Relational database: This is a kind of database known for storing structured datasets. Each type of dataset is related to another, and relational databases provide an easy way to establish a relationship between different kinds of datasets. We will discuss relational databases in detail later in this chapter.
- NoSQL databases or non-relational databases: NoSQL databases are non-relational databases, where data can be stored in some form other than a tabular format...