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

Information query method and device for associated data, computer equipment and storage medium

A technology of information query and data query, applied in the database field, can solve problems such as affecting data access efficiency, slow query operation process, unsatisfactory user experience, etc., and achieve the effect of improving user experience, clear and fast query process, and fast access to data records

Pending Publication Date: 2019-10-11
PINGAN PUHUI ENTERPRISE MANAGEMENT CO LTD
View PDF0 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When customers want to obtain a data record, they need to use SQL statements to perform multiple index queries and data queries to obtain the required information, and the query operation process becomes slower as the amount of data increases, which greatly affects data access. Efficiency, user experience is not ideal

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
  • Information query method and device for associated data, computer equipment and storage medium
  • Information query method and device for associated data, computer equipment and storage medium
  • Information query method and device for associated data, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0043] see figure 1 , this embodiment proposes an information query method for associated data, which is mainly used for querying data records corresponding to specific fields from a stored database, including the following steps:

[0044] S1: In response to the data query instruction, obtain the field in the data query instruction, and query the target position of the target data table corresponding to the field from the first index structure; wherein the index structure represents a plurality of interrelated sheets The index relationship between the first data tables, the target data table is one or more of the plurality of interrelated first data tables.

[0045] In a traditional database query method, such as querying information from an oracle database, it is necessary to determine the relevant data table from the query index of the oracle database, and then search for relevant records from the data table. The query of index information needs to be realized by using sql ...

Embodiment 2

[0083] see Figure 4 , this embodiment proposes an information storage method, which corresponds to the information query method in Embodiment 1, and is the basis for realizing the information query method in Embodiment 1. The information storage method proposed in this embodiment includes the following steps:

[0084] S1: In response to a data storage instruction, store data records in a plurality of interrelated second data tables.

[0085] The following steps in this embodiment are used to introduce the storage process of multiple data tables that are associated with each other.

[0086] After receiving the data storage instruction, the present invention will first store the data records in multiple data tables that are related to each other. It should be noted that in this step, the index relationship between the data tables does not need to be stored. The data records in the data table are generally stored in an ordinary database, such as an oracle database, but some da...

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 an information query method and an information query device for associated data, and the method comprises the steps: responding to a data query instruction, obtaining a field inthe data query instruction, and querying a target position of a target data table corresponding to the field from a first index structure; wherein the index structure represents an index relationshipamong a plurality of first data tables associated with each other, and the target data table is one or more of the plurality of first data tables associated with each other; obtaining a matching field matched with the field from a data storage space according to the target position; and obtaining a first data record corresponding to the matching field.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to an information query method, device, computer equipment and storage medium capable of efficiently querying associated data of stored data. Background technique [0002] A complete set of data information often includes multiple interrelated data tables, and each data table has an index relationship with each other and is relatively independent. In the traditional data storage method, all data tables are stored in a unified database, and a large number of query indexes need to be established in the database for the convenience of query. When customers want to obtain a data record, they need to use SQL statements to perform multiple index queries and data queries to obtain the required information, and the query operation process becomes slower as the amount of data increases, which greatly affects data access. Efficiency, user experience is not ideal. Contents of the inventio...

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/22G06F16/2455
CPCG06F16/2282G06F16/2228G06F16/24552Y02D10/00
Inventor 魏浩
Owner PINGAN PUHUI ENTERPRISE MANAGEMENT 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