Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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 verified, it cannot be returned to its initial state before the verification, and the above steps are re-executed. Heavy workload and low work efficiency

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

Technical field [0001] The present invention relates to the technical field of databases, in particular to a method and device for verifying the data structure of a database. Background technique [0002] In project and product development, the data structure between multiple versions of relational databases often changes. At present, the industry generally implements operations such as adding or deleting fields to data tables in the database, adding indexes, and cutting over data in tables by changing Structured Query Language (SQL) scripts. [0003] In the specific operation, generally the designer or developer first submits an application for data structure or data changes, and then the reviewer will review, modify the SQL script, and verify the modified SQL script. After the verification is passed, it will be persisted. Save the SQL script and deliver the product or project for use. However, in this process, after verifying the modified SQL script, the structure of the databa...

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
IPC IPC(8): G06F16/21G06F16/22
CPCG06F16/21G06F16/2282
Inventor 毛恒
Owner CHINA UNITECHS
Features
  • Generate Ideas
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More