KDB - Study Note

1. What is KDB ?

http://en.wikipedia.org/wiki/K_(programming_language)

http://kx.com/software-download.php

Arthur Whitney.

K programming language Database.

In-memory Database.

Data is stored as contiguous items in Column lists. (Column-oriented database).

Faster Analysis.

Tiny Code (Cryptic, Small code, Lot of in-built functions).

Any data you play with is atom or a list

2. Data Types.

type function to identify whether it's a list or atom

Symbol is not a string, it's an atom, string is a list of characters., A Symbol is pre-fxied with a back-tick "`". e.g. `BP.L `IBM

Symbols are enumerated.

Cast: $ operator

Parttioned Tables / Splayed tables

3. In-memory Data

4. On-disk Data

5. IPC

6. Ticker

7. KDB DNA