OLAP cubes can be thought of as extensions to the two-dimensional array of a spreadsheet. Although many report-writing tools exist for relational databases, these are slow when the whole database must be summarized. Instead, they are better suited for creating records from a series of transactions. Relational databases are not well suited for near instantaneous analysis and display of large amounts of data. The arrangement of data into cubes overcomes a limitation of relational databases. An OLAP cube is a data structure that allows fast analysis of data. The OLAP cube consists of numeric facts called measures which are categorized by dimensions. Or you can use Microsoft Excel to create rich and customized reports. You can explore the resulting cube with our OlapCube Reader. cub extension) from data stored in any relational database (including MySQL, PostgreSQL, Microsoft Access, SQL aServer, SQL Server Express, Oracle, Oracle Express). OlapCube will let you create local cubes (files with. OlapCube is a simple, yet powerful tool to analyze data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |