DATABASES AND DATA WAREHOUSES
S. Ramalakshmi · 2023
A database is generally referred as a collection of data organized in a formatted structure for storage, accessibility and retrieval. There are various types of databases which include XML, CSV files, flat files and spreadsheets etc., the main two categories of databases includes data from OLTP (Online Transactional Processing) and OLAP (Online Analytical Processing). Both systems store data in the form of tables, columns, indexes, keys, views and data types. MySQL, Oracle and NoSQL are some query languages used to query the database. In the other side data warehouses are also the types of database that integrates data from multiple sources and provisions the data for analytical process. Data warehouse is an OLAP database. Data warehouses are mainly designed to enable and support business intelligence mainly data analytics. Data warehouses are often consists of huge volume of historical data. As a whole data warehouse collects data from different sources and stores it into a single repository for analytics and decision making. This chapter presents an overview about databases, types of databases, data warehouses and the differences between databases and data warehouses.