-
parallel computing
Parallel computing is the simultaneous use of multiple compute resources to solve a computational problem.
click here to
read more
- axis
A set of tuples. Each tuple is a vector of members. A set of axes defines the coordinates of a multidimensional data set. For more information about axes, see the OLE DB documentation.
- slice
A subset of the data in a cube, specified by limiting one or more dimensions by members of the dimension. For example, facts for a particular year constitute a slice of multiyear data.
- tuple
An ordered collection of members from different dimensions. For example, (Boston, [1995]) is a tuple formed by members of two dimensions: Geography and Time. A single member is a degenerated case of a tuple and can be used as an expression without the parentheses.
- computed column
A virtual column in a table whose value is computed at run time. The values in the column are not stored in the table, but are computed based on the expression that defines the column. An example of the definition of a computed column is: Cost as Price * Quantity .
- data warehouse
A database specifically structured for query and analysis. A data warehouse typically contains data representing the business history of an organization.
- density
The percentage of cells that contain data in a multidimensional structure. Analysis Services stores only cells that contain data. A dense cube requires more storage than a sparse cube of identical structure design.
- sparsity
The relative percentage of a multidimensional structure's cells that do not contain data. Analysis Services stores only cells that contain data. A sparse cube requires less storage than a dense cube of identical structure design.
click
here to read more
- data explosion
The exponential growth in size of a multidimensional structure, such as a cube, due to the storage of aggregated data.
click
here to read more
- dimension
A structural attribute of a cube, which is an organized hierarchy of categories (levels) that describe data in the fact table. These categories typically describe a similar set of members upon which the user wants to base an analysis. For example, a geography dimension might include levels for Country, Region, State or Province, and City.
- hierarchy
A logical tree structure that organizes the members of a dimension such that each member has one parent member and zero or more child members.
- level
The name of a set of members in a dimension hierarchy such that all members of the set are at the same distance from the root of the hierarchy. For example, a time hierarchy may contain the levels Year, Month, and Day.
- distributed query
A single query that accesses data from multiple data sources.
- drill down/drill up
A technique for navigating through levels of data ranging from the most summarized (up) to the most detailed (down). For example, when viewing the details of sales data by year, a user can drill down to display sales data by quarter, and further to display data by month.
- fact table
A central table in a data warehouse schema that contains numerical measures and keys relating facts to dimension tables. Fact tables contain data that describes specific events within a business, such as bank transactions or product sales.
- Multidimensional Expressions (MDX)
A syntax used for defining multidimensional objects and querying and manipulating multidimensional data.
- multidimensional structure
A database paradigm that treats data not as relational tables and columns, but as information cubes that contain dimension and summary data in cells. Each cell is addressed by a set of coordinates that specify a position in the structure's dimensions. For example, the cell at coordinates {SALES, 1997, WASHINGTON, SOFTWARE} would contain the summary of software sales in Washington in 1997.
- measure
In a cube, a set of values that are based on a column in the cube's fact table and are usually numeric. Measures are the central values that are aggregated and analyzed.
- member
An item in a dimension representing one or more occurrences of data. A member can be either unique or nonunique. For example, 1997 and 1998 represent unique members in the year level of a time dimension, whereas January represents nonunique members in the month level because there can be more than one January in the time dimension if it contains data for more than one year.
- multidimensional OLAP (MOLAP)
A storage mode that uses a proprietary multidimensional structure to store a partition's facts and aggregations or a dimension. The data of a partition is completely contained within the multidimensional structure.
- OLAP.
On-line analytical processing.
OLAP is loosely defined as a set of principles that provide a
dimensional framework for decision support.
click here to read more
- persistence
The saving of an object definition so it will be available after the current session ends.
- pivot
To rotate rows to columns, and columns to rows, in a crosstabular data browser.
To choose dimensions from the set of available dimensions in a multidimensional data structure for display in the rows and columns of a crosstabular structure.
- slice
A subset of the data in a cube, specified by limiting one or more dimensions by members of the dimension. For example, facts for a particular year constitute a slice of multiyear data.
|
