Multi-Dimensional Databases | Dimensions |
Cubes | Measures |
Hierarchies | Slicing |
Dicing | Roll-Up |
The different attributes or aspects of data that can be used for analysis and organization in a multi-dimensional database. | A type of database that is designed to store and query data with multiple dimensions, such as time, location, and product. |
The numerical values or metrics that are stored in a multi-dimensional database and can be analyzed and aggregated. | The main structures in a multi-dimensional database that contain the actual data and are used for analysis and reporting. |
The process of selecting a subset of data from a multi-dimensional database based on specific criteria or filters. | The levels of organization or categorization within dimensions in a multi-dimensional database, such as year, quarter, and month in a time dimension. |
The process of aggregating data from lower-level hierarchies to higher-level hierarchies in a multi-dimensional database. | The process of selecting multiple subsets of data from a multi-dimensional database based on multiple criteria or filters. |
Drill-Down | OLAP |
Online Analytical Processing, which refers to the ability to efficiently analyze and query data in a multi-dimensional database. | The process of navigating from a higher-level hierarchy to a lower-level hierarchy in a multi-dimensional database to view more detailed data. |