NOSQL vs SQL RDMS for trading data

(Last Updated On: April 15, 2015)

NOSQL vs SQL RDMS for trading data

I got this question from a member:

When storing my stock data, would it be better to use a NOSQL or SQL server I am a MS Partner so I receive $100 monthly credit for Azure services and it looks like a promising option. They have DocumentDB as well as SQL server options both on high bandwidth connections, I could run my IQFeed client on a compute node and just query database from mobile and desktop connections, but not sure which option is better for stock data.

I am unsure of your exact goals in terms are you using this for analytical real time purpose or to house data, If you are using for real time in a high frequency timeframe, use NOSQL with something like MongoDB or Redis. If you are using for historical or to permanently house (like a data warehouse), use a database like SQL Server. In terms of cloud, if the data is not sensitive, it can be useful.

As for me, I want to live in a non Windows world one day so I my modern open source database of choice is PostGres for now. It has worked as well as my experience with SQL Server plus PostGres is free as you know.

Hope this helps for now,

Join my FREE newsletter to learn more about databases in trading 

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!
This entry was posted in Quant Development and tagged , , , , on by .

About caustic

Hi i there My name is Bryan Downing. I am part of a company called QuantLabs.Net This is specifically a company with a high profile blog about technology, trading, financial, investment, quant, etc. It posts things on how to do job interviews with large companies like Morgan Stanley, Bloomberg, Citibank, and IBM. It also posts different unique tips and tricks on Java, C++, or C programming. It posts about different techniques in learning about Matlab and building models or strategies. There is a lot here if you are into venturing into the financial world like quant or technical analysis. It also discusses the future generation of trading and programming Specialties: C++, Java, C#, Matlab, quant, models, strategies, technical analysis, linux, windows P.S. I have been known to be the worst typist. Do not be offended by it as I like to bang stuff out and put priorty of what I do over typing. Maybe one day I can get a full time copy editor to help out. Do note I prefer videos as they are much easier to produce so check out my many video at youtube.com/quantlabs