Eureka AIR delivers breakthrough ideas for toughest innovation challenges, trusted by R&D personnel around the world.

DDL (Data Definition Language) statement audit method and device

A sentence and object technology, applied in the field of DDL sentence review methods and devices, can solve the problems of wasting manpower and time, low review efficiency, and poor accuracy, and achieve the effects of improving accuracy, improving review efficiency, and reducing review errors.

Active Publication Date: 2018-03-13
PING AN TECH (SHENZHEN) CO LTD
View PDF5 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the traditional method, the DDL statements in the database are usually manually reviewed by the database administrator, and the low-quality DDL statements are modified. This kind of review method wastes a lot of manpower and time, and the review efficiency is low and error-prone. Audit accuracy is poor

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
  • DDL (Data Definition Language) statement audit method and device
  • DDL (Data Definition Language) statement audit method and device
  • DDL (Data Definition Language) statement audit method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0059] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0060] figure 1 It is a schematic diagram of the internal structure of the server in one embodiment. Such as figure 1 As shown, the server includes a processor connected through a system bus, a non-volatile storage medium, an internal memory, and a network interface. Wherein, the non-volatile storage medium of the server stores an operating system, a database and a DDL statement checking device, and the database stores database script files, and the DDL statement checking device is used to implement a DDL statement checking method suitable for the server. The processor of the server is used to p...

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 relates to a DDL (Data Definition Language) statement audit method and device. The above-mentioned method includes: acquiring a to-be-audited script file; parsing the script file to obtain an object type of each DDL statement in the script file; categorising each DDL statement according to the object type of each DDL statement to obtain the DDL statements, which belong to each objectcategory, by division; acquiring an object audit template corresponding to each object category; and respectively auditing the DDL statements, which belong to each object category, according to the object audit template corresponding to each object category. According to the above-mentioned DDL statement audit method and device, massive manpower and time are saved, audit efficiency of the DDL statements can be improved, accuracy of audit is effectively improved, and audit errors are reduced.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for checking DDL statements. Background technique [0002] Due to the needs of production business, generally large-scale companies need to establish a huge database group to store data in actual production business, including product information, customer information, etc. In order to effectively manage the database group, it is usually necessary to ensure that the DDL (Data Definition Language, database definition language) statements in the database comply with the corresponding specifications, so as to ensure the stable operation of the database. In the traditional method, the DDL statements in the database are usually manually reviewed by the database administrator, and the low-quality DDL statements are modified. This kind of review method wastes a lot of manpower and time, and the review efficiency is low and error-prone. Audit accuracy is poor. Co...

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): G06F11/36G06F17/30
CPCG06F11/362G06F16/217
Inventor 金海锋
Owner PING AN TECH (SHENZHEN) CO LTD
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
Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com