From Kx Wiki
Jump to: navigation, search


Kdb+ for Mortals

Chapter 1 - Persistent Tables

Jeffry A. Borror

Table of Contents

1.1 Loading Tables from Stored Data
1.1.0 Overview
1.1.1 Serialized Tables
1.1.2 Table from Newline-Delimited Text File
1.1.3 Table from Fixed Record Text File
1.1.4 Table from Delimited Record Text File
1.1.5 Links
1.2 Splayed Tables
1.2.0 Overview Splayed table Layout Limitations of Splaying
1.2.1 Splaying a Table
1.2.2 Working with Splayed Tables
1.2.3 Modifying a Mapped Table in Memory
1.2.4 Built-in Operations on the Persisted Splayed Table Appending Records Sorting and Applying Attributes
1.2.5 Manual Operations on Splayed Table Files Column Update Reordering Columns on Disk Sorting by a Column on Disk Adding a Column on Disk Deleting a Column on Disk
1.2.6 Splayed Tables with Symbols Splaying Enumerated Symbol Columns Merging Saved sym Domains
1.2.7 Splayed Tables with Compound Columns Compound Column Example String Columns Symbols vs. Strings
1.2.8 Links between Splayed Tables
1.2.9 Query Execution on Splayed Tables (Advanced)
1.3 Partitioned Tables
1.3.0 Overview
1.3.1 Partitions Partition Layout Partition Examples Partition Domain
1.3.2 Creating Partitions Partitioning Tables without Symbols Partitioning Tables with Symbols
1.3.3 Working with Partitioned Tables The select Template The Virtual Column i in Partitioned Tables
1.3.4 Query Execution on Partitioned Tables (Advanced) Overview Map-Reduce Map-Reduce in Queries Map-Reduce Aggregates vs. Brute Force
1.3.5 Modifying Partitioned Tables Appending Records within a Partition Modifying Data in a Partition
1.3.6 Multiple Partitioned Tables Daily trades and quotes Missing Table in Partition
1.3.7 Examples of Partition Domains Yearly Monthly int
1.3.8 Links and Partitioned Tables Linking to a Column in Memory Linking to a Column on Disk
1.4 Segments
1.4.0 Overview
1.4.1 Segmented Tables Contrasting Partitions and Segments Segment Layout Examples
1.4.2 Creating Segments Trades Segmented by Day of Week Trades Segmented by Symbol Range Trades Segmented by Exchange Trades Segmented across Partitions
1.4.3 Multiple Segmented Tables
1.4.4 Query Execution on Segmented Tables (Advanced) Preliminaries Execution over Segments Slaves and Cores
1.4.5 Examples
1.5 Using .Q Utilities for Splayed and Partitioned Tables
1.5.1 .Q.qp
1.5.2 .Q.en
1.5.3 .Q.ind
1.5.4 .Q.dpft
1.5.5 .Q.fs
1.5.6 .Q.chk
1.5.7 .Q.view
1.6 Kdb+ Database
1.6.1 Comparing kdb+ to an RDBMS
1.6.2 The Physical Layout of a kdb+ Database The sym File Other Serialized Files in the Root Scripts Splayed Tables Partitioned Tables Segmented Tables
1.6.3 Creating and Loading a Kdb+ Database What happens at startup? Serialized q Entities Splayed Tables Partitioned Tables Segmented Tables Scripts Putting It All Together
1.6.4 There's No Place Like QHOME The Environment Variables Where is q?

Next: 1.1 Loading Tables from Stored Data

Table of Contents

Personal tools