Advanced

Working Down the Column: The Kdb+ Community

Posted by deadline on · Post a comment
clustermonkey.net; By Douglas Eadline
Mail this story
Print this story

Time series analysis (financial data, web logs, etc.) works best with row oriented databases. A traditional database consists of tables with data ordered by row (row-oriented). When data are organized by rows, data look-up can be done quickly by using a key-value to identify the row and then its associated data. When data are organized by column (column-oriented), operations on columns are extremely fast because there is no key-value look-up. This approach is used for time-series analysis. If you are a kdb+ user or are intrigued with time-series analysis, there are resources waiting for you. First, there is a free version of kdb+ (32 bit) available for download. The free version has all the functionality of the 64-bit version and can be used for commercial, non-commercial, or educational purposes.

A traditional database consists of tables with data ordered by row (row-oriented). When data are organized by rows, data look-up can be done quickly by using a key-value to identify the row and then its associated data. When data are organized by column (column-oriented), operations on columns are extremely fast because there is no key-value look-up. This approach is used for time-series analysis. If you are a kdb+ user or are intrigued with time-series analysis, there are resources waiting for you. First, there is a free version of kdb+ (32 bit) available for download. The free version has all the functionality of the 64-bit version and can be used for commercial, non-commercial, or educational purposes.

Full Story

  Nav
» Read more about: Story Type: Editorial, Tutorial; Groups: Developer

» Get new stories by e-mail: nightly or as they are published

« Return to the newswire homepage

  Related stories
» More like this

Comments

No comments yet. Be the first.

Post a comment

A free account is needed to post. Write your comment here first: your text is kept in this browser while you sign up or log in, and is waiting for you when you come back.

Your message:
|||||
10
Markdown: **bold**, *italic*, [text](https://link), - lists, > quotes, $x^2$ for math. Formatting help

Sign up and post (it is free)  or  Log in and post