Data query method and device in database, equipment and storage medium
A data query and database technology, applied in the database field, can solve problems such as increasing system processing complexity and wasting system resources.
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0026] figure 1 It is a flowchart of a data query method in a database provided by Embodiment 1 of the present invention. This embodiment is applicable to the situation of data query in a database. The method can be executed by a data query device in a database, and specifically includes the following steps:
[0027] Step S110, analyzing the received query statement.
[0028] In this embodiment, a query statement can be understood as a statement generated according to a database query and a programming language for data query, for example, select count(*) from t1.
[0029] When users have query requirements, that is, when they want to obtain information from the database, they input query statements on the application program interface (database software), and the database management system analyzes the syntax and semantics of the query statements.
[0030] Step S120, determine whether there is a where filter condition in the query statement, if yes, execute step S130; otherw...
Embodiment 2
[0045] figure 2 It is a flowchart of a data query method in a database provided by Embodiment 2 of the present invention. The technical solution of this embodiment is further refined on the basis of the above-mentioned technical solution, and specifically mainly includes the following steps:
[0046] Step S210, analyzing the received query statement.
[0047] Step S220, determine whether there is a where filter condition in the query statement, if yes, execute step S230; otherwise, execute step S280.
[0048] Step S230, determining the number of data tables to be queried in the set of tables to be queried in the query statement.
[0049] Step S240, judging whether the query quantity is within the preset quantity range, if yes, perform step S250; otherwise, perform step S280.
[0050] Step S250, for the target data table selected from the set of tables to be queried, judge whether the target data table satisfies the statement conversion condition, if so, execute step S260; ...
Embodiment 3
[0073] image 3 A schematic structural diagram of a device for querying data in a database provided by Embodiment 3 of the present invention, the device includes: an analysis module 31 , a determination module 32 and an optimization module 33 .
[0074] Wherein, the parsing module 31 is used for parsing the received query statement; the determination module 32 is used for determining the query quantity of the data table in the table set to be queried in the query statement when there is a where filter condition in the query statement; An optimization module 33, configured to, when the number of queries is within a preset number range, for the target data table selected from the set of tables to be queried, according to the preset sentence conversion conditions and sentence conversion rules for the The statement associated with the target data table in the query statement is optimized to obtain an optimized query statement, so as to implement data query according to the optimiz...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com