Oracle data warehouse tuning for 10g
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 W...
Κύριος συγγραφέας: | Powell, Gavin. |
---|---|
Μορφή: | Ηλεκτρονική πηγή |
Γλώσσα: | English |
Στοιχεία έκδοσης: |
Burlingham, MA :
Elsevier Digital Press,
c2005.
|
Θέματα: | |
Διαθέσιμο Online: |
http://www.sciencedirect.com/science/book/9781555583354 |
Ετικέτες: |
Προσθήκη ετικέτας
Δεν υπάρχουν, Καταχωρήστε ετικέτα πρώτοι!
|
LEADER | 02907nam a2200265 a 4500 | ||
---|---|---|---|
001 | 1/45132 | ||
008 | 140728s2005 us 001 0 eng | ||
020 | |a 9781555583354 | ||
020 | |a 1555583350 | ||
035 | |l 48090 | ||
040 | |a OPELS |b eng |c OPELS |d OPELS |d OCLCQ |d OCLCF |d GR-PeUP | ||
100 | 1 | |a Powell, Gavin. | |
245 | 1 | 0 | |a Oracle data warehouse tuning for 10g |h [electronic resource] / |c Gavin Powell. |
260 | |a Burlingham, MA : |b Elsevier Digital Press, |c c2005. | ||
300 | |a 1 online resource (xxx, 468 p.) : |b ill. | ||
520 | |a 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. | ||
505 | 0 | |a 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. | |
504 | |a Includes bibliographical references (p. 449-450) and index. | ||
650 | 4 | |a Data warehousing. | |
630 | 0 | 0 | |a Oracle (Computer file) |
655 | 4 | |a Electronic books. | |
852 | |a INST |b UNIPILB |c EBOOKS |e 20140729 |p 00b48090 |q 00b48090 |t ONLINE |y 0 | ||
856 | 4 | 0 | |3 ScienceDirect |u http://www.sciencedirect.com/science/book/9781555583354 |
856 | 4 | |d /webopac/covers/03/48090_9781555583354.jpg | |
856 | 4 | |d /webopac/covers/03/48090_1555583350.jpg |