Building a Data Warehouse

With Examples in SQL Server

Vincent Rainardi

$214.95 $171.85

Hardback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

APress
07 January 2008

Software Engineering; Databases; Data warehousing

Building a Data Warehouse: With Examples in SQL Server describes how to build a data warehouse completely from scratch and shows practical examples on how to do it. Author Vincent Rainardi also describes some practical issues he has experienced that developers are likely to encounter in their first data warehousing project, along with solutions and advice. The relational database management system (RDBMS) used in the examples is SQL Server; the version will not be an issue as long as the user has SQL Server 2005 or later.

The book is organized as follows. In the beginning of this book (chapters 1 through 6), you learn how to build a data warehouse, for example, defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Then in chapters 7 through 10, you learn how to populate the data warehouse, for example, extracting from source systems, loading the data stores, maintaining data quality, and utilizing the metadata. After you populate the data warehouse, in chapters 11 through 15, you explore how to present data to users using reports and multidimensional databases and how to use the data in the data warehouse for business intelligence, customer relationship management, and other purposes. Chapters 16 and 17 wrap up the book: After you have built your data warehouse, before it can be released to production, you need to test it thoroughly. After your application is in production, you need to understand how to administer data warehouse operation.

By: Vincent Rainardi
Imprint: APress
Country of Publication: United States
Edition: 1st ed.
Dimensions: Height: 235mm, Width: 178mm, Spine: 38mm
Weight: 1.198kg
ISBN: 9781590599310
ISBN 10: 1590599314
Pages: 523
Publication Date: 07 January 2008
Audience: General/trade , ELT Advanced
Format: Hardback
Publisher's Status: Active

to Data Warehousing.- Data Warehouse Architecture.- Data Warehouse Development Methodology.- Functional and Nonfunctional Requirements.- Data Modeling.- Physical Database Design.- Data Extraction.- Populating the Data Warehouse.- Assuring Data Quality.- Metadata.- Building Reports.- Multidimensional Database.- Using Data Warehouse for Business Intelligence.- Using Data Warehouse for Customer Relationship Management.- Other Data Warehouse Usage.- Testing Your Data Warehouse.- Data Warehouse Administration.

A bio is not available for this author.