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.