GeekArticles
Data Warehousing
Analysis ServicesOptimizing Cube Processing
Author: exforsys.com |
Published: 22nd Aug 2005 |
Visited: 300 times |
Add CommentFiled in: OLAPCubes are made up of a fact table and several dimensions. Optimizing cube processing therefore, involves optimizing dimensions also. Let us look at two scenarios. One in which the dimensions are not optimized and the cube is processed and another in which the dimensions are optimized and the cube is processed.
Read Article Sponsored Links
Related Articles
• Optimizing the Datacentre with Sun Server Virtualization In this webcast, you'll learn how to make server management simpler by reducing server sprawl by as much as 90%, boost resource utilization up to 80%, reduce your environmental impact, and provide an IT infrastructure that can aggressively grow while maintaining cost and security controls. You& ...
• XML Processing in PHP and Oracle Applications Processing XML in PHP/Oracle Applications
As mentioned, there are two alternatives when it comes to performing XML processing in your PHP/Oracle application. You can perform any required XML processing using either PHP's XML extensions (or PEAR XML packages) or Oracle's XML features.
Visi ...
• Transforming and Processing XML with XSLT Transforming and Processing XML with XSLT
In the preceding example, you transform XML into HTML directly in your script, wrapping the data extracted from the XML document into appropriate HTML tags. Alternatively, you might perform an XSL (Extensible Stylesheet Language) transformation to get the...
• Performing XML Processing inside the Database Performing XML Processing inside the Database
When building XML-enabled applications on top of Oracle, there are many advantages to performing the XML processing inside the database when compared to performing it on the client. The key advantages to perform XML processing inside the database are as. ...
• Moving All the XML Processing into the Database Moving All the XML Processing into the Database
In the preceding example, the database server performs only a part of the XML processing while the rest is still performed by the PHP engine. Specifically, the database server generates an employees XML document based on the records from the...
Visit ...