kdb+ Data Warehouse Implementation
The equities division of a London based Tier 1 Investment Bank engaged Version 1 to implement a kdb+ data warehouse.
Version 1’s team of kdb+ experts worked closely with the customer to define the requirements, and to collaborate on key architectural and design decisions to ensure the platform met their exacting needs.
A global investment bank was planning an internal initiative to centralise the capture and storage of all equity market and reference data into a single warehouse. Their main business objectives were to reduce duplication, hardware and support overheads, and system complexity.
It was essential that the solution be globally accessible in a timely manner by both programmatic applications and individual groups for research and be available 24 hours a day. To accommodate future growth in data volumes and in the user community, the platform had to be scalable.
The platform was built in kdb+ with a web-based UI that users could interact with and was designed with high-availability and redundancy from inception.
Another important feature of the system was the ability to classify critical users and applications, and give priority to these groups in the case of reduced capability (due to potential hardware failure) or increased volatility and data volumes (Due to market conditions).
Hardware specification was designed to provide sufficient headroom to capture ever increasing volumes of data as well as offer scalability options for future growth.
As a result of this engagement, the following benefits were delivered:
- New data warehouse with a single point of access for all equity market and reference data
- Ability to handle any individual data-node failure, machine or site outage with no loss of data availability to the end users
- Robust and easily maintainable solution that can scale horizontally for future growth
kdb+ Database Services
Combining years of kdb+ experience with expertise in operational integration, streaming data ingestion, UI technologies/platforms and other engineering languages such as Java, C++ and Python, we can ensure a fully tailored solution for our clients.Find Out More
News & Insights
Leading technology and digital transformation provider Version 1 has accelerated its growth and added to its rapidly expanding global customer base with the acquisition of data and business intelligence...
Blog: September 1, 2021
Speed to insight can be the leading source of competitive advantage for any data-driven organisation. It’s the ability to gain real-time access to powerful data insights and action them that’s critical...