The Oracle Guru Answer #1

Are you an Oracle guru? Take our quiz and see how much you really know about Oracle.

Were you correct? This week's answer is:
c. ROLAP

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.

Click for full definition.

For More Information

  • Best Web Links: OLAP

  • Article: Microsoft/Oracle tout OLAP successes

  • Tip: Successful data mining requires work

  • White paper: Breakthrough performance for star schemas

  • Do you have an idea for a quiz question topic? Let us know!

  • This was first published in July 2003

    Dig deeper on Oracle DBA jobs, training and certification

    Pro+

    Features

    Enjoy the benefits of Pro+ membership, learn more and join.

    0 comments

    Oldest 

    Forgot Password?

    No problem! Submit your e-mail address below. We'll send you an email containing your password.

    Your password has been sent to:

    -ADS BY GOOGLE

    SearchDataManagement

    SearchBusinessAnalytics

    SearchSAP

    SearchSQLServer

    TheServerSide

    SearchDataCenter

    SearchContentManagement

    SearchFinancialApplications

    Close