Главная
Study mode:
on
1
Introduction
2
Agenda
3
Storage Models
4
Page Layout
5
Row Storage
6
Decomposition Storage Models
7
Fixed Length All Sets
8
Column Store History
9
Pros Cons
10
Partition Attributes Across
11
Horizontal Partition
12
Memory Page Sizes
13
Huge Pages
14
Transparency Pages
15
TLB
16
Representation
17
Decimals
18
Floating Point Numbers
19
Fixed Point Precision Numbers
20
Fixed Point Project
21
Postgres
22
Extra Source Code
23
Add Function
24
Nulls
25
Storing Nulls
26
Display
27
MemSQL
28
Updates
29
Fraction Mirrors
30
Mirror Copy
31
Delta Store
32
Column Store
Description:
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only! Grab it Explore a comprehensive lecture on database storage models and data layout from Carnegie Mellon University's Advanced Database Systems course. Delve into various storage models, including row storage, decomposition storage, and column stores. Examine page layouts, memory page sizes, and data representation techniques. Learn about handling decimals, floating-point numbers, and fixed-point precision. Discover strategies for storing nulls, implementing updates, and managing delta stores in column-oriented databases. Gain insights from Professor Andy Pavlo's expertise in this in-depth exploration of database storage concepts.

Database Storage Models and Data Layout - Lecture 3

CMU Database Group
Add to list