Need to create software(script) that will be store, filter and analize data. The number of records in the database can be up to hundreds of thousands of records, you should use the most optimized algorithms and development technologies.(New data will be upload every day)
The process of working has next structure:
.CSV data file -> Database and text comparation analizer-> Processing macros and filters -> output in .TXT format
1 step) Loading data from a .CSV file with a fixed structure in the current database
2) After data uploaded, it should compare one field(text) for each record with another records in !ALL DATABASE for similarity
(!!! This is the most difficult part of this project, it need to compare two text(two records), and return similirity of it in percents)
Example of working you can find at:
[url removed, login to view]
[url removed, login to view] (There is russian language interface(can be translated in Google translate))
After current record was compared with all records in DB, it add info of MAXIMUM percent of similiry and ID of the record that is most similiar to.
So we saved this info for each record in db.
3) One record has next structure:
Field 1;Field 2;Field 3;...;Max percent of simility;ID of most similiar record
4)The ability to create flexible filters (macros) to sort the data (filters (macros) should be able to save)
Macro consists of several filters (fields has different types: date, text, numerical)..
Field 1 contains "John"
Field 4 is equal to "address" OR field 4 is equal to "Andy"
So macros has a complex structure with the logical relations between the filters inside AND \ OR
5) After processing the macro data that we received, export in .TXT file
!!!ALL ADDITIONAL INFO AND DATA SAMPLE WILL BE PROVIDED!!!
12 freelancers are bidding on average $584 for this job
I have fully understood the requirements of your project and am ready to start ASAP. 10+ years of .NET experience guarantee swift project completion with quality results.
We are freelance software developers. If you contact me I can give a quote for your project and we can discuss the details. www.<b><i>Removed by Admin</i></b>
Hello. I'm interresting in this project. I have experience in analysing hudge amounts of data in SQL databases (hundreds of millions records) using Delphi.