Data Warehousing with SQL Server 7 Technical Reference (Microsoft Technical Reference) - Softcover

Sturm, J.

Softcover

ISBN 10: 0735608598 ISBN 13: 9780735608597

Publisher: Microsoft Press,U.S., 2000

Synopsis

A book/CD-ROM showing how to take advantage of features of SQL Server 7.0 to design, build, and manage a data warehouse. Introduces basic concepts of data warehousing, then looks at online analytical processing services, data transformation services, advanced query processor and the MDX query langua

About this title

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. Though it's primarily a reference to Multidimensional Extensions (MDX) and ActiveX Data Objects Multidimensional (ADO MD), this book includes tons of explanatory and tutorial 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. You'll find this book valuable if you've worked with OLAP before in environments other than SQL Server 7, and also if you're totally new to data warehousing and plan to cut your teeth on Microsoft's flagship database system.

Author Jake Sturm notes that the line between database software developer and database administrator is blurring further all the time, and he does a good job of explaining this new role. He's careful to clarify procedures for building and managing cubes (and the reasons behind them), and he provides lots of information on how to develop software that interacts with complex data structures. MDX (including MDX expressions) get a tutorial treatment, and Sturm documents the ADO MD objects by fitting them into a Visual Basic application. You'll likely find that this book will refresh your existing SQL Server knowledge and then build upon it. --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

Synopsis

A book/CD-ROM showing how to take advantage of features of SQL Server 7.0 to design, build, and manage a data warehouse. Introduces basic concepts of data warehousing, then looks at online analytical processing services, data transformation services, advanced query processor and the MDX query language, and SQL Server cubes. The CD-ROM contains samp

Edition details

• Publisher: Microsoft Press,U.S.
• Publication date: 2000
• ISBN 10: 0735608598
• ISBN 13: 9780735608597
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 500