INFS 247 Study Guide - Quiz Guide: Online Analytical Processing, Data Warehouse, Data Mining
Document Summary
Operational database can be used by thousands of employees, partners and customers. Data warehouses are used by data analysts and decision makers. Etl infrastructure: the infrastructure that facilitates the retrieval of data from operational databases into the data warehouses, etl includes the following tasks: Extracting analytically useful data from the operational data sources. Transforming such data so that it conforms to the structure of the target data warehouse model, while ensuring the quality of the transformed data. Loading the transformed and quality assured data into the target data warehouse. Updating (i. e. inserting, modifying, and deleting), retrieving and presenting data from databases for operational purposes. Querying and presenting data from data warehouses and/or data marts for analytical purposes. Tools specifically for data mining: slice and dice, pivot (rotate, drill down/ drill up. Adds, replaces, or eliminates specified attributes (or particular values) from the already displayed result.