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

DDL statement processing method, device, electronic equipment and medium

A processing method and statement technology, applied in the field of data processing, can solve problems such as uncommon code, complex logic, heavy code maintenance and inspection workload, etc., and achieve the effect of fast positioning analysis and reducing code redundancy

Active Publication Date: 2021-06-01
SHANGHAI DAMENG DATABASE
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the implementation process of each DDL statement, each database object needs to write independent code, that is, the code between different database objects cannot be shared, resulting in code redundancy, which in turn makes code maintenance and inspection a large workload and complex logic

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 statement processing method, device, electronic equipment and medium
  • DDL statement processing method, device, electronic equipment and medium
  • DDL statement processing method, device, electronic equipment and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] 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, but not to limit the present invention. In addition, it should be noted that, for the convenience of description, only some structures related to the present invention are shown in the drawings but not all structures.

[0024] figure 1 It is a flow chart of a method for processing a DDL statement provided by an embodiment of the present invention. This embodiment is applicable to performing equivalent transformation on a DDL statement to be processed, and generating a corresponding Data Manipulation Language (Data ManipulationLanguage, DML) statement to reduce code In the case of redundancy, the method can be executed by a DDL sentence processing device, the DDL sentence processing device can be implemented by software and / or har...

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 processing method, device, electronic equipment and medium of a DDL statement. The method comprises: acquiring an operation instruction and a dictionary object in a DDL statement to be processed; generating a corresponding DML statement according to the operation instruction and the dictionary object; encapsulating the DML statement, get and execute the corresponding script statement. The embodiment of the present invention solves the problem in the prior art that codes need to be written independently for each database object, resulting in code redundancy, reduces code redundancy, and can quickly locate and analyze codes.

Description

technical field [0001] Embodiments of the present invention relate to data processing technologies, and in particular to a method, device, electronic equipment and media for processing DDL statements. Background technique [0002] In today's large-scale relational databases, the Data Definition Language (Data Definition Language, DDL) function is an essential function. How to efficiently execute DDL statements and handle concurrent DDL statements is a complex task. [0003] Currently, in a relational database, storing database objects in memory is directly manipulating the data in the system table at runtime. In the implementation process of each DDL statement, each database object needs to write independent code, that is, the code between different database objects cannot be shared, resulting in code redundancy, which in turn makes code maintenance and inspection a large workload and complex logic . Contents of the invention [0004] Embodiments of the present invention...

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 Patents(China)
IPC IPC(8): G06F16/242G06F16/28G06F16/22
CPCG06F16/2282G06F16/2433G06F16/288
Inventor 刘静
Owner SHANGHAI DAMENG DATABASE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products