surrogate key
91Online analytical processing — In computing, online analytical processing, or OLAP (  /ˈoʊlæ …
92Data dictionary — Not to be confused with Dictionary (data structure). A data dictionary, or metadata repository, as defined in the IBM Dictionary of Computing, is a centralized repository of information about data such as meaning, relationships to other data,… …
93Degenerate dimension — Contents 1 The Kimball definition 2 Other uses of the term 3 See also 4 External reference 5 Notes …
94Business intelligence consulting services — BackgroundBusiness Intelligence (BI) is a complex undertaking for most large organisations. Large organisations typically have numerous (often in the hundreds of) information systems that help them to operate their business. These systems are… …
95Decision support system — Example of a Decision Support System for John Day Reservoir. A decision support system (DSS) is a computer based information system that supports business or organizational decision making activities. DSSs serve the management, operations, and… …
96Object identifier — In computing, an object identifier or OID is an identifier used to name an object (compare URN). Structurally, an OID consists of a node in a hierarchically assigned namespace, formally defined using the ITU T s ASN.1 standard.[citation needed]… …
97Operational data store — An operational data store (or ODS ) is a database designed to integrate data from multiple sources for additional operations on the data. The data is then passed back to operational systems for further operations and to the data warehouse for… …
98Measure (data warehouse) — For other senses of this word, see Measure (disambiguation). In a data warehouse, a measure is a property on which calculations (e.g., sum, count, average, minimum, maximum) can be made using precomputed aggregates. Contents 1 Example 2 Use of… …
99Data Mining Extensions — (DMX) is a query language for Data Mining Models supported by Microsoft s SQL Server Analysis Services product. Like SQL, it supports a data definition language, data manipulation language and a data query language, all three with SQL like syntax …
100Data transformation — Data transformation/Source transformation Concepts metadata · data mapping data transformation · model transf …
