Questions from Database Management


Q: What is meant by a corporate information factory?

What is meant by a corporate information factory?

See Answer

Q: List the different roles played by data marts and data warehouses in

List the different roles played by data marts and data warehouses in a data warehouse environment.

See Answer

Q: Explain how the characteristics of data for data warehousing is different from

Explain how the characteristics of data for data warehousing is different from the characteristics of data for operational databases.

See Answer

Q: Why is real-time data warehousing called active data warehousing?

Why is real-time data warehousing called active data warehousing?

See Answer

Q: What type of an impact has the significant decrease in the cost

What type of an impact has the significant decrease in the cost of storage space had on data warehouse and data mart design?

See Answer

Q: What are the key differences between data warehousing and big data approaches

What are the key differences between data warehousing and big data approaches to analytical data management?

See Answer

Q: FAME (Forondo Artist Management Excellence) Inc. is an artist

FAME (Forondo Artist Management Excellence) Inc. is an artist management company that represents classical music artists (only soloists) both nationally and internationally. FAME has more than 500 art...

See Answer

Q: Discuss the role of an enterprise data model and metadata in the

Discuss the role of an enterprise data model and metadata in the architecture of a data warehouse.

See Answer

Q: Describe the characteristics of a surrogate key as used in a data

Describe the characteristics of a surrogate key as used in a data warehouse or data mart.

See Answer

Q: Explain the components of a star schema with figures and suitable examples

Explain the components of a star schema with figures and suitable examples.

See Answer