multidimensional expressions
21Extract, transform, load — Extract, transform and load (ETL) is a process in database usage and especially in data warehousing that involves: Extracting data from outside sources Transforming it to fit operational needs (which can include quality levels) Loading it into… …
22Decision 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… …
23Data 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,… …
24MDX — The abbreviation, acronym, or initialism MDX has several different meanings: *Multidimensional Expressions, a query language for OLAP databases, much like SQL is a query language for relational databases *.MDX, a 3D Model Format used by Blizzard… …
25Dimension table — In data warehousing, a dimension table is one of the set of companion tables to a fact table. The fact table contains business facts or measures and foreign keys which refer to candidate keys (normally primary keys) in the dimension tables.… …
26Operational 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… …
27Dimension (data warehouse) — This article is about a dimension in a data warehouse. For other uses, see dimension (disambiguation). In a data warehouse, a dimension is a data element that categorizes each item in a data set into non overlapping regions. A data warehouse… …
28Measure (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… …
29Data 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 …
30Mosha Pasumansky — is one of the inventors of the MultiDimensional eXpressions (MDX) language, a query language for online analytical processing (OLAP) databases. Pasumansky is also one of the architects of the Microsoft Analysis Services, and an OLAP expert. Mosha …
