What is a data warehouse and what are its main characteristics quizlet?

What is a data warehouse and what are its main characteristics?

A data warehouse is a relational or multidimensional database that is designed for query and analysis. Data warehouses are not optimized for transaction processing, which is the domain of OLTP systems. Data warehouses usually consolidate historical and analytic data derived from multiple sources.

What are the characteristics of data warehouse quizlet?

Terms in this set (16)Characteristics of a data warehouse. - Subject-oriented. ... Data warehouse. - Used for data retrieval and analysis. ... Traditional database. - Used to run daily business transactions. ... Star schema. ... Denormalization. ... Database partitioning. ... Aggregation. ... Levels of data.

What is data warehouse quizlet?

Data warehouse. A logical collection of information - gathered from many different operational databases - that supports business analysis activities and decision-making tasks. primary purpose of a data warehouse. aggregate information throughout an organization into a single repository for decision-making purposes.

What are the four characteristics of data in a warehouse?

Characteristics Of A Data Warehouse. The four characteristics of a data warehouse, also called features of a data warehouse, include SUBJECT ORIENTED, TIME VARIANT, INTEGRATED and NON-VOLATILE.