Résumé
This book covers:
- Data warehousing and data mart principles
- Microsoft SQL Server data warehousing and OLAP architecture and features
- How to design and administer a data warehouse that will run in SQL Server 2000
- The new SQL Server 2000 tools that make data transformation from development databases to the data warehouse easy, and makes developing OLAP applications and administering the data warehouse an enjoyable task
- Using the new data mining features in SQL Server 2000
- SQL Server 7.0 and Microsoft OLAP Services users who want to know about what the new version of Microsoft Analysis Services has to offer
- SQL Server users who want to learn more about the data warehousing features and services in SQL Server version 2000, including data mining
- IT professionals and managers who are investigating using SQL Server's data warehousing capabilities on the NT or Windows 2000 platform for their decision support processes
- Developers who have basic knowledge of the SQL language and who deal with SQL Server as their backend database in their client-server enterprise applications and would like to learn how to develop applications that use OLAP databases using the tools provided as part of both Microsoft Data Access Components (MDAC) and Analysis Services
- SQL Server administrators who may find themselves
administering a SQL Server-based data warehouse or data
marts
Contents
Introduction
Chapter 1: Analysis Services in SQL Server 2000 – An Overview
Chapter 2: Microsoft Analysis Services Architecture
Chapter 3: Analysis Services Tools
Chapter 4: DataMarts
Chapter 5: The Transactional System
Chapter 6: Designing the Data Warehouse and OLAP Solution
Chapter 7: Introducing Data Transformation Services (DTS)
Chapter 8: Advanced DTS Topics
Chapter 9: Building OLAP Cubes with Analysis Manager
Chapter 10: Introduction to MDX
Chapter 11: Advanced MDX Topics
Chapter 12: Using the PivotTable Service
Chapter 13: OLAP Services Project Wizard in English Query
Chapter 14: Programming Analysis Services
Chapter 15: English Query and Analysis Services
Chapter 16: Data Mining – An Overview
Chapter 17: Data Mining: Tools and Techniques
Chapter 18: Web Analytics
Chapter 19: Securing Analysis Services Cubes
Chapter 20: Tuning for Performance
Chapter 21: Maintaining the Data Warehouse
L'auteur - Wrox Team
Michael Brundage, Patrick Dengler, Jeff gabriel, Andy Hoskinson, Michael Kay, Thomas Maxwell, Marcelo Ochoa, Johnny Papa, Mohan Vanmane, John Carnell, Bjarki Holm, Ann Horton, Kevin Mukhar, Daniel O'Connor, Mario Zucca, Michael Awai, Matthew Bortniker, Jaeda goodman, Thomas Kyte, Glenn E. Mitchell II, Gary Nicol, Frank Hubeny, Sean Dillon, Drew Erwin, Guy Ruth-Hammond, Burton Harvey, Simon Robinson, Julia Templeman, Karli Watson, Subrahmanyam Allamaraju, Ronald Ashri, Chad darby, Robert Flenner, Tracy Karsjens, Mark Kerzner, Alex Krotov, Alex Linde, Jim MacIntosh, James McGorven, Thor Mirchandani, Bryan Plaster, Don Reamy, Dr P G Sarang, Dave Writz, Aldo Calpini, Arthur Corliss, Simon Cozens, JJ Merelo-Guervos, Aalhad Saraf, Chris Nandor...
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Wrox Press |
Auteur(s) | Wrox Team |
Parution | 23/11/2001 |
Format | 18,5 x 23 |
Couverture | Broché |
Poids | 1123g |
Intérieur | Noir et Blanc |
EAN13 | 9781861005403 |
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