Data Warehouse vs Database Flashcards
1
Q
Pulls together data from different
sources for reporting and analysis
A
Data Warehouse
2
Q
To store current transactions and enable fast
access to specific transactions for ongoing
business processes
A
Database
3
Q
Normalized data organized in columns,
rows and tables
A
Database
4
Q
To store large quantities of historical
data and enable fast, complex queries
across all data
A
Data Warehouse
5
Q
Use fewer tables
Doesn’t exclude data redundancie
A
Data Warehouse
6
Q
Normalized data
More complex queries required to read the
data as a single data combines data from
many tables
A
Database
7
Q
Related data separated into multiple tables.
Data is organized to make sure no
redundant data
A
Database
8
Q
Denormalized data
Offers better performance when
reading data for analytics purposes
A
Data Warehouse
