CN112286958A - Processing method and system for database query expression - Google Patents
Processing method and system for database query expression Download PDFInfo
- Publication number
- CN112286958A CN112286958A CN202011278301.2A CN202011278301A CN112286958A CN 112286958 A CN112286958 A CN 112286958A CN 202011278301 A CN202011278301 A CN 202011278301A CN 112286958 A CN112286958 A CN 112286958A
- Authority
- CN
- China
- Prior art keywords
- database query
- target
- operand
- expression
- query expression
- 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.)
- Granted
Links
- 230000014509 gene expression Effects 0.000 title claims abstract description 117
- 238000003672 processing method Methods 0.000 title claims description 3
- 238000000034 method Methods 0.000 claims abstract description 29
- 238000012545 processing Methods 0.000 claims abstract description 24
- 238000013500 data storage Methods 0.000 claims abstract description 17
- 238000004458 analytical method Methods 0.000 claims description 4
- 238000001514 detection method Methods 0.000 claims description 4
- 238000011161 development Methods 0.000 abstract description 20
- 238000010586 diagram Methods 0.000 description 11
- 238000004590 computer program Methods 0.000 description 6
- 238000012986 modification Methods 0.000 description 5
- 230000004048 modification Effects 0.000 description 5
- 230000004044 response Effects 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24564—Applying rules; Deductive queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/30—Semantic analysis
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Mathematical Physics (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a method and a system for processing a database query expression, wherein the method comprises the following steps: acquiring a database query expression from a database query statement of a data source, wherein the database query expression comprises an operational character and an operand; detecting whether the operational character is a preset general operational character, and if so, acquiring the format of the operational character; determining a first target operational character corresponding to the format of an operand according to a preset corresponding rule; and generating a first target database query expression according to the first target operational character and the operand, generating a first target database query statement according to the first target database query expression, and sending the first target database query statement to the target data storage space for execution. The method enables the user to input the database query expression more conveniently, and the development platform does not need to provide different query interfaces for different operators, thereby reducing the development difficulty of the query interfaces.
Description
Technical Field
The present application relates to the field of database application technologies, and in particular, to a method and a system for processing a database query expression.
Background
With the increase of internet-based related services, Platform as a Service (PaaS) is a business model in which a server Platform is provided as a Service, and a Platform for Software development is submitted to developers as a Service in a SaaS (Software as a Service) model.
SQL, a Structured Query Language, is a special-purpose programming Language, a database Query and programming Language, used to access data and Query, update, and manage relational database systems.
In practical application, a development platform provides a query interface of a database for a user to select or input a query expression, and different query interfaces aiming at different operators are required to be provided for the user according to different operators in the expression, so that the development difficulty of the query interface is increased.
Disclosure of Invention
The embodiment of the application provides a method and a system for processing a database query expression, so that a user can input the database query expression more conveniently, a development platform does not need to provide different query interfaces for different operators, and the development difficulty of the query interfaces is reduced.
In a first aspect, an embodiment of the present application provides a method for processing a database query expression, where the method includes the following steps:
acquiring a database query expression from a database query statement of a data source, wherein the database query expression comprises an operational character and an operand;
detecting whether the operator is a preset general operator or not, and if so, acquiring the format of the operand;
determining a first target operational character corresponding to the format of the operand according to a preset corresponding rule;
generating a first target database query expression according to the first target operational character and the operand, generating a first target database query statement according to the first target database query expression, and sending the first target database query statement to a target data storage space for execution.
Further, when the operand includes a semantic parameter, the method further includes the following steps:
analyzing the semantic parameters to obtain second target operational characters corresponding to the semantic parameters;
and generating a second target database query expression according to the second target operational character and the parameter value in the operand, generating a second target database query statement according to the second target database query expression, and sending the second target database query statement to a target data storage space for execution.
Further, the format of the operand includes at least one of:
one or more parameter values; at least one parameter value and at least one operator and their arrangement rules.
Further, the method also comprises the following steps:
removing the restriction of the database expression from the database query statement when the operand is null or the operand indicates a null value.
Further, the method also comprises the following steps:
and pushing the first target database query statement to a user.
In a second aspect, an embodiment of the present application provides a system for processing a database query expression, including:
the query expression acquisition module is used for acquiring a database query expression from a database query statement of a data source, wherein the database query expression comprises an operational character and an operand;
the detection module is used for detecting whether the operational character is a preset general operational character or not, and if so, acquiring the format of the operational character;
the target operational character determining module is used for determining a first target operational character corresponding to the format of the operand according to a preset corresponding rule;
and the first expression generation module is used for generating a first target database query expression according to the first target operational character and the operand, generating a first target database query statement according to the first target database query expression, and sending the first target database query statement to a target data storage space for execution.
Further, when the operand includes a semantic parameter, the system further includes:
the analysis module is used for analyzing the semantic parameters to obtain second target operational characters corresponding to the semantic parameters;
and the second expression generation module is used for generating a second target database query expression according to the second target operational character and the parameter value in the operand, generating a second target database query statement according to the second target database query expression, and sending the second target database query statement to a target data storage space for execution.
Further, the format of the operand includes at least one of:
one or more parameter values; an arrangement rule of at least one parameter value and at least one operator.
Further, still include:
a cancellation module, configured to cancel the restriction of the database expression from the database query statement when the operand is a null value or the operand indicates a null value.
Further, still include:
and the pushing module is used for pushing the first target database query statement to a user.
In the embodiment of the application, after the query statement of the database is obtained from the data source of the development platform, the query expression is obtained, when the operational character in the query expression is detected to be a preset general operational character, the first target operational character is determined according to the format of the operational character, the first target database query expression is generated according to the first target operational character, and the first target database query statement is further regenerated, so that a user can input the query expression of the database more conveniently, the development platform does not need to provide different query interfaces for different operational characters, and the development difficulty of the query interfaces is reduced.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings needed to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present application, and it is obvious for those skilled in the art to obtain other drawings based on these drawings without creative efforts.
FIG. 1 is a schematic diagram of a data storage architecture of a development platform in the art;
FIG. 2 is a flow chart of a method for processing a database query expression according to an embodiment of the present application;
FIG. 3 is a flow chart of a method for processing a database query expression according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of a system for processing a database query expression according to an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are some embodiments of the present application, but not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The terminology used in the embodiments of the present application is for the purpose of describing particular embodiments only and is not intended to be limiting of the application. As used in the examples of this application and the appended claims, the singular forms "a", "an", and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise, and "a plurality" typically includes at least two.
The words "if", as used herein, may be interpreted as "at … …" or "at … …" or "in response to a determination" or "in response to a detection", depending on the context. Similarly, the phrases "if determined" or "if detected (a stated condition or event)" may be interpreted as "when determined" or "in response to a determination" or "when detected (a stated condition or event)" or "in response to a detection (a stated condition or event)", depending on the context.
Fig. 1 is a schematic diagram of a Data storage architecture of a development platform in the technology, in fig. 1, a development platform 10 is configured with a Data source DS (Data source) and a database DB1(Data Base), after a user inputs an SQL-based database query statement, the Data source DS routes the database query statement to a database DB1, so that the database DB1 executes the database query language.
SQL-based database query statements typically include a select sub-statement, a from sub-statement, and a where sub-statement, with the standard order of arrangement being the select sub-statement, the from sub-statement, and the where sub-statement. For example, in one example, the database query statement is: select param from table condition, which can be understood as querying the table for the field param satisfying the condition.
The where sub-statement comprises a database query expression and is used for setting a screening condition on a field specified by a select sub-statement in a data table specified by the from sub-statement so as to eliminate unnecessary redundant data and obtain required data.
The query expression of the where sub-statement usually consists of a ternary expression, which usually includes three parameters, i.e., operator and operand, for example, the database query statement select from products _ tbl where pro _ ID is '119', which means all data of the query table ' products _ tbl ' where pro _ ID ' is '119', and the query expression is: pro _ ID ═ 119', where' pro _ ID 'is the operator,' is the operator, '119' is the operand.
In practical application, a development platform provides a query interface of a database for a user to select or input a query expression, and different query interfaces aiming at different operators are required to be provided for the user according to different operators in the expression, so that the development difficulty of the query interface is increased.
In view of this technical problem, the present application provides a method for processing a database query expression, which is applicable to the development platform in fig. 1, and in other examples, the method is also applicable to any scenario where a database is queried through a database query language.
As shown in fig. 2, in one example, the method includes the steps of:
s201: the method comprises the steps of obtaining a database query expression from a database query statement of a data source, wherein the database query expression comprises an operator and an operand.
In some examples, the database query statement is a statement based on the SQL standard, and in an embodiment of the present application, the database query statement includes a database query expression, and the database query expression is used to indicate a filtering condition in the database query statement, and in some examples, the database query expression further includes an operator, and the filtering condition is that a relationship between the operator and an operand is the same as the operator.
In this embodiment of the present application, the database query statement of the data source may be obtained by: a user inputs a query condition in a database query page provided by a user terminal or the development platform in fig. 1, and the user terminal or the development platform generates a database query statement according to the query condition input by the user and sends the database query statement to a data source.
S202: and detecting whether the operator is a preset general operator, and if so, acquiring the format of the operand.
S203: and determining a first target operator corresponding to the format of the operand according to a preset corresponding rule.
S204: and generating a first target database query expression according to the first target operational character and the operand, and sending the first target database query statement to a target data storage space for execution.
The general operator is a preset operator different from the conventional operator, and may be in any format, for example, ' - ', or, ' #, ', etc., and when it is detected that the operator is not the preset general operator but the conventional operator, for example, ' < >, ' < ' >, etc., the following steps of the unapplied method are not performed, and the database query statement is directly sent to the target data storage space for execution.
In the embodiment of the application, target operators corresponding to different operand formats are preset, and when a user does not determine how to use the operators or selects to use common operators for more convenient input, the first operator required by the user can be determined by detecting the operand format.
In conventional inputs, the operand is typically one or more parameter values, e.g., 100 in the statement select from products _ tbl where pro _ ID > -100 ', 100 AND 200 in the statement select from products _ tbl where pro _ ID > -100' AND < '200'. In the embodiment of the present application, the operand includes not only one or more parameter values, but also different formats, and the operators corresponding to operands in different formats are preset, and when the user inputs the operand according to the set format, the method of the embodiment of the present application may determine the first target operator corresponding to the operand according to the preset rule.
In one specific example, the operand may be composed of parameter values and operand symbols, and the format of the operand may include at least one of: one or more parameter values; at least one parameter value and at least one operator and their arrangement rules. In other examples, the operand may be composed of a parameter value and other values and characters.
The following description is given by way of example with operands consisting of parameter values and operand symbols:
when the operand includes a parameter value, for example in the expression pro _ ID ═ 119', then the first target operator may be ' ═ and the first target database query expression pro _ ID ═ 119 '. If the operand includes a parameter value, but the parameter value includes a wildcard, for example in the expression pro _ ID ═ 11% ', the first target operator may be ' LIKE ', and the first target database query expression is pro _ ID ' 11% '.
When the operand includes multiple parameter values, for example IN the expression pro _ ID ═ 119, 120,121 ' ″, then the first target operator may be ' IN ', indicating a comparison match of the value of pro _ ID against the values of a specified list, and the first target database query expression is pro _ ID IN ' [119, 120,121] '.
When the operand comprises parameter values and operators, the format of the operand comprises parameter values and different operators, or arrangement rules of the parameter values and the different operators.
In a specific example, when the parameter value is matched with the operator 'to', the parameter value may have an operand format such as '119 to', in the expression pro _ ID ═ 119, the first target operator may be '> ═ and the first target database query expression is pro _ ID > -'. In the expression pro _ ID ═ 119', the first target operator may be' ═ and the first target database query expression pro _ ID ═ 119 ·. In the expression pro _ ID ═ 110 to 119', the first target operator is ' betweeen ', AND the first target database query expression is pro _ ID betweeen 110AND 119. In the expression pro _ ID ═ 110 to >119', the first target operators include' > ═ AND '<', AND the first target database query expression is pro _ ID > ═ 110AND < 119. In the expression pro _ ID ═ 110< -119 ', the first target operators include ' < ═ AND ' >, AND the first target database query expression is pro _ ID >110AND ═ 119.
In some examples, the steps of the above method for processing the database query expression are implemented by a unified database engine (unified database engine) disposed between the data source DS and the database DB.
In some examples, the data storage space includes a data table space of a database or an oracle database.
In the embodiment of the application, after the query statement of the database is obtained from the data source of the development platform, the query expression is obtained, when the operational character in the query expression is detected to be a preset general operational character, the first target operational character is determined according to the format of the operational character, the first target database query expression is generated according to the first target operational character, and the first target database query statement is further regenerated, so that a user can input the query expression of the database more conveniently, the development platform does not need to provide different query interfaces for different operational characters, and the development difficulty of the query interfaces is reduced.
In an embodiment, in order to facilitate the input of the user, the database query expression of the present application may further support the user to directly input the semantic parameter, as shown in fig. 3, when it is detected that the operand includes the semantic parameter, the method for processing the database query expression of the present application further includes the following steps:
s301: analyzing the semantic parameters to obtain second target operational characters corresponding to the semantic parameters;
s302: and generating a second target database query expression according to the second target operational character and the parameter value in the operand, and sending the second target database query expression to the target data storage space for execution.
Specifically, when the format of the operand is detected, in addition to detecting the parameter value and the operator in the operand, when a word is detected in the operand, semantic analysis is performed on the word to determine whether the word is a semantic parameter related to the operator, specifically, whether the semantic of the word includes a corresponding operator to determine whether the word is the semantic parameter, and when the operand includes the semantic parameter, a second target operator corresponding to the semantic parameter can be obtained by analyzing the semantic parameter.
In another example, when the query statement of the database does not need the database expression to define the query condition, the method for processing the database query expression of the present application further includes the following steps:
removing the restriction of the database expression from the database query statement when the operand is null or the operand indicates a null value.
In particular, the null value may be without any input, e.g., pro _ ID ═ g. The indication control may indicate in a preset manner, for example, pro _ ID ═ NULL'.
In one example, after the first target database query statement or the second target database query statement is obtained, the statement is pushed to the user, so that the user can intuitively determine whether the correct operand is input.
As shown in fig. 4, fig. 4 is a schematic structural diagram of a system 400 for processing a database query expression according to an embodiment of the present application, including:
a query expression obtaining module 401, configured to obtain a database query expression from a database query statement of a data source, where the database query expression includes an operator and an operand;
a detecting module 402, configured to detect whether the operator is a preset general operator, and if so, obtain a format of the operand;
a target operator determining module 403, configured to determine, according to a preset correspondence rule, a first target operator corresponding to a format of the operand;
a first expression generating module 404, configured to generate a first target database query expression according to the first target operator and the operand, generate a first target database query statement according to the first target database query expression, and send the first target database query statement to a target data storage space for execution.
In one embodiment, when the operand includes a semantic parameter, the system further comprises:
the analysis module is used for analyzing the semantic parameters to obtain second target operational characters corresponding to the semantic parameters;
and the second expression generation module is used for generating a second target database query expression according to the second target operational character and the parameter value in the operand, generating a second target database query statement according to the second target database query expression, and sending the second target database query statement to a target data storage space for execution.
In one embodiment, the format of the operand includes at least one of:
one or more parameter values; an arrangement rule of at least one parameter value and at least one operator.
In one embodiment, the system further comprises:
a cancellation module, configured to cancel the restriction of the database expression from the database query statement when the operand is a null value or the operand indicates a null value.
In one embodiment, the method further comprises:
and the pushing module is used for pushing the first target database query statement to a user.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
While the preferred embodiments of the present application have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all alterations and modifications as fall within the scope of the application.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present application without departing from the spirit and scope of the application. Thus, if such modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is intended to include such modifications and variations as well.
Claims (10)
1. A processing method for database query expressions is characterized by comprising the following steps:
acquiring a database query expression from a database query statement of a data source, wherein the database query expression comprises an operational character and an operand;
detecting whether the operator is a preset general operator or not, and if so, acquiring the format of the operand;
determining a first target operational character corresponding to the format of the operand according to a preset corresponding rule;
generating a first target database query expression according to the first target operational character and the operand, generating a first target database query statement according to the first target database query expression, and sending the first target database query statement to a target data storage space for execution.
2. The method for processing the database query expression according to claim 1, wherein when the operand includes the semantic parameter, the method further comprises the following steps:
analyzing the semantic parameters to obtain second target operational characters corresponding to the semantic parameters;
and generating a second target database query expression according to the second target operational character and the parameter value in the operand, generating a second target database query statement according to the second target database query expression, and sending the second target database query statement to a target data storage space for execution.
3. The method of claim 1, wherein the format of the operand comprises at least one of:
one or more parameter values; at least one parameter value and at least one operator and their arrangement rules.
4. The method for processing the database query expression according to claim 1, further comprising the steps of:
removing the restriction of the database expression from the database query statement when the operand is null or the operand indicates a null value.
5. The method for processing the database query expression according to claim 1, further comprising the steps of:
and pushing the first target database query statement to a user.
6. A system for processing database query expressions, comprising:
the query expression acquisition module is used for acquiring a database query expression from a database query statement of a data source, wherein the database query expression comprises an operational character and an operand;
the detection module is used for detecting whether the operational character is a preset general operational character or not, and if so, acquiring the format of the operational character;
the target operational character determining module is used for determining a first target operational character corresponding to the format of the operand according to a preset corresponding rule;
and the first expression generation module is used for generating a first target database query expression according to the first target operational character and the operand, generating a first target database query statement according to the first target database query expression, and sending the first target database query statement to a target data storage space for execution.
7. The system for processing a database query expression of claim 6, wherein when the operand includes a semantic parameter, the system further comprises:
the analysis module is used for analyzing the semantic parameters to obtain second target operational characters corresponding to the semantic parameters;
and the second expression generation module is used for generating a second target database query expression according to the second target operational character and the parameter value in the operand, generating a second target database query statement according to the second target database query expression, and sending the second target database query statement to a target data storage space for execution.
8. The system for processing a database query expression of claim 6, wherein the format of the operands comprises at least one of:
one or more parameter values; an arrangement rule of at least one parameter value and at least one operator.
9. The system for processing database query expressions according to claim 6, further comprising:
a cancellation module, configured to cancel the restriction of the database expression from the database query statement when the operand is a null value or the operand indicates a null value.
10. The system for processing a database query expression of claim 9, further comprising:
and the pushing module is used for pushing the first target database query statement to a user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011278301.2A CN112286958B (en) | 2020-11-16 | 2020-11-16 | Processing method and system for database query expression |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011278301.2A CN112286958B (en) | 2020-11-16 | 2020-11-16 | Processing method and system for database query expression |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112286958A true CN112286958A (en) | 2021-01-29 |
| CN112286958B CN112286958B (en) | 2024-05-17 |
Family
ID=74398991
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011278301.2A Active CN112286958B (en) | 2020-11-16 | 2020-11-16 | Processing method and system for database query expression |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112286958B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113542245A (en) * | 2021-07-02 | 2021-10-22 | 广州华多网络科技有限公司 | Data flow monitoring method and device, computer equipment and storage medium |
| CN113609154A (en) * | 2021-08-06 | 2021-11-05 | 网易（杭州）网络有限公司 | Data query method and device, electronic equipment and storage medium |
| CN117591547A (en) * | 2024-01-18 | 2024-02-23 | 中昊芯英(杭州)科技有限公司 | Database query method and device, terminal equipment and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108804554A (en) * | 2018-05-22 | 2018-11-13 | 上海达梦数据库有限公司 | A kind of data base query method, device, server and storage medium |
| CN109241095A (en) * | 2018-07-13 | 2019-01-18 | 网宿科技股份有限公司 | A kind of method for quickly querying, terminal and can storage medium |
| CN110362593A (en) * | 2019-07-11 | 2019-10-22 | 上海达梦数据库有限公司 | A kind of data query method, apparatus, equipment and storage medium |
| CN110858202A (en) * | 2018-08-21 | 2020-03-03 | 北京京东尚科信息技术有限公司 | Method and device for generating where clause in database query statement |
| CN110866028A (en) * | 2019-10-10 | 2020-03-06 | 微梦创科网络科技（中国）有限公司 | SQL instruction generation method and system |
| CN111159330A (en) * | 2018-11-06 | 2020-05-15 | 阿里巴巴集团控股有限公司 | Database query statement generation method and device |
| CN111460241A (en) * | 2020-04-26 | 2020-07-28 | 甬矽电子(宁波)股份有限公司 | Data query method and device, electronic equipment and storage medium |
-
2020
- 2020-11-16 CN CN202011278301.2A patent/CN112286958B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108804554A (en) * | 2018-05-22 | 2018-11-13 | 上海达梦数据库有限公司 | A kind of data base query method, device, server and storage medium |
| CN109241095A (en) * | 2018-07-13 | 2019-01-18 | 网宿科技股份有限公司 | A kind of method for quickly querying, terminal and can storage medium |
| CN110858202A (en) * | 2018-08-21 | 2020-03-03 | 北京京东尚科信息技术有限公司 | Method and device for generating where clause in database query statement |
| CN111159330A (en) * | 2018-11-06 | 2020-05-15 | 阿里巴巴集团控股有限公司 | Database query statement generation method and device |
| CN110362593A (en) * | 2019-07-11 | 2019-10-22 | 上海达梦数据库有限公司 | A kind of data query method, apparatus, equipment and storage medium |
| CN110866028A (en) * | 2019-10-10 | 2020-03-06 | 微梦创科网络科技（中国）有限公司 | SQL instruction generation method and system |
| CN111460241A (en) * | 2020-04-26 | 2020-07-28 | 甬矽电子(宁波)股份有限公司 | Data query method and device, electronic equipment and storage medium |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113542245A (en) * | 2021-07-02 | 2021-10-22 | 广州华多网络科技有限公司 | Data flow monitoring method and device, computer equipment and storage medium |
| CN113609154A (en) * | 2021-08-06 | 2021-11-05 | 网易（杭州）网络有限公司 | Data query method and device, electronic equipment and storage medium |
| CN113609154B (en) * | 2021-08-06 | 2023-08-29 | 网易（杭州）网络有限公司 | Data query method and device, electronic equipment and storage medium |
| CN117591547A (en) * | 2024-01-18 | 2024-02-23 | 中昊芯英(杭州)科技有限公司 | Database query method and device, terminal equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112286958B (en) | 2024-05-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112286958B (en) | Processing method and system for database query expression | |
| CN110908997B (en) | Data blood relationship construction method and device, server and readable storage medium | |
| US8661023B1 (en) | Optimizing search query logic to speed retrieval | |
| CN110795455A (en) | Dependency relationship analysis method, electronic device, computer device and readable storage medium | |
| US9355152B2 (en) | Non-exclusionary search within in-memory databases | |
| CN113641701B (en) | Data query method, system, heterogeneous acceleration platform and storage medium | |
| KR102196976B1 (en) | Method and apparatus for generating natural output based on natural language user interface input | |
| CN112015722A (en) | Database management method, data blood relationship analysis method and related device | |
| CN111427784B (en) | Data acquisition method, device, equipment and storage medium | |
| CN111767320A (en) | Data blood relationship determination method and device | |
| CN110895537A (en) | Method and device for freely inquiring authority control | |
| CN114969819A (en) | Data asset risk discovery method and device | |
| KR20230129555A (en) | Join JavaScript object notation (JSON) queries for cloud resources | |
| CN112182637A (en) | Safety control system, method, device and storage medium | |
| CA2651461A1 (en) | Relationship management for data modeling in an integrated development environment | |
| US9037752B1 (en) | Remote materialization of low velocity data | |
| CN111026574A (en) | Method and device for diagnosing Elasticissearch cluster problems | |
| CN114896269A (en) | Structured query statement detection method and device, electronic equipment and storage medium | |
| CN112765200A (en) | Data query method and device based on Elasticissearch | |
| CN117407430B (en) | Data query method, device, computer equipment and storage medium | |
| CN115952203B (en) | Data query method, device, system and storage medium | |
| US20140115000A1 (en) | Boolean content search | |
| CN117290883A (en) | Real-time dynamic desensitization method, system and equipment based on field-level blood margin | |
| CN112199387A (en) | Method and system for processing database query statement | |
| CN118296026A (en) | Data query method, device, computer 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |