Palo Alto (2 Dec 1999) – Kx Systems, a world-renowned pioneer in high performance vector-based technology, announced today that Lehman Brothers (NYSE:LEH) has selected Kdb as the underlying database for an enterprise decision support platform for fixed income portfolio and index analysis. The system, called POINT, contains over ten years of portfolio data on Lehman’s global family of bond indices. The underlying database, called Kdb, allows Lehman’s internal and external end users to perform sophisticated time series analyses on the portfolio data in real time.
Lehman chose Kdb over several leading database alternatives because of its speed and unique capabilities. Rich Wagner, Senior Vice President of Lehman Brother’s Fixed Income Research Group, said, “The most important database requirement for POINT was functionality. We wanted to be able to ask new types of complex time-based queries that we couldn’t with our existing relational database system. With Kdb, POINT can now handle comparisons of portfolios versus indices over time. This capability, in addition, to Kdb’s speed and simplicity, has made an enormous contribution to POINT’s success.”
Before selecting Kdb as the underlying database for POINT, Lehman rigorously tested its capabilities, requiring Kdb to meet, or exceed, exacting standards for a number of criteria:
- Processing Speed — Kdb’s special treatment of time, combined with the fact that the data is ordered, resulted in very fast processing speeds. This allowed POINT to perform historical analyses on portfolios of securities across indices and sectors in a fraction of the time it takes with other systems.
- Programming overhead — Programming time was dramatically reduced with Kdb because of its efficient syntax. Pages of old code were literally reduced to lines with Kdb
- .Scalability — Scaling up proved easy with Kdb. During the initial implementation period, the database grew from 12 to 33 GB without any loss in performance, largely because of Kdb’s unique efficiencies in table structure.
- Perform complex financial functions — These are native to Kdb’s query language, KSQL, so it easily performs all financial functions.
- Require minimal training — Kdb’s query language, KSQL is so similar to SQL92 that it requires very little training.
- Perform under peak conditions — Lehman found that Kdb’s speed made it better at handling high levels of demand for compute-intensive queries than other database products.
- Integrate easily — POINT’s architecture relies on a number of technology layers. Connections to Kdb were easy using either its interprocess communication facility or industry standard interfaces.
The system currently has hundreds of thousands of securities, with hundreds of fields of data for each security, and will continue to grow.