Database data structure verification method and device

A technology of data structure and verification method, applied in the database field, can solve the problems of large workload and low work efficiency, and achieve the effect of improving efficiency and small workload

Active Publication Date: 2020-03-24
CHINA UNITECHS
View PDF8 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in this process, after the modified SQL script is verified, the structure of the database has changed. If the SQL script fails to be verifi

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
  • Database data structure verification method and device
  • Database data structure verification method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] In order to make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the following describes the embodiments of the present invention in further detail with reference to the accompanying drawings. Here, the exemplary embodiments of the present invention and the description thereof are used to explain the present invention, but not as a limitation to the present invention.

[0041] Attached figure 1 This is a flowchart of a method for verifying a database data structure provided by an embodiment of the present invention, as attached figure 1 As shown, the method includes:

[0042] Step 101: Obtain association information between different data tables in the original database.

[0043] In this embodiment, step 101 includes: obtaining information of multiple data tables in the original database according to the data dictionary of the original database, and obtaining the association information between different data tables in t...

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

The invention discloses a database data structure verification method and apparatus. The method comprises: obtaining associated information between different data tables in an original database; obtaining influence information of each data table in the original database on other tables in the original database when the in-table field changes according to the associated information among differentdata tables in the original database; creating a temporary database, and obtaining a preset environment standard in combination with the influence information; according to a preset environment standard, establishing a temporary data table corresponding to the data table in the original database in the temporary database; and verifying the updated data structure in the original database accordingto the temporary data table, and emptying the temporary database if the verification fails. According to the method, all data and structures in the original data table do not need to be correspondingto the temporary data table, so that the efficiency of subsequently using the temporary data table for verification is improved. And if the verification fails, only the temporary database needs to beemptied, and the temporary data table is re-established for verification, so that the workload is relatively small.

Description

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

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
Owner CHINA UNITECHS
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