 - Relational online analytical processing (ROLAP) is a form of online analytical processing (OLAP) that performs dynamic multidimensional analysis of data stored in a relational database rather than in a multidimensional database (which is usually considered the OLAP standard).
Data processing may take place within the database system, a mid-tier server, or the client. In a two-tiered architecture, the user submits a Structure Query Language (SQL) query to the database and receives back the requested data. In a three-tiered architecture, the user submits a request for multidimensional analysis and the ROLAP engine converts the request to SQL for submission to the database. Then the operation is performed in reverse: the engine converts the resulting data from SQL to a multidimensional format before it is returned to the client for viewing. As is typical of relational databases, some queries are created and stored in advance. If the desired information is available, then that query will be used, which saves time. Otherwise, the query is created on the fly from the user request. Microsoft Access's PivotTable is an example of a three-tiered architecture.
Since ROLAP uses a relational database, it requires more processing time and/or disk space to perform some of the tasks that multidimensional databases are designed for. However, ROLAP supports larger user groups and greater amounts of data and is often used when these capacities are crucial, such as in a large and complex department of an enterprise.
 |
Learn more about Oracle database design and architecture |
| Spotlight on Oracle performance tuning: Performance tuning is a key task for any Oracle DBA. This spotlight includes tips and advice to help you meet your tuning challenges and keep users happy. |
| Oracle database performance tuning guide: Learn the tricks of industry experts for identifying and eliminating perfomance problems in this guide. |
| RDBMS fundamentals: This learning guide can help you to understand the theory that serves as the foundation for Oracle's software and offer practical tips for designing and working with it. |
| Relational Database Management System (RDBMS) fundamentals tutorial: New to database administration or development? Here's a quick guide that can get you started by providing background on the relational model and practical advice for working with a relational database ... |
| Database design: Good performance and effective applications begin with efficient database design. Here are a few resources to help you figure out how to arrange and access your data. |
| Designing database systems: This excerpt from "Designing effective database systems" describes the processes involved in the analysis and design of database systems, starting with project life cycles. |
| LAST UPDATED: |
16 Feb 2009
|
 |
Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com
|
|
Show me everything on 
