Building the Data Warehouse

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

data element (1) an attribute of an entity; (2) a uniquely named and well-defined category of data that consists of data items and that is included in a record of an activity.

data item set (dis) a grouping of data items, each of which directly relates to the key of the grouping of data in which the data items reside. The data item set is found in the midlevel model.

data mart a departmentalized structure of data feeding from the data warehouse where data is denormalized based on the department’s need for information.

data mining the process of analyzing large amounts of data in search of previously undiscovered business patterns.

data model (1) the logical data structures, including operations and constraints provided by a DBMS for effective database processing; (2) the system used for the representation of data (for example, the ERD or relational model).

data structure a logical relationship among data elements that is designed to support specific data manipulation functions (trees, lists, and tables).

data warehouse a collection of integrated, subject-oriented databases designed to support the DSS function, where each unit of data is relevant to some moment in time. The data warehouse contains atomic data and lightly summarized data.

decision support system (DSS) a system used to support managerial decisions. Usually DSS involves the analysis of many units of data in a heuristic fashion. As a rule, DSS processing does not involve the update of data.

decompaction the opposite of compaction; once data is stored in a compacted form, it must be decompacted to be used.

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