We need a sample database which can store the data and basic functionalities like add, delete, query and display entries of the database.
It is quite a simple database but it should be solid enough to store million of entries and a fast search of the database.
I can find a free version of Microsoft sql server 2008 r2 running on windows 2008 server platform but any free and solid database would be fine. Our platform use Windows server 2008 R2.
Any programming language is fine. and all the codes should be our property. We need especaially someone who is already familiar with Microsoft sql server 2008 r2 running on windows 2008 server platform, or any other free database will also be welcomed.
We have csv files which contains all the data, there are two types of csv files, all the csv files have headers and corresponding values, each row of the csv file has one header named ASIN which is the identifier and the other headers are simple attributes. You need to develop a database server and functionalities, and a client application which can execute the same functionalities remotely.
The basic functionalities of the database is the following :
1) read a csv file format with headers and their corresponding values, parse the identifier column and check if this identifier exists in the database. If the identifier already exists in the database it is removed from the result csv file, if not add the identifier to a new entry of the database. At the end of the process the database generates a result csv file with only non-existing identifiers rows of the input csv file. An optimized search and check should be done as quickest as possible in the database.
2) delete functionality, it reads the input csv file, and remove all the identifiers of the database which match the identifier of the csv file, and a save functionality of the results into a csv file. An option to delete the whole entries of the database but with a confirmation pop-up window.
3) a functionality to display all the entries of the database, display the number of entries in the database, display all the entries matching an attribute or identifier.