CN110688544A - Method, device and storage medium for querying database - Google Patents
Method, device and storage medium for querying database Download PDFInfo
- Publication number
- CN110688544A CN110688544A CN201910989442.6A CN201910989442A CN110688544A CN 110688544 A CN110688544 A CN 110688544A CN 201910989442 A CN201910989442 A CN 201910989442A CN 110688544 A CN110688544 A CN 110688544A
- Authority
- CN
- China
- Prior art keywords
- database
- attribute information
- queried
- query
- branch
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/90335—Query processing
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method, equipment and a storage medium for querying data. The method comprises the following steps: acquiring attribute information of an SQL query statement; acquiring a database to be queried according to the attribute information; and carrying out data query from the database to be queried according to the SQL query statement. In the embodiment of the invention, no matter the structured database or the unstructured database is adopted, the database to be queried can be obtained and queried by obtaining the attribute information of the SQL query statement without being limited by the type of the database, so that the databases of different types can be queried by adopting a uniform query mode.
Description
Technical Field
The embodiment of the invention relates to the technical field of databases, in particular to a method, equipment and a storage medium for querying a database.
Background
With the development of computer technology, data storage technology is continuously advanced, the complexity of service systems is continuously improved, and many systems with relatively complex services have adopted various types of structured databases to store data, such as Oracle, mysql, or server and other various types of databases.
In the process of implementing the invention, the inventor finds that the prior art has the following defects: when a structured database and an unstructured database exist in a system, an effective unified mode for querying the databases with different properties does not exist at present.
Disclosure of Invention
The invention provides a method, equipment and a storage medium for querying a database, which are used for accurately querying data of the database.
In a first aspect, an embodiment of the present invention provides a method for querying a database, where the method includes: acquiring attribute information of an SQL query statement; acquiring a database to be queried according to the attribute information; and performing data query from the database to be queried according to the attribute information.
In a second aspect, an embodiment of the present invention further provides an apparatus, where the apparatus includes: one or more processors;
a storage device for storing one or more programs,
when executed by one or more processors, cause the one or more processors to implement a method of querying a database as any embodiment of the invention.
In a third aspect, an embodiment of the present invention provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements a method for querying a database according to any embodiment of the present invention.
The embodiment of the invention provides a method, equipment and a storage medium for querying a database, and in the embodiment of the invention, whether the database is a structured database or an unstructured database, the database to be queried can be obtained and queried by obtaining the attribute information of an SQL query statement without being limited by the type of the database, so that the databases of different types can be queried by adopting a uniform query mode.
Drawings
The above and other features, advantages and aspects of various embodiments of the present disclosure will become more apparent by referring to the following detailed description when taken in conjunction with the accompanying drawings. Throughout the drawings, the same or similar reference numbers refer to the same or similar elements. It should be understood that the drawings are schematic and that elements and features are not necessarily drawn to scale.
Fig. 1 is a flowchart of a method for querying a database according to an embodiment of the present invention;
FIG. 2 is a flowchart of a method for querying a database according to a second embodiment of the present invention;
fig. 3 is a schematic structural diagram of an apparatus for querying a database according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of an apparatus according to a fourth embodiment of the present invention.
Detailed Description
Embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While certain embodiments of the present disclosure are shown in the drawings, it is to be understood that the present disclosure may be embodied in various forms and should not be construed as limited to the embodiments set forth herein, but rather are provided for a more thorough and complete understanding of the present disclosure. It should be understood that the drawings and embodiments of the disclosure are for illustration purposes only and are not intended to limit the scope of the disclosure.
It should be understood that the various steps recited in the method embodiments of the present disclosure may be performed in a different order, and/or performed in parallel. Moreover, method embodiments may include additional steps and/or omit performing the illustrated steps. The scope of the present disclosure is not limited in this respect.
Example one
Fig. 1 is a flowchart of a method for querying a database according to an embodiment of the present invention, where the present embodiment is applicable to querying different types of databases, and the method may be executed by an apparatus for querying a database according to an embodiment of the present invention, where the apparatus may be implemented in software and/or hardware, and may be generally integrated in a computer device. The method of the embodiment of the invention specifically comprises the following steps:
Optionally, before acquiring the attribute information of the SQL query statement, the method may further include: defining the format of the SQL query statement, wherein the format of the SQL query statement comprises the following steps:
select [ field ], … from [ database type ], [ table ] where [ condition status ] [ group by status ] [ order by status ] limit [ query start line ]? [ number of queries per page ].
In the present embodiment, the structured database or the unstructured database can be queried using the SQL language defined above and having the same format, thereby implementing the compatibility of the SQL query method.
Optionally, the obtaining attribute information of the SQL query statement may include: analyzing the SQL query statement by adopting a lexical analysis tool class generated by a preset lexical script to obtain lexical information of the SQL query statement; analyzing the lexical information by adopting a grammar analyzing tool class generated by a preset grammar script to obtain the grammar information of the SQL query statement; acquiring a syntax tree of the SQL query statement according to the syntax information; and acquiring the attribute information of the SQL query statement according to the syntax tree.
Specifically, in this embodiment, the lexical script may be defined as querysqllexer.g, the grammar script may be defined as querysqlparser.g, and specific code programs of the grammar script are as follows:
of course, this embodiment is described by way of example only, and other code programs that can achieve the same functions are also within the scope of the present application, and are not limited in the examples of the present application.
It should be noted that, in this embodiment, an analysis tool class may be generated according to a lexical script querysqlLexer.g and a grammatical script querysqlParser.g, specifically, a lexical analysis tool class querysqlLexer.java in a java code form may be generated for the querysqlLexer.g, and a grammatical analysis tool class querysqlParser.java in a java code form may be generated for the querysqlParser.g. Since the specific implementation of generating tool classes according to scripts is not the focus of the present application, details of the implementation are not repeated. And, defining a method for defining a syntax tree in a syntax parsing tool class QuerySqlParser. java, wherein specific codes are as follows:
the specific definition of the syntax tree common tree may be set according to the format of the query statement defined by the user, and the specific definition of the syntax tree is not limited in this embodiment
In a specific implementation, in a specific execution process, parsing an SQL query statement by using a lexical parsing tool querysqllexer.java generated by a preset lexical script querysqllexer.g to obtain lexical information of the SQL query statement, parsing the lexical information by using a syntax parsing tool querysqlparser.java generated by a preset syntax script querysqlparser.g to obtain syntax information of the SQL query statement, and obtaining a syntax tree of the SQL query statement according to the syntax information, wherein specific codes are as follows:
optionally, the syntax tree includes a selectTree branch, a fromTree branch, a heretree branch, a groupByTree branch, an orderByTree branch, and a limitTree branch; acquiring attribute information of the SQL query statement according to the syntax tree, wherein the attribute information comprises the following steps: and acquiring attribute information of the SQL query statement from different branches.
Specifically, a syntax tree of the SQL query statement may be obtained by executing the code, where the syntax tree includes a plurality of tree branches, and the attribute information of the SQL query statement may be obtained from each tree branch.
And 102, acquiring a database to be queried according to the attribute information.
Optionally, obtaining the database to be queried according to the attribute information may include: and traversing from the attribute information contained in the fromTree branch to obtain the database to be queried and the type of the database to be queried.
Specifically, in the embodiment of the present application, the obtained fromTree branch of the syntax tree includes related attribute information of the database, which may specifically include the database to be queried and the type of the data to be queried, and of course, the related attribute information of the database may also include other parameters, which is not limited in this embodiment.
And 103, performing data query from a database to be queried according to the attribute information.
Optionally, querying data from a database to be queried according to the attribute information includes: traversing according to the attribute information contained in the branch to obtain query parameters; and performing data query from a database to be queried according to the query parameters.
The embodiment of the invention provides a method for querying a database, and in the implementation mode of the invention, no matter a structured database or an unstructured database, the database to be queried can be obtained and queried by obtaining the attribute information of an SQL query statement without being limited by the type of the database, so that the databases of different types can be queried by adopting a uniform query mode.
Example two
Fig. 2 is a flowchart of a method for querying a database according to a second embodiment of the present invention. The embodiment of the present invention may be combined with each alternative in the above implementation, and in the embodiment of the present invention, performing data query from a database to be queried according to attribute information includes: traversing according to the attribute information contained in the branch to obtain query parameters; and performing data query from a database to be queried according to the query parameters.
As shown in fig. 2, the method of the embodiment of the present invention specifically includes:
step 201, obtaining attribute information of the SQL query statement.
Step 202, obtaining a database to be queried according to the attribute information.
Step 203, traversing according to the attribute information contained in the branch to obtain the query parameter.
Optionally, traversing according to the attribute information included in the branch to obtain the query parameter, which may include: traversing attribute information contained in the selectTree branch to obtain a query field aiming at a database to be queried; traversing from the attribute information contained in the whereTree branch to obtain an inquiry condition aiming at the database to be inquired; traversing attribute information contained in the groupByTree branch to obtain a grouping mode aiming at a database to be queried; traversing attribute information contained in the orderbyTree branch to obtain a sorting mode aiming at a database to be queried; and traversing the attribute information contained in the limitree branch to obtain the query starting row and the query number of each page of the database to be queried.
In a specific implementation, after the database to be queried is determined, traversal needs to be further performed from the attribute information included in the branch of the syntax tree to obtain the query parameter for the database to be queried, and the attribute information of the query field is obtained in the selectTree branch of the obtained syntax tree, for example, the attribute information of the query field specifically includes field a; obtaining a query condition in a where tree branch of the obtained syntax tree, for example, attribute information of the query condition specifically includes condition B; obtaining attribute information of a grouping mode in a groupByTree branch of the obtained syntax tree, wherein the attribute information of the grouping mode specifically comprises grouping according to regions, for example; obtaining attribute information of a sorting mode in an orderbyTree branch of the obtained syntax tree, for example, the attribute information of the sorting mode comprises ascending order; and obtaining attribute information of a query starting line and the number of query strips per page in a limitree branch of the obtained syntax tree, wherein the attribute information of the query starting line comprises 6 and the attribute information of the number of query strips per page comprises 10. Of course, this embodiment is described by way of example only, and is not limited to specific numerical values of parameters obtained from attribute information included in each branch.
Step 204, performing data query from the database to be queried according to the query parameters
Optionally, after traversing according to the attribute information included in the branch and obtaining the query parameter, the method may further include: calling a query interface of the database to be queried according to the type of the database to be queried and the query parameters; performing data query from a database to be queried according to the query parameters, wherein the data query comprises the following steps: and carrying out data query from the database to be queried through a query interface according to the query parameters.
Specifically, in the embodiment, different types of databases and query parameters respectively correspond to different query interfaces, so after the database to be queried and the query parameters are obtained, the corresponding query interface needs to be called according to the database to be queried and the query parameters, and data query is performed from the determined query interface according to the query parameters, so that the accuracy of data query is ensured.
The embodiment of the invention provides a method for querying a database, and in the implementation mode of the invention, no matter a structured database or an unstructured database, the database to be queried can be obtained and queried by obtaining the attribute information of an SQL query statement without being limited by the type of the database, so that the databases of different types can be queried by adopting a uniform query mode. And performing data query from the database to be queried according to the attribute information, wherein the data query comprises traversing according to the attribute information contained in the branch to obtain query parameters, and performing data query from the database to be queried according to the query parameters. Thereby ensuring the accuracy of the query data.
EXAMPLE III
Fig. 3 is a schematic structural diagram of an apparatus for querying a database according to an embodiment of the present invention. The apparatus may be implemented in software and/or hardware and may generally be integrated in a computer device. As shown in fig. 3, the apparatus includes: an attribute information acquisition module 301, a database to be queried acquisition module 302 and a data query module 303.
The attribute information acquiring module 301 is configured to acquire attribute information of an SQL query statement; a database to be queried obtaining module 302, configured to obtain a database to be queried according to the attribute information; and the data query module 303 is configured to perform data query from the database to be queried according to the attribute information.
The apparatus for querying a database according to the embodiment of the present invention is the same as the method for querying a database according to the embodiments, and technical details that are not described in detail in the embodiments of the present invention may be referred to the embodiments, and the embodiments of the present invention have the same beneficial effects as the embodiments.
Example four
Fig. 4 is a schematic structural diagram of a computer device according to an embodiment of the present invention. FIG. 4 illustrates a block diagram of an exemplary computer device 412 suitable for use in implementing embodiments of the present invention. The computer device 412 shown in FIG. 4 is only one example and should not impose any limitations on the functionality or scope of use of embodiments of the present invention.
As shown in fig. 4, the computer device 412 is in the form of a general purpose computing device. Components of computer device 412 may include, but are not limited to: one or more processors 416, a memory 428, and a bus 418 that couples the various system components (including the memory 428 and the processors 416).
The memory 428 is used to store instructions. Memory 428 can include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM)430 and/or cache memory 432. The computer device 412 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 434 may be used to read from and write to non-removable, nonvolatile magnetic media (not shown in FIG. 4, commonly referred to as a "hard drive"). Although not shown in FIG. 4, a magnetic disk drive for reading from and writing to a removable, nonvolatile magnetic disk (e.g., a "floppy disk") and an optical disk drive for reading from or writing to a removable, nonvolatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to bus 418 by one or more data media interfaces. Memory 428 can include at least one program product having a set (e.g., at least one) of program modules that are configured to carry out the functions of embodiments of the invention.
A program/utility 440 having a set (at least one) of program modules 442 may be stored, for instance, in memory 428, such program modules 442 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which examples or some combination thereof may comprise an implementation of a network environment. The program modules 442 generally perform the functions and/or methodologies of the described embodiments of the invention.
The computer device 412 may also communicate with one or more external devices 414 (e.g., keyboard, pointing device, display 424, etc.), with one or more devices that enable a user to interact with the computer device 412, and/or with any devices (e.g., network card, modem, etc.) that enable the computer device 412 to communicate with one or more other computing devices. Such communication may occur via input/output (I/O) interfaces 422. Also, computer device 412 may communicate with one or more networks (e.g., a Local Area Network (LAN), a Wide Area Network (WAN) and/or a public network, such as the Internet) through network adapter 420. As shown, network adapter 420 communicates with the other modules of computer device 412 over bus 418. It should be appreciated that although not shown in FIG. 4, other hardware and/or software modules may be used in conjunction with the computer device 412, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems, among others.
The processor 416 performs various functional applications and data processing by executing instructions stored in the memory 428, such as performing the following: acquiring attribute information of an SQL query statement; acquiring a database to be queried according to the attribute information; and performing data query from a database to be queried according to the attribute information.
EXAMPLE five
Fifth embodiment of the present invention provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the method for querying a database provided in any embodiment of the present invention.
Namely: acquiring attribute information of an SQL query statement; acquiring a database to be queried according to the attribute information; and performing data query from a database to be queried according to the attribute information.
Any combination of one or more computer-readable media may be employed. The computer readable medium may be a computer readable signal or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C + +, or the like, as well as conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet service provider).
It is to be noted that the foregoing is only illustrative of the preferred embodiments of the present invention and the technical principles employed. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, although the present invention has been described in greater detail by the above embodiments, the present invention is not limited to the above embodiments, and may include other equivalent embodiments without departing from the spirit of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims (10)
1. A method of querying a database, comprising:
acquiring attribute information of an SQL query statement;
acquiring a database to be queried according to the attribute information;
and performing data query from the database to be queried according to the attribute information.
2. The method according to claim 1, wherein before obtaining the attribute information of the SQL query statement, the method further comprises:
defining the format of the SQL query statement, wherein the format of the SQL query statement comprises the following steps:
select [ field ], … from [ database type ], [ table ] where [ condition status ] [ group pby status ] [ order by status ] limit [ query start line ]? [ number of queries per page ].
3. The method according to claim 1, wherein the obtaining attribute information of the SQL query statement comprises:
analyzing the SQL query statement by adopting a lexical analysis tool class generated by a preset lexical script to obtain lexical information of the SQL query statement;
analyzing the lexical information by adopting a grammar analyzing tool class generated by a preset grammar script to obtain the grammar information of the SQL query statement;
acquiring a syntax tree of the SQL query statement according to the syntax information;
and acquiring the attribute information of the SQL query statement according to the syntax tree.
4. The method of claim 3, wherein the syntax tree includes a selectTree branch, a fromTree branch, a heretree branch, a groupByTree branch, an orderByTree branch, and a limitree branch;
the obtaining of the attribute information of the SQL query statement according to the syntax tree includes:
and acquiring the attribute information of the SQL query statement from different branches.
5. The method according to claim 4, wherein the obtaining the database to be queried according to the attribute information comprises:
and traversing from the attribute information contained in the fromTree branch to obtain the database to be queried and the type of the database to be queried.
6. The method according to claim 5, wherein the querying data from the database to be queried according to the attribute information comprises:
traversing according to the attribute information contained in the branch to obtain query parameters;
and performing data query from the database to be queried according to the query parameters.
7. The method of claim 6, wherein the traversing according to the attribute information included in the branch to obtain the query parameter comprises:
traversing from the attribute information contained in the selectTree branch to obtain a query field for the database to be queried;
traversing from the attribute information contained in the whereTree branch to obtain an inquiry condition aiming at the database to be inquired;
traversing from the attribute information contained in the groupByTree branch to obtain a grouping mode aiming at the database to be queried;
traversing from the attribute information contained in the orderbbytree branch to obtain a sorting mode aiming at the database to be queried;
and traversing from the attribute information contained in the limitree branch to obtain the query starting row and the query number of each page aiming at the database to be queried.
8. The method according to claim 6, wherein after performing traversal according to the attribute information included in the branch and obtaining the query parameter, further comprising:
calling a query interface of the database to be queried according to the type of the database to be queried and the query parameter;
the data query from the database to be queried according to the query parameters comprises:
and performing data query from the database to be queried through the query interface according to the query parameters.
9. An apparatus, characterized in that the apparatus comprises:
one or more processors;
a storage device for storing one or more programs,
the one or more programs, when executed by the one or more processors, cause the one or more processors to perform the method of querying a database of any of claims 1-8.
10. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the method of querying a database according to any one of claims 1 to 8.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910989442.6A CN110688544A (en) | 2019-10-17 | 2019-10-17 | Method, device and storage medium for querying database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910989442.6A CN110688544A (en) | 2019-10-17 | 2019-10-17 | Method, device and storage medium for querying database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110688544A true CN110688544A (en) | 2020-01-14 |
Family
ID=69113328
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910989442.6A Pending CN110688544A (en) | 2019-10-17 | 2019-10-17 | Method, device and storage medium for querying database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110688544A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111259038A (en) * | 2020-01-16 | 2020-06-09 | 北京思特奇信息技术股份有限公司 | Database query and data export method, system, medium and equipment |
| CN111460241A (en) * | 2020-04-26 | 2020-07-28 | 甬矽电子(宁波)股份有限公司 | Data query method and device, electronic equipment and storage medium |
| CN111897911A (en) * | 2020-06-11 | 2020-11-06 | 中国科学院计算机网络信息中心 | Unstructured data query method and system based on secondary attribute graph |
| CN112035493A (en) * | 2020-07-23 | 2020-12-04 | 北京达佳互联信息技术有限公司 | User attribute data updating method, device, server and storage medium |
| CN112597186A (en) * | 2020-12-29 | 2021-04-02 | 广州慧智信息科技有限公司 | Data query method, computer equipment and storage medium |
| CN112765286A (en) * | 2021-02-01 | 2021-05-07 | 广州海量数据库技术有限公司 | Query method and device based on relational database |
| CN113779071A (en) * | 2021-09-24 | 2021-12-10 | 北京锐安科技有限公司 | Database query method, device, equipment and storage medium |
| CN113821526A (en) * | 2020-12-23 | 2021-12-21 | 京东科技信息技术有限公司 | Method, device and equipment for querying data and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108446289A (en) * | 2017-09-26 | 2018-08-24 | 北京中安智达科技有限公司 | A kind of data retrieval method for supporting heterogeneous database |
| CN110032575A (en) * | 2019-04-15 | 2019-07-19 | 网易（杭州）网络有限公司 | Data query method, apparatus, equipment and storage medium |
| CN110232056A (en) * | 2019-05-21 | 2019-09-13 | 苏宁云计算有限公司 | A kind of the blood relationship analytic method and its tool of structured query language |
-
2019
- 2019-10-17 CN CN201910989442.6A patent/CN110688544A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108446289A (en) * | 2017-09-26 | 2018-08-24 | 北京中安智达科技有限公司 | A kind of data retrieval method for supporting heterogeneous database |
| CN110032575A (en) * | 2019-04-15 | 2019-07-19 | 网易（杭州）网络有限公司 | Data query method, apparatus, equipment and storage medium |
| CN110232056A (en) * | 2019-05-21 | 2019-09-13 | 苏宁云计算有限公司 | A kind of the blood relationship analytic method and its tool of structured query language |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111259038A (en) * | 2020-01-16 | 2020-06-09 | 北京思特奇信息技术股份有限公司 | Database query and data export method, system, medium and equipment |
| CN111460241A (en) * | 2020-04-26 | 2020-07-28 | 甬矽电子(宁波)股份有限公司 | Data query method and device, electronic equipment and storage medium |
| CN111460241B (en) * | 2020-04-26 | 2024-01-23 | 甬矽电子(宁波)股份有限公司 | Data query method and device, electronic equipment and storage medium |
| CN111897911A (en) * | 2020-06-11 | 2020-11-06 | 中国科学院计算机网络信息中心 | Unstructured data query method and system based on secondary attribute graph |
| CN112035493A (en) * | 2020-07-23 | 2020-12-04 | 北京达佳互联信息技术有限公司 | User attribute data updating method, device, server and storage medium |
| CN113821526A (en) * | 2020-12-23 | 2021-12-21 | 京东科技信息技术有限公司 | Method, device and equipment for querying data and storage medium |
| CN112597186A (en) * | 2020-12-29 | 2021-04-02 | 广州慧智信息科技有限公司 | Data query method, computer equipment and storage medium |
| CN112765286A (en) * | 2021-02-01 | 2021-05-07 | 广州海量数据库技术有限公司 | Query method and device based on relational database |
| CN113779071A (en) * | 2021-09-24 | 2021-12-10 | 北京锐安科技有限公司 | Database query method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110688544A (en) | Method, device and storage medium for querying database | |
| CN110633292B (en) | Query method, device, medium, equipment and system for heterogeneous database | |
| CN110795455B (en) | Dependency analysis method, electronic device, computer apparatus, and readable storage medium | |
| CN109947791B (en) | Database statement optimization method, device, equipment and storage medium | |
| CN109471851B (en) | Data processing method, device, server and storage medium | |
| CN111309760A (en) | Data retrieval method, system, device and storage medium | |
| CN110990406B (en) | Fuzzy query method, device, equipment and medium | |
| CN111078729B (en) | Medical data tracing method, device, system, storage medium and electronic equipment | |
| US10579500B2 (en) | Debugging for SQL statement | |
| CN113901083B (en) | Heterogeneous data source operation resource analysis positioning method and equipment based on multiple resolvers | |
| CN109241100B (en) | Query method, device, equipment and storage medium | |
| CN105760418B (en) | Method and system for performing cross-column search on relational database table | |
| CN110175128B (en) | Similar code case acquisition method, device, equipment and storage medium | |
| CN109033456B (en) | Condition query method and device, electronic equipment and storage medium | |
| CN109543027B (en) | Method, device and equipment for acquiring paging data and storage medium | |
| CN112182637A (en) | Safety control system, method, device and storage medium | |
| CN116502273B (en) | Dynamic data desensitization method, device and equipment based on data blood edges | |
| CN113419740A (en) | Program data stream analysis method and device, electronic device and readable storage medium | |
| CN112487025A (en) | Data query method and device, electronic equipment and storage medium | |
| CN108008947B (en) | Intelligent prompting method and device for programming statement, server and storage medium | |
| CN109542912B (en) | Interval data storage method, device, server and storage medium | |
| CN114547086B (en) | Data processing method, device, equipment and computer readable storage medium | |
| CN113609128A (en) | Method and device for generating database entity class, terminal equipment and storage medium | |
| CN114154468A (en) | Report synthesis method and device, electronic equipment and storage medium | |
| CN114265966A (en) | Data processing method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200114 |