Overview of Oracle Olap and Using SQL for Manipulate Multidimensional Data

Vatuiu Teodora () and Vasile Popeanga

Annals of the University of Petrosani, Economics, 2007, vol. 7, 355-362

Abstract: There are many PL/SQL packages that you can use directly in SQL*Plus or indirectly in Analytic Workspace Manager and OLAP Worksheet. Using SQL you can manipulate multidimensional data and extract that data into a relational table. In this article I discussed about some methods that you can use for manipulating and extracting multidimensional data. Oracle OLAP provides support for business intelligence applications without the need for replicating large volumes of data in specialized analytical databases. Oracle OLAP allows applications to support complex multidimensional calculations directly against the data warehouse. The result is a single database that is more manageable, more scalable and accessible to the largest number of applications.

Keywords: Oracle OLAP; SQL; analytic workspace; multidimensional data (search for similar items in EconPapers)
Date: 2007
References: View complete reference list from CitEc
Citations:

Downloads: (external link)
http://www.upet.ro/annals/pdf/Annals-2007.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:pet:annals:v:7:y:2006:p:355-362

Access Statistics for this article

More articles in Annals of the University of Petrosani, Economics from University of Petrosani, Romania
Bibliographic data for series maintained by Imola Driga ().