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.