Continued from page 1
Data from different data sources is stored in a relational database for end use analysis Data is organized in summarized, aggregated, subject oriented, non volatile patterns.
Data is a data warehouse is consolidated, flexible collection of data Supports analysis of data but does not support online analysis of data.
Online Analytical Processing
A tool to evaluate and analyze
data in
data warehouse using analytical queries.
A tool which helps organize data in
data warehouse using multidimensional models of data aggregation and summarization.
Supports
data analyst in real time and enables online analysis of data with speed and flexibility.
Ralph Kimball
co-founder of
data warehousing concept has defined
data warehouse as a “"a copy of transaction data specifically structured for query and analysis”.
Both definitions highlight specific features of
data warehouse. The former definition focuses on
structure and organization of
data and
latter focuses upon
usage of
data. However, a listing of
features of a data warehouse would necessarily include
aspects highlighted in both these definitions.
For more visualization of this article along with
screen shots and more visit http://www.exforsys.com/content/category/17/253/332/

Exforsys is a community of developers specializing in C, C++, C#, Java, J2EE, .NET, PeopleSoft, SAP, Siebel, Oracle Apps., Data warehousing, Oracle/SQL Server/DB2 and Testing. Please visit http://www.exforsys.com for more tutorials and for Interview questions http://www.geekinterview.com is an open database.