Data warehouses are large databases containing historical, summarized and consolidated data that are mostly populated from OLTP systems or external databases. A data warehouse is used to effectively store information, and OLAP is used for the retrieval of information. OLAP tools do not indicate how the data are actually stored. The case study that will be presented illustrates the implementation of a multidimensional data model and the corresponding data warehouse schema in order to perform on line analytical processing. The system is developed by utilizing Express, that is the family of OLAP Technology products from Oracle.
Express applications manipulate and display data using a multidimensional data model.
The multidimensional data model is created through Oracle's Express Relational Access Administrator, which is a component of Oracle's Express Relational Access Manager.