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

Database DDL management method and device

A database and data dictionary technology, applied in the field of database DDL management, can solve the problems of not being very friendly and not supporting the maintenance of stored procedures, and achieve the goal of overcoming omissions and inconvenience, automatic and accurate tracking of version management, effective and easy-to-use version management Effect

Pending Publication Date: 2021-03-05
CCB FINTECH CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This open source tool does not support the maintenance of stored procedures, and is not very friendly to enterprises that still use stored procedures more

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 DDL management method and device
  • Database DDL management method and device
  • Database DDL management method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0067]Exemplary embodiments of the present invention are described below in conjunction with the accompanying drawings, which include various details of the embodiments of the present invention to facilitate understanding, and they should be regarded as exemplary only. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.

[0068] figure 1 is a basic flowchart of a method for database DDL management according to an embodiment of the present invention, such as figure 1 As shown, the method for database DDL management includes steps S101, S102 and S103.

[0069] The term "RDBMS": Relational Database Management System (RDBMS) refers to a set of programs (database management system software) inc...

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 DDL management method and device, and relates to the technical field of computers. The method comprises the steps of obtaining a first DDL of a target component in adata dictionary at a first moment; comparing a first DDL obtained at the first moment with a second DDL of the target component at a second moment; and generating version change information of the target component according to the comparison result. According to the embodiment, the technical problems of omission, inconvenience and the like caused by manual DDL management are solved, and then thetechnical effect of automatically and accurately tracking version management is achieved.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for database DDL management. Background technique [0002] Relational database is a software system widely used by technicians in the process of IT construction. Technicians create various tables, views, functions, stored procedures, etc. in relational databases to store various data assets. The database schema definition language DDL (Data Definition Language) usually includes statements such as creating tables, views, and functions. In a large-scale project, it is particularly important to perform effective version management and tracking of these DDL creation, modification, and deletion actions. Better version management can enable users to actively learn about relevant code changes and better manage projects. [0003] For version management of the DDL of the relational database, the commonly used schemes are as follows. In the process of realizing the...

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/22G06F16/28
CPCG06F16/219G06F16/2282G06F16/284G06F16/287
Inventor 涂霖英
Owner CCB FINTECH CO LTD
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

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