Wall Street & Technology is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Trading Technology

08:00 AM
Connect Directly
RSS
E-Mail
50%
50%

Kx Offers Nanosecond Timestamps in Updated Database

Ability to track trades in billionths of a second should be useful in high frequency trading.

Kx Systems, a provider of high-speed database and timeseries analysis, has announced today the release of version 2.6 of kdb+. The most significant feature of this release is the addition of nanosecond timestamps as built-in data types. (A nanosecond is a billionth of a second.)

The constant increase in data volumes and the resulting need for greater accuracy and granularity were the drivers behind Kx's decision to make the nanosecond timestamp available to its client base. There is a trend among exchanges to provide greater precision, but while some data providers support microsecond accuracy (i.e. six decimal places), end users can't always take advantage of this. In kdb+, nanosecond timestamps (9 decimal places) are built-in data types making the unique identification of the most recent events, such as trades, straightforward and enabling faster processing and simpler and more elegant code.

Kx chief strategist, Simon Garland, comments: "The feedback we've had from our users is that a millisecond timestamp was not accurate enough for state-of-the-art applications. Adding support for microseconds would have been a bit of a stop-gap measure as we would have had to revisit it in a couple of years' time thus inconveniencing our users." Garland adds: "Although a nanosecond timestamp goes beyond the needs of most people at the moment, we have decided to do this now, to give our clients a significant amount of flexibility. This is similar to our leading the market to 64-bits years ago, at a time when this was not seen as essential " now it has become the market standard."

There are a number of other enhancements in 2.6, including:

Network Compression " additional compression between kdb+ instances now speeds data transfer, especially in distributed and cloud environments.

Windowed database join " this feature is now more general than the join previously available in kdb+. For example, a user could retrieve all the quotes in a user-defined window around each individual trade in a group of thousands or even millions of trades. This allows for very sophisticated calculations and facilitates targeted back-testing on historical data. This feature takes advantage of the enormous speed of kdb+, a pre-requisite to being able to filter vast quantities of data.

Network bottleneck tracking and management " this feature gives the ability to monitor the activity of server clients. Servers running 2.6 could, for example, automatically check whether all clients are consuming data sufficiently quickly. If any are found to be falling behind they could be disconnected from the server to prevent other clients being affected, or they could be throttled until they catch up, by for example being sent just trades rather than both trades and quotes.

Memory use " based on user feedback this was enhanced in version 2.5 and has now been fine-tuned further, making even more efficient use of memory.

Named services " kdb+ now fully supports named services making kdb+ easier to deploy in complex, enterprise-wide environments; it also simplifies administration.

Garland says: "This version is faster than the previous version, and it takes advantage of the latest advances in Intel's chip technology."

Register for Wall Street & Technology Newsletters
Video
Exclusive: Inside the GETCO Execution Services Trading Floor
Exclusive: Inside the GETCO Execution Services Trading Floor
Advanced Trading takes you on an exclusive tour of the New York trading floor of GETCO Execution Services, the solutions arm of GETCO.