CN110109947A - The method and apparatus for extracting data - Google Patents
The method and apparatus for extracting data Download PDFInfo
- Publication number
- CN110109947A CN110109947A CN201711463037.8A CN201711463037A CN110109947A CN 110109947 A CN110109947 A CN 110109947A CN 201711463037 A CN201711463037 A CN 201711463037A CN 110109947 A CN110109947 A CN 110109947A
- Authority
- CN
- China
- Prior art keywords
- field
- sql statement
- number request
- sql
- splicing
- 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/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
- G06F16/2448—Query languages for particular applications; for extensibility, e.g. user defined types
-
- 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/2452—Query translation
- G06F16/24522—Translation of natural language queries to structured queries
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Artificial Intelligence (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of method and apparatus for extracting data, are related to field of computer technology.Wherein, this method comprises: reception user's input proposes several requests；Number request inquiry splicing allocation list is mentioned according to described, to obtain corresponding splicing configuration information；Number request and corresponding splicing configuration information generation SQL statement are mentioned according to described, to extract data according to the SQL statement.By above step, SQL statement, and then self-oriented extraction data can be automatically generated, personalized data requirements can not only be met, and can be improved and propose several efficiency, shorten and mention one number time.
Description
Technical field
The present invention relates to field of computer technology more particularly to a kind of method and apparatus for extracting data.
Background technique
In the big data production era, data have become the indispensable a part of enterprise production and management.Preferably to measure
The problems in the output that works or discovery operation, digitization measures index of correlation and has become the essential link of enterprise operation.With
The division of labor among enterprises it is more and more detailed-oriented and specialized, and not all post personnel all has and independently gets required number from database
According to technical ability.
For the data requirements for meeting all personnel, following two settling mode exists in the prior art: the first, passing through data
Visual Report Forms carry out data displaying；The second, enterprise proposes several personnel's Develop Datas extraction work by the way that recruitment is a certain number of.
In realizing process of the present invention, at least there are the following problems in the prior art: the first solution party for inventor's discovery
Formula is generally only able to satisfy the data requirements of general character, is not able to satisfy personalized data requirements；Although second of settling mode can
Meet personalized data requirements, but exists and mention that several efficiency are lower, mention one number time longer, artificial communication cost is biggish and ask
Topic.
Summary of the invention
In view of this, the present invention provides a kind of method and apparatus for extracting data, personalized data can not only be met
Demand, and can be improved mention several efficiency, shorten mention one number time.
To achieve the above object, according to an aspect of the invention, there is provided a kind of method for extracting data.
The method of extraction data of the invention include: receive user input propose several requests；It requests to look into according to the number that mentions
Splicing allocation list is ask, to obtain corresponding splicing configuration information；Number request and corresponding splicing configuration information are mentioned according to described
SQL statement is generated, to extract data according to the SQL statement.
It is optionally, described that propose number request include: output field, screening field, screening field value, operation used in screening
Symbol；The splicing allocation list includes: table name, the SQL of field is indicated, the SQL of operator is indicated in table.
Optionally, the step of number request and corresponding splicing configuration information generation SQL statement are mentioned according to packet
It includes: meeting in the corresponding splicing configuration information: in the case that table where the field mentioned in number request is one, by institute
The SQL expression for stating output field is placed in SELECT clause；The table name of table where the field mentioned in number request is placed in
In FROM clause；And the SQL of the operator according to used in the SQL expression of the screening field, the screening is indicated and institute
The SQL expression that screening field value constructs the screening conditions is stated, and the SQL of screening conditions expression is placed in WHERE clause
In.
Optionally, the splicing allocation list further include: configuration item, the main table for whether being main table are associated with non-master table
System.
Optionally, described the step of number request and corresponding splicing configuration information generation SQL statement are mentioned according to, goes back
Include: to meet in the corresponding splicing configuration information: table where the field mentioned in number request is multiple and there are one
It is described whether be main table configuration item value be "Yes" in the case where, mentioned described in generation number request in field where every table
SQL statement；The SQL statement of every table is connected with the incidence relation of non-master table according to the main table, and will be connected after
Entirety be nested in outermost FROM clause.
Optionally, described the step of number request and corresponding splicing configuration information generation SQL statement are mentioned according to, goes back
Include: to meet in the corresponding splicing configuration information: table where proposing the field in number request be it is multiple and it is all it is described whether
For the configuration item of main table value be "No" in the case where, mentioned described in generation number request in field where every table SQL language
The SQL statement of sentence and main table；It will be where the field that mentioned in number request according to the incidence relation of the main table and non-master table
The SQL statement of every table be connected with the SQL statement of main table, and the entirety after being connected is nested in outermost FROM clause
In.
Optionally, the splicing allocation list further include: the partition identification of table；It is described to propose number request according to and correspond to
Splicing configuration information generate SQL statement the step of further include: mentioned described in judgement number request in field where table subregion mark
Knowledge is increment list or full dose table；If increment list, when generating the SQL statement of the table by subregion condition setting are as follows: when subregion
Between with user selection time consistency；If full dose table, when generating the SQL statement of the table by subregion condition setting are as follows: subregion
Time is the previous day of the time of user's selection.
Optionally, the splicing allocation list further include: field whether be index configuration item；The number that mentions according to is asked
It asks and the step of corresponding splicing configuration information generates SQL statement further include: in the corresponding splicing configuration information satisfaction:
At least one output field it is corresponding it is described whether be index configuration item value be "Yes" in the case where, in generated SQL
GROUP BY clause is spliced at the end of sentence, and the output field for removing index is placed in GROUP BY clause.
To achieve the above object, according to another aspect of the present invention, a kind of device for extracting data is provided.
The device of extraction data of the invention includes: receiving module, for receive user input propose several requests；Inquire mould
Block, for mentioning number request inquiry splicing allocation list according to, to obtain corresponding splicing configuration information；Generation module is used for
Number request and corresponding splicing configuration information generation SQL statement are mentioned according to described, to extract data according to the SQL statement.
It is optionally, described that propose number request include: output field, screening field, screening field value, operation used in screening
Symbol；The splicing allocation list includes: table name, the SQL of field is indicated, the SQL of operator is indicated in table.
Optionally, the generation module proposes number request according to and corresponding splicing configuration information generates SQL statement
Operation include: to meet in the corresponding splicing configuration information: table where the field mentioned in number request is one feelings
Under condition, the SQL expression of the output field is placed in SELECT clause by the generation module；The generation module is mentioned described
The table name of table is placed in FROM clause where field in number request；And the generation module is according to the screening field
SQL is indicated, the SQL of operator used in the screening is indicated and the SQL for screening field value and constructing the screening conditions
It indicates, and the SQL of screening conditions expression is placed in WHERE clause.
Optionally, the splicing allocation list further include: configuration item, the main table for whether being main table are associated with non-master table
System.
Optionally, the generation module proposes number request according to and corresponding splicing configuration information generates SQL statement
Operation further include: it is described it is corresponding splicing configuration information meet: it is described mention number request in field where table be it is multiple and
There are described in one whether be main table configuration item value be "Yes" in the case where, the generation module generate described in propose several requests
In field where every table SQL statement；The generation module is according to the incidence relation of the main table and non-master table by institute
State mention number request in field where every table SQL statement be connected, and will be connected after entirety be nested in it is outermost
In FROM clause.
Optionally, the generation module proposes number request according to and corresponding splicing configuration information generates SQL statement
Operation further include: meet in the corresponding splicing configuration information: table where proposing the field in number request is multiple and all
It is described whether be main table configuration item value be "No" in the case where, the generation module generate described in propose field in number request
The SQL statement of every table at place and the SQL statement of main table；The generation module is according to the pass of the main table and non-master table
The SQL statement of every table where the field mentioned in number request is connected by connection relationship with the SQL statement of main table, and will be connected
Entirety afterwards is nested in outermost FROM clause.
Optionally, the splicing allocation list further include: the partition identification of table；The generation module proposes several requests according to
And corresponding splicing configuration information generates the operation of SQL statement further include: mentions in number request described in the generation module judgement
Field where the partition identification of table be increment list or full dose table；If increment list, SQL language of the generation module in the table
By subregion condition setting in sentence are as follows: the time consistency of zone time and user's selection；If full dose table, the generation module is at this
By subregion condition setting in the SQL statement of table are as follows: zone time is the previous day of the time of user's selection.
Optionally, the splicing allocation list further include: field whether be index configuration item；The generation module is according to institute
State the operation for proposing number request and corresponding splicing configuration information generation SQL statement further include: configure in the corresponding splicing
Information meets: at least one output field it is corresponding it is described whether be index configuration item value be "Yes" in the case where, it is described
Generation module splices GROUP BY clause at the end of generated SQL statement, also, the generation module will remove index
Output field is placed in GROUP BY clause.
To achieve the above object, according to a further aspect of the invention, a kind of server is provided.
Server of the invention, comprising: one or more processors；And storage device, for storing one or more
Program；When one or more of programs are executed by one or more of processors, so that one or more of processors
The method for realizing extraction data of the invention.
To achieve the above object, according to a further aspect of the invention, a kind of computer-readable medium is provided.
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 method of extraction data of the invention is realized when row.
One embodiment in foregoing invention has the following advantages that or the utility model has the advantages that is asked by the number that mentions for receiving user's input
It asks, mentions number request inquiry splicing allocation list according to described, to obtain corresponding splicing configuration information, and asked according to the number that mentions
It asks and corresponding splicing configuration information generates these steps of SQL statement, SQL statement can be automatically generated, and then self-oriented mention
Access evidence, can not only meet personalized data requirements, and can be improved and extract the efficiency of data, shortens and extract data
Period.
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 the method according to an embodiment of the invention for extracting data；
Fig. 2 is the key step schematic diagram of the method according to another embodiment of the present invention for extracting data；
Fig. 3 is the main modular schematic diagram of the device according to an embodiment of the invention for extracting data；
Fig. 4 is the main modular schematic diagram of the device according to another embodiment of the present invention for extracting data；
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.
Before the embodiment of the present invention is discussed in detail, first to the present embodiments relate to portion of techniques term say
It is bright.
SQL: structured query language, for accessing data and querying, updating, and managing relational database system.
Hive: it is a Tool for Data Warehouse based on Hadoop, the data file of structuring can be mapped to one
Database table, and simple SQL query function is provided, SQL statement can be converted to MapReduce task and run.
Fig. 1 is the key step schematic diagram of the method according to an embodiment of the invention for extracting data.As shown in Figure 1,
The method of the extraction data of the embodiment of the present invention includes:
Step S101, receive user's input proposes several requests.
Wherein, described to propose several requests can include: output field, screening conditions.The screening conditions can include: screening word
Section, screening operator used, screening field value.
For example, a certain user's proposes several requests are as follows: extract user's residence time on the page that Page Name is homepage
Data.Wherein, output field is " user's residence time ", and screening conditions are " page that Page Name is homepage ".In the sieve
It selects in condition, the operator that screening field is " Page Name ", screening is used is " being equal to ", screening field value is " homepage ".
Step S102, number request inquiry splicing allocation list is mentioned, according to obtain corresponding splicing configuration information.
Wherein, the splicing allocation list can include: the SQL of field is indicated in table name, table, the field selects for user
The configuration items such as the SQL expression of operator.Wherein, the operator that each field selects for user can be " being greater than ", " being less than ",
"comprising", " beginning is ", " ending is ", " between " etc. one or more.For example, in a certain splicing allocation list, word
The configuration item of section " device number " includes: " lab1 ", " uid ", "=".Wherein, " lab1 " is the table of table where field " device number "
Name, " uid " are that the SQL of field " device number " is indicated, "=" is the SQL table for the operator " being equal to " that the field selects for user
Show.
Illustratively, it is assumed that proposing the output field in number request is " user's residence time ", and screening field is " page name
", screening used operator is when be referred to as " being equal to ", then in a certain corresponding splicing configuration information for splicing and being inquired in allocation list
Meet: the table name of table where " user's residence time " this field is lab1, the SQL of the field is expressed as " dt ", " page name
" table where this field table name be referred to as lab1, the field SQL be expressed as " page_id ", used in " being equal to " this screening
The SQL of operator is expressed as "=".
Step S103, number request is proposed according to and corresponding splicing configuration information generates SQL statement, according to
SQL statement extracts data.
In embodiments of the present invention, by presetting splicing configuration information, and receive user number requests are proposed
Afterwards, corresponding splicing configuration information is obtained by inquiry splicing allocation list, and proposes number request and the corresponding spelling according to described
It connects configuration information and generates SQL statement, realize automatically generating for SQL statement, be convenient for self-oriented extraction data.With prior art phase
Than the method for the extraction data of the embodiment of the present invention can not only meet personalized data requirements, and can be improved and mention number
Efficiency, shortening mention one number time.
Fig. 2 is the key step schematic diagram of the method according to another embodiment of the present invention for extracting data.As shown in Fig. 2,
The method of the extraction data of the embodiment of the present invention includes:
Step S201, receive user's input proposes several requests.
Wherein, described to propose several requests can include: output field, screening conditions.The screening conditions can include: screening word
Section, screening operator used, screening field value.For example, a certain user's proposes several requests are as follows: in the page that Page Name is homepage
User's residence time on face.Wherein, output field is " user's residence time ", and screening conditions are that " Page Name is homepage
The page ".In the screening conditions, the operator that screening field is " Page Name ", screening is used is " being equal to ", screens field value
For " homepage ".
Further, before step S201, the method for the embodiment of the present invention may also include that be constructed according to data requirements and splice
Allocation list.Specifically, corresponding splicing allocation list can be set according to data requirements classification.For example, browsing related for order
Related, click correlation, the relevant data requirements of advertisement, can be respectively set the splicing allocation list of corresponding classification.In turn, it is not only convenient for
Splicing configuration information corresponding with number request is proposed is found, and quickly convenient for management user right.
Step S202, number request inquiry splicing allocation list is mentioned, according to obtain corresponding splicing configuration information.
Wherein, the splicing allocation list can include: the SQL of field is indicated in table name, table, the field selects for user
Whether the SQL expression of operator, the partition identification of table, field are the configuration items such as index.The partition identification of the table be to table into
The mark of row partition management, can include: increment list mark, full dose table mark.
Wherein, it when the value of " whether field is index " this configuration item is "Yes", indicates that the field is index, that is, means
The field need by calculate can just obtain.For example the two fields of order numbers, number of users are index；When " field whether be
When the value of this configuration item of index " is "No", indicate that the field is not index, this means that the field is interior to store in table
Hold, without can be obtained by calculating.For example order number, user account the two fields are not index.When it is implemented, index
The SQL expression of field is mostly function, and the SQL expression of non-index field is mostly the English name of field.For example, index field
The SQL of " order numbers " is expressed as function " count (order_id) ", and the SQL of non-index field " order number " is expressed as the field
English name " order_id ".
In addition, the splicing allocation list may also include that whether table is the configuration such as incidence relation of main table, main table and non-master table
?.Wherein, the incidence relation of the main table and non-master table can include: association keyword, associate field.For example, main table lab1 with
The incidence relation of non-master table lab2 includes: association keyword " join ", associate field " uid=uid ".
Step S203, table where proposing the field in number request described in judgement is one or multiple.If one, then executing
Step S204；If multiple, S205 is thened follow the steps.
Specifically, if the corresponding splicing configuration information found meets: including one in corresponding splicing configuration information
A table name table, then the table where the field mentioned in number request is one.If the corresponding splicing configuration information found is full
Foot: including multiple table names in corresponding splicing configuration information, then table where the field mentioned in number request is multiple.Wherein,
The field mentioned in number request refers to all fields including output field and screening field.
For example, it is assumed that proposing number request is " user's residence time on the page that Page Name is homepage ", this mentions number and asks
Output field in asking is " user's residence time ", and screening field is " Page Name ", also, in the corresponding splicing found
In configuration information, the table name of table is " lab1 " where field " user's residence time " and field " Page Name ", then can determine whether
Table where this proposes the field in number request out is one.
Step S204, the SQL statement of the table is generated.
Illustratively, step can include: the SQL expression of the output field is placed in SELECT clause；It will be described
The table name of table is placed in FROM clause where proposing the field in number request；And it is indicated according to the SQL of the screening field, institute
The SQL for stating screening operator used indicates and SQL that the screening field value constructs the screening conditions is indicated, and by institute
The SQL expression for stating screening conditions is placed in WHERE clause.
Further, in order to which the scene applicability for mentioning several sentences and accuracy, step S204 that improve generation may also include that root
Judge whether the output field includes index according to corresponding splicing configuration information.When the corresponding splicing configuration information is full
Foot: at least one output field it is described whether be index configuration item value be "Yes" in the case where, that is, indicate the output
Field includes index field, and then splices GROUP BY clause at the end of generated SQL statement, and will remove the finger
The output field of marking-up section is placed in GROUP BY clause.When the corresponding splicing configuration information meets: all output fields
It is described whether be index configuration item value be "No" in the case where, that is, indicating the output field not includes index field,
In turn, GROUP BY clause can be spliced at the end of generated SQL statement and all output fields is placed in GROUP BY
In sentence；Alternatively, can also be to generated SQL statement with no treatment.
For example, it is assumed that the number request that mentions of user's input meets: output field is " user's residence time " and " when averagely stopping
Between ", screening conditions are " page that Page Name is homepage " and " the output time is on December 13rd, 2017 ", then according to step
The SQL statement that S204 is generated is as follows:
Wherein, dt is that the SQL of " user's residence time " is indicated, avg (end_time-start_time) is index field
The SQL of " mean residence time " indicates that app.app_pv_time is table name where field, dt=' 2017-12-13 ' and page_
Id=' home ' is screening conditions.
Step S205, the SQL expression of the output field is placed in outermost SELECT clause.Step S205 it
Afterwards, step S206 can be performed.
Step S206, mention whether the table that number request is related to includes main table described in judgement.Match confidence in the corresponding splicing
Breath meet: there are described in one whether be main table configuration item value be "Yes" in the case where, that is, indicate described in mention number request in
Field where table include main table, and then execute step S207；Meet in the corresponding splicing configuration information: being described in all
In the case that the value of the no configuration item for main table is all "No", i.e., table where proposing the field in number request described in expression does not include master
Table, and then execute step S208.
Step S207, the SQL statement of every table where the field in number request is mentioned described in generation；Several requests are proposed by described
In field where every table SQL statement be connected, and will be connected after entirety be nested in outermost FROM clause.
The step is carried out for mentioning the SQL statement of the main table where the field in number request described in generating below detailed
Explanation.The process that the SQL statement of the main table where the field in number request is mentioned in an optional embodiment, described in generation can wrap
It includes:
Step a, judgement be located at main table output field in whether include main table and non-master table associate field.If it is not, holding
Row step b；If so, executing step c.
Step b, the associate field of main table Yu non-master table is obtained from splicing allocation list, and by the associate field, Yi Jiwei
It is placed in the SELECT clause of main table in the output field of main table.Then, step d can be performed.
Step c, the output field for being located at main table is placed in the SELECT clause of main table.Then, step d can be performed.
Further, it in step c, before the output field of the main table is placed in the SELECT clause of main table, also wraps
Include: whether the output field for judging the main table includes index field.When the corresponding splicing configuration information meets: at least one
A output field positioned at main table it is described whether be index configuration item value be "Yes" in the case where, judge the main table
Output field include index field, and then when generating the SELECT clause of main table, the English name of the field for index is set
In the SELECT clause of main table.Also, in step S205, being to be functional form (the i.e. index field of the field of index
SQL indicate) be placed in outermost SELECT clause.
Step d, splice the FROM clause of main table and the WHERE clause of main table.
Similarly, when mentioning the SQL statement of the non-master table where the field in number request described in the generation, it can take and operate
A to d similar judgment step, specifically includes: step a1 to step d1.
Whether it includes associate field with main table that a1, judgement are located in the output field of non-master table.If it is not, executing b1；If
It is to execute c1.
B1, the associate field of the non-master table and main table is obtained from splicing allocation list, and by the associate field and be located at
The output field of non-master table is placed in the SELECT clause of non-master table.Then, operation d1 can be performed.
C1, the output field for being located at non-master table is placed in the SELECT clause of the non-master table.Then, operation can be performed
d1。
The WHERE clause of d1, the FROM clause of the non-master table of splicing and non-master table.
Further, in step c1, before the output field of the non-master table is placed in the SELECT clause of non-master table,
Further include: whether the output field for judging the non-master table includes index field.When the corresponding splicing configuration information meets:
At least one be located at the output field of non-master table it is described whether be index configuration item value be "Yes" in the case where, judge
The output field of the non-master table includes index field, and then when generating the SELECT clause of non-master table, will be for the word of index
The English name of section is placed in the SELECT clause of non-master table.Also, in step S205, being to be the function shape of the field of index
Formula (i.e. the SQL of index field is indicated) is placed in outermost SELECT clause.
Step S208, the SQL statement of the SQL statement, main table that mention every table where the field in number request is generated；It will mention
The SQL statement of every table where field, the SQL statement of main table in number request are connected, and the entirety after being connected are nested in
In outermost FROM clause.
After step S204, step S207 or step S208, step S209 can be performed.
Further, in order to improve several efficiency, before step S209, the embodiment of the present invention be can comprise the further steps of:
The partition identification of table is increment list or full dose table where proposing the field in number request described in judgement.If increment list, then in life
At the table SQL statement when by subregion condition setting are as follows: the time consistency of zone time and user's selection；If full dose table, then
When generating the SQL statement of the table by subregion condition setting are as follows: zone time is the previous day of the time of user's selection.
Step S209, data warehouse execution will be pushed into the corresponding SQL statement of number requests that mentions.
Step S210, receive return mention number as a result, and proposing several results by described and showing user.
Illustratively, data bins will can be pushed into the corresponding SQL statement of number requests that mentions by Hive Sever2 process
Library executes, and after execution, receives mentioning for return by Hive Sever2 process and counts as a result, to propose several results for described
Show user.
In embodiments of the present invention, automatically generating for SQL statement is realized by above step, is convenient for self-oriented extraction number
According to.Compared with prior art, the method for the extraction data of the embodiment of the present invention can not only meet personalized data requirements,
And can be improved mention several efficiency, shorten mention one number time.
Fig. 3 is the main modular schematic diagram of the device according to an embodiment of the invention for extracting data.As shown in figure 3,
The device 300 of the extraction data of the embodiment of the present invention includes: receiving module 301, enquiry module 302, generation module 303.
Receiving module 301, for receive user input propose several requests.
Wherein, described to propose several requests can include: output field, screening conditions.The screening conditions can include: screening word
Section, screening operator used, screening field value.For example, a certain user's proposes several requests are as follows: in the page that Page Name is homepage
User's residence time on face.Wherein, output field is " user's residence time ", and screening conditions are that " Page Name is homepage
The page ".In the screening conditions, the operator that screening field is " Page Name ", screening is used is " being equal to ", screens field value
For " homepage ".
Enquiry module 302, for mentioning number request inquiry splicing allocation list according to, to obtain corresponding splicing with confidence
Breath.
Wherein, the splicing allocation list can include: the SQL of field is indicated in table name, table, the field selects for user
The configuration items such as the SQL expression of operator.Wherein, the operator that each field selects for user can be " being greater than ", " being less than ",
"comprising", " beginning is ", " ending is ", " between " etc. one or more.For example, in a certain splicing allocation list, word
The configuration item of section " device number " includes: " lab1 ", " uid ", "=".Wherein, " lab1 " is the table of table where field " device number "
Name, " uid " are that the SQL of field " device number " is indicated, "=" is the SQL table for the operator " being equal to " that the field selects for user
Show.
Generation module 303 generates SQL statement for proposing number request and corresponding splicing configuration information according to, with
Data are extracted according to the SQL statement.
In embodiments of the present invention, several requests are mentioned by receiving module reception user, passes through enquiry module and inquires splicing
Allocation list obtains corresponding splicing configuration information, and proposes number request and the corresponding splicing according to by generation module and match
Confidence breath generates SQL statement, realizes automatically generating for SQL statement, is convenient for self-oriented extraction data.Compared with prior art,
The device of the extraction data of the embodiment of the present invention can not only meet personalized data requirements, and can be improved and propose several effects
Rate, shortening mention one number time.
Fig. 4 is the main modular schematic diagram of the device according to another embodiment of the present invention for extracting data.As shown in figure 4,
The device 400 of the extraction data of the embodiment of the present invention includes: configuration module 401, receiving module 402, enquiry module 403, generates
Module 404.
Configuration module 401, for constructing splicing allocation list according to data requirements.Specifically, configuration module 401 can basis
The corresponding splicing allocation list of data requirements classification setting.For example, for order correlation, browsing is related, it is related to click, advertisement correlation
Data requirements, the splicing allocation list of corresponding classification can be respectively set.In turn, it is not only convenient for quickly finding and proposing number request pair
The splicing configuration information answered, and convenient for management user right.
Receiving module 402, for receive user input propose several requests.
Wherein, described to propose several requests can include: output field, screening conditions.The screening conditions can include: screening word
Section, screening operator used, screening field value.For example, a certain user's proposes several requests are as follows: in the page that Page Name is homepage
User's residence time on face.Wherein, output field is " user's residence time ", and screening conditions are that " Page Name is homepage
The page ".In the screening conditions, the operator that screening field is " Page Name ", screening is used is " being equal to ", screens field value
For " homepage ".
Enquiry module 403, for mentioning number request inquiry splicing allocation list according to, to obtain corresponding splicing with confidence
Breath.
Wherein, the splicing allocation list can include: the SQL of field is indicated in table name, table, the field selects for user
Whether the SQL expression of operator, the partition identification of table, field are the configuration items such as index.The partition identification of the table be to table into
The mark of row partition management, can include: increment list mark, full dose table mark.In addition, the splicing allocation list may also include that
Whether table is the configuration items such as the incidence relation of main table, main table and non-master table.Wherein, the incidence relation of the main table and non-master table can
It include: association keyword, associate field.
Generation module 404 generates SQL statement for proposing number request and corresponding splicing configuration information according to, with
Data are extracted according to the SQL statement.
Specifically, generation module 404 is generated includes: with the process for mentioning the corresponding SQL statement of several requests
Operation one, generation module 404 judge that table where the field mentioned in number request is one or multiple.
Specifically, if the corresponding splicing configuration information found meets: including one in corresponding splicing configuration information
A table name, then table where the field mentioned in number request is one.If the corresponding splicing configuration information found meets: right
It include multiple table names in the splicing configuration information answered, then table where the field mentioned in number request is multiple.Number is mentioned described
In the case that table where field in request is one, generation module 404 executes operation two；In the field mentioned in number request
In the case that place table is multiple, generation module 404 executes operation three.
Wherein, the field mentioned in number request refers to all fields including output field and screening field.
Operation two, generation module 404 generate the SQL statement of the table.
Illustratively, generation module 404 generates the SQL statement of the table can include: generation module 404 is by the output field
SQL expression be placed in SELECT clause；The table name of table where the field mentioned in number request is placed in by generation module 404
In FROM clause；And the operator according to used in the SQL expression of the screening field, the screening of generation module 404
The SQL that SQL is indicated and the screening field value constructs the screening conditions is indicated, and the SQL of the screening conditions is indicated
It is placed in WHERE clause.
Further, in order to improve the scene applicability for mentioning several sentences and accuracy of generation, generation module 404 generates the table
SQL statement may also include that generation module 404 according to corresponding splicing configuration information judge the output field whether include refer to
Mark.
Specifically, meet in the corresponding splicing configuration information: at least one output field it is corresponding it is described whether
For the configuration item of index value be "Yes" in the case where, that is, judge that the output field includes index field, so generate mould
Block 404 splices GROUP BY clause, and the output field that will remove the index field at the end of generated SQL statement
It is placed in GROUP BY clause.
Meet in the corresponding splicing configuration information: all output fields it is corresponding it is described whether be index configuration item
Value be "No" in the case where, that is, judging the output field not includes index field, and then generation module 404 can give birth to
At the end splicing of SQL statement GROUP BY clause and all output fields are placed in GROUP BY clause；Alternatively, raw
It can also be to generated SQL statement with no treatment at module 404.
The SQL expression of the output field is placed in outermost SELECT clause by operation three, generation module 404.It
Afterwards, the executable operation four of generation module 404.
Whether the table where operation four, generation module 404 judge the field proposed in number request includes main table.Described
It is corresponding splicing configuration information meet: there are described in one whether be main table configuration item value be "Yes" in the case where, judgement
Table where the field mentioned in number request includes main table out, and then operation five can be performed in generation module 404；Described corresponding
Splicing configuration information meets: it is all it is described whether be main table configuration item value be "No" in the case where, judge described to mention number
Table where field in request does not include main table, and then operation six can be performed in generation module 404.
Operation five, generation module 404 generate the SQL statement of every table where the field mentioned in number request；It generates
The SQL statement of every table where the field mentioned in number request is connected by module 404, and the entirety after being connected is nested in
In outermost FROM clause.
Below to behaviour by taking the SQL statement of the main table where generation module 404 generates the field proposed in number request as an example
Make five to be described in detail.In an optional embodiment, generation module 404 is generated where the field mentioned in number request
The process of the SQL statement of main table can include:
Operate A, generation module 404 judgement be located at main table output field in whether include main table and non-master table associated characters
Section.If it is not, executing operation B；If so, executing operation C.
Operation B, generation module 404 obtain the associate field of main table Yu non-master table from splicing allocation list, and by the association
It field and is placed in the SELECT clause of main table positioned at the output field of main table.Then, operation D can be performed.
The output field for being located at main table is placed in the SELECT clause of main table by operation C, generation module 404.Then, it can hold
Row operation D.
Operation D, generation module 404 splice the FROM clause of main table and the WHERE clause of main table.
Similarly, when mentioning the SQL statement of the non-master table where the field in number request described in the generation, it can take and operate
A to D similar judgment step, specifically includes:
Whether it includes associate field with main table that A1, the judgement of generation module 404 are located in the output field of non-master table.If
It is no, execute B1；If so, executing C1.
B1, generation module 404 obtain the associate field of the non-master table and main table from splicing allocation list, and by the associated characters
Section and be placed in the SELECT clause of non-master table positioned at the output field of non-master table.Then, operation D1 can be performed.
The output field for being located at non-master table is placed in the SELECT clause of the non-master table by C1, generation module 404.Then,
Executable operation D1.
D1, generation module 404 splice the FROM clause of non-master table and the WHERE clause of non-master table.
Operation six, generation module 404 generate the SQL of the SQL statement, main table that mention every table where the field in number request
Sentence；Generation module 404 will propose the SQL statement phase of the SQL statement and main table of every table where counting the field in request
Even, and by the entirety after being connected it is nested in outermost FROM clause.
Further, in order to improve several efficiency, generation module 404 can also be used in: the field in number request is proposed described in judgement
The partition identification of place table is increment list or full dose table.If increment list, then generation module 404 is in the SQL language for generating the table
By subregion condition setting when sentence are as follows: the time consistency of zone time and user's selection；If full dose table, then generation module 404 exists
By subregion condition setting when generating the SQL statement of the table are as follows: zone time is the previous day of the time of user's selection.
The device of the embodiment of the present invention realizes automatically generating for SQL statement, is convenient for self-oriented extraction data.With existing skill
Art is compared, the method for the extraction data of the embodiment of the present invention, can not only meet personalized data requirements, and can be improved
Propose several efficiency, shortening mentions one number time.
Fig. 5 is shown can be using the exemplary of the device of the method or extraction data of the extraction data of the embodiment of the present invention
System architecture 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 number request that mentions issued provides the back-stage management server supported.Back-stage management server can propose several requests to what is received
Etc. data carry out the processing such as analyzing, and processing result is fed back into terminal device.
It should be noted that the method that data are extracted provided by the embodiment of the present invention is generally executed by server 505, phase
Ying Di, the device for extracting data 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.
Server shown in Fig. 6 is only an example, should not function to the embodiment of the present invention and use scope bring any restrictions.
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, enquiry module, generation 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 " module that reception proposes number request ".
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
Obtain the equipment and execute following below scheme: receive user's input proposes several requests；Number request inquiry splicing allocation list is mentioned according to described, with
Obtain corresponding splicing configuration information；Number request and corresponding splicing configuration information generation SQL statement are mentioned according to described, with root
Data are extracted according to the SQL statement.
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 (18)
1. a kind of method for extracting data, which is characterized in that the described method includes:
Receive user's input proposes several requests；
Number request inquiry splicing allocation list is mentioned according to described, to obtain corresponding splicing configuration information；
Number request and corresponding splicing configuration information generation SQL statement are mentioned according to described, to extract number according to the SQL statement
According to.
2. the method according to claim 1, wherein it is described mention number request include: output field, screening field,
Screen operator used in field value, screening；The splicing allocation list include: table name, in table the SQL of field indicate, operator
SQL indicate.
3. according to the method described in claim 2, it is characterized in that, it is described mentioned according to number request and it is corresponding splicing match
Confidence breath generate SQL statement the step of include:
Meet in the corresponding splicing configuration information:, will in the case that table where the field mentioned in number request is one
The SQL expression of the output field is placed in SELECT clause；The table name of table where the field mentioned in number request is placed in
In FROM clause；And the SQL of the operator according to used in the SQL expression of the screening field, the screening is indicated and institute
The SQL expression that screening field value constructs the screening conditions is stated, and the SQL of screening conditions expression is placed in WHERE clause
In.
4. according to the method described in claim 3, it is characterized in that, the splicing allocation list further include: whether be matching for main table
Set the incidence relation of item, main table and non-master table.
5. according to the method described in claim 4, it is characterized in that, it is described mentioned according to number request and it is corresponding splicing match
The step of confidence breath generates SQL statement further include:
Meet in the corresponding splicing configuration information: table where the field mentioned in number request is multiple and there are one
It is described whether be main table configuration item value be "Yes" in the case where, the SQL language of every tables that number request is related to is mentioned described in generation
Sentence；The SQL statement of every table is connected with the incidence relation of non-master table according to the main table, and the entirety after being connected is embedding
It covers in outermost FROM clause.
6. according to the method described in claim 5, it is characterized in that, it is described mentioned according to number request and it is corresponding splicing match
The step of confidence breath generates SQL statement further include:
Meet in the corresponding splicing configuration information: table where proposing the field in number request be it is multiple and it is all it is described whether
For the configuration item of main table value be all "No" in the case where, mentioned described in generation number request in field where every table SQL
The SQL statement of sentence and main table；Described mention is counted into the field institute in requesting according to the incidence relation of the main table and non-master table
The SQL statement of every table be connected with the SQL statement of main table, and the entirety after being connected is nested in outermost FROM clause
In.
7. method according to any one of claims 2 to 6, which is characterized in that the splicing allocation list further include: the subregion of table
Mark；
Described the step of number request and corresponding splicing configuration information generation SQL statement are mentioned according to further include: judge institute
The partition identification for stating table where proposing the field in number request is increment list or full dose table；If increment list, the table is being generated
By subregion condition setting when SQL statement are as follows: the time consistency of zone time and user's selection；If full dose table, the table is being generated
SQL statement when by subregion condition setting are as follows: zone time is the previous day of the time of user's selection.
8. the method according to the description of claim 7 is characterized in that the splicing allocation list further include: whether field is index
Configuration item；
Described the step of number request and corresponding splicing configuration information generation SQL statement are mentioned according to further include:
Meet in the corresponding splicing configuration information: at least one output field it is corresponding it is described whether be index configuration item
Value be "Yes" in the case where, splice GROUP BY clause at the end of generated SQL statement, and the defeated of index will be removed
Field is placed in GROUPBY clause out.
9. a kind of device for extracting data, which is characterized in that described device includes:
Receiving module, for receive user input propose several requests；
Enquiry module, for mentioning number request inquiry splicing allocation list according to, to obtain corresponding splicing configuration information；
Generation module generates SQL statement for proposing number request and corresponding splicing configuration information according to, according to
SQL statement extracts data.
10. device according to claim 9, which is characterized in that it is described mention number request include: output field, screening field,
Screen operator used in field value, screening；The splicing allocation list include: table name, in table the SQL of field indicate, operator
SQL indicate.
11. device according to claim 10, which is characterized in that the generation module mentioned according to number request and it is right
The operation that the splicing configuration information answered generates SQL statement includes:
Meet in the corresponding splicing configuration information: in the case that table where the field mentioned in number request is one, institute
It states generation module the SQL expression of the output field is placed in SELECT clause；The generation module proposes several requests for described
In field where the table name of table be placed in FROM clause；And the generation module is according to the SQL table of the screening field
Show, the SQL of operator used in the screening indicate and it is described screening field value construct the screening conditions SQL indicate,
And the SQL of screening conditions expression is placed in WHERE clause.
12. device according to claim 11, which is characterized in that the splicing allocation list further include: whether be main table
The incidence relation of configuration item, main table and non-master table.
13. device according to claim 12, which is characterized in that the generation module mentioned according to number request and it is right
The splicing configuration information answered generates the operation of SQL statement further include:
Meet in the corresponding splicing configuration information: table where the field mentioned in number request is multiple and there are one
It is described whether be main table configuration item value be "Yes" in the case where, the generation module generate described in propose field in number request
The SQL statement of every table at place；The generation module is according to the incidence relation of the main table and non-master table by every table
SQL statement be connected, and will be connected after entirety be nested in outermost FROM clause.
14. device according to claim 13, which is characterized in that the generation module mentioned according to number request and it is right
The splicing configuration information answered generates the operation of SQL statement further include:
Meet in the corresponding splicing configuration information: table where proposing the field in number request be it is multiple and it is all it is described whether
For the configuration item of main table value be "No" in the case where, the generation module generate described in mention it is every where field in number request
Open the SQL statement of table and the SQL statement of main table；The generation module will according to the incidence relation of the main table and non-master table
The SQL statement of every table where the field mentioned in number request is connected with the SQL statement of main table, and will it is connected after entirety
It is nested in outermost FROM clause.
15. 0 to 14 any device according to claim 1, which is characterized in that the splicing allocation list further include: table
Partition identification；
The generation module proposes number request according to and the operation of corresponding splicing configuration information generation SQL statement is also wrapped
Include: the partition identification of table is increment list or full dose table where proposing the field in number request described in the generation module judgement；If
Increment list, the generation module is in the SQL statement of the table by subregion condition setting are as follows: zone time and user selection when
Between it is consistent；If full dose table, the generation module is in the SQL statement of the table by subregion condition setting are as follows: zone time is to use
The previous day of the time of family selection.
16. device according to claim 15, which is characterized in that the splicing allocation list further include: whether field is finger
Target configuration item；
The generation module proposes number request according to and the operation of corresponding splicing configuration information generation SQL statement is also wrapped
Include: meeting in the corresponding splicing configuration information: at least one output field it is corresponding it is described whether be index configuration item
Value be "Yes" in the case where, the generation module generated SQL statement end splice GROUP BY clause, also,
The output field for removing index is placed in GROUP BY clause by the generation module.
17. a kind of electronic equipment 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.
18. 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 |
|---|---|---|---|
| CN201711463037.8A CN110109947A (en) | 2017-12-28 | 2017-12-28 | The method and apparatus for extracting data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711463037.8A CN110109947A (en) | 2017-12-28 | 2017-12-28 | The method and apparatus for extracting data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110109947A true CN110109947A (en) | 2019-08-09 |
Family
ID=67482984
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711463037.8A Pending CN110109947A (en) | 2017-12-28 | 2017-12-28 | The method and apparatus for extracting data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110109947A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111651363A (en) * | 2020-06-29 | 2020-09-11 | 平安银行股份有限公司 | Test data acquisition method, test data acquisition device, electronic device and medium |
| CN112507353A (en) * | 2020-11-27 | 2021-03-16 | 中原银行股份有限公司 | Data extraction method and device |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101464862A (en) * | 2007-12-21 | 2009-06-24 | 英业达股份有限公司 | SQL generating system and method |
| CN103093000A (en) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | Database query modeling system and database query modeling method |
| CN104899231A (en) * | 2014-03-07 | 2015-09-09 | 上海市玻森数据科技有限公司 | Sentiment analysis engine based on fine-granularity attributive classification |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
| CN106250390A (en) * | 2016-07-15 | 2016-12-21 | 中国银联股份有限公司 | A kind of substep automatically generates the method and device of sql like language |
| CN106775770A (en) * | 2017-01-16 | 2017-05-31 | 兴唐通信科技有限公司 | The lookup method of query statement is built based on category information |
-
2017
- 2017-12-28 CN CN201711463037.8A patent/CN110109947A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101464862A (en) * | 2007-12-21 | 2009-06-24 | 英业达股份有限公司 | SQL generating system and method |
| CN103093000A (en) * | 2013-02-25 | 2013-05-08 | 用友软件股份有限公司 | Database query modeling system and database query modeling method |
| CN104899231A (en) * | 2014-03-07 | 2015-09-09 | 上海市玻森数据科技有限公司 | Sentiment analysis engine based on fine-granularity attributive classification |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
| CN106250390A (en) * | 2016-07-15 | 2016-12-21 | 中国银联股份有限公司 | A kind of substep automatically generates the method and device of sql like language |
| CN106775770A (en) * | 2017-01-16 | 2017-05-31 | 兴唐通信科技有限公司 | The lookup method of query statement is built based on category information |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111651363A (en) * | 2020-06-29 | 2020-09-11 | 平安银行股份有限公司 | Test data acquisition method, test data acquisition device, electronic device and medium |
| CN112507353A (en) * | 2020-11-27 | 2021-03-16 | 中原银行股份有限公司 | Data extraction method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111177231B (en) | Report generation method and report generation device | |
| US10055426B2 (en) | System and method transforming source data into output data in big data environments | |
| CN110472207A (en) | List generation method and device | |
| CN109144997A (en) | Data correlation method, device and storage medium | |
| CN108228906B (en) | Method and apparatus for generating information | |
| CN109683998A (en) | Internationalize implementation method, device and system | |
| CN109947788A (en) | Data query method and apparatus | |
| CN111913954B (en) | Intelligent data standard catalog generation method and device | |
| CN109033342A (en) | Applied to the service providing method of service system, device and service model | |
| CN112860744A (en) | Business process processing method and device | |
| CN108958959A (en) | The method and apparatus for detecting hive tables of data | |
| CN109241033A (en) | The method and apparatus for creating real-time data warehouse | |
| CN109901987A (en) | A kind of method and apparatus generating test data | |
| CN109840817A (en) | A kind of method and apparatus for inquiring order information | |
| CN109992495A (en) | The method and apparatus of interface testing | |
| CN110309142A (en) | The method and apparatus of regulation management | |
| CN109960212A (en) | Task sending method and device | |
| CN109753424A (en) | The method and apparatus of AB test | |
| CN109840534B (en) | Method and device for processing event | |
| CN110321252A (en) | A kind of method and apparatus of craft services scheduling of resource | |
| CN108959289B (en) | Website category acquisition method and device | |
| CN109409419A (en) | Method and apparatus for handling data | |
| CN110109912A (en) | A kind of identifier generation method and device | |
| CN110399397A (en) | A kind of data query method and system | |
| CN108959294A (en) | A kind of method and apparatus accessing search engine |
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 |