CN112199387A - Method and system for processing database query statement - Google Patents
Method and system for processing database query statement Download PDFInfo
- Publication number
- CN112199387A CN112199387A CN202011279408.9A CN202011279408A CN112199387A CN 112199387 A CN112199387 A CN 112199387A CN 202011279408 A CN202011279408 A CN 202011279408A CN 112199387 A CN112199387 A CN 112199387A
- Authority
- CN
- China
- Prior art keywords
- clause
- database query
- select
- input
- query statement
- 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
- 238000000034 method Methods 0.000 title claims abstract description 27
- 238000013500 data storage Methods 0.000 claims abstract description 30
- 230000018109 developmental process Effects 0.000 claims description 28
- 238000001514 detection method Methods 0.000 claims description 19
- 230000011218 segmentation Effects 0.000 claims description 5
- 238000003672 processing method Methods 0.000 claims 1
- 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
- 101100268665 Caenorhabditis elegans acc-1 gene Proteins 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 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
Abstract
The application discloses a method and a system for processing a database query statement, wherein the method comprises the following steps: acquiring a database query statement from a data source of a development platform, wherein the database query statement comprises a select clause and a from clause; detecting whether the select clause and the from clause accord with a preset arrangement sequence or not; and if not, adjusting the select clause and the from clause according to a preset arrangement sequence, and sending the adjusted database query sentence to a target data storage space for execution. By the method, when a user inputs the database query sentence on the development platform, the input sequence of the select clause and the from clause can be adjusted according to personal use habits to input the database query sentence.
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 statement.
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.
The SQL-based database query statement generally includes a select sub-statement, a from sub-statement, and a where sub-statement, and the standard arrangement order of the select sub-statement, the from sub-statement, and the where sub-statement, when a developer inputs the database query statement composed of the above sub-statements in other orders through a development platform, the database cannot recognize and execute the database query statement.
Disclosure of Invention
The embodiment of the application provides a method and a system for processing a database query statement, so that when a user inputs the database query statement on a development platform, the input sequence of a select clause and a from clause can be adjusted according to personal use habits to input the database query statement.
In a first aspect, an embodiment of the present application provides a method for processing a database query statement, where the method includes the following steps:
acquiring a database query statement from a data source of a development platform, wherein the database query statement comprises a select clause and a from clause;
detecting whether the select clause and the from clause accord with a preset arrangement sequence or not;
and if not, adjusting the select clause and the from clause according to a preset arrangement sequence, and sending the adjusted database query sentence to a target data storage space for execution.
Further, the detecting whether the select clause and the from clause conform to the preset arrangement sequence includes:
segmenting the database query statement according to a preset rule, wherein each segment comprises a clause;
acquiring the arrangement sequence between the segment where the select clause is located and the segment where the from clause is located according to keyword query;
and detecting whether the arrangement sequence between the segment where the select clause is positioned and the segment where the from clause is positioned accords with a preset arrangement sequence.
Further, the method also comprises the following steps:
detecting whether a from word is input into a database operation instruction input box of the development platform;
if so, acquiring the table names of all the data tables in the target data storage space, and outputting a first intelligent prompt comprising the table names of all the data tables in the target data storage space based on the input box, so that a user can select the target data table according to the first intelligent prompt.
Further, the method also comprises the following steps:
detecting whether a select word is input into the input box;
if yes, detecting whether the input box has the from word which is input and the table name of the target data table;
and if the target data table exists, acquiring the display fields of the target data table, and outputting a second intelligent prompt comprising all the display fields based on the input box, so that the user can select the target display fields according to the second intelligent prompt.
Further, still include:
when the fact that subsequent input exists after the select word is input into the input box is detected, the display field in the second intelligent prompt is adjusted to be the display field containing the letters input subsequently.
In a second aspect, an embodiment of the present application provides a system for processing a database query statement, including a data source and a unified database engine, where the unified database engine includes:
the system comprises a statement acquisition module, a statement acquisition module and a statement generation module, wherein the statement acquisition module is used for acquiring a database query statement from a data source of a development platform, and the database query statement comprises a select clause and a from clause;
the first detection module is used for detecting whether the select clause and the from clause accord with a preset arrangement sequence or not;
and the adjusting and sending module is used for adjusting the select clause and the from clause according to a preset arrangement sequence and sending the adjusted database query statement to a target data storage space for execution if the selected clause and the from clause are not in the preset arrangement sequence.
Further, the first detection module comprises:
the segmentation unit is used for segmenting the database query statement according to a preset rule, wherein each segment comprises a clause;
the sequence acquisition unit is used for acquiring the arrangement sequence between the segment where the select clause is located and the segment where the from clause is located according to the keyword query;
and the first detection unit is used for detecting whether the arrangement sequence between the segment where the select clause is positioned and the segment where the from clause is positioned accords with a preset arrangement sequence.
Further, still include the development platform, the development platform includes:
the second detection module is used for detecting whether a from word is input into a database operation instruction input box of the development platform;
and the first prompting module is used for acquiring the table names of all the data tables in the target data storage space if the target data storage space is the target data storage space, and outputting a first intelligent prompt comprising the table names of all the data tables in the target data storage space based on the input box, so that a user can select the target data table according to the first intelligent prompt.
Further, the development platform further comprises:
the third detection module is used for detecting whether a select word is input into the input box;
the fourth detection module is used for detecting whether the input frame has the from word which is input and the table name of the target data table or not;
and the second prompt module is used for acquiring the display fields of the target data table if the target data table exists, and outputting a second intelligent prompt comprising all the display fields based on the input box, so that a user can select the target display fields according to the second intelligent prompt.
Further, still include:
and the display field adjusting module is used for adjusting the display field in the second intelligent prompt to be the display field comprising the subsequently input letters when the fact that the subsequent input exists after the select word is input into the input box is detected.
In the embodiment of the application, after the database query statement is acquired from a data source of a development platform, whether a select clause and a from clause conform to a preset arrangement sequence is detected, if not, the arrangement sequence between the select clause and the from clause is adjusted.
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 statement according to an embodiment of the present application;
FIG. 3 is a flow chart of a method for processing a database query statement according to an embodiment of the present application;
FIG. 4 is a flow chart of a method for processing a database query statement according to an embodiment of the present application;
FIG. 5 is a flowchart of a method for processing a database query statement according to an embodiment of the present application;
fig. 6 is a schematic structural diagram of a system for processing a database query statement 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: the SELECT param FROM table term condition, which can be understood as querying the table for the field param satisfying the condition. However, in practical applications, according to thinking habits, a user usually selects to input a from sub-statement first, determine a table name of a target table to be queried, and then input a select sub-statement to determine a field in the target table, but the database cannot recognize a database query statement formed by the input.
To solve the technical problem, an embodiment of the present application provides a method for processing a database query statement, as shown in fig. 2, in one example, the method includes the following steps:
s201: the method comprises the steps of obtaining a database query statement from a data source of a development platform, wherein the database query statement comprises a select clause and a from clause.
In some examples, the database query statement further includes a condition clause.
S202: and detecting whether the select clause and the from clause accord with a preset arrangement sequence.
In one example, the preset arrangement order is the statements conforming to the SQL standard, and specifically, in the statements conforming to the SQL standard, the select clause is arranged before the from clause.
As shown in fig. 3, in a specific example, it is detected whether the select clause and the from clause conform to the preset arrangement order by the following steps:
s2021: and segmenting the database query statement according to a preset rule, wherein each segment comprises a clause.
Specifically, the keywords such as SELECT, FROM, and condition may be detected, and the keywords may be segmented as a segmentation basis, for example, by detecting the keywords, the FROM table SELECT param WHERE condition of the database query statement may be divided into three sections, i.e., the FROM table, the SELECT param, and the WHERE condition.
S2022: and acquiring the arrangement sequence between the segment where the select clause is positioned and the segment where the from clause is positioned according to the keyword query.
S2023: and detecting whether the arrangement sequence between the segment where the select clause is positioned and the segment where the from clause is positioned accords with a preset arrangement sequence.
After the segmentation, the arrangement order between the segments can be obtained by querying the above-mentioned keyword, and the arrangement order between the segment where the select clause is located and the segment where the from clause is located can be detected according to the arrangement order between the segments, for example, in the above example, it can be detected that the from clause is arranged before the select clause.
S203: and if not, adjusting the select clause and the from clause according to a preset arrangement sequence, and sending the adjusted database query sentence to a target data storage space for execution.
In an example, the foregoing segments may be adjusted to the segments of the select clause and arranged before the segments of the from clause according to a preset arrangement order, and then the segments are recombined into a complete database query statement conforming to the SQL standard and then sent to the target data storage space for execution.
The data storage space may be a database as shown in fig. 1, and in other examples, may also be one of the data table spaces of an oracle database.
In some examples, the steps of the above method for processing the database query statement are implemented by a unified database engine (unified database engine) disposed between the data source DS and the database DB.
In the embodiment of the application, after the database query statement is acquired from a data source of a development platform, whether a select clause and a from clause conform to a preset arrangement sequence is detected, if not, the arrangement sequence between the select clause and the from clause is adjusted.
In an embodiment, as shown in fig. 4, the method for processing the database query statement of the present application further includes the following steps:
s401: detecting whether a from word is input into a database operation instruction input box of the development platform;
s402: if so, acquiring the table names of all the data tables in the target data storage space, and outputting a first intelligent prompt comprising the table names of all the data tables in the target data storage space based on the input box, so that a user can select the target data table according to the first intelligent prompt.
The database operation instruction input box is used for receiving a database operation instruction input by a user, and the database operation instruction comprises a database query statement based on SQL. In the embodiment of the application, as the table names in the database are numerous, in order to facilitate the input of a user, after a from word is detected to be input in the input box, the table names in all target data storage spaces are obtained, and a first intelligent prompt including all the table names is output based on the input box, the first intelligent prompt can be popped out below the input box in the form of a list box, in some preferred examples, the size of the list box can be adjusted, when the number of the table names is large and cannot be displayed together, each table name can be displayed in the list box in the form of a scroll bar, the user can manually input the table names into the input box according to the first intelligent prompt, and can select the table names from the first intelligent prompt through a mouse or a keyboard, so that the selected table names are automatically filled into the input box.
In one example, when a subsequent input is detected after the input box enters the from word, the displayed field in the first smart prompt is adjusted to a displayed field that includes letters of the subsequent input.
For example, if the table names include counting1, counting2, counting3, Employee1, Employee2 and Employee3, after detecting that the input box inputs a from word, the first intelligent prompt displays the above 6 table names, and when detecting that the input box continues to input a letter, ac or the like after the from word, the first intelligent prompt only continues to display three table names including the letter a or ac, acc 1, counting2 and counting 3.
In an embodiment, as shown in fig. 5, the method for processing the database query statement of the present application further includes the following steps:
s501: detecting whether a select word is input into the input box;
s502: if yes, detecting whether the input box has the from word which is input and the table name of the target data table;
s503: and if the target data table exists, acquiring the display fields of the target data table, and outputting a second intelligent prompt comprising all the display fields based on the input box, so that the user can select the target display fields according to the second intelligent prompt.
Further, when it is detected that there is a subsequent input after the select word is input in the input box, the display field in the second intelligent prompt is adjusted to be the display field including the subsequently input letter, and the specific implementation manner and the adjustment manner of the second intelligent prompt may be the same as those in the first intelligent prompt in the foregoing embodiment, and are not described again here.
In the embodiment of the application, when the user inputs the SQL database query statement, the from sub statement can be arranged in front of the select sub statement, so that after a select word is input, the display field name which can be selected by the select sub statement can be obtained according to the table name in the previously input from sub statement, a second intelligent prompt can pop up for the select sub statement, and the user can input the SQL database query statement conveniently.
As shown in fig. 6, fig. 6 is a schematic structural diagram of a system 600 for processing a database query statement according to an embodiment of the present application, and includes a data source DS1 and a unified database engine UDE, where the unified database engine UDE includes:
a statement obtaining module 601, configured to obtain a database query statement from a data source of a development platform, where the database query statement includes a select clause and a from clause;
a first detecting module 602, configured to detect whether the select clause and the from clause conform to a preset ordering sequence;
and an adjusting and sending module 603, configured to adjust the select clause and the from clause according to a preset arrangement order if the query clause and the from clause are not in the preset arrangement order, and send the adjusted database query statement to a target data storage space for execution.
In one embodiment, the first detection module 603 comprises:
the segmentation unit is used for segmenting the database query statement according to a preset rule, wherein each segment comprises a clause;
the sequence acquisition unit is used for acquiring the arrangement sequence between the segment where the select clause is located and the segment where the from clause is located according to the keyword query;
and the first detection unit is used for detecting whether the arrangement sequence between the segment where the select clause is positioned and the segment where the from clause is positioned accords with a preset arrangement sequence.
In one embodiment, the processing system 600 for database query statements further comprises a development platform comprising:
the second detection module is used for detecting whether a from word is input into a database operation instruction input box of the development platform;
and the first prompting module is used for acquiring the table names of all the data tables in the target data storage space if the target data storage space is the target data storage space, and outputting a first intelligent prompt comprising the table names of all the data tables in the target data storage space based on the input box, so that a user can select the target data table according to the first intelligent prompt.
In one embodiment, the development platform further comprises:
the third detection module is used for detecting whether a select word is input into the input box;
the fourth detection module is used for detecting whether the input frame has the from word which is input and the table name of the target data table or not;
and the second prompt module is used for acquiring the display fields of the target data table if the target data table exists, and outputting a second intelligent prompt comprising all the display fields based on the input box, so that a user can select the target display fields according to the second intelligent prompt.
In one embodiment, the processing system 600 for database query statements further comprises:
and the display field adjusting module is used for adjusting the display field in the second intelligent prompt to be the display field comprising the subsequently input letters when the fact that the subsequent input exists after the select word is input into the input box is detected.
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 of a database query statement is characterized by comprising the following steps:
acquiring a database query statement from a data source of a development platform, wherein the database query statement comprises a select clause and a from clause;
detecting whether the select clause and the from clause accord with a preset arrangement sequence or not;
and if not, adjusting the select clause and the from clause according to a preset arrangement sequence, and sending the adjusted database query sentence to a target data storage space for execution.
2. The method for processing a database query statement according to claim 1, wherein the detecting whether the select clause and the from clause conform to a preset arranging order includes:
segmenting the database query statement according to a preset rule, wherein each segment comprises a clause;
acquiring the arrangement sequence between the segment where the select clause is located and the segment where the from clause is located according to keyword query;
and detecting whether the arrangement sequence between the segment where the select clause is positioned and the segment where the from clause is positioned accords with a preset arrangement sequence.
3. The method for processing the database query statement according to claim 1, further comprising the steps of:
detecting whether a from word is input into a database operation instruction input box of the development platform;
if so, acquiring the table names of all the data tables in the target data storage space, and outputting a first intelligent prompt comprising the table names of all the data tables in the target data storage space based on the input box, so that a user can select the target data table according to the first intelligent prompt.
4. The method for processing the database query statement according to claim 3, further comprising the steps of:
detecting whether a select word is input into the input box;
if yes, detecting whether the input box has the from word which is input and the table name of the target data table;
and if the target data table exists, acquiring the display fields of the target data table, and outputting a second intelligent prompt comprising all the display fields based on the input box, so that the user can select the target display fields according to the second intelligent prompt.
5. The method for processing the database query statement according to claim 4, further comprising:
when the fact that subsequent input exists after the select word is input into the input box is detected, the display field in the second intelligent prompt is adjusted to be the display field containing the letters input subsequently.
6. A system for processing a database query statement, comprising a data source and a unified database engine, wherein the unified database engine comprises:
the system comprises a statement acquisition module, a statement acquisition module and a statement generation module, wherein the statement acquisition module is used for acquiring a database query statement from a data source of a development platform, and the database query statement comprises a select clause and a from clause;
the first detection module is used for detecting whether the select clause and the from clause accord with a preset arrangement sequence or not;
and the adjusting and sending module is used for adjusting the select clause and the from clause according to a preset arrangement sequence and sending the adjusted database query statement to a target data storage space for execution if the selected clause and the from clause are not in the preset arrangement sequence.
7. The system for processing a database query statement according to claim 6, wherein the first detection module includes:
the segmentation unit is used for segmenting the database query statement according to a preset rule, wherein each segment comprises a clause;
the sequence acquisition unit is used for acquiring the arrangement sequence between the segment where the select clause is located and the segment where the from clause is located according to the keyword query;
and the first detection unit is used for detecting whether the arrangement sequence between the segment where the select clause is positioned and the segment where the from clause is positioned accords with a preset arrangement sequence.
8. The system for processing a database query statement according to claim 6, further comprising a development platform, the development platform including:
the second detection module is used for detecting whether a from word is input into a database operation instruction input box of the development platform;
and the first prompting module is used for acquiring the table names of all the data tables in the target data storage space if the target data storage space is the target data storage space, and outputting a first intelligent prompt comprising the table names of all the data tables in the target data storage space based on the input box, so that a user can select the target data table according to the first intelligent prompt.
9. The system for processing a database query statement according to claim 8, wherein the development platform further includes:
the third detection module is used for detecting whether a select word is input into the input box;
the fourth detection module is used for detecting whether the input frame has the from word which is input and the table name of the target data table or not;
and the second prompt module is used for acquiring the display fields of the target data table if the target data table exists, and outputting a second intelligent prompt comprising all the display fields based on the input box, so that a user can select the target display fields according to the second intelligent prompt.
10. The system for processing a database query statement according to claim 9, further comprising:
and the display field adjusting module is used for adjusting the display field in the second intelligent prompt to be the display field comprising the subsequently input letters when the fact that the subsequent input exists after the select word is input into the input box is detected.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011279408.9A CN112199387A (en) | 2020-11-16 | 2020-11-16 | Method and system for processing database query statement |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011279408.9A CN112199387A (en) | 2020-11-16 | 2020-11-16 | Method and system for processing database query statement |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112199387A true CN112199387A (en) | 2021-01-08 |
Family
ID=74033105
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011279408.9A Pending CN112199387A (en) | 2020-11-16 | 2020-11-16 | Method and system for processing database query statement |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112199387A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101258496A (en) * | 2005-09-08 | 2008-09-03 | 微软公司 | Autocompleting with queries to a database |
| CN103093000A (en) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | Database query modeling system and database query modeling method |
| CN110858202A (en) * | 2018-08-21 | 2020-03-03 | 北京京东尚科信息技术有限公司 | Method and device for generating where clause in database query statement |
| CN110888876A (en) * | 2019-10-31 | 2020-03-17 | 平安科技（深圳）有限公司 | Method and device for generating database script, storage medium and computer equipment |
| CN110968593A (en) * | 2019-12-10 | 2020-04-07 | 上海达梦数据库有限公司 | Database SQL statement optimization method, device, equipment and storage medium |
| CN110968601A (en) * | 2019-11-28 | 2020-04-07 | 中国银行股份有限公司 | Data query processing method and device |
-
2020
- 2020-11-16 CN CN202011279408.9A patent/CN112199387A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101258496A (en) * | 2005-09-08 | 2008-09-03 | 微软公司 | Autocompleting with queries to a database |
| CN103093000A (en) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | Database query modeling system and database query modeling method |
| CN110858202A (en) * | 2018-08-21 | 2020-03-03 | 北京京东尚科信息技术有限公司 | Method and device for generating where clause in database query statement |
| CN110888876A (en) * | 2019-10-31 | 2020-03-17 | 平安科技（深圳）有限公司 | Method and device for generating database script, storage medium and computer equipment |
| CN110968601A (en) * | 2019-11-28 | 2020-04-07 | 中国银行股份有限公司 | Data query processing method and device |
| CN110968593A (en) * | 2019-12-10 | 2020-04-07 | 上海达梦数据库有限公司 | Database SQL statement optimization method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20200257543A1 (en) | Aggregate Features For Machine Learning | |
| CN106649742B (en) | Database maintenance method and device | |
| CN105989040B (en) | Intelligent question and answer method, device and system | |
| US8886648B1 (en) | System and method for computation of document similarity | |
| US20200242140A1 (en) | Method, apparatus, device and medium for determining text relevance | |
| US20160275148A1 (en) | Database query method and device | |
| US20160350404A1 (en) | Technologies for dynamic automated content discovery | |
| US20170364495A1 (en) | Propagation of changes in master content to variant content | |
| CN110795524B (en) | Main data mapping processing method and device, computer equipment and storage medium | |
| US20180300296A1 (en) | Document similarity analysis | |
| CN109906450A (en) | For the method and apparatus by similitude association to electronic information ranking | |
| US20210110111A1 (en) | Methods and systems for providing universal portability in machine learning | |
| US8458196B1 (en) | System and method for determining topic authority | |
| JP2016038788A (en) | Retrieval support program, retrieval support method, retrieval support device, and response method | |
| US11783129B2 (en) | Interactive control system, interactive control method, and computer program product | |
| US20230186212A1 (en) | System, method, electronic device, and storage medium for identifying risk event based on social information | |
| CN112286958A (en) | Processing method and system for database query expression | |
| US8756236B1 (en) | System and method for indexing documents | |
| JP2016110256A (en) | Information processing device and information processing program | |
| CN109033082B (en) | Learning training method and device of semantic model and computer readable storage medium | |
| CN112199387A (en) | Method and system for processing database query statement | |
| CN110019783B (en) | Attribute word clustering method and device | |
| US10296585B2 (en) | Assisted free form decision definition using rules vocabulary | |
| WO2019231635A1 (en) | Method and apparatus for generating digest for broadcasting | |
| CN115208923A (en) | Equipment information determination method, device and equipment |
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 |