Supercharge Your Innovation With Domain-Expert AI Agents!

Data query method and system and computer readable storage medium

A data query and data technology, applied in the field of data query, can solve the problem of low data query efficiency and achieve the effect of improving data query efficiency

Pending Publication Date: 2021-03-16
SHENZHEN YEAHKA TECH
View PDF0 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The main purpose of the present invention is to provide a data query method, a data query system and a computer-readable storage medium, aiming to solve the problem of low data query efficiency in the prior art when data is synchronized to the index

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 and computer readable storage medium
  • Data query method and system and computer readable storage medium
  • Data query method and system and computer readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0075] refer to figure 2 , figure 2 It is a flow chart of the first embodiment of the data query method of the present invention. In this embodiment, the data query method includes the following steps:

[0076] Step S10: Obtain data update information of each data table in the database;

[0077] In this embodiment, in order to improve the efficiency of data query, the fields of multiple data tables in the database can be merged into the index field of the same index in the search engine, that is, the user only needs to input any field in the index field to quickly query to the data in multiple data tables without multiple queries through indexes and databases, that is, there is no need to associate multiple data tables for joint table query, and it is not necessary to merge multiple data tables into the same data table to avoid Increase the load on the database. However, the data tables in the database are updated in real time. When there are data updates in the data tabl...

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 a data query method. The method comprises the following steps: obtaining data updating information of each data table in a database; if it is determined that multiple updated data tables exist according to the data updating information and associated unique table fields exist among the multiple updated data tables, combining the table fields of the multiple updated data tables into index fields of the same index, the updated data tables being data tables with data updated in a database; and querying the data in the plurality of updated data tables from a search engine based on the merged index fields. The invention further discloses a data query system and a computer readable storage medium. By combining the table fields of the multiple data tables into the same index, the data in the multiple data tables can be queried only by one-time query without multiple queries, so that the data query efficiency is improved.

Description

technical field [0001] The present invention relates to the technical field of data query, in particular to a data query method, system and computer-readable storage medium. Background technique [0002] At present, there are mainly two methods for querying data based on indexes: the first one is to synchronize the data table to the index as it is, which needs to combine the data of multiple tables from the index query to the database or another index to obtain, that is, at least Two queries, the query efficiency is not high. The second is to synchronize the log data to the queue by analyzing the log data, and then use other programs to consume the queue and write the data to the index. At this time, not only the additional queue module and additional consumer program modules need to be introduced, but also the data synchronization to the index is not real-time And the efficiency is not high enough. Therefore, the existing synchronous index scheme has the problem of low da...

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/2455G06F16/22G06F16/23G06F16/27
CPCG06F16/24558G06F16/2228G06F16/23G06F16/27
Inventor 刘颖麒罗美清
Owner SHENZHEN YEAHKA TECH
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com