1. Why are traditional databases called operational or transactional? Why are these databases inappropriate for data analysis?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

 

1.  Discuss four main characteristics of data warehouses.

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

3.   What is the purpose of online analytical processing (OLAP) systems and how are they related to data warehouses?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

 

4.   What is the extraction, transformation, and loading (ETL) process?

________________________________________________________________________

________________________________________________________________________

________________________________________________________________________

 

5.   Explain the differences between spatial databases and spatial data warehouses.

________________________________________________________________________

Answer rating: 100% (QA)

Traditional databases are often called operational or transactional databases because they are optimized for handling daytoday operations and transactions of an organization These databases are design... View the full answer