10 September 2010

The Ruby Reflector

Topic

OLAP

  Source Favicon
Email

…significant defects in Infobright that would be "show stoppers" for typical OLAP analysis queries. These tests were intended to approximate what would happen if you ported a MyISAM OLAP application to ICE. My testing suggests that with some basic testing, an application could be ported to ICE with a good chance of success. Of course, a good test environment is something that I think every operations team should insist on.

The second part of my analysis focused on testing a …

mysqlperformanceblog.com Read
  Source Favicon
Email

…de-normalization of the data is beneficial. The goal of a this approach is usually multi-dimensional ( OLAP) analysis as it is very hard to create a dimensional model from a highly normalized database schema. It is particularly difficult to build such a model that scales as the volume in the warehouse increases. For this reason OLAP analysis usually is performed on a star schema which partially denormalizes the data. A star schema about a particular subject matter, such as sales, is usually …

mysqlperformanceblog.com Read
  Source Favicon
By scottswigart of How Software is Built 5 months ago.
Email

…server-based business intelligence functions. JasperAnalysis is a full relational OLAP environment that works side-by-side with JasperServer and provides multi-dimensional capabilities through the ROLAP engine.

Lastly, we sponsor the JasperETL Project, which allows for very sophisticated data integration, enabling extract, transform, and load functions in creating a data warehouse.

The combination of all five projects we refer to as the Jaspersoft Business Intelligence Suite, …

howsoftwareisbuilt.com Read
  Source Favicon
Email

As far as BI is concerned, this series of posts focuses on OLAP analysis and in a lesser sense, on data warehousing. Data warehouses often provide the information upon which OLAP analysis is performed, but more on this in post #2.

OLAP? What is that?

OLAP is an acronym which stands for online analytical processing. OLAP analysis, which is really just another name for multidimensional analysis, consists of displaying summary aggregations of the data broken down into different groups. …

mysqlperformanceblog.com Read