Method and system for realizing update data in real time data bank

Abstract

This invention discloses a method and a system for realizing data refreshment in real time in a database, in which, said system includes: an applied unit, a data control unit and a storage unit, the method includes: designing a section of fixed code against all relation lists in a database, said fixed code registers information of association relation check needed to be carried out, designing recording for expressing the association relation between said target relation list and other relation list against each target relation list, carrying out the exame based on the set code and the recording corresponding to the data refreshment and carrying out data refreshment based on the exame result to modify the recording corresponding to the relation list involved in the data refreshment.

Description

technical field [0001] The invention relates to database technology, in particular to a method and system for updating data in a real-time database. Background technique [0002] student ID SNO student name SN Department SD student age SA 100 Li Hong computer science 18 … … … … [0003] Relationship table S [0004] course number CNO Course Title CN lesson hours CT 1 microcomputer principle 18 … … … [0005] Relationship Table C [0006] student ID SNO course number CNO academic performance GR 100 1 88 … … … [0007] Relationship table SC [0008] It can be seen from the above relational table S, relational table C, and relational table SC that there is no associated field between relational table S and relationa...

AI Technical Summary

Problems solved by technology

[0016] It can be seen from the above description that in the process of implementing data update in the prior art, since the relationship information between a relational table and other relational tables is hard-coded in the fixed code corresponding to the relational table, every time the system After executing the data update process, it is necessary to modify the fixed code of the relationship table whose association relationship has changed. Since the fixed code of the system is modified, it will lead to unstable operation of the system.

In addition, in the process of implementing data update in the prior art, a fixed code must be set for each relational table, that is to say, each set of fixed codes is completely dependent on the specific relational table, and the relational table is different, and its corresponding The fixed code is different, so that the number of codes is large, which greatly increases the error probability of the system and reduces the performance of the system.

Images