E-books in Russian and English



<<< >>>

Welcome
(Ashburn, Virginia, United States)

 


Enter · Register · Search

 
 
   
 
 
 
« Декабрь 2008 »
Пн Вт Ср Чт Пт Сб Вс
1234567
891011121314
15161718192021
22232425262728
293031 
 
One Week Top10:
 2  3   4

date: 27 декабря 2008 / author: izograv / категория: Oracle / views: 3231 / comments: 0

Oracle Data Warehouse Tuning for 10g by Gavin JT Powell



for Enterprise Data Warehouses

Tuning a data warehouse database focuses on large
transactions, mostly requiring what is known as throughput. Throughput is the passing of large amounts of information through a server, network
and Internet environment, backwards and forwards, constantly! The ultimate objective of a data warehouse is the production of meaningful and useful reporting, from historical and archived data. The trick is to make the reports print within an acceptable time frame.

A data model contains tables and relationships between tables. Tuning a data model involves Normalization and Denormalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.

* Takes users beyond basics to critical issues in running most efficient data warehouse applications
* Illustrates how to keep data going in and out in the most productive way possible
* Focus is placed on Data Warehouse performance tuning




 

Comments: 0

 
 
Year Top:
2011
2010
2009
2008
2007
2006
 
  

 


 

Design/Web/Support/Anti-Leech by izograv @ yandex.ru
Optimized for Firefox | Anti-Leech tested on IE, Firefox, Reget