CN109947788A - Data query method and apparatus - Google Patents
Data query method and apparatus Download PDFInfo
- Publication number
- CN109947788A CN109947788A CN201711042305.9A CN201711042305A CN109947788A CN 109947788 A CN109947788 A CN 109947788A CN 201711042305 A CN201711042305 A CN 201711042305A CN 109947788 A CN109947788 A CN 109947788A
- Authority
- CN
- China
- Prior art keywords
- attribute
- splicing
- data query
- rule
- module
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a kind of data query method and apparatus, are related to field of computer technology.Wherein, this method comprises: receiving data query task；According to attribute configuration table and the assembled SQL statement corresponding with the data query task of preset splicing rule；The label list in database is inquired according to the SQL statement, to obtain query result.By above step, it can be dynamically generated SQL statement in server-side, not need to be embedded in fixed SQL code in front end, reduce the degree of coupling of data query system front and back ends.
Description
Technical field
The present invention relates to field of computer technology more particularly to a kind of data query method and apparatus.
Background technique
In internet, marketing gradually occupies the epoch of mainstream, specifies product orientation, optimization user experience, precisely launches extensively
It accuses, and measurement user's value etc. is all closely related with the target audience of determining marketing.And can quick response choose demand, energy
The no convenient model of choosing that extends is the key index for measuring system superiority and inferiority of choosing.
Existing system of choosing generally is made of front-end interface and rear end table.Front-end interface is usually for party in request's personalization
The configuration interface for selecting attribute, to limit querying condition.Rear end table is the huge wide table with various attribute tags, tool
There is the features such as data volume is big, attribute is various.In existing system of choosing, for generating query SQL (structured query language)
Code be that front end is embedded in a manner of hard coded by developer.After demander submits attribute to choose list, front end can root
The attribute and attribute value generation query SQL chosen according to demander, are then committed to rear end for query SQL.Before rear end receives
When the query SQL at end, corresponding SQL statement is executed, and forward end returns to query result.
In realizing process of the present invention, at least there are the following problems in the prior art for inventor's discovery:
The first, close coupling.In existing system of choosing, the code for generating query SQL is prior fixedly embedded front end
, the coupling of system front and back end is high, is not easy to the code that data mining personnel modify query SQL.
The second, high latency.The rear end table of existing system of choosing is a huge wide table, and data volume is very big.When user selects
When the attribute selected is more, such one huge wide table is inquired by SQL statement, time-consuming very long, the pressure of database is also very big.Cause
This, existing system response time of choosing is very slow, and user experience is poor.
Summary of the invention
In view of this, the embodiment of the present invention provides a kind of data query method and apparatus, with being capable of dynamic generation SQL language
Sentence reduces the degree of coupling of data query system (such as system of choosing) front and back ends.Further, the data of the embodiment of the present invention are looked into
Asking method and apparatus can be improved the response speed of data query system, improve user experience.
To achieve the above object, according to an aspect of the invention, there is provided a kind of data query method.
Data query method of the invention includes: to receive data query task；According to attribute configuration table and preset spelling
Connect regular assembled SQL statement corresponding with the data query task；The label in database is inquired according to the SQL statement
Table, to obtain query result.
Optionally, the data query task includes: the attribute and its attribute value of selection；The attribute configuration table includes:
Label table name, attribute-name, attribute type, splicing logical word；The splicing rule includes: the first splicing rule and the second splicing rule
Then；It is described according to attribute configuration table and the preset assembled SQL statement corresponding with the data query task of splicing rule
Step includes: that attribute type corresponding with the attribute of the selection and splicing logical word are obtained from the attribute configuration table；Root
The attribute of the selection is spliced with its attribute value according to the attribute type and the first splicing rule, to obtain condition；Root
The all properties of same label table name will be corresponded in the data query task according to the splicing logical word and the second splicing rule
The condition spliced, to obtain WHERE clause；SELECT clause, FROM clause and the WHERE clause are spelled
Dress, to generate SQL statement.
Optionally, the first splicing rule includes: when attribute type is " selection ", and the splicing of attribute and attribute value is closed
Keyword is " IN "；When attribute type is " range ", the splicing keyword of attribute and attribute value is " BETWEEN AND ".
Optionally, it is genuine condition and all splicing logics that the second splicing rule, which includes: preferentially by preset logic,
Word is that the condition of the attribute of " AND " is stitched together, whole to constitute the condition spliced by splicing logical word " AND "；It will
Preset logic is false condition and all splicing logical words are that the condition of attribute of " OR " is stitched together, with composition by
The condition for splicing logical word " OR " splicing is whole；The condition by splicing logical word " OR " splicing is crucial entirely through splicing
Word " AND " splicing is behind the condition entirety by splicing logical word " AND " splicing.
Optionally, it is described according to the SQL statement inquire database in label list the step of include: with the data
When the corresponding SQL statement of query task is multiple, multiple label lists in database are concurrently inquired according to all SQL statements,
Then the comprehensive inquiry result of each label list is determined according to the logical relation of all SQL statements.
Optionally, described according to attribute configuration table and the assembly of preset splicing rule and the data query task pair
Before the step of SQL statement answered, the method also includes: the attribute pair of acquisition and the selection from the attribute configuration table
The attribute type answered converts the attribute value in the data query task according to the attribute type and preset write-in rule
The storage format required at SQL splicing is met.
Optionally, the preset write-in rule includes: and corresponds to the attribute when the attribute type of attribute is " selection "
Attribute value write-in storage table " initial value " field；When the attribute type of attribute is " range ", by the left margin of the attribute
" initial value " field of value write-in storage table, by " end value " field of the right boundary value write-in storage table of the attribute.
Optionally, before the reception data query task the step of, the method also includes: receiving front end
When attribute retrieval request, reading attributes allocation list, in order to which front end includes multiple display modules according to result dynamic generation is read
Front end query interface；Wherein, each display module includes at least one attribute that can be selected.
To achieve the above object, according to another aspect of the present invention, a kind of data query device is provided.
Data query device of the invention includes: receiving module, for receiving data query task；Assembling module is used for
According to attribute configuration table and the assembled SQL statement corresponding with the data query task of preset splicing rule；Enquiry module,
For inquiring the label list in database according to the SQL statement, to obtain query result.
Optionally, the data query task includes: the attribute and its attribute value of selection；The attribute configuration table includes:
Label table name, attribute-name, attribute type, splicing logical word；The splicing rule includes: the first splicing rule and the second splicing rule
Then；The assembling module is assembled corresponding with the data query task according to attribute configuration table and preset splicing rule
SQL statement includes: that attribute type corresponding with the attribute of the selection and spelling are obtained in the assembling module dependence allocation list
Connect logical word；The assembling module is according to the attribute type and the regular attribute and its attribute value by the selection of the first splicing
Spliced, to obtain condition；The assembling module looks into the data according to the splicing logical word and the second splicing rule
The condition that all properties of same label table name are corresponded in inquiry task is spliced, to obtain WHERE clause；The assembly
SELECT clause, FROM clause and the WHERE clause are carried out assembly by module, to generate SQL statement.
Optionally, the enquiry module according to the SQL statement inquire database in label list include: with the number
According to the corresponding SQL statement of query task be it is multiple when, the enquiry module is concurrently inquired in database according to all SQL statements
Multiple label lists, the comprehensive inquiry result of each label list is then determined according to the logical relation of all SQL statements.
Optionally, described device further include: writing module, for being obtained from the attribute configuration table and the selection
The corresponding attribute type of attribute, it is regular by the attribute in the data query task according to the attribute type and preset write-in
Value is converted into meeting the storage format that SQL splicing requires.
Optionally, described device further include: read module, for reading in the attribute retrieval request for receiving front end
Attribute configuration table, in order to front end according to read result dynamic generation include multiple display modules front end query interface；Wherein,
Each display module includes the attribute that at least one can be selected.
To achieve the above object, another aspect according to an embodiment of the present invention provides a kind of server.
The server of the embodiment of the present invention, comprising: one or more processors；And storage device, for storing one
Or multiple programs；When one or more of programs are executed by one or more of processors, so that one or more of
The data query method of the processor realization embodiment of the present invention.
To achieve the above object, another aspect according to an embodiment of the present invention provides a kind of computer-readable medium.
The computer-readable medium of the embodiment of the present invention, is stored thereon with computer program, and described program is held by processor
The data query method of the embodiment of the present invention is realized when row.
One embodiment in foregoing invention has the following advantages that or the utility model has the advantages that in embodiments of the present invention, by
Rear end presets attribute configuration table and splicing rule, and after receiving data query task, according to attribute configuration table and
The assembled SQL statement corresponding with the data query task of splicing rule, can be dynamically generated SQL statement, without
The fixed SQL code of the front end insertion of data query system, reduces the coupling of system front and back ends.Further, pass through generation
Multiple SQL statements concurrently inquire multiple label lists, can save query time, improve data query system response speed
Degree improves user experience.
Further effect possessed by above-mentioned non-usual optional way adds hereinafter in conjunction with specific embodiment
With explanation.
Detailed description of the invention
Attached drawing for a better understanding of the present invention, does not constitute an undue limitation on the present invention.Wherein:
Fig. 1 is the key step schematic diagram of data query method according to an embodiment of the invention；
Fig. 2 is the key step schematic diagram of data query method according to another embodiment of the present invention；
Fig. 3 is the main modular schematic diagram of data query device according to an embodiment of the invention；
Fig. 4 is the main modular schematic diagram of data query device according to another embodiment of the present invention；
Fig. 5 is that the embodiment of the present invention can be applied to exemplary system architecture figure therein；
Fig. 6 is adapted for the structural schematic diagram for the computer system for realizing the server of the embodiment of the present invention.
Specific embodiment
Below in conjunction with attached drawing, an exemplary embodiment of the present invention will be described, including the various of the embodiment of the present invention
Details should think them only exemplary to help understanding.Therefore, those of ordinary skill in the art should recognize
It arrives, it can be with various changes and modifications are made to the embodiments described herein, without departing from scope and spirit of the present invention.Together
Sample, for clarity and conciseness, descriptions of well-known functions and structures are omitted from the following description.
It should be pointed out that in the absence of conflict, the feature in embodiment and embodiment in the present invention can be with
It is combined with each other.
Fig. 1 is the key step schematic diagram of data query method according to an embodiment of the invention.The embodiment of the present invention
Data query method can be executed by rear end (server-side).As shown in Figure 1, the data query method of the embodiment of the present invention includes:
Step S101, data query task is received.
When it is implemented, user can choose the category limited needed for inquiry operation by front end (terminal device) query interface
It property and sets property.After user clicks " submission " button, data query task is sent to rear end by front end.Wherein,
The data query task includes: the attribute and its attribute value of selection.For example, in the target audience to determine advertisement marketing,
A certain user includes: in basic behavioral module based on the data query task that the front end query interface for the system of choosing is submitted
Grd_lvl (abbreviation of grade_level, membership grade) attribute, age (age) attribute and sex (gender) attribute, and purchase
The attribute of order_num (amount of placing an order) attribute and order_amt (order value) attribute and each attribute in behavioral module
Value.
Step S102, assembled corresponding with the data query task according to attribute configuration table and preset splicing rule
SQL statement.
Wherein, the attribute configuration table is used to store the configuration information for all properties that front end query interface can be shown,
Can include: label table name, attribute-name, the corresponding attribute type of each attribute, the corresponding splicing logical word of each attribute.The spelling
Connecing rule includes the strictly all rules that are followed of splicing SQL statement, it may include: for the attribute with different attribute type, it is specified that
It carries out splicing splicing keyword used with attribute value；For with it is different splicing logical words attributes constitute condition,
Define the rule that each condition is spliced.
Wherein, a kind of optional embodiment of step S102 includes: the attribute query according to included by data query task
Attribute configuration table, to obtain corresponding attribute configuration information；Then, by the corresponding attribute configuration information and preset
Splicing rule is associated, and attribute and attribute value is spliced into condition, then each condition is spliced into WHERE clause；Next,
The WHERE clause and SELECT clause, FROM clause are spliced, to obtain the SQL language for inquiring a label list
Sentence.When it is implemented, the corresponding SQL statement of the data query task (may only be inquired in a label list for one
Data), it is also possible to be multiple (inquiring the data in multiple label lists).
Step S103, the label list in database is inquired according to the SQL statement, to obtain query result.
When it is implemented, multiple label lists can be stored in the database in order to improve data query speed.Also, with
When the corresponding SQL statement of the data query task is multiple, multiple label lists can be concurrently inquired according to all SQL statements,
Then the comprehensive inquiry of each label list is determined according to the logical relation of all SQL statements as a result, and by the comprehensive inquiry result
It is back to the front end (terminal device) of data query system.
In embodiments of the present invention, by presetting attribute configuration table and splicing rule, and appoint receiving data query
It, being capable of dynamic according to attribute configuration table and the assembled SQL statement corresponding with the data query task of splicing rule after business
Ground generates SQL statement, without the SQL code fixed in front end insertion, reduces the coupling of data query system front and back ends
Property.Further, when generating multiple SQL statements, by concurrently inquiring multiple label lists, query time can be saved, improved
The response speed of data query system improves user experience.
Fig. 2 is the key step schematic diagram of data query method according to another embodiment of the present invention.The embodiment of the present invention
Data query method can be executed by server-side.As shown in Fig. 2, the data query method of the embodiment of the present invention includes:
Step S201, data query task is received.
Wherein, the data query task includes: the attribute and its attribute value of selection.Further, before step S201,
The data query method of the embodiment of the present invention further include: in the attribute retrieval request for receiving front end, reading attributes allocation list,
In order to front end according to read result dynamic generation include multiple display modules front end query interface；Wherein, each displaying mould
Block includes the attribute that at least one can be selected.
Wherein, the attribute configuration table includes: that all display module names of data query system, each display module are corresponding
The all properties name that label table name, each display module include.In addition, the attribute configuration table further include: the Attribute class of each attribute
The field informations such as the attribute meaning of splicing logical word and each attribute of type and each attribute.The attribute type includes: selection class
Type, wide-style；The splicing logical word includes: AND, OR.When it is implemented, the corresponding relationship of display module and label list can
Think one-to-one, or many-one.For example, the front end for system of choosing is looked into the target audience to determine advertisement marketing
Asking interface includes: basic behavioral module, buying behavior module；Database includes: label list lab1, label list lab2.Also, base
Plinth behavioral module is corresponding with label list lab1, and buying behavior module is corresponding with label list lab2.
In embodiments of the present invention, by the way that all properties of data query system to be stored in the attribute configuration table of rear end
In, and the reading attributes allocation list when rear end receives the attribute retrieval request of front end, it is dynamically obtained convenient for front end to be presented
Attribute, and then front end query interface is dynamically generated according to the attribute of acquisition, reduces the coupling of data query system front and back ends
It is right.When developer needs to modify or delete some attribute, the attribute configuration table of rear end need to be only modified, it is not necessary to modify front ends
Code, so that the iterative operation of system is more convenient, iteration efficiency is improved.
Step S202, attribute type corresponding with the attribute of the selection is obtained in dependence allocation list, according to the category
Property type and preset write-in rule the attribute value in the data query task is converted into meeting the storage that SQL splicing requires
Format.
Wherein, said write rule includes: when the attribute type of the attribute in data query task is " selection " type
When, by " initial value " field of the corresponding attribute value write-in storage table of the attribute；When the attribute type of an attribute is " range " class
When type, by " initial value " field of the left boundary value write-in storage table of the attribute, and the right boundary value of the attribute is written and is stored
" end value " field of table.In addition, said write is regular further include: for the attribute for " range " type, if user does not limit
" initial value " field in storage table is then written in left margin default value by the left boundary value of the attribute；If user does not limit the category
Property right boundary value, then by right margin default value be written storage table in " end value " field.
It has been obtained by step S202 for storing the storage table for meeting the attribute value that SQL splicing requires.The storage table
Can include: these field informations of task identification, module name, attribute-name, initial value, end value.So, SQL language is being carried out
When sentence splicing, it can facilitate directly using the attribute value in the storage table and carry out SQL splicing.Illustratively, work as data query
When system is target user's inquiry system in advertisement marketing, attribute configuration table can be as shown in table 1, is obtained according to step S202
Storage table can be as shown in table 2.
Table 1
| Module name | Label table name | Attribute-name | Attribute meaning | Attribute type | Splice logical word |
| Basic behavior | lab1 | grd_lvl | Membership grade | Selection | AND |
| Basic behavior | lab1 | age | Age | Range | OR |
| Basic behavior | lab1 | sex | Gender | Selection | OR |
| Basic behavior | lab1 | log_date | Log date | Range | AND |
| Buying behavior | lab2 | order_num | The amount of placing an order | Range | AND |
| Buying behavior | lab2 | order_amt | Order value | Range | AND |
Table 2
| Task identification | Module name | Attribute-name | Initial value | End value |
| 149690 | Basic behavior | grd_lvl | 1,2,3 | |
| 149690 | Basic behavior | age | 18 | 30 |
| 149690 | Basic behavior | sex | ‘f’ | |
| 149690 | Basic behavior | log_date | date‘2017-01-01’ | date‘2017-01-10’ |
It should be pointed out that table 1 is the exemplary illustration to attribute configuration table, table 2 is illustrated only is with task identification
The corresponding attribute value of 149690 data query task stores information.In the specific implementation, those skilled in the art can be according to reality
Border demand adjusts field contents included by attribute configuration table, storage table.
Step S203, label table name corresponding to the attribute with the selection is obtained in dependence allocation list, and is based on institute
State label table name building FROM clause.
Illustratively, as shown in table 1, when data query task includes the attribute in basic behavioral module, with the module
In the corresponding label list of attribute it is entitled " lab1 ", for the label list building FROM clause are as follows: FROM lab1.Work as data
When query task includes the attribute in buying behavior module, label list corresponding with the attribute in the module is entitled " lab2 ", needle
To the FROM clause of label list building are as follows: FROM lab2.
Step S204, attribute type corresponding with the attribute of the selection is obtained from the attribute configuration table and splicing is patrolled
Collect word；The attribute of the selection is spliced with its attribute value according to the attribute type and the first splicing rule, to obtain
Condition.
Wherein, the first splicing rule includes: and is carried out attribute-name and attribute value with " IN " when attribute type is " selection "
Splicing, to be spliced into a condition；When attribute type is " range ", with " BETWEEN AND " by attribute-name and attribute value into
Row splicing, is spliced into a condition.
Step S205, it will be corresponded in the data query task according to the splicing logical word and the second splicing rule same
The condition of all properties of label table name is spliced, to obtain WHERE clause.
Wherein, it is genuine condition (for example, " 1=1 " this condition) that the second splicing rule, which includes: preferentially by preset logic,
It is stitched together with the condition for the attribute that all splicing logical words are " AND ", is spliced with constituting by splicing logical word " AND "
Condition it is whole；By preset logic be false condition (for example, " 1=2 " this condition) and all splicing logical words are " OR "
The condition of attribute be stitched together, to constitute condition entirety splice by splicing logical word " OR "；By described by splicing
Logical word " OR " splicing condition entirely through splicing keyword " AND " splicing it is described by splicing logical word " AND " splicing
Behind condition entirety.
Step S206, SELECT clause, FROM clause and the WHERE clause are subjected to assembly, to generate SQL statement.
Wherein, the SELECT clause can determine according to the purpose of data query task.For example, when data query system is
When target user's inquiry system in advertisement marketing, the purpose of data query task is inquiry target user, therefore, building
SELECT clause are as follows: SELECTuser_id.Illustratively, when data query system is target user's inquiry in advertisement marketing
When system, by step S203 to step S206 construct for inquiring the SQL statement of a certain label list are as follows:
Step S207, when SQL statement corresponding with the data query task is multiple, simultaneously according to all SQL statements
Multiple label lists in database are inquired capablely, and the synthesis of each label list is then determined according to the logical relation of all SQL statements
Query result.
In this step, the comprehensive inquiry result of each label list is determined according to the logical relation of all SQL statements can include:
If the logical relation of each SQL statement is " AND ", intersection can be taken to the query result of each label list, and using the intersection as
Final comprehensive inquiry result；If the logical relation of each SQL statement is " OR ", the query result of each label list can be taken simultaneously
Collection, and using the union as final comprehensive inquiry result.
Step S208, comprehensive inquiry result is back to front end.
In embodiments of the present invention, SQL statement can be dynamically generated by above step, and according to each SQL of generation
Sentence concurrently inquires multiple label lists, not only reduces the coupling of front and back ends, and can save query time, improve
The response speed of data query system improves user experience.Further, it in the attribute retrieval request for receiving front end, reads
Attribute configuration table, so that front end dynamic generation includes the front end query interface of multiple display modules, before further reduced system,
The degree of coupling of rear end.
Fig. 3 is the main modular schematic diagram of data query device according to an embodiment of the invention.In general, data query
System includes: front end (terminal device), rear end (server-side).The data query device of the embodiment of the present invention is arranged in server-side.
As shown in figure 3, the data query device 300 of the embodiment of the present invention includes: receiving module 301, assembling module 302, enquiry module
303。
Receiving module 301, for receiving data query task.
When it is implemented, user can choose the category limited needed for inquiry operation by front end (terminal device) query interface
It property and sets property.After user clicks " submission " button, data query task is sent to rear end by front end.Wherein,
The received data query task of receiving module 301 includes: the attribute and its attribute value of selection.For example, for determine advertisement
When the target audience of marketing, a certain user includes: based on the data query task that the front end query interface for the system of choosing is submitted
The attribute value of grd_lvl (membership grade) attribute, age (age) attribute and sex (gender) attribute and each attribute.
Assembling module 302, for appointing according to attribute configuration table and preset splicing rule are assembled with the data query
It is engaged in corresponding SQL statement.
Wherein, the attribute configuration table is used to store the configuration information for all properties that front end query interface can be shown,
Can include: label table name, attribute-name, the corresponding attribute type of each attribute, the corresponding splicing logical word of each attribute.The spelling
Connecing rule includes the strictly all rules that are followed of splicing SQL statement, it may include: for the attribute with different attribute type, it is specified that
It carries out splicing splicing keyword used with attribute value；For with it is different splicing logical words attributes constitute condition,
Define the rule that each condition is spliced.
Wherein, a kind of optional embodiment of the assembled SQL statement of assembling module 302 includes: assembling module 302 according to data
Attribute query attribute configuration table included by query task, to obtain corresponding attribute configuration information；Then, assembling module
302 are associated the corresponding attribute configuration information and preset splicing rule, and attribute and attribute value are spliced into item
Part, then each condition is spliced into WHERE clause；Next, assembling module 302 by the WHERE clause and SELECT clause,
FROM clause is spliced, to obtain the SQL statement for inquiring a label list.When it is implemented, assembling module 302 generates
SQL statement corresponding with the data query task may for one (i.e. only inquire a label list in data), can also
Can be multiple (inquiring the data in multiple label lists).
Enquiry module 303, for inquiring the label list in database according to the SQL statement, to obtain query result.
When it is implemented, multiple label lists can be stored in the database in order to improve data query speed.Also, with
When the corresponding SQL statement of the data query task is multiple, enquiry module 303 can concurrently be inquired according to all SQL statements
Multiple label lists in database, then according to the logical relation of all SQL statements determine each label list comprehensive inquiry as a result,
And the comprehensive inquiry result is back to front end.
In embodiments of the present invention, by receiving module receive data query task, by assembling module assembly with it is described
The corresponding SQL statement of data query task, can be dynamically generated SQL statement, without the SQL generation fixed in front end insertion
Code, reduces the coupling of data query system front and back ends.Further, multiple label lists are concurrently inquired by enquiry module,
The response speed that query time can be saved, improve data query system improves user experience.
Fig. 4 is the main modular schematic diagram of data query device according to another embodiment of the present invention.The embodiment of the present invention
Data query device may be provided at server-side.As shown in figure 4, the data query device 400 of the embodiment of the present invention includes: to receive
Module 401, writing module 402, assembling module 403, enquiry module 404.
Receiving module 401, for receiving data query task.Wherein, the data query task includes: the attribute of selection
And its attribute value.
Writing module 402, for obtaining attribute type corresponding with the attribute of the selection in dependence allocation list, according to
Attribute value in the data query task is converted into meeting SQL splicing requirement by the attribute type and preset write-in rule
Storage format.
Wherein, the attribute configuration table includes: that all display module names of data query system, each display module are corresponding
All properties name included by label table name, each display module, the attribute type of each attribute and splicing logical word.The Attribute class
Type includes: Selective type, wide-style；The splicing logical word includes: AND, OR.
Wherein, said write rule based on writing module 402 includes: the category when the attribute in data query task
Property type when being " selection " type, the corresponding attribute value of the attribute is written to " initial value " field of storage table；When an attribute
When attribute type is " range " type, by " initial value " field of the left boundary value of attribute write-in storage table, and by the attribute
Right boundary value write-in storage table " end value " field.In addition, said write is regular further include: for for " range " type
If user does not limit the left boundary value of the attribute " initial value " field in storage table is written in left margin default value by attribute；
If user does not limit the right boundary value of the attribute, " end value " field in storage table is written into right margin default value.
In embodiments of the present invention, it by the way that writing module 402 is arranged, has obtained meeting what SQL splicing required for storing
The storage table of attribute value.The storage table can include: these fields of task identification, module name, attribute-name, initial value, end value
Information.So, when carrying out SQL statement splicing, progress can be facilitated directly using the attribute value in the storage table
SQL splicing.
Assembling module 403, for appointing according to attribute configuration table and preset splicing rule are assembled with the data query
It is engaged in corresponding SQL statement, specifically includes:
Assembling module 403, for obtaining label table name corresponding to the attribute with the selection in dependence allocation list, and
FROM clause is constructed based on the label table name.
Illustratively, as shown in table 1, when data query task includes the attribute in basic behavioral module, with the module
In the corresponding label list of attribute it is entitled " lab1 ", assembling module 403 be directed to the label list building FROM clause are as follows: FROM
lab1.When data query task includes the attribute in buying behavior module, label table name corresponding with the attribute in the module
For " lab2 ", assembling module 403 is directed to the FROM clause of label list building are as follows: FROM lab2.
Assembling module 403 is also used to obtain Attribute class corresponding with the attribute of the selection from the attribute configuration table
Type and splicing logical word；And the attribute of the selection and its attribute value are carried out according to the attribute type and the first splicing rule
Splicing, to obtain condition.
Wherein, first splicing rule includes: when attribute type is " selection ", with " IN " based on assembling module 403
Attribute-name and attribute value are spliced, to be spliced into a condition；When attribute type is " range ", with " BETWEEN
AND " splices attribute-name and attribute value, is spliced into a condition.
Assembling module 403 is also used to regular by the data query task according to the splicing logical word and the second splicing
The condition of all properties of the middle same label table name of correspondence is spliced, to obtain WHERE clause.
Wherein, it is genuine condition (for example, " 1=1 " this condition) that the second splicing rule, which includes: preferentially by preset logic,
It is stitched together with the condition for the attribute that all splicing logical words are " AND ", is spliced with constituting by splicing logical word " AND "
Condition it is whole；By preset logic be false condition (for example, " 1=2 " this condition) and all splicing logical words are " OR "
The condition of attribute be stitched together, to constitute condition entirety splice by splicing logical word " OR "；By described by splicing
Logical word " OR " splicing condition entirely through splicing keyword " AND " splicing it is described by splicing logical word " AND " splicing
Behind condition entirety.
Assembling module 403 is also used to SELECT clause, FROM clause and the WHERE clause carrying out assembly, to generate
SQL statement.
Wherein, the SELECT clause can be determined by assembling module 403 according to the purpose of data query task.For example, working as
When data query system is target user's inquiry system in advertisement marketing, the purpose of data query task is that inquiry target is used
Family, therefore, the SELECT clause that assembling module 403 constructs are as follows: SELECT user_id.
Illustratively, when data query system is target user's inquiry system in advertisement marketing, 403 structure of assembling module
That builds is used to inquire the SQL statement of a certain label list are as follows:
Enquiry module 404 is used for when SQL statement corresponding with the data query task is multiple, according to all SQL
Sentence concurrently inquires multiple label lists in database, then determines each label list according to the logical relation of all SQL statements
Comprehensive inquiry result.
Wherein, enquiry module 404 determines that the comprehensive inquiry result of each label list can according to the logical relation of all SQL statements
If the logical relation for including: each SQL statement is " AND ", enquiry module 404 can take intersection to the query result of each label list,
And using the intersection as final comprehensive inquiry result；If the logical relation of each SQL statement is " OR ", enquiry module 404
Union can be taken to the query result of each label list, and using the union as final comprehensive inquiry result.
Further, the data query device 400 of the embodiment of the present invention can also include: read module.Read module is used for
In the attribute retrieval request for receiving front end, reading attributes allocation list, in order to which front end is according to reading result dynamic generation packet
Include the front end query interface of multiple display modules；Wherein, each display module includes at least one attribute that can be selected.Tool
When body is implemented, the corresponding relationship of the label list in the display module and database of front end query interface can be it is one-to-one, can also
Think many-one.For example, the front end query interface for system of choosing includes: basis in the target audience to determine advertisement marketing
Behavioral module, buying behavior module；Database includes: label list lab1, label list lab2.Also, basic behavioral module and mark
It is corresponding to sign table lab1, buying behavior module is corresponding with label list lab2.
In embodiments of the present invention, it by the way that read module is arranged, can be read in the attribute retrieval request for receiving front end
Attribute configuration table is taken, front end query interface is dynamically generated in order to which front end is based on reading result, reduces the coupling of front and back ends
Degree.When developer needs to modify or delete some attribute, attribute configuration table only need to be modified, it is not necessary to modify front-end codes, make
The iterative operation for the system of obtaining is more convenient, and iteration efficiency is improved.
The data query device of the embodiment of the present invention can dynamically generate SQL statement, and parallel based on each SQL statement
Multiple label lists in database are inquired on ground, not only reduce the coupling of data query system front and back ends, and can save
Query time, the response speed for improving data query system improve user experience.Further, the data of the embodiment of the present invention are looked into
Device is ask by reading attributes allocation list, is convenient for front end dynamic generation front end query interface, further reduced system front and back ends
The degree of coupling.
Fig. 5 is shown can be using the data query method of the embodiment of the present invention or the exemplary system of data query device
Framework 500.
As shown in figure 5, system architecture 500 may include terminal device 501,502,503, network 504 and server 505.
Network 504 between terminal device 501,502,503 and server 505 to provide the medium of communication link.Network 504 can be with
Including various connection types, such as wired, wireless communication link or fiber optic cables etc..
User can be used terminal device 501,502,503 and be interacted by network 504 with server 505, to receive or send out
Send message etc..Various telecommunication customer end applications, such as the application of shopping class, net can be installed on terminal device 501,502,503
The application of page browsing device, searching class application, instant messaging tools, mailbox client, social platform software etc..
Terminal device 501,502,503 can be the various electronic equipments with display screen and supported web page browsing, packet
Include but be not limited to smart phone, tablet computer, pocket computer on knee and desktop computer etc..
Server 505 can be to provide the server of various services, such as utilize terminal device 501,502,503 to user
The system of choosing browsed provides the back-stage management server supported.Back-stage management server can be to the inquiry request received
Etc. data carry out the processing such as analyzing, and processing result (such as user information of selection) is fed back into terminal device.
It should be noted that data query method provided by the embodiment of the present invention is generally executed by server 505, accordingly
Ground, data query device are generally positioned in server 505.
It should be understood that the number of terminal device, network and server in Fig. 5 is only schematical.According to realization need
It wants, can have any number of terminal device, network and server.
Fig. 6 shows the structural schematic diagram for being suitable for the computer system 600 for the server for being used to realize the embodiment of the present invention.
Computer system shown in Fig. 6 is only an example, should not function to the embodiment of the present invention and use scope bring it is any
Limitation.
As shown in fig. 6, computer system 600 includes central processing unit (CPU) 601, it can be read-only according to being stored in
Program in memory (ROM) 602 or be loaded into the program in random access storage device (RAM) 603 from storage section 608 and
Execute various movements appropriate and processing.In RAM 603, also it is stored with system 600 and operates required various programs and data.
CPU 601, ROM 602 and RAM 603 are connected with each other by bus 604.Input/output (I/O) interface 605 is also connected to always
Line 604.
I/O interface 605 is connected to lower component: the importation 606 including keyboard, mouse etc.；It is penetrated including such as cathode
The output par, c 607 of spool (CRT), liquid crystal display (LCD) etc. and loudspeaker etc.；Storage section 608 including hard disk etc.；
And the communications portion 609 of the network interface card including LAN card, modem etc..Communications portion 609 via such as because
The network of spy's net executes communication process.Driver 610 is also connected to I/O interface 605 as needed.Detachable media 611, such as
Disk, CD, magneto-optic disk, semiconductor memory etc. are mounted on as needed on driver 610, in order to read from thereon
Computer program be mounted into storage section 608 as needed.
Particularly, disclosed embodiment, the process described above with reference to flow chart may be implemented as counting according to the present invention
Calculation machine software program.For example, embodiment disclosed by the invention includes a kind of computer program product comprising be carried on computer
Computer program on readable medium, the computer program include the program code for method shown in execution flow chart.?
In such embodiment, which can be downloaded and installed from network by communications portion 609, and/or from can
Medium 611 is dismantled to be mounted.When the computer program is executed by central processing unit (CPU) 601, system of the invention is executed
The above-mentioned function of middle restriction.
It should be noted that computer-readable medium shown in the present invention can be computer-readable signal media or meter
Calculation machine readable storage medium storing program for executing either the two any combination.Computer readable storage medium for example can be --- but not
Be limited to --- electricity, magnetic, optical, electromagnetic, infrared ray or semiconductor system, device or device, or any above combination.Meter
The more specific example of calculation machine readable storage medium storing program for executing can include but is not limited to: have the electrical connection, just of one or more conducting wires
Taking formula computer disk, hard disk, random access storage device (RAM), read-only memory (ROM), erasable type may be programmed read-only storage
Device (EPROM or flash memory), optical fiber, portable compact disc read-only memory (CD-ROM), light storage device, magnetic memory device,
Or above-mentioned any appropriate combination.In the present invention, computer readable storage medium can be it is any include or storage journey
The tangible medium of sequence, the program can be commanded execution system, device or device use or in connection.And at this
In invention, computer-readable signal media may include in a base band or as carrier wave a part propagate data-signal,
Wherein carry computer-readable program code.The data-signal of this propagation can take various forms, including but unlimited
In electromagnetic signal, optical signal or above-mentioned any appropriate combination.Computer-readable signal media can also be that computer can
Any computer-readable medium other than storage medium is read, which can send, propagates or transmit and be used for
By the use of instruction execution system, device or device or program in connection.Include on computer-readable medium
Program code can transmit with any suitable medium, including but not limited to: wireless, electric wire, optical cable, RF etc. are above-mentioned
Any appropriate combination.
Flow chart and block diagram in attached drawing are illustrated according to the system of various embodiments of the invention, method and computer journey
The architecture, function and operation in the cards of sequence product.In this regard, each box in flowchart or block diagram can generation
A part of one module, program segment or code of table, a part of above-mentioned module, program segment or code include one or more
Executable instruction for implementing the specified logical function.It should also be noted that in some implementations as replacements, institute in box
The function of mark can also occur in a different order than that indicated in the drawings.For example, two boxes succeedingly indicated are practical
On can be basically executed in parallel, they can also be executed in the opposite order sometimes, and this depends on the function involved.Also it wants
It is noted that the combination of each box in block diagram or flow chart and the box in block diagram or flow chart, can use and execute rule
The dedicated hardware based systems of fixed functions or operations is realized, or can use the group of specialized hardware and computer instruction
It closes to realize.
Being described in module involved in the embodiment of the present invention can be realized by way of software, can also be by hard
The mode of part is realized.Described module also can be set in the processor, for example, can be described as: a kind of processor packet
Include receiving module, assembling module, enquiry module.Wherein, the title of these modules is not constituted under certain conditions to the module
The restriction of itself, for example, receiving module is also described as " receiving the module of data query task ".
As on the other hand, the present invention also provides a kind of computer-readable medium, which be can be
Included in equipment described in above-described embodiment；It is also possible to individualism, and without in the supplying equipment.Above-mentioned calculating
Machine readable medium carries one or more program, when said one or multiple programs are executed by the equipment, makes
It obtains the equipment and executes following below scheme: receiving data query task；According to attribute configuration table and preset splicing rule it is assembled with
The corresponding SQL statement of the data query task；The label list in database is inquired according to the SQL statement, to obtain inquiry
As a result.
Above-mentioned specific embodiment, does not constitute a limitation on the scope of protection of the present invention.Those skilled in the art should be bright
It is white, design requirement and other factors are depended on, various modifications, combination, sub-portfolio and substitution can occur.It is any
Made modifications, equivalent substitutions and improvements etc. within the spirit and principles in the present invention, should be included in the scope of the present invention
Within.
Claims (15)
1. a kind of data query method, which is characterized in that the described method includes:
Receive data query task；
According to attribute configuration table and the assembled SQL statement corresponding with the data query task of preset splicing rule；
The label list in database is inquired according to the SQL statement, to obtain query result.
2. the method according to claim 1, wherein the data query task include: selection attribute and its
Attribute value；The attribute configuration table includes: label table name, attribute-name, attribute type, splicing logical word；The splicing rule packet
It includes: the first splicing rule and the second splicing rule；
It is described according to attribute configuration table and the preset assembled SQL statement corresponding with the data query task of splicing rule
Step includes: that attribute type corresponding with the attribute of the selection and splicing logical word are obtained from the attribute configuration table；Root
The attribute of the selection is spliced with its attribute value according to the attribute type and the first splicing rule, to obtain condition；Root
The all properties of same label table name will be corresponded in the data query task according to the splicing logical word and the second splicing rule
The condition spliced, to obtain WHERE clause；SELECT clause, FROM clause and the WHERE clause are spelled
Dress, to generate SQL statement.
3. according to the method described in claim 2, it is characterized in that, the first splicing rule includes: when attribute type is " choosing
Select " when, the splicing keyword of attribute and attribute value is " IN "；When attribute type is " range ", the splicing of attribute and attribute value
Keyword is " BETWEENAND ".
4. according to the method described in claim 3, it is characterized in that, the second splicing rule includes: preferentially to patrol preset
Collecting is that genuine condition and all conditions for splicing the attribute that logical words are " AND " are stitched together, and is patrolled with constituting by splicing
The condition for collecting word " AND " splicing is whole；By preset logic be false condition and all splicing logical words are the attribute of " OR "
The condition is stitched together, whole to constitute the condition spliced by splicing logical word " OR "；It will be described by splicing logical word
The condition of " OR " splicing is whole in the condition by splicing logical word " AND " splicing entirely through splicing keyword " AND " splicing
Behind body.
5. according to the method described in claim 2, it is characterized in that, the mark inquired according to the SQL statement in database
The step of label table includes:
When SQL statement corresponding with the data query task is multiple, database is concurrently inquired according to all SQL statements
In multiple label lists, the comprehensive inquiry result of each label list is then determined according to the logical relation of all SQL statements.
6. according to any method of claim 2 to 5, which is characterized in that described according to attribute configuration table and default
Splicing rule assembled SQL statement corresponding with the data query task the step of before, the method also includes:
Attribute type corresponding with the attribute of the selection is obtained from the attribute configuration table, according to the attribute type and in advance
If write-in rule the attribute value in the data query task is converted into meeting the storage format that SQL splicing requires.
7. according to the method described in claim 6, it is characterized in that, the preset write-in rule includes:
When the attribute type of attribute is " selection ", by " initial value " field of the corresponding attribute value write-in storage table of the attribute；
When the attribute type of attribute is " range ", by " initial value " field of the left boundary value write-in storage table of the attribute, by the category
Property right boundary value write-in storage table " end value " field.
8. the method according to claim 1, wherein before the reception data query task the step of, institute
State method further include:
In the attribute retrieval request for receiving front end, reading attributes allocation list, in order to which front end is raw according to result dynamic is read
At the front end query interface including multiple display modules；Wherein, each display module includes at least one category that can be selected
Property.
9. a kind of data query device, which is characterized in that described device includes:
Receiving module, for receiving data query task；
Assembling module, for assembled corresponding with the data query task according to attribute configuration table and preset splicing rule
SQL statement；
Enquiry module, for inquiring the label list in database according to the SQL statement, to obtain query result.
10. device according to claim 9, which is characterized in that the data query task include: selection attribute and its
Attribute value；The attribute configuration table includes: label table name, attribute-name, attribute type, splicing logical word；The splicing rule packet
It includes: the first splicing rule and the second splicing rule；
The assembling module is assembled corresponding with the data query task according to attribute configuration table and preset splicing rule
SQL statement includes: that attribute type corresponding with the attribute of the selection and spelling are obtained in the assembling module dependence allocation list
Connect logical word；The assembling module is according to the attribute type and the regular attribute and its attribute value by the selection of the first splicing
Spliced, to obtain condition；The assembling module looks into the data according to the splicing logical word and the second splicing rule
The condition that all properties of same label table name are corresponded in inquiry task is spliced, to obtain WHERE clause；The assembly
SELECT clause, FROM clause and the WHERE clause are carried out assembly by module, to generate SQL statement.
11. device according to claim 10, which is characterized in that the enquiry module inquires number according to the SQL statement
Include: according to the label list in library
When SQL statement corresponding with the data query task is multiple, the enquiry module is parallel according to all SQL statements
Multiple label lists in database are inquired on ground, then determine that the synthesis of each label list is looked into according to the logical relation of all SQL statements
Ask result.
12. device described in 0 or 11 according to claim 1, which is characterized in that described device further include:
Writing module, for obtaining attribute type corresponding with the attribute of the selection from the attribute configuration table, according to institute
It states attribute type and the attribute value in the data query task is converted into meeting what SQL splicing required by preset write-in rule
Storage format.
13. device according to claim 9, which is characterized in that described device further include:
Read module, in the attribute retrieval request for receiving front end, reading attributes allocation list, in order to which front end is according to reading
Taking result dynamic generation includes the front end query interface of multiple display modules；Wherein, each display module includes at least one energy
The attribute being enough selected.
14. a kind of server characterized by comprising
One or more processors；
Storage device, for storing one or more programs,
When one or more of programs are executed by one or more of processors, so that one or more of processors are real
The now method as described in any in claim 1 to 8.
15. a kind of computer-readable medium, is stored thereon with computer program, which is characterized in that described program is held by processor
The method as described in any in claim 1 to 8 is realized when row.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711042305.9A CN109947788B (en) | 2017-10-30 | 2017-10-30 | Data query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711042305.9A CN109947788B (en) | 2017-10-30 | 2017-10-30 | Data query method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109947788A true CN109947788A (en) | 2019-06-28 |
| CN109947788B CN109947788B (en) | 2021-10-15 |
Family
ID=67004006
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711042305.9A Active CN109947788B (en) | 2017-10-30 | 2017-10-30 | Data query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109947788B (en) |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110909018A (en) * | 2019-11-12 | 2020-03-24 | 深圳前海微众银行股份有限公司 | SQL statement generation method, device, equipment and storage medium |
| CN111190906A (en) * | 2019-12-31 | 2020-05-22 | 全球能源互联网研究院有限公司 | Method for detecting data abnormality of sensor network |
| CN111209307A (en) * | 2020-01-07 | 2020-05-29 | 深圳迅策科技有限公司 | Data dynamic classification processing method and device, terminal equipment and storage medium |
| CN111563094A (en) * | 2020-03-31 | 2020-08-21 | 北京奇艺世纪科技有限公司 | Data query method and device, electronic equipment and computer-readable storage medium |
| CN111639078A (en) * | 2020-05-25 | 2020-09-08 | 北京百度网讯科技有限公司 | Data query method and device, electronic equipment and readable storage medium |
| CN111951077A (en) * | 2020-08-13 | 2020-11-17 | 中国民航信息网络股份有限公司 | Ticket buying scheme display method and system |
| CN112015752A (en) * | 2020-08-31 | 2020-12-01 | 杭州小电科技股份有限公司 | Method and device for dynamically querying data, electronic equipment and storage medium |
| CN112199577A (en) * | 2020-12-09 | 2021-01-08 | 浙江口碑网络技术有限公司 | Data query method and device and electronic equipment |
| CN112307068A (en) * | 2020-11-10 | 2021-02-02 | 天元大数据信用管理有限公司 | Dynamic SQL query method |
| CN112632098A (en) * | 2020-12-18 | 2021-04-09 | 平安普惠企业管理有限公司 | Dynamic generation method of structured query statement and related equipment |
| CN112988781A (en) * | 2021-02-02 | 2021-06-18 | 北京金山云网络技术有限公司 | Data query method and device, electronic equipment and computer readable storage medium |
| WO2021189195A1 (en) * | 2020-03-23 | 2021-09-30 | 深圳市欢太科技有限公司 | Data querying method and apparatus, server, and storage medium |
| CN113505265A (en) * | 2021-07-27 | 2021-10-15 | 北京达佳互联信息技术有限公司 | Data query method and device, electronic equipment, storage medium and program product |
| CN114416529A (en) * | 2021-12-21 | 2022-04-29 | 惠州市德赛西威汽车电子股份有限公司 | Configuration table-based diagnostic mode implementation method, storage medium, and computer program |
| CN115357604A (en) * | 2022-10-18 | 2022-11-18 | 天聚地合(苏州)科技股份有限公司 | Data query method and device |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20010013036A1 (en) * | 2000-02-09 | 2001-08-09 | International Business Machines Corporation | Interaction with query data |
| US20060155689A1 (en) * | 2004-07-23 | 2006-07-13 | Oracle International Corporation | Web-based user interface for searching metadata-driven relational databases |
| US20100082656A1 (en) * | 2008-09-24 | 2010-04-01 | Yi Jing | Methods and apparatus for generating dynamic program files based on input queries that facilitate use of persistent query services |
| US20130006966A1 (en) * | 2011-06-09 | 2013-01-03 | International Business Machines Corporation | Relational Query Planning for Non-Relational Data Sources |
| CN103093000A (en) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | Database query modeling system and database query modeling method |
| CN105205104A (en) * | 2015-08-26 | 2015-12-30 | 成都布林特信息技术有限公司 | Cloud platform data acquisition method |
| CN105224544A (en) * | 2014-05-30 | 2016-01-06 | 北大方正集团有限公司 | A kind of data editing method of database and device |
| CN105975617A (en) * | 2016-05-20 | 2016-09-28 | 北京京东尚科信息技术有限公司 | Multi-partition-table inquiring and processing method and device |
| CN106775770A (en) * | 2017-01-16 | 2017-05-31 | 兴唐通信科技有限公司 | The lookup method of query statement is built based on category information |
| CN107169033A (en) * | 2017-04-17 | 2017-09-15 | 东北大学 | Relation data enquiring and optimizing method with parallel framework is changed based on data pattern |
| CN107273525A (en) * | 2017-06-23 | 2017-10-20 | 上海携程商务有限公司 | Functional expression querying method and system |
-
2017
- 2017-10-30 CN CN201711042305.9A patent/CN109947788B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20010013036A1 (en) * | 2000-02-09 | 2001-08-09 | International Business Machines Corporation | Interaction with query data |
| US20060155689A1 (en) * | 2004-07-23 | 2006-07-13 | Oracle International Corporation | Web-based user interface for searching metadata-driven relational databases |
| US20100082656A1 (en) * | 2008-09-24 | 2010-04-01 | Yi Jing | Methods and apparatus for generating dynamic program files based on input queries that facilitate use of persistent query services |
| US20130006966A1 (en) * | 2011-06-09 | 2013-01-03 | International Business Machines Corporation | Relational Query Planning for Non-Relational Data Sources |
| CN103093000A (en) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | Database query modeling system and database query modeling method |
| CN105224544A (en) * | 2014-05-30 | 2016-01-06 | 北大方正集团有限公司 | A kind of data editing method of database and device |
| CN105205104A (en) * | 2015-08-26 | 2015-12-30 | 成都布林特信息技术有限公司 | Cloud platform data acquisition method |
| CN105975617A (en) * | 2016-05-20 | 2016-09-28 | 北京京东尚科信息技术有限公司 | Multi-partition-table inquiring and processing method and device |
| CN106775770A (en) * | 2017-01-16 | 2017-05-31 | 兴唐通信科技有限公司 | The lookup method of query statement is built based on category information |
| CN107169033A (en) * | 2017-04-17 | 2017-09-15 | 东北大学 | Relation data enquiring and optimizing method with parallel framework is changed based on data pattern |
| CN107273525A (en) * | 2017-06-23 | 2017-10-20 | 上海携程商务有限公司 | Functional expression querying method and system |
Non-Patent Citations (3)
| Title |
|---|
| MATTHIAS NICOLA: "《Generating SQL/XML query and update statements》", 《ACM》 * |
| 俞晓: "《基于SQL Server的动态多条件查询方案》", 《电脑编程技巧与维护》 * |
| 周千明等: "《通用动态多条件查询方法的研究与实现》", 《电脑知识与技术》 * |
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110909018A (en) * | 2019-11-12 | 2020-03-24 | 深圳前海微众银行股份有限公司 | SQL statement generation method, device, equipment and storage medium |
| CN111190906A (en) * | 2019-12-31 | 2020-05-22 | 全球能源互联网研究院有限公司 | Method for detecting data abnormality of sensor network |
| CN111190906B (en) * | 2019-12-31 | 2023-06-20 | 全球能源互联网研究院有限公司 | Sensor network data anomaly detection method |
| CN111209307A (en) * | 2020-01-07 | 2020-05-29 | 深圳迅策科技有限公司 | Data dynamic classification processing method and device, terminal equipment and storage medium |
| WO2021189195A1 (en) * | 2020-03-23 | 2021-09-30 | 深圳市欢太科技有限公司 | Data querying method and apparatus, server, and storage medium |
| CN111563094A (en) * | 2020-03-31 | 2020-08-21 | 北京奇艺世纪科技有限公司 | Data query method and device, electronic equipment and computer-readable storage medium |
| CN111639078A (en) * | 2020-05-25 | 2020-09-08 | 北京百度网讯科技有限公司 | Data query method and device, electronic equipment and readable storage medium |
| CN111951077A (en) * | 2020-08-13 | 2020-11-17 | 中国民航信息网络股份有限公司 | Ticket buying scheme display method and system |
| CN112015752A (en) * | 2020-08-31 | 2020-12-01 | 杭州小电科技股份有限公司 | Method and device for dynamically querying data, electronic equipment and storage medium |
| CN112307068A (en) * | 2020-11-10 | 2021-02-02 | 天元大数据信用管理有限公司 | Dynamic SQL query method |
| CN112199577A (en) * | 2020-12-09 | 2021-01-08 | 浙江口碑网络技术有限公司 | Data query method and device and electronic equipment |
| CN112199577B (en) * | 2020-12-09 | 2021-04-02 | 浙江口碑网络技术有限公司 | Data query method and device and electronic equipment |
| CN112632098A (en) * | 2020-12-18 | 2021-04-09 | 平安普惠企业管理有限公司 | Dynamic generation method of structured query statement and related equipment |
| CN112988781A (en) * | 2021-02-02 | 2021-06-18 | 北京金山云网络技术有限公司 | Data query method and device, electronic equipment and computer readable storage medium |
| CN113505265A (en) * | 2021-07-27 | 2021-10-15 | 北京达佳互联信息技术有限公司 | Data query method and device, electronic equipment, storage medium and program product |
| CN113505265B (en) * | 2021-07-27 | 2024-03-01 | 北京达佳互联信息技术有限公司 | Data query method and device, electronic equipment, storage medium and program product |
| CN114416529A (en) * | 2021-12-21 | 2022-04-29 | 惠州市德赛西威汽车电子股份有限公司 | Configuration table-based diagnostic mode implementation method, storage medium, and computer program |
| CN115357604A (en) * | 2022-10-18 | 2022-11-18 | 天聚地合(苏州)科技股份有限公司 | Data query method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109947788B (en) | 2021-10-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109947788A (en) | Data query method and apparatus | |
| JP6736173B2 (en) | Method, system, recording medium and computer program for natural language interface to a database | |
| CN102053983B (en) | Method, system and device for querying vertical search | |
| CN110472207A (en) | List generation method and device | |
| CN111177231A (en) | Report generation method and report generation device | |
| CN109683998A (en) | Internationalize implementation method, device and system | |
| CN106919711B (en) | Method and device for labeling information based on artificial intelligence | |
| CN109783741A (en) | Method and apparatus for pushed information | |
| CN106326243B (en) | Data processing method and device | |
| US20200074509A1 (en) | Business data promotion method, device, terminal and computer-readable storage medium | |
| CN108958959A (en) | The method and apparatus for detecting hive tables of data | |
| CN111382279A (en) | Order examination method and device | |
| CN109726295A (en) | Brand knowledge map display methods, device, figure server and storage medium | |
| CN112347147A (en) | Information pushing method and device based on user association relationship and electronic equipment | |
| CN110309142A (en) | The method and apparatus of regulation management | |
| CN107291923B (en) | Information processing method and device | |
| CN111258988B (en) | Asset management method, device, electronic equipment and medium | |
| CN113450172A (en) | Commodity recommendation method and device | |
| CN111611155A (en) | RTA (remote terminal installation) DMP (distributed file protocol) releasing platform and method for realizing AB (AB test) and electronic equipment | |
| US20220164377A1 (en) | Method and apparatus for distributing content across platforms, device and storage medium | |
| CN109857838B (en) | Method and apparatus for generating information | |
| CN113760969A (en) | Data query method and device based on elastic search | |
| CN113157964A (en) | Method and device for searching data set through voice and electronic equipment | |
| CN110110199B (en) | Information output method and device | |
| CN112016017A (en) | Method and device for determining characteristic data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |