Method and device for sorting relationship between database tables and application

A database and data table technology, applied in special data processing applications, visual data mining, electronic digital data processing, etc., can solve the problem that the correlation between database tables cannot be quickly and automatically sorted out, and achieve the purpose and advantages. , to avoid the effects of low accuracy and low efficiency

Pending Publication Date: 2022-03-08
CITY CLOUD TECH HANGZHOU CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] The embodiment of the present application provides a method, device and application for sorting out the relationship between database tables. Aiming at the problem that the relationship between existing database tables cannot be quickly and automatically sorted out, the historical execution sta

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 and device for sorting relationship between database tables and application
  • Method and device for sorting relationship between database tables and application
  • Method and device for sorting relationship between database tables and application

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. Implementations described in the following exemplary embodiments do not represent all implementations consistent with one or more embodiments of this specification. Rather, they are merely examples of apparatuses and methods consistent with aspects of one or more embodiments of the present specification as recited in the appended claims.

[0029] It should be noted that in other embodiments, the steps of the corresponding methods are not necessarily performed in the order shown and described in this specification. In some other embodiments, the method may include more or less steps than those described in this specification. In addition, a single step described in this...

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 provides a method and device for sorting the relation between database tables and application, and the method comprises the steps: obtaining a business data list and the record line number of each to-be-matched data table, comparing the business data size of the business data list with each record line number to obtain a comparison result, and comparing the business data size of the business data list with the record line number to obtain a matching result; determining a service main table according to the comparison result; and querying a historical execution statement associated with the service main table, extracting the to-be-matched data table having an association relationship with the service main table from the historical execution statement as an associated data table, and recording the association relationship. According to the method, the historical execution statement associated with the service main table is processed, so that the data table associated with the service main table is obtained, and the association relationship between the fields is established, and the beneficial effect of rapidly sorting the relationship between the database tables is achieved.

Description

technical field [0001] The present application relates to the technical field of data mining, in particular to a method, device and application for sorting out relationships between database tables. Background technique [0002] Driven by urbanization and the development of innovative technologies, smart cities are blooming everywhere in my country. After more than ten years of development, China has become one of the global smart city practice bases and frontier countries. At present, with the in-depth advancement of my country's reforms, a new smart city construction model featuring the "urban brain" was born in Hangzhou along with the pace of digital economic development, and is spreading to the whole country and the world. Building a smart city is inseparable from data support. In the face of complex business and massive data tables, I don’t know how to effectively build a data warehouse and extract effective data from the business system. For example, if a system crea...

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/2458G06F16/26G06F16/215
CPCG06F16/2465G06F16/26G06F16/215
Inventor 李圣权曾国清
Owner CITY CLOUD TECH HANGZHOU CO LTD
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