 |
|
Oracle Tips by Burleson |
Oracle 10g XML Support for Analytic Workspace (AW)
In general, there are three basic OLAP
development interfaces. They are OLAP java interface, SQL and PL-SQL
interface, and OLAP DML interface. The 10g database release focuses
more on improving the SQL and PL-SQL interface by providing XML
access and expanding the power of SQL user.
Oracle Database 10g includes a new set of XML
metadata and associated PL/SQL packages for SQL users to define
simple multi-dimensional models and load data into data models.
These procedures also help to perform advanced OLAP calculations on
the loaded data.
The 10g release introduces the new package
dbms_aw_xml, which comes with a comprehensive set of functions. This
package allows you to create the Analytic Workspace (AW) and execute
the calculations specified in the XML metadata.
Get the complete Oracle10g story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details:
http://www.dba-oracle.com/service_oracle_backup.htm
|
