Database query method and device, computer device and readable storage medium
A query method and database technology, applied in the fields of computer-readable storage media, devices, and database query methods, can solve the problems of difficulty in writing SQL statements, inconvenient user operations, and high basic requirements for databases, and achieve the effect of facilitating query operations
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment 1
[0047] figure 1 It is a flow chart of steps in a preferred embodiment of the database query method of the present invention. According to different requirements, the order of the steps in the flowchart can be changed, and some steps can be omitted.
[0048] refer to figure 1 As shown, the database query method specifically includes the following steps.
[0049] Step S1, acquiring attribute information of the database, and generating a tree selection model according to the attribute information.
[0050] In this embodiment, the attribute information of the database includes a database identifier, a data table identifier, a field identifier and a record identifier. Understandably, each database may include one or more data tables, each data table may include one or more fields, and each field may include one or more records.
[0051]Preferably, each database has a database identifier, each data table has a data table identifier, each field has a field identifier, and each fi...
Embodiment 2
[0078] figure 2 It is a functional block diagram of a preferred embodiment of the database query device of the present invention.
[0079] refer to figure 2 As shown, the database query device 20 may include a generation module 201 , an opening module 202 , an association module 203 , a query module 204 and an acquisition module 205 .
[0080] The generation module 201 is used to obtain attribute information of the database, and generate a tree selection model according to the attribute information.
[0081] In one embodiment, each database in the generating module 201 has a database identifier, each data table has a data table identifier, each field has a field identifier, and each field identifier has a record identifier. The database identification, data table identification, field identification and record identification can be used as nodes of the tree selection model, wherein each database identification node in the tree selection model is connected to the root node,...
Embodiment 3
[0109] image 3 It is a schematic diagram of a preferred embodiment of the computer device of the present invention.
[0110] The computer device 30 includes a memory 31 , a processor 32 and a computer program 33 stored in the memory 31 and operable on the processor 32 , such as a database query program. When the processor 32 executes the computer program 33, the steps in the above-mentioned database query method embodiment are realized, for example figure 1 Steps S1-S5 are shown. Alternatively, when the processor 32 executes the computer program 33, it realizes the functions of each module in the above database query device embodiment, for example figure 2 Modules 201-205 in .
[0111] Exemplarily, the computer program 33 can be divided into one or more modules / units, and the one or more modules / units are stored in the memory 31 and executed by the processor 32 to complete this invention. The one or more modules / units may be a series of computer program instruction segm...
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