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 LEADER 01163nam 2200325 450 001 9910703702903321 005 20150618094858.0 035 $a(CKB)5470000002434697 035 $a(OCoLC)911182272 035 $a(EXLCZ)995470000002434697 100 $a20150618d2001 ua 0 101 0 $aeng 135 $aurbn||||||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aStrategy, money, and the New Look, 1953-1956 /$fRichard M. Leighton 210 1$aWashington, D.C. :$cHistorical Office, Office of the Secretary of Defense,$d2001. 215 $a1 online resource (xvi, 792 pages) $cillustrations 225 1 $aHistory of the Office of the Secretary of Defense ;$vv. 3 300 $aTitle from title screen (viewed June 18, 2015). 320 $aIncludes bibliographical references (pages 755-774) and index. 700 $aLeighton$b Richard M.$0265050 712 02$aUnited States.$bDepartment of Defense.$bHistorical Office, 801 0$bGPO 801 1$bGPO 906 $aBOOK 912 $a9910703702903321 996 $aStrategy, money, and the New Look, 1953-1956$93479124 997 $aUNINA