«Back to Home

Oracle Jump Start
Topics

Data Warehousing In Oracle

Data Warehousing
 
   • A Data Warehouse is a subject Oriented, Integrated, Non Volatile, Time variant collection of the data.
   • In a Network Computing Environment, data warehouse sizes are increased to tetra byte.
   • Network Computing Environment has made people to have daily data in a data warehouse.
 
A data warehouse is a subject oriented, integrated, nonvolatile, time variant collection of data structured and stored from the management point of view.

1
 
                                                        Fig: Data Warehouse Architecture
 
Data warehouse sizes between 10 or 100 gigabyte of data. In network computing era, the increasing amounts of data that companies are storing will push the data warehouse size into tetra byte and virtually everyone can be connected to the net. In the past, analysts were practically the only ones, using the data warehouse, but network computing environments are now changing the user profile. Today, many employees need to have daily access to the critical data in a data warehouse.
 
Types of Data Warehouse
 
There are three types of Data Warehousing.
 
   • Information processing
   • Analytical processing
   • Data mining
 
Data Warehouse Application
 
Data Warehouses are widely used in the following fields-
 
   • Financial Services
   • Banking Services
   • Consumer Goods
   • Retail Sector
   • Controlled Manufacturing

Data Warehouse Features
 
   • Subject Oriented
   • Integrated
   • Time Variant
   • Non-Volatile

Summary
 
Thus, we learnt that the data warehouse is subject oriented, integrated, nonvolatile, time variant collection of data. We learnt about its types of data warehouse, Applications and features.