Real Time Analysis (ROLAP)

ROLAP is a form of online analytical processing (OLAP) that performs dynamic multidimensional analysis of data stored in a relational database. The base data and the dimension tables are stored as relational tables. The ROLAP tool provides a comprehensive data analysis and visual reporting solution for business users. Users can break down data in any manner they require.

 Features
  • Quickly Display Table Data into Fully Customizable Visual Reports. Format reports by Year, Quarter and Month
  • Hierarchical automatic arrangement of values
  • Row level and column level totals
  • Sort Data and Display Top Rows
  • Filter the data against which calculations are based
  • ROLAP Grid fields expose a Group Interval property which allows you to merge field values into groups
  • Paging in table data
  • User can select different themes to change the appearance, look and feel of the ROLAP Grid
  • User can view the graph for appropriate row expanded data
  • Easy access to the tools functionality using the Toolbar
  • Personalized folders and reports
  • The ROLAP grid's contents can be exported to all popular formats, including: Word, Excel and Pdf
 Benefits
  • ROLAP DBMS (or RDBMS) are supported by relational technology. RDBMS support numeric, textual, spatial, audio, graphic, and video data, general-purpose DSS analysis, freely structured data, numerous indexes, and star schemas
  • ROLAP servers can have both disciplined and ad hoc usage and can contain both detailed and summarized data
  • ROLAP supports large databases while enabling good performance, platform portability, exploitation of hardware advances such as parallel processing, robust security, multi-user concurrent access (including read-write with locking), recognized standards, and openness to multiple vendor’s tools
  • ROLAP tools take advantage of parallel RDBMSs for those parts of the application processed using SQL (SQL not being a multidimensional access or processing language)
  • SQL does not, by itself, support multidimensional manipulation of calculations. The ROLAP tool does these calculations using a server side engine
  • Data warehouses are predominantly built using RDBMSs. If you have a warehouse built on a relational database and you want to perform OLAP analysis against it, ROLAP is a natural fit
  • Leverages all the inherent functionalities within the RDBMS database