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

Database data object relation graph generation method and device, equipment and medium

A data object and database technology, applied in the field of big data, can solve problems such as difficult to evaluate the impact of the database, unable to judge the reference of the stored procedure table, etc.

Active Publication Date: 2021-02-19
PING AN TECH (SHENZHEN) CO LTD
View PDF8 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The main purpose of this application is to provide a method, device, device, and medium for generating a database data object relationship graph, aiming at solving the problem that existing database development tools can only analyze the reference relationship between packages and tables, and cannot judge each stored procedure References to tables, making it difficult to assess the impact of abnormal changes in table structure or table data content on the database

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 object relation graph generation method and device, equipment and medium
  • Database data object relation graph generation method and device, equipment and medium
  • Database data object relation graph generation method and device, equipment and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0060] In order to make the purpose, technical solution and advantages of the present application clearer, the present application 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 application, and are not intended to limit the present application.

[0061] In order to solve the problem that the existing database development tools can only analyze the reference relationship between the package and the table, but cannot judge the reference of each stored procedure to the table, making it difficult to evaluate the impact of abnormal changes in the table structure or table data content on the database, this application proposes A method for generating a data object relational graph of a database is provided, the method is applied in the field of big data technology, the method is further applied in the field of database te...

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 the technical field of big data, and discloses a database data object relation graph generation method and device, equipment and a medium. The method comprises the steps of acquiring to-be-analyzed view data according to ORACLE database codes; analyzing the to-be-analyzed view data to obtain first dependency relationship data, second dependency relationship data, third dependency relationship data and fourth dependency relationship data; determining a target package definition storage process relationship, a target package definition function relationship, a target call function relationship, a target call storage process relationship, a target call table relationship, a target call view relationship, a target view call function relationship, a target view call view relationship and a target view call table relationship; and determining a target data object relationship graph according to the first dependency relationship data, the second dependency relationship data, the third dependency relationship data and the fourth dependency relationship data. Therefore, the relational graph based on the data object is automatically generated. The invention also relates to a blockchain technology.

Description

technical field [0001] The present application relates to the technical field of big data, in particular to a method, device, equipment and medium for generating a data object relational graph of a database. Background technique [0002] The current database development tools can only analyze the reference relationship between the package and the table when analyzing the data objects of the database. When there are multiple stored procedures in a package, it is impossible to judge the reference of each stored procedure to the table, resulting in When there is an abnormal change in the table structure or table data content, it is difficult to assess the impact on the entire database. Contents of the invention [0003] The main purpose of this application is to provide a method, device, device, and medium for generating a database data object relationship graph, aiming at solving the problem that existing database development tools can only analyze the reference relationship...

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/26G06F16/22G06F16/28
CPCG06F16/26G06F16/2282G06F16/284
Inventor 童显耀
Owner PING AN TECH (SHENZHEN) 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