Questions from Database Systems


Q: What is a data warehouse, and what are its main characteristics

What is a data warehouse, and what are its main characteristics? How does it differ from a data mart?

See Answer

Q: Give three examples of likely problems when operational data are integrated into

Give three examples of likely problems when operational data are integrated into the data warehouse.

See Answer

Q: While working as a database analyst for a national sales organization,

While working as a database analyst for a national sales organization, you are asked to be part of its data warehouse project team. Prepare a high-level summary of the main requirements for evaluating...

See Answer

Q: Trace the use of the transaction log in database recovery.

Trace the use of the transaction log in database recovery.

See Answer

Q: Find the listing of customers who did not make purchases during the

Find the listing of customers who did not make purchases during the invoicing period. Your output must match the output shown in Figure P7.40. FIGURE P7.40 Customer Balances for Customers Who Did Not...

See Answer

Q: While working as a database analyst for a national sales organization,

While working as a database analyst for a national sales organization, you are asked to be part of its data warehouse project team. Your data warehousing project group is debating whether to create a...

See Answer

Q: What is Big Data? Give a brief definition.

What is Big Data? Give a brief definition.

See Answer

Q: What is the difference between a name node and a data node

What is the difference between a name node and a data node in HDFS?

See Answer

Q: Explain the basic steps of MapReduce processing.

Explain the basic steps of MapReduce processing.

See Answer

Q: Briefly explain how HDFS and MapReduce are complementary to each other.

Briefly explain how HDFS and MapReduce are complementary to each other.

See Answer