下载PDF
Actian > 实例探究 > Actian Vectorwise
Actian Logo

Actian Vectorwise

技术
  • 分析与建模 - 实时分析
适用行业
  • 金融与保险
适用功能
  • 商业运营
用例
  • 预测性维护
服务
  • 数据科学服务
挑战
The Rohatyn Group (TRG), a hedge fund based in New York, needed a solution to manage risk in the highly volatile market of hedge funds. Information about positions, pricing, and risk is critical to investment decision-making. For tactical decision-making, TRG provided analysts immediate access to the information they needed in a format that they could use through a self-service data access environment. However, the combination of market volatility and a desire to do more strategic analysis drove the need to understand how their positions had performed over time. While the existing solution provided the interactive analysis TRG was looking for, it did not have the historical data. They wanted the user tools to remain the same and the query responses to be interactive, but they needed to do the analysis on more than 1000 times the data.
关于客户
The Rohatyn Group (TRG) is a hedge fund headquartered in New York, focusing on emerging markets. The company provides analysts with immediate access to the information they need in a format that they can use through a self-service data access environment. TRG maintains extensive data about the current state of all their market positions in a multi-dimensional data structure managed by a proprietary in-memory database. This enables analysts to interactively answer their questions about the current state of their investments.
解决方案
TRG deployed Vectorwise to process data from multiple systems so that hedge fund managers could evaluate their positions in near real time. For the Vectorwise POC, TRG decided to flatten all of the data into a single table with almost 300 columns. They loaded millions of rows of historical data into the single table and the results were incredible. Vectorwise provided the in-memory performance and interactivity wanted with the data residing on-disk. Fast performance was delivered out-of-the-box without any indexing, preaggregating results, or extensive database tuning. Vectorwise’s support for standard SQL made the implementation very fast and the simplicity of the data design made the migration very easy.
运营影响
  • Access to historical data enables different analyses that enable analysts to better assess the risk of the current market positions.
  • Flexibility and adaptability of the Vectorwise-based solution have improved greatly over the replaced proprietary in-memory database.
  • In-memory query performance against large data sets that cannot possibly fit in-memory is delivering the performance and interactivity users want.

相关案例.

联系我们

欢迎与我们交流!

* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

Thank you for your message!
We will contact you soon.