Features
- Cover Type: Hard Cover with 446 pages
- Published by: Microsoft Pr March 2000
- Written in: English
- ISBN 10 Number: 0735608598
- ISBN 13 Number: 978-0735608597
-
Book Dimensions:
9.8 x 8 x 1.5 inches
- Weighs: 2.5 pounds
Product Review
Microsoft SQL Server 7 has its own ways of implementing data warehouses and complex data-analysis tools, and
Data Warehousing with Microsoft SQL Server 7.0 Technical Reference helps you get a handle on them. Although it's primarily a reference to Multidimensional Extensions (MDX) and ActiveX Data Objects Multidimensional (ADO MD), this book includes tons of information about the
Microsoft way of collecting and managing large quantities of data, looking at complex relationships among the bits of information, and deriving significant business-related meaning from them. Readers will find this book valuable if they've worked with OLAP before in environments other than SQL Server 7, and also if they're totally new to data warehousing and plan to cut their teeth on
Microsoft's flagship database system.
The book notes that the line between database
software developer and database administrator is blurring further all the time, and it does a good job of explaining this new role. The text is careful to clarify procedures for building and managing cubes (and the reasons behind them), and provides lots of information on how to develop
software that interacts with complex data structures. MDX (including MDX expressions) get a tutorial treatment, and
Data Warehousing documents the ADO MD objects by fitting them into a Visual Basic application. This book will likely refresh and then build upon existing SQL Server knowledge.
--David Wall Topics covered: - Data warehousing under SQL Server 7
- Online Analytical Processing (OLAP) and other data-analysis mechanisms
- The OLAP Management Console
- The Cube Editor
- Multidimensional Extensions (MDX)
- ActiveX Data Objects Multidimensional (ADO MD)
- Data Transformation Services (DTS)
- General engineering matters
Product Description
Data warehouses help users look at information in new ways so they can see patterns and trends to gain insights and make better business decisions. DATA WAREHOUSING WITH
Microsoft SQL SERVER 7.0 TECHNICAL REFERENCE shows how to take advantage of all the power of SQL Server 7.0 to design, build, and manage data warehouses easily. The book introduces and explains data warehousing, and then discusses planning and design, online analytical processing (OLAP), star schemas, data transformation services (DTS), multidimensional query language (MDX), developing SQL server cubes, and more-with extensive sample databases and utilities. It's the best introduction to building enterprise data warehousing solutions with SQL Server 7.0.
Reader ReviewsThis is an excellent book. It has three detailed chapters on MDX, good descriptions on how to build data warehouses with SQL 7, a discussion on DTS, and includes an introductory chapter on OLAP for those not familiar with it. Great chapter on optimizing a SQL DW, too. My only negativeis that I found chapter 9 wasn't that useful, and read it after I read the other chapters. I also skipped the code sample in the appendix. Everything else in the book is good. I highly recommend the book.
Search for books at
