CN104239578B - The treating method and apparatus of tables of data - Google Patents
The treating method and apparatus of tables of data Download PDFInfo
- Publication number
- CN104239578B CN104239578B CN201410532720.2A CN201410532720A CN104239578B CN 104239578 B CN104239578 B CN 104239578B CN 201410532720 A CN201410532720 A CN 201410532720A CN 104239578 B CN104239578 B CN 104239578B
- Authority
- CN
- China
- Prior art keywords
- data
- tables
- filtration condition
- filter identification
- global filter
- 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
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/2457—Query processing with adaptation to user needs
- G06F16/24573—Query processing with adaptation to user needs using data annotations, e.g. user-defined metadata
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Library & Information 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)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind for the treatment of method and apparatus of tables of data.This method includes：Obtain the data row of tables of data；Detect the filtration condition of data row；The filtration condition arranged according to the data detected updates the data the global filter identification in table, wherein, global filter identification is provided with tables of data, global filter identification is used to represent whether tables of data is in filtration condition, global filter identification includes the first mark and the second mark, first identifies for representing that tables of data is in filtration condition, and second identifies and be not in filtration condition for mark data table；Global filter identification is shown in tables of data.By the present invention, solve the problems, such as whether tables of data intuitively display can not be in filtration condition in itself.
Description
Technical field
The present invention relates to data processing field, in particular to a kind for the treatment of method and apparatus of tables of data.
Background technology
In data processing field, when user needs to know target data information, it is necessary in tables of data in bulk information
Filter operation is carried out to data.For example, a student information table, record the family information of student, school grade situation and its
His some relevant informations., it is necessary to whole student information when user needs to know the information of student of the mathematics achievement less than 60 points
Information carries out filtration treatment in table, can just obtain the information of student of the mathematics achievement less than 60 points.
In the prior art, filter condition can be set to filter multiple data row in tables of data simultaneously.Work as user
When setting filter condition on multiple data row in tables of data, number of columns in tables of data is held when reaching to a certain degree
All data row can not disposably be shown by being easily caused, therefore whether tables of data intuitively display can not be in filtration condition in itself.From
And user easily ignores the tables of data for being currently at filtration condition, cause the data acquisition system for having handled mistake.
For tables of data in correlation technique can not intuitively whether display is in filtration condition in itself the problem of, not yet carry at present
Go out effective solution.
The content of the invention
, can not be straight to solve tables of data it is a primary object of the present invention to provide a kind for the treatment of method and apparatus of tables of data
The problem of whether display is in filtration condition in itself seen.
To achieve these goals, according to an aspect of the invention, there is provided a kind of processing method of tables of data.According to
The processing method of the tables of data of the present invention includes：Obtain the data row in tables of data；Detect the filtration condition of data row；According to inspection
The filtration condition of the data row measured updates the data the global filter identification in table, wherein, global mistake is provided with tables of data
Filter mark, global filter identification are used to represent whether tables of data be in filtration condition, global filter identification include the first mark with
Second mark, first identifies for representing that tables of data is in filtration condition, and second identifies and be not in filtering for mark data table
State；Global filter identification is shown in tables of data.
Further, the filtration condition arranged according to the data detected, which updates the data the global filter identification in table, to be included：
Obtain the filtration condition of data row and the mapping relations of global filter identification；The filtration condition that is arranged by the data that detect and reflect
Penetrate Relation acquisition and the corresponding global filter identification of filtration condition of the data row detected；The overall situation according to acquiring filters
Mark updates the data the global filter identification in table.
Further, the global filter identification updated the data according to the global filter identification acquired in table includes：It is logical
Cross total columns that data of the filtration condition statistics in filtration condition of the data row detected arrange；In the number in filtration condition
In the case of being 0 according to total columns of row, global filter identification is updated for the second mark；In the total of the data row in filtration condition
Columns is more than in the case of 0, updates global filter identification for the first mark.
Further, tables of data arranges including multiple data, and the filtration condition of detection data row is included to multiple data row
Filtration condition is detected successively, and the filtration condition arranged according to the data detected updates the data the global filter identification bag in table
Include：When the filtration condition arranged multiple data detects successively, judge whether to detect the data row in filtration condition；
If detecting the data row in filtration condition, global filter identification state is updated for the first mark.
Further, after global filter identification is shown in tables of data, this method also includes：Judge the global mistake of display
Filter mark is the first mark or the second mark；In the case where the global filter identification for judging display is the first mark, to clear
Except global filter identification performs operation, wherein, it is provided with tables of data and removes global filter identification, removes global filter identification
For all filter conditions in the table that clears data；After the filter condition for the table that clears data, second is shown in tables of data
Mark.
To achieve these goals, according to another aspect of the present invention, there is provided a kind of processing unit of tables of data.The dress
Put including：Acquiring unit, for obtaining the row of the data in tables of data；Detection unit, for detecting the filtration condition of data row；More
New unit, for updating the data the global filter identification in table according to the filtration condition of the data row detected, wherein, in data
Global filter identification is provided with table, global filter identification is used to represent whether tables of data is in filtration condition, overall situation filtering mark
Knowledge includes the first mark and the second mark, and first identifies for representing that tables of data is in filtration condition, and second identifies for identifying
Tables of data is not in filtration condition；Display unit, for showing global filter identification in tables of data.
Further, updating block includes：First acquisition module, for the filtration condition for obtaining data row and global filtering
The mapping relations of mark；Second acquisition module, the filtration condition and mapping relations that the data for detecting arrange obtain and detection
Global filter identification corresponding to the filtration condition of the data row arrived；First update module, for according to the global mistake acquired
Filter mark updates the data the global filter identification in table.
Further, updating block includes：Statistical module, the filtration condition statistics of the data row for detecting were in
Total columns of the data row of filter state；Second update module, the feelings that total columns for being arranged in the data in filtration condition is 0
Under condition, global filter identification is updated for the second mark；3rd update module, for total row in the data row in filtration condition
Number is more than in the case of 0, updates global filter identification for the first mark.
Further, tables of data arranges including multiple data, and the filtration condition of detection data row is included to multiple data row
Filtration condition is detected successively, and updating block includes：First judge module, for the filtration condition that multiple data arrange according to
It is secondary when being detected, judge whether to detect the data row in filtration condition；4th update module, if for detecting everywhere
Arranged in the data of filtration condition, update global filter identification state for the first mark.
Further, the device also includes：Second judge module, for judging that the global filter identification of display is the first mark
Know or second identifies；Processing module, in the case of being the first mark in the global filter identification for judging display, to removing
Global filter identification performs operation, wherein, it is provided with tables of data and removes global filter identification, is removed global filter identification and use
All filter conditions in the table that clears data；Display module, for after the filter condition for the table that clears data, in tables of data
The middle mark of display second.
By the present invention, using the method comprised the following steps：Obtain the data row of tables of data；Detect the filtering of data row
State；The filtration condition arranged according to the data detected updates the data the global filter identification in table, wherein, set in tables of data
Global filter identification is equipped with, global filter identification is used to represent whether tables of data is in filtration condition, and global filter identification includes
First mark and the second mark, first identifies for representing that tables of data is in filtration condition, and second identifies for mark data table
It is not in filtration condition；Global filter identification is shown in tables of data, solves whether tables of data intuitively can not be located in itself in display
In the filtration condition the problem of, realize whether database intuitively display can be in filtration condition in itself.
Brief description of the drawings
The accompanying drawing for forming the part of the application is used for providing a further understanding of the present invention, schematic reality of the invention
Apply example and its illustrate to be used to explain the present invention, do not form inappropriate limitation of the present invention.In the accompanying drawings：
Fig. 1 is the flow chart according to the first embodiment of the processing method of the tables of data of the present invention；
Fig. 2 is the schematic diagram according to the first embodiment of the processing unit of the tables of data of the present invention；
Fig. 3 is the schematic diagram according to the second embodiment of the processing unit of the tables of data of the present invention；
Fig. 4 is the schematic diagram according to the 3rd embodiment of the processing unit of the tables of data of the present invention；
Fig. 5 is the schematic diagram according to the fourth embodiment of the processing unit of the tables of data of the present invention；And
Fig. 6 is the schematic diagram according to the 5th embodiment of the processing unit of the tables of data of the present invention.
Embodiment
In order that those skilled in the art is better understood from the present invention program, below in conjunction with the embodiment of the present invention
Accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is only
The embodiment of a part of the invention, rather than whole embodiments.Based on the embodiment in the present invention, in ordinary skill
Personnel do not make the every other embodiment obtained under the premise of creative work, should all belong to the protection model of the present invention
Enclose.
It should be noted that term " first " in description and claims of this specification and above-mentioned accompanying drawing, "
Two " etc. be for distinguishing similar object, without for describing specific order or precedence.It should be appreciated that so use
Data can exchange in the appropriate case, so as to embodiments of the invention described herein can with except illustrating herein or
Order beyond those of description is implemented.In addition, term " comprising " and " having " and their any deformation, it is intended that cover
Cover non-exclusive include.
In the case where not conflicting, the feature in embodiment and embodiment in the application can be mutually combined.Below will
The present invention will be described in detail with reference to the accompanying drawings and embodiments.
Fig. 1 is the flow chart according to the first embodiment of the processing method of the tables of data of the present invention.As shown in figure 1, the party
Method includes steps S101 to step S104：
Step S101, obtain the data row in tables of data.
Obtaining the row of the data in tables of data can be the data row obtained in tables of data or obtain tables of data
In multiple data row.
For example, a student information data table, the tables of data stores the correlation such as family information, school grade situation of student
Information.It is as shown in table 1 below：
Table 1
In this step, it can obtain multiple data row to obtain the data row in tables of data, and the plurality of data row are to use
Arranged in the multiple data for representing different attribute in tables of data.By taking table 1 as an example, obtain table 1 in student name, sex, nationality and
The data such as mathematics achievement arrange.
Step S102, the filtration condition of detection data row.
Detect the filtration condition of data row, can be detect in tables of data the filtration condition of data row or
Detect the filtration condition of multiple data row in tables of data.
The one or more data got in tables of data are arranged, filtering can be pre-set to one or more data row
Condition, one or more data are arranged and perform filter operation, the filtering shape of detection data row according to the filter condition pre-set
State.Wherein, the filtration condition of one or more data row has 2 kinds, is to be in filtration condition and be not in filtration condition respectively.
Illustrated by taking table 1 as an example, the filter condition set to table 1 is less than 70 points of student information for data achievement, right
Data row in table 1 are filtered.Text information is arranged to runic for representing data row in filtering shape during data are arranged
State, it is as shown in the table：
Table 2
In this step, the filtration condition of multiple data row in tables of data, the filtering shape of the plurality of data row can be detected
State has 2 kinds, is to be in filtration condition and be not in filtration condition respectively.As shown in table 2, by detecting multiple data in tables of data
Whether the word of row is runic, you can the filtration condition for judging data row is in filtration condition or is not in filtration condition.
The data row for detecting mathematics achievement by this method are in filtration condition.
It should be noted that arbitrary form can be arranged to the data row in filtration condition, the form can be passed through
Intuitively judge that data row are in filtration condition, for example, text color is arranged to red use in can arranging data
Filtration condition is in representing that data arrange.
Step S103, the filtration condition arranged according to the data detected update the data the global filter identification in table.
The filtration condition of the one or more data row detected can be in filtration condition and be not in filtration condition.
According to the one or more data arrange in filtration condition and be not in filtration condition and update the data global filtering mark in table
Know.Global filter identification is provided with tables of data, global filter identification is used to represent whether tables of data is in filtration condition, entirely
Office's filter identification includes the first mark and the second mark, and first identifies for representing that tables of data is in filtration condition, the second mark
For representing that tables of data is not in filtration condition.
Specifically, by obtaining the filtration condition of data row and the mapping relations of global filter identification, pass through what is detected
The filtration condition and mapping relations of data row, the corresponding global filter identification of filtration condition of the data row with detecting is obtained,
The global filter identification in table is updated the data by the global filter identification acquired.
The filtration condition arranged according to the data detected in table 1 updates the data the global filter identification in table, such as following table
It is shown：
Table 4
In this step, the filtration condition of the one or more data row detected can be in filtration condition and not locate
In filtration condition.According to data arrange in filtration condition and be not in filtration condition and update the data global filtering mark in table
Know.As shown in table 4, the data row of Chinese Achievement Test are in filtration condition.Filtration condition pair is according to the data of Chinese Achievement Test row
The global filter identification answered updates the data the global filter identification in table.
Preferably, in order to lift the renewal speed of the global filter identification in tables of data, provided in an embodiment of the present invention
In the processing method of tables of data, the filtration condition arranged according to the data detected updates the data the global filter identification bag in table
Include：Total columns that data of the filtration condition statistics in filtration condition arranged by the data detected arrange；In filtering shape
In the case that total columns of the data row of state is 0, global filter identification is updated for the second mark；In the data in filtration condition
Total columns of row is more than in the case of 0, updates global filter identification for the first mark.
The total columns arranged by counting the data in filtration condition, quickly updates global filtering by the situation of total columns
Mark, improves the renewal speed of the global filter identification in tables of data, ensure that and global filter identification is upgraded in time.
Preferably, in order to preferably lift the renewal speed of the global filter identification in tables of data, in the embodiment of the present invention
In the processing method of the tables of data of offer, the filtration condition arranged according to the data detected updates the data the global filtering mark in table
Knowledge includes：When the filtration condition for arranging multiple data detects successively, judge whether to detect the number in filtration condition
According to row；If detecting the data row in filtration condition, global filter identification state is updated for the first mark.
By detect successively data arrange filtration condition, if detect data row be in filtration condition, immediately more
New global filter identification, preferably improve the renewal speed of the global filter identification in tables of data.It ensure that and the overall situation is filtered
Mark upgrades in time.
Preferably, in order to lift the processing speed of removing filter condition, at the place of tables of data provided in an embodiment of the present invention
In reason method, this method also includes：The global filter identification for judging display is the first mark or the second mark；Judging to show
Global filter identification be the first mark in the case of, perform operation to removing global filter identification, wherein, set in tables of data
It is equipped with and removes global filter identification, removes global filter identification for all filter conditions in the table that clears data；Removing number
After the filter condition of table, the second mark is shown in tables of data.
In the case where judging tables of data processing filtration condition, operation is performed to removing global filter identification, is realized
Clear data all filter conditions in table, improves the processing speed for removing filter condition.
Step S104, global filter identification is shown in tables of data.
The processing method of tables of data provided in an embodiment of the present invention, arranged by obtaining the data in tables of data；Detect data
The filtration condition of row；The filtration condition arranged according to the data detected updates the data the global filter identification in table；In tables of data
The middle global filter identification of display, solves the problems, such as whether tables of data intuitively display can not be in filtration condition in itself, realizes
Whether database intuitively display can be in filtration condition in itself.
It should be noted that can be in such as one group of computer executable instructions the flow of accompanying drawing illustrates the step of
Performed in computer system, although also, show logical order in flow charts, in some cases, can be with not
The order being same as herein performs shown or described step.
The embodiment of the present invention additionally provides a kind of processing unit of tables of data, it is necessary to illustrate, the embodiment of the present invention
The processing unit of tables of data can be used for the processing method for performing the tables of data that the embodiment of the present invention is provided.Below to the present invention
The processing unit for the tables of data that embodiment provides is introduced：
Fig. 2 is the schematic diagram according to the first embodiment of the processing unit of the tables of data of the present invention.As shown in Fig. 2 the dress
Put including：Acquiring unit 10, detection unit 20, updating block 30 and display unit 40.
Acquiring unit 10, for obtaining the row of the data in tables of data.
Detection unit 20, for detecting the filtration condition of data row.
Updating block 30, for updating the data the global filtering mark in table according to the filtration condition of the data row detected
Know, wherein, global filter identification is provided with tables of data, global filter identification is used to represent tables of data whether in filtering shape
State, global filter identification include the first mark and the second mark, and first identifies for representing that tables of data is in filtration condition, and second
Identify and be not in filtration condition for mark data table.
Display unit 40, for showing global filter identification in tables of data.
The processing unit of tables of data provided in an embodiment of the present invention, the data in tables of data are obtained by acquiring unit 10
Row.Detection unit 20 detects the filtration condition of data row.The filtration condition that updating block 30 arranges according to the data detected updates
Global filter identification in tables of data, wherein, global filter identification is provided with tables of data, global filter identification represents data
Whether table is in filtration condition, and global filter identification includes the first mark and the second mark, and the first mark represents that tables of data is in
Filtration condition, the second mark represent that tables of data is not in filtration condition.Display unit 40 shows global filtering mark in tables of data
Know, solve the problems, such as whether tables of data intuitively display can not be in filtration condition in itself, realizing database can intuitively show
Show whether itself is in filtration condition.
Fig. 3 is the schematic diagram according to the second embodiment of the processing unit of the tables of data of the present invention.The embodiment can be made
For a kind of preferred embodiment of embodiment illustrated in fig. 2, as shown in figure 3, the device includes：Acquiring unit 10, detection unit 20,
Updating block 30 and display unit 40.Wherein, updating block 30 also includes：First acquisition module 301, the second acquisition module 302
With the first update module 303.
Acquiring unit 10, detection unit 20, act in the effect of updating block 30 and display unit 40 and above-described embodiment
It is identical, it will not be repeated here.
First acquisition module 301, for obtaining the filtration condition of data row and the mapping relations of global filter identification.
Second acquisition module 302, what the filtration condition and mapping relations that the data for detecting arrange were obtained and detected
Global filter identification corresponding to the filtration condition of data row.
First update module 303, for updating the data the global filtering in table according to the global filter identification acquired
Mark.
Fig. 4 is the schematic diagram according to the second embodiment of the processing unit of the tables of data of the present invention.The embodiment can be made
For a kind of preferred embodiment of embodiment illustrated in fig. 2, as shown in figure 4, the device includes：Acquiring unit 10, detection unit 20,
Updating block 30 and display unit 40.Wherein, updating block 30 also includes：Statistical module 304, the second update module 305 and
Three update modules 306.
Acquiring unit 10, detection unit 20, act in the effect of updating block 30 and display unit 40 and above-described embodiment
It is identical, it will not be repeated here.
Statistical module 304, the filtration condition statistics of the data row for detecting are in the total of the data row of filtration condition
Columns.
Second update module 305, in the case of being 0 in total columns of the data row in filtration condition, renewal is complete
Office's filter identification is the second mark.
3rd update module 306, in the case of being more than 0 in total columns of the data row in filtration condition, more
New global filter identification is the first mark.
Fig. 5 is the schematic diagram according to the second embodiment of the processing unit of the tables of data of the present invention.The embodiment can be made
For a kind of preferred embodiment of embodiment illustrated in fig. 2, as shown in figure 5, the device includes：Acquiring unit 10, detection unit 20,
Updating block 30 and display unit 40.Wherein, updating block 30 also includes：First judge module 307 and the 4th update module
308。
Acquiring unit 10, detection unit 20, act in the effect of updating block 30 and display unit 40 and above-described embodiment
It is identical, it will not be repeated here.
First judge module 307, during for detecting successively in the filtration condition for arranging multiple data, judge whether to examine
The data in filtration condition are measured to arrange.
4th update module 308, if for detecting the data row in filtration condition, update global filter identification shape
State is the first mark.
Fig. 6 is the schematic diagram according to the second embodiment of the processing unit of the tables of data of the present invention.The embodiment can be made
For a kind of preferred embodiment of embodiment illustrated in fig. 2, as shown in fig. 6, the device includes：Acquiring unit 10, detection unit 20,
Updating block 30, display unit 40, the second judge module 50, processing module 60 and display module 70.
Acquiring unit 10, detection unit 20, act in the effect of updating block 30 and display unit 40 and above-described embodiment
It is identical, it will not be repeated here.
Second judge module 50, the global filter identification for judging display are the first mark or the second mark.
Processing module 60 is complete to removing in the case of being the first mark in the global filter identification for judging display
Office's filter identification performs operation, wherein, it is provided with tables of data and removes global filter identification, is removed global filter identification and be used for
All filter conditions to clear data in table.
Display module 70, for after the filter condition for the table that clears data, the second mark to be shown in tables of data.
Obviously, those skilled in the art should be understood that above-mentioned each module of the invention or each step can be with general
Computing device realize that they can be concentrated on single computing device, or be distributed in multiple computing devices and formed
Network on, alternatively, they can be realized with the program code that computing device can perform, it is thus possible to they are stored
Performed in the storage device by computing device, either they are fabricated to respectively each integrated circuit modules or by they
In multiple modules or step be fabricated to single integrated circuit module to realize.So, the present invention is not restricted to any specific
Hardware and software combines.
The preferred embodiments of the present invention are the foregoing is only, are not intended to limit the invention, for the skill of this area
For art personnel, the present invention can have various modifications and variations.Within the spirit and principles of the invention, that is made any repaiies
Change, equivalent substitution, improvement etc., should be included in the scope of the protection.
Claims (8)
- A kind of 1. processing method of tables of data, it is characterised in that including：Obtain the data row in tables of data；Detect the filtration condition of the data row；The filtration condition arranged according to the data detected updates the global filter identification in the tables of data, wherein, in institute State and the global filter identification is provided with tables of data, the global filter identification is used to represent whether the tables of data was in Filter state, the global filter identification include the first mark and the second mark, and described first identifies for representing the tables of data In filtration condition, described second identifies and is not in filtration condition for identifying the tables of data；AndThe global filter identification is shown in the tables of data,Wherein, the global filter identification that the filtration condition arranged according to the data detected is updated in the tables of data includes： Obtain the filtration condition of the data row and the mapping relations of the global filter identification；Arranged by the data detected Filtration condition and the mapping relations obtain the corresponding global filter identification of the filtration condition arranged with the data detected；With And the global filter identification in the tables of data is updated according to the global filter identification acquired.
- 2. according to the method for claim 1, it is characterised in that the number is updated according to the global filter identification acquired Include according to the global filter identification in table：Total columns that data of the filtration condition statistics in filtration condition arranged by the data detected arrange；In the case where total columns of the data row in filtration condition is 0, it is described second to update the global filter identification Mark；AndIn the case of total columns of the data row in filtration condition is more than 0, it is described to update the global filter identification First mark.
- 3. according to the method for claim 1, it is characterised in that the tables of data arranges including multiple data, detects the number Include detecting the filtration condition of the multiple data row successively according to the filtration condition of row, according to the data detected The global filter identification that the filtration condition of row is updated in the tables of data includes：When the filtration condition for arranging the multiple data detects successively, judge whether to detect the number in filtration condition According to row；AndIf detecting the data row in filtration condition, the global filter identification state is updated for the described first mark.
- 4. according to the method for claim 1, it is characterised in that shown in the tables of data the global filter identification it Afterwards, methods described also includes：The global filter identification for judging display is first mark or second mark；In the case where the global filter identification for judging display is first mark, held to removing global filter identification Row operation, wherein, the global filter identification of removing is provided with the tables of data, the global filter identification of removing is used for Remove all filter conditions in the tables of data；AndAfter the filter condition of the tables of data is removed, second mark is shown in the tables of data.
- A kind of 5. processing unit of tables of data, it is characterised in that including：Acquiring unit, for obtaining the row of the data in tables of data；Detection unit, for detecting the filtration condition of the data row；Updating block, for updating the global filtering mark in the tables of data according to the filtration condition of the data row detected Know, wherein, the global filter identification is provided with the tables of data, the global filter identification is used to represent the data Whether table is in filtration condition, and the global filter identification includes the first mark and the second mark, and described first identifies for table Show that the tables of data is in filtration condition, described second identifies and be not in filtration condition for identifying the tables of data；AndDisplay unit, for showing the global filter identification in the tables of data,Wherein, the updating block includes：First acquisition module, for the filtration condition for obtaining the data row and the overall situation The mapping relations of filter identification；Second acquisition module, the filtration condition and the mapping that the data for detecting arrange close The corresponding global filter identification of system obtains with the data that detect arrange filtration condition；And first update module, it is used for Global filter identification in the tables of data is updated according to the global filter identification acquired.
- 6. device according to claim 5, it is characterised in that the updating block includes：Statistical module, the filtration condition statistics of the data row for detecting are in total row that the data of filtration condition arrange Number；Second update module, in the case of being 0 in total columns of the data row in filtration condition, update the global mistake Filter is identified as second mark；And3rd update module, in the case of being more than 0 in total columns of the data row in filtration condition, update described complete Office's filter identification is the described first mark.
- 7. device according to claim 5, it is characterised in that the tables of data arranges including multiple data, detects the number Include detecting the filtration condition of the multiple data row successively according to the filtration condition of row, the updating block includes：First judge module, during for detecting successively in the filtration condition for arranging the multiple data, judge whether to detect To the data row in filtration condition；And4th update module, if for detecting the data row in filtration condition, update the global filter identification state For the described first mark.
- 8. device according to claim 5, it is characterised in that described device also includes：Second judge module, the global filter identification for judging display are first mark or second mark；Processing module, in the case of being first mark in the global filter identification for judging display, to removing Global filter identification performs operation, wherein, the global filter identification of removing is provided with the tables of data, it is described to remove entirely Office's filter identification is used to remove all filter conditions in the tables of data；AndDisplay module, for after the filter condition of the tables of data is removed, showing second mark in the tables of data Know.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410532720.2A CN104239578B (en) | 2014-10-10 | 2014-10-10 | The treating method and apparatus of tables of data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410532720.2A CN104239578B (en) | 2014-10-10 | 2014-10-10 | The treating method and apparatus of tables of data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104239578A CN104239578A (en) | 2014-12-24 |
| CN104239578B true CN104239578B (en) | 2017-11-14 |
Family
ID=52227637
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410532720.2A Active CN104239578B (en) | 2014-10-10 | 2014-10-10 | The treating method and apparatus of tables of data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104239578B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2005260345A (en) * | 2004-03-09 | 2005-09-22 | Nippon Telegr & Teleph Corp <Ntt> | Authentication cooperative distribution firewall system compatible with mobile information communication , firewall apparatus, security policy management server, and authentication server |
| CN101320388A (en) * | 2008-07-18 | 2008-12-10 | 金蝶软件（中国）有限公司 | Method and apparatus for filtering documents according to documents state |
| CN103064823A (en) * | 2012-12-25 | 2013-04-24 | 北京易时信通科技有限公司 | Method and system for processing data |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8566569B2 (en) * | 2010-06-24 | 2013-10-22 | International Business Machines Corporation | State machine-based filtering of pattern history tables based on distinguishable pattern detection |
-
2014
- 2014-10-10 CN CN201410532720.2A patent/CN104239578B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2005260345A (en) * | 2004-03-09 | 2005-09-22 | Nippon Telegr & Teleph Corp <Ntt> | Authentication cooperative distribution firewall system compatible with mobile information communication , firewall apparatus, security policy management server, and authentication server |
| CN101320388A (en) * | 2008-07-18 | 2008-12-10 | 金蝶软件（中国）有限公司 | Method and apparatus for filtering documents according to documents state |
| CN103064823A (en) * | 2012-12-25 | 2013-04-24 | 北京易时信通科技有限公司 | Method and system for processing data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104239578A (en) | 2014-12-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110381369A (en) | Determination method, apparatus, equipment and the storage medium of recommendation information implantation position | |
| US20240020635A1 (en) | Information processing apparatus, information processing system, control method, and program | |
| CN104572735B (en) | A kind of picture mark words recommending method and device | |
| CN109284784A (en) | A kind of content auditing model training method and device for live scene video | |
| CN107704625A (en) | Fields match method and apparatus | |
| CN105117464B (en) | Application pushing method and device and service equipment | |
| CN107992595A (en) | A kind of learning Content recommends method, apparatus and smart machine | |
| CN104809751B (en) | The method and apparatus for generating event group evolution diagram | |
| CN106372977B (en) | A kind of processing method and equipment of virtual account | |
| CN105956079B (en) | Test question searching method and device applied to electronic terminal | |
| CN106650570A (en) | Article finding method and terminal | |
| CN106934741A (en) | The method and device of the construction of curriculum | |
| CN110223202A (en) | A kind of method and system of teaching stage property identification and scoring | |
| CN110287767A (en) | Can attack protection biopsy method, device, computer equipment and storage medium | |
| CN106503740B (en) | Picture classification method and device | |
| CN102866885A (en) | Method and device for confirming clicking position in webpage | |
| CN103810241B (en) | Filter method and device that a kind of low frequency is clicked on | |
| CN104462322B (en) | Character string comparison method and device | |
| CN104239578B (en) | The treating method and apparatus of tables of data | |
| CN106294106B (en) | The test method and device of Web application system | |
| CN109634460A (en) | A kind of touch control identification method based on region mirror image, device and touch control display apparatus | |
| CN116842910A (en) | Service data display method, device, equipment and storage medium | |
| CN109597744A (en) | Data unusual fluctuation analysis method and device | |
| CN107424461B (en) | Information screen method and system | |
| CN211454663U (en) | Skin allergy determination system |
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 | ||
| PE01 | Entry into force of the registration of the contract for pledge of patent right |
Denomination of invention: Data table processing method and device Effective date of registration: 20190531 Granted publication date: 20171114 Pledgee: Shenzhen Black Horse World Investment Consulting Co., Ltd. Pledgor: Beijing Guoshuang Technology Co.,Ltd. Registration number: 2019990000503 |
|
| PE01 | Entry into force of the registration of the contract for pledge of patent right | ||
| CP02 | Change in the address of a patent holder |
Address after: 100083 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Patentee after: Beijing Guoshuang Technology Co.,Ltd. Address before: 100086 Beijing city Haidian District Shuangyushu Area No. 76 Zhichun Road cuigongfandian 8 layer A Patentee before: Beijing Guoshuang Technology Co.,Ltd. |
|
| CP02 | Change in the address of a patent holder |