kdb+ The high-performance database that sets the standard for time-series analytics

Kx offers kdb+, a high-performance column-store database with a built-in expressive query and programming language, q. Used as a central repository to store time-series data within an enterprise, kdb+ supports real-time analysis of billions of records and fast access to terabytes of historical data. It also:

provides seamless scalability;
runs on industry standard server platforms;
is top-ranked in third-party benchmark testing;
has an extremely small footprint, which makes installation and maintenance fast and straightforward;
easily accommodates available APIs for connectivity to major external systems and modules;
requires fewer developers, contributing to lower total cost of ownership.
The result? A rich environment of powerful solutions.

kdb+ is a high-performance database made powerful by its expressive programming language q.

Optimized for time-series, kdb+ features:

SQL-like general purpose programming language, q.
One platform, no data transfer, use kdb+ for streaming, in-memory and historical data.
kdb+ is an analytic database engine that integrates seamlessly with WebSockets, Java, C/C++, C#, R, Python, Matlab and others through APIs.
Columnar design optimized for time-series analysis.
Scales to multi-petabyte systems.
Runs on commodity hardware.
Built-in Map/Reduce.
For even more on kdb+ and q, jump over to our Community page.

Welcome to the kdb+ 32bit Edition.

There is a Google discussion group for users of this edition of kdb+ at http://groups.google.com/group/personal-kdbplus. If you have questions, please post there.

kdb+ is Kx Systems flagship product: a unified platform for realtime and historical databases, event processing and general data oriented programming. This release is a full version of kdb+ but is limited to a 32-bit address space. To upgrade to our production 64-bit software please contact sales@kx.com for information.

To use this software you must have read and agreed to the license at http://kx.com/license2.php.

To install this software:

* When unzipping the install, take care to retain the embedded folder structure.

- On Windows, unzip to c:\q and then open a command prompt window, change directory to c:\q, and run c:\q\w32\q.

- On Linux, Solaris and MacOSX, unzip in ~/q, change directory to ~/q, and run ~/q/{l32|s32|v32|m32}/q as appropriate. The respective versions are:
        . l32 is Linux on x86
        . s32 is Solaris 10 or higher on Sparc
        . v32 is Solaris 10 or higher on x86
        . m32 is MacOSX 10.4 or higher on x86

e.g. on linux, run ~/q/l32/q

When running the trial on Linux 64-bit systems, you may need to
install the package ia32-libs. Depending on your distribution, this
can be installed with the command:

 sudo apt-get install ia32-libs

or

 yum install ia32-libs

When upgrading from a previous release, please note that the q binary file must match the q.k file, so if you choose to install to a directory different to the above defaults, please set the QHOME environment variable to point to the directory where you have installed the updated q.k file.

Note that command line history can be obtained on the unix versions through the use of the package "rlwrap" which can be found at http://freshmeat.net/projects/rlwrap. On linux, depending on your distribution, this can be installed with the command:

 sudo apt-get install rlwrap
or
 yum install rlwrap

For osx users, rlwrap can be installed through the use of http://wiki.github.com/mxcl/homebrew/Installation with the command:

 brew install rlwrap

To learn to use this software please visit our community site at http://code.kx.com.

Good starting points are:

Tutorial introductions to the q language and kdb+ database:
http://code.kx.com/wiki/Tutorials

A cookbook of common tasks:
http://code.kx.com/wiki/Cookbook

A reference on the built in functions:
http://code.kx.com/wiki/Reference

User contributed code has a source repository at code.kx. You can find an excel integration, python integration, and many useful snippets referenced from pages on the wiki. You can browse via the wiki or check out the repository using any Subversion client. For example:

svn co http://code.kx.com/svn

In particular, for Excel integration, see instructions at:

http://code.kx.com/wiki/Cookbook/IntegratingWithExcel

A book on kdb+ is available from Amazon. The title is "q for mortals" by Jeffry Borror.

We hope you enjoy this release and welcome to the kdb+ community!

        The Kx Systems team.