You are here
Home > Sql

Download E-books Building a Data Warehouse: With Examples in SQL Server (Expert's Voice) PDF

By Vincent Rainardi

Here is the correct box advisor for information warehousing implementation. This ebook first teaches you the way to construct an information warehouse, together with defining the structure, knowing the method, collecting the necessities, designing the knowledge versions, and developing the databases. assurance then explains the best way to populate the information warehouse and explores tips on how to current info to clients utilizing stories and multidimensional databases and the way to exploit the information within the info warehouse for company intelligence, shopper dating administration, and different reasons. It additionally information checking out and the way to manage info warehouse operation.

Show description

Read Online or Download Building a Data Warehouse: With Examples in SQL Server (Expert's Voice) PDF

Similar Sql books

Administering SQL Server 7

Offering details for database directors and alertness builders, this e-book is a step by step consultant to studying program improvement and process administration with SQL, writing effective SQL code, and fine-tuning server functionality. The CD-ROM comprises an evaluate replica of SQL Server 7.

Oracle Database 11g SQL (Oracle Press)

Write strong SQL statements and PL/SQL programsLearn to entry Oracle databases via SQL statements and build PL/SQL courses with tips from Oracle professional, Jason expense. released by way of Oracle Press, Oracle Database 11g SQL explains tips to retrieve and regulate database info, use SQL Plus and SQL Developer, paintings with database items, write PL/SQL courses, and lots more and plenty extra.

A Guide to SQL Standard (4th Edition)

The former version of this e-book verified itself because the so much whole and comprehensible remedy of the SQL ordinary more often than not to be had. Many alterations have happened within the SQL criteria international due to the fact that version was once released, notwithstanding: an enormous new part, the Call-Level Interface (SQL/CLI), was once further in 1995.

NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence

The necessity to deal with more and more better information volumes is one issue riding the adoption of a brand new type of nonrelational “NoSQL” databases. Advocates of NoSQL databases declare they are often used to construct platforms which are extra performant, scale larger, and are more straightforward to software.   NoSQL Distilled is a concise yet thorough creation to this swiftly rising know-how.

Extra info for Building a Data Warehouse: With Examples in SQL Server (Expert's Voice)

Show sample text content

441 ■CHAPTER 15 different information Warehouse utilization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 467 ■CHAPTER sixteen trying out Your facts Warehouse . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 477 ■CHAPTER 17 info Warehouse management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 491 ■APPENDIX Normalization ideas . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 505 ■INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 509 v 9314fmfinal. qxd 11/15/07 1:37 PM web page vi 9314fmfinal. qxd 11/15/07 1:37 PM web page vii Contents in regards to the writer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv ■CHAPTER 1 advent to information Warehousing . . . . . . . . . . . . . . . . . . . . . . . . . . 1 what's a knowledge Warehouse?. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Retrieves facts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . four Consolidates facts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . five Periodically . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 Dimensional information shop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 Normalized facts shop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . eight historical past . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 question . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . eleven company Intelligence . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 different Analytical actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 up-to-date in Batches . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 different Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . sixteen info Warehousing at the present time . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 company Intelligence . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 shopper dating administration . . . . . . . . . . . . . . . . . . . . . . . . . . 18 information Mining. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 grasp info administration (MDM) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 purchaser information Integration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 destiny tendencies in information Warehousing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 Unstructured information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 seek . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 Service-Oriented structure (SOA) . . . . . . . . . . . . . . . . . . . . . . . . . . 26 Real-Time info Warehouse . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 precis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 vii 9314fmfinal. qxd viii 11/15/07 1:37 PM web page viii ■CONTENTS ■CHAPTER 2 information Warehouse structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 facts circulation structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 unmarried DDS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 NDS + DDS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 ODS + DDS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 Federated facts Warehouse . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 process structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . forty two Case examine . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . forty four precis. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . forty seven ■CHAPTER three facts Warehouse improvement technique . . . . . . . .

Rated 4.54 of 5 – based on 26 votes
Top