Eureka AIR delivers breakthrough ideas for toughest innovation challenges, trusted by R&D personnel around the world.

Data query method, device and system

A data query and data technology, applied in the field of communication, can solve the problems that the processing speed of the database server is greatly affected, affects the customer query experience, and the data database load is large, so as to improve the query experience, reduce the amount of processing and transmission, and improve efficiency Effect

Inactive Publication Date: 2014-02-19
HUAWEI TECH CO LTD
View PDF3 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The inventor found in the research that there are the following problems in querying data through the above method: the query operation in the prior art relies heavily on the database server, which is greatly affected by the processing speed of the database server, and the database server directly searches for data according to the query conditions. Filter out the data that meets the query conditions from the database with millions of data volumes, which puts a heavy load on the data database, and the query efficiency is also very low, which affects the customer's query experience

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, device and system
  • Data query method, device and system
  • Data query method, device and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] In order to make the objectives, technical solutions and advantages of the present invention clearer, the embodiments of the present invention will be described in further detail below with reference to the accompanying drawings and examples.

[0027] In the embodiment of the present invention, the application server determines the query primary key according to the query conditions in the query request sent by the client, and queries the database server for the value of the query primary key, according to the number of query result items in the query request and the corresponding query primary key value The database server is instructed to create a temporary table, and finally the data identified by the value of the query primary key in the temporary table is queried, and the data required by the client is queried. Through the above technical means, the efficiency of data query is improved, the load of the database server is reduced, and the query experience of the clie...

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 embodiment of the invention provides a data query method, which comprises the following steps of: determining a query main key through an application server according to a query request sent by a client for querying data in accordance with certain query conditions, querying the value of the query main key in a database server, creating a temporary database table according to the query result item number in the query request and the value of the corresponding query main key, and finally querying the data identified by the value of the query main key in the temporary table, wherein the data are required by the client. The invention also provides a data query device and a data query system. The data query efficiency can be improved through the technical scheme provided by the embodiment of the invention.

Description

technical field [0001] The present invention relates to the field of communication technologies, and in particular, to a data query method, device and system. Background technique [0002] With the development of communication technology, in order to meet the needs of various services, more and more data are stored in the database server. For large-scale application systems (such as carrier-level application systems), the amount of data in the database server is often in the millions. , and querying and browsing data are the most common needs of users. How to quickly and reliably read the data required by the user from the huge data of the database server is particularly important. [0003] In the application system of B / S (Browser / Server) browser / server mode and C / S (Client / Server) client / server mode, the general query process in the prior art is: data is stored in the database server, when When the user needs to query data, the query conditions are sent to the applicatio...

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 Patents(China)
IPC IPC(8): H04L12/24H04L12/26G06F17/30
Inventor 李宗标魏雪锋沈琦蒋英茹
Owner HUAWEI 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
Eureka Blog
Learn More
PatSnap group products