Database query method and device, computer equipment and storage medium

A data query and database technology, which is applied in the database field, can solve problems such as the server is prone to crash, the efficiency of SQL statement execution is reduced, and the data volume of the data table cannot be expanded, so as to realize the query load, reduce the probability of crash, and improve efficiency. Effect

Active Publication Date: 2020-04-10
浙江大搜车软件技术有限公司
View PDF6 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the SQL statements are all pre-set simple logic. When the business volume of the database surges, the SQL statement cannot cope with the expansion of the number of data tables in the database and the data volume of the data table. The execution efficiency of the server based on the SQL statement is reduced, and the server also prone to crashes etc.

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
  • Database query method and device, computer equipment and storage medium
  • Database query method and device, computer equipment and storage medium
  • Database query method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application.

[0046] The database query method provided by this application can be applied to such as figure 1 shown in the application environment. Wherein, the terminal 102 communicates with the server 104 through the network. The server 104 receives the database query request sent by the terminal 102, and the database query request carries a service identifier; the server 104 obtains the service query type and the condition field corresponding to the service identifier; the server 104 determines the service query type, and based on the condition field and the service query The busi...

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 a database query method and device, computer equipment and a storage medium. The method comprises the steps: receiving a database query request sent by a terminal, wherein thedatabase query request carries a service identifier; obtaining a service query type and a condition field corresponding to the service identifier; determining the service query type, and generating an SQL segment for data fragmentation and query based on the condition field and a service conversion logic corresponding to the service query type, the service conversion logic carrying statement parameters corresponding to query conditions of a service identifier; according to the SQL sentences in the SQL language segments, carrying out database division on a database, carrying out data query onthe database subjected to database division to obtain query data, and sending the query data to the terminal. By adopting the method, the SQL statement can be generated in real time according to the service identifier, so the database data processing efficiency is improved.

Description

technical field [0001] The present application relates to the database field, in particular to a database query method, device, computer equipment and storage medium. Background technique [0002] In large-scale applications, the database has become an indispensable part, and all operations on the database need to be completed through the database connection. The server needs to perform a retrieval operation on the database through a structured query language (SQL: Structured Query Language) statement corresponding to the service identifier. However, the SQL statements are all pre-set simple logic. When the business volume of the database surges, the SQL statement cannot cope with the expansion of the number of data tables in the database and the data volume of the data table. The execution efficiency of the server based on the SQL statement is reduced, and the server also prone to crashes etc. Contents of the invention [0003] Based on this, it is necessary to address ...

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): G06F16/22G06F16/242G06F16/2455
CPCG06F16/2433G06F16/2455G06F16/2282Y02D10/00
Inventor 郑钢民
Owner 浙江大搜车软件技术有限公司
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