Which of the following is correct for data warehouse?
(A). Organized around important subject areas.
(B). Contains numerous naming conventions and formats.
(c). Can be updated by end users.
(D). Contains only current data.
Answer: Organized around important subject areas.
Difference between data warehouse and data mart
| Attribute | Data mart | Data warehouse |
| difficulty to build | easy | Difficult |
| Amount of memory | limited | bigger |
| Scope of the data | department-wide | enterprise-wide |
| Number of subject areas | single | many |
| time required to build | less | more |
Data warehouse Alternative names
- Business Intelligence Solution
- Executive Information System
- Management Information System
- Analytic Application
- Decision Support System (DSS)
Types of Data Warehouse
- Data Mart
- Operational Data Store
- Enterprise Data Warehouse (EDW)
Components of Data warehouse
- Query Manager:
- End-user access tools:
- Load manager:
- Warehouse Manager:
Tools for Data Warehouse
- Snowflake
- IBM Db2 Warehouse
- Amazon S3
- Cloudera
- Micro Focus Vertica
- Amazon RDS
- MarkLogic
- Google BigQuery
- Amazon DynamoDB
- MariaDB
- PostgreSQL
- Oracle Autonomous Warehouse
- Microsoft Azure
- Teradata
- Amazon Redshift
