Exam 3: Database, Data Warehouse, and Data Mining

Mini-data warehouses are small-scale data warehouses that support a single function or department.

Because of volatility, data from databases are transferred to a data warehouse so that they are ready for quick responses to inquiries.

Aberdeen's 2012) survey of 176 organizations worldwide found that the volume of physical paper) documents is ________________ by approximately 30% per year.

The two basic types of database systems are static databases and dynamic databases.

Thanks to increased use of Document Management Systems DMS) many offices and companies are becoming "paperless".

Because the high costs of a data warehouse can make them too expensive for a company to operate, some organizations turn to an alternative, called a data mart.

In terms of the major functions performed by a DBMS, data enrichment refers to correcting, standardizing, and verifying the integrity of the data.

In terms of the major functions performed by a DBMS, "data synchronization" refers to integrating, matching, or linking data from disparate sources.

In terms of the major functions performed by a DBMS, data enrichment refers to which of the following?

Data warehouses that integrate data from databases across an entire organization are called ____________ data warehouses.

An active data warehouse ADW) is a relatively new OLAP system that is updated in real-time, providing the most current data available for analysis and decision support apps.

___________________________ are computer programs used to manage additions, updates, and deletions of data in a database as transactions occur; and support data queries and reporting.

According to a study conducted by MIT Sloan Management Review and IBM top-performing organizations use _______________ five times more than lower performers.

Data warehouses are designed as online transaction processing OLTP) systems, meaning that the data can be queried and analyzed much more efficiently than OLAP applications.

___________ are small-scale data warehouses that support a single function or department.

Briefly describe a Document Management System and explain why it is of increasing importance in today's business environment.

Data warehouses are designed as online analytical processing OLAP) systems, meaning that the data can be queried and analyzed much more efficiently than OLTP application databases.

Sometimes organizations place too much emphasis on the costs associated with acquiring high levels of data quality and ignore the costs of "dirty" or poor quality data. According to your text, what three factors make up the total costs associated with poor quality data?

Because of the very large amount of data and the costs associated with BI applications, small and mid-sized companies with limited IT staff and budgets sometimes use a new BI architecture called BI in the cloud.

What is the key advantage of an active data warehouse ADW) compared to a traditional data warehouse?