OLAP
Online Analytical Processing, or OLAP (IPA: /'o?læp/), is an approach to quickly provide answers to analytical queries that are multi-dimensional in nature.
Article

Oracle Database 10g OLAP Performance Tips & Techniques

The OLAP Option to Oracle 10g gives you the ability to store multidimensional cubes of data in your Oracle database, and perform OLAP queries on them using OLAP DML, regular SQL or query tools such...
Article

Mastering OLAP Reporting: Meet Business Needs with Matrix Dynamics, Part 2

Generate duplicate data regions for each of multiple business territories, based upon selections chosen by the consumer at run time. In this article, Architect Bill Pearson leads hands-on practice in...
Article

A Look Into The Future Of Microsoft And Oracle OLAP

Oracle has recently released version 10g of its database, which now comes with an embedded multidimensional OLAP server known as the OLAP Option. Microsoft, which so famously took the OLAP market by...
Article

An Oracle DBA’s Guide to the OLAP Option

This article explains the background of the OLAP Option, shows how it extends the analytic capabilities of Oracle data warehouses, and gives you the first steps in harnessing the power of the OLAP...
Article

Drilling from OLAP to Relational using Discoverer 10.1.2

This article explais how one can drill from a Discoverer for OLAP worksheet to a Discoverer Plus Relational worksheet using Discoverer 10.1.2.
Article

Building OLAP Cubes Using OWB "Paris"

Oracle Warehouse Builder 10gR2 "Paris", the forthcoming release of Oracle's ETL tool, comes with a host of new features to support the building and maintenance of relational and multdimensional cubes...
Article

Information Retrieval Optimization in OLTP and OLAP applications

Application tuning is an important factor in Information Retrieval from OLTP and OLAP systems, various simple techniques of application tuning are available and by proper utilization of these...
Article

How To Implement Long Running Tasks in Windows Forms

Have you ever needed to perform long running operations in a windows form? Perhaps its some complicated mathematical function, maybe is some long OLAP processing. In this tutorial I'm going to cover...
Article

OLAP and Data Warehousing (The Problem and Solution)

This article article takes an in-depth look at on-line analytical processing (OLAP) server technology and online transaction processing systems (OLTP).
 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.