ADVDB23 03 - Database Storage Models & Data Layout
Модели хранения данных 00:00 Introduction 03:22 Agenda 03:41 Storage Models 07:55 Page Layout 11:50 Row Storage 13:41 Decomposition Storage Models 20:37 Fixed Length All Sets 22:47 Column Store History 25:37 Pros Cons 28:43 Partition Attributes Across 29:43 Horizontal Partition 34:05 Memory Page Sizes 36:21 Huge Pages 38:14 Transparency Pages 41:36 TLB 43:49 Representation 45:17 Decimals 46:10 Floating Point Numbers 47:29 Fixed Point Precision Numbers 49:30 Fixed Point Project 50:20 Postgres 50:53 Extra Source Code 51:23 Add Function 51:48 Nulls 52:07 Storing Nulls 53:32 Display 53:37 MemSQL 54:45 Updates 57:14 Fraction Mirrors 57:29 Mirror Copy 58:21 Delta Store 59:08 Column Store
Модели хранения данных 00:00 Introduction 03:22 Agenda 03:41 Storage Models 07:55 Page Layout 11:50 Row Storage 13:41 Decomposition Storage Models 20:37 Fixed Length All Sets 22:47 Column Store History 25:37 Pros Cons 28:43 Partition Attributes Across 29:43 Horizontal Partition 34:05 Memory Page Sizes 36:21 Huge Pages 38:14 Transparency Pages 41:36 TLB 43:49 Representation 45:17 Decimals 46:10 Floating Point Numbers 47:29 Fixed Point Precision Numbers 49:30 Fixed Point Project 50:20 Postgres 50:53 Extra Source Code 51:23 Add Function 51:48 Nulls 52:07 Storing Nulls 53:32 Display 53:37 MemSQL 54:45 Updates 57:14 Fraction Mirrors 57:29 Mirror Copy 58:21 Delta Store 59:08 Column Store