Constructing the OLAP Cube From Relational Databases/Flat Files

Most of them understand spreadsheets and table data. Few can understand databases but only very few can really process the data into meaningful information. Most companies professionals acquaint themselves with pivot tables which summarize data and provide the performance figures at a glance. But for advanced analysis of data, professionals are hired to run the data marts and warehouses. For faster results data in warehouses is often aggregated and pre-summarised and so called OLAP Cubes are constructed. The start point is usually a flat database(s) or relational databases which are usually designed from the perspective of transactional data. For any OLAP based work, it is said that 90% of efforts are made in construction of the Cube.

Provided by: Kurukshetra University Topic: Data Management Date Added: Dec 2011 Format: PDF

Find By Topic