Questions from Database Systems


Q: How does a BASE system differ from a traditional distributed database system

How does a BASE system differ from a traditional distributed database system?

See Answer

Q: Using the results of the query created in Problem 37, provide

Using the results of the query created in Problem 37, provide a summary of customer balance characteristics as shown in Figure P7.38. FIGURE P7.38 Balance Summary for Customers Who Made Purchases

See Answer

Q: What is business intelligence? Give some recent examples of BI usage

What is business intelligence? Give some recent examples of BI usage, using the Internet for assistance. What BI benefits have companies found?

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. Suppose you are selling the data warehouse idea to your users. How w...

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. The data warehousing project group has invited you to provide an OLA...

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. One of your vendors recommends using an MDBMS. How would you explain...

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. The project group is ready to make a final decision between ROLAP an...

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. The data warehouse project is in the design phase. Explain to your f...

See Answer

Q: Briefly discuss OLAP architectural styles with and without data marts.

Briefly discuss OLAP architectural styles with and without data marts.

See Answer

Q: What is OLAP, and what are its main characteristics?

What is OLAP, and what are its main characteristics?

See Answer