Microsoft OLAP Unleashed
Tim Peterson, Jim Pinkelman - Collection Unleashed
Résumé
- Design an enterprise data structure for an OLAP
system
- Transform a normalized data structure into a
multidimensional star schema
- Create OLAP cubes with the OLAP Manager or with the DSO
Object Model
- Integrate the MOLAR HOLAR and ROLAP cube storage
structures
- Program with MDX, the language used to query
cubes
- Build an OLAP client application
- Deploy an OLAP client on the Web
- Integrate Microsoft Excel 2000 with OLAP Services
- Create Visual Basic" client applications for OLAP
browsing
- Use the Microsoft Repository to store and retrieve
metadata
- Connect to Microsoft OLAP Server using ADO MID
Table of contents
- Introduction
- Part I: The New OLAP Paradigm-MS OLAP Services in
SQL
Server 7.0
- 1 Microsoft's Entry into the World of OLAP
- 2 How OLAP Is Used in the Real World
- 3 The Keys to a Successful OLAP System
- Part II: Preparing Data for OLAP
- 4 Enterprise Data Structure and Data Flow
- 5 The Star Schema
- 6 MS Data Transformation Services (DTS)
- 7 The Core Data Transformation Tasks
- 8 Using Other DTS Tasks
- 9 DTS Packages
- 10 Using the DTS Import and Export Wizards
- 11 Writing ActiveX Scripts
- 12 Programming with the DTS Object Model
- 13 Using the Repository in Data Transformations
- 14 Third-Party Data Transformation and Repository Tools
- Part III: Creating OLAP Cubes
- 15 Creating Cubes
- 16 Processing and Browsing Cubes
- 17 Partitioning Cubes and Administering OLAP Server
- Part IV: Programming the OLAP Server
- 18 Decision Support Objects
- 19 Developing an Add-In Program for OLAP Services
- 20 The PivotTable Service
- 21 Other OLE DB for OLAP Servers
L'auteur - Tim Peterson
is a data warehousing consultant, seminar leader, and database designer with his company SDG Computing, Inc. He is an MCSD, MCSE, MCT, and an associate member of the Data Warehousing Institute.
L'auteur - Jim Pinkelman
Ph.D., is Vice President of Technology and a consultant for Geppetto's Workshop, specializing in advanced query technology for relational and multidimensional databases. He teaches Management Sciences part-time at Loyola University in Chicago.
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Sams |
Auteur(s) | Tim Peterson, Jim Pinkelman |
Collection | Unleashed |
Parution | 10/10/1999 |
Nb. de pages | 946 |
Format | 18,8 x 23,2 |
Poids | 1650g |
EAN13 | 9780672316715 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse