Technology News
Home | Tech Store | Amazon Store | Game Store | Webmaster Tools | Safe Kids Links | Promotional Items
Site Sponser
Recommended Products
Related Links

Christian InTech Articles - Computers

 

 

Informative Articles

Another Kind of Computer Game
The term computer game might have one more meaning than you realize. There are also games in the physical world, played with pens and paper and imagination which involve the characters doing things in the virtual world of the Internet.  ...
Build Your Own Computer : What to Look for in a Case
Build Your Own Computer : What to Look for in a Case By Stephen Bucaro Why would you want to build your own computer? Not to save money. With a decent manufactured computer costing less than $400.00, it will cost you more to buy the parts to build...
Buying A Computer For Novices
Advice on buying computers Computers come in many different shapes, sizes and formats and to the newcomer this must be very confusing. Here we will try to explain some of the jargon. What is the difference between the second hand PC and...
Computer Geeks and Garden Gnomes
First and foremost before I begin my ranting it is worth mentioning that there are many very helpful and considerate people out there in the cyber wilderness who devote much of their time to providing open source and free scripts of all variations...
Get The Most Out Of Your Digital Camera Today!
Point and click. The new life of digital cameras gives us all the opportunity to capture images as we go. Whether you simply hit the shutter button to take pictures of your friends and family or if you want to have your camera with you at all...
 
Introduction to Data Warehousing

This tutorial starts with the introduction to Data Warehousing, Defination of OLAP, difference between Data warehouse and the OLTP Database, Objectives of data warehousing and data flow.

Computerization of business processes; technological advances in transmission and storage of data; and powerful database management tools have opened up new possibilities of data manipulation and analysis. Business managers are eager to explore the repositories of current and historical data to identify trends and patterns in the wrap and hoof of business. They hope to mine data and use them for taking intelligent business decisions. In this context, industries are increasingly focusing on data warehousing, Online Analytical Processing (OLAP), and other related technologies.

What's the Difference

Data warehouse and OLAP are terms which are often used interchangeably. Actually they refer to two different components of a decision support system. While data in a data warehouse is composed of the historical data of the organization stored for end user analysis, OLAP is a technology that enables a data warehouse to be used effectively for online analysis using complex analytical queries. The differences between OLAP and data warehouse is tabulated below for ease of understanding:

Data Warehouse

Data from different data sources is stored in a relational database for end use analysis

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 the data in the data warehouse using analytical queries.

A tool which helps organize data in the data warehouse using multidimensional models of data aggregation and summarization.

Supports the data analyst in real time and enables online analysis of data with speed and flexibility.

Ralph Kimball the co-founder of the data warehousing concept has defined the data warehouse as a "a copy of transaction data specifically structured for query and analysis.

Both definitions highlight specific features of the data warehouse. The former definition focuses on the structure and organization of the data and the latter focuses upon the usage of the data. However, a listing of the features of a data warehouse would necessarily include the aspects highlighted in both these definitions.

For more visualization of this article along with the screen shots and more visit http://www.exforsys.com/content/category/17/253/332/

About the Author

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.