Paper on the Strengths and Weaknesses of Oracle 9i
This is a paper evaluating the strengths and weaknesses of Oracle 9i. First I would like to discuss the evolution which has taken place within the Oracle applications in relation to OLAP. OLAP first became a feature of the Oracle database with the introduction of Oracle 8i enterprise edition. Prior to Oracle 8i OLAP was accomplished by a separate application known as OLAP server. Oracle accomplished this task when they added relational OLAP features to their database. Oracle 8i enterprise edition used a feature called dimensions, which were additional layers of metadata to put over table or set of tables. You could use this to define hierarchical relationships between columns. In this way a single dimension could contain multiple hierarchies and the database could contain multiple dimensions, which are unique within each schema. (http://www.rittman.net/archives/001113.htm)
With the introduction of Oracle 9i an option......
Join Now or Login to view the rest of this paper.
Approximate Word Count: 819
Approximate Pages: 4 (260 words per double-spaced page) |