This is a type of database that is optimized for data warehouse, data mart and online analytical processing (OLAP) applications. The main advantage of this database is query performance.
Relational databases make it easy to work with individual records, whereas multidimensional databases are designed for analyzing large groups of records. Relational database is typically accessed using a Structured Query Language (SQL) query. A multidimensional database allows a user to ask questions like “How many mortgages have been sold in New Jersey city” and “How many credit cards have been purchased in a particular county?”.
| Database Name | Company Name |
|---|---|
| Crystal Holos | Business Objects |
| Hyperion Essbase | Hyperion |
| Oracle Express | Oracle Corporation |
| Oracle OLAP Option | Oracle Corporation |
| AWMicrosoft Analysis Services | Microsoft |
| PowerPlay Enterprise | Cognos |
Learn data modeling design Skills on OLTP and OLAP from a US University Professor with…
These SQL commands are related with Oracle's data dictionary and can be used to get…
important DDL Statements from Oracle like Commit, Rollback, Grant, Revoke etc..
In this section, we will try to explain about important database DROP commands that are…
In this section, we will try to explain about important database DML commands that are…
In this section, we will try to explain about important database ALTER commands that are…