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»