Logi XOLAP - Logi XOLAP Data Cubes

Working from the premise that there can be useful multi-dimensional analysis of data that's not necessarily in an OLAP cube, Logi Info includes the ability to create similar data structures on the fly and report on them.

At run time, a Logi Info report can query a wide variety of data sources and build a temporary, XML-based virtual data cube from the results.

Specialized Logi Info elements allow analysis of, and reporting on, these XML cubes. Logi XML Online Analytical Processing, or Logi XOLAP, delivers much of the analytical power of data cubes without the overhead associated with building large OLAP systems.

Naturally, there are some limits. While Logi XOLAP is similar to OLAP in its analytical methods, it doesn't necessarily support the same scale.

OLAP cubes usually include vast amounts of often historical data and are designed with a range of queries in mind, so that specific and ad hoc queries can be handled. They are relatively permanent structures and are often only dynamic in that new data is constantly added to them. Essentially, an OLAP cube is designed and built long before the first query against it is issued.

Logi XOLAP, on the other hand, builds a virtual data cube on demand in response to specific query from an individual user. Therefore, queries that involve millions of result rows may result in unacceptably slow performance. As with all attempts to quantify database limits, a number of factors such as the number of columns, data types, and the number of concurrent queries make it difficult to provide specific row limits.

Logi XOLAP is generally optimized for 10's to 100's of thousands of records, and with the benefit of the Hybrid Caching of the Logi Server Engine, it can also scale based on hardware such as RAM and CPU/Processing power. For more information, see Hybrid Caching.

Logi XOLAP performance is monitored in a special section of the Logi Info Debugger Trace Page, so you can see how long it takes to process your data.

For example, the Debugger entry above shows that it took just over 1/10th ofa second to query the data and create a Logi XOLAP cube using a 10,000+ record data set on a desktop-class PC. This can be extrapolated, given the exact same data, cube dimensions and measures, and query load, to 5.5 million+ rows a minute. We can't guarantee a specific performance level but this example is representative.

The ability to create virtual cubes of XML data, even from data sources not normally associated with OLAP, and report on them is a fantastic capability that allows new opportunities for data analysis.