Login to ask the library to add a book.
|
|
Active Filter Settings
No Active Filters
|
|
|
|
first record
| previous record
| next record
| last record
|
full | marc
|
Record 4 of 9
|
|
|
Total Requests 0 Unsatisfied Requests 0
|
You searched IISERK - Subject: Forests and forestry Congresses.
|
Request |
|
Call Number
|
658.4/0380285574
|
Author
|
Powell, Gavin.
|
Title
|
Oracle data warehouse tuning for 10g [electronic resource] / Gavin Powell.
|
Publication
|
Burlingham, MA : Elsevier Digital Press, c2005.
|
Material Info.
|
xxx, 468 p. : ill. ; 24 cm.
|
Summary Note
|
This book should satisfy those who want a different perspective than the official Oracle documentation. It will cover all important aspects of a data warehouse while giving the necessary examples to make the reading a lively experience. - Tim Donar, Author and Systems Architect 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.
|
Notes
|
Includes bibliographical references (p. 449-450) and index.
|
Notes
|
Introduction to Data Warehousing; Data Warehouse Data Modeling; Making Hardware and I/O Perform in a Data Warehouse; Data Warehouse Physical Architecture; Effective Data Warehouse Indexing; Constraints and Integrity in Data Warehouses; Using Partitioning and Tuning Parallel Processing; Materialized Views and Query Rewrites; Oracle Dimension Objects; Data Loading: Extraction and Transportation; Data Loading: Loading and Transformation; SQL Aggregation Using GROUP BY Clause Extensions.
|
Notes
|
Electronic reproduction. Amsterdam : Elsevier Science & Technology, 2007.
|
ISBN
|
9781555583354
|
ISBN
|
1555583350
|
Subject
|
Oracle (Computer file)
|
Subject
|
Data warehousing.
|
Subject
|
Electronic books.
|
Added Entry
|
ScienceDirect (Online service)
|
Date
|
Year, Month, Day:01405141
|
Link
|
An electronic book accessible through the World Wide Web; click for information ScienceDirect
|
|
|
|
|