LEADER 02864nam 2200529 450 001 9910548185003321 005 20221006212814.0 010 $a1-4842-8048-2 024 7 $a10.1007/978-1-4842-8048-5 024 8 $a9781484280485 035 $a(MiAaPQ)EBC6897101 035 $a(Au-PeEL)EBL6897101 035 $a(CKB)21325618900041 035 $a(OCoLC)1301274165 035 $a(OCoLC-P)1301274165 035 $a(CaSebORM)9781484280485 035 $a(PPN)260832669 035 $a(EXLCZ)9921325618900041 100 $a20221006d2022 uy 0 101 0 $aeng 135 $aurcnu|||||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aAnalytics optimization with columnstore indexes in Microsoft SQL Server $eoptimizing OLAP workloads /$fEdward Pollack 205 $a[First edition]. 210 1$aNew York, New York :$cApress L. P.,$d[2022] 210 4$dİ2022 215 $a1 online resource (285 pages) $cillustrations 300 $aIncludes index. 311 08$aPrint version: Pollack, Edward Analytics Optimization with Columnstore Indexes in Microsoft SQL Server Berkeley, CA : Apress L. P.,c2022 9781484280478 320 $aIncludes index. 327 $a1. 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 330 $aMeet 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 intelligence questions with alacrity. The book provides a complete walk through of columnstore indexing that encompasses an introduction, best practices, hands-on demonstrations, explanations of common mistakes, and presents a detailed architecture that is suitable for professionals of all skill levels. 606 $aClient/server computing 606 $aDatabase management 615 0$aClient/server computing. 615 0$aDatabase management. 676 $a005.7585 700 $aPollack$b Edward$c(Database administrator),$01061083 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910548185003321 996 $aAnalytics Optimization with Columnstore Indexes in Microsoft SQL Server$92787493 997 $aUNINA