Chapter 13 Database Systems: Design, Implementation, and Management CORRECT VERIFIED ANSWERS

Chapter 13 Database Systems: Design, Implementation, and Management Algorithm - correct answers A process or set of operations in a calculation. Most common among data mining are based on neural networks, decision trees, rules induction.... attribute hierarchy - correct answers A top-down data organization that is used for two main purposes: aggregation and drill-down/roll-up data analysis. Business Intelligence (BI) - correct answers A comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information to support business decision making. cube cache - correct answers In multidimensional OLAP, the shared, reserved memory area where data cubes are held. It assists in speeding up data access. dashboard - correct answers In business intelligence, a web-based system that presents key business performance indicators or information in a single, integrated view with clear and concise graphics. Data analytics - correct answers A subset of business intelligence functions that encompasses a wide range of mathematical, statistical, and modeling techniques with the purpose of extracting knowledge from data. Data Cube - correct answers The multidimensional data structure used to store and manipulate data in a multidimensional DBMS. The location of each data value in the data cube is based on its x-, y-, and z-axes. They are static, meaning they must be created before they are used, so they cannot be created by an ad hoc query. Data extraction - correct answers A process used to extract and validate data from an operational database and external data sources prior to their placement in a data warehouse. data filtering - correct answers A process used to extract and validate data from an operational database and external data sources prior to their placement in a data warehouse. Data mart - correct answers A small, single-subject data warehouse subset that provides decision support to a small group of people. Data mining - correct answers a process that employs automated tools to analyze data in a data warehouse and other sources and to proactively identify possible relationships and anomalies Decision Support System (DSS) - correct answers An arrangement of computerized tools used to assist managerial decision making within a business.