Overview of Oracle Olap and Using SQL for Manipulate Multidimensional Data
AbstractThere 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.
Download InfoIf you experience problems downloading a file, check if you have the proper application to view it first. In case of further problems read the IDEAS help page. Note that these files are not on the IDEAS site. Please be patient as the files may be large.
Bibliographic InfoArticle provided by University of Petrosani, Romania in its journal Annals of University of Petroşani.
Volume (Year): 7 (2007)
Issue (Month): ()
Contact details of provider:
Web page: http://www.upet.ro/
Oracle OLAP; SQL; analytic workspace; multidimensional data;
You can help add them by filling out this form.
reading list or among the top items on IDEAS.Access and download statisticsgeneral information about how to correct material in RePEc.
For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (Imola Driga).
If references are entirely missing, you can add them using this form.