OpenRolap
Main project page
OpenRolap is an implementation of OLAP principles in a relational database. It is actually a set of algorithms that can be implemented in any relational database, and relased as open source (BSD License). More...
It's primary purpose is to provide fast access to a set of data. It does this via a series a pre-summarized tables stored in a (MySQL) database.
In some tests on a 1 million row table, OpenRolap improved query repsonse time by 99% or better.
It is lead by and currently maintained by Matt Stucky (stuckym44@yahoo.com).
It is primarily funded by Anclad.com Reporting and Analysis Outsourcing Services.
The objective of OpenRolap is to create a pre-summarized data structure for rapid response to queries of the original data table. "Adequate response time" is loosely defined as anything less than 3 seconds, but generally targeted as 1 second or less.
From the client side, it attempts to avoid complex "*.mdx" query language, instead using a simple "filter path" construct to filter the data "from the top down". A filter path is somewhat similar to an SQL "where" statement in that it specifies a series of dimension-value pairs, as in
"Salesperson=Jones and Month=January"
OpenRolap allows hundreds of thousands, millions, tens of millions and even hundreds of millions of rows. Its purpose is to provide rapid response to any question, even when the underlying data contains hundreds of millions of rows. MySQL is chosen as the reference implementation because it is (a) open source, and (b) already optimized for speed. However, the principles of OpenRolap can be applied to any database.
Last Update: Monday, 19-Mar-2007 09:15:12 MDT
