Building the Data Warehouse

Скачать в pdf «Building the Data Warehouse»


dual database the practice of separating high-performance, transaction-oriented data from decision support data.


dual database management systems the practice of using multiple database management systems to control different aspects of the database environment.


dumb terminal a device used to interact directly with the end user where all processing is done on a remote computer. A dumb terminal acts as a device that gathers data and displays data only.


estetbusiness commerce conducted based on Web interactions.


encoding a shortening or abbreviation of the physical representation of a data value (e.g., male = “M,” female = “F”).


enterprise resource planning (ERP) application software for processing transactions.


entity a person, place, or thing of interest to the data modeler at the highest level of abstraction.


entity-relationship diagram (ERD) a high-level data model; the schematic showing all the entities within the scope of integration and the direct relationship between those entities.


event a signal that an activity of significance has occurred. An event is noted by the information system.


Executive Information Systems (EIS) systems designed for the top executive, featuring drill-down analysis and trend analysis.


extract/load/transformation (ETL) the process of taking legacy application data and integrating it into the data warehouse.


external data (1) data originating from other than the operational systems of a corporation; (2) data residing outside the central processing complex.


exploration warehouse a structure specifically designed for statistical processing that searches for business patterns.


extract the process of selecting data from one environment and transporting it to another environment.

Скачать в pdf «Building the Data Warehouse»