Oracle Data Warehouse Tuning For 10g
| Author/creator | Powell, Gavin Author |
| Format | Electronic |
| Publication Info | Digital Press [Imprint] San Diego : Elsevier Science & Technology Books |
| Description | 504 p. ill 09.250 x 07.500 in. |
| Supplemental Content | Full text available from eBook - Computer Science 1995 - 2006 |
| Subjects |
| Summary | Annotation "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."<br />- Tim Donar, Author and Systems Architect<br />for Enterprise Data Warehouses<br /><br />Tuning a data warehouse database focuses on large<br />transactions, mostly requiring what is known as throughput. Throughput is the passing of large amounts of information through a server, network<br />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.<br /><br />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.<br /><br />* Takes users beyond basics to critical issues in running most efficient data warehouse applications<br />* Illustrates how to keep data going in and out in the most productive way possible<br />* Focus is placed on Data Warehouse performance tuning |
| Access restriction | Available only to authorized users. |
| Technical details | Mode of access: World Wide Web |
| Genre/form | Electronic books. |
| ISBN | 9781555583354 |
| ISBN | 1555583350 (Perfect) Active Record |
| Standard identifier# | 9781555583354 |
| Stock number | 00991439 |