Multidimensional database definition
A multidimensional database organizes data into dimensions and facts optimizing it for complex querying and fast access. Primarily used in online analytical processing (OLAP) and business intelligence, it supports in-depth data analysis from various perspectives.
See also: flat file
History of multidimensional database
Multidimensional databases, evolving since the 1970s, were developed to enhance data analysis and support decision-making in business. The 1980s introduced Online Analytical Processing (OLAP) systems, revolutionizing data organization and retrieval by enabling multidimensional views for complex queries.
In the 1990s, these databases gained mainstream adoption as major software companies integrated OLAP features into their products, catering to a growing demand for advanced data analysis tools.
Examples of multidimensional database
- Microsoft analysis services. Microsoft Analysis Services is a component of Microsoft SQL Server, offering robust multidimensional database capabilities.
- Oracle essbase. Oracle Essbase is a highly regarded multidimensional database platform, widely used for enterprise performance management and business analytics.
- IBM Cognos TM1. It is a multidimensional database tool designed for enterprise planning, budgeting, and forecasting. It allows for real-time data analysis and collaboration.