The data warehouse DBMS needs to be the same DBMS used for the operational database.

More Questions from Database Processing for BIS

• OLAP uses measures, dimensions and associations.
• Report types include static, dynamic, query and OLAP.
• In unsupervised data mining, explanations are created after patterns are found.
• In a common form of RFM analysis, customers are sorted in five groups and given a score of 1 to 5 depending on their group.
• OnLine Analytical Processing (OLAP) is a BI reporting system.
• Business Intelligence (BI) systems do not obtain data from operational databases.
• A data warehouse is a database system that is optimized for operational transaction processing.
• A data mart is a collection of data that, while smaller than a data warehouse, still addresses the entire business.
• The term neural networks as used in data mining is a misnomer.
• Most operational databases can be used for many BI applications.

Discussion & Comments