Submitted by felixdragan on Mon, 2007-11-19 13:32.
Some definitions
The data cube is a conceptual representation of database (or a subset of it) which offers fast access/views of data in any number of dimensions.
OLAP(Online Analytical Processing) cubes can be thought of as extensions to the two-dimensional array of a spreadsheet.
In database theory, an OLAP cube is an abstract representation of a projection of an RDBMS relation.
A data mart is a repository of data gathered from a database (or data warehouse) which allows the knowledge user to analyse the stored data in a more specialised way.
For instance, a company wants to analyse some of its data by time-period, by product, by location, by cost and by comparing this data with a budget.
Since a database/datawarehouse is a strategic aggregation of data, a data mart is a data model which tends to facilitate the access and usability (also avoiding complex queries which can accomplish the same thing in relational database systems).
It can also be said that a data mart allows a tactical representation of data through its model designed around data legibility. It addresses the knowledge worker's culture, the decision support needs and actuallt neglects the organisational boundaries between data management and data movement within large companies.
click here for an example
How it can be used on Digital Laurie Grove Baths
- Data cubes may help in making available different ways of representing data stored and related within the RDMS of Laurie Grove Baths.
- It provides support for definition of various aggregation of data (and quite a lot has been already gathered).
- How this cubes are going to look is yet to be discussed between ma-im_ers.
References:
open source analytics
techtarget
noumenal
