Inside the VertiPaq Engine

Inside the VertiPaq Engine

PASS Data Community Summit via YouTube Direct link

Row storage layout

5 of 26

5 of 26

Row storage layout

Class Central Classrooms beta

YouTube playlists curated by Class Central.

Classroom Contents

Inside the VertiPaq Engine

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Intro
  2. 2 Marco Russo
  3. 3 What is VertiPaq?
  4. 4 Tabular query architecture
  5. 5 Row storage layout
  6. 6 Column storage layout
  7. 7 Querying a columnar database
  8. 8 Column vs row storage
  9. 9 Value encoding
  10. 10 Hash encoding
  11. 11 Run Length Encoding (RLE)
  12. 12 Compression of one column
  13. 13 VertiPaq compression
  14. 14 Reducing column size
  15. 15 Segmentation
  16. 16 Processing phases
  17. 17 Special Case of 3rd Segment
  18. 18 Calculated columns and tables
  19. 19 Query parallelization
  20. 20 Hierarchies
  21. 21 Memory Usage During Process
  22. 22 Data memory usage
  23. 23 VertiPaq Analyzer
  24. 24 Query memory usage
  25. 25 Early materialization
  26. 26 Late materialization

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.