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

Big data query return method and device

A big data, the largest technology, applied in the field of big data query return method and device, can solve the problem of poor effectiveness

Inactive Publication Date: 2018-03-09
CHINA SECURITY & FIRE IOT SENSING CO LTD
View PDF4 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to provide a big data query return method and device to solve the problem of poor effectiveness in the existing solutions for improving the query return speed of tens of millions of big data

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
  • Big data query return method and device
  • Big data query return method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0037] see figure 1 , which shows a flow chart of a big data query return method provided by an embodiment of the present invention, wherein the big data may refer to big data of tens of millions of levels, of course, it may also be applied to other levels of data according to actual needs, No specific limitation is made here. The above method may specifically include the following steps:

[0038] S11: Obtain the corresponding start record number and end rec...

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 big data query return method and device. The big data query return method comprises the steps of obtaining a corresponding start record number and a termination record numberbased on a query start time and a query termination time, wherein each query record has a corresponding record number, and the record number has an auto-increment attribute; determining a differencevalue of the termination record number and the start record number as the total number of the query records, and determining a quotient of the total number of the query records to the preset single-page number as the number of total pages; and returning to the corresponding query records in a paging mode from the start record number to the termination record number on basis of the single-page number and the number of the total pages. This method makes use of the auto-increment attribute of the record number to obtain the total number of the query records by means of the difference value of thetermination record number and the start record number, then determines the number of the total pages according to the total number of the query records and the preset single-page number, and returnsto all the query records that are queried in the paging mode so that the query return speed of tens of millions of the big data is effectively improved so as to better satisfy the user experience.

Description

technical field [0001] The present invention relates to the technical field of information retrieval, and more specifically, to a large data query return method and device. Background technique [0002] With the continuous development of informatization, the amount of data in each business system is getting larger and larger, and when the amount of data reaches a certain level, it is very time-consuming to query, especially when the data reaches tens of millions. If the database design is not reasonable , it often takes a long time to query more than tens of millions of data, and then displaying the queried data to users will cause a very bad user experience due to the long waiting time; therefore, improving the query of tens of millions of big data Return speed becomes even more important. [0003] How to give full play to the maximum performance of the system and make the query speed the fastest without increasing the hardware cost is a problem faced by many enterprises. ...

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/2228G06F16/248
Inventor 陈兵彭星豪
Owner CHINA SECURITY & FIRE IOT SENSING 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