0
$\begingroup$

My firm is looking for an out-of-the-box database system to store and query high-frequency tick data. What are the best options? It seems that kdb+ is the market leader in this field.

$\endgroup$
  • $\begingroup$ In those circumstances: The best database system is file system. $\endgroup$ – Marian May 19 '14 at 5:54
  • $\begingroup$ out-of-the-box? This concept does not exist in finance, unless of course you want to "trade" bitcoins. Whatever time series store you decide to go with you will not get around doing a lot of performance analytics, tweaking, and customization. Just for your reference, KDB generally sends a host of "consultants" who stay for several days just to setup the initial database structure. $\endgroup$ – Matthias Wolf May 19 '14 at 7:35
  • $\begingroup$ possible duplicate of Is there any thing out there as a substitute for KDB? $\endgroup$ – Bob Jansen May 19 '14 at 7:57
  • $\begingroup$ I'm also quite interested in this; if anyone knows of a free DB that integrates well with .NET, please do tell. $\endgroup$ – rex May 19 '14 at 11:52
  • $\begingroup$ not aware of such free product. if low frequency, check open-tsdb. $\endgroup$ – Daniel Qin May 20 '14 at 6:18
1
$\begingroup$

An alternative is the TeaFiles file format. It's simple and boasts a high performance but I believe you'll have to reinvent some wheels.

$\endgroup$
1
$\begingroup$

kdb+ seems to be the leader but their programming language is a pain really. Personally I use a HDF5. It is a No-SQL database. It integrates very nicely with python.

I have been very happy with it so far.

$\endgroup$
0
$\begingroup$

velocity analytics might be a choice.

$\endgroup$
  • $\begingroup$ Can you say a bit more about why? $\endgroup$ – Bob Jansen May 20 '14 at 5:53
  • $\begingroup$ you may check thomsonreuters.com/enterprise-platform-velocity-analytics $\endgroup$ – Daniel Qin May 20 '14 at 6:11
  • $\begingroup$ @DanielQin you should ellaborate in your answer, otherwise, please just post a comment. This is one of the good practices of this web site. Thanks. And welcome anyway. $\endgroup$ – lehalle May 21 '14 at 5:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.