Invention content
The main purpose of the present invention is to provide a kind of batch data processing method and processing device for client end interface, with
Solve the problems, such as that in the related technology operating efficiency is low when to data progress batch modification.
To achieve the goals above, according to an aspect of the invention, there is provided a kind of data for client end interface
Batch processing method.
Batch data processing method according to the present invention for client end interface includes:Determine target on client end interface
Attribute, wherein objective attribute target attribute is the attribute for the data being associated in client end interface;Receive multiple data filtering instructions, wherein
Multiple data filtering instructions are to be used to indicate the instruction of the garbled data from objective attribute target attribute associated data;Multiple data are received to repair
Change instruction, wherein the number that data modification instruction filters out data filtering instructions for instruction from the associated data of objective attribute target attribute
According to the instruction modified, and the instruction of multiple data modifications is corresponded with the instruction of multiple data filterings;Judge whether to receive
It is instructed to submitting, wherein submit instruction to instruct garbled data according to multiple data filterings and according to multiple data for executing
The instruction for the data that modification instruction modification filters out;And when judging to receive submission instruction, according to multiple data filterings
Instruction garbled data and the data filtered out according to multiple data modification instruction modifications from the associated data of objective attribute target attribute.
Further, it when judging to receive submission instruction, is associated with from objective attribute target attribute according to the instruction of multiple data filterings
Data in garbled data and the data that are filtered out according to multiple data modification instruction modifications include:Respectively according to multiple data mistakes
Each data filtering in filter instruction instructs the garbled data from objective attribute target attribute associated data, obtains multiple data acquisition systems;
Each data modification instruction in being instructed respectively according to multiple data modifications modifies to the data in multiple data acquisition systems,
Obtain modified data;And it will be in modified data update to database.
Further, each data filtering instruction in being instructed respectively according to multiple data filterings is associated with from objective attribute target attribute
Data in garbled data, after obtaining multiple data acquisition systems, this method further includes:Judge multiple data acquisition systems with the presence or absence of friendship
Collection;And if it is judged that multiple data acquisition systems there are intersections, then export the first prompt message, wherein the first prompt message is
For prompting multiple data acquisition systems, there are intersections.
Further, judging multiple data acquisition systems, there are intersections, and after exporting the first prompt message, this method is also wrapped
It includes:Receive selection instruction, wherein selection instruction is for selecting to there are the fingers of the modification mode of multiple data acquisition systems of intersection
It enables;The modification mode of selection is determined according to selection instruction;And multiple data acquisition systems are repaiied according to the modification mode of selection
Change.
Further, data modification instruction includes the instruction of the first data modification and the instruction of the second data modification, wherein first
Data modification instruction is phase for the data modification for corresponding data filtering instruction will be instructed to filter out with the first data modification
With the instruction of value, the instruction of the second data modification is for will data mistake corresponding with the instruction of the second data modification according to preset rules
The instruction that the data that filter instruction filters out are modified.
To achieve the goals above, according to another aspect of the present invention, a kind of data for client end interface are provided
Batch-processed devices.
Batch data processing unit according to the present invention for client end interface includes:First determination unit, for true
Determine objective attribute target attribute on client end interface, wherein objective attribute target attribute is the attribute for the data being associated in client end interface;First receives
Unit, for receiving multiple data filtering instructions, wherein multiple data filtering instructions are associated from objective attribute target attribute to be used to indicate
The instruction of garbled data in data;Second receiving unit, for receiving multiple data modification instructions, wherein data modification instructs
To indicate the instruction modified to the data that data filtering instructions are filtered out from the associated data of objective attribute target attribute, and it is multiple
Data modification is instructed to be corresponded with the instruction of multiple data filterings;First judging unit, for judging whether that receiving submission refers to
It enables, wherein submit instruction to instruct garbled data according to multiple data filterings for execution and being instructed according to multiple data modifications
Change the instruction of the data filtered out;And the first modification unit, for when judging to receive submission instruction, according to multiple
Data filtering instruction garbled data and is filtered out according to multiple data modification instruction modifications from objective attribute target attribute associated data
Data.
Further, the first modification unit includes:Screening module, for every in being instructed respectively according to multiple data filterings
One data filtering instructions garbled data from the associated data of objective attribute target attribute, obtains multiple data acquisition systems;Modified module is used for
Each data modification instruction in being instructed respectively according to multiple data modifications modifies to the data in multiple data acquisition systems,
Obtain modified data;And update module, being used for will be in modified data update to database.
Further, which further includes:Second judgment unit, for judging that multiple data acquisition systems whether there is intersection;
And output unit exports the first prompt message, wherein first carries for judging multiple data acquisition systems there are when intersection
Show that information is that there are intersections for prompting multiple data acquisition systems.
Further, which further includes:Third receiving unit, for receiving selection instruction, wherein selection instruction is to use
In selection to there are the instructions of the modification mode of multiple data acquisition systems of intersection;Second determination unit, for according to selection instruction
Determine the modification mode of selection;And the second modification unit, for being carried out to multiple data acquisition systems according to the modification mode of selection
Modification.
Further, data modification instruction includes the instruction of the first data modification and the instruction of the second data modification, wherein first
Data modification instruction is phase for the data modification for corresponding data filtering instruction will be instructed to filter out with the first data modification
With the instruction of value, the instruction of the second data modification is for will data mistake corresponding with the instruction of the second data modification according to preset rules
The instruction that the data that filter instruction filters out are modified.
Through the invention, using multiple data filtering instructions and the instruction of multiple data modifications are received simultaneously, judging to connect
When receiving submission instruction, according to multiple data filterings instruction garbled data and according to multiple numbers from the associated data of objective attribute target attribute
According to the data that modification instruction modification filters out, realizes and different data filter condition is sieved from the associated data of objective attribute target attribute simultaneously
The data selected carry out batch modification respectively, and operating efficiency is low when solving in the related technology to data progress batch modification asks
Topic, and then achieved the effect that improve the operating efficiency for carrying out data batch modification.
Specific implementation mode
It should be noted that in the absence of conflict, the features in the embodiments and the embodiments of the present application can phase
Mutually combination.The present invention will be described in detail below with reference to the accompanying drawings and embodiments.
In order to make those skilled in the art more fully understand application scheme, below in conjunction in the embodiment of the present application
Attached drawing, technical solutions in the embodiments of the present application are clearly and completely described, it is clear that described embodiment is only
The embodiment of the application part, instead of all the embodiments.Based on the embodiment in the application, ordinary skill people
The every other embodiment that member is obtained without making creative work should all belong to the model of the application protection
It encloses.
It should be noted that term " first " in the description and claims of this application 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 embodiments herein described herein.In addition, term " comprising " and " tool
Have " and their any deformation, it is intended that cover it is non-exclusive include, for example, containing series of steps or unit
Process, method, system, product or equipment those of are not necessarily limited to clearly to list step or unit, but may include without clear
It is listing to Chu or for these processes, method, product or equipment intrinsic other steps or unit.
According to embodiments of the present invention, a kind of batch data processing method for client end interface is provided, Fig. 1 is basis
The flow chart of the batch data processing method for client end interface of the embodiment of the present invention.
As shown in Figure 1, the batch data processing method for being used for client end interface includes following step S102 to step
S110:
Step S102:Determine objective attribute target attribute on client end interface, wherein objective attribute target attribute is to be associated in client end interface
The attribute of data.
Client end interface refers to the operation interface for being interacted with user, for example, the interfaces Excel, before database
Hold interface, web interface etc..Objective attribute target attribute can be the attribute that can be arbitrarily changed on client end interface, for example, being used for network
The client end interface of the data processing of popularization, on the client end interface comprising keyword, hits, show rate, keyword goes out
The attributes such as valence, the data correlation in each attribute background data base corresponding with client end interface.The objective attribute target attribute can be one
It is a, can also be multiple.
Step S104:Receive multiple data filtering instructions, wherein multiple data filtering instructions are to be used to indicate from target category
The instruction of garbled data in the associated data of property.
Include filter condition operator and filter condition operand in data filtering instruction, for example, being more than 1, is less than 2, packet
Containing a, etc., wherein be more than, be less than and comprising being filter condition operator, 1,2 and a is filter condition operand.Specifically
Ground, the embodiment of the present invention can show corresponding filter condition operator according to the type of the associated data of objective attribute target attribute, for example,
For the data of value type, filter condition operator include mainly be more than, be less than, being equal to, section etc., for character string type
Data, filter condition operator includes mainly comprising not including, beginning includes that ending includes to be contained in.Filter condition
Operand is usually inputted by user according to actual needs, for example, big when needing to change keyword bid in client end interface
When 1 yuan of data, filter condition operator can be selected to be more than and input by selecting keyword bid as objective attribute target attribute
Therefore filter condition operand 1 is instructed by data filtering and can be filtered out from the associated data of keyword bid more than 1
Keyword bid is more than 1 yuan of data.Optionally, a data filtering instructions can include multiple filter condition operators and mistake
Conditional operation number is filtered, for example, for keyword bid, first pair of filter condition operator and filter condition in data filtering instruction
Operand is more than 1 yuan, and second pair of filter condition operator and filter condition operand are that creation time is more than August 1 in 2014
Day, keyword bid can be filtered out simultaneously more than 1 yuan from the associated data of keyword bid by the instruction of above-mentioned data filtering
And creation time is more than the data on the 1st of August in 2014.
Step S106:Receive the instruction of multiple data modifications, wherein data modification instruction for instruction to data filtering instructions from
The instruction that the data filtered out in the associated data of objective attribute target attribute are modified, and the instruction of multiple data modifications and multiple data
Filtering instructions correspond.
Multiple data modification instructions are corresponded with above-mentioned multiple data filtering instructions, it is preferable that are repaiied to improve data
The flexibility changed, data modification instruction include the instruction of the first data modification and the instruction of the second data modification, wherein the first data are repaiied
It is identical value to change instruction as the data modification for corresponding data filtering instruction will be instructed to filter out with the first data modification
Instruction, data filtering corresponding with the instruction of the second data modification is for being instructed by the instruction of the second data modification according to preset rules
The instruction that the data filtered out are modified.
First data modification instruction instruction will instruct corresponding data filtering instruction to filter out with the first data modification
Data modification is the instruction of identical value, for example, big by keyword bid is filtered out in the above-mentioned associated data from keyword bid
It is 1.6 yuan to be revised as keyword bid in 1 yuan of data.The instruction of second data modification will be with the according to preset rules for instruction
The instruction that the data that two data modifications instruct the instruction of corresponding data filtering to filter out are modified, preset rules are used to indicate pair
Can be according to passing for example, for the data of value type according to the alteration ruler of data that data filtering instruction screening obtains
The rule such as increase, successively decrease to modify to data, can be according to substitute character, additional character for the data of character string type
It modifies to data Deng rule.Second data modification, which instructs, makes the mode of batch data modification more diversified, also more can
Meet the diversified batch data modification demand of user, increases the flexibility of batch data modification.
Step S108:Judge whether to receive submission instruction, wherein submit instruction for for executing according to multiple data mistakes
The instruction of filter instruction garbled data and the data filtered out according to multiple data modification instruction modifications.
Step S110:When judging to receive submission instruction, it is associated with from objective attribute target attribute according to the instruction of multiple data filterings
Data in garbled data and the data that are filtered out according to multiple data modification instruction modifications.
The embodiment of the present invention is instructed by receiving multiple data filtering instructions and multiple data modifications simultaneously, is judging to connect
When receiving submission instruction, according to multiple data filterings instruction garbled data and according to multiple numbers from the associated data of objective attribute target attribute
According to the data that modification instruction modification filters out, realizes and different data filter condition is sieved from the associated data of objective attribute target attribute simultaneously
The data selected carry out batch modification respectively, compared with the prior art in can only once change a data filtering condition and filter out
Data carry out batch modification, improve batch data modification operating efficiency, solve and data criticized in the related technology
Operating efficiency low problem when amount modification.
Optionally, it when judging to receive submission instruction, is instructed according to multiple data filterings associated from objective attribute target attribute
Garbled data and the data filtered out according to multiple data modification instruction modifications include in data:Respectively according to multiple data filterings
Each data filtering in instruction instructs the garbled data from objective attribute target attribute associated data, obtains multiple data acquisition systems;Point
Each data modification instruction in not instructed according to multiple data modifications modifies to the data in multiple data acquisition systems, obtains
To modified data;And it will be in modified data update to database.
Specifically, when judging to receive submission instruction, objective attribute target attribute can be established, multiple data filterings instruct, is more
The incidence relation of a data modification instruction, and the incidence relation is stored, for example, being stored in an operational set.According to multiple
Data filtering instruction garbled data and is filtered out according to multiple data modification instruction modifications from objective attribute target attribute associated data
It, can be with traversing operation set, according to each number in the multiple data filterings instruction stored in operational set in data procedures
According to filtering instructions from the objective attribute target attribute associated data stored in operational set garbled data, each data filtering can be referred to
Order is stored in from the data screened in the associated data of objective attribute target attribute in a data acquisition system, completes multiple data filterings
Instruction can obtain multiple data acquisition systems, refer to according to multiple data modifications after being screened in the associated data of objective attribute target attribute
Each data modification instruction in order modifies to the data in multiple data acquisition systems, obtains modified data, wherein
Data modification instruction only instructs the data acquisition system screened from the associated data of objective attribute target attribute to its corresponding data filtering
It modifies, after the data modification for completing data acquisition system, by modified data update to the corresponding number of client end interface
According in library.
Preferably, it is clashed when being changed in order to avoid batch data, it is every in being instructed respectively according to multiple data filterings
One data filtering instructions garbled data from the associated data of objective attribute target attribute, after obtaining multiple data acquisition systems, this method is also
Including:Judge that multiple data acquisition systems whether there is intersection;And if it is judged that multiple data acquisition systems there are intersections, then export
One prompt message, wherein the first prompt message is that there are intersections for prompting multiple data acquisition systems.
Specifically, due to having received multiple data filtering instructions number is screened from the associated data of the same objective attribute target attribute
According at this point, it is possible that there are identical data, i.e., multiple data sets in the data that different data filtering instructions filters out
Conjunction the case where there are intersections, for example, modifying for the associated data of above-mentioned keyword bid, including data filtering instruction 1
With data filtering instructions 2, wherein data filtering instruction 1 is big to screen keyword bid from the associated data of keyword bid
In 2 yuan of data, and data filtering instruction 2 for screened from the associated data of keyword bid keyword bid be more than 1 yuan and
Data less than 3 yuan, at this point, may comprising keyword bid be 2.5 yuan in data filtering instructs 1 data acquisition system that filters out
Data, and in 2 data acquisition systems that filter out of data filtering instruction also include the data that keyword bid is 2.5 yuan, therefore,
It needs the data for being 2.5 yuan to keyword bid to carry out 2 modifications, can be clashed when updating the data library.Therefore, in root respectively
Each data filtering in being instructed according to multiple data filterings instructs the garbled data from objective attribute target attribute associated data, obtains more
After a data acquisition system, judge that multiple data acquisition systems whether there is intersection, is judging multiple data acquisition systems there are when intersection, it is defeated
Go out prompt message, i.e. the first prompt message, there are intersections to prompt the multiple data acquisition systems of user, so as to believe according to the prompt
Breath accordingly changes data filtering instructions, to avoid data modification conflict occurs.
Preferably, in order to improve user experience, judging multiple data acquisition systems, there are intersections, export the first prompt message
Later, this method further includes:Receive selection instruction, wherein selection instruction is for selecting to there are multiple data sets of intersection
The instruction of the modification mode of conjunction;The modification mode of selection is determined according to selection instruction;And according to the modification mode of selection to more
A data acquisition system is modified.
Specifically, multiple modification modes can be preset, for example, judging that multiple data acquisition systems there are when intersection, also may be used
To abandon entirely changing operation, evidence can be more counted accurately with Last modification value to the data in the intersection of multiple data acquisition systems
Library can also be the modification of data, etc. only ignored in the intersection to multiple data acquisition systems.Judging multiple data acquisition systems
There are intersections, after exporting the first prompt message, export the interface for selecting modification mode for user, user can be according to reality
The corresponding modification mode of border demand selection.After receiving selection instruction input by user, searched according to the selection instruction corresponding
Data modification mode, and being modified to multiple data acquisition systems according to the modification mode of selection, and by modified obtained number
According in update to database.Since user can select the modification mode of data according to demand, user experience is improved.
Specifically, batch data modification operation is integrated in an operation interface by the embodiment of the present invention, you can to pass through
Multiple data filtering instructions and the instruction of multiple data modifications are received in the same operation interface and submit instruction, it is easy to operate straight
It sees.As shown in Fig. 2, in the operation interface, the objective attribute target attribute selected is bid, including two data filtering instructions, first
Data filtering instructs>1, data modification instruction corresponding with first data filtering instructions is 1.66, second data filtering
Instruction is<1 and creation time>2014-8-1, data modification instruction corresponding with second data filtering instructions is up-regulation
0.01 yuan, the confirming button of the operation interface is for submitting aforesaid operations, and 01 for indicating the revisable category of the client end interface
Property list, 02 indicate to bid corresponding filter operation accords with list, and 03 indicates the operation interface of the second data modification instruction.
It can be seen from the above description that the present invention realizes following technique effect:
The embodiment of the present invention is instructed by receiving multiple data filtering instructions and multiple data modifications simultaneously, is judging to connect
When receiving submission instruction, according to multiple data filterings instruction garbled data and according to multiple numbers from the associated data of objective attribute target attribute
According to the data that modification instruction modification filters out, realizes and different data filter condition is sieved from the associated data of objective attribute target attribute simultaneously
The data selected carry out batch modification respectively, compared with the prior art in can only once change a data filtering condition and filter out
Data carry out batch modification, improve batch data modification operating efficiency, solve and data criticized in the related technology
Operating efficiency low problem when amount modification.Further it is provided that a variety of data modification instructions modify to data, improves data and repair
The flexibility changed.
It should be noted that step shown in the flowchart of the accompanying drawings can be in such as a group of computer-executable instructions
It is executed in computer system, although also, logical order is shown in flow charts, and it in some cases, can be with not
The sequence being same as herein executes shown or described step.
Another aspect according to the ... of the embodiment of the present invention provides a kind of batch data processing dress for client end interface
Set, the batch data processing unit for being used for client end interface can be used for execute the embodiment of the present invention be used for client end interface
Batch data processing method, the batch data processing method for client end interface of the embodiment of the present invention can also pass through this
Inventive embodiments are executed for the batch data processing unit of client end interface.
As shown in figure 3, the batch data processing unit for being used for client end interface includes:First determination unit 10, first
Receiving unit 20, the second receiving unit 30, the first judging unit 40 and first change unit 50.
First determination unit 10, for determining objective attribute target attribute on client end interface, wherein objective attribute target attribute is to be associated with client
Hold the attribute of the data in interface.
Client end interface refers to the operation interface for being interacted with user, for example, the interfaces Excel, before database
Hold interface, web interface etc..Objective attribute target attribute can be the attribute that can be arbitrarily changed on client end interface, for example, being used for network
The client end interface of the data processing of popularization, on the client end interface comprising keyword, hits, show rate, keyword goes out
The attributes such as valence, the data correlation in each attribute background data base corresponding with client end interface.The objective attribute target attribute can be one
It is a, can also be multiple.
First receiving unit 20, for receiving multiple data filtering instructions, wherein multiple data filtering instructions is for referring to
Show the instruction of the garbled data from objective attribute target attribute associated data.
Include filter condition operator and filter condition operand in data filtering instruction, for example, being more than 1, is less than 2, packet
Containing a, etc., wherein be more than, be less than and comprising being filter condition operator, 1,2 and a is filter condition operand.It is optional
Ground, a data filtering instructions can include multiple filter condition operators and filter condition operand.
Second receiving unit 30, for receiving multiple data modification instructions, wherein data modification instruction is instruction to data
The instruction that the data that filtering instructions are filtered out from the associated data of objective attribute target attribute are modified, and multiple data modifications instruct
It instructs and corresponds with multiple data filterings.
Preferably, data modification instruction includes the instruction of the first data modification and the instruction of the second data modification, wherein the first number
It is instructed according to modification to be identical for the data modification that corresponding data filtering instruction filters out will to be instructed with the first data modification
The instruction of value, the instruction of the second data modification is for will data filtering corresponding with the instruction of the second data modification according to preset rules
The instruction for instructing the data filtered out to modify.
First data modification instruction instruction will instruct corresponding data filtering instruction to filter out with the first data modification
Data modification is the instruction of identical value.The instruction of second data modification will instruct for instruction according to preset rules with the second data modification
The instruction that the data that corresponding data filtering instruction filters out are modified, preset rules are used to indicate to being referred to according to data filtering
The alteration ruler of data for enabling screening obtain can be according to the rules such as being incremented by, successively decrease for example, for the data of value type
Modify to data, for the data of character string type, can be according to substitute character, additional character etc. rule to data into
Row modification.
First judging unit 40 receives submission instruction, wherein submit instruction for for executing basis for judging whether
The instruction of multiple data filtering instruction garbled datas and the data filtered out according to multiple data modification instruction modifications.
First modification unit 50, for when judging to receive submission instruction, being instructed from mesh according to multiple data filterings
Mark garbled data and the data filtered out according to multiple data modification instruction modifications in the data of Attribute Association.
The embodiment of the present invention determines objective attribute target attribute on client end interface, the first receiving unit by the first determination unit 10
20, for receiving multiple data filtering instructions, the second receiving unit 30, for receiving multiple data modification instructions, first judges
Unit 40 receives submission instruction, the first modification unit 50, for judging to receive submission instruction for judging whether
When, according to multiple data filterings instruction from objective attribute target attribute associated data garbled data and according to multiple data modifications instruction repair
Change the data filtered out.Realize the data point filtered out from the associated data of objective attribute target attribute to different data filter condition simultaneously
Do not carry out batch modification, compared with the prior art in can only once change the data that a data filtering condition filters out and criticized
Amount modification, improves the operating efficiency of batch data modification, solves in the related technology operation when to data progress batch modification
The low problem of efficiency.
Optionally, the first modification unit 50 includes:Screening module, for every in being instructed respectively according to multiple data filterings
One data filtering instructions garbled data from the associated data of objective attribute target attribute, obtains multiple data acquisition systems;Modified module is used for
Each data modification instruction in being instructed respectively according to multiple data modifications modifies to the data in multiple data acquisition systems,
Obtain modified data;And update module, being used for will be in modified data update to database.
Preferably, which further includes:Second judgment unit, for judging that multiple data acquisition systems whether there is intersection;With
And output unit exports the first prompt message for judging multiple data acquisition systems there are when intersection, wherein the first prompt
Information is that there are intersections for prompting multiple data acquisition systems.
Preferably, which further includes:Third receiving unit, for receiving selection instruction, wherein selection instruction be for
Selection is to there are the instructions of the modification mode of multiple data acquisition systems of intersection;Second determination unit, for true according to selection instruction
Determine the modification mode of selection;And second modification unit, for being repaiied to multiple data acquisition systems according to the modification mode of selection
Change.
Obviously, those skilled in the art should be understood that each module of the above invention or each step can be with general
Computing device realize that they can be concentrated on a single computing device, or be distributed in multiple computing devices and formed
Network on, optionally, they can be realized with the program code that computing device can perform, it is thus possible to which they are stored
Be performed by computing device in the storage device, either they are fabricated to each integrated circuit modules or by they
In multiple modules or step be fabricated to single integrated circuit module to realize.In this way, the present invention is not limited to any specific
Hardware and software combines.
The foregoing is only a preferred embodiment of the present invention, is not intended to restrict the invention, for the skill of this field
For art personnel, the invention may be variously modified and varied.All within the spirits and principles of the present invention, any made by repair
Change, equivalent replacement, improvement etc., should all be included in the protection scope of the present invention.