Q. What is the goal of building data warehouses in terms of business intelligence?

View solution

Q. How did early data warehouses start in terms of user groups?

View solution

Q. What was a limitation of second-generation decision support systems running on client/server architecture?

View solution

Q. What impact has the Web had on information delivery in Web-enabled data warehouses?

View solution

Q. What question arises regarding OLAP systems in a Web-enabled data warehouse?

View solution

Q. What are the three approaches to implementing OLAP in a Web-enabled data warehouse?

View solution

Q. What is a characteristic of the approach, using browser plug-ins for OLAP implementation?

View solution

Q. What is a disadvantage of the approach, providing pre-created HTML documents for OLAP?

View solution

Q. What is a key advantage of the approach, implementing OLAP in the server?

View solution

Q. What benefits does the approach, OLAP in the server, provide in a production environment?

View solution

Q. What is a critical factor in the design of the OLAP engine for a Web-enabled data warehouse?

View solution

Q. What does a properly designed OLAP engine produce in terms of performance as the number of concurrent users increases?

View solution

Q. What is a potential disadvantage of an OLAP engine that depends completely on the RDBMS for multidimensional processing?

View solution

Q. What challenges arise with an OLAP engine that relies on the RDBMS for multidimensional processing?

View solution

Q. How does the number of concurrent users impact an OLAP system that depends on the RDBMS?

View solution

Q. What are two problems associated with an OLAP engine that generates SQL to access summary data and performs all processing on a middle tier?

View solution

Q. What is a potential issue with an OLAP engine that relies completely on the RDBMS for multidimensional processing?

View solution

Q. What is an advantage of an intelligent OLAP engine in distributing joins, aggregations, and calculations?

View solution

Q. What does the intelligent OLAP engine have the ability to do regarding the type of request and its optimal processing location?

View solution

Q. How does the intelligent OLAP engine contribute to system processing in a Web-enabled data warehouse?

View solution