ElastiCubes are super-fast data stores that are specifically designed to withstand extensive querying typically required by business intelligence applications.
ElastiCubes allow you to bring in data from multiple sources, and then merge, manipulate and query the data as if it was one consolidated data set. ElastiCubes perform so well, that in most cases the creation of dedicated OLAP cubes and/or optimized data marts are completely unnecessary – even when dealing with hundreds of millions of rows of raw data.
One of the biggest advantages of ElastiCubes is the ability to easily mash up multiple data sources. It is made up of fields where each value in one field has a corresponding value in another field. The data for an ElastiCube can come from one source, multiple sources or even from multiple physical locations. Once the data is inside the ElastiCube, it is all the same and every field coming from every table can be analyzed in the context of any other – quickly.
ElastiCube technology make queries over hundreds of millions of rows of raw data return in seconds, with moderate hardware requirements including standard desktop-class computers with commodity hardware. More importantly, ElastiCubes can do this without having to pre-aggregate and pre-calculate the data ahead of time and store it on the hard-drive, thus radically reducing required import/processing time and storage space.
ElastiCubes are most useful when one or more of the following is true:
- Large amounts of data need to be analyzed
- Data for analysis originates from multiple disparate sources
ElastiCube Manager Environment
The ElastiCube Manager is a visual environment where you can import and structure multiple data sources, create relationships between data, and perform ETL (Extract, transform, and load) processes to prepare data for analysis and visualization.
- Data Schema Tab
- Main Menu
- Table and relationship layout
- Search tables and fields
- Zoom control
To learn more about the ElastiCube Manager, see Working in the ElastiCube Manager.
Hey! Was this article helpful?
Questions? Ask the community.