Local databse
-
Hi, I am writing a program in VB.NET (VS2005 Pro) that essentially simulates an neurology experiment. This program's data shoould consiste of 8 independent tables, each having 13 columns and up to 100,000 rows in each table. To make it simpler, all data will be in string format. Other requirments: 1. The tables needs to be sortable like a dictioanry where 1 column will act as a key. 2. The user needs to be able to see the data in a tabular format. 3. The data must be held on the user's local machine, not a server and not remotley. 4. Needs to easily be readable by Excel, doesn't matter how. It can convert to an XML file and then somehow be automatically converted to xls. I am thinking of using a databse becasue I would like to eventually create a login screen to link previous experiment values to a user, but that is not essential. I used dynamic multi-dimensiaonal arrays but find it difficult to work with, and extremley difficult to sort. I was looking at the idea of using an XML database which will probbaly solve any issues of excel compatability as well as provide support for displaying the information on a website sometime in the future. I can't figure out how this all works. Can anyone recommend a way to display a large amounts of generated data on a local computer, and almo make it save-able. I also like Oracle's 10g Express thing, but don't know if it would work for my specific problem becasue the cusotmer support people at Oracle don't speak English very well. Thank You, Maksim UCLA, Neurology
-
Hi, I am writing a program in VB.NET (VS2005 Pro) that essentially simulates an neurology experiment. This program's data shoould consiste of 8 independent tables, each having 13 columns and up to 100,000 rows in each table. To make it simpler, all data will be in string format. Other requirments: 1. The tables needs to be sortable like a dictioanry where 1 column will act as a key. 2. The user needs to be able to see the data in a tabular format. 3. The data must be held on the user's local machine, not a server and not remotley. 4. Needs to easily be readable by Excel, doesn't matter how. It can convert to an XML file and then somehow be automatically converted to xls. I am thinking of using a databse becasue I would like to eventually create a login screen to link previous experiment values to a user, but that is not essential. I used dynamic multi-dimensiaonal arrays but find it difficult to work with, and extremley difficult to sort. I was looking at the idea of using an XML database which will probbaly solve any issues of excel compatability as well as provide support for displaying the information on a website sometime in the future. I can't figure out how this all works. Can anyone recommend a way to display a large amounts of generated data on a local computer, and almo make it save-able. I also like Oracle's 10g Express thing, but don't know if it would work for my specific problem becasue the cusotmer support people at Oracle don't speak English very well. Thank You, Maksim UCLA, Neurology
My Best Suggestion is go with XMl.
Regards, Satips.:rose:
-
Hi, I am writing a program in VB.NET (VS2005 Pro) that essentially simulates an neurology experiment. This program's data shoould consiste of 8 independent tables, each having 13 columns and up to 100,000 rows in each table. To make it simpler, all data will be in string format. Other requirments: 1. The tables needs to be sortable like a dictioanry where 1 column will act as a key. 2. The user needs to be able to see the data in a tabular format. 3. The data must be held on the user's local machine, not a server and not remotley. 4. Needs to easily be readable by Excel, doesn't matter how. It can convert to an XML file and then somehow be automatically converted to xls. I am thinking of using a databse becasue I would like to eventually create a login screen to link previous experiment values to a user, but that is not essential. I used dynamic multi-dimensiaonal arrays but find it difficult to work with, and extremley difficult to sort. I was looking at the idea of using an XML database which will probbaly solve any issues of excel compatability as well as provide support for displaying the information on a website sometime in the future. I can't figure out how this all works. Can anyone recommend a way to display a large amounts of generated data on a local computer, and almo make it save-able. I also like Oracle's 10g Express thing, but don't know if it would work for my specific problem becasue the cusotmer support people at Oracle don't speak English very well. Thank You, Maksim UCLA, Neurology
I think performance wise a database would be alot faster. You can sort by column in multiple ways as well as only pull the data you want by using queries. Even if speed isn't a factor, I think you'll find working with databases easier.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
-
I think performance wise a database would be alot faster. You can sort by column in multiple ways as well as only pull the data you want by using queries. Even if speed isn't a factor, I think you'll find working with databases easier.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo