CN107273468B - A kind of database data processing method, device and terminal - Google Patents
A kind of database data processing method, device and terminal Download PDFInfo
- Publication number
- CN107273468B CN107273468B CN201710418648.4A CN201710418648A CN107273468B CN 107273468 B CN107273468 B CN 107273468B CN 201710418648 A CN201710418648 A CN 201710418648A CN 107273468 B CN107273468 B CN 107273468B
- Authority
- CN
- China
- Prior art keywords
- data
- filter
- keyset
- checked
- filter set
- 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.)
- Active
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 20
- 238000000034 method Methods 0.000 claims abstract description 92
- 238000012545 processing Methods 0.000 claims abstract description 25
- 238000001914 filtration Methods 0.000 claims description 70
- 230000008569 process Effects 0.000 claims description 21
- 230000015654 memory Effects 0.000 description 22
- 230000006870 function Effects 0.000 description 11
- 238000010586 diagram Methods 0.000 description 8
- 230000006854 communication Effects 0.000 description 7
- 238000004891 communication Methods 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 4
- 238000012216 screening Methods 0.000 description 4
- 241000208340 Araliaceae Species 0.000 description 3
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 3
- 235000003140 Panax quinquefolius Nutrition 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 3
- 238000001514 detection method Methods 0.000 description 3
- 230000014509 gene expression Effects 0.000 description 3
- 235000008434 ginseng Nutrition 0.000 description 3
- 230000005611 electricity Effects 0.000 description 2
- 230000005484 gravity Effects 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 230000007774 longterm Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 241000406668 Loxodonta cyclotis Species 0.000 description 1
- 230000001133 acceleration Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000005314 correlation function Methods 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 235000013399 edible fruits Nutrition 0.000 description 1
- 239000004744 fabric Substances 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012905 input function Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 238000010897 surface acoustic wave method Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
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/2425—Iterative querying; Query formulation based on the results of a preceding query
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of database data processing method, device and terminal, database data processing method proposed by the invention can allow for user voluntarily to realize that database data handles logic, to maximize the customizable degree of database data processing procedure.User handles logic by customized database data and can be handled database data in complicated special scene, even for resolved binary large object is not easy, logic can also be handled by the database data of user's customized and efficiently handled.
Description
Technical field
The present invention relates to a kind of database field more particularly to database data processing method, device and terminals.
Background technology
For common database, user can only be according to structured query language (Structured Query
Language) form of SQL statement or similar SQL statement executes the inquiry of data.As shown in Figure 1, the inquiry based on SQL
Generally include following step：Client sends out the query statement of SQL or class SQL；Server analysis simultaneously optimizes input by user
Query statement；Server executes the query statement after optimization and query result is returned to client.
It is limited to the ability to express of SQ sentences or class SQL statement, some complicated query logics are difficult to realize.And such as
Data in fruit database are preserved in the form of binary large object (binary large object, BLOB), then are difficult to pass through
SQL statement carries out analysis inquiry.
Invention content
In order to solve the above-mentioned technical problem, the present invention proposes a kind of database data processing method, device and terminal.This
Invention is specifically to be realized with following technical solution：
In a first aspect, a kind of database data processing method, the method includes：
Obtain the data inquiry request that client is sent out；Filter set is obtained according to the inquiry request；
The corresponding set of data to be checked and the corresponding index of data to be checked are obtained according to the data inquiry request；
By the filter set according to the corresponding index of the data to be checked to the corresponding collection of the data to be checked
It closes and carries out first round filtering to obtain the corresponding set of first object data and first filter set；The first filter collection
It is combined into the set that the filter of the corresponding index of the data to be checked can not be used to be constituted in filter set；
Judge whether the first filter set is empty；If the first filter set is not sky, by described the
One filter set continues the filtering of the second wheel to obtain the corresponding set of the second target data；The second mesh is returned to client
Mark data.
Second aspect, a kind of database data processing unit, described device include：
Data inquiry request acquisition module, the data inquiry request sent out for obtaining client；It is asked according to the inquiry
It asks to obtain filter set；
Query argument acquisition module, for according to the data inquiry request obtain the corresponding set of data to be checked and
The corresponding index of data to be checked；
First filtering module, for being waited for described according to corresponding index of the data to be checked by the filter set
The corresponding set of inquiry data carries out first round filtering to obtain the corresponding set of first object data and first filter set；
The first filter collection is combined into the filter institute structure that the corresponding index of the data to be checked can not be used in filter set
At set；
Judgment module, for judging whether the first filter set is empty；
Second filtering module, for continuing the filtering of the second wheel by the first filter set to obtain the second target
The corresponding set of data；
Data return to module, for returning to the second target data to client.
The third aspect, a kind of terminal, the terminal include above-mentioned device.
The present invention provides a kind of database data processing method, device and terminals, have the advantages that：
Database data processing method provided by the invention can allow for user voluntarily to realize that database data processing is patrolled
Volume, to maximize the customizable degree of data handling procedure.User handles logic by customized database data can be with
Database data is handled in complicated special scene, even for being not easy resolved binary large object,
It can efficiently be handled by the data process method of user's customized.
Description of the drawings
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technology description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention for those of ordinary skill in the art without creative efforts, can be with
Other attached drawings are obtained according to these attached drawings.
Fig. 1 is the querying method flow chart based on SQL that background of invention provides；
Fig. 2 is a kind of applied environment figure of database data processing method provided in an embodiment of the present invention；
Fig. 3 is database data process flow figure provided in an embodiment of the present invention；
Fig. 4 is the database data process flow figure that another embodiment of the present invention provides；
Fig. 5 carries out the mode flow chart of the second wheel filtering under being provided in an embodiment of the present invention or relationship；
Fig. 6 is the mode flow chart that the second wheel filtering is carried out under another or relationship provided in an embodiment of the present invention；
Fig. 7 is provided in an embodiment of the present invention and Relation Filter filter method flow chart；
Fig. 8 is provided in an embodiment of the present invention or Relation Filter filter method flow chart；
Fig. 9 is provided in an embodiment of the present invention another or Relation Filter method flow diagram；
Figure 10 is a kind of database data processing unit block diagram provided in an embodiment of the present invention；
Figure 11 is the second filtering module block diagram provided in an embodiment of the present invention；
Figure 12 is another second filtering module block diagram provided in an embodiment of the present invention；
Figure 13 is a kind of server architecture schematic diagram provided in an embodiment of the present invention；
Figure 14 is terminal schematic diagram provided in an embodiment of the present invention.
Specific implementation mode
In order to enable those skilled in the art to better understand the solution of the present invention, below in conjunction in the embodiment of the present invention
Attached drawing, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described embodiment is only
The embodiment of a part of the invention, instead of all the embodiments.Based on the embodiments of the present invention, ordinary skill people
The every other embodiment that member is obtained without making creative work should all belong to the model that the present invention protects
It encloses.
It should be noted that term " first " in description and claims of this specification and above-mentioned attached drawing, "
Two " etc. be for distinguishing similar object, without being used to describe specific sequence or precedence.It should be appreciated that using in this way
Data can be interchanged in the appropriate case, so as to the embodiment of the present invention described herein can in addition to illustrating herein or
Sequence other than those of description is implemented.In addition, term " comprising " and " having " and their any deformation, it is intended that cover
It includes to be not necessarily limited to for example, containing the process of series of steps or unit, method, system, product or equipment to cover non-exclusive
Those of clearly list step or unit, but may include not listing clearly or for these processes, method, product
Or the other steps or unit that equipment is intrinsic.
An embodiment of the present invention provides a kind of applied environment figure of database data processing method, at the database data
The system that reason method can be applied to common client-server architecture, can also be applied to as shown in Figure 2 by terminal
110 and server cluster 120 constitute distributed system among.Server cluster 120 may include multiple server nodes.Eventually
End 110 can have multiple, such as terminal 110 (1) and terminal 110 (2).
Under normal conditions, database is accessed using structured query language SQL statement, however the expression energy of SQL statement
Power is weaker, therefore, realizes that the access of data is more difficult using SQL statement under many complex application scenarios, and
The performance of data access process is also difficult to ensure, by taking development of games as an example, some special screnes during game backstage is developed
Under it is extremely complex to the access of data or difficult to realize, therefore the data access capabilities of SQL statement for game developer and
Say that limitation is larger, it is necessary to realize a kind of database data processing method so that user can arbitrarily parse data, fully
Using index, the query logic of oneself is customized.
In above-mentioned application environment, the embodiment of the present invention provides a kind of database data processing method, and the method can
Among applied to application environment as shown in Figure 2.
The method is as shown in figure 3, specifically include：
S101. the data inquiry request that client is sent out is obtained；Filter set is obtained according to the inquiry request.
Filter set expresses the condition of data base querying, where subsequent conditions when being equivalent to SQL statement inquiry,
Filter set can also include multiple filters, at this point, filter set expresses the combination of multiple queries condition.
Specifically, the filter by the advance self-defining of client and can be uploaded to server and be preserved, and also may be used
To be realized by server and be allowed client voluntarily Selection and call.After getting data inquiry request, server based on data
Inquiry request calls filter set (or filter) to be inquired.
Include filter set in a feasible embodiment, in the inquiry request that client is sent out.
In another feasible embodiment, data inquiry request can be also sent out by client, is made in the inquiry request
Specific querying condition is identified with where, its corresponding filter set is obtained according to the querying condition by server.
S102. the corresponding set of data to be checked is obtained according to the data inquiry request and data to be checked is corresponding
Index.
Data to be checked are corresponding to gather the data source for executing the data inquiry request, and the data to be checked correspond to
Index be the data source in index, according to it is described index in the data source inquiry can promote query rate.Into
One step, some or certain several fields that the index can be only to data source are effective.
S103. the data to be checked are corresponded to according to corresponding index of the data to be checked by the filter set
Set carry out the first round filtering with obtain first object data it is corresponding set and first filter set.
The first round is filtered into the filtering based on index, so as to make full use of existing index in data source to promote filtering
Rate.The first filter collection is combined into the filter that the corresponding index of the data to be checked can not be used in filter set
The set constituted.By taking the filter set includes set A and set B as an example, set A can carry out data mistake using index
Filter, and set B cannot carry out data filtering using index.It is based only on set A in step s 103 and carries out first round filtering simultaneously
Obtain the corresponding set of first object data.It can be seen that first object data are corresponding to gather the data query requirement for meeting set A
And not necessarily meet the data query requirement of set B.Set B is not performed in step S103, to constitute the first filtering
Device set in step S104 in order to using.
S104. judge whether the first filter set is empty.
If S105. the first filter collection is combined into sky, first object data are returned to client.
If first filter collection is combined into sky, illustrate that whole filters in the filter set obtained in step S101 are equal
It is performed in step s 103, obtained first object data are the final result inquired.
If S106. the first filter set is not sky, continue second according to the first filter set
Wheel filtering is to obtain the corresponding set of the second target data；The second target data is returned to client.
If first filter set is not sky, there is the filter not being performed, therefore, it is necessary to carry out the second wheel filtering
To obtain final query result (the second target data).
An embodiment of the present invention provides a kind of database data processing methods, and user can allow for voluntarily to realize database number
According to processing (inquiry) logic, to maximize the degree of may customize.User handles logic by customized database data can be with
Database data is handled in complicated special scene, even for being not easy resolved binary large object,
Logic can be handled by the database data of user's customized efficiently to handle.
Another embodiment of the present invention provides a kind of database data processing method, and the method can be applied to such as Fig. 2
Shown among application environment.
Specifically, each node among the application environment can be with configuration database, with data pair in database
The form group organization data of elephant, each data object are made of key and value.Specifically, it is indicated in the database with cache
Database table indicates that data object, each entry are made of key (key) and value (value) with entry.
Under above application environment, the method is as shown in figure 4, specifically include：
S201. the data inquiry request that client is sent out is obtained；Filter set is obtained according to the inquiry request.
S202. the keyset that data object to be checked is obtained according to the data inquiry request closes and data object to be checked
Corresponding index.
Specifically, the filter set include for according to index be filtered the first filter function (by
ApplyIndex interfaces are realized) and without using the second filter function for being directly filtered of index (by evaluateEntry interfaces
It realizes).
S203. progress is closed to the keyset according to corresponding index of the data object to be checked by the filter set
First round filtering is closed and first filter set with the keyset for obtaining first object data object.
Specifically, server-side participates in all data of inquiry and all indexes are used as filter set described in parameter call,
In the specific implementation procedure of step S203, the applyIndex interfaces of each filter in filter set are used, it is therefore an objective to
Judge whether filter can utilize index to be filtered, and the filter of index can be utilized to obtain first object to executing
The keyset of data object closes；And the filter that index cannot be utilized to execute inquiry is included into first filter set.
S204. judge whether the first filter set is empty.
If S205. the first filter collection is combined into sky, close to obtain first according to the keyset of first object data object
Target data objects return to the first object data object to client.
If S206. the first filter set is not sky, continue second according to the first filter set
Wheel filtering is closed with the keyset for obtaining the second target data objects.
It can be utilized the filter result of the filter of index in step S203, have another part that cannot utilize rope
The filter drawn executes not yet, can only be executed by the second wheel filtering, and because index cannot be used in implementation procedure, because
What this was called is the evaluateEntry interfaces of filter, and the keyset for finally obtaining the second target data objects closes.
Specifically, described according to first mistake if being between filter in the filter set and relationship
Filter set continues the filtering of the second wheel and includes with the keyset conjunction for obtaining the second target data objects：
The keyset of the first object data object is closed by the first filter set and carries out the second wheel filtering to obtain
Keyset to the second target data objects closes.
Specifically, if being between filter in the filter set or relationship, the second wheel filter process have two
Kind executive mode.
As shown in figure 5, the mode for carrying out the second wheel filtering under the first or relationship includes：
S1. the keyset of the data object to be checked is closed by the first filter set and carries out the second wheel filtering to obtain
Keyset to intermediate data object closes.
S2. the keyset of the intermediate data object is taken to close the union closed with the keyset of the first object data object, it is raw
It is closed at the keyset of the second target data objects.
As shown in fig. 6, the mode for carrying out the second wheel filtering under second or relationship includes：
S10. according to the keyset symphysis of first object data object at intermediate filter.
S20. by the intermediate filter be added the first filter set so that the intermediate filter with it is described
It is between other filters in first filtered set or relationship.
S30. the keyset of the data object to be checked is closed by the first filter set carry out the second wheel filtering with
The keyset for obtaining the second target data objects closes.
S207. it is closed to obtain the second target data objects according to the keyset of the second target data objects, the is returned to client
Two target data objects.
In above-mentioned data processing method, although data and index all in server-side, by user client from
It defining the semantic and interface of filter and filter is uploaded to server, user, which can also lead to, voluntarily realizes query logic, from
And maximize the customizable degree of query logic in data processing.
Further, between each filter in filter set can be with relationship (in similar SQL statement with item
Part " wherea>1andb<5 "), or or relationship (in similar SQL statement or condition wherea>1orb<5), obtain with
Relationship and/or relationship have both at the same time.And, correspondingly filter different for the logical relation of each filter in filter set
The method that set executes filtering is also different.
Filter set includes one or more filters, and filter set and filter can be indicated by Filter.This
Two methods are provided in inventive embodiments to execute the filter process (S202 and S205) based on filter set：
(1) recurrence executes filter process.
By taking filter set includes three filters A, B, C as an example, three filter relationships are A＆＆B | | C, then A＆＆ first
B generates one and Relation Filter, described to be generated again with filter C with Relation Filter or Relation Filter, in setting and
It can be realized based on filter set by step-by-step recursion on the basis of the filter method of Relation Filter and/or Relation Filter
Filter process.
Specifically, Filter1＆＆Filter2 or Relation Filter can be expressed as with Relation Filter can be expressed as
Filter1||Filter2。
(2) by the relationship of each filter in filter set be converted into relationship or or relationship, according to default suitable
Filter is filtered sequence one by one, finally obtains the filter result based on filter set.
Specifically, for the data processing method described in the apparent description embodiment of the present invention, the embodiment of the present invention is given
Go out the description to the relevant data structure of filter and related semanteme：
(1) filter can be by user's self-defining, and filter is mutually organized together by logical relation can be with structure
At filter set.Specifically, filtering is customized by realizing the interface evaluateEntry and applyIndex of Filter
Device.
Filter interfaces are defined as follows：
public interface Filter{
public boolean evaluateEntry(java.util.Map.Entry entry)；
public Filter applyIndex(Map indexMap,Set keySet)；
}
The query logic of oneself is defined by realizing Filter interfaces：
public static class MyFilter implements Filter{
public MyFilter(){
}
@Override//user realizes that evaluateEntry's is self-defined by rewriting
public boolean evaluateEntry(java.util.Map.Entry entry){
}
@Override//user realizes that applyIndex's is self-defined by rewriting
public Filter applyIndex(Map indexMap,Set keySet){
}
}
Wherein, the parameter of evaluateEntry interfaces is that each entry objects (include the data pair of key and value
As), evaluateEntry returns to true and indicates that this entry object meets the querying condition of Filter, returns to false and indicates not
Meet Filter querying conditions.User can customize the query logic of oneself in this function.
First parameter indexMap of applyIndex interfaces is index data, and second parameter keySet is Filter
The keyset filtered is needed to close.Return value indicates the still remaining portions that cannot utilize index after all index filterings this Filter
Divide Filter.Such as a filter set (including multiple filters), only the querying condition of stage filter can utilize
Index, that return value are the filter set that the filter of rest part is constituted.If returning to null, indicate that this Filter includes
All querying conditions using index can complete data screening, if returning to non-null, indicate this Filter exist cannot
Utilize the filter set of index.
(2) in client publishing data inquiry request, its customized mistake can be attached in the data inquiry request
Filter set Filter.After the corresponding objects of Filter are transmitted to server-side by client, server-side will be on corresponding opportunity
Its interface is called, to realize the custom-built query of data.
(3) server can also provide a user simple Filter corresponding with the querying condition in common SQL, be convenient for
User directly invokes.Such as similar " where num>The GreaterFilter of 3 " conditions：
GreaterFilter f=new GreaterFilter (new ReflectionExtractor (" getNum "),
3)；
Direct use is only needed for the Filter user of offer.Similar Filter also have AllFilter,
AndFilter, BetweenFilter, EqualsFilter, LessFilter, LikeFilter, LimitFilter etc..
On the basis of being explained for Filter semantemes and data structure, as shown in fig. 7, the embodiment of the present invention provides
It is a kind of that (filter set can be expressed as Filter1＆＆Filter2, wherein Filter1, Filter2 with Relation Filter
Can be filter set) filter method, the method includes：
S100. the keyset for obtaining the data object to be checked for executing filtering closes and the corresponding rope of data object to be checked
Draw.
S200. the keyset conjunction and the corresponding index of data object to be checked for using the data object to be checked are used as ginseng
Number calls the current applyIndex interfaces with Relation Filter (Filter1＆＆Filter2).
Specifically, during executing the applyIndex interfaces of Filter1＆＆Filter2, Filter1 is taken first,
Judge that its applyIndex is able to carry out, if cannot, intermediate filtered set restFilter is added in Filter1, if can,
The applyIndex for executing Filter1, obtains the corresponding key of data for meeting Filter1 filter conditions, is added into middle key
Set filterKeySet, the middle key set filterKeySet are to meet a part of mistake of certain in Filter1＆＆Filter2
The corresponding set of key of the data of filter condition；
Then Filter2 is executed, judges that its applyIndex is able to carry out, if cannot, intermediate mistake is added in Filter2
Set restFilter is filtered, if can, by middle key set filterKeySet as parameter call Filter2's
ApplyIndex obtains the corresponding key of data for meeting Filter2 filter conditions, is added into middle key set
filterKeySet。
S300. judge whether the current applyIndex interfaces with Relation Filter can be completed to inquire.
Specifically, the return value for obtaining the applyIndex interfaces of Filter1＆＆Filter2 judges whether it is null,
If so, illustrating that all querying conditions that Filter1＆＆Filter2 includes can complete data screening using index, therefore
Query results can be directly generated according to obtained filter result (middle key set filterKeySet).If not null, then
It also needs to carry out subsequent processing.
If S400. can complete to inquire, obtains filtered keyset and close.
Specifically, the middle key set filterKeySet obtained in step S200 is that filtered keyset closes.
S500. it is closed to obtain its corresponding set of data objects according to the keyset, and is looked into according to set of data objects generation
It askes result set and the query results is fed back into client.
If S600. can not complete to inquire, filtered middle key set and intermediate filtered set are obtained.
Since Filter1＆＆Filter2 is and Relation Filter, it only need to be in middle key set filterKeySet
The data that middle acquisition meets restFilter requirements can be obtained final result.
S700. using the corresponding intermediate data object set of the middle key set as parameter, the intermediate filtered is called
The evaluateEntry interfaces of filter in set.
Since restFilter cannot use index, it is therefore desirable to evaluateEntry interfaces are used, and
The parameter of evaluateEntry is that data object (entry) therefore converts filterKeySet to it first in this step
Corresponding data object obtains intermediate data object set filterEntrySet, then can use evaluateEntry.
Specific implementation procedure is as follows：
By traversing filterEntrySet, each entry therein is as parameter call restFilter's
Entry is added filtered keyset and closed by evaluateEntry interfaces if return value is true, if returning to false,
Filtered keyset is then added without to close.
S800. it obtains filtered keyset to close, closes to obtain its corresponding set of data objects according to the keyset, and according to
Set of data objects generates query results and the query results is fed back to client.
On the basis of being explained for Filter semantemes and data structure, as shown in figure 8, the embodiment of the present invention provides
A kind of or Relation Filter (filter set can be expressed as Filter1 | | Filter2, wherein Filter1, Filter2
Can be filter set) filter method, the method includes：
P100. the keyset for obtaining the data object to be checked for executing filtering closes and the corresponding rope of data object to be checked
Draw.
P200. the keyset conjunction and the corresponding index of data object to be checked for using the data object to be checked are used as ginseng
Number calls current or Relation Filter applyIndex interfaces.
This method executes beginning, and current or Relation Filter is Filter1 | | Filter2.
By current or Relation Filter be Filter1 | | for Filter2, execute Filter1 | | Filter2's
During applyIndex interfaces, Filter1 is taken first, judges that its applyIndex is able to carry out, if cannot, it will
Intermediate filtered set restFilter is added in Filter1, if can, the applyIndex of Filter1 is executed, is met
The corresponding key of data of Filter1 filter conditions is added into target data keyset and closes matchKeySet, the target data
It is to meet Filter1 that keyset, which closes matchKeySet, | | the corresponding set of key of the data of Filter2 filter conditions；
Then Filter2 is executed, judges that its applyIndex is able to carry out, if cannot, intermediate mistake is added in Filter2
Set restFilter is filtered, if can, target data keyset is subtracted by the keyset conjunction of data object to be checked and closes matchKeySet
As the applyIndex of parameter call Filter2, obtain the corresponding key of data for meeting Filter2 filter conditions, by itself plus
Enter target data keyset and closes matchKeySet.
P300. judge whether current or Relation Filter the applyIndex interfaces can be completed to inquire.
This method executes beginning, and current or Relation Filter is Filter1 | | Filter2.
By current or Relation Filter be Filter1 | | for Filter2, obtain Filter1 | | Filter2's
The return value of applyIndex interfaces judges whether it is null (intermediate filtered set restFilter is empty situation), if
It is then to illustrate Filter1 | | all querying conditions that Filter2 includes can complete data screening, therefore root using index
Query results can be directly generated according to obtained filter result (target data keyset closes matchKeySet).If not null (in
Between filtered set restFilter be not empty situation), then also need to carry out subsequent processing.
If P400. can complete to inquire, obtains filtered keyset and close.
Specifically, it is that filtered keyset closes that the target data keyset obtained in step P200, which closes matchKeySet,.
P500. it is closed to obtain its corresponding set of data objects according to the keyset, and is looked into according to set of data objects generation
It askes result set and the query results is fed back into client.
If P600. can not complete to inquire, judge that target data keyset closes whether matchKeySet is empty.
This method executes beginning, and current or Relation Filter is Filter1 | | Filter2.
By current or Relation Filter be Filter1 | | for Filter2, if matchKeySet not be sky, illustrate
A part has been obtained using index meet Filter1 in step P200 | | the corresponding key of data of Filter2；If
MatchKeySet is empty, then illustrates Filter1 | | Filter2 cannot use index, or use the part of index no
To meeting Filter1 | | the data record of Filter2.
If it is sky that P700. target data keyset, which closes matchKeySet not, closed according to target data keyset
MatchKeySet builds a filter, the filter and the intermediate filtered set restFilter structure it is new or close
It is filter, sets current or Relation Filter to described new or Relation Filter, and repeat step P100.
Specifically, it is described according to target data keyset close matchKeySet structure filter can be Filter3,
For stating query statement where key in matchKeySet, filter condition is Filter3：In data object to be checked
Keyset close all keys in be located at target data keyset close matchKeySet key.The new or Relation Filter being combined into
For Filter3 | | restFilter.
If it is sky that P800. target data keyset, which closes matchKeySet, set current or Relation Filter to
RestFilter, and call the evaluateEntry interfaces of the restFilter.
Since restFilter cannot use index, it is therefore desirable to evaluateEntry interfaces are used, and
The parameter of evaluateEntry is data object (entry), therefore, first by the keyset of data object to be checked in this step
Conjunction is converted into its corresponding data object, obtains set of data objects EntrySet to be checked, then can use
evaluateEntry.Specific implementation procedure is as follows：
By traversing EntrySet, evaluateEntrys of each entry therein as parameter call restFilter
Entry is added filtered target data keyset and closes matchKeySet, if returned by interface if return value is true
False is then added without target data keyset and closes matchKeySet, and it is to filter that the target data keyset, which closes matchKeySet,
The keyset arrived closes.
P900. it obtains filtered keyset to close, closes to obtain its corresponding set of data objects according to the keyset, and according to
Set of data objects generates query results and the query results is fed back to client.
Further, at upper one on the basis of the method for realization or Relation Filter, the embodiment of the present invention additionally provides
Another kind is realized or the method for Relation Filter, as shown in figure 9, the method includes：
T100. the keyset for obtaining the data object to be checked for executing filtering closes and the corresponding rope of data object to be checked
Draw.
T200. the keyset conjunction and the corresponding index of data object to be checked for using the data object to be checked are used as ginseng
Number calls current or Relation Filter applyIndex interfaces.
By current or Relation Filter be Filter1 | | for Filter2, execute Filter1 | | Filter2's
During applyIndex interfaces, Filter1 is taken first, judges that its applyIndex is able to carry out, if cannot, it will
Intermediate filtered set restFilter is added in Filter1, if can, the applyIndex of Filter1 is executed, is met
The corresponding key of data of Filter1 filter conditions is added into target data keyset and closes matchKeySet, the target data
It is to meet Filter1 that keyset, which closes matchKeySet, | | the corresponding set of key of the data of Filter2 filter conditions；
Then Filter2 is executed, judges that its applyIndex is able to carry out, if cannot, intermediate mistake is added in Filter2
Set restFilter is filtered, if can, target data keyset is subtracted by the keyset conjunction of data object to be checked and closes matchKeySet
As the applyIndex of parameter call Filter2, obtain the corresponding key of data for meeting Filter2 filter conditions, by itself plus
Enter target data keyset and closes matchKeySet.
T300. judge whether current or Relation Filter the applyIndex interfaces can be completed to inquire.
By current or Relation Filter be Filter1 | | for Filter2, obtain Filter1 | | Filter2's
The return value of applyIndex interfaces judges whether it is null (intermediate filtered set restFilter is empty situation), if
It is then to illustrate Filter1 | | all querying conditions that Filter2 includes can complete data screening, therefore root using index
Query results can be directly generated according to obtained filter result (target data keyset closes matchKeySet).If not null (in
Between filtered set restFilter be not empty situation), then also need to carry out subsequent processing.
If T400. can complete to inquire, obtains filtered keyset and close.
Specifically, it is that filtered keyset closes that the target data keyset obtained in step T200, which closes matchKeySet,.
T500. it is closed to obtain its corresponding set of data objects according to the keyset, and is looked into according to set of data objects generation
It askes result set and the query results is fed back into client.
If T600. can not complete to inquire, judge that target data keyset closes whether matchKeySet is empty.
If T700. target data keyset close matchKeySet be sky, according to intermediate filtered set restFilter after
Continuous to be filtered, obtained filter result takes union to obtain filtered set with the matchKeySet.
If it is sky that T800. target data keyset, which closes matchKeySet, set current or Relation Filter to
RestFilter, and call the evaluateEntry interfaces of the restFilter to obtain filtered set.
Specifically, the implementation procedure of restFilter may refer to the filter process of one or Relation Filter.
T900. it obtains filtered keyset to close, closes to obtain its corresponding set of data objects according to the keyset, and according to
Set of data objects generates query results and the query results is fed back to client.
Further, the customization of server-side database is operated to promote user, the embodiment of the present invention also provides
Other data process methods outside data query are removed, the data process method further includes that the establishment of data object management table is patrolled
It collects, the data object change logic in index creation logic and/or database, above-mentioned data process method can be by being used in visitor
Family end defines, and is then transmit to server end and is executed by server.
Specifically, for above-mentioned data process method, the embodiment of the present invention provides following example：
(1) data object management table creates logic
FlameCache cache=CacheFactory.getCache (" cache_1 ")；//cache is equivalent to data
Library table
(2) data object in database changes logic
For data object is written：
Value value_1=new Value ()；
cache.put(“key_1”,value_1)；//cache is database table
Assuming that the definition of Value is：
public class Value{
private String name；
private long timestamp；
private Collection<String>StringCol=new LinkedList<String>()；
public long getTimestamp(){
return timestamp；
}
}
(3) index creation logic：
cache.addIndex(new ReflectionExtractor("getTimestamp"),true)；
The field of index is created by the way of ReflectionExtractor extractors, getTimestamp therein
Corresponding Value defines the getTimestamp functions of the inside, can be directed to getTimestamp fields in this way and create database rope
Draw.The second parameter of addIndex illustrates whether the index that needs create is ranking index, and ranking index is established in true expressions,
Non- ranking index is established in false expressions.
The embodiment of the present invention provides not only the specifically data query method based on filter, also provides one kind together
Realize the method with the realization of method, the method for Recursive Implementation or filter and onrecurrent or filter of filter, thus
The inquiry customization of bigger is brought on inquiry mode to user, user is by realizing Filter and Filter being transmitted to server
The indirect control query process of database even can freely manipulate the data and rope of database in above-mentioned query process
Draw, so that inquiry is more directly more flexible, the complicated special inquiry scene of processing is also easier to, even if the data in database
Binary large object or other data for being not easy parsing are saved as, Filter can also be voluntarily write by user to solve
Analysis and inquiry.In addition, the embodiment of the present invention additionally provides other data process methods, to realize to the full extent user for
The customization of database operates.
The embodiments of the present invention also provide a kind of storage medium, the storage medium may be disposed at client and/or clothes
It is engaged among device to preserve for realizing the program code of database data processing method in embodiment of the method.Optionally, in this reality
It applies in example, above-mentioned storage medium can be located at least one of multiple network equipments of computer network network equipment.It is optional
Ground, in the present embodiment, above-mentioned storage medium can include but is not limited to：USB flash disk, read-only memory (ROM, Read-Only
Memory), random access memory (RAM, Random Access Memory), mobile hard disk, magnetic disc or CD etc. are various
The medium of program code can be stored.
The present invention also provides a kind of database data processing units, and as described in Figure 10, described device includes：
Data inquiry request acquisition module 301, the data inquiry request sent out for obtaining client；According to the inquiry
Request obtains filter set.It can be used for executing embodiment of the method step S101 and S201.
Query argument acquisition module 302, for obtaining the corresponding set of data to be checked according to the data inquiry request
And the corresponding index of data to be checked.It can be used for executing embodiment of the method step S102 and S202.
First filtering module 303, for being indexed to institute by the filter set according to the data to be checked are corresponding
It states the corresponding set of data to be checked and carries out first round filtering to obtain the corresponding set of first object data and first filter
Set；The first filter collection is combined into the filter that the corresponding index of the data to be checked can not be used in filter set
The set constituted.It can be used for executing embodiment of the method step S103 and S203.
Judgment module 304, for judging whether the first filter set is empty.It can be used for executing embodiment of the method step
Rapid S104 and S204.
Second filtering module 305, for continuing the filtering of the second wheel according to the first filter set to obtain the
The corresponding set of two target datas.It can be used for executing embodiment of the method step S106 and S206.
Data return to module 306, for returning to first object data or the second target data to client.It can be used for executing
Embodiment of the method step S105, S205 and S207.
Further, in a feasible embodiment, the query argument acquisition module is used for according to the data
Inquiry request obtains keyset conjunction and the corresponding index of data object to be checked of data object to be checked；
First filtering module is used for by the filter set according to the corresponding index of the data object to be checked
The keyset is closed and carries out first round filtering with the keyset conjunction for obtaining first object data object and first filter set；
Second filtering module is used to continue the filtering of the second wheel according to the first filter set to obtain the
The keyset of two target data objects closes；The second target data objects are returned to client；
Data return to module, for according to the keyset of first object data object close to obtain first object data object and to
Client returns to first object data object, or, being closed to obtain the second target data pair according to the keyset of the second target data objects
As and to client returns to the second target data objects.
Specifically, 1 is please referred to Fig.1, second filtering module 305 includes：
First filter element 3051 is used for by the first filter set to the keyset of the first object data object
It closes and carries out the second wheel filtering to obtain the keyset conjunction of the second target data objects.
Second filter element 3052, for being closed to the keyset of the data object to be checked by the first filter set
The second wheel filtering is carried out to close with the keyset for obtaining intermediate data object.It can be used for executing embodiment of the method step S1.
Data result acquiring unit 3053, for taking the keyset of the intermediate data object to close and the first object data
The union that the keyset of object closes, the keyset for generating the second target data objects close.It can be used for executing embodiment of the method step S2.
Specifically, in other feasible embodiments, 2 are please referred to Fig.1, second filtering module 305 includes：
First filter element 3051 is used for by the first filter set to the keyset of the first object data object
It closes and carries out the second wheel filtering to obtain the keyset conjunction of the second target data objects.
Filter generation unit 3054 is used for the keyset symphysis according to first object data object into intermediate filter.It can
For executing embodiment of the method step S10.
First filter set changing unit 3055, for the first filter set to be added in the intermediate filter
So that being between other filters in the intermediate filter and first filtered set or relationship.It can be used for the side of execution
Method embodiment step S20.
Third filter element 3056, for being closed to the keyset of the data object to be checked by the first filter set
The second wheel filtering is carried out to close with the keyset for obtaining the second target data objects.It can be used for executing embodiment of the method step S30.
Device described in the device of the invention embodiment be based on embodiment of the method in the same manner as inventive concept.
Specifically, Figure 13 is a kind of server architecture schematic diagram provided in an embodiment of the present invention, and the server architecture can
To be set among above-mentioned apparatus.The server 800 can generate bigger difference because configuration or performance are different, may include
One or more central processing units (central processing units, CPU) 822 (for example, one or more
Processor) and memory 832, the storage medium 830 (such as one of one or more storage application programs 842 or data 844
A or more than one mass memory unit).Wherein, memory 832 and storage medium 830 can be of short duration storage or persistently deposit
Storage.The program for being stored in storage medium 830 may include one or more modules (diagram is not shown), and each module can be with
Include to the series of instructions operation in server.Further, central processing unit 822 could be provided as and storage medium
830 communications execute the series of instructions operation in storage medium 830 on server 800.Server 800 can also include one
A or more than one power supply 826, one or more wired or wireless network interfaces 850, one or more inputs are defeated
Outgoing interface 858, and/or, one or more operating systems 841, such as Windows ServerTM, Mac OS XTM,
UnixTM, LinuxTM, FreeBSDTM etc..Step performed by above method embodiment can be based on taking shown in the Figure 13
Business device structure.
Referring to Figure 14, an embodiment of the present invention provides a kind of terminal, which can be used for implementing carrying in above-described embodiment
A kind of database data processing method supplied.Specifically：
The terminal may include RF (Radio Frequency, radio frequency) circuit 110, include one or more
The memory 120 of computer readable storage medium, input unit 130, display unit 140, sensor 150, voicefrequency circuit 160,
WiFi (wireless fidelity, Wireless Fidelity) module 170, include there are one or more than one processing core processing
The components such as device 180 and power supply 190.It will be understood by those skilled in the art that terminal structure shown in Figure 14 is not constituted pair
The restriction of terminal may include either combining certain components or different component cloth than illustrating more or fewer components
It sets.Wherein：
RF circuits 110 can be used for receiving and sending messages or communication process in, signal sends and receivees, particularly, by base station
After downlink information receives, one or the processing of more than one processor 180 are transferred to；In addition, the data for being related to uplink are sent to
Base station.In general, RF circuits 110 include but not limited to antenna, at least one amplifier, tuner, one or more oscillators, use
Family identity module (SIM) card, transceiver, coupler, LNA (Low Noise Amplifier, low-noise amplifier), duplex
Device etc..In addition, RF circuits 110 can also be communicated with network and other equipment by radio communication.The wireless communication can make
With any communication standard or agreement, and including but not limited to GSM (Global System of Mobile communication, entirely
Ball mobile communcations system), GPRS (General Packet Radio Service, general packet radio service), CDMA (Code
Division Multiple Access, CDMA), WCDMA (Wideband Code Division Multiple
Access, wideband code division multiple access), LTE (Long Term Evolution, long term evolution), Email, SMS (Short
Messaging Service, short message service) etc..
Memory 120 can be used for storing software program and module, and processor 180 is stored in memory 120 by operation
Software program and module, to perform various functions application and data processing.Memory 120 can include mainly storage journey
Sequence area and storage data field, wherein storing program area can storage program area, the application program etc. needed for function；Store data
Area can be stored uses created data etc. according to the terminal.It is deposited in addition, memory 120 may include high random access
Reservoir can also include nonvolatile memory, for example, at least a disk memory, flush memory device or other volatibility
Solid-state memory.Correspondingly, memory 120 can also include Memory Controller, to provide processor 180 and input unit
The access of 130 pairs of memories 120.
Input unit 130 can be used for receiving the number or character information of input, and generate and user setting and function
Control related keyboard, mouse, operating lever, optics or the input of trace ball signal.Specifically, input unit 130 may include touching
Sensitive surfaces 131 and other input equipments 132.Touch sensitive surface 131, also referred to as touch display screen or Trackpad are collected and are used
Family on it or neighbouring touch operation (such as user using any suitable object or attachment such as finger, stylus in touch-sensitive table
Operation on face 131 or near touch sensitive surface 131), and corresponding attachment device is driven according to preset formula.It is optional
, touch sensitive surface 131 may include both touch detecting apparatus and touch controller.Wherein, touch detecting apparatus detection is used
The touch orientation at family, and the signal that touch operation is brought is detected, transmit a signal to touch controller；Touch controller is from touch
Touch information is received in detection device, and is converted into contact coordinate, then gives processor 180, and can receive processor 180
The order sent simultaneously is executed.Furthermore, it is possible to using multiple types such as resistance-type, condenser type, infrared ray and surface acoustic waves
Realize touch sensitive surface 131.In addition to touch sensitive surface 131, input unit 130 can also include other input equipments 132.Specifically,
Other input equipments 132 can include but is not limited to physical keyboard, function key (such as volume control button, switch key etc.),
It is one or more in trace ball, mouse, operating lever etc..
Display unit 140 can be used for showing information input by user or be supplied to the information of user and the terminal
Various graphical user interface, these graphical user interface can be made of figure, text, icon, video and its arbitrary combination.
Display unit 140 may include display panel 141, optionally, LCD (Liquid Crystal Display, liquid crystal may be used
Show device), the forms such as OLED (Organic Light-Emitting Diode, Organic Light Emitting Diode) configure display panel
141.Further, touch sensitive surface 131 can cover display panel 141, when touch sensitive surface 131 detects on it or neighbouring touches
After touching operation, processor 180 is sent to determine the type of touch event, is followed by subsequent processing type of the device 180 according to touch event
Corresponding visual output is provided on display panel 141.Although in Figure 5, touch sensitive surface 131 and display panel 141 are conducts
Two independent components realize input and input function, but in some embodiments it is possible to by touch sensitive surface 131 and display
Panel 141 is integrated and realizes and outputs and inputs function.
The terminal may also include at least one sensor 150, such as optical sensor, motion sensor and other sensings
Device.Specifically, optical sensor may include ambient light sensor and proximity sensor, wherein ambient light sensor can be according to environment
The light and shade of light adjusts the brightness of display panel 141, and proximity sensor can close display when the terminal is moved in one's ear
Panel 141 and/or backlight.As a kind of motion sensor, gravity accelerometer can detect in all directions (generally
Three axis) acceleration size, size and the direction of gravity are can detect that when static, can be used to identify terminal posture application (ratio
Such as horizontal/vertical screen switching, dependent game, magnetometer pose calibrating), Vibration identification correlation function (such as pedometer, tap)；Extremely
In other sensors such as gyroscope, barometer, hygrometer, thermometer, the infrared sensors that the terminal can also configure, herein
It repeats no more.
Voicefrequency circuit 160, loud speaker 161, microphone 162 can provide the audio interface between user and the terminal.Sound
The transformed electric signal of the audio data received can be transferred to loud speaker 161, is converted to by loud speaker 161 by frequency circuit 160
Voice signal exports；On the other hand, the voice signal of collection is converted to electric signal by microphone 162, is received by voicefrequency circuit 160
After be converted to audio data, it is such as another to be sent to through RF circuits 110 then by after the processing of audio data output processor 180
Terminal, or audio data is exported to memory 120 to be further processed.Voicefrequency circuit 160 is also possible that earplug is inserted
Hole, to provide the communication of peripheral hardware earphone and the terminal.
WiFi belongs to short range wireless transmission technology, and the terminal can help user to receive and dispatch electricity by WiFi module 170
Sub- mail, browsing webpage and access streaming video etc., it has provided wireless broadband internet to the user and has accessed.Although Figure 14 shows
Go out WiFi module 170, but it is understood that, and it is not belonging to must be configured into for the terminal, it completely can be according to need
It to be omitted in the range for the essence for not changing invention.
Processor 180 is the control centre of the terminal, utilizes each portion of various interfaces and the entire terminal of connection
Point, by running or execute the software program and/or module that are stored in memory 120, and calls and be stored in memory 120
Interior data execute the various functions and processing data of the terminal, to carry out integral monitoring to terminal.Optionally, it handles
Device 180 may include one or more processing cores；Preferably, processor 180 can integrate application processor and modulation /demodulation processing
Device, wherein the main processing operation system of application processor, user interface and application program etc., modem processor is mainly located
Reason wireless communication.It is understood that above-mentioned modem processor can not also be integrated into processor 180.
The terminal further includes the power supply 190 (such as battery) powered to all parts, it is preferred that power supply can pass through electricity
Management system and processor 180 are logically contiguous, to realize management charging, electric discharge and power consumption by power-supply management system
The functions such as management.Power supply 190 can also include one or more direct current or AC power, recharging system, power supply event
Hinder the random components such as detection circuit, power supply changeover device or inverter, power supply status indicator.
Although being not shown, the terminal can also include camera, bluetooth module etc., and details are not described herein.Specifically at this
In embodiment, the display unit of terminal is touch-screen display, terminal further include have memory and one or more than one
Program, one of them either more than one program be stored in memory and be configured to by one or more than one
Manage the instruction in embodiment of the method in the device execution present invention.
It should be noted that：The embodiments of the present invention are for illustration only, can not represent the quality of embodiment.
One of ordinary skill in the art will appreciate that realizing that all or part of step of above-described embodiment can pass through hardware
It completes, relevant hardware can also be instructed to complete by program, the program can be stored in a kind of computer-readable
In storage medium, storage medium mentioned above can be read-only memory, disk or CD etc..
The foregoing is merely presently preferred embodiments of the present invention, is not intended to limit the invention, it is all the present invention spirit and
Within principle, any modification, equivalent replacement, improvement and so on should all be included in the protection scope of the present invention.
Claims (15)
1. a kind of database data processing method, which is characterized in that the method includes：
Obtain the data inquiry request that client is sent out；Filter set is obtained according to the inquiry request；
The corresponding set of data to be checked and the corresponding index of data to be checked are obtained according to the data inquiry request；
By the filter set according to the corresponding index of the data to be checked it is corresponding to the data to be checked gather into
The filtering of the row first round is to obtain the corresponding set of first object data and first filter set；The first filter collection is combined into
The set that the filter of the corresponding index of the data to be checked can not be used to be constituted in filter set；
Judge whether the first filter set is empty；If the first filter set is not sky, according to described first
Filter set continues the filtering of the second wheel to obtain the corresponding set of the second target data；The second target is returned to client
Data.
2. according to the method described in claim 1, it is characterized in that, in the database in the form of data object tissue number
According to each data object is made of key and value.
3. according to the method described in claim 2, it is characterized in that, the method includes：
The keyset that data object to be checked is obtained according to the data inquiry request closes and the corresponding rope of data object to be checked
Draw；
Progress first round mistake is closed to the keyset according to corresponding index of the data object to be checked by the filter set
Filter is closed and first filter set with the keyset for obtaining first object data object；
Judge whether the first filter set is empty；
If the first filter collection is combined into sky, closed to obtain first object data pair according to the keyset of first object data object
As returning to the first object data object to client；
If the first filter set is not sky, the filtering of the second wheel is continued to obtain according to the first filter set
Keyset to the second target data objects closes；It is closed to obtain the second target data objects according to the keyset of the second target data objects,
The second target data objects are returned to client.
If 4. according to the method described in claim 3, it is characterized in that, be between filter in the filter set with
Relationship, then it is described that the filtering of second wheel is continued to obtain the key of the second target data objects according to the first filter set
Set includes：
The keyset of the first object data object is closed by the first filter set and carries out the second wheel filtering to obtain the
The keyset of two target data objects closes.
If 5. according to the method described in claim 3, it is characterized in that, be between filter in the filter set or
Relationship, then it is described that the filtering of second wheel is continued to obtain the key of the second target data objects according to the first filter set
Set includes：
The keyset of the data object to be checked is closed by the first filter set and carries out the second wheel filtering to obtain centre
The keyset of data object closes；
It takes the keyset of the intermediate data object to close the union closed with the keyset of the first object data object, generates the second mesh
The keyset for marking data object closes.
If 6. according to the method described in claim 3, it is characterized in that, be between filter in the filter set or
Relationship, then it is described that the filtering of second wheel is continued to obtain the key of the second target data objects according to the first filter set
Set includes：
According to the keyset symphysis of first object data object at intermediate filter；
The first filter set is added in the intermediate filter so that the intermediate filter is filtered with described first
It is between other filters in set or relationship；
The keyset of the data object to be checked is closed by the first filter set and carries out the second wheel filtering to obtain second
The keyset of target data objects closes.
7. method according to claim 4 or 5, which is characterized in that asked in the data query that the acquisition client is sent out
Further include the logical relation in adjustment filter set between each filter so that being between each filter after asking
Between relationship or each filter it is or relationship.
8. according to the method described in claim 1, it is characterized in that, the filter set includes for being carried out according to index
First filter function of filter and the second filter function being directly filtered without using index.
9. according to the method described in claim 1, it is characterized in that, the method further includes：
Obtain the customized data process method of client；The data process method includes that the establishment of data object management table is patrolled
It collects, the data object in index creation logic, filter and/or database changes logic；
Server executes the data process method.
10. a kind of database data processing unit, which is characterized in that described device includes：
Data inquiry request acquisition module, the data inquiry request sent out for obtaining client；It is obtained according to the inquiry request
To filter set；
Query argument acquisition module, for obtaining the corresponding set of data to be checked and to be checked according to the data inquiry request
Ask the corresponding index of data；
First filtering module, for being indexed to described to be checked by the filter set according to the data to be checked are corresponding
The corresponding set of data carries out first round filtering to obtain the corresponding set of first object data and first filter set；It is described
First filter collection, which is combined into filter set, can not use the filter of the corresponding index of the data to be checked to be constituted
Set；
Judgment module, for judging whether the first filter set is empty；
Second filtering module, for continuing the filtering of the second wheel according to the first filter set to obtain the second number of targets
According to corresponding set；
Data return to module, for returning to the second target data to client.
11. device according to claim 10, it is characterised in that：
The query argument acquisition module be used for according to the data inquiry request obtain data object to be checked keyset close with
And the corresponding index of data object to be checked；
First filtering module is used to be indexed to institute according to the data object to be checked is corresponding by the filter set
It states keyset and closes the filtering of the progress first round to obtain keyset conjunction and the first filter set of first object data object；
Second filtering module is used to continue the filtering of the second wheel according to the first filter set to obtain the second mesh
The keyset for marking data object closes；The second target data objects are returned to client；
Data return to module, for closing to obtain first object data object according to the keyset of first object data object and to client
End returns to first object data object, or, being closed to obtain the second target data objects simultaneously according to the keyset of the second target data objects
The second target data objects are returned to client.
12. according to the devices described in claim 11, which is characterized in that second filtering module includes：
First filter element carries out for being closed to the keyset of the first object data object by the first filter set
Two wheel filterings are closed with the keyset for obtaining the second target data objects.
13. according to the devices described in claim 11, which is characterized in that second filtering module includes：
Second filter element carries out second for being closed to the keyset of the data object to be checked by the first filter set
Wheel filtering is closed with the keyset for obtaining intermediate data object；
Data result acquiring unit, for taking the keyset of the intermediate data object to close the key with the first object data object
Union of sets collection, the keyset for generating the second target data objects close.
14. according to the devices described in claim 11, which is characterized in that second filtering module includes：
Filter generation unit is used for the keyset symphysis according to first object data object into intermediate filter；
First filter set changing unit, for the first filter set to be added so that institute in the intermediate filter
It states between other filters in intermediate filter and first filtered set and is or relationship；
Third filter element carries out second for being closed to the keyset of the data object to be checked by the first filter set
Wheel filtering is closed with the keyset for obtaining the second target data objects.
15. a kind of terminal, which is characterized in that the terminal includes the device described in any one of claim 10-14.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710418648.4A CN107273468B (en) | 2017-06-06 | 2017-06-06 | A kind of database data processing method, device and terminal |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710418648.4A CN107273468B (en) | 2017-06-06 | 2017-06-06 | A kind of database data processing method, device and terminal |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107273468A CN107273468A (en) | 2017-10-20 |
| CN107273468B true CN107273468B (en) | 2018-08-03 |
Family
ID=60065423
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710418648.4A Active CN107273468B (en) | 2017-06-06 | 2017-06-06 | A kind of database data processing method, device and terminal |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107273468B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102789487A (en) * | 2012-06-29 | 2012-11-21 | 用友软件股份有限公司 | Data query and retrieval processing device and data query and retrieval processing method |
| CN105739970A (en) * | 2016-01-20 | 2016-07-06 | 北京京东尚科信息技术有限公司 | Method and device for mapping data into custom class object |
| US9430494B2 (en) * | 2009-12-28 | 2016-08-30 | Oracle International Corporation | Spatial data cartridge for event processing systems |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106020937A (en) * | 2016-07-07 | 2016-10-12 | 腾讯科技（深圳）有限公司 | Method, device and system for creating virtual machine |
-
2017
- 2017-06-06 CN CN201710418648.4A patent/CN107273468B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9430494B2 (en) * | 2009-12-28 | 2016-08-30 | Oracle International Corporation | Spatial data cartridge for event processing systems |
| CN102789487A (en) * | 2012-06-29 | 2012-11-21 | 用友软件股份有限公司 | Data query and retrieval processing device and data query and retrieval processing method |
| CN105739970A (en) * | 2016-01-20 | 2016-07-06 | 北京京东尚科信息技术有限公司 | Method and device for mapping data into custom class object |
Non-Patent Citations (2)
| Title |
|---|
| An efficient SQL-based RDF querying scheme;El Chong等;《ACM》;20050902;全文 * |
| 云计算系统中索引与查询处理技术研究;王金宝;《中国博士学位论文全文数据库 信息科技辑》;20140115(第1期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107273468A (en) | 2017-10-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104965721B (en) | The method and device that a kind of pair of application program is updated | |
| CN105278937B (en) | A kind of method and device showing pop-up box message | |
| CN105119806B (en) | message updating method and device | |
| CN104142868B (en) | Establish the method and device of connection | |
| CN108880867A (en) | A kind of network equipment collecting method and system | |
| CN106126174B (en) | A kind of control method and electronic equipment of scene audio | |
| CN106919918A (en) | A kind of face tracking method and device | |
| CN107357656A (en) | A kind of memory allocation method, mobile terminal and computer-readable recording medium | |
| CN104516888B (en) | The permission querying method and device of multidimensional data | |
| CN107766139B (en) | Application management method and device | |
| CN110674112A (en) | Data query method and device and electronic equipment | |
| CN107204964A (en) | A kind of methods, devices and systems of rights management | |
| CN104252341A (en) | Method and device for resurfacing application program and client side device of application program | |
| CN109992367A (en) | Application processing method and device, electronic equipment, computer readable storage medium | |
| CN110019840A (en) | The method, apparatus and server that entity updates in a kind of knowledge mapping | |
| CN106453030B (en) | A kind of method and device obtaining social networks chain | |
| CN106385485A (en) | Call recording method, call recording device and mobile terminal | |
| CN106412033A (en) | Data migration method and terminal | |
| CN108989887A (en) | The method, apparatus of mobile terminal and pushing video | |
| CN108011687B (en) | Data processing method and device | |
| CN106708500B (en) | Unload the display methods and device at interface | |
| CN106681884B (en) | A kind of monitoring method and device of system calling | |
| CN110413639A (en) | Data check method and device, electronic equipment and computer readable storage medium | |
| CN109062643A (en) | A kind of display interface method of adjustment, device and terminal | |
| CN106095558B (en) | A kind of method and terminal of audio effect processing |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20231009 Address after: 100190 Beijing Haidian District Zhichun Road 49 No. 3 West 309 Patentee after: TENCENT CLOUD COMPUTING (BEIJING) Co.,Ltd. Address before: 518000, 35th Floor, Tencent Building, Keji Zhongyi Road, High tech Zone, Nanshan District, Shenzhen City, Guangdong Province Patentee before: TENCENT TECHNOLOGY (SHENZHEN) Co.,Ltd. |
|
| TR01 | Transfer of patent right |