Delaing with a large dataset

I have been given dataset (one is 6 db and the other is 35 gb). this is my first time to handle such large database, I have been used to small datasets (surveys), using STATA and SPSS.

My qestion is, what are the recommended data management systems for data management and analysis

I am also interested in automating some of the functions, like filter or rows/columns. I am good in programming using vb.net

Anthony
LVL 1
Anthony MatovuBusiness Analyst, MTN UgandaAsked:
Who is Participating?
 
dqmqCommented:
SQL Server has a nice suite of integrated tools with an obvious affinity to vb.net.  It can handle well-designed DB's of that size without breaking a sweat.
0
 
AmmarRCommented:
hi MatovuAnthony

SQL server 2008 R2 can handle a database of size 524,272 terabytes
for more details check the link for the Maximum Capacity Specifications for SQL Server

http://msdn.microsoft.com/en-us/library/ms143432.aspx
0
 
AmmarRCommented:
and for dealing with large database using data-grid in VB
here you go you can use Virtual Mode with Just-In-Time Data Loading

http://msdn.microsoft.com/en-us/library/ms171624.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.