(Business Intelligence) BI Systems

12.1  What are BI systems?

12.2  How do BI systems differ from transaction processing systems?

12.3  Name and describe the two main categories of BI systems.

12.4  What are the three sources of data for BI systems?

12.5  Explain the difference in processing between reporting and data mining applications.

12.6  Describe three reasons why direct reading of operational data is not feasible for BI


12.7  Summarize the problems with operational databases that limit their usefulness for BI


12.8  What are dirty data? How do dirty data arise?

12.9  Why is server time not useful for Web-based order entry BI applications?

12.10  What is click-stream data? How is it used in BI applications?

12.11  Why are data warehouses necessary?

12.12  Why do the authors describe the data in Figure 12-6 as "frightening"?

12.13  Giveexamples of data warehouse metadata.

12.14  Explain the difference between a data warehouse and a data mart. Use the analogy of a supply chain.

12.15  What is the enterprise data warehouse (EDW)architecture?

12.16  Describe the differences between operational databases and dimensional databases.

12.17  What is a star schema?

12.18  What is a fact table? What type of data is stored in fact tables?

12.19  What is a measure?

12.20  What is a dimension table? What type of data is stored in dimension tables?

†Part 5† †Database Access Standards

12.21  What is a slowlychanging dimension?

12.22  Why is the time dimension important in a dimensional model?

12.23  What is a conformed dimension?

12.24  State the purpose of a reporting system.

12.25  What do the letters RFM stand for in RPManalysis?

12.26  Describe, in general terms, how to perform an RPManalysis.

12.27  Explain the characteristics  of customers having the following RPM scores:  {l 1  5},

{151}, {5 5 5}, {2 5 5}, {512}, {113}.

12.28  What does OLAPstand for?

12.29  What is the distinguishing characteristic of OLAPreports?

12.30  Define measure, dimension, and cube.

12.31  Give an example, other than one in this text. of a measure, two dimensions related to your measure, and a cube.

12.32  What is drill down?

12.33  Explain how the OLAPreport in Figure 12-23differsfrom that in Figure 12-22.

12.34  What is the purpose of an OLAPserver?

12.35  Define distributed database.

12.36  Explain one way to partition a database that has three tables: Tl, T2, and T3.

12.37  Explain one way to replicate a database that has three tables: Tl, T2, and T3.

12.38  Explain what must be done when fully replicating a database but allowing only one computer to process updates.

12.39  If more than one computer can update a replicated database, what three problems can occur?

12.40  What solution is used to prevent the problems in ReviewQuestion 12.39?

12.41  Explain what problems can occur in a distributed database that is partitioned but not replicated.

12.42  What organizations should consider using a distributed database?

12.43  Explain the meaning of the term object persistence.

12.44  In general terms,  explain why relational databases  are difficult to  use for object persistence.

12.45  What does OODBMS stand for, and what is its purpose?

12.46  According to this chapter, why were OODBMSsnot successful?

12.47  What is an object-relational database?

12.48  What is v:irtualization?

12.49  What is cloud computing?

12.50  What is BigData?

12.51  What is the relationship between 1 MB of storage and lEB of storage?

12.52  What is the NoSQLmovement?

12.53  What were the first two nonrelational data stores to be developed, and who developed them?

(Business Intelligence) BI Systems

  • Order

  • Payment

  • Processing

  • Delivery

Validation error occured. Please enter the fields and submit it again.
Thank You ! Your email has been delivered.