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

A data update and data update technology, applied in the database field, can solve the problems of unstable system operation, increase the probability of system errors, and reduce system performance.

Inactive Publication Date: 2006-11-08
SHENZHEN TINNO WIRELESS TECH
View PDF0 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for realizing update data in real time data bank
  • Method and system for realizing update data in real time data bank
  • Method and system for realizing update data in real time data bank

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0076] The present invention proposes a method for updating data in a real-time database, and its core idea is: set a section of fixed code for all relational tables in the database, and the fixed code records the information of the association relation check that needs to be performed; Each table sets a record to represent the relationship between the target relational table and other relational tables; receives externally input data to be updated and updates the information of the relational tables involved, and updates the relational tables involved according to the set fixed codes For the corresponding records, check the association relationship, and update the data to be updated in the relationship table involved in the update according to the result of the association relationship inspection; and correct the records corresponding to the relationship table whose association relationship has changed.

[0077] Correspondingly, the present invention also proposes a system for...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 季小俊
Owner SHENZHEN TINNO WIRELESS TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap