Der Datenzugriff bei den einfachsten Datenbanken erfolgt über die SQL Sprache. Für hoch entwickelte Datenbanken hat Microsoft die MDX Abfragesprache entwickelt. Sie wurde speziell für den Zugriff auf multidimensionale (oder OLAP) Data Warehouses konzipiert, wie sie von den meisten Fortune 500 Unternehmen benutzt werden, um riesige Datenmengen an Kundeninformationen zu speichern. Microsoft hat MDX in sein neuestes Datenbank Analysetool eingebaut - die Microsoft SQL Server Analysis Services 2000. Jeder Entwickler, der ein Data Warehouse mit diesem Tool aufbauen will, muss mit der MDX Sprache vertraut sein. Ebenso müssen auch Data Warehouse Nutzer MDX beherrschen, wenn sie auf Daten zugreifen wollen, z.B. ein Marketinganalyst, der die Ergebnisse der jüngsten Werbekampagne nach Altersgruppe, Einkommen, Ort, und anderen Kriterien ermitteln will. MDX erlaubt nicht nur komplexe Analysen, sondern verbessert dadurch auch die Effektivität von Marketingaktionen. "MDX Solutions" ist ein aktueller Leitfaden für die Praxis. Er behandelt alle wichtigen Aspekte der neuen Features von Microsoft Analysis Services, z.B. Data Mining und Analysis Services, die Arbeit mit dem Analysis Manager Interface, Skalierbarkeit und Offline-Analyse durch Clients.
A hands-on tutorial on building and using multidimensional data warehouses
The SQL query language is used to access data in most simple databases. But for multidimensional (or OLAP) data warehouses, Microsoft developed MDX. The MDX query language has become essential know-how for developers and users alike, whether for data warehouses or for budgeting and planning systems. This tutorial/reference guide shows developers and users how to use MDX to access and analyze data for decision support. Both the standard language and Microsoft's own extensive additions to MDX are explained. The authors provide practical examples of MDX in use, and explain both standard usage and more advanced techniques, such as optimization, cube design, and Pareto analysis. Finally, the appendices provide a handy reference guide that users can rely on.
Introduction.
Acknowledgments.
A First Introduction to MDX.
MDX in More Detail.
MDX in Use.
Advanced MDX Application Topics.
MDX Context and Execution.
The Many Ways to Calculate in Microsoft Analysis Services.
Extending MDX through External Functions.
Building Queries in MDX.
Advanced Operations and Commands - Drill-Through and Actions.
Changing the Cube and Dimension Environment through MDX.
Advanced Applications in Cube Design.
Client Programming Basics.
Working with Local Cubes.
Optimizing MDX.
Appendix A: MDX Function and Operator Reference.
Appendix B: Connection Parameters That Affect MDX.
Appendix C: Intrinsic Cell and Member Properties.
Appendix D: Format String Codes.
Index.
A hands-on tutorial on building and using multidimensional data warehouses
The SQL query language is used to access data in most simple databases. But for multidimensional (or OLAP) data warehouses, Microsoft developed MDX. The MDX query language has become essential know-how for developers and users alike, whether for data warehouses or for budgeting and planning systems. This tutorial/reference guide shows developers and users how to use MDX to access and analyze data for decision support. Both the standard language and Microsoft's own extensive additions to MDX are explained. The authors provide practical examples of MDX in use, and explain both standard usage and more advanced techniques, such as optimization, cube design, and Pareto analysis. Finally, the appendices provide a handy reference guide that users can rely on.
Introduction.
Acknowledgments.
A First Introduction to MDX.
MDX in More Detail.
MDX in Use.
Advanced MDX Application Topics.
MDX Context and Execution.
The Many Ways to Calculate in Microsoft Analysis Services.
Extending MDX through External Functions.
Building Queries in MDX.
Advanced Operations and Commands - Drill-Through and Actions.
Changing the Cube and Dimension Environment through MDX.
Advanced Applications in Cube Design.
Client Programming Basics.
Working with Local Cubes.
Optimizing MDX.
Appendix A: MDX Function and Operator Reference.
Appendix B: Connection Parameters That Affect MDX.
Appendix C: Intrinsic Cell and Member Properties.
Appendix D: Format String Codes.
Index.