METHOD OF UPDATING STRUCTURED DATA IN RELATIONAL DATABASE MANAGEMENT SYSTEM Russian patent published in 2014 - IPC G06F17/30 

FIELD: physics, computer engineering.

SUBSTANCE: invention relates to computer engineering. The method of updating structured data in a relational database management system involves forming an updated database structure containing metadata and a set of altered data; comparing the structure of the initial and updated database by comparing data and metadata of the structures, and if the structures of the initial and updated databases are identical, the structure comparison result is transformed into a data format of a given structure, which depends on the structure of lines of the initial and updated databases returned by a request, thereby obtaining fragments of metadata in the data format of the given structure; comparing the obtained metadata fragments while forming comparison results; analysing the formed comparison results and selecting the essence - different data lines in the data format of the given structure of the formatted data descriptor fragment, in the updated or initial database, using the selected essence; creating a data file describing difference of data and describing all actions bringing data of the initial database into an updated state, using the formed data file; updating data in the initial database by inverse transformation of data from the data format of the given structure into a request format.

EFFECT: high accuracy and quality of comparing and updating data in relational database management system.

7 cl, 3 dwg