Microsoft SQL server 2005 analysis services /

Microsoft SQL Server Analysis Services provides fast access to data by means of multidimensional data structures and the multidimensional query languag MDX. Analysis Services provides the capability to design, create, and manage multidimensional cubes based on data warehouse tables, and it serves as...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Melomed, Edward
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [Indianapolis, Ind.?] : Sams, 2006.
Temas:
SQL server.
SQL server
Client/server computing.
Relational databases.
Architecture client-serveur (Informatique)
Bases de données relationnelles.
COMPUTERS > Data Processing.
Client/server computing
Relational databases
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 1. What's new in analysis services 2005
  • 2. Multidimensional databases
  • 3. UDM : linking relational and multidimensional databases
  • 4. Client/server architecture and multidimensional databases : an overview
  • 5. Conceptual data model
  • 6. Dimensions in the conceptual model
  • 7. Cubes and multidimensional analysis
  • 8. Measures and multidimensional analysis
  • 9. Multidimensional models and business intelligence development studio
  • 10. MDX concepts
  • 11. Advanced MDX
  • 12. Cube-based MDX calculations
  • 13. Dimension-based MDX calculations
  • 14. Extending MDX with stored procedures
  • 15. Key performance indicators, actions, and the DRILLTHROUGH statement
  • 16. Writing data into analysis services
  • 17. Loading data from a relational database
  • 18. DSVs and object bindings
  • 19. Multidimensional models and relational database schemas
  • 20. physical data model
  • 21. Dimension and partition processing
  • 22. Using SQL server integration services to load data
  • 23. Aggregation design and usage-based optimization
  • 24. Proactive caching and real-time updates
  • 25. Building scalable analysis services applications
  • 26. Server architecture and command execution
  • 27. Memory management
  • 28. Architecture of query execution
  • calculating MDX expressions
  • 29. Architecture of query execution
  • retrieving data from storage
  • 30. Client/server architecture and data access
  • 31. Client components shipped with analysis services
  • 32. XML for analysis
  • 33. Adomd.Net
  • 34. Analysis management objects
  • 35. Security model for analysis services
  • 36. Object security model for analysis services
  • 37. Securing dimension data
  • 38. Securing cell values
  • 39. Using trace to monitor and audit analysis services
  • 40. Backup and restore operations
  • 41. Deployment strategies.

Ejemplares similares