 |
Further
Reading ...
|
|
physical topology of a network refers to the configuration of cables, computers
What is a Topology? The physical topology of a network refers to the configuration of cables, computers, and other peripherals. Physical topology should not be confused with logical topology which is the method used to pass information between...
Selling on eBay? Here's a Success Tip for Your Online Auctions
Are you planning to sell on eBay? Or have you tried in the past but not had much success with your online auctions? If so, here's a strategy that has worked very well for me.
In my experience, the auction lots where I created a useful...
How To Protect Your Website From Being Repossessed Or Stolen!
Did you know that you can lose your digital piece of real estate, even without an eviction notice? Imagine losing everything in a single heartbeat: your business, your brand equity, your traffic and your source of income ... Without your knowledge...
Adsense Tricks to Explode Your Profits
There are many adsense tips floating around the internet. Here are some adsense tricks that can drastically increase your CTR and your profits. Lots of people say to make your ads blend in. However, some people are having a lot of success by...
|
|
|
Introduction to Data Warehousing
|
 |
Written By:
Exforsys.com
|
|
|
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, - continued below ...
|
|
|
continued ...
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.
|
|
|
|
 |
|
|
| _Additional Resources ... |
|
Identity Theft: Count The Ways
I received an e-mail message from "Paypal" not to long ago. The e-mail stated that PayPal needed me to update and verify my security information for their database. I didn't. One of the sentences in the e-mail read: "Complete the necessary...
Easy to Execute!
Plug and play equipment or hardware solves the problem of driver installation, re-starting routines, and generally speaking, “hassle”, for those who are not technically proficient. If your computer supports “Plug and Play”, then, as the name...
Part Time Internet Marketing with A Full Time Approach
The deluge of people wanting to make money on the internet has exploded in the past few years. It's getting to the point where anyone that has a computer has heard of or has been tempted by such income. From affiliate marketing to playing around...
|
|
|
|
|
|
|
|
|
|
