DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Is a relational database that is designed for query and analysis
|
|
|
Is a non-relational database that is designed for query and analysis
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -A data warehouse is a central repository of information that can be analyzed to make more informed decisions. Data flows into a data warehouse from transactional systems, relational databases, and other sources, typically on a regular cadence.
Detailed explanation-2: -A data warehouse is a relational database that is designed for query and analysis rather than transaction processing. It usually contains historical data that is derived from transaction data, but it can include data from other sources.
Detailed explanation-3: -A system that is used to run the business in real time and is based on historical data.
Detailed explanation-4: -A relational database organizes data into rows and columns, which collectively form a table. Data is typically structured across multiple tables, which can be joined together via a primary key or a foreign key.
Detailed explanation-5: -Like a database, a data warehouse has a relational structure, in that data is organized into tables, rows, and columns-but there’s one key difference. While the data in a database is organized and stored by row, the data in a data warehouse is stored by columns, to facilitate online analytical processing (OLAP).