Data query method and system based on complex data relationship of database

A data query and complex data technology, applied in the field of database query, can solve the problem of low retrieval efficiency

Inactive Publication Date: 2021-03-09
INSPUR SUZHOU INTELLIGENT TECH CO LTD
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Aiming at the deficiencies in the prior art, the present invention provides a data query method based on the complex data relationship of the database, aiming at solving the limitation of the underlying implementation principle of the MySQL database in the prior art when the data definition relationship is many and complex , the default SQL statement, the problem of low retrieval efficiency

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
  • Data query method and system based on complex data relationship of database
  • Data query method and system based on complex data relationship of database
  • Data query method and system based on complex data relationship of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] Embodiments of the technical solutions of the present invention will be described in detail below in conjunction with the accompanying drawings. The following examples are only used to illustrate the technical solution of the present invention more clearly, and therefore are only examples, and cannot be used to limit the protection scope of the present invention.

[0045] figure 1 It is an implementation flow chart of the data query method based on the complex data relationship of the database provided by the present invention, which specifically includes the following steps:

[0046] In step S101, the input data object to be queried is received, and the data object is analyzed for the lower-level entry, wherein the data object includes a database, a data table, and each table structure object under the data table;

[0047] In step S102, the data objects are grouped according to the preset grouping base number and the number of subordinate entries of the data objects, ...

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 database query, and provides a data query method and system based on a complex data relationship of a database, and the method comprises the steps: receiving an input to-be-queried data object, and carrying out the analysis of a subordinate entry of the data object; grouping the data objects according to a preset grouping cardinal number and the number of the subordinate entries of the data objects, and recording the data objects as N groups; constructing a self-connection query command of each group of data objects according to a rule of the self-connection query statement, and executing a query action on the self-connection query command corresponding to each group of data objects to generate a corresponding query search result file; and performing intersection operation on all query search result files by using a recursion method to obtain a data query file, thereby improving the database data search efficiency.

Description

technical field [0001] The invention belongs to the technical field of database query, and in particular relates to a data query method and system based on complex data relationships of a database. Background technique [0002] In database operations, it is often necessary to complete the retrieval of predetermined data. A simple search limited by a small amount of data can be retrieved by using only basic SQL statements. However, when the data restriction relationship is many and complex, the default SQL statement is limited by the underlying implementation principle of the MySQL database, and the retrieval efficiency is low. [0003] Attempts to use pure database technology to optimize complex searches are not recommended in many one-off or short-term applications. Moreover, some technical personnel who do not have a deep understanding of databases, and even database administrators cannot use pure database technology to give specific solutions or statements in a short pe...

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/242G06F16/2453G06F16/2455G06F16/248
CPCG06F16/2433G06F16/2453G06F16/2455G06F16/248
Inventor 石立南
Owner INSPUR SUZHOU INTELLIGENT TECH 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