{"product_id":"oracle-data-warehouse-tuning-for-gavin-powell-9781555583354","title":"Oracle Data Warehouse Tuning for 10g","description":"\"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.\"\u003cbr\u003e - Tim Donar, Author and Systems Architect \u003cbr\u003efor Enterprise Data Warehouses \u003cp\u003e\u003c\/p\u003eTuning a data warehouse database focuses on large \u003cbr\u003etransactions, mostly requiring what is known as throughput. Throughput is the passing of large amounts of information through a server, network \u003cbr\u003eand 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. \u003cp\u003e\u003c\/p\u003eA 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.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Gavin Powell\u003cbr\u003e\u003cb\u003eISBN-10:\u003c\/b\u003e 1555583350\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9781555583354\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Digital Press\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 09\/01\/2005\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 500\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 2.26lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.20h x 7.48w x 1.23d","brand":"Gavin Powell","offers":[{"title":"Paperback","offer_id":48088556503295,"sku":"9781555583354","price":101.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0662\/2982\/9887\/files\/img_59e9b1e9-9a4f-421a-b2d3-0f6296d4674d.jpg?v=1769105428","url":"https:\/\/www.whiterainbookhouse.com\/products\/oracle-data-warehouse-tuning-for-gavin-powell-9781555583354","provider":"WR Book House","version":"1.0","type":"link"}