CN103810273B - A kind of data screening method and device based on cloud computing - Google Patents
A kind of data screening method and device based on cloud computing Download PDFInfo
- Publication number
- CN103810273B CN103810273B CN201410048524.8A CN201410048524A CN103810273B CN 103810273 B CN103810273 B CN 103810273B CN 201410048524 A CN201410048524 A CN 201410048524A CN 103810273 B CN103810273 B CN 103810273B
- Authority
- CN
- China
- Prior art keywords
- screening
- screening conditions
- field
- user
- data
- 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
- 238000012216 screening Methods 0.000 title claims abstract description 418
- 238000000034 method Methods 0.000 title claims abstract description 49
- 238000013500 data storage Methods 0.000 claims description 8
- 235000013399 edible fruits Nutrition 0.000 claims description 4
- 235000013410 fast food Nutrition 0.000 description 24
- 238000005516 engineering process Methods 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000001747 exhibiting effect Effects 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- 230000003796 beauty Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 210000004709 eyebrow Anatomy 0.000 description 1
- 210000004209 hair Anatomy 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 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/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24561—Intermediate data storage techniques for performance improvement
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of data screening method and device based on cloud computing, wherein, methods described includes：Receive the screening conditions of each field of user's data to be checked；The screening conditions of each field of data to be checked are locked successively, the screening conditions of other fields according to corresponding to inquiring about the screening conditions of the field in the screening conditions of the field of Current lock beyond the clouds source database, if the screening conditions of other fields of user data to be checked in the screening conditions of other fields described in inquiring be present, the screening conditions of the screening conditions of the field of the Current lock and other fields are then combined screening, generate screening scheme；Data query is carried out in the high in the clouds source database according to the screening scheme, obtains Query Result.Present invention can ensure that during screening is combined, system can remain at each field and all provide screening scheme, to improve the flexibility ratio for inquiring about data, improve Consumer's Experience.
Description
Technical field
The present invention relates to the communications field, and in particular to a kind of data screening method and device based on cloud computing.
Background technology
As shown in figure 1, at present, the data screening system based on cloud computing, including：Cloud Server and client, cloud service
Device is placed the data in the source database of high in the clouds by cloud computing technology, receives the query statement that client is sent, and will inquiry
As a result client is sent to, available data is all stored in the source database of high in the clouds in the form of multiple fields, in source database
The corresponding relation between the screening conditions of each field of data storage, and the screening conditions of each field is preserved, screens bar
Part is from the data characteristic of each field extraction, table 1：The correspondence of the screening conditions of each field of high in the clouds source database available data
Relation
The corresponding relation of the screening conditions of each field of available data is given, the screening conditions that corresponding relation be present can be with
Inquire corresponding data.It is field A and field B respectively assuming that the data stored in the source database of high in the clouds are divided into two fields,
Screening conditions in wherein field A are a1, a2, a3 respectively, and screening conditions are to represent the characteristic that field A has, a1, a2, a3 point
Not Biao Shi field A 3 characteristics, the screening conditions in field B are b1, b2, b3 respectively, represent 3 characteristics that field B is included,
The screening conditions of field in the table 1 can inquire all data in database.
| A | B |
| a1 | b1 |
| a1 | b2 |
| a1 | b3 |
| a2 | b1 |
| a2 | b2 |
| a3 | b1 |
| a3 | b3 |
Table 1：The corresponding relation of the screening conditions of each field of high in the clouds source database available data
For example, it is assumed that the available data in source database is Pekinese dining room, as shown in table 2, there are two words in each dining room
Section, field A represent dining room generic, and field B represents dining room affiliated area, and field A screening conditions have fast food, self-service and ground
Square dish, field B screening conditions have Xidan, Zhong Guan-cun, a Wangjing, table 2 indicate the screening conditions of each field, corresponding relation and
Corresponding data.
| A | B | Data storage |
| Fast food | Xidan | KFC |
| Fast food | Zhong Guan-cun | McDonald |
| Fast food | Wangjing | Real skill |
| It is self-service | Xidan | Leopard |
| It is self-service | Zhong Guan-cun | Golden Pusan |
| Local dish | Xidan | South Beauty |
| Local dish | Wangjing | Eyebrow state Dong Po |
Table 2
For multiword segment data, triage techniques is combined using data, existing data combination triage techniques is broadly divided into two
Kind：
Method one：Screening scheme immobilizes
The screening scheme is to provide screening scheme by system programming count, no matter what the screening conditions of user are, system
All provide the same screening scheme（That is, screening scheme state 0, state 1, state 2）.
For example, user's target data to be checked is that screening conditions are（Fast food, Xidan）Corresponding data.Used in user
When method one carries out data screening, first, system can provide the screening scheme shape of method one according to high in the clouds source database available data
State 0, and show that as shown in table 3, table 3 is the field A extracted according to table 1 characteristic to user（Screening conditions）With field B
Characteristic（Screening conditions）, table 3 illustrates all screening conditions of field A and field B to user respectively（The row of table 3 the 2nd~4）,
Equivalent to the Drop Down Menu Choices for user's selection；
| A | B |
| Fast food | Xidan |
| It is self-service | Zhong Guan-cun |
| Local dish | Wangjing |
Table 3：The screening scheme state 0 of method one
Then, user first selectes field A screening conditions fast food, system meeting lock field A screening conditions（The row of table 4 the 1st
Selected fast food）And shown to user, while can be according to database available data to the screening scheme state 1 of user's methods of exhibiting one
（The row of table 4 the 2nd~4）, that is to say, that all screening bars of field A and field B can be still shown to user by the system of method one
Part, as shown in table 4：
| Fast food | B |
| Fast food | Xidan |
| It is self-service | Zhong Guan-cun |
| Local dish | Wangjing |
Table 4：The screening scheme state 1 of method one
Pay attention to, simply all screening conditions of field A and field B shown to user in table 4, between two fields without pair
It should be related to, differ and surely correspond to corresponding data, it is necessary to field B screening conditions be selected in user, by two screening conditions
Send to after Cloud Server, if Cloud Server inquire two fields corresponding to data could return to corresponding data, if
Inquire about less than the information for then returning to inquiry failure.
Then, user selectes field B screening conditions Xidan, system meeting lock field B screening conditions again（The row of table 5 the 1st
Selected fast food, Xidan）And shown to user, now system can still show all screening bars of field A and field B to user
Part, i.e. screening scheme state 2（The row of table 5 the 2nd~4）, as shown in table 5：
| Fast food | Xidan |
| Fast food | Xidan |
| It is self-service | Zhong Guan-cun |
| Local dish | Wangjing |
Table 5：The alternative storehouse that method one ultimately generates
Finally, user determines selected screening conditions（Fast food, Xidan）, client sends the screening conditions to Cloud Server
Data query is carried out in source database beyond the clouds, obtains Query Result, the target data to be inquired about of user is returned to user, if
Corresponding data are not inquired about, then return query failure message to user.
Method two：Screening frame changed in stages
For example, user's target data to be checked is that screening conditions are（Local dish, Xidan）Corresponding data.Make in user
When carrying out data screening with method two, first, system can be sieved according to high in the clouds source database available data to user's methods of exhibiting two
Scheme state 0 is selected, it is identical with the screening scheme state 0 of method one, as shown in table 3, i.e., show that field A and field B owns to user
Screening conditions.
Then, user first selectes field A screening conditions local dish, system meeting lock field A screening conditions（Table 6 the 1st
The selected local dish of row）And shown to user, simultaneity factor shows that source database is inquired corresponding to local dish beyond the clouds to user
Xidan, Wangjing corresponding to field B screening conditions, i.e. local dish（The row of table 6 the 2nd~3）, reach the screening scheme state 1 of method two,
As shown in table 6.
| Local dish | B |
| Xidan | |
| Wangjing |
Table 6：The screening scheme state 1 of method two
Then, user selectes field B screening conditions Xidan again, and system can relock field B screening conditions（Table 7 the 1st
The selected local dish of row, Xidan）And shown to user, reach the screening scheme state 2 of method two, as shown in table 7.
| Local dish | Xidan |
Table 7：The screening scheme that method two ultimately generates
Finally, user determines selected screening conditions（Local dish, Xidan）, client sends the screening bar to Cloud Server
Part carries out data query in source database beyond the clouds, obtains Query Result, and the target data to be inquired about of user is returned to user.
But problems with existing method be present：
1st, there is problems with method one：
When user's application method one carry out data combined sorting when, system to the screening scheme that user shows be basis all the time
All screening conditions of each field that database available data is drawn, the screening conditions between field do not have corresponding relation, because
This, user directly can not determine whether the data to be inquired about of user according to the screening conditions shown, for example, first, user
The screening conditions for selecting A fields successively are local dish, and the screening conditions of B field are Zhong Guan-cun, and then, client is by the screening bar
Part is sent to server end and inquires about data, and query failure message is returned if data are not inquired.That is, only exist
The screening conditions that user selectes field A and field B are combined after screening, can just be informed by system in database and not met
The data of user's screening conditions.Method one can not allow user know in time inquiry less than situation, the embodiment degree of user is high.
2nd, there is problems with method two：
When user's application method two carries out data combined sorting, data screening condition can be by automatic classification, when user selects
After the screening conditions for determining field A, system can remove field A remaining screening conditions, select word every time to user's displaying successively
Screening scheme after section, as shown in table 6, user can only see the screening conditions of B field, and this method changes inquiry in user
When target data wants to reselect the screening conditions of A fields, system can not provide remaining screening scheme, and user can only cancel it
Preceding screening, garbled data again, flexibility ratio when inquiring about data is low, and user experience is not high.
The content of the invention
The technical problem to be solved in the invention is to provide a kind of data screening method and device based on cloud computing, can be with
Ensure during screening is combined, system can remain at each field and all provide screening scheme, to improve inquiry
The flexibility ratio of data, improve Consumer's Experience.
In order to solve the above-mentioned technical problem, the invention provides a kind of data screening method based on cloud computing, including：
Receive the screening conditions of each field of user's data to be checked；
The screening conditions of each field of data to be checked are locked successively, according to the screening conditions of the field of Current lock
The screening conditions of other fields corresponding to the screening conditions of the field are inquired about in source database beyond the clouds, if in the institute inquired
State the screening conditions for other fields that user data to be checked in the screening conditions of other fields be present, then will be described current
The screening conditions of the screening conditions of the field of locking and other fields are combined screening, generate screening scheme；
Data query is carried out in the high in the clouds source database according to the screening scheme, obtains Query Result.
Further, the screening conditions of each field of data storage are preserved in the high in the clouds source database, and it is each
Corresponding relation between the screening conditions of field.
Further, the sieve of the field is inquired about in source database beyond the clouds in the screening conditions of the field according to Current lock
After selecting the screening conditions of other fields corresponding to condition, in addition to：
The screening conditions of each field are shown to the user, if described in inquire other fields screening conditions
In be not present user data to be checked other fields screening conditions, then receive the user abandon inquiry finger
After order, terminate inquiry.
Further, the screening conditions of the field by the Current lock carry out group with the screening conditions of other fields
Screening is closed, generates screening scheme, including：
The screening conditions of locking other fields, according to the screening of other fields in the high in the clouds source database
The screening conditions of the field of the Current lock corresponding to condition query, by the screening conditions of the field of the Current lock inquired
It is combined with the screening conditions of other fields, generates screening scheme.
Further, the sieve of the field is inquired about in source database beyond the clouds in the screening conditions of the field according to Current lock
After selecting the screening conditions of other fields corresponding to condition, and after screening scheme is generated, in addition to：
The screening conditions of each field are shown to the user；
When the user changes the screening conditions of each field of data to be checked, the user is received from displaying
Each field in select screening conditions；
Carried out according to the screening conditions that the user selectes from each field of displaying in the high in the clouds source database
Data query, obtain Query Result.
In order to solve the above-mentioned technical problem, present invention also offers a kind of data screening device based on cloud computing, including：
Receiving module, for receiving the screening conditions of each field of user's data to be checked；
Screening module, for locking the screening conditions of each field of data to be checked successively, according to Current lock
The screening conditions of field inquire about the screening conditions of other fields corresponding to the screening conditions of the field in source database beyond the clouds, such as
The screening bar of other fields of user data to be checked in the screening conditions of other fields described in inquiring be present in fruit
Part, then the screening conditions of the screening conditions of the field of the Current lock and other fields are combined screening, generated
Screening scheme；
Enquiry module, for according to data query is carried out in the high in the clouds source database in the screening scheme, obtaining
Query Result.
Further, the screening conditions of each field of data storage, and each field are preserved in the source database
Screening conditions between corresponding relation.
Further, described device also includes the display module being connected with the screening module, wherein：
The screening module, it is additionally operable to inquire about in source database beyond the clouds in the screening conditions of the field according to Current lock
After the screening conditions of other fields corresponding to the screening conditions of the field, it is each to notify that the display module is shown to the user
The screening conditions of field, if user data to be checked are not present in the screening conditions of other fields described in inquiring
Other fields screening conditions, then receive the user abandon inquiry instruction after, notify the enquiry module to terminate
Inquiry；
The display module, for after the notice of the screening module is received, each field to be shown to the user
Screening conditions；
The enquiry module, be additionally operable to receive the user abandon inquiry instruction after, terminate inquiry.
Further, the screening module, for by the screening conditions of the field of the Current lock and other fields
Screening conditions are combined screening, generate screening scheme, including：
The screening conditions of locking other fields, according to the screening of other fields in the high in the clouds source database
The screening conditions of the field of the Current lock corresponding to condition query, by the screening conditions of the field of the Current lock inquired
It is combined with the screening conditions of other fields, generates screening scheme.
Further, described device also includes the display module being connected with the screening module, wherein：
The screening module, it is additionally operable to inquire about in source database beyond the clouds in the screening conditions of the field according to Current lock
After the screening conditions of other fields corresponding to the screening conditions of the field, and after screening scheme is generated, notify the exhibition
Show that module shows the screening conditions of each field to the user；When the user changes each field of data to be checked
Screening conditions when, receive the screening conditions that the user selectes from each field of displaying and send to the inquiry mould
Block；
The display module, for after the notice of the screening module is received, each field to be shown to the user
Screening conditions；
The enquiry module, for according to the user from each field of displaying select screening conditions in the cloud
Data query is carried out in the source database of end, obtains Query Result.
Compared with prior art, the data screening method and device provided by the invention based on cloud computing, has following beneficial
Technique effect：
1）When can ensure not having in source database beyond the clouds the target data to be inquired about of user, user can not carry out group
Screening is closed, user is known situation of the inquiry less than data in time, the time of user will not be wasted, improve user's body
Test；
2）During screening is combined, system can remain at each field and all provide screening scheme；With
When family changes the target data to be inquired about, system can neatly provide remaining screening scheme, and user need not screen again
Data, flexibility ratio during inquiry data is improved, improves Consumer's Experience.
Brief description of the drawings
Fig. 1 is the data screening system construction drawing based on cloud computing；
Fig. 2 is the structure chart of the data screening device based on cloud computing in embodiment；
Fig. 3 is the flow chart of the data screening method based on cloud computing in embodiment；
Fig. 4 is the flow chart of the data screening method based on cloud computing in an application example.
Embodiment
For the object, technical solutions and advantages of the present invention are more clearly understood, below in conjunction with accompanying drawing to the present invention
Embodiment be described in detail.It should be noted that in the case where not conflicting, in the embodiment and embodiment in the application
Feature can mutually be combined.
Embodiment：
As shown in figure 1, a kind of data screening system based on cloud computing is present embodiments provided, including：Cloud Server and
Client, Cloud Server are placed the data in the source database of high in the clouds by cloud computing technology, receive the inquiry that client is sent
Instruction, and Query Result is sent to client, the client includes the dress of the data screening based on cloud computing as shown in Figure 2
Put, the device, including：
Receiving module, for receiving the screening conditions of each field of user's data to be checked；
Screening module, for locking the screening conditions of each field of data to be checked successively, according to Current lock
The screening conditions of field inquire about the screening conditions of other fields corresponding to the screening conditions of the field in source database beyond the clouds, such as
The screening bar of other fields of user data to be checked in the screening conditions of other fields described in inquiring be present in fruit
Part, then the screening conditions of the screening conditions of the field of the Current lock and other fields are combined screening, generated
Screening scheme；
Enquiry module, for according to data query is carried out in the high in the clouds source database in the screening scheme, obtaining
Query Result.
Wherein, the screening conditions of each field of data storage, and the sieve of each field are preserved in the source database
Select the corresponding relation between condition.
Preferably, described device also includes the display module being connected with the screening module, wherein：
The screening module, it is additionally operable to inquire about in source database beyond the clouds in the screening conditions of the field according to Current lock
After the screening conditions of other fields corresponding to the screening conditions of the field, it is each to notify that the display module is shown to the user
The screening conditions of field, if user data to be checked are not present in the screening conditions of other fields described in inquiring
Other fields screening conditions, then receive the user abandon inquiry instruction after, notify the enquiry module to terminate
Inquiry；
The display module, for after the notice of the screening module is received, each field to be shown to the user
Screening conditions；
The enquiry module, be additionally operable to receive the user abandon inquiry instruction after, terminate inquiry.
Wherein, the screening module, for by the screening of the screening conditions of the field of the Current lock and other fields
Condition is combined screening, generates screening scheme, including：
The screening conditions of locking other fields, according to the screening of other fields in the high in the clouds source database
The screening conditions of the field of the Current lock corresponding to condition query, by the screening conditions of the field of the Current lock inquired
It is combined with the screening conditions of other fields, generates screening scheme.
The screening module, it is additionally operable to inquire about in source database beyond the clouds in the screening conditions of the field according to Current lock
After the screening conditions of other fields corresponding to the screening conditions of the field, and after screening scheme is generated, notify the exhibition
Show that module shows the screening conditions of each field to the user；When the user changes each field of data to be checked
Screening conditions when, receive the screening conditions that the user selectes from each field of displaying and send to the inquiry mould
Block；
The display module, for after the notice of the screening module is received, each field to be shown to the user
Screening conditions；
The enquiry module, for according to the user from each field of displaying select screening conditions in the cloud
Data query is carried out in the source database of end, obtains Query Result.
As shown in figure 3, present embodiments providing a kind of data screening method based on cloud computing, comprise the following steps：
S101：Client receives the screening conditions of each field of user's data to be checked；
S102：The screening conditions of each field of data to be checked are locked successively, according to the sieve of the field of Current lock
Condition is selected to inquire about the screening conditions of other fields corresponding to the screening conditions of the field in source database beyond the clouds；
Wherein, the screening conditions of each field of data storage, and each field are preserved in the high in the clouds source database
Screening conditions between corresponding relation.
S103：If its of user data to be checked in the screening conditions of other fields described in inquiring be present
The screening conditions of his field, then the screening conditions of the screening conditions of the field of the Current lock and other fields are carried out
Combined sorting, generate screening scheme；
S104：According to data query is carried out in the high in the clouds source database in the screening scheme, Query Result is obtained.
In step s 103, the field is inquired about in source database beyond the clouds in the screening conditions of the field according to Current lock
Screening conditions corresponding to other fields screening conditions after, in addition to：
The screening conditions of each field are shown to the user, if described in inquire other fields screening conditions
In be not present user data to be checked other fields screening conditions, then receive the user abandon inquiry finger
After order, terminate inquiry.Before screening is not combined, the target data to be inquired about of no user, user are just had determined that
Screening need not be combined, so the time of user will not be wasted, improves Consumer's Experience.
Wherein, the screening conditions of the field by the Current lock are combined sieve with the screening conditions of other fields
Choosing, screening scheme is generated, including：
The screening conditions of locking other fields, according to the screening of other fields in the high in the clouds source database
The screening conditions of the field of the Current lock corresponding to condition query, by the screening conditions of the field of the Current lock inquired
It is combined with the screening conditions of other fields, generates screening scheme.
Wherein, in step s 103, inquired about beyond the clouds in source database in the screening conditions of the field according to Current lock
After the screening conditions of other fields corresponding to the screening conditions of the field, and after screening scheme is generated, in addition to：To
The user shows the screening conditions of each field；When the user changes the screening conditions of each field of data to be checked
When, receive the screening conditions that the user selectes from each field of displaying；
In step S104, the screening conditions selected according to the user from each field of displaying are in the high in the clouds source
Data query is carried out in database, obtains Query Result.
In an application example, it is assumed that the data stored in the source database of high in the clouds are divided into two fields, as shown in table 1,
It is field A and field B respectively, the screening conditions in wherein field A are a1, a2, a3 respectively, and a1, a2, a3 represent field A respectively
3 characteristics, the screening conditions in field B are b1, b2, b3 respectively, represent field B 3 characteristics.Certainly, in practical application
In, the data of high in the clouds storage can also be divided into multiple fields, and client shows the screening conditions of multiple fields to user.This hair
The bright number for not limiting field.
By taking the source database in Beijing dining room shown in table 2 as an example, exemplified by as shown in figure 4, this application example provides one kind
Data screening method based on cloud computing, comprises the following steps：
S201：Client receives the screening conditions of each field of user's data to be checked（Local dish, Xidan）, in user
When carrying out data screening, system can provide screening scheme state 0 according to database available data, and show user, such as the institute of table 3
Show.
S202：User first selectes field A screening conditions local dish, system meeting lock field A screening conditions（Table 8 the 1st
The selected local dish of row）, corresponding field B screening conditions Xidan, Wangjing are inquired in source database beyond the clouds, system can again successively
Lock field B screening conditions Xidan, Wangjing, and inquired beyond the clouds in source database field A screening conditions fast food, from
Help and local dish, obtain screening scheme state 1（The row of table 8 the 2nd~4）, as shown in table 8, give the screening conditions that field A is included
With field B screening conditions, it is noted that now, field A and field B screening conditions have corresponding relation, according to the two
Screening conditions can directly obtain corresponding data.
| Local dish | B |
| Fast food | Xidan |
| It is self-service | Xidan |
| Local dish | Xidan |
| Fast food | Wangjing |
| Local dish | Wangjing |
Table 8：Screening scheme state 1
S203：Client is by the content displaying of the table 8 of screening scheme state 1 to user；
If using method two of the prior art, once selected field A, field A just lock screened condition, such as
Local dish is locked, other screening conditions for providing field A, the screening scheme such as institute of table 6 shown to user will not be shown to user
Show, and in the present embodiment, after field A selectes screening conditions, according to inquiring about twice, obtained screening conditions（Selected according to field A
Fixed local dish, screening conditions Xidan, the Wangjing of field B corresponding to local dish are inquired, further according to Xidan, Wangjing, is inquired
Screening conditions fast food, the self-service and local dish of field A corresponding to Xidan, Wangjing）It can directly select, be inquired about in cloud source database
To corresponding data.
Now, after user screens field A, if user changes target data, the new each field of data to be checked
Screening conditions be（It is self-service, Xidan）, now field A screening scheme is fast food, self-service, local dish, and user only needs to screen
Go out " self-service " can, without cancelling whole screening process, screen again.
S204：Judge the screening conditions in the field B inquired（It is Xidan in the present embodiment, Wangjing）In whether deposit
In the screening conditions of the target data B field（It is Xidan in the present embodiment）, if it does not exist, then performing step S205, such as
Fruit is present, then performs step S206；
S205：Client receives the instruction that user abandons inquiry, terminates inquiry.
Because now user can see the screening conditions of the B field of the displaying of table 8, therefore, it can be seen directly that either with or without
" Xidan " this screening conditions, if not provided, corresponding data are also not present in explanation source database, directly abandon inquiring about.From
And when can ensure not having in data beyond the clouds the target data of user, user can not be combined screening；Use will not be wasted
The time at family, improve user's embodiment.But if using prior art method one, step S206 is had to carry out, in step
After rapid S206, i.e., whether after combined sorting, just can determine that in data block has the screening conditions to be inquired about of user, search efficiency
It is not high.
S206：User selectes field B screening conditions Xidan, system meeting lock field B screening conditions again（The row of table 9 the 1st
Selected local dish, Xidan）, and inquire in source database Xidan corresponding field A screening conditions fast food, self-service and local
Dish, system can lock field A screening conditions successively again（Fast food, self-service and local dish）, and the map locating in source database
Go out corresponding field B screening conditions（Xidan, Zhong Guan-cun, Wangjing）, screening scheme state 2 is obtained, as shown in table 9, gives word
The screening conditions and field B screening conditions that section A is included, it is noted that now, field A and field B screening conditions are to exist to correspond to
Relation, it can directly obtain corresponding data according to the two screening conditions.
| Local dish | Xidan |
| Fast food | Xidan |
| Fast food | Zhong Guan-cun |
| Fast food | Wangjing |
| It is self-service | Xidan |
| It is self-service | Zhong Guan-cun |
| Local dish | Xidan |
| Local dish | Wangjing |
Table 9：The screening scheme that the present embodiment ultimately generates
S207：By the content displaying of final screening scheme table 9 to user；
Now, if user changes inquiry data, corresponding screening bar can also be selected in the screening conditions that table 9 is shown
Part, it is not necessary to cancel whole screening process, screen again.
S208：User clicks on selected screening conditions, and client sends request in the high in the clouds source data to Cloud Server
Data query is carried out in storehouse, obtains Query Result, the target data to be inquired about of user is returned to user.
From above-described embodiment as can be seen that relative to prior art, the number based on cloud computing that is provided in above-described embodiment
According to screening technique and system, there is following beneficial technique effect：
1）When can ensure not having in source database beyond the clouds the target data to be inquired about of user, user can not carry out group
Screening is closed, user is known situation of the inquiry less than data in time, the time of user will not be wasted, improve user's body
Test；
2）During screening is combined, system can remain at each field and all provide screening scheme；With
When family changes the target data to be inquired about, system can neatly provide remaining screening scheme, and user need not screen again
Data, flexibility ratio during inquiry data is improved, improves Consumer's Experience.
One of ordinary skill in the art will appreciate that all or part of step in the above method can be instructed by program
Related hardware is completed, and described program can be stored in computer-readable recording medium, such as read-only storage, disk or CD
Deng.Alternatively, all or part of step of above-described embodiment can also be realized using one or more integrated circuits.Accordingly
Ground, each module/unit in above-described embodiment can be realized in the form of hardware, can also use the shape of software function module
Formula is realized.The present invention is not restricted to the combination of the hardware and software of any particular form.
The preferred embodiments of the present invention are the foregoing is only, are not intended to limit the scope of the present invention.According to
The content of the invention of the present invention, can also there is other various embodiments, in the case of without departing substantially from spirit of the invention and its essence, be familiar with
Those skilled in the art works as can make various corresponding changes and deformation according to the present invention, all in the spirit and principles in the present invention
Within, any modification, equivalent substitution and improvements made etc., it should be included in the scope of the protection.
Claims (8)
1. a kind of data screening method based on cloud computing, Cloud Server are placed the data in the source database of high in the clouds, visitor is received
The query statement that family end is sent, and Query Result is sent to client, preserve data storage in the high in the clouds source database
Corresponding relation between the screening conditions of each field, and the screening conditions of each field；Including：
Receive the screening conditions of each field of user's data to be checked；
The screening conditions of each field of data to be checked are locked successively, according to the screening conditions of Current lock field
The screening conditions of other fields corresponding to the screening conditions of the field are inquired about in source database beyond the clouds, if in the institute inquired
State the screening conditions for other fields that user data to be checked in the screening conditions of other fields be present, then will be described current
The screening conditions of a field of locking are combined screening with the screening conditions of other fields, generate screening scheme；
Data query is carried out in the high in the clouds source database according to the screening scheme, obtains Query Result.
2. the method as described in claim 1, it is characterised in that：
Corresponding to the screening conditions of the field being inquired about in the screening conditions of the field according to Current lock in source database beyond the clouds
After the screening conditions of other fields, in addition to：
The screening conditions of each field are shown to the user, if in the screening conditions of other fields described in inquiring not
The screening conditions of other fields of user data to be checked be present, then receive the user abandon inquiry instruction
Afterwards, inquiry is terminated.
3. method as claimed in claim 2, it is characterised in that：
The screening conditions of the field by the Current lock are combined screening, generation sieve with the screening conditions of other fields
Scheme is selected, including：
The screening conditions of locking other fields, according to the screening conditions of other fields in the high in the clouds source database
The screening conditions of the field of the Current lock corresponding to inquiry, by the screening conditions of the field of the Current lock inquired and institute
The screening conditions for stating other fields are combined, and generate screening scheme.
4. the method as described in claim 1, it is characterised in that：
Corresponding to the screening conditions of the field being inquired about in the screening conditions of the field according to Current lock in source database beyond the clouds
After the screening conditions of other fields, and after screening scheme is generated, in addition to：
The screening conditions of each field are shown to the user；
When the user changes the screening conditions of each field of data to be checked, the user is received from each of displaying
The screening conditions selected in individual field；
According to the screening conditions that the user selectes from each field of displaying data are carried out in the high in the clouds source database
Inquiry, obtains Query Result.
5. a kind of data screening device based on cloud computing, Cloud Server are placed the data in the source database of high in the clouds, visitor is received
The query statement that family end is sent, and Query Result is sent to client, preserve data storage in the high in the clouds source database
Corresponding relation between the screening conditions of each field, and the screening conditions of each field；Including：
Receiving module, for receiving the screening conditions of each field of user's data to be checked；
Screening module, for locking the screening conditions of each field of data to be checked successively, according to the one of Current lock
The screening conditions of field inquire about the screening conditions of other fields corresponding to the screening conditions of the field in source database beyond the clouds, such as
The screening bar of other fields of user data to be checked in the screening conditions of other fields described in inquiring be present in fruit
Part, then the screening conditions of the screening conditions of a field of the Current lock and other fields are combined screening,
Generate screening scheme；
Enquiry module, for according to data query is carried out in the high in the clouds source database in the screening scheme, being inquired about
As a result.
6. device as claimed in claim 5, it is characterised in that：Described device also includes the displaying being connected with the screening module
Module, wherein：
The screening module, it is additionally operable to inquire about the word in source database beyond the clouds in the screening conditions of the field according to Current lock
After the screening conditions of other fields corresponding to the screening conditions of section, the display module is notified to show each field to the user
Screening conditions, if in the screening conditions of other fields described in inquiring be not present user data to be checked its
The screening conditions of his field, then receive the user abandon inquiry instruction after, notify the enquiry module to terminate to inquire about；
The display module, for after the notice of the screening module is received, the screening of each field to be shown to the user
Condition；
The enquiry module, be additionally operable to receive the user abandon inquiry instruction after, terminate inquiry.
7. device as claimed in claim 6, it is characterised in that：
The screening module, for the screening conditions of the screening conditions of the field of the Current lock and other fields to be carried out into group
Screening is closed, generates screening scheme, including：
The screening conditions of locking other fields, according to the screening conditions of other fields in the high in the clouds source database
The screening conditions of the field of the Current lock corresponding to inquiry, by the screening conditions of the field of the Current lock inquired and institute
The screening conditions for stating other fields are combined, and generate screening scheme.
8. device as claimed in claim 5, it is characterised in that：Described device also includes the displaying being connected with the screening module
Module, wherein：
The screening module, it is additionally operable to inquire about the word in source database beyond the clouds in the screening conditions of the field according to Current lock
After the screening conditions of other fields corresponding to the screening conditions of section, and after screening scheme is generated, notify the displaying mould
Block shows the screening conditions of each field to the user；When the user changes the sieve of each field of data to be checked
When selecting condition, receive the screening conditions that the user selectes from each field of displaying and send to the enquiry module；
The display module, for after the notice of the screening module is received, the screening of each field to be shown to the user
Condition；
The enquiry module, for according to the user from each field of displaying select screening conditions in the high in the clouds source
Data query is carried out in database, obtains Query Result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410048524.8A CN103810273B (en) | 2014-02-12 | 2014-02-12 | A kind of data screening method and device based on cloud computing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410048524.8A CN103810273B (en) | 2014-02-12 | 2014-02-12 | A kind of data screening method and device based on cloud computing |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103810273A CN103810273A (en) | 2014-05-21 |
| CN103810273B true CN103810273B (en) | 2018-03-27 |
Family
ID=50707043
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410048524.8A Active CN103810273B (en) | 2014-02-12 | 2014-02-12 | A kind of data screening method and device based on cloud computing |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103810273B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106447441A (en) * | 2016-09-21 | 2017-02-22 | 上海鲶鱼网络科技有限公司 | Data processing system and method |
| CN109299910A (en) * | 2018-08-21 | 2019-02-01 | 北京海数宝科技有限公司 | Data summarization method, device, computer equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101194257A (en) * | 2005-03-30 | 2008-06-04 | 电子湾有限公司 | Methods and systems to process search information |
| CN103279525A (en) * | 2013-05-29 | 2013-09-04 | 浙江搜车客网络技术有限公司 | Multi-condition linkage searching method based on Hash optimization |
| CN103488692A (en) * | 2013-09-02 | 2014-01-01 | 用友软件股份有限公司 | Data query system and data query method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090327231A1 (en) * | 2008-06-27 | 2009-12-31 | Microsoft Corporation | Inline enhancement of web lists |
-
2014
- 2014-02-12 CN CN201410048524.8A patent/CN103810273B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101194257A (en) * | 2005-03-30 | 2008-06-04 | 电子湾有限公司 | Methods and systems to process search information |
| CN103279525A (en) * | 2013-05-29 | 2013-09-04 | 浙江搜车客网络技术有限公司 | Multi-condition linkage searching method based on Hash optimization |
| CN103488692A (en) * | 2013-09-02 | 2014-01-01 | 用友软件股份有限公司 | Data query system and data query method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103810273A (en) | 2014-05-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103944932B (en) | Search for, determine the method and server of active regions | |
| CN104991924B (en) | Method and apparatus for the address for determining new supply centre | |
| CN105302916A (en) | Information recommendation method and device | |
| CN103377204B (en) | A kind of exhibiting method of map search result and device | |
| CN103853769B (en) | A kind of map inquiry request processing method and device | |
| CN105975627A (en) | Room choosing method and device | |
| CN105426375B (en) | A kind of calculation method and device of relational network | |
| CN105243169B (en) | A kind of data query method and system | |
| CN103927310B (en) | Generation method and device are suggested in a kind of search of map datum | |
| CN111967964B (en) | Intelligent recommending method and device for bank client sites | |
| SG175286A1 (en) | Improvements in or relating to a method and system of booking management | |
| CN105894234A (en) | Data processing method and data processing system for calculating throwing position of self-service parcel cabinet | |
| CN106354719B (en) | POI service providing method, POI data processing method and processing device | |
| CN105975537A (en) | Sorting method and device of application program | |
| CN103810273B (en) | A kind of data screening method and device based on cloud computing | |
| CN104077360A (en) | GIS (Geographic Information System) real estate valuation based data processing system and method | |
| CN109669999A (en) | The generation method and device in interest region, storage medium, electronic device | |
| CN110347882A (en) | Consanguinity analysis method and device, storage medium and the electronic device of data | |
| CN106528559B (en) | Method and device for providing position information | |
| CN108257596A (en) | It is a kind of to be used to provide the method and apparatus that information is presented in target | |
| CN103487057B (en) | Paths planning method based on end points extension and device | |
| CN103793804A (en) | Logistics distribution platform cloud service management system | |
| WO2014088892A8 (en) | Methods, devices and systems for the generation of requests for quotes from aggregated construction-related and permitting information | |
| CN110288390A (en) | Determine the method and device of address | |
| CN106156275A (en) | A kind of method and apparatus of singulated inquiry |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |