Choosing the right database is crucial for the success of a project. Different databases excel at different tasks and it is important to consider factors such as data type and usage. There are three main types of databases - user-facing databases, databases for analytics, and databases for operations. User-facing databases include relational databases and NoSQL databases. Analytical databases are used for analyzing data and include data warehouses and data lakes. Operational databases are used for internal operations and include key-value stores, time series databases, and logs/search databases.
Table of contents
Databases 101Finding the Right Data Flour: Why Your Choice of Database MattersUnderstanding Data and Its Usage3 Main Types of Databases and Their RolesDatabases that power a user-facing appUser-facing DBs / Relational DatabasesUser-facing DBs / NoSQL DatabasesUser-facing DBs / Graph DatabasesDatabases that power analyticsAnalytical DBs / Data WarehousesAnalytical DBs / Data LakesDatabases that power operationsOperational DBs / Key Value StoresOperational DBs / Time Series DatabasesOperational DBs / Logs and Search DatabasesSort: