|
Answer» Database: A database is a logically organized collection of structured data kept electronically in a computer SYSTEM. A database MANAGEMENT system is usually in charge of a database (DBMS). The data, the DBMS, and the applications that go with them are referred to as a database system, which is commonly abbreviated to just a database. The following table ENLISTS the difference between data warehouse and database:- | Data Warehouse | Database |
|---|
| Data Warehouse uses the OnLine Analytical Processing (OLAP). | Database uses the OnLine Transactional Processing (OLTP). | | Data Warehouse is mainly used for analyzing the historical data so as to make FUTURE decisions based on them. | The database aids in the execution of basic business procedures. | | Because a data warehouse is denormalized, tables and joins are straightforward. | A database's tables and joins are complicated because they are normalised. | | It can be referred to as a subject-oriented collection of data. | It can be referred to as an application-oriented collection of data. | | In this, data modelling techniques are used for designing. | In this, Entity-Relationship (ER) modelling techniques are used for designing. | | Data may not be up to date in this. | Data is generally up to date in this. | | The data structure of Data Warehouse is based on a dimensional and normalised approach. For example, a star and snowflake schema is employed. | For data storing, the FLAT Relational Approach approach is employed. | | Generally, highly summarized data is stored in a data warehouse. | Generally, detailed data is stored in a database. |
|
