Problem when merging data from different sources. What attributes do key in the database?
System for large firms engaged in marketing and data analysis on competitors
One of the functions of accounting information of companies and their structure (dochke, branches, etc.) and data transmission to the Central office
Ie client machine with the server installed in different cities (offices).
Attributes. For example:
Short name: Roel
Full name: LLC "NK rule"
Organizacna form: limited liability company
Address: Syktyvkar, St. Mark's, 7
Activities: Sale and production of precious metals
Parent company: JSC "Rarus"
The lower of the company: LLC "FSC", LTD "MARRIAGE"
Owner: Sidorov PI
Analyst each day passes the information on to the Central office analysts.
The multiserver system. I.e. the DB data is not centralized. For information about the establishments is and their structure was identical to the structure information is transmitted to the Central office. Let's just say, for the alignment of a structure.
It is logical to assume that the key attribute is the "full name" or INN. But there is one but
the analysis identifies firms (dochke) which is not complete. For example:
"There is information about some of the company was in Balma, owner Mycol. There is information about the fact that this firm is associated with JSC "Rosadana". Please consider and check"
I.e. on one of the client machines will be fixed infa about objete without his name. And will need this info to send.
Please tell me which attribute (or something "more") to make the key and why?
Guys correctly write about aydishnik. Once you have the data completeness is not defined, the only ever-present element of the record is an additional field of aydishnik.
hank51 answered on July 9th 19 at 14:09
Generated ID in this case is the only correct solution, int/long or UUID depending on the views/wishes. At the time, tried various identifiers like INN, KPP, etc. to do the keys, but nothing good came out of this - the usefulness of the data entered by the end user, as a rule, are not guaranteed, exactly as their reliability.