Microsoft OLAPソリューション (SQL Server LIBRARY) [単行本]

"The authors merge their deep experience in OLAP to produce a roadmap to success with Microsoft SQL Server OLAP Services." -Bill Baker, Microsoft Corporation Microsoft(r) OLAP Solutions OLAP enables users to create, change, and access information from multi-dimensional data warehouses almost instantaneously. Microsoft has unleashed the power of OLAP in one of its most popular products, SQL Server 7, now distributed with its OLAP Services component. This guide to mastering Microsoft OLAP Services begins with a practical introduction to OLAP server concepts and architecture. It then progresses by logical, skill-building steps through a range of crucial topics in maintenance, database optimization, and advanced database design. The authors include in-depth case studies illustrating how to build OLAP applications, as well as instructions on how to construct working OLAP applications, including a healthcare benefits analysis application and a grocery store frequent shopper analysis application. Topics covered in detail include:
* The storage and operational architecture of Microsoft OLAP server
* Using the MDX language with Microsoft OLAP server
* Using Microsoft OLAP server to access and update data
* Specifying calculations
* Optimizing server performance
* Securing the server
On the CD-ROM you'll find:
* All the sample applications and databases described in the book
* Additional software for working with Microsoft OLAP server
Wiley Computer Publishing Timely. Practical. Reliable. Visit our Web site at www.wiley.com/compbooks/ --このテキストは、絶版本またはこのタイトルには設定されていない版型に関連付けられています。

本書では、データベースアドミニストレータ(DBA)とパワーアナリストが、Microsoft OLAP Servicesで効果的な分析アプリケーションシステムを作成する方法について解説。OLAP Servicesの機能と能力を現実的かつ完全な方法で示し、OLAP Servicesをユーザアプリケーションに適用する方法を理解するためのアプローチとガイドラインを提供し、ユーザが独自のシステムを開発するための具体的な例題を示す。

データベースアドミニストレータとパワーアナリストが、Microsoft OLAP Servicesで効果的な分析アプリケーションシステムを作成する方法について解説する。

Written for analysts who have at least some previous experience with data warehousing, Microsoft OLAP Solutions provides a working guide to analyzing legacy data with the new Microsoft online analytical processing (OLAP) Services. This book assumes you understand the fundamentals of what data warehousing is and how it works; if you do, this guide masterfully presents the strengths (and limitations) of OLAP technology.

Database (DB) analysts know that Microsoft OLAP is the proverbial new kid on the block when it comes to data warehousing. It offers good wizards and tools to simplify creation and maintenance of a data warehouse. While the authors of Microsoft OLAP Solutions dutifully explain some of the technical terminology related to OLAP (like cubes and dimensions) and design, many readers will likely seize on the chapters that examine actually using OLAP wizards and tools for building warehouses. Moreover, the reference to MDX (OLAP's data-analysis language) will be invaluable here.

This book presents some warehousing theory first, and then it focuses on specifics, including two excellent case studies (for analyzing databases for health care and a grocery store) at the end of the book. It also offers chapters on implementing changes and optimizing OLAP databases once they are up and running.

There's little doubt that with the weight of Microsoft behind it, OLAP will be a reasonable option for many corporate data warehouses. This book gives you all the information you need to apply your data warehouse knowledge to this new Microsoft platform. --Richard Dragan

Topics covered: Microsoft OLAP, datahouse warehousing design, dimensions and cubes, pure OLAP (MOLAP), relational OLAP (ROLAP), hybrid OLAP (HOLAP), Multidimensional Expressions (MDX), maintenance, and optimization.
--このテキストは、絶版本またはこのタイトルには設定されていない版型に関連付けられています。

The authors merge their deep experience in OLAP to produce a roadmap to success with Microsoft SQL Server OLAP Services.--Bill Baker, Microsoft Corporation. Microsoft OLAP Solutions OLAP enables users to create, change, and access information from multi-dimensional data warehouses almost instantaneously. Microsoft has unleashed the power of OLAP in one of its most popular products, SQL Server 7, now distributed with its OLAP Services component. This guide to mastering Microsoft OLAP Services begins with a practical introduction to OLAP server concepts and architecture. It then progresses by logical, skill-building steps through a range of crucial topics in maintenance, database optimization, and advanced database design. The authors include in-depth case studies illustrating how to build OLAP applications, as well as instructions on how to construct working OLAP applications, including a healthcare benefits analysis application and a grocery store frequent shopper analysis application. Topics covered in detail include: * The storage and operational architecture of Microsoft OLAP server. * Using the MDX language with Microsoft OLAP server. * Using Microsoft OLAP server to access and update data. * Specifying calculations. * Optimizing server performance. * Securing the server. On the CD-ROM you'll find: * All the sample applications and databases described in the book. * Additional software for working with Microsoft OLAP server. ERIK THOMSEN is Chief Scientist of the DSS Lab, where he works on the design and implementation of integrated DSS systems. He is a frequent speaker at conferences, writes the "Decision Support" column for Intelligent Enterprise, and performs independent research in the areas of multidimensional logic and visualization. His e-mail address is erikdsslab.com. GEORGE SPOFFORD is Chief Architect of the DSS Lab, where he is a consultant and software engineer specializing in design, implementation, and evaluation of OLAP-based DSS systems and related tools. His e-mail address is georgesdsslab.com. DICK CHASE is a Senior Consultant for Decision Support Technology (a part of the Condor Technology Solutions family) and has developed numerous decision support solutions for clients in such industries as retail, healthcare, insurance, and financial services. His e-mail address is dchasedstcorp.com. Wiley Computer Publishing Timely. Practical. Reliable. Visit our Web site at www.wiley.com/compbooks/
--このテキストは、絶版本またはこのタイトルには設定されていない版型に関連付けられています。

"The authors merge their deep experience in OLAP to produce a roadmap to success with Microsoft SQL Server OLAP Services."—Bill Baker, Microsoft Corporation.

Microsoft(r) OLAP Solutions

OLAP enables users to create, change, and access information from multi-dimensional data warehouses almost instantaneously. Microsoft has unleashed the power of OLAP in one of its most popular products, SQL Server 7, now distributed with its OLAP Services component. This guide to mastering Microsoft OLAP Services begins with a practical introduction to OLAP server concepts and architecture. It then progresses by logical, skill-building steps through a range of crucial topics in maintenance, database optimization, and advanced database design. The authors include in-depth case studies illustrating how to build OLAP applications, as well as instructions on how to construct working OLAP applications, including a healthcare benefits analysis application and a grocery store frequent shopper analysis application.

Topics covered in detail include: The storage and operational architecture of Microsoft OLAP server. Using the MDX language with Microsoft OLAP server. Using Microsoft OLAP server to access and update data. Specifying calculations. Optimizing server performance. Securing the server.

On the CD-ROM you'll find: All the sample applications and databases described in the book. Additional software for working with Microsoft OLAP server.

--このテキストは、絶版本またはこのタイトルには設定されていない版型に関連付けられています。

ERIK THOMSEN is Chief Scientist of the DSS Lab, where he works on the design and implementation of integrated DSS systems. He is a frequent speaker at conferences, writes the "Decision Support" column for Intelligent Enterprise, and performs independent research in the areas of multidimensional logic and visualization. His e-mail address is erik@dsslab.com. GEORGE SPOFFORD is Chief Architect of the DSS Lab, where he is a consultant and software engineer specializing in design, implementation, and evaluation of OLAP-based DSS systems and related tools. His e-mail address is georges@dsslab.com. DICK CHASE is a Senior Consultant for Decision Support Technology (a part of the Condor Technology Solutions family) and has developed numerous decision support solutions for clients in such industries as retail, healthcare, insurance, and financial services. His e-mail address is dchase@dstcorp.com. --このテキストは、絶版本またはこのタイトルには設定されていない版型に関連付けられています。