Method for database multi-list union query

A joint query and database technology, applied in relational databases, database models, database distribution/replication, etc., can solve the problem of slow joint query speed of multiple tables in databases, and achieve the effect of improving speed and efficiency

Active Publication Date: 2017-10-20
XIDIAN UNIV
View PDF4 Cites 23 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The present invention aims to solve the technical problem of slow joint query speed of multiple tables in the database, and provi...

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 for database multi-list union query
  • Method for database multi-list union query
  • Method for database multi-list union query

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] The present invention will be further described below in conjunction with drawings and embodiments.

[0028] figure 1 It is a schematic flow chart of an embodiment of the database multi-table joint query method of the present invention. According to the embodiment, the technology of the present invention is illustrated by taking the design of the metadata information table and gateway information table of the sensing device in the relational database MySQL as an example Scheme, the database multi-table joint query method provided by the present invention comprises the following steps:

[0029] Step 1, according to query requirements, group the associated tables in MySQL, and determine the associated metadata information table sensorInfo and gateway information table gatewayInfo in MySQL.

[0030] Step 2, connect to the MySQL database, and obtain the information of the table sensorInfo (see Table 1) and the table gatewayInfo (see Table 2). A plurality of structured que...

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

A method for database multi-list union query comprises the steps of determining a plurality of lists associated with service logic in a relational database; connecting the database, and obtaining information of the plurality of lists; associating the plurality of lists into a materialized view list according to foreign key information; processing fields in the materialized view list, generating a combination key, and setting the combination key as a row key of a newly-built column type data table; establishing a mapping relation from the relational database to the column type data table, and writing the mapping relation and data records in the materialized view list into an XML file; mapping data in the materialized view list to the row key and a column identifier in the column type data table, writing the data records into the column type data table; performing multi-list query in the column type data table, and obtaining query results. According to the method, multi-list union query can be implemented quickly and efficiently under the condition of mass data.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method for combined query of multiple tables in a database. Background technique [0002] The database is an organized and shareable collection of data stored in the computer for a long time. The data in the database is organized, described and stored together with a certain data model. Users can query and retrieve the data in the database within a certain range. and processing operations. The technology of extracting the required data from a computer file or database according to the query requirements, which is one of the basic technologies of data processing, is called data query technology. For relational databases, there are many methods of data query, such as simple structured query language query, fuzzy query, object data model query, multi-table joint query, etc. Among them, multi-table joint query is a very common and important query method, which can be realized t...

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): G06F17/30
CPCG06F16/2282G06F16/2456G06F16/256G06F16/27G06F16/284
Inventor 仝勖峰张群王慧敏高海乐
Owner XIDIAN UNIV
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