I'm storing large amounts of financial data for options. Recommendations for a database to store this data?
我正在为选项存储大量财务数据。建议数据库存储此数据?
Edit
- "large amounts" is 1GB initially, scaling up to around 100GB at some point in the future.
- Fine with either commercial and open source.
- Developing with Microsoft Visual Studio 2010 and C#.
- Latency/retention periods: need to store streaming realtime data in such a way that I don't lose any of the data coming in (probably about 10KByte/sec maximum data to store). Querying can be performed outside of market hours, so speed of querying is not an issue.
“大量”最初为1GB,未来某个时候可以扩展到100GB左右。
商业和开源都很好。
使用Microsoft Visual Studio 2010和C#进行开发。
延迟/保留期:需要以这样的方式存储流式实时数据,即我不会丢失任何数据(可能存储大约10KByte / sec的最大数据)。查询可以在市场时间之外执行,因此查询速度不是问题。
2 个解决方案
#1
2
Since this is a Microsoft-based project the obvious choice is Microsoft SQL Server, which has very good integration with C# and Visual Studio.
由于这是一个基于Microsoft的项目,显而易见的选择是Microsoft SQL Server,它与C#和Visual Studio有很好的集成。
100GB is not large.
100GB并不大。
#2
1
You don't give us a lot of details! Have a look at this; it may help you decide.
你没有给我们很多细节!看看这个;它可以帮助你决定。
#1
2
Since this is a Microsoft-based project the obvious choice is Microsoft SQL Server, which has very good integration with C# and Visual Studio.
由于这是一个基于Microsoft的项目,显而易见的选择是Microsoft SQL Server,它与C#和Visual Studio有很好的集成。
100GB is not large.
100GB并不大。
#2
1
You don't give us a lot of details! Have a look at this; it may help you decide.
你没有给我们很多细节!看看这个;它可以帮助你决定。