Analytics optimization with columnstore indexes in Microsoft SQL Server : optimizing OLAP workloads /

Meet the challenge of storing and accessing analytic data in SQL Server in a fast and performant manner. This book illustrates how columnstore indexes can provide an ideal solution for storing analytic data that leads to faster performing analytic queries and the ability to ask and answer business i...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Pollack, Edward, (Database administrator) (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: New York, NY : Apress, [2022]
Edición:[First edition].
Temas:
SQL server.
SQL server
Client/server computing.
Database management.
Architecture client-serveur (Informatique)
Bases de données > Gestion.
Client/server computing
Database management
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 1. Introduction to Analytic Data in a Transactional Database
  • 2. Transactional vs. Analytic Workloads
  • 3. What are Columnstore Indexes?
  • 4. Columnstore Index Architecture
  • 5. Columnstore Compression
  • 6. Columnstore Metadata
  • 7. Batch Execution
  • 8. Bulk Loading Data
  • 9. Delete and Update Operations
  • 10. Segment and Rowgroup Elimination
  • 11. Partitioning
  • 12. Non-Clustered Columnstore Indexes on Rowstore Tables
  • 13. Non-Clustered Rowstore Indexes on Columnstore Tables
  • 14. Columnstore Index Maintenance
  • 15. Columnstore Index Performance.

Ejemplares similares