High Performance SQL Server Data Warehousing

Hassan A. Afyouni, Sam Afyouni - Collection IT In-Focus

290 pages, parution le 30/09/2006

Ajouter à une liste

Indisponible

Résumé

Managers are in constant struggle to make the right decision. One of the tools that managers depend on is timely and accurate reports provided by an efficient and well designed data warehouse application. This book is a comprehensive and concise guide to designing and building data warehouse applications using the newly introduced Microsoft product SQL Server 2005.

This book provides the reader techniques and tips on how to implement SQL Server 2005 efficiently and exploits its features to produce high performance and intelligent business applications. The book presents in details all phases of data warehouse development cycle showing the reader step by step examples for each phase. This book guides the reader on how to extract, transform and load data through the use of SQL and Transact-SQL and demonstrates all related data warehouse features of SQL Server 2005.

This book is the first of it's kind for managing very large databases in SQL Server 2005. This is the first book dedicated to managing large volumes of data using SQL Server 2005. Using real-world techniques from a practicing SQL Server DBA, this book show how to leverage SQL Server's data management features for very large databases.

This is a comprehensive book showing all phases of data warehouse design and implementation with SQL Server, from preliminary analysis to the working data warehouse. Showing never before published secrets, Sam Afyouni guides you through the use of TSQL for SQL Server Extract, transformation and load (ETL) processing.

The book also shows tools and techniques for SQL Server optimization for the data warehouse including clickstreams, data replication and OLAP services. This comprehensive handbook is a indispensable aid to building successful SQL Server database systems.

Microsoft SQL Server 2005 is a new version introduced recently to the database market. Microsoft is expecting this version to claim more market share than ever especially with the new features that have hooks to the Microsoft dot net and other development platforms. Similarly data warehouse applications are on the rise providing businesses with more intelligent reports to assist managers make better decisions. This book combines both technologies together in a context to provide a sure resource for any IT professional.

Sommaire

Data Warehouse Principles and Concepts
SQL Server 2005 for Data Warehousing
Data Warehouse Architecture and Design for SQL Server
Building the Data Warehouse in SQL Server
Data Warehouse Applications
Data Warehouse Intelligence in SQL Server
SQL Server 2005 Data Warehouse Features
Data Warehouse Case Study
Appendix A. On Line Application Processing Vendors

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Rampant
Auteur(s)	Hassan A. Afyouni, Sam Afyouni
Collection	IT In-Focus
Parution	30/09/2006
Nb. de pages	290
Format	17,5 x 24
Couverture	Broché
Intérieur	Noir et Blanc
EAN13	9780977671502
ISBN13	978-0-9776715-0-2