Build a master database of names that we can compare with a customer list and it displays the langauge/country/genealogy of that name.
1. The first step will be to build the master database of names- this will need to be done in multiple phases
a) build master database of surnames and code to a language/country/genealogy
b) build master database of first names and code to a language/country/genealogy
c) aggregate a master database of full names and code to a language/country/genealogy
We have access to an existing database (csv/dbf) plus our own databases (excel) of surnames so there will be a logical process to load these.
2. The second step will then be to connect this with our existing system and clean our existing database system. I can explain more about this but there is a relationship between the new surname database created and the existing census databases that we have
3. The third step will be to build an interface where we can upload some client list, compare it with our master database of surnames and spit back the results with some logic and smarts to be accessible on client side.
11 pekerja bebas membida secara purata $215 untuk pekerjaan ini
Having good Experience in RDBMS solution and architecture. Mastered at Database Architecture, Query Solution and Query Optimisation with SQL Server, MySQL and PostgreSQL.