Geek Answers Handbook

Storage of a large amount of analytical data

I usually use SQL Server and C # for all the projects I do, however I am considering a project that could potentially span billions of rows of data, and I am not comfortable in SQL Server.

The data that I will store

  • datetime
  • ipAddress
  • linkId
  • possibly other string related data

I had only dealt with relational databases before and, therefore, was looking for some recommendations about which database technology is best suited for this type of data storage. One that can scale and do it at a low cost (compared to the overlooked SQL Server)

Then I needed to pull this data based on linkId.

Also, can I make an order in a request in the database or will it be best done in the application?

EDIT: It will be cloudy. So I looked at SQL Azure, which I used widely, however it just starts to cause problems as the number of rows increases.

+4
source share
2 answers

, , .Net/#, ( "" - LinkID ) , , , RDBMS, Amazon DynamoDB. DynamoDB AWS (Amazon Web Services) NoSQL. , . 2013-11-04, DynamoDB , :

AWS Free Tier 100 , 5 , 10 Amazon DynamoDB.

: , .Net .Net SDK.

: , , , AWS, ..

+1

, , , ;-). Microsoft SQL Server ( , ). , 4 , , 1,2-1,5 ( ), , , . -, ( ). , , , , ", " ( ). , Express , Standard Edition, , . - , .

, , , , MS SQL Server . , , , , - , , , , : , , MS SQL Server . , , , , , ..

:)

:

  • (), " ", 1 90 , . , , , , .
  • Enterprise Edition, , , , , . / SQL Server "Sharding".
  • Column Store, Enterprise Edition. , , , . SQL Server 2012 , ​​ . , , Table Partitioning, SQL Server 2014 .
+4

More articles:


All Articles