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

Method, device, equipment and medium for generating data object relational graph of database

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: 2022-03-18
PING AN TECH (SHENZHEN) CO LTD
View PDF8 Cites 0 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
  • Method, device, equipment and medium for generating data object relational graph of database
  • Method, device, equipment and medium for generating data object relational graph of database
  • Method, device, equipment and medium for generating data object relational graph of database

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

This application relates to the field of big data technology, and discloses a method, device, device and medium for generating a database data object relationship graph, wherein the method includes: obtaining the view data to be analyzed according to the ORACLE database code; analyzing the view data to be analyzed to obtain the first Dependency data, second dependency data, third dependency data, and fourth dependency data, determine target package definition stored procedure relationship, target package definition function relationship, target call function relationship, target call stored procedure relationship, target call table relation, target call view relation, target view call function relation, target view call view relation and target view call table relation; determined according to first dependency data, second dependency data, third dependency data and fourth dependency data Target data object relational graph. In this way, a relationship graph based on data objects is automatically generated. This application also relates to 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
Patent Type & Authority Patents(China)
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