CN107391739A - A kind of query statement generation method, device and electronic equipment - Google Patents
A kind of query statement generation method, device and electronic equipment Download PDFInfo
- Publication number
- CN107391739A CN107391739A CN201710667798.9A CN201710667798A CN107391739A CN 107391739 A CN107391739 A CN 107391739A CN 201710667798 A CN201710667798 A CN 201710667798A CN 107391739 A CN107391739 A CN 107391739A
- Authority
- CN
- China
- Prior art keywords
- target
- field
- data
- tables
- default
- 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
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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- 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/2453—Query optimisation
Abstract
The embodiments of the invention provide a kind of query statement generation method, device and electronic equipment, methods described includes：The Query Information of user's input is obtained, wherein, the Query Information includes：Target data source and target field to be checked；According to the matching relationship of default data source and tables of data, obtain the target matrix matched in database with target data source, according to the matching relationship of field in default field to be checked and tables of data, the aiming field with target fields match to be checked in the target matrix is obtained；Default query statement generating structure is filled with the target matrix and the aiming field, generates target query sentence.When carrying out query statement generation using technical scheme provided in an embodiment of the present invention, the efficiency of generation query statement is improved.
Description
Technical field
The present invention relates to software technology field, more particularly to a kind of query statement generation method, device and electronic equipment.
Background technology
Query statement is mainly used in administrative relationships type Database Systems, can be to the data in database using query statement
Enter the operation such as line access, inquiry, renewal.Common query statement includes：SQL (Structured Query Language, knot
Structure query language) and class SQL data query languages.Class SQL data query languages refer to such as HiveQL (hive
Structured Query Language, hive SQL) etc. the complete SQL query function of offer language.With
The continuous development of relevant database, increasing data analyst needs to use query statement to carry out pipe to database
Reason.
At present, the mode for generating query statement is mainly the mode of manual compiling code, thus, data analyst needs
While business is understood, it is necessary to the table structure of relevant database is understood, when table structural adjustment, it is also desirable to which the very first time will
Table structure synchronization after adjustment, so that data analyst writes out rational query statement, therefore, is to data analyst
The rational query statement of generation, data analyst need to put into larger energy and time, cause to write query statement
It is inefficient.
The content of the invention
The purpose of the embodiment of the present invention is to provide a kind of query statement generation method, device and electronic equipment, to realize
Improve the efficiency of generation query statement.Concrete technical scheme is as follows：
In a first aspect, the embodiments of the invention provide a kind of query statement generation method, methods described includes：
The Query Information of user's input is obtained, wherein, the Query Information includes：Target data source and target are to be checked
Field；
According to the matching relationship of default data source and tables of data, obtain what is matched in database with the target data source
Target matrix, according to the matching relationship of field in default field to be checked and tables of data, obtain in the target matrix
With the aiming field of target fields match to be checked；
Default query statement generating structure is filled with the target matrix and the aiming field, generation target is looked into
Ask sentence.
Optionally, the matching relationship according to default data source and tables of data, obtain database in the target
The target matrix of data source matching, including：
According to default data source and tables of data ID matching relationship, obtain and matched in database with the target data source
Tables of data ID, using tables of data corresponding to the tables of data ID as target matrix；
The matching relationship according to field in default field to be checked and tables of data, obtain in the target matrix
With the aiming field of target fields match to be checked, including：
According to the matching relationship of Field ID in default field to be checked and tables of data, obtain in the target matrix with
The Field ID of the target fields match to be checked, using field corresponding to the Field ID as aiming field.
Optionally, default query statement generating structure is being filled with the target matrix and the aiming field,
Before the step of generating target query sentence, methods described also includes：
Judge whether the aiming field associates the first tables of data, wherein, first tables of data is except target matrix
Tables of data in addition；
If it is, obtaining first tables of data, and the aiming field is based on, to the target matrix and described
First tables of data is associated processing；
It is described to fill default query statement generating structure with the target matrix and the aiming field, generate mesh
Query statement is marked, including：
Filled with the target matrix after association process, first tables of data and the aiming field default
Query statement generating structure, generate target query sentence.
Optionally, default query statement generating structure is being filled with the target matrix and the aiming field,
Before the step of generating target query sentence, methods described also includes：
Judge whether the aiming field meets optimal conditions；
If it is, using default optimization processing algorithm, processing is optimized to the aiming field；
It is described to fill default query statement generating structure with the target matrix and the aiming field, generate mesh
Query statement is marked, including：
Default query statement generating structure is filled with the aiming field after the target matrix and optimization processing, it is raw
Into target query sentence.
Optionally, the Query Information also includes the condition that target field to be checked meets；
Default query statement generating structure is being filled with the target matrix and the aiming field, is generating target
Before the step of query statement, methods described also includes：
Judge whether the condition of target field satisfaction to be checked meets the goal condition in preparatory condition table；
If it is, execution is described to fill default query statement life with the target matrix and the aiming field
Into structure, the step of generating target query sentence.
Optionally, the mesh in whether the condition for judging that target field to be checked meets meets preparatory condition table
After the step of mark condition, methods described also includes：
If the condition that the target field to be checked meets does not meet goal condition, Query Information described in feedback representation has
Prompt message by mistake.
Second aspect, the embodiments of the invention provide a kind of query statement generating means, described device includes：
Transceiver module, for obtaining the Query Information of user's input, wherein, the Query Information includes：Target data source
And target field to be checked；
Processing module, for the matching relationship according to default data source and tables of data, obtain in database with the mesh
The target matrix of data source matching is marked, according to the matching relationship of field in default field to be checked and tables of data, obtains institute
State the aiming field with target fields match to be checked in target matrix；With the target matrix and the target
Field fills default query statement generating structure, generates target query sentence.
Optionally, the processing module, is additionally operable to：
According to default data source and tables of data ID matching relationship, obtain and matched in database with the target data source
Tables of data ID, using tables of data corresponding to the tables of data ID as target matrix；According to default field to be checked and number
According to the matching relationship of Field ID in table, the Field ID with target fields match to be checked in the target matrix is obtained,
Using field corresponding to the Field ID as aiming field.
Optionally, the processing module also includes：
First judging submodule, for filling default inquiry language with the target matrix and the aiming field
Sentence generating structure, before generating target query sentence, judges whether the aiming field associates the first tables of data, wherein, it is described
First tables of data is the tables of data in addition to target matrix；
Submodule is obtained, for when the judged result of first judging submodule is is, obtaining first data
Table, and the aiming field is based on, processing is associated to the target matrix and first tables of data；
The processing module, it is additionally operable to the target matrix after association process, first tables of data and institute
State aiming field and fill default query statement generating structure, generate target query sentence.
Optionally, the processing module also includes：
Second judging submodule, for filling default inquiry language with the target matrix and the aiming field
Sentence generating structure, before generating target query sentence, judges whether the aiming field meets optimal conditions；
Optimize submodule, for second judging submodule judged result for be when, at default optimization
Adjustment method, processing is optimized to the aiming field；
The processing module, it is additionally operable to default with the aiming field filling after the target matrix and optimization processing
Query statement generating structure, generate target query sentence.
Optionally, the Query Information also includes the condition that target field to be checked meets, the processing module is also
Including：
3rd judging submodule, for filling default inquiry language with the target matrix and the aiming field
Sentence generating structure, before generating target query sentence, it is default to judge whether condition that target field to be checked meets meets
Goal condition in condition table；
Implementation sub-module, for when the judged result of the 3rd judging submodule is is, performing the mesh
Mark tables of data and the aiming field and fill default query statement generating structure, the step of generating target query sentence.
Optionally, the processing module also includes：
Submodule is fed back, for whether meeting in preparatory condition table in the condition for judging target field satisfaction to be checked
Goal condition after, if the condition that target field to be checked meets does not meet goal condition, looked into described in feedback representation
Ask the wrong prompt message of information.
At the another aspect that the present invention is implemented, a kind of computer-readable recording medium is additionally provided, it is described computer-readable
Instruction is stored with storage medium, when run on a computer so that computer performs above-mentioned query statement generation side
Method.
At the another aspect that the present invention is implemented, the embodiment of the present invention additionally provides a kind of computer program production comprising instruction
Product, when run on a computer so that computer performs above-mentioned query statement generation method.
It can be seen that when carrying out query statement generation using technical scheme provided in an embodiment of the present invention, it is defeated user can be obtained
Target data source and the target field to be checked entered；And then using the matching relationship of default data source and tables of data, obtain
The target matrix matched with the target data source, and closed using the matching of default field to be checked and field in tables of data
System, obtain the aiming field with target fields match to be checked；Finally, filled with the target matrix and the aiming field
Default query statement generating structure, target query sentence is generated, instead of in the prior art by manual compiling code building
The mode of query statement, so as to improve the efficiency for generating query statement.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described.
Fig. 1 is a kind of schematic flow sheet of query statement generation method provided in an embodiment of the present invention；
Fig. 2 is a kind of flow chart of user input query information provided in an embodiment of the present invention；
Fig. 3 is a kind of structural representation of query statement generating means provided in an embodiment of the present invention；
Fig. 4 is the structural representation of another query statement generating means provided in an embodiment of the present invention；
Fig. 5 is the structural representation of a kind of electronic equipment provided in an embodiment of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is described.
In order to solve the problems, such as to write the inefficient of query statement in the prior art, the embodiment of the invention discloses inquiry
Sentence generation method, device and electronic equipment.
Specifically, a kind of application scenarios of query statement generation method provided in an embodiment of the present invention can be：Server
The Query Information of user's input is obtained, wherein, the Query Information includes：Target data source and target field to be checked；And then
According to the matching relationship of default data source and tables of data, the target data matched in database with the target data source is obtained
Table, according to the matching relationship of field in default field to be checked and tables of data, obtain in the target matrix and treated with the target
Inquire about the aiming field of fields match；Default query statement generation knot is filled with the target matrix and the aiming field
Structure, target query sentence is generated, it is achieved thereby that improving the efficiency of generation query statement.
A kind of query statement generation method provided in an embodiment of the present invention is described in detail below.
It should be noted that a kind of query statement generation method that the embodiment of the present invention is provided is applied to electronic equipment,
Wherein, in a particular application, the electronic equipment can be server, or terminal device, this is all rational.In addition,
The functional software for realizing a kind of query statement generation method that the embodiment of the present invention is provided can be that special query statement is given birth to
Into software, or existing query statement generation software or other there is plug-in unit in the software of query statement systematic function.
Referring to Fig. 1, Fig. 1 is a kind of schematic flow sheet of query statement generation method provided in an embodiment of the present invention, including
Following steps：
S101, obtain the Query Information of user's input.
Wherein, the Query Information includes：Target data source and target field to be checked.
It is understood that user can be any ordinary person for having and obtaining demand data, specific acquisition user is defeated
The mode of the Query Information entered can be：Electronic equipment provides human-computer interaction interface, and the human-computer interaction interface includes data source
Option and Field Options to be checked, the target data source and target selected by human-computer interaction interface acquisition user are to be checked
Field is ask, so as to obtain the Query Information of user's input.Certainly, the mode for obtaining the Query Information of user's input can also be it
His feasible mode, the embodiment of the present invention are not limited the specific mode for obtaining Query Information.
Specifically, understand for the ease of user and select, each choosing in data source options and Field Options to be checked
Item can use natural language description, natural language refer to ordinary person it will be appreciated that and the language that uses, for example, data source
Option can include the option with natural language description such as payroll, census returns, list of results, and Field Options to be checked can be with
Include the option of wage, name, city, population, achievement etc. natural language description.
S102, according to the matching relationship of default data source and tables of data, obtain in database with the target data source
The target matrix matched somebody with somebody, according to the matching relationship of field in default field to be checked and tables of data, obtain the target matrix
In aiming field with target fields match to be checked.
In practical application, database can be relevant database, and relevant database is built upon relational model basis
On database.In general, be stored with one or more tables of data in database, pass through default data source and tables of data
Matching relationship, the target matrix matched in database with the target data source can be obtained；One is included in each tables of data
Or multiple fields, according to the matching relationship of field in default field to be checked and tables of data, the target matrix can be obtained
In aiming field with target fields match to be checked.
For example, data source options include payroll, census returns, list of results, the tables of data difference stored in database
For a, b, c, the matching relationship of default data source and tables of data is：Payroll corresponding data table a, census returns' corresponding data
Table b, list of results corresponding data table c, then when target data source is payroll, pass through the matching of default data source and tables of data
Relation, the target matrix matched in database with the target data source, i.e. tables of data a can be obtained；In selection data source choosing
Xiang Hou, the Field Options to be checked of appearance include wage, name, and field is respectively a1, a2 in tables of data a；It is default to be checked
The matching relationship of field and field in tables of data is：In field a1 in wage corresponding data table a, name corresponding data table a
Field a2, then when target field to be checked is wage, closed by the matching of field in default field to be checked and tables of data
System, can obtain the aiming field with target fields match to be checked, i.e. a1 in the target matrix.
S103, default query statement generating structure is filled with the target matrix and the aiming field, generates target
Query statement.
It should be noted that default query statement generating structure can be prior designed one section of program code, should
Program code is run in electronic equipment, so as to which electronic equipment is after target matrix and aiming field is obtained, Ke Yizhi
Connect and the target matrix and the aiming field are filled into the program code, you can generation target query sentence.
Because the field having can be used in calculating, some fields can not be used to calculate, for example, population, income, fraction
It can be used for calculating, sex, area, time can not be used to calculate, therefore, can in order to simplify the design philosophy of program code
So that field is divided into index and dimension, wherein, index can be used in calculating, and dimension can not be used to calculate.The embodiment of the present invention
The specific calculation calculated field does not limit.For example, can be plus and, average etc. collect calculation.
It can be seen that when carrying out query statement generation using technical scheme provided in an embodiment of the present invention, it is defeated user can be obtained
Target data source and the target field to be checked entered；And then using the matching relationship of default data source and tables of data, obtain
The target matrix matched with the target data source, and closed using the matching of default field to be checked and field in tables of data
System, obtain the aiming field with target fields match to be checked；Finally, filled with the target matrix and the aiming field
Default query statement generating structure, target query sentence is generated, instead of in the prior art by manual compiling code building
The mode of query statement, so as to improve the efficiency for generating query statement.
In order to ensure the security of database, in a kind of specific embodiment, according to default data source and data
The matching relationship of table, obtain the target matrix matched in database with the target data source, Ke Yiwei：According to default data
Source and tables of data ID matching relationship, the tables of data ID matched in database with target data source is obtained, by ID pairs of the tables of data
The tables of data answered is as target matrix；
According to the matching relationship of field in default field to be checked and tables of data, obtain in the target matrix with the mesh
Mark the aiming field of fields match to be checked, Ke Yiwei：According to the matching of Field ID in default field to be checked and tables of data
Relation, the Field ID with target fields match to be checked in the target matrix is obtained, field corresponding to the Field ID is made
For aiming field.
It should be noted that tables of data ID unique identification data tables, Field ID unique mark field, therefore, pass through data
Table id can determine tables of data corresponding with tables of data ID, and field corresponding to the Field ID can be determined by Field ID.Separately
Outside, the embodiment of the present invention is not limited the specific manifestation form of data table id and Field ID.Specifically, tables of data ID and
Field ID can be made up of numeral, letter and asterisk wildcard, for example, tables of data ID can be：92be-53, Field ID can be：
84a0b78-46ed。
As can be seen that the matching relationship by pre-setting data source and tables of data ID, and field to be checked and data
The matching relationship of Field ID in table, data source is mapped with tables of data indirectly using tables of data ID, it is indirect using Field ID
Field to be checked is mapped with field in tables of data, avoids and directly matches data source with tables of data, and directly will
Fields match in field to be checked and tables of data, so as to which user can not know storage location of the tables of data in database, also without
Method knows the field information in tables of data, i.e., can shield bottom physical store relation, user can not be known storage aspect
Logic, it ensure that the security of database.
Because in practical application, designer is when database table structure designs, in order to reduce data redundancy, it will usually use
Same field is by two or multiple different tables of data associate, for example, personal information includes person number, Ren Yuannian
Age, personnel's sex, information of vehicles include type of vehicle, vehicle price, license plate number, because a people can have more cars, if
Personal information and information of vehicles are stored simultaneously with a table, the redundancy of personal information will be caused, therefore, designer would generally set
With two tables of data, i.e. person chart and meter for vehicle stores personal information and information of vehicles respectively for meter, meanwhile, in order to inquire about
All vehicles of one people, can increase person number in meter for vehicle, so as to by person number by person chart and car
Table associates.
Therefore, in order to tackle the situation of tables of data association of being likely to occur, improve the accuracy of the query statement of generation, with
Target matrix and aiming field fill default query statement generating structure, before the step of generating target query sentence,
This method can also include：
Judge whether the aiming field associates the first tables of data, if it is, obtaining first tables of data, and be based on the target
Field, processing is associated to the target matrix and first tables of data；
Wherein, first tables of data is the tables of data in addition to target matrix.
It is understood that the structure of tables of data, i.e. tables of data include which field, the type of each field and each
It is all to establish in advance that field, which associates which tables of data etc., and can establish contingency table in advance, and the contingency table is used to store each word
Duan Guanlian all tables of data, after aiming field is obtained, the contingency table can be inquired about, so as to judge the aiming field
Whether first tables of data is associated, and in practical application, the first tables of data can only include a tables of data, can also include more numbers
According to table.
For example, aiming field is person number, target matrix is person chart, when finding the aiming field in contingency table
When the tables of data of association includes person chart and meter for vehicle, then person number's also associated vehicle table, and obtain meter for vehicle is judged, from
And based on person number, processing is associated to person chart and meter for vehicle.
Based on person number, processing is associated to person chart and meter for vehicle and belongs to prior art, the embodiment of the present invention exists
This is repeated no more.For example, keyword JOIN can be used by the aiming field in target matrix and the mesh in the first tables of data
Marking-up section associates.
Specifically, filling default query statement generating structure with target matrix and aiming field, generation target is looked into
Ask sentence, Ke Yiwei：Default inquiry language is filled with the target matrix after association process, the first tables of data and aiming field
Sentence generating structure, generates target query sentence.
As can be seen that looked into the filling of the target matrix after association process, the first tables of data and aiming field is default
Sentence generating structure is ask, generates target query sentence, rather than it is directly default with target matrix and aiming field filling
Query statement generating structure, target query sentence is generated, the situation for being likely to occur tables of data association can be successfully managed, so as to,
Improve the accuracy of the query statement of generation.
In order to simplify the computation complexity of target query sentence, the execution efficiency of target query sentence is improved, with target
Tables of data and aiming field fill default query statement generating structure, before the step of generating target query sentence, the party
Method also includes：
Judge whether the aiming field meets optimal conditions；If it is, using default optimization processing algorithm, to the target
Field optimizes processing；
It is understood that aiming field can only include a field, multiple fields can also be included, optimal conditions can
To be to be directed to the sequencing of aiming field arrangement or for aiming field numerical value, specifically, can be according to thing
Decision procedure in the program code first designed, judges whether the aiming field meets optimal conditions, and the embodiment of the present invention is to tool
The decision procedure of body does not limit.For example, decision procedure can be：If the default value of aiming field is null value (NULL),
Then judge that the aiming field meets optimal conditions, or, if aiming field includes time, wage, the sequencing of arrangement is
Wage field, time field, then judge that the aiming field meets optimal conditions.
After judging that aiming field meets optimal conditions, using default optimization processing algorithm, the aiming field is carried out
Optimization processing.Optimization processing algorithm can be designed according to programmer's self-demand, for example, optimization processing algorithm can be with
For：When aiming field is behind where keywords or order by keywords, can be indexed to being established in aiming field,
So as to avoid full table scan, or：When aiming field is behind where keywords, can be set to aiming field silent
It is 0 to recognize value, so as to avoid the full table scan triggered because aiming field NULL occurs；Can also be：When aiming field arrangement
Sequencing is wage field, time field, its sequencing can be adjusted as time field, wage field, so as to elder generation
Inquiry meets the data of time conditions, then inquires about the data for meeting salary bill part, and looking into needed for query statement is performed so as to shorten
Ask the time.
In addition, in practical application, it is sometimes desirable to field occurrence number is counted, in order to improve the statistics speed to field
Degree, when aiming field repeats in tables of data, it can also judge that aiming field meets optimal conditions, at specific optimization
Reason process can be：Re-scheduling processing is carried out to aiming field.Realizing the mode of re-scheduling processing can be：Using re-scheduling function (example
Such as, unique () function), or, preferably, can also be：First aiming field is sorted out, obtains the note of each classification
Record, then, the number that Repeating Field occurs is calculated in the record of each classification.
For example, the number of users of statistics each product of each website in 2016, aiming field include：Website, product, use
Family, the field of repeat count are：User, the process to the optimization processing of aiming field can be：Obtaining each in 2016
After the user of each product of website accesses record, first sort out according to website, product and user field, obtain each of each website
The user list of individual product, the then counting user number in each product record of each website, so as to, obtain 2016 it is each
The number of users of each product of individual website.
As can be seen that for the number of users in each product for directly counting each network address, first according to website, production
Product and user field merger, then the counting user number in each product of each website, avoids the re-scheduling to user field
Calculate, improve overall Statistical Speed.
Specifically, filling default query statement generating structure with target matrix and aiming field, generation target is looked into
Sentence is ask, including：Default query statement generating structure is filled with the aiming field after target matrix and optimization processing, it is raw
Into target query sentence.
Because the aiming field in target query sentence is by optimization processing, thus, target query sentence is shortened
Computation complexity, improve the execution efficiency of target query sentence.
In addition, in the case where aiming field associates the first tables of data, based on aiming field, to the target matrix with
And after first tables of data is associated processing, the target matrix in incidence relation and the first tables of data can also be carried out
Optimization processing, specific optimization process can be：It is the feelings established based on SQL for target matrix and the first tables of data
Condition, index is established in target matrix and the first tables of data, first is quickly accessed quickly through target matrix so as to realize
Tables of data；It is situation about being established based on HiveQL for target matrix and the first tables of data, is counted in target matrix and first
According to specified memory association (map join) in table, the first tables of data is quickly accessed quickly through target matrix so as to realize.
In order to avoid user's misoperation, and the situation for causing the target query sentence of generation not to be performed, in one kind
In specific embodiment, Query Information can also include the condition that target field to be checked meets；With the target matrix
And the aiming field fills default query statement generating structure, before the step of generating target query sentence, this method is also
It can include：
Judge whether the condition of target field satisfaction to be checked meets the goal condition in preparatory condition table；If it is,
Then perform and fill default query statement generating structure with the target matrix and the aiming field, generate target query sentence
The step of.
It is understood that the condition of field in each tables of data in database is previously provided with condition table, for example, number
According to having payroll and census returns in storehouse, the field in payroll includes：Person number, wage, sex, age；Population is united
Field in meter table includes：City, population, time, then the condition for each field that condition table can be set be：In payroll
Person number, sex and age can not be calculated, wage can carry out addition, subtraction, it is impossible to carry out multiplication and division meter
Calculate；City and time in census returns can not be calculated, and population wage can carry out addition, subtraction.
As can be seen that the condition that target field to be checked meets is the condition of user's input, the condition of field in condition table
The condition designed in advance for programmer, only when the condition that the target field to be checked of user's input meets meet it is default
During goal condition in condition table, it could perform and fill default query statement with the target matrix and the aiming field and give birth to
Into structure, the step of generating target query sentence, thus, it is possible to ensure the condition that the target field to be checked of user's input meets
Meet the goal condition in preparatory condition table.
Further, in order to guide user to input correct Query Information, the bar of target field satisfaction to be checked is being judged
After whether part meets the step of goal condition in preparatory condition table, this method also includes：
If the condition that target field to be checked meets does not meet goal condition, the feedback representation Query Information is wrong
Prompt message.
As can be seen that if the condition that the target field to be checked of user's input meets does not meet goal condition, electronics
The wrong prompt message of the equipment feedback representation Query Information, so as to which user is after the prompt message is seen, it can re-enter
Query Information, after the condition of the target field satisfaction to be checked of user's input meets goal condition, just perform generation target and look into
The step of asking sentence, it is thereby achieved that guiding user inputs correct Query Information.
The embodiment of the present invention is simply introduced below by an instantiation.
Searching method provided in an embodiment of the present invention is applied to some electronic equipment, the electronic equipment provides a personal-machine
Interactive interface, interface include the condition that data source options, Field Options to be checked and field to be checked meet, wherein, treat
Inquiry Field Options can be subdivided into：Index option, dimension option, the condition that field to be checked meets include：What dimension met
Condition options, index sequence and the export-restriction that condition options, dimension packet options, index meet, for example, user is by such as scheming
Flow is selected successively shown in 2, the data source of selection for：Census returns, index are：Population, dimension are：City, dimension
The condition of satisfaction is：City=Beijing, dimension are grouped into：Region, the condition that index meets are：Population>5000, index sequence
It is with export-restriction：Descending arrangement data are counted per capita, and export before ranking 20 data, so as to complete the defeated of Query Information
Enter.
Electronic equipment is after the Query Information of user's input is got, according to default data source and tables of data ID matching
Relation, the tables of data ID matched in database with census returns is obtained, using tables of data corresponding to tables of data ID as target
Tables of data；According to the matching relationship of Field ID in default field to be checked and tables of data, obtain in the target matrix with people
Mouth and the Field ID of city matching, using field corresponding with the Field ID of population and city matching as aiming field；
Satellite information is obtained, wherein, satellite information includes：The mark of related information, the mark for optimizing information and verification are closed
The mark of method information, after judging that aiming field associates the first tables of data, the mark of related information is arranged to 1, is judging mesh
After marking-up section meets optimal conditions, the mark for optimizing information is arranged to 1, in the condition symbol for judging that target field to be checked meets
After closing the goal condition in preparatory condition table, the mark for verifying legal information is arranged to 1；
If verification legal information is identified as 1, and related information is identified as 1, then obtains first tables of data, and
Based on aiming field, processing is associated to target matrix and the first tables of data, and with the target data after association process
Table, the first tables of data and aiming field fill default query statement generating structure, generate target query sentence；If verification
Legal information is identified as 1, and optimize information is identified as 1, then using default optimization processing algorithm, to the target word
Section optimizes processing, and fills default query statement generation knot with the aiming field after target matrix and optimization processing
Structure, generate target query sentence.
It can be seen that using scheme provided in an embodiment of the present invention, when carrying out query statement generation, user's input can be obtained
Target data source and target field to be checked；And then utilize the matching relationship of default data source and tables of data, acquisition and institute
The target matrix of target data source matching is stated, and utilizes the matching relationship of default field to be checked and field in tables of data,
Obtain the aiming field with target fields match to be checked；Finally, filled with the target matrix and the aiming field pre-
If query statement generating structure, generate target query sentence, instead of and looked into the prior art by manual compiling code building
The mode of sentence is ask, so as to, the efficiency of generation query statement is improved, and user's misoperation can be avoided, and cause to generate
Target query sentence situation about can not be performed, further, cope with the situation for being likely to occur tables of data association, improve
The accuracy of the query statement of generation, and can simplify the computation complexity of target query sentence, improve target query
The execution efficiency of sentence.
Corresponding with above-mentioned query statement generation method embodiment, the embodiment of the present invention also provides a kind of query statement life
Into device.
Referring to Fig. 3, Fig. 3 is a kind of structural representation map device bag of query statement generating means provided in an embodiment of the present invention
Include：
Transceiver module 301, for obtaining the Query Information of user's input, wherein, the Query Information includes：Target data source
And target field to be checked；
Processing module 302, for the matching relationship according to default data source and tables of data, obtain in database with the mesh
The target matrix of data source matching is marked, according to the matching relationship of field in default field to be checked and tables of data, is somebody's turn to do
In target matrix with the aiming field of target fields match to be checked；Filled with the target matrix and the aiming field
Default query statement generating structure, generate target query sentence.
It can be seen that when carrying out query statement generation using technical scheme provided in an embodiment of the present invention, it is defeated user can be obtained
Target data source and the target field to be checked entered；And then using the matching relationship of default data source and tables of data, obtain
The target matrix matched with the target data source, and closed using the matching of default field to be checked and field in tables of data
System, obtain the aiming field with target fields match to be checked；Finally, filled with the target matrix and the aiming field
Default query statement generating structure, target query sentence is generated, instead of in the prior art by manual compiling code building
The mode of query statement, so as to improve the efficiency for generating query statement.
Wherein, the processing module 302, is additionally operable to：
According to default data source and tables of data ID matching relationship, obtain what is matched in database with the target data source
Tables of data ID, using tables of data corresponding to tables of data ID as target matrix；According to default field to be checked and tables of data
The matching relationship of middle Field ID, the Field ID with target fields match to be checked in the target matrix is obtained, by the field
Field is as aiming field corresponding to ID.
Wherein, the processing module 302 also includes：
First judging submodule, for filling default query statement life with the target matrix and the aiming field
Into structure, before generating target query sentence, judge whether the aiming field associates the first tables of data, wherein, first data
Table is the tables of data in addition to target matrix；
Submodule is obtained, for when the judged result of first judging submodule is is, obtaining first tables of data, and
Based on the aiming field, processing is associated to the target matrix and first tables of data；
The processing module 302, it is additionally operable to the target matrix after association process, first tables of data and the target
Field fills default query statement generating structure, generates target query sentence.
Wherein, the processing module 302 also includes：
Second judging submodule, for filling default query statement life with the target matrix and the aiming field
Into structure, before generating target query sentence, judge whether the aiming field meets optimal conditions；
Optimize submodule, for when the judged result of second judging submodule is is, utilizing default optimization processing
Algorithm, processing is optimized to the aiming field；
The processing module 302, it is additionally operable to default with the aiming field filling after the target matrix and optimization processing
Query statement generating structure, generate target query sentence.
Wherein, the Query Information also includes the condition that target field to be checked meets, the processing module 302 also includes：
3rd judging submodule, for filling default query statement life with the target matrix and the aiming field
Into structure, before generating target query sentence, judge whether the condition that target field to be checked meets meets preparatory condition table
In goal condition；
Implementation sub-module, for when the judged result of the 3rd judging submodule is is, performing with the target matrix
And the aiming field fills default query statement generating structure, the step of generating target query sentence.
Wherein, the processing module 302, in addition to：
Submodule is fed back, for whether meeting in preparatory condition table in the condition for judging target field satisfaction to be checked
After goal condition, if the condition that target field to be checked meets does not meet goal condition, the feedback representation Query Information
Wrong prompt message.
In an alternate embodiment of the invention, as shown in figure 4, the processing module 302 in the embodiment of the present invention can be processor
410, transceiver module 301 can be transceiver 420, meanwhile, the embodiment of the present invention provides query statement generating means, can also wrap
Memory 430 is included, memory 430 is used for store program codes and data.
The embodiment of the present invention additionally provides a kind of electronic equipment, as shown in figure 5, including processor 501, communication interface 502,
Memory 503 and communication bus 504, wherein, processor 501, communication interface 502, memory 503 is complete by communication bus 504
Into mutual communication,
Memory 503, for depositing computer program；
Processor 501, during for performing the program deposited on memory 503, realize what the embodiment of the present invention was provided
Query statement generation method, specifically, the query statement generation method comprises the following steps：
The Query Information of user's input is obtained, wherein, the Query Information includes：Target data source and target word to be checked
Section；
According to the matching relationship of default data source and tables of data, the mesh matched in database with the target data source is obtained
Tables of data is marked, according to the matching relationship of field in default field to be checked and tables of data, is obtained in the target matrix with being somebody's turn to do
The aiming field of target fields match to be checked；
Default query statement generating structure is filled with the target matrix and the aiming field, generates target query language
Sentence.
Optionally, according to the matching relationship of default data source and tables of data, obtain in database with the target data source
The target matrix of matching, including：
According to default data source and tables of data ID matching relationship, obtain what is matched in database with the target data source
Tables of data ID, using tables of data corresponding to tables of data ID as target matrix；
According to the matching relationship of field in default field to be checked and tables of data, obtain in the target matrix with the mesh
The aiming field of fields match to be checked is marked, including：
According to the matching relationship of Field ID in default field to be checked and tables of data, obtain in the target matrix with being somebody's turn to do
The Field ID of target fields match to be checked, using field corresponding to the Field ID as aiming field.
Optionally, default query statement generating structure, generation are being filled with the target matrix and the aiming field
Before the step of target query sentence, this method also includes：
Judge whether the aiming field associates the first tables of data, wherein, first tables of data is in addition to target matrix
Tables of data；
If it is, obtaining first tables of data, and the aiming field is based on, to the target matrix and first data
Table is associated processing；
Default query statement generating structure is filled with the target matrix and the aiming field, generates target query language
Sentence, including：
Default inquiry language is filled with the target matrix after association process, first tables of data and the aiming field
Sentence generating structure, generates target query sentence.
Optionally, default query statement generating structure, generation are being filled with the target matrix and the aiming field
Before the step of target query sentence, this method also includes：
Judge whether the aiming field meets optimal conditions；
If it is, using default optimization processing algorithm, processing is optimized to the aiming field；
Default query statement generating structure is filled with the target matrix and the aiming field, generates target query language
Sentence, including：
Default query statement generating structure, generation are filled with the aiming field after the target matrix and optimization processing
Target query sentence.
Optionally, the Query Information also includes the condition that target field to be checked meets；
Default query statement generating structure is being filled with the target matrix and the aiming field, is generating target query
Before the step of sentence, this method also includes：
Judge whether the condition of target field satisfaction to be checked meets the goal condition in preparatory condition table；
Default query statement generating structure is filled with the target matrix and the aiming field if it is, performing,
The step of generating target query sentence.
Optionally, the goal condition in whether the condition for judging target field satisfaction to be checked meets preparatory condition table
The step of after, this method also includes：
If the condition that target field to be checked meets does not meet goal condition, the feedback representation Query Information is wrong
Prompt message.
The communication bus that above-mentioned electronic equipment is mentioned can be Peripheral Component Interconnect standard (Peripheral Component
Interconnect, abbreviation PCI) bus or EISA (Extended Industry Standard
Architecture, abbreviation EISA) bus etc..The communication bus can be divided into address bus, data/address bus, controlling bus etc..
For ease of representing, only represented in figure with a thick line, it is not intended that an only bus or a type of bus.
The communication that communication interface is used between above-mentioned electronic equipment and other equipment.
Memory can include random access memory (Random Access Memory, abbreviation RAM), can also include
Nonvolatile memory (non-volatile memory), for example, at least a magnetic disk storage.Optionally, memory may be used also
To be at least one storage device for being located remotely from aforementioned processor.
Above-mentioned processor can be general processor, including central processing unit (Central Processing Unit,
Abbreviation CPU), network processing unit (Ne twork Processor, abbreviation NP) etc.；It can also be digital signal processor
(Digital Signal Processing, abbreviation DSP), application specific integrated circuit (Applica tion Specific
Integrated Circuit, abbreviation ASIC), field programmable gate array (Field-Programmable Gate Array,
Abbreviation FPGA) either other PLDs, discrete gate or transistor logic, discrete hardware components.
At the another aspect that the present invention is implemented, a kind of computer-readable recording medium is additionally provided, it is described computer-readable
Instruction is stored with storage medium, when run on a computer so that computer performs above-mentioned query statement generation side
Method.
At the another aspect that the present invention is implemented, the embodiment of the present invention additionally provides a kind of computer program production comprising instruction
Product, when run on a computer so that computer performs above-mentioned query statement generation method.
In the above-described embodiments, can come wholly or partly by software, hardware, firmware or its any combination real
It is existing.When implemented in software, can realize in the form of a computer program product whole or in part.The computer program
Product includes one or more computer instructions.When loading on computers and performing the computer program instructions, all or
Partly produce according to the flow or function described in the embodiment of the present invention.The computer can be all-purpose computer, special meter
Calculation machine, computer network or other programmable devices.The computer instruction can be stored in computer-readable recording medium
In, or the transmission from a computer-readable recording medium to another computer-readable recording medium, for example, the computer
Instruction can pass through wired (such as coaxial cable, optical fiber, numeral from a web-site, computer, server or data center
User's line (DSL)) or wireless (such as infrared, wireless, microwave etc.) mode to another web-site, computer, server or
Data center is transmitted.The computer-readable recording medium can be any usable medium that computer can access or
It is the data storage devices such as server, the data center integrated comprising one or more usable mediums.The usable medium can be with
It is magnetic medium, (for example, floppy disk, hard disk, tape), optical medium (for example, DVD) or semiconductor medium (such as solid state hard disc
Solid State Disk (SSD)) etc..
It should be noted that herein, such as first and second or the like relational terms are used merely to a reality
Body or operation make a distinction with another entity or operation, and not necessarily require or imply and deposited between these entities or operation
In any this actual relation or order.Moreover, term " comprising ", "comprising" or its any other variant are intended to
Nonexcludability includes, so that process, method, article or equipment including a series of elements not only will including those
Element, but also the other element including being not expressly set out, or it is this process, method, article or equipment also to include
Intrinsic key element.In the absence of more restrictions, the key element limited by sentence "including a ...", it is not excluded that
Other identical element also be present in process, method, article or equipment including the key element.
Each embodiment in this specification is described by the way of related, identical similar portion between each embodiment
Divide mutually referring to what each embodiment stressed is the difference with other embodiment.Especially for device,
For electronic equipment embodiment, because it is substantially similar to embodiment of the method, so description is fairly simple, related part referring to
The part explanation of embodiment of the method.
The foregoing is merely illustrative of the preferred embodiments of the present invention, is not intended to limit the scope of the present invention.It is all
Any modification, equivalent substitution and improvements made within the spirit and principles in the present invention etc., are all contained in protection scope of the present invention
It is interior.
Claims (13)
1. a kind of query statement generation method, it is characterised in that methods described includes：
The Query Information of user's input is obtained, wherein, the Query Information includes：Target data source and target word to be checked
Section；
According to the matching relationship of default data source and tables of data, the target matched in database with the target data source is obtained
Tables of data, according to the matching relationship of field in default field to be checked and tables of data, obtain in the target matrix with institute
State the aiming field of target fields match to be checked；
Default query statement generating structure is filled with the target matrix and the aiming field, generates target query language
Sentence.
2. according to the method for claim 1, it is characterised in that described to be closed according to the matching of default data source and tables of data
System, the target matrix matched in database with the target data source is obtained, including：
According to default data source and tables of data ID matching relationship, the number matched in database with the target data source is obtained
According to table id, using tables of data corresponding to the tables of data ID as target matrix；
The matching relationship according to field in default field to be checked and tables of data, obtain in the target matrix with institute
The aiming field of target fields match to be checked is stated, including：
According to the matching relationship of Field ID in default field to be checked and tables of data, obtain in the target matrix with it is described
The Field ID of target fields match to be checked, using field corresponding to the Field ID as aiming field.
3. method according to claim 1 or 2, it is characterised in that with the target matrix and the target word
Section fills default query statement generating structure, and before the step of generating target query sentence, methods described also includes：
Judge whether the aiming field associates the first tables of data, wherein, first tables of data is in addition to target matrix
Tables of data；
If it is, obtaining first tables of data, and the aiming field is based on, to the target matrix and described first
Tables of data is associated processing；
Described to fill default query statement generating structure with the target matrix and the aiming field, generation target is looked into
Sentence is ask, including：
Default inquiry is filled with the target matrix after association process, first tables of data and the aiming field
Sentence generating structure, generate target query sentence.
4. method according to claim 1 or 2, it is characterised in that with the target matrix and the target word
Section fills default query statement generating structure, and before the step of generating target query sentence, methods described also includes：
Judge whether the aiming field meets optimal conditions；
If it is, using default optimization processing algorithm, processing is optimized to the aiming field；
Described to fill default query statement generating structure with the target matrix and the aiming field, generation target is looked into
Sentence is ask, including：
Default query statement generating structure is filled with the aiming field after the target matrix and optimization processing, generates mesh
Mark query statement.
5. method according to claim 1 or 2, it is characterised in that it is to be checked that the Query Information also includes the target
The condition that field meets；
Default query statement generating structure is being filled with the target matrix and the aiming field, is generating target query
Before the step of sentence, methods described also includes：
Judge whether the condition of target field satisfaction to be checked meets the goal condition in preparatory condition table；
If it is, execution is described to fill default query statement generation knot with the target matrix and the aiming field
Structure, generate target query sentence the step of.
6. according to the method for claim 5, it is characterised in that in the bar for judging target field to be checked and meeting
After whether part meets the step of goal condition in preparatory condition table, methods described also includes：
If the condition that the target field to be checked meets does not meet goal condition, Query Information described in feedback representation is wrong
Prompt message.
7. a kind of query statement generating means, it is characterised in that described device includes：
Transceiver module, for obtaining the Query Information of user's input, wherein, the Query Information includes：Target data source and
Target field to be checked；
Processing module, for the matching relationship according to default data source and tables of data, obtain in database with the number of targets
The target matrix matched according to source, according to the matching relationship of field in default field to be checked and tables of data, obtain the mesh
Mark the aiming field with target fields match to be checked in tables of data；With the target matrix and the aiming field
Default query statement generating structure is filled, generates target query sentence.
8. device according to claim 7, it is characterised in that the processing module, be additionally operable to：
According to default data source and tables of data ID matching relationship, the number matched in database with the target data source is obtained
According to table id, using tables of data corresponding to the tables of data ID as target matrix；According to default field to be checked and tables of data
The matching relationship of middle Field ID, the Field ID with target fields match to be checked in the target matrix is obtained, by institute
Field corresponding to Field ID is stated as aiming field.
9. the device according to claim 7 or 8, it is characterised in that the processing module also includes：
First judging submodule, for filling default query statement life with the target matrix and the aiming field
Into structure, before generating target query sentence, judge whether the aiming field associates the first tables of data, wherein, described first
Tables of data is the tables of data in addition to target matrix；
Submodule is obtained, for when the judged result of first judging submodule is is, obtaining first tables of data, and
Based on the aiming field, processing is associated to the target matrix and first tables of data；
The processing module, it is additionally operable to the target matrix after association process, first tables of data and the mesh
Marking-up section fills default query statement generating structure, generates target query sentence.
10. the device according to claim 7 or 8, it is characterised in that the processing module also includes：
Second judging submodule, for filling default query statement life with the target matrix and the aiming field
Into structure, before generating target query sentence, judge whether the aiming field meets optimal conditions；
Optimize submodule, for when the judged result of second judging submodule is is, being calculated using default optimization processing
Method, processing is optimized to the aiming field；
The processing module, it is additionally operable to fill default inquiry with the aiming field after the target matrix and optimization processing
Sentence generating structure, generate target query sentence.
11. the device according to claim 7 or 8, it is characterised in that it is to be checked that the Query Information also includes the target
The condition that field meets, the processing module also include：
3rd judging submodule, for filling default query statement life with the target matrix and the aiming field
Into structure, before generating target query sentence, judge whether the condition that target field to be checked meets meets preparatory condition
Goal condition in table；
Implementation sub-module, for when the judged result of the 3rd judging submodule is is, performing the number of targets
Default query statement generating structure is filled according to table and the aiming field, the step of generating target query sentence.
12. device according to claim 11, it is characterised in that the processing module also includes：
Submodule is fed back, for the mesh in whether meeting preparatory condition table in the condition for judging target field satisfaction to be checked
After mark condition, if the condition that target field to be checked meets does not meet goal condition, letter is inquired about described in feedback representation
Cease wrong prompt message.
13. a kind of electronic equipment, it is characterised in that including processor, communication interface, memory and communication bus, wherein, processing
Device, communication interface, memory complete mutual communication by communication bus；
Memory, for depositing computer program；
Processor, during for performing the program deposited on memory, realize any described method and steps of claim 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710667798.9A CN107391739A (en) | 2017-08-07 | 2017-08-07 | A kind of query statement generation method, device and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710667798.9A CN107391739A (en) | 2017-08-07 | 2017-08-07 | A kind of query statement generation method, device and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107391739A true CN107391739A (en) | 2017-11-24 |
Family
ID=60354384
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710667798.9A Pending CN107391739A (en) | 2017-08-07 | 2017-08-07 | A kind of query statement generation method, device and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107391739A (en) |
Cited By (33)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108563736A (en) * | 2018-04-10 | 2018-09-21 | 口碑(上海)信息技术有限公司 | The method and device of data is inquired based on data characteristics |
| CN108874926A (en) * | 2018-05-31 | 2018-11-23 | 康键信息技术（深圳）有限公司 | Mass data inquiry method, device, computer equipment and storage medium |
| CN108959381A (en) * | 2018-05-29 | 2018-12-07 | 阿里巴巴集团控股有限公司 | The management method and device and electronic equipment of data |
| CN109165377A (en) * | 2018-06-11 | 2019-01-08 | 玖富金科控股集团有限责任公司 | Generate the method and tabulating equipment of form data |
| CN109299234A (en) * | 2018-09-19 | 2019-02-01 | 北京明略软件系统有限公司 | A kind of information query method, device and computer readable storage medium |
| CN109446386A (en) * | 2018-10-23 | 2019-03-08 | 中国银行股份有限公司 | A kind of data query method and device |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
| CN109766338A (en) * | 2018-11-28 | 2019-05-17 | 杭州云为科技有限公司 | Self-defined report design method, electronic equipment, storage medium and system |
| CN109783543A (en) * | 2019-01-14 | 2019-05-21 | 广州虎牙信息科技有限公司 | Data query method, apparatus, equipment and storage medium |
| CN109947770A (en) * | 2018-08-14 | 2019-06-28 | 武汉斗鱼网络科技有限公司 | A kind of data base query method, terminal device and storage medium |
| CN110008232A (en) * | 2019-04-11 | 2019-07-12 | 北京启迪区块链科技发展有限公司 | Generation method, device, server and the medium of structured query sentence |
| CN110019307A (en) * | 2017-12-28 | 2019-07-16 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN110069532A (en) * | 2019-03-14 | 2019-07-30 | 东软集团股份有限公司 | Data query method, apparatus, computer readable storage medium and electronic equipment |
| CN110321344A (en) * | 2019-05-20 | 2019-10-11 | 平安普惠企业管理有限公司 | Information query method, device, computer equipment and the storage medium of associated data |
| CN110442620A (en) * | 2019-08-05 | 2019-11-12 | 赵玉德 | A kind of big data is explored and cognitive approach, device, equipment and computer storage medium |
| CN110516081A (en) * | 2019-09-02 | 2019-11-29 | 北京明略软件系统有限公司 | The display methods and device of tables of data mapping relations |
| CN110807042A (en) * | 2018-07-20 | 2020-02-18 | 武汉烽火众智智慧之星科技有限公司 | SQL statement generation system and method |
| CN110990444A (en) * | 2019-11-27 | 2020-04-10 | 中诚信征信有限公司 | Data query method and device |
| CN111090640A (en) * | 2019-11-13 | 2020-05-01 | 山东中磁视讯股份有限公司 | ETL data cleaning method and system |
| CN111143433A (en) * | 2019-12-10 | 2020-05-12 | 中国平安财产保险股份有限公司 | Method and device for counting data of data bins |
| CN111177174A (en) * | 2018-11-09 | 2020-05-19 | 百度在线网络技术（北京）有限公司 | SQL statement generation method, device, equipment and computer readable storage medium |
| CN111241111A (en) * | 2020-02-12 | 2020-06-05 | 网易（杭州）网络有限公司 | Data query method and device, data comparison method and device, medium and equipment |
| CN111708804A (en) * | 2020-06-11 | 2020-09-25 | 中国建设银行股份有限公司 | Data processing method, device, equipment and medium |
| CN111782653A (en) * | 2020-06-30 | 2020-10-16 | 平安国际智慧城市科技股份有限公司 | Data query method and device, electronic equipment and storage medium |
| CN111813799A (en) * | 2020-07-23 | 2020-10-23 | 德清云岫科技有限公司 | Database query statement generation method and device, computer equipment and storage medium |
| CN112559576A (en) * | 2019-09-26 | 2021-03-26 | 北京国双科技有限公司 | Data display method, system, device, storage medium and electronic equipment |
| CN112860728A (en) * | 2021-02-19 | 2021-05-28 | 深圳市极致科技股份有限公司 | Method and device for adding display columns to data query table based on user environment |
| CN113051287A (en) * | 2021-06-01 | 2021-06-29 | 北京达佳互联信息技术有限公司 | Query statement generation method, device, equipment and storage medium |
| CN113407548A (en) * | 2021-08-18 | 2021-09-17 | 南京网觉软件有限公司 | Big data query method, system and medium based on ClickHouse dictionary table |
| CN113641698A (en) * | 2021-08-19 | 2021-11-12 | 成都数之联科技有限公司 | Table connection query code generation method and device, electronic equipment and computer readable storage medium |
| CN113704306A (en) * | 2021-08-31 | 2021-11-26 | 上海观安信息技术股份有限公司 | Database data processing method and device, storage medium and electronic equipment |
| CN114490762A (en) * | 2022-01-20 | 2022-05-13 | 北京宇信科技集团股份有限公司 | Data source access method, device, medium and equipment for decision engine |
| CN115878659A (en) * | 2023-02-01 | 2023-03-31 | 云账户技术(天津)有限公司 | Method, device and equipment for generating SQL (structured query language) statement and readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101739453A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Method and device for carrying out condition query on database table |
| CN102567539A (en) * | 2011-12-31 | 2012-07-11 | 北京新媒传信科技有限公司 | Intelligent WEB report implementation method and intelligent WEB report implementation system |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
| CN106873974A (en) * | 2016-12-30 | 2017-06-20 | 武汉默联股份有限公司 | Smart code generates automotive engine system and method |
-
2017
- 2017-08-07 CN CN201710667798.9A patent/CN107391739A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101739453A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Method and device for carrying out condition query on database table |
| CN102567539A (en) * | 2011-12-31 | 2012-07-11 | 北京新媒传信科技有限公司 | Intelligent WEB report implementation method and intelligent WEB report implementation system |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
| CN106873974A (en) * | 2016-12-30 | 2017-06-20 | 武汉默联股份有限公司 | Smart code generates automotive engine system and method |
Cited By (48)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110019307A (en) * | 2017-12-28 | 2019-07-16 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN110019307B (en) * | 2017-12-28 | 2023-09-01 | 阿里巴巴集团控股有限公司 | Data processing method and device |
| CN108563736A (en) * | 2018-04-10 | 2018-09-21 | 口碑(上海)信息技术有限公司 | The method and device of data is inquired based on data characteristics |
| CN108959381A (en) * | 2018-05-29 | 2018-12-07 | 阿里巴巴集团控股有限公司 | The management method and device and electronic equipment of data |
| CN108959381B (en) * | 2018-05-29 | 2021-05-28 | 创新先进技术有限公司 | Data management method and device and electronic equipment |
| CN108874926A (en) * | 2018-05-31 | 2018-11-23 | 康键信息技术（深圳）有限公司 | Mass data inquiry method, device, computer equipment and storage medium |
| CN109165377A (en) * | 2018-06-11 | 2019-01-08 | 玖富金科控股集团有限责任公司 | Generate the method and tabulating equipment of form data |
| CN110807042A (en) * | 2018-07-20 | 2020-02-18 | 武汉烽火众智智慧之星科技有限公司 | SQL statement generation system and method |
| CN110807042B (en) * | 2018-07-20 | 2023-02-24 | 武汉烽火众智智慧之星科技有限公司 | SQL statement generation system and method |
| CN109947770A (en) * | 2018-08-14 | 2019-06-28 | 武汉斗鱼网络科技有限公司 | A kind of data base query method, terminal device and storage medium |
| CN109299234A (en) * | 2018-09-19 | 2019-02-01 | 北京明略软件系统有限公司 | A kind of information query method, device and computer readable storage medium |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
| CN109446386B (en) * | 2018-10-23 | 2020-10-27 | 中国银行股份有限公司 | Data query method and device |
| CN109446386A (en) * | 2018-10-23 | 2019-03-08 | 中国银行股份有限公司 | A kind of data query method and device |
| CN111177174A (en) * | 2018-11-09 | 2020-05-19 | 百度在线网络技术（北京）有限公司 | SQL statement generation method, device, equipment and computer readable storage medium |
| CN109766338A (en) * | 2018-11-28 | 2019-05-17 | 杭州云为科技有限公司 | Self-defined report design method, electronic equipment, storage medium and system |
| CN109783543A (en) * | 2019-01-14 | 2019-05-21 | 广州虎牙信息科技有限公司 | Data query method, apparatus, equipment and storage medium |
| CN109783543B (en) * | 2019-01-14 | 2021-07-02 | 广州虎牙信息科技有限公司 | Data query method, device, equipment and storage medium |
| CN110069532A (en) * | 2019-03-14 | 2019-07-30 | 东软集团股份有限公司 | Data query method, apparatus, computer readable storage medium and electronic equipment |
| CN110008232A (en) * | 2019-04-11 | 2019-07-12 | 北京启迪区块链科技发展有限公司 | Generation method, device, server and the medium of structured query sentence |
| CN110321344B (en) * | 2019-05-20 | 2024-03-15 | 深圳市晶测科技有限公司 | Information query method and device for associated data, computer equipment and storage medium |
| CN110321344A (en) * | 2019-05-20 | 2019-10-11 | 平安普惠企业管理有限公司 | Information query method, device, computer equipment and the storage medium of associated data |
| CN110442620A (en) * | 2019-08-05 | 2019-11-12 | 赵玉德 | A kind of big data is explored and cognitive approach, device, equipment and computer storage medium |
| CN110442620B (en) * | 2019-08-05 | 2023-08-29 | 赵玉德 | Big data exploration and cognition method, device, equipment and computer storage medium |
| CN110516081A (en) * | 2019-09-02 | 2019-11-29 | 北京明略软件系统有限公司 | The display methods and device of tables of data mapping relations |
| CN112559576A (en) * | 2019-09-26 | 2021-03-26 | 北京国双科技有限公司 | Data display method, system, device, storage medium and electronic equipment |
| CN111090640A (en) * | 2019-11-13 | 2020-05-01 | 山东中磁视讯股份有限公司 | ETL data cleaning method and system |
| CN110990444A (en) * | 2019-11-27 | 2020-04-10 | 中诚信征信有限公司 | Data query method and device |
| CN111143433A (en) * | 2019-12-10 | 2020-05-12 | 中国平安财产保险股份有限公司 | Method and device for counting data of data bins |
| CN111241111A (en) * | 2020-02-12 | 2020-06-05 | 网易（杭州）网络有限公司 | Data query method and device, data comparison method and device, medium and equipment |
| CN111241111B (en) * | 2020-02-12 | 2023-09-26 | 网易（杭州）网络有限公司 | Data query method and device, data comparison method and device, medium and equipment |
| CN111708804A (en) * | 2020-06-11 | 2020-09-25 | 中国建设银行股份有限公司 | Data processing method, device, equipment and medium |
| CN111708804B (en) * | 2020-06-11 | 2024-03-01 | 中国建设银行股份有限公司 | Data processing method, device, equipment and medium |
| CN111782653A (en) * | 2020-06-30 | 2020-10-16 | 平安国际智慧城市科技股份有限公司 | Data query method and device, electronic equipment and storage medium |
| CN111813799A (en) * | 2020-07-23 | 2020-10-23 | 德清云岫科技有限公司 | Database query statement generation method and device, computer equipment and storage medium |
| CN111813799B (en) * | 2020-07-23 | 2024-01-19 | 德清云岫科技有限公司 | Database query statement generation method, device, computer equipment and storage medium |
| CN112860728A (en) * | 2021-02-19 | 2021-05-28 | 深圳市极致科技股份有限公司 | Method and device for adding display columns to data query table based on user environment |
| CN113051287B (en) * | 2021-06-01 | 2021-08-20 | 北京达佳互联信息技术有限公司 | Query statement generation method, device, equipment and storage medium |
| CN113051287A (en) * | 2021-06-01 | 2021-06-29 | 北京达佳互联信息技术有限公司 | Query statement generation method, device, equipment and storage medium |
| CN113407548A (en) * | 2021-08-18 | 2021-09-17 | 南京网觉软件有限公司 | Big data query method, system and medium based on ClickHouse dictionary table |
| CN113407548B (en) * | 2021-08-18 | 2021-11-19 | 南京网觉软件有限公司 | Big data query method, system and medium based on ClickHouse dictionary table |
| CN113641698A (en) * | 2021-08-19 | 2021-11-12 | 成都数之联科技有限公司 | Table connection query code generation method and device, electronic equipment and computer readable storage medium |
| CN113641698B (en) * | 2021-08-19 | 2024-03-12 | 成都数之联科技股份有限公司 | Method and device for generating continuous table query code, electronic equipment and computer readable storage medium |
| CN113704306A (en) * | 2021-08-31 | 2021-11-26 | 上海观安信息技术股份有限公司 | Database data processing method and device, storage medium and electronic equipment |
| CN113704306B (en) * | 2021-08-31 | 2024-01-30 | 上海观安信息技术股份有限公司 | Database data processing method and device, storage medium and electronic equipment |
| CN114490762B (en) * | 2022-01-20 | 2022-11-22 | 北京宇信科技集团股份有限公司 | Data source access method, device, medium and equipment for decision engine |
| CN114490762A (en) * | 2022-01-20 | 2022-05-13 | 北京宇信科技集团股份有限公司 | Data source access method, device, medium and equipment for decision engine |
| CN115878659A (en) * | 2023-02-01 | 2023-03-31 | 云账户技术(天津)有限公司 | Method, device and equipment for generating SQL (structured query language) statement and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107391739A (en) | A kind of query statement generation method, device and electronic equipment | |
| US11552785B2 (en) | Methods and systems for a synchronized distributed data structure for federated machine learning | |
| CN108280365B (en) | Data access authority management method, device, terminal device and storage medium | |
| US10885591B1 (en) | Pre-calculated insurance premiums with wildcarding | |
| US8943059B2 (en) | Systems and methods for merging source records in accordance with survivorship rules | |
| CN104391934B (en) | Data verification method and device | |
| US20200218737A1 (en) | Method, system and program product for matching of transaction records | |
| US9547638B2 (en) | Data logging for rule specifications | |
| US8595171B2 (en) | System and method for rule set validation | |
| US8108367B2 (en) | Constraints with hidden rows in a database | |
| CN107153847A (en) | Predict method and computing device of the user with the presence or absence of malicious act | |
| CN109241068A (en) | The method, apparatus and terminal device that foreground and background data compares | |
| US20210065245A1 (en) | Using machine learning to discern relationships between individuals from digital transactional data | |
| AU2017299435A1 (en) | Record matching system | |
| EP4181010A1 (en) | Data reuse computing architecture | |
| US20220129816A1 (en) | Methods and arrangements to manage requirements and controls, and data at the intersection thereof | |
| CN112016138A (en) | Method and device for automatic safe modeling of Internet of vehicles and electronic equipment | |
| CN109816330A (en) | Regular method of calibration, device, electronic equipment and computer readable storage medium | |
| Jing et al. | A Universal neighbourhood rough sets model for knowledge discovering from incomplete heterogeneous data | |
| WO2020056314A1 (en) | Systems and methods for a simulation program of a percolation model for the loss distribution caused by a cyber attack | |
| US11861551B1 (en) | Apparatus and methods of transport token tracking | |
| US11928640B1 (en) | Apparatus and method of transport management | |
| US20240144036A1 (en) | Apparatus for emissions predictions | |
| CN117708350B (en) | Enterprise policy information association method and device and electronic equipment | |
| US20090228232A1 (en) | Range-based evaluation |
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 |
Application publication date: 20171124 |
|
| RJ01 | Rejection of invention patent application after publication |