Method for fast searching database

A database and fast technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of increased data volume, low response efficiency, inability to meet system concurrency requirements, etc., to increase costs and improve query functions. , Improve the effect of concurrent response speed

Inactive Publication Date: 2014-04-16
G CLOUD TECH
View PDF3 Cites 37 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This design method is in line with the software design and can make the software more flexible, but there will be problems in the process of data query; because the above information is stored in different tables, it is necessary to associate all information through the method of table association
The association will cause a rapid increase in the amount of resulting data. For example, if there are 50 records for student information and 12 information for classroom information, 600 records will appear in the Cartesian product when the two tables are associated. Cal product increases faster
Therefore, in some high-frequency query services, this method may not meet the concurrency requirements of the system, or the response efficiency is very low

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 fast searching database
  • Method for fast searching database
  • Method for fast searching database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] As shown in the figure, the present invention mainly includes the following steps:

[0018] The first step, according to business needs, create a temporary table temp for a certain business;

[0019] Step 2. According to business needs, establish the corresponding index for the table;

[0020] The third step is to query the data association table of a certain business through the timer, and insert it into the temporary table temp; when broadcasting the temporary table, delete the old data first;

[0021] Step 4. In the business system query, first use keywords to query whether there is a result value in memchace, if it exists, it will directly return the result set; if it does not exist, go to step 5;

[0022] Step 5: Query the temp temporary table, use the keyword as the key, integrate the combination into the value, and put it in the menchace cache, and return the result set to the client.

[0023] Such as figure 2 As shown, the following specifically takes the student status ...

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 relates to the technical field of software, in particular to a method for fast searching a database. Service data are cached and checked layer by layer by allocating a set of service data temporary tables, and the query result is cached into the memcache through the memcache; when the query is carried out again, data can be accessed in the memcache through a key value. Due to the fact that the memcache is an internal storage object suspected caching system, the query speed is higher, and the operation efficiency for the database is higher. A timer is used for cleaning the memchace, and the most complete data result body is obtained through the query. The method can be widely applied to database query services of software products.

Description

Technical field [0001] The present invention relates to the technical field of software, in particular to a method for rapid database retrieval. Background technique [0002] The current business system is becoming more and more responsible, but in the process of software design, everyone uses object-oriented methods to design and develop the platform. For example, student information in a school status management system may include teacher information, classroom information, grade information, Attendance information, class information, contact information. At the same time, this information is stored in a separate table. Student information will only store the related information of the above information, but when the above information needs to be obtained, it can be obtained through related queries. The design method is in line with the software design, and can make the software more flexible, but there will be problems in the data query process; because the above information ...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/2272G06F16/2477
Inventor 关班记孙傲冰庞毅季统凯
Owner G CLOUD TECH
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