Table structure modification method and device, equipment and computer readable storage medium

A table structure and modification instruction technology, applied in the field of financial technology, can solve the problems of complicated table structure modification process and low DDL execution efficiency.

Pending Publication Date: 2019-10-15
WEBANK (CHINA)
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The main purpose of the present invention is to provide a table structure modification method, device, equipment and computer-readable storage medium, aiming to solve the existing problems of complicated table structure modification process and low DDL execution 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
  • Table structure modification method and device, equipment and computer readable storage medium
  • Table structure modification method and device, equipment and computer readable storage medium
  • Table structure modification method and device, equipment and computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0043] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0044] refer to figure 1 , figure 1 It is a schematic diagram of the device structure of the hardware operating environment involved in the solution of the embodiment of the present invention.

[0045] The device for modifying the table structure in the embodiment of the present invention may be a smart phone, or a terminal device such as a PC (Personal Computer, personal computer), a tablet computer, or a portable computer.

[0046] like figure 1 As shown, the device for modifying the table structure may include: a processor 1001 , such as a CPU, a communication bus 1002 , a user interface 1003 , a network interface 1004 , and a memory 1005 . Wherein, the communication bus 1002 is used to realize connection and communication between these components. The user interface 1003 may include a display screen (Display), a...

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 table structure modification method and device, equipment and a computer readable storage medium. The method comprises: when a table structure modification instruction is received, acquiring a structured query language SQL file carried in the table structure modification instruction; analyzing the SQL file to obtain a table name of each database mode definition language DDL statement in the SQL file and a corresponding execution command; determining a modification type corresponding to the table structure modification instruction according to the table name of each DDL statement, and determining a corresponding modification strategy according to the modification type; and processing the DDL statement based on the modification strategy, the table name and the execution command to obtain a processed DDL statement, and calling a preset tool to execute the processed DDL statement so as to modify a corresponding table structure. According to the method, the problems that an existing table structure modification process is complex, and DDL execution efficiency is low can be solved.

Description

technical field [0001] The present invention relates to the technical field of financial technology (Fintech), in particular to a table structure modification method, device, equipment and computer-readable storage medium. Background technique [0002] With the development of computer technology, more and more technologies (big data, distributed, blockchain, artificial intelligence, etc.) The industry's security and real-time requirements also put forward higher requirements for technology. [0003] With the frequent increase of Internet application functions, it often involves modifying the table structure, such as adding fields, modifying field attributes, and so on. At present, pt-online-schema-change (an open source online table structure change tool) is generally used to modify the table structure online. However, this tool can only change one table at a time. If a SQL (StructuredQuery Language, Structured Query Language) file involves DDL (Data Definition Language, D...

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/22
CPCG06F16/2282
Inventor 黄蔚胡盼盼卢道和
Owner WEBANK (CHINA)
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