a data repository that supports the efficient perform the selection of materialized views for databases with a reduced number of dimensions
a specialized data storage structure in which data is presummarized and cross-tabulated and then stored as individual cells in a matrix format, rather than in the row-and-column format of relational database tables. The source data can come either from a data warehouse or from other data sources. MDDBs can give users quick, unlimited views of multiple relationships in large quantities of summarized data.
An OLAP database that you create using the Application Manager or ESSCMD commands (in DB2 OLAP Server) or with the DB2 OLAP Integration Server desktop, which is in the Starter Kit. An OLAP database includes a database outline, data, associated optional calculation scripts, optional report scripts, and data load rules. DB2 OLAP Server stores the actual data and a shadow of the database outline in tables in a relational database.
A database that you create using the Application Manager or commands (in DB2 OLAP Server) or with the DB2 OLAP Integration Server desktop, which is in the Starter Kit. A multidimensional database includes a database outline, data, associated optional calculation scripts, optional report scripts, and data load rules. The relational storage manager stores the actual data and a shadow of the database outline in tables in a relational database. You can store many multidimensional databases in a single relational database. The multidimensional data storage manager stores the outline and data in files in the file system.
A powerful database that lets users analyze large amounts of data. An MDBS captures and presents data as arrays that can be arranged in multiple dimensions.
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.
A database management system in which data can be viewed and manipulated in multiple dimensions. Data is stored using multidimensional structures and is organized to support analytical operations such as drill-down, consolidation, slicing, and dicing.
A DBMS optimized to support multidimensional data. The best systems support standard RDBMS functionality and add high-bandwidth support for multidimensional data and queries. Users that need a lot of slices and dices might appreciate a multidimensional database.
A database that stores data in a multidimensional array, in which all possible combinations of data are reflected in cells that can be accessed directly. Analysts use multidimensional databases to quickly access summarized information without searching through gigabytes of data.
A database designed for on-line analytical processing. Structured as a multidimensional hypercube with one axis per dimension.
Database that stores data in dimensions. 13.27
Multidimensional databases are variously (depending on the context) data aggregators which combine data from a multitude of data sources; databases which offer networks, hierarchies, arrays and other data formats difficult to model in SQL; or databases which give a high degree of flexibility in the definition of dimensions, units, and unit relationships, regardless of data format.