"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/
"Sinopsis" puede pertenecer a otra edición de este libro.
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.About the Author:
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 email@example.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 firstname.lastname@example.org. 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 email@example.com.
"Sobre este título" puede pertenecer a otra edición de este libro.
Descripción Wiley, 1999. Paperback. Estado de conservación: New. book. Nº de ref. de la librería 471332585
Descripción Wiley, 1999. Paperback. Estado de conservación: New. book. Nº de ref. de la librería 0471332585
Descripción Wiley, 1999. Paperback. Estado de conservación: New. Nº de ref. de la librería DADAX0471332585
Descripción Estado de conservación: Brand New. Book Condition: Brand New. Nº de ref. de la librería 97804713325891.0