|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9911114308503321 |
|
|
Autore |
Pollack Edward |
|
|
Titolo |
Analytics Optimization with Columnstore Indexes in Microsoft SQL Server : Cost-Effective, Scalable Analytics for Real-World SQL Server Workloads |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Berkeley, CA : , : Apress L. P., , 2026 |
|
©2026 |
|
|
|
|
|
|
|
|
|
ISBN |
|
|
|
|
|
|
Edizione |
[2nd ed.] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (249 pages) |
|
|
|
|
|
|
Collana |
|
Professional and Applied Computing Series |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
Client/server computing |
Database management |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
|
|
|
|
|
Nota di contenuto |
|
Analytics Optimization with Columnstore Indexes in Microsoft SQL Server -- Introduction -- Acknowledgments -- Table of Contents -- About the Author -- About the Technical Reviewer -- 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 -- 16. Ordered Columnstore Indexes -- Index. |
|
|
|
|
|
|
|
|
Sommario/riassunto |
|
Meet the challenge of storing and accessing analytic data in SQL Server with speed and efficiency--now with expanded coverage of SQL Server 2025 and Azure SQL Database features. This updated second edition also explores how columnstore indexes compare to other modern analytic storage options, helping you make informed architectural decisions. |
|
|
|
|
|
|
|