Associated data table query method and device

A query method and data table technology, applied in the database field, can solve problems such as affecting business results, low efficiency, and no solutions are proposed, and achieve the effect of efficient development and improved query efficiency.

Pending Publication Date: 2021-08-13
BANK OF CHINA
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When performing logic development, the existing technology manually selects multiple associated data tables by developers. Due to the large number of data tables involved, it is a challenge for developers to choose which tables to associate with a table. If the selection is wrong Can affect business results, inefficiency
[0003] For the above problems, no effective solution has been proposed

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
  • Associated data table query method and device
  • Associated data table query method and device
  • Associated data table query method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0022] Those skilled in the art know that the embodiments of the present invention can be implemented as a system, device, method or computer program product. Therefore, the disclosure of the present invention can be embodied in the form of complete hardware, complete software (including firmware, resident software, microcode, etc.), or a combination of hardware and software.

[0023] An embodiment of the present invention provides a query method for an associ...

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 an associated data table query method and a device, and relates to the technical field of databases, and the associated data table query method comprises the following steps: establishing a metadatabase according to metadata of each data table; receiving a target data table, and querying an associated data table of the target data table from the metadatabase according to metadata of the target data table; and pushing the associated data table of the target data table to the user, and by establishing the metadatabase and querying the associated data table of the target data table from the metadatabase, so that the automatic query of the associated data table is realized, the query efficiency of the associated data table is improved, and the development of job logic can be more efficient and accurate.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a query method and device for an associated data table. Background technique [0002] When developing job logic in a data system, it is often necessary to associate multiple data tables before forming a job with specific business logic. When performing logic development, the existing technology manually selects multiple associated data tables by developers. Due to the large number of data tables involved, it is a challenge for developers to choose which tables to associate with a table. If the selection is wrong It will affect business results and be inefficient. [0003] For the above problems, no effective solution has been proposed yet. Contents of the invention [0004] An embodiment of the present invention provides a query method for an associated data table to improve the query efficiency of the associated data table. The method includes: [0005] According to the m...

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 Applications(China)
IPC IPC(8): G06F16/22G06F16/245
CPCG06F16/2282G06F16/245
Inventor 陈世强徐雅光韩路
Owner BANK OF 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