CN103902543A - Database inquiry method and device and database system - Google Patents
Database inquiry method and device and database system Download PDFInfo
- Publication number
- CN103902543A CN103902543A CN201210571717.2A CN201210571717A CN103902543A CN 103902543 A CN103902543 A CN 103902543A CN 201210571717 A CN201210571717 A CN 201210571717A CN 103902543 A CN103902543 A CN 103902543A
- Authority
- CN
- China
- Prior art keywords
- function
- identification
- database
- query statement
- interface message
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
Abstract
The embodiment of the invention discloses a database inquiry method and device and a database system. The database inquiry method comprises the steps of receiving an inquiry statement from a client terminal; analyzing the inquiry statement so as to obtain a function identification contained in the inquiry statement; searching N standard functions and M registered self-defining functions for a first function corresponding to the function identification, wherein the M and the N are natural numbers; if the first function corresponding to the function identification is found, obtaining first function calling interface information corresponding to the first function, calling the first function to search a database according to the obtained first function calling interface information, and feeding the processing result obtained through the operation carried out by the first function for searching the database back to the client terminal. According to the technical scheme, the database inquiry function is expanded, and the usability of database inquiry is improved.
Description
Technical field
The present invention relates to field of computer technology, be specifically related to a kind of data base query method and device and Database Systems.
Background technology
Along with the development of computer technology, there is increasing system and application.The scale of system and machine is also increasing, and for larger system, system adjustment and optimization is essential work.The basis of system adjustment and optimization is analytical performance data, and the mode of collecting performance data mostly is sampling.
Due to problems such as sampling interval short (may be generally a second level), the application operation length of machine scale greatly and in system, make the sampled point of performance data may be extremely many, thereby the data volume that has caused needs to process and analyze is very large, and these data of access also can more complicated.In the processing and access of large-scale data, database has good performance.But aspect data base querying, existing simple data library inquiry and computing function are sometimes difficult to meet the requirement of user to performance data analysis.For example, data that user often wishes to obtain wanting by shirtsleeve operation, may wish data directly can be represented to appearance in the mode of figure, and result is carried out manual drawing again.
Summary of the invention
The embodiment of the present invention provides data base query method and device and Database Systems, to enriching data base querying function, strengthens the ease for use of data base querying.
First aspect present invention provides a kind of data base query method, comprising:
Receive the query statement from client;
Resolve the function identification that described query statement is comprised to obtain described query statement;
In N canonical function and a registered M self-defining function, search and whether have first function corresponding with described function identification, wherein, described M and N are natural number;
If found first function corresponding with described function identification, obtain the first function call interface message that described the first function is corresponding, and call described the first function by described the first function call interface message getting database is carried out to search operation, to the first function described in described client feedback, database is carried out to search operation and the result that obtains.
In conjunction with first aspect, in the possible embodiment of the first, describedly in N canonical function and a registered M self-defining function, search the function that whether exists described function identification corresponding, comprising:
In available functions list, search and whether have the record mating with described function identification;
Wherein, record in described available functions list comprises the first field for recording function identification and for recording the second field of function call interface message, in described available functions list, record function identification and the function call interface message of N canonical function, in described available functions list, also recorded function identification and the function call interface message of M self-defining function.
In conjunction with the possible embodiment of the first of first aspect or first aspect, in the possible embodiment of the second, the part or all of function in a described M self-defining function is inquiry primitive.
In conjunction with the possible embodiment of the second of the possible embodiment of the first of first aspect or first aspect or first aspect, in the third possible embodiment, described the first function is in a described M self-defining function;
Before the step of described reception from the query statement of client, also comprise:
Receive the function registration request from client; Resolve function identification and the first function call interface message of described function registration request with the first function of obtaining described function registration request and being comprised, and in described available functions list, add a record, the function identification that a record of described interpolation comprises described the first function and the first function call interface message.
In conjunction with the third possible embodiment of the possible embodiment of the second of the possible embodiment of the first of first aspect or first aspect or first aspect or first aspect, in the 4th kind of possible embodiment, described the first function is function for calculating standard deviation or for drawing the function of scatter diagram or for drawing the function of histogram or for drawing the function of broken line graph, for calculating the function of related coefficient, for calculating the function of variance, relevant from the function of coefficient, for calculating the function of weighted mean value or the function for taking the logarithm for calculating.
Second aspect present invention provides a kind of database inquiry device, comprising:
The first receiving element, for receiving the query statement from client;
The first resolution unit, the function identification being comprised to obtain described query statement for resolving described query statement that described receiving element receives;
Search unit, for searching whether there be first function corresponding with described function identification at N canonical function and a registered M self-defining function, wherein, described M and N are natural number;
Function calling cell, if searching unit described in being used for has found and corresponding the first function of described function identification, obtain the function call interface message that described the first function is corresponding, and call described the first function by the described function call interface message getting database is carried out to search operation;
Feedback unit, the result obtaining for database being carried out to search operation to the first function described in described client feedback.
In conjunction with second aspect, in the possible embodiment of the first,
Described search unit specifically for, in available functions list, search and whether have the record mating with described function identification; Wherein, record in described available functions list comprises the first field for recording function identification and for recording the second field of function call interface message, in described available functions list, record function identification and the first function call interface message of N canonical function, in described available functions list, also recorded function identification and the first function call interface message of M self-defining function.
In conjunction with the possible embodiment of the first of second aspect or second aspect, in the possible embodiment of the second, described the first function is in a described M self-defining function;
Described database inquiry device also comprises:
The second receiving element, before receiving the described query statement from client at described the first receiving element, receives the function registration request from client;
Registering unit, for resolving described function registration request that described the second receiving element receives function identification and the function call interface message with the first function of obtaining described function registration request and being comprised, and in described available functions list, add a record, function identification and function call interface message that a record of described interpolation comprises described the first function.
In conjunction with the possible embodiment of the second of the possible embodiment of the first of second aspect or second aspect or second aspect, in the third possible embodiment, described the first function is function for calculating standard deviation or for drawing the function of scatter diagram or for drawing the function of histogram or for drawing the function of broken line graph, for calculating the function of related coefficient, for calculating the function of variance, relevant from the function of coefficient, for calculating the function of weighted mean value or the function for taking the logarithm for calculating.
In conjunction with the third possible embodiment of the possible embodiment of the second of the possible embodiment of the first of second aspect or second aspect or second aspect or second aspect, in the 4th kind of possible embodiment, the part or all of function in a described M self-defining function is inquiry primitive.
Third aspect present invention provides a kind of Database Systems, can comprise:
Client, virtual interpretation layer and database;
Wherein, described client is used for sending query statement;
Described virtual interpretation layer, for receiving the query statement from described client; Resolve the function identification that described query statement is comprised to obtain described query statement; In N canonical function and a registered M self-defining function, search the function that whether exists described function identification corresponding, wherein, described M and N are natural number; If found the first function corresponding to described function identification, obtain the function call interface message that described the first function is corresponding, and call described the first function by the described function call interface message getting described database is carried out to search operation, to the first function described in described client feedback, described database is carried out to search operation and the result that obtains.
Therefore embodiment of the present invention scheme is at the query statement receiving from client; Resolve the function identification that above-mentioned query statement is comprised to obtain above-mentioned query statement; In N canonical function and a registered M self-defining function, search the first function that whether exists above-mentioned function identification corresponding; If found the first function corresponding to above-mentioned function identification, by first function call interface interchange the first function corresponding to the first function, database is carried out to search operation, and feed back that the first function carries out search operation to database and the result that obtains.Owing to having proposed to introduce the mechanism of self-defining function in the present embodiment scheme, so just break the single defect of canonical function query function to a certain extent, be so conducive to expansion and enrich data base querying function, strengthen data base querying availability.
Brief description of the drawings
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, to the accompanying drawing of required use in embodiment or description of the Prior Art be briefly described below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, do not paying under the prerequisite of creative work, can also obtain according to these accompanying drawings other accompanying drawing.
Fig. 1 is the schematic flow sheet of a kind of data base query method of providing of the embodiment of the present invention;
Fig. 2-a is the configuration diagram of a kind of Database Systems of providing of the embodiment of the present invention;
Fig. 2-b is the configuration diagram of the another kind of Database Systems that provide of the embodiment of the present invention;
Fig. 3-a is the schematic diagram of a kind of database inquiry device of providing of the embodiment of the present invention;
Fig. 3-b is the schematic diagram of the another kind of database inquiry device that provides of the embodiment of the present invention;
Fig. 4-a is the schematic diagram of a kind of computer system of providing of the embodiment of the present invention;
Fig. 4-b is the schematic diagram of the another kind of computer system that provides of the embodiment of the present invention;
Fig. 5 is the configuration diagram that the embodiment of the present invention provides another a kind of Database Systems.
Embodiment
The embodiment of the present invention provides data base query method and device and Database Systems, to enriching data base querying function, strengthens the ease for use of data base querying.
In order to make those skilled in the art person understand better the present invention program, below in conjunction with the accompanying drawing in the embodiment of the present invention, technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the embodiment of a part of the present invention, instead of whole embodiment.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtaining under creative work prerequisite, should belong to the scope of protection of the invention.
Below be elaborated respectively.
Term " first " in instructions of the present invention and claims and above-mentioned accompanying drawing, " second ", " the 3rd " " 4th " etc. (if existence) are for distinguishing similar object, and needn't be used for describing specific order or precedence.The data that should be appreciated that such use suitably can exchanged in situation, so as embodiments of the invention described herein for example can with except diagram here or describe those order enforcement.In addition, term " comprises " and " having " and their any distortion, intention is to cover not exclusive comprising, for example, those steps or unit that process, method, system, product or the equipment that has comprised series of steps or unit is not necessarily limited to clearly list, but can comprise clearly do not list or for these processes, method, product or equipment intrinsic other step or unit.
An embodiment of data base query method of the present invention, a kind of data base query method can comprise: receive the query statement from client; Resolve the function identification that above-mentioned query statement is comprised to obtain above-mentioned query statement; In N canonical function and a registered M self-defining function, search the function that whether exists above-mentioned function identification corresponding; If found the first function corresponding to above-mentioned function identification, obtain the function call interface message that the first function is corresponding, and call the first function by the above-mentioned function call interface message getting database is carried out to search operation, database is carried out to search operation and the result that obtains to above-mentioned client feedback the first function.
Referring to Fig. 1, a kind of data base query method that the embodiment of the present invention provides can comprise:
101, receive the query statement from client.
In actual applications, user can send query statement by client, to ask that database is carried out to corresponding query manipulation.
102, resolve the function identification that above-mentioned query statement is comprised to obtain this query statement.
In some embodiments of the invention, receive after the query statement from client, can first check that whether the grammer of query statement is correct, if grammer is correct, resolve again the function identification that this query statement is comprised to obtain this query statement, if grammer is incorrect, can point out grammer incorrect.Certainly grammer that, also can default query statement is correct and do not carry out syntax check.Be understandable that, the function identification that may comprise one or more functions in query statement (for example can comprise the function identification of the first function, also can comprise the function identification of the second function etc.), can be by resolving the function identification of query statement with one or more functions of obtaining this query statement and being comprised.
103, in N canonical function and a registered M self-defining function, search and whether have first function corresponding with above-mentioned function identification.
Wherein, N and M can be natural number or positive integer.
In some embodiments of the invention, in an above-mentioned M self-defining function, partly or entirely can be inquiry primitive.
In some embodiments of the invention, can safeguard an available functions list, wherein, record in this available functions list can comprise the first field for recording function identification and for recording the second field of function call interface message, function identification and the function call interface message of N canonical function in available functions list, are for example recorded, in available functions list, also recorded function identification and the function call interface message of M self-defining function, wherein, above-mentioned M and N are natural number.For instance, recording of available functions list records the function identification of canonical function a1 and the function call interface message of canonical function a1 in a, recording of available functions list records the function identification of self-defining function b1 and the function call interface message of self-defining function b1 in b, certainly, in available functions list, also can record out of Memory, the position that such as function is stored and/or affiliated function library title etc.
In some embodiments of the invention, for example can in available functions list, search and whether exist and the record of resolving the function identification that obtains and mating; If find and the record of resolving the function identification that obtains and mating in available functions list, represent to have found first function corresponding to this function identification (for ease of citation, be referred to as the first function below), resolving the first function corresponding to function identification obtaining is available functions, and follow-up first function that can call carries out query manipulation.
Wherein, the first function may be the function for realizing various functions, and for example the first function can be function for calculating standard deviation or for drawing the function of scatter diagram or for drawing the function of histogram or for drawing the function of broken line graph, for calculating the function of related coefficient, for calculating the function of variance, relevant from the function of coefficient, for calculating the function of weighted mean value, for the function of taking the logarithm or for realizing the function of other function for calculating.
If 104 have found the first function corresponding to above-mentioned function identification, obtain the function call interface message that the first function is corresponding (for ease of citation, can claim the first function call interface message below), and call the first function by the first function call interface message getting database is carried out to search operation.
In some embodiments of the invention, if do not find function corresponding to above-mentioned function identification, invalid with prompting query failure or query function to client feedback information.For example, if do not find and the record of resolving the function identification that obtains and mating, represent not found function corresponding to this function identification in available functions list, resolving function corresponding to function identification obtaining may be unavailable function.
105, database is carried out to search operation and the result that obtains to above-mentioned client feedback the first function.
In some embodiments of the invention, if the first function is one of them in above-mentioned registered M self-defining function; Receive the first function registration process that also can comprise following way of example from the query statement of client before: receive the function registration request from client; Resolve function identification and the function call interface message of this function registration request with the first function of obtaining this function registration request and being comprised, and can in available functions list, add a record, the function identification that a record of this interpolation comprises the first function and the function call interface message of the first function, this interpolation record also can comprise the information of other and the first functional dependence certainly.Be appreciated that one of object of carrying out function registration is the available functions that this function of making becomes system.In actual applications, can provide self-defining function interface, for example, to utilize self-defining function interface to upgrade available functions list (increase in available functions list, deletion and/or amendment record), to realize registration of self-defining function etc.
In some embodiments of the invention, the virtual interpretation layer of new deployment that for example can be between client and database, the such scheme of the present embodiment for example can specifically be implemented in virtual interpretation layer, and the such scheme of the present embodiment also can be implemented in other query entity certainly.
Therefore the present embodiment scheme is at the query statement receiving from client; Resolve the function identification that above-mentioned query statement is comprised to obtain above-mentioned query statement; In N canonical function and a registered M self-defining function, search the first function that whether exists above-mentioned function identification corresponding; If found the first function corresponding to above-mentioned function identification, by function call interface interchange first function of the first function, database is carried out to search operation, and feed back that the first function carries out search operation to database and the result that obtains.Owing to having proposed to introduce the mechanism of self-defining function in the present embodiment scheme, so just break the single defect of canonical function query function to a certain extent, be so conducive to expansion and enrich data base querying function, strengthen data base querying availability.Can be by the self-defining function of the various functions of registration, support for example to ask the complicated displaying characteristics such as variance, related coefficient etc. complicated calculations, Query Result be graphical, visual, be conducive to like this data (for example can be conducive to performance data in more fully deep use analytical database etc.) in more fully deep use analytical database, and then be conducive to more reliably analyze more accurately data and lay the foundation for follow-up operation provides.
For ease of better understanding and implement the such scheme of the embodiment of the present invention, below by giving an example, application scenes describes.
Referring to Fig. 2-a and Fig. 2-b, Fig. 2-a and Fig. 2-b are the Organization Charts of two kinds of Database Systems providing of the embodiment of the present invention.
As shown in Fig. 2-a, between client 210 and database 230, dispose virtual interpretation layer 220, virtual interpretation layer 220 can be called the function in function library 240.Wherein, shown in 2-a, virtual interpretation layer 220 can comprise query interface 221, self-defining function interface 222, available functions list 223, Logical processing unit 224.Wherein, as shown in Fig. 2-b, Database Systems also can comprise Query Result integral unit 225.Wherein, client 210 can be browser.
The main query statement of reception from client 210 of being responsible for of query interface 221.
A query statement for example below:
select?std（E1），xplot（E2）from?all?where?app=”search”
Wherein, suppose that std and xplot may be self-defined inquiry primitive, suppose std() function for calculate standard deviation, xplot() function is the scatter diagram that draws data, the above-mentioned query statement meaning is data in the database in the time that 230 li of inquiry app of database are " search ", and returns to the standard deviation of E1 row and the scatter diagram of E2 row.Wherein, std and xplo all can regard function identification as.
In actual applications, user can send query statement by client 210, to ask that database 230 is carried out to corresponding query manipulation.
Whether main being responsible for of Logical processing unit 224 resolved the function identification that above-mentioned query statement is comprised to obtain this query statement, search and exist and the record of resolving the function identification that obtains and mating in available functions list 223.Wherein, if Logical processing unit 224 finds and the record of resolving the function identification that obtains and mating at available functions row 223 table, represent to have found the first function corresponding to this function identification,, function corresponding to function identification that parsing obtains is available functions, and follow-up first function that can call carries out query manipulation.Wherein, the first function for example can be function for calculating standard deviation or for drawing the function of scatter diagram or for realizing the function of other function.
Wherein, record in the available functions list 223 that virtual interpretation layer 220 is safeguarded can comprise the first field for recording function identification and for recording the second field of function call interface message, function identification and the function call interface message of N canonical function in available functions list 223, are for example recorded, the function identification and the function call interface message that in available functions list 223, have also recorded M self-defining function, wherein this M and N are natural number.For instance, recording of available functions list 223 records the function identification of canonical function a1 and the function call interface message of canonical function a1 in a, recording of available functions list 223 records the function identification of self-defining function b1 and the function call interface message of self-defining function b1 in b, certainly, in available functions list 223, also can record out of Memory, for example, function is stored position and/or affiliated function library title etc.
In some embodiments of the invention, in an above-mentioned M self-defining function, partly or entirely can be inquiry primitive.
If Logical processing unit 224 has found the first function corresponding to above-mentioned function identification, obtain the function call interface message that the first function is corresponding, and call the first function by the above-mentioned function call interface message getting database 230 is carried out to search operation.The data access interface that the first function can provide by database 230 obtains the corresponding data in database 230.
The main result of being responsible for the first function to carry out search operation to database 230 and obtain of Query Result integral unit 225 is integrated, and integrates result to client 210 feedbacks.The result that for example search operation obtains comprises data and figure, and Query Result integral unit 225 can by data and figure merges and to the result of client 210 feedback fusions.
The main responsible function registration request receiving from client 310 of self-defining function interface 222; Self-defining function interface 222 is resolved function identification and the function call interface message that this function registration request is comprised to obtain this function registration request, and can in available functions list 223, add a record, a record of this interpolation comprises resolves the function identification and the function call interface message that obtain, and this interpolation record also can comprise the information of other and the first functional dependence certainly.User can send to virtual interpretation layer 220 by self-defining function by client 20, and self-defining function interface 222 will add in function library 240 from the self-defining function of client 210.
In function library 240, can comprise multiple canonical functions and multiple self-defining function.Between some functions in function library 240, can mutually call.In function library 240, for example can comprise following self-defining function:
For the function xplot of picture scatter diagram,
For the function xhist of picture histogram,
For the function xline of picture broken line graph,
For calculate standard deviation function std,
For calculate related coefficient function corr,
For calculate variance function variance,
For calculate coefficient of autocorrelation function self_corr,
For calculate weighted mean value function weight_ave,
For the function geo_ave of set of computations mean value,
For calculating the function log that takes the logarithm etc.
A kind of course of work of the virtual interpretation layer 220 of giving an example below.
The query statement from client 210 receiving with query interface 221 below the following is example:
select?std（E1），xplot（E2）from?all?where?app=”search”
First, query interface 221 receives above-mentioned query statement, and query interface 221 judges that whether the grammer of this query statement is correct.Suppose that above-mentioned query statement grammer is correct, query interface 221 and then this query statement is passed to Logical processing unit 224.Logical processing unit 224 is resolved this query statement and is obtained function identification std and the xplot that this query statement comprises, suppose that the function that std and xplot are corresponding is self-defining function, Logical processing unit 224 inquires this function identification std and record corresponding to xplot in available functions list 223.And can in available functions list 223, find the function call interface message of self-defining function std and xplot, Logical processing unit 224 is utilized self-defining function std and the xplot in the function call interface message call function storehouse 240 of self-defining function std and xplot.The access interface that invoked self-defining function std and xplot provide by database 230 obtains the data in database 230.For example, function std obtains the E1 column data in all tables of data that in database 230, app is search, and this column data is calculated to standard deviation, then the standard deviation result of calculating is returned to virtual interpretation layer 220.Function xplot obtains E2 column data in all tables of data that in database 230, app is search, and E2 column data is drawn as to scatter diagram, then scatter diagram is returned to virtual interpretation layer 220.Virtual interpretation layer 220 has obtained standard deviation result and scatter diagram, and Query Result integral unit 225 combines this standard deviation result and scatter diagram, and the result after integrating is returned to client 210.
Be appreciated that the virtual interpretation layer 220 of the functional unit combination mode shown in Fig. 2-a and Fig. 2-b is only for illustrating, in actual applications, the framework of functional unit also may change flexibly.
Therefore, in the scheme of the present embodiment, between client 210 and database 230, introduce virtual interpretation layer 220, virtual interpretation layer 220 is for receiving the query statement from client 210; Resolve the function identification that above-mentioned query statement is comprised to obtain above-mentioned query statement; In N canonical function and a registered M self-defining function, search the function that whether exists above-mentioned function identification corresponding; If found the first function corresponding to above-mentioned function identification, by function call interface interchange first function of the first function, database is carried out to search operation, and feed back that the first function carries out search operation to database and the result that obtains.Owing to having proposed to introduce the mechanism of self-defining function in the present embodiment scheme, so just break the single defect of canonical function query function to a certain extent, be so conducive to expansion and enrich data base querying function, strengthen data base querying availability.And, introduce database inquiry device 220 and remove client 210 and database 230 direct-couplings, be conducive to simplify the external interface of client 210 and database 230.
For example, can be by the self-defining function of the various functions of registration, support for example to ask the complicated displaying characteristics such as variance, related coefficient etc. complicated calculations, graphical data be visual, be conducive to like this data in more fully deep use analytical database (for instance, can be conducive to performance data in more fully deep use analytical database etc.), and then be conducive to more reliably analyze more accurately data and lay the foundation for follow-up operation provides.
For ease of the better such scheme of implementing the embodiment of the present invention, be also provided for implementing the relevant apparatus of such scheme below.
Provide a kind of database inquiry device 300 referring to Fig. 3-a, the embodiment of the present invention, can comprise:
The first receiving element 310, the first resolution unit 320, search unit 330, function calling cell 340 and feedback unit 350.
Wherein, the first receiving element 310, for receiving the query statement from client;
The first resolution unit 320, the function identification being comprised to obtain above-mentioned query statement for resolving above-mentioned query statement that the first receiving element 310 receives;
In some embodiments of the invention, receive after the query statement from client at the first receiving element 310, the first resolution unit 320 can first check that whether the grammer of query statement is correct, if grammer is correct, resolve again the function identification that this query statement is comprised to obtain this query statement, if grammer is incorrect, can point out grammer incorrect.Certainly grammer that, also can default query statement is correct and do not carry out syntax check.Be understandable that, the function identification that may comprise one or more functions in query statement (for example can comprise the function identification of the first function, also can comprise the function identification of the second function etc.), the first resolution unit 320 can be by resolving the function identification of query statement with one or more functions of obtaining this query statement and being comprised.
In some embodiments of the invention, can safeguard an available functions list, wherein, record in this available functions list can comprise the first field for recording function identification and for recording the second field of function call interface message, function identification and the function call interface message of N canonical function in available functions list, are for example recorded, in available functions list, also recorded function identification and the function call interface message of M self-defining function, wherein, above-mentioned M and N are natural number.For instance, recording of available functions list records the function identification of canonical function a1 and the function call interface message of canonical function a1 in a, recording of available functions list records the function identification of self-defining function b1 and the function call interface message of self-defining function b1 in b, certainly, in available functions list, also can record out of Memory, the position that such as function is stored and/or affiliated function library title etc.
In some embodiments of the invention, in above-mentioned chartered M self-defining function, partly or entirely can be inquiry primitive.
In some embodiments of the invention, searching unit 330 can be specifically for, searches and whether have the record mating with above-mentioned function identification in available functions list.In some embodiments of the invention, do not find function corresponding to above-mentioned function identification if search unit 330, feedback unit 350 also can be invalid with prompting query failure or query function to client feedback information.For example, if search unit 330 does not find with the first resolution unit 320 and resolves the record that the function identification that obtains is mated in available functions list, represent not found function corresponding to this function identification, it may be unavailable function that the first resolution unit 320 is resolved function corresponding to function identification obtaining.
Wherein, the first function may be the function for realizing various functions, and for example the first function can be function for calculating standard deviation or for drawing the function of scatter diagram or for drawing the function of histogram or for drawing the function of broken line graph, for calculating the function of related coefficient, for calculating the function of variance, relevant from the function of coefficient, for calculating the function of weighted mean value, for the function of taking the logarithm or for realizing the function of other function for calculating.
Referring to Fig. 3-b, in some embodiments of the invention, if the first function is one of them in above-mentioned registered M self-defining function, database inquiry device 300 also can comprise: the second receiving element 360 and registering unit 370.
The second receiving element 360, before receiving the above-mentioned query statement from client at the first receiving element 310, receives the function registration request from client.
Registering unit 370, for resolving the above-mentioned function registration request that the second receiving element 360 receives, to obtain function identification and the first function call interface message of the first function that above-mentioned function registration request comprised, and in above-mentioned available functions list, add a record, the function identification that a record of above-mentioned interpolation comprises the first function and the first function call interface message.
Be understandable that, the function of each functional module of the database inquiry device 300 of the present embodiment can be according to the method specific implementation in said method embodiment, and its specific implementation process can, with reference to the associated description of said method embodiment, repeat no more herein.
Therefore the present embodiment database inquiry device 300 receives the query statement from client; Resolve the function identification that above-mentioned query statement is comprised to obtain above-mentioned query statement; In N canonical function and a registered M self-defining function, search the function that whether exists above-mentioned function identification corresponding; If found the first function corresponding to above-mentioned function identification, by function call interface interchange first function of the first function, database is carried out to search operation, and feed back that the first function carries out search operation to database and the result that obtains.Owing to having proposed to introduce the mechanism of self-defining function in the present embodiment scheme, so just break the single defect of canonical function query function to a certain extent, be so conducive to expansion and enrich data base querying function, strengthen data base querying availability.Can be by the self-defining function of the various functions of registration, support for example to ask the complicated displaying characteristics such as variance, related coefficient etc. complicated calculations, graphical data be visual, be conducive to like this data (for example can be conducive to performance data in more fully deep use analytical database etc.) in more fully deep use analytical database, and then be conducive to more reliably analyze more accurately data and lay the foundation for follow-up operation provides.
Fig. 4-a is the structural representation of a kind of computer system provided by the invention, as shown in Fig. 4-a, the computer system of the present embodiment comprises at least one bus 401, at least one processor 402 being connected with bus 401 and at least one storer 403 being connected with bus 401.
Wherein, processor 402 calls the code of storage in storer 403 by bus 401, for receiving the query statement from above-mentioned client; Resolve the function identification that above-mentioned query statement is comprised to obtain above-mentioned query statement; In N canonical function and a registered M self-defining function, search the first function that whether exists above-mentioned function identification corresponding, wherein, above-mentioned N and M are natural number; If found the first function corresponding to above-mentioned function identification, obtain the first function call interface message that the first function is corresponding, and call the first function by the first function call interface message getting database is carried out to search operation, to client feedback the first function, database is carried out to search operation and the result that obtains.
In some embodiments of the invention, processor 402 is after the query statement receiving from client, whether the grammer that can first check query statement is correct, if grammer is correct, resolve again the function identification that this query statement is comprised to obtain this query statement, if grammer is incorrect, can point out grammer incorrect.Certainly grammer that also can default query statement is correct and do not carry out syntax check.Be understandable that, may comprise the function identification of one or more functions in query statement, processor 402 can be by resolving the function identification of query statement with one or more functions of obtaining this query statement and being comprised.
Wherein, N and M can be natural number or positive integer.
In some embodiments of the invention, in an above-mentioned M self-defining function, partly or entirely can be inquiry primitive.
In some embodiments of the invention, processor 402 can be safeguarded an available functions list, record in this available functions list can comprise the first field for recording function identification and for recording the second field of function call interface message, function identification and the function call interface message of N canonical function in available functions list, are for example recorded, function identification and the function call interface message of M self-defining function in available functions list, are also recorded, wherein, above-mentioned M and N are natural number.For instance, recording of available functions list records the function identification of canonical function a1 and the function call interface message of canonical function a1 in a, recording of available functions list records the function identification of self-defining function b1 and the function call interface message of self-defining function b1 in b, certainly, in available functions list, also can record out of Memory, the position that such as function is stored and/or affiliated function library title etc.
In some embodiments of the invention, whether processor 402 for example can be searched and exist and the record of resolving the function identification that obtains and mating in available functions list; If find and the record of resolving the function identification that obtains and mating in available functions list, represent to have found function corresponding to this function identification (for ease of citation, be referred to as the first function below),, function corresponding to function identification that parsing obtains is available functions, and follow-up first function that can call carries out query manipulation.
Wherein, the first function may be the function for realizing various functions, and for example the first function can be function for calculating standard deviation or for drawing the function of scatter diagram or for drawing the function of histogram or for drawing the function of broken line graph, for calculating the function of related coefficient, for calculating the function of variance, relevant from the function of coefficient, for calculating the function of weighted mean value, for the function of taking the logarithm or for realizing the function of other function for calculating.
In some embodiments of the invention, if processor 402 does not find function corresponding to above-mentioned function identification, processor 402 is invalid with prompting query failure or query function to client feedback information.For example, if do not find and the record of resolving the function identification that obtains and mating, represent not found function corresponding to this function identification in available functions list, resolving function corresponding to function identification obtaining may be unavailable function.
In some embodiments of the invention, if the first function is one of them in above-mentioned registered M self-defining function; Processor 402 also can comprise the first function registration process of carrying out following way of example before receiving the query statement from client:, processor 402 also can be used for, and receives the function registration request from client; Resolve this function registration request with the function identification of the first function of obtaining this function registration request and being comprised and the first function the first function call interface message, and can in available functions list, add a record, the function identification that a record of this interpolation comprises the first function and the first function call interface message of the first function, certainly, this interpolation record also can comprise the information of some other and the first functional dependence.Be understandable that, one of object of carrying out function registration is the available functions that this function of making becomes system.
In actual applications, processor 402 can provide self-defining function interface, for example, to utilize self-defining function interface to upgrade available functions list (, increase in available functions list, deletion and/or amendment record etc.), to realize registration of self-defining function etc.
In some embodiments of the invention, processor 402 can carry out search operation to database by the first function and the result that obtains is integrated, and integrates result to client feedback.For example search operation and the result that obtains comprises data and figure, processor 402 can merge data and figure, the result merging to client feedback.
Referring to Fig. 4-b, the structural representation of the another kind of computer system 400 that Fig. 4-b provides for the embodiment of the present invention, computer system 400 also can comprise input media 404 and output unit 405, input media 404 and output unit 405 and bus 401.
The computer system that the present embodiment provides, can be for carrying out the corresponding part of carrying out of technical scheme Computer system of said method embodiment, and it realizes principle and technique effect is similar, repeats no more herein.Fig. 4-a or Fig. 4-a are only a kind of schematic diagram of the structure of computer system provided by the invention, and concrete structure can be adjusted according to actual.
Therefore the present embodiment computer system 400 receives the query statement from client; Resolve the function identification that above-mentioned query statement is comprised to obtain above-mentioned query statement; In N canonical function and a registered M self-defining function, search the function that whether exists above-mentioned function identification corresponding; If found the first function corresponding to above-mentioned function identification, by function call interface interchange first function of the first function, database is carried out to search operation, and feed back that the first function carries out search operation to database and the result that obtains.Owing to having proposed to introduce the mechanism of self-defining function in the present embodiment scheme, so just break the single defect of canonical function query function to a certain extent, be so conducive to expansion and enrich data base querying function, strengthen data base querying availability.Can be by the self-defining function of the various functions of registration, support for example to ask the complicated displaying characteristics such as variance, related coefficient etc. complicated calculations, graphical data be visual, be conducive to like this data (for example can be conducive to performance data in more fully deep use analytical database etc.) in more fully deep use analytical database, and then be conducive to more reliably analyze more accurately data and lay the foundation for follow-up operation provides.
Referring to Fig. 5, the embodiment of the present invention also provides a kind of Database Systems, can comprise:
Wherein, client 510 is for sending query statement.
Wherein, client 510 can be browser.
In some embodiments of the invention, virtual interpretation layer 520 is after the query statement receiving from client 510, whether the grammer that can first check query statement is correct, if grammer is correct, resolve again the function identification that this query statement is comprised to obtain this query statement, if grammer is incorrect, can point out grammer incorrect.Certainly grammer that also can default query statement is correct and do not carry out syntax check.Be understandable that, may comprise the function identification of one or more functions in query statement, virtual interpretation layer 520 can be by resolving the function identification of query statement with one or more functions of obtaining this query statement and being comprised.
Wherein, N and M can be natural number or positive integer.
In some embodiments of the invention, in an above-mentioned M self-defining function, partly or entirely can be inquiry primitive.
In some embodiments of the invention, virtual interpretation layer 520 can be safeguarded an available functions list, wherein, record in this available functions list can comprise the first field for recording function identification and for recording the second field of function call interface message, function identification and the function call interface message of N canonical function in available functions list, are for example recorded, function identification and the function call interface message of M self-defining function in available functions list, are also recorded, wherein, above-mentioned M and N are natural number.For instance, recording of available functions list records the function identification of canonical function a1 and the function call interface message of canonical function a1 in a, recording of available functions list records the function identification of self-defining function b1 and the function call interface message of self-defining function b1 in b, certainly, in available functions list, also can record out of Memory, the position that such as function is stored and/or affiliated function library title etc.
In some embodiments of the invention, whether virtual interpretation layer 520 for example can search and exist and the record of resolving the function identification that obtains and mating in available functions list; If find and the record of resolving the function identification that obtains and mating in available functions list, represent to have found the first function corresponding to this function identification, resolving the first function corresponding to function identification obtaining is available functions, and follow-up first function that can call carries out query manipulation.
Wherein, the first function may be the function for realizing various functions, and for example the first function can be function for calculating standard deviation or for drawing the function of scatter diagram or for drawing the function of histogram or for drawing the function of broken line graph, for calculating the function of related coefficient, for calculating the function of variance, relevant from the function of coefficient, for calculating the function of weighted mean value, for the function of taking the logarithm or for realizing the function of other function for calculating.
In some embodiments of the invention, if virtual interpretation layer 520 does not find function corresponding to above-mentioned function identification, invalid with prompting query failure or query function to client feedback information.For example, if do not find and the record of resolving the function identification that obtains and mating, represent not found function corresponding to this function identification in available functions list, resolving function corresponding to function identification obtaining may be unavailable function.
In some embodiments of the invention, if the first function is one of them in above-mentioned registered M self-defining function; Virtual interpretation layer 520 also can comprise the first function registration process of carrying out following way of example before receiving the query statement from client:, virtual interpretation layer 520 also can be used for, and receives the function registration request from client 510; Resolve the function identification of the first function and the first function call interface message of the first function that this function registration request is comprised to obtain this function registration request, and can in available functions list, add a record, the function identification that a record of this interpolation comprises the first function and the first function call interface message of the first function, certainly, this interpolation record also can comprise the information of other and the first functional dependence.Be understandable that, one of object of carrying out function registration is the available functions that this function of making becomes system.In actual applications, virtual interpretation layer 520 can provide self-defining function interface, for example, to utilize self-defining function interface to upgrade available functions list (increase in available functions list, deletion and/or amendment record), to realize registration of self-defining function etc.
In some embodiments of the invention, virtual interpretation layer 520 can be carried out search operation to database 530 by the first function and the result that obtains is integrated, and integrates results to client 510 feedbacks.For example search operation and the result that obtains comprises data and figure, virtual interpretation layer 520 can merge data and figure, to the result of client 510 feedback fusions.
Therefore the scheme of the present embodiment is introduced virtual interpretation layer 520 between client 510 and database 530, virtual interpretation layer 520 is for receiving the query statement from client 510; Resolve the function identification that above-mentioned query statement is comprised to obtain above-mentioned query statement; In N canonical function and a registered M self-defining function, search the function that whether exists above-mentioned function identification corresponding; If found the first function corresponding to above-mentioned function identification, by function call interface interchange first function of the first function, database is carried out to search operation, and feed back that the first function carries out search operation to database and the result that obtains.Owing to having proposed to introduce the mechanism of self-defining function in the present embodiment scheme, so just break the single defect of canonical function query function to a certain extent, be so conducive to expansion and enrich data base querying function, strengthen data base querying availability.And, introduce database inquiry device 520 and remove client 510 and database 530 direct-couplings, be conducive to simplify the external interface of client 510 and database 530.Can be by the self-defining function of the various functions of registration, support for example to ask the complicated displaying characteristics such as variance, related coefficient etc. complicated calculations, graphical data be visual, be conducive to like this data (for example can be conducive to performance data in more fully deep use analytical database etc.) in more fully deep use analytical database, and then be conducive to more reliably analyze more accurately data and lay the foundation for follow-up operation provides.
The embodiment of the present invention also provides a kind of computer-readable storage medium, and wherein, this computer-readable storage medium can have program stored therein, and this program comprises the part or all of step of the data base query method of recording in said method embodiment while execution.
It should be noted that, for aforesaid each embodiment of the method, for simple description, therefore it is all expressed as to a series of combination of actions, but those skilled in the art should know, the present invention is not subject to the restriction of described sequence of movement, because according to the present invention, some step can adopt other orders or carry out simultaneously.Secondly, those skilled in the art also should know, the embodiment described in instructions all belongs to preferred embodiment, and related action and unit might not be that the present invention is necessary.
In the above-described embodiments, the description of each embodiment is all emphasized particularly on different fields, in certain embodiment, there is no the part of detailed description, can be referring to the associated description of other embodiment.
In the several embodiment that provide in the application, should be understood that disclosed device can be realized by another way.For example, device embodiment described above is only schematic, the division of for example said units, be only that a kind of logic function is divided, when actual realization, can there is other dividing mode, for example multiple unit or assembly can in conjunction with or can be integrated into another system, or some features can ignore, or do not carry out.Another point, shown or discussed coupling each other or direct-coupling or communication connection can be by some interfaces, indirect coupling or the communication connection of device or unit can be electrical or other form.
The above-mentioned unit as separating component explanation can or can not be also physically to separate, and the parts that show as unit can be or can not be also physical locations, can be positioned at a place, or also can be distributed in multiple network element.Can select according to the actual needs some or all of unit wherein to realize the object of the present embodiment scheme.
In addition, the each functional unit in each embodiment of the present invention can be integrated in a processing unit, can be also that the independent physics of unit exists, and also can be integrated in a unit two or more unit.Above-mentioned integrated unit both can adopt the form of hardware to realize, and also can adopt the form of SFU software functional unit to realize.
If above-mentioned integrated unit is realized and during as production marketing independently or use, can be stored in a computer read/write memory medium using the form of SFU software functional unit.Based on such understanding, the all or part of of the part that technical scheme of the present invention contributes to prior art in essence in other words or this technical scheme can embody with the form of software product, this computer software product is stored in a storage medium, comprises that some instructions are in order to make a computer equipment (can be personal computer, server or the network equipment etc.) carry out all or part of step of each embodiment said method of the present invention.And aforesaid storage medium comprises: various media that can be program code stored such as USB flash disk, ROM (read-only memory) (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), portable hard drive, magnetic disc or CDs.
Above-mentioned above, above embodiment only, in order to technical scheme of the present invention to be described, is not intended to limit; Although the present invention is had been described in detail with reference to previous embodiment, those of ordinary skill in the art is to be understood that: its technical scheme that still can record aforementioned each embodiment is modified, or part technical characterictic is wherein equal to replacement; And these amendments or replacement do not make the essence of appropriate technical solution depart from the spirit and scope of various embodiments of the present invention technical scheme.
Claims (10)
1. a data base query method, is characterized in that, comprising:
Receive the query statement from client;
Resolve the function identification that described query statement is comprised to obtain described query statement;
In N canonical function and a registered M self-defining function, search and whether have first function corresponding with described function identification, wherein, described M and N are natural number;
If found first function corresponding with described function identification, obtain the first function call interface message that described the first function is corresponding, and call described the first function by described the first function call interface message getting database is carried out to search operation, to the first function described in described client feedback, database is carried out to search operation and the result that obtains.
2. method according to claim 1, is characterized in that,
Describedly in N canonical function and a registered M self-defining function, search the function that whether exists described function identification corresponding, comprising:
In available functions list, search and whether have the record mating with described function identification;
Wherein, record in described available functions list comprises the first field for recording function identification and for recording the second field of function call interface message, in described available functions list, record function identification and the function call interface message of N canonical function, in described available functions list, also recorded function identification and the function call interface message of M self-defining function.
3. method according to claim 1 and 2, is characterized in that, the part or all of function in a described M self-defining function is inquiry primitive.
4. according to the method described in claims 1 to 3 any one, it is characterized in that,
Described the first function is in a described M self-defining function;
Before the step of described reception from the query statement of client, also comprise:
Receive the function registration request from client;
Resolve function identification and the first function call interface message of described function registration request with the first function of obtaining described function registration request and being comprised, and in described available functions list, add a record, the function identification that a record of described interpolation comprises described the first function and the first function call interface message.
5. according to the method described in claim 1 to 4 any one, it is characterized in that, described the first function is function for calculating standard deviation or for drawing the function of scatter diagram or for drawing the function of histogram or for drawing the function of broken line graph, for calculating the function of related coefficient, for calculating the function of variance, relevant from the function of coefficient, for calculating the function of weighted mean value or the function for taking the logarithm for calculating.
6. a database inquiry device, is characterized in that, comprising:
The first receiving element, for receiving the query statement from client;
The first resolution unit, the function identification being comprised to obtain described query statement for resolving described query statement that described receiving element receives;
Search unit, for searching whether there be first function corresponding with described function identification at N canonical function and a registered M self-defining function, wherein, described M and N are natural number;
Function calling cell, if searching unit described in being used for has found and corresponding the first function of described function identification, obtain the function call interface message that described the first function is corresponding, and call described the first function by the described function call interface message getting database is carried out to search operation;
Feedback unit, the result obtaining for database being carried out to search operation to the first function described in described client feedback.
7. database inquiry device according to claim 6, is characterized in that,
Described search unit specifically for, in available functions list, search and whether have the record mating with described function identification; Wherein, record in described available functions list comprises the first field for recording function identification and for recording the second field of function call interface message, in described available functions list, record function identification and the function call interface message of N canonical function, in described available functions list, also recorded function identification and the function call interface message of M self-defining function.
8. according to the database inquiry device described in claim 6 to 7 any one, it is characterized in that,
Described the first function is in a described M self-defining function;
Described database inquiry device also comprises:
The second receiving element, before receiving the described query statement from client at described the first receiving element, receives the function registration request from client;
Registering unit, for resolving described function registration request that described the second receiving element receives function identification and the first function call interface message with the first function of obtaining described function registration request and being comprised, and in described available functions list, add a record, the function identification that a record of described interpolation comprises described the first function and the first function call interface message.
9. according to the database inquiry device described in claim 6 to 8 any one, it is characterized in that, described the first function is function for calculating standard deviation or for drawing the function of scatter diagram or for drawing the function of histogram or for drawing the function of broken line graph, for calculating the function of related coefficient, for calculating the function of variance, relevant from the function of coefficient, for calculating the function of weighted mean value or the function for taking the logarithm for calculating.
10. Database Systems, is characterized in that, comprising:
Client, virtual interpretation layer and database;
Wherein, described client is used for sending query statement;
Described virtual interpretation layer, for receiving the query statement from described client; Resolve the function identification that described query statement is comprised to obtain described query statement; In N canonical function and a registered M self-defining function, search the function that whether exists described function identification corresponding, wherein, described M and N are natural number; If found the first function corresponding to described function identification, obtain the function call interface message that described the first function is corresponding, and call described the first function by the described function call interface message getting described database is carried out to search operation, to the first function described in described client feedback, described database is carried out to search operation and the result that obtains.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210571717.2A CN103902543A (en) | 2012-12-25 | 2012-12-25 | Database inquiry method and device and database system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210571717.2A CN103902543A (en) | 2012-12-25 | 2012-12-25 | Database inquiry method and device and database system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103902543A true CN103902543A (en) | 2014-07-02 |
Family
ID=50993873
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210571717.2A Pending CN103902543A (en) | 2012-12-25 | 2012-12-25 | Database inquiry method and device and database system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103902543A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105701128A (en) * | 2014-11-28 | 2016-06-22 | 华为技术有限公司 | Query statement optimization method and apparatus |
| WO2016127851A1 (en) * | 2015-02-12 | 2016-08-18 | Huawei Technologies Co., Ltd. | Method and query optimization server for associating functions with columns for optimizing query execution |
| CN106547883A (en) * | 2016-11-03 | 2017-03-29 | 北京集奥聚合科技有限公司 | A kind of processing method and system of user-defined function UDF ruuning situations |
| CN107678968A (en) * | 2017-10-18 | 2018-02-09 | 北京奇虎科技有限公司 | Sample extraction method, apparatus, computing device and the storage medium of source code function |
| CN109284097A (en) * | 2018-09-07 | 2019-01-29 | 武汉轻工大学 | Realize method, equipment, system and the storage medium of complex data analysis |
| CN109460416A (en) * | 2018-12-12 | 2019-03-12 | 成都四方伟业软件股份有限公司 | A kind of data processing method, device, electronic equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040199636A1 (en) * | 2001-09-28 | 2004-10-07 | International Business Machines Corporation | Automatic generation of database invocation mechanism for external web services |
| CN101620536A (en) * | 2009-08-17 | 2010-01-06 | 用友软件股份有限公司 | Method and device for invoking performance function |
| CN102253984A (en) * | 2011-06-28 | 2011-11-23 | 用友软件股份有限公司 | Query sentence processing device and query sentence processing method |
-
2012
- 2012-12-25 CN CN201210571717.2A patent/CN103902543A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040199636A1 (en) * | 2001-09-28 | 2004-10-07 | International Business Machines Corporation | Automatic generation of database invocation mechanism for external web services |
| CN101620536A (en) * | 2009-08-17 | 2010-01-06 | 用友软件股份有限公司 | Method and device for invoking performance function |
| CN102253984A (en) * | 2011-06-28 | 2011-11-23 | 用友软件股份有限公司 | Query sentence processing device and query sentence processing method |
Non-Patent Citations (1)
| Title |
|---|
| 陈恭和 等: "《数据库Access应用教程（第2版）》", 30 September 2012 * |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105701128A (en) * | 2014-11-28 | 2016-06-22 | 华为技术有限公司 | Query statement optimization method and apparatus |
| CN105701128B (en) * | 2014-11-28 | 2019-03-08 | 华为技术有限公司 | A kind of optimization method and device of query statement |
| WO2016127851A1 (en) * | 2015-02-12 | 2016-08-18 | Huawei Technologies Co., Ltd. | Method and query optimization server for associating functions with columns for optimizing query execution |
| CN107004034A (en) * | 2015-02-12 | 2017-08-01 | 华为技术有限公司 | Row and function is associated into the method performed with Optimizing Queries and query optimization server |
| CN107004034B (en) * | 2015-02-12 | 2021-01-29 | 华为技术有限公司 | Method for associating columns with functions to optimize query execution and query optimization server |
| CN106547883A (en) * | 2016-11-03 | 2017-03-29 | 北京集奥聚合科技有限公司 | A kind of processing method and system of user-defined function UDF ruuning situations |
| CN106547883B (en) * | 2016-11-03 | 2021-02-19 | 北京集奥聚合科技有限公司 | Method and system for processing User Defined Function (UDF) running condition |
| CN107678968A (en) * | 2017-10-18 | 2018-02-09 | 北京奇虎科技有限公司 | Sample extraction method, apparatus, computing device and the storage medium of source code function |
| CN109284097A (en) * | 2018-09-07 | 2019-01-29 | 武汉轻工大学 | Realize method, equipment, system and the storage medium of complex data analysis |
| CN109284097B (en) * | 2018-09-07 | 2022-02-15 | 武汉轻工大学 | Method, device, system and storage medium for realizing complex data analysis |
| CN109460416A (en) * | 2018-12-12 | 2019-03-12 | 成都四方伟业软件股份有限公司 | A kind of data processing method, device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103902543A (en) | Database inquiry method and device and database system | |
| CN108804299A (en) | Application exception processing method and processing device | |
| CN102314460B (en) | Data analysis method and system and servers | |
| CN108280022A (en) | Performance monitoring method and device | |
| CN103890709A (en) | Cache based key-value store mapping and replication | |
| CN104579909A (en) | Method and equipment for classifying user information and acquiring user grouping information | |
| CN102521332B (en) | Graphic mode matching method, device and system based on strong simulation | |
| CN111367976A (en) | Method and device for exporting EXCEL file data based on JAVA reflection mechanism | |
| CN103020225B (en) | A kind of CPU type identifier method and hardware detection system | |
| CN115827436A (en) | Data processing method, device, equipment and storage medium | |
| CN110008462A (en) | A kind of command sequence detection method and command sequence processing method | |
| CN113485909B (en) | Test method, test device, computing equipment and medium | |
| CN111352951A (en) | Data export method, device and system | |
| CN112350872B (en) | Network architecture configuration information generation method and device, storage medium and electronic equipment | |
| CN112364051B (en) | Data query method and device | |
| CN111125226B (en) | Configuration data acquisition method and device | |
| CN109325015A (en) | A kind of extracting method and device of the feature field of domain model | |
| CN101986307B (en) | Generation method of MIME (multipurpose Internet mail extension) type plug-in component, system and browser | |
| CN105227528A (en) | To detection method and the device of the attack of Web server group | |
| CN111339560A (en) | Data isolation method, device and system | |
| CN110020166A (en) | A kind of data analysing method and relevant device | |
| CN110955547B (en) | Management method, system, equipment and readable storage medium for interface abnormal information | |
| CN103326892A (en) | Web interface operation method and device | |
| CN110955709B (en) | Data processing method and device and electronic equipment | |
| CN110471708B (en) | Method and device for acquiring configuration items based on reusable components |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140702 |
|
| RJ01 | Rejection of invention patent application after publication |