CN104239578A - Data table processing method and device - Google Patents
Data table processing method and device Download PDFInfo
- Publication number
- CN104239578A CN104239578A CN201410532720.2A CN201410532720A CN104239578A CN 104239578 A CN104239578 A CN 104239578A CN 201410532720 A CN201410532720 A CN 201410532720A CN 104239578 A CN104239578 A CN 104239578A
- Authority
- CN
- China
- Prior art keywords
- data
- filtration condition
- tables
- filter identification
- overall 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.)
- Granted
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
Abstract
The invention discloses a data table processing method and device. The method includes the steps of obtaining data columns of a data table; detecting the filtering state of the data columns; renewing overall filtering identification in the data table according to the detected filtering state of the data columns, wherein the overall filtering identification is arranged in the data table and used for representing whether the data table is in the filtering state or not, and comprises a first identification body and a second identification body, the first identification body is used for representing that the data table is in the filtering state, and the second identification body is used for representing that the data table is not in the filtering state; displaying the overall filtering identification in the data table. By means of the data table processing method and device, the problem that whether the data table is in the filtering state or not can not be visually displayed is solved.
Description
Technical field
The present invention relates to data processing field, in particular to a kind of disposal route and device of tables of data.
Background technology
In data processing field, when user needs to know target data information, need to carry out filter operation to data in bulk information in tables of data.Such as, a student information table, family information, school grade situation and some other relevant information of record student.When user needs to know the information of mathematics achievement lower than the student of 60 points, need to carry out filtration treatment to information in whole student information table, just can obtain the information of mathematics achievement lower than the student of 60 points.
In the prior art, filtercondition can be arranged to data rows multiple in tables of data to filter simultaneously.When user, in tables of data, multiple data rows arranges filtercondition time, easily causing during the acquiring a certain degree of the number of columns in tables of data cannot all data rows of disposable display, and therefore whether tables of data intuitively display itself can not be in filtration condition.Thus user easily ignores the current tables of data being in filtration condition, cause having processed wrong data acquisition.
Intuitively display itself whether can not be in the problem of filtration condition for tables of data in correlation technique, not yet propose effective solution at present.
Summary of the invention
Fundamental purpose of the present invention is the disposal route and the device that provide a kind of tables of data, intuitively display itself whether can not be in the problem of filtration condition to solve tables of data.
To achieve these goals, according to an aspect of the present invention, a kind of disposal route of tables of data is provided.Disposal route according to tables of data of the present invention comprises: obtain the data rows in tables of data; Detect the filtration condition of data rows; According to the overall filter identification in the filtration condition updated data table of the data rows detected, wherein, overall filter identification is provided with in tables of data, overall situation filter identification is for representing whether tables of data is in filtration condition, overall situation filter identification comprises the first mark and the second mark, first mark is for representing that tables of data is in filtration condition, and the second mark is used for identification data table and is not in filtration condition; Overall filter identification is shown in tables of data.
Further, comprise according to the overall filter identification in the filtration condition updated data table of the data rows detected: obtain the filtration condition of data rows and the mapping relations of overall filter identification; The overall filter identification corresponding with the filtration condition of the data rows detected is obtained by the filtration condition of data rows that detects and mapping relations; According to the overall filter identification in the overall filter identification updated data table acquired.
Further, comprise according to the overall filter identification in the overall filter identification updated data table acquired: the total columns being in the data rows of filtration condition by the filtration condition statistics of the data rows detected; When total columns of the data rows being in filtration condition is 0, upgrading overall filter identification is the second mark; When total columns of the data rows being in filtration condition is greater than 0, upgrading overall filter identification is the first mark.
Further, tables of data comprises multiple data rows, detect the filtration condition of data rows to comprise and detecting successively the filtration condition of multiple data rows, comprising according to the overall filter identification in the filtration condition updated data table of the data rows detected: when detecting successively the filtration condition of multiple data rows, judging whether to detect the data rows being in filtration condition; If the data rows being in filtration condition detected, upgrading overall filter identification state is the first mark.
Further, show overall filter identification in tables of data after, the method also comprises: judge that the overall filter identification of display is the first mark or the second mark; When the overall filter identification judging to show is the first mark, to the overall filter identification executable operations of removing, wherein, is provided with in tables of data and removes overall filter identification, removing all filterconditions of overall filter identification for clearing data in table; After the filtercondition of table that clears data, in tables of data, show the second mark.
To achieve these goals, according to a further aspect in the invention, a kind for the treatment of apparatus of tables of data is provided.This device comprises: acquiring unit, for obtaining the data rows in tables of data; Detecting unit, for detecting the filtration condition of data rows; Updating block, for according to the overall filter identification in the filtration condition updated data table of data rows detected, wherein, overall filter identification is provided with in tables of data, overall situation filter identification is for representing whether tables of data is in filtration condition, overall situation filter identification comprises the first mark and the second mark, and the first mark is for representing that tables of data is in filtration condition, and the second mark is used for identification data table and is not in filtration condition; Display unit, for showing overall filter identification in tables of data.
Further, updating block comprises: the first acquisition module, for the mapping relations of the filtration condition and overall filter identification that obtain data rows; Second acquisition module, obtains the overall filter identification corresponding with the filtration condition of the data rows detected for the filtration condition of data rows that detects and mapping relations; First update module, for the overall filter identification in the overall filter identification updated data table that basis acquires.
Further, updating block comprises: statistical module, and the filtration condition statistics for the data rows detected is in total columns of the data rows of filtration condition; Second update module, for when total columns of the data rows being in filtration condition is 0, upgrading overall filter identification is the second mark; 3rd update module, during for being greater than 0 at total columns of the data rows being in filtration condition, upgrading overall filter identification is the first mark.
Further, tables of data comprises multiple data rows, detect the filtration condition of data rows to comprise and detecting successively the filtration condition of multiple data rows, updating block comprises: the first judge module, for when detecting successively the filtration condition of multiple data rows, judge whether to detect the data rows being in filtration condition; 4th update module, if for the data rows being in filtration condition being detected, upgrading overall filter identification state is the first mark.
Further, this device also comprises: the second judge module, for judging that the overall filter identification shown is the first mark or the second mark; Processing module, for when the overall filter identification judging to show is the first mark, to the overall filter identification executable operations of removing, wherein, being provided with in tables of data and removing overall filter identification, removing all filterconditions of overall filter identification for clearing data in table; Display module, for after the filtercondition of table that clears data, shows the second mark in tables of data.
By the present invention, adopt the method comprised the following steps: the data rows obtaining tables of data; Detect the filtration condition of data rows; According to the overall filter identification in the filtration condition updated data table of the data rows detected, wherein, overall filter identification is provided with in tables of data, overall situation filter identification is for representing whether tables of data is in filtration condition, overall situation filter identification comprises the first mark and the second mark, first mark is for representing that tables of data is in filtration condition, and the second mark is used for identification data table and is not in filtration condition; In tables of data, show overall filter identification, solve tables of data and intuitively display itself whether can not be in the problem of filtration condition, achieve database and intuitively display itself whether can be in filtration condition.
Accompanying drawing explanation
The accompanying drawing forming a application's part is used to provide a further understanding of the present invention, and schematic description and description of the present invention, for explaining the present invention, does not form inappropriate limitation of the present invention.In the accompanying drawings:
Fig. 1 is the process flow diagram of the first embodiment of disposal route according to tables of data of the present invention;
Fig. 2 is the schematic diagram of the first embodiment for the treatment of apparatus according to tables of data of the present invention;
Fig. 3 is the schematic diagram of the second embodiment for the treatment of apparatus according to tables of data of the present invention;
Fig. 4 is the schematic diagram of the 3rd embodiment for the treatment of apparatus according to tables of data of the present invention;
Fig. 5 is the schematic diagram of the 4th embodiment for the treatment of apparatus according to tables of data of the present invention; And
Fig. 6 is the schematic diagram of the 5th embodiment for the treatment of apparatus according to tables of data of the present invention.
Embodiment
Better the present invention program is understood in order to make those skilled in the art, below in conjunction with the accompanying drawing in the embodiment of the present invention, technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the embodiment of a part of the present invention, instead of whole embodiments.Based on the embodiment in the present invention, the every other embodiment obtained under those of ordinary skill in the art do not make creative work prerequisite, all should belong to protection scope of the present invention.
It should be noted that, term " first ", " second " etc. in instructions of the present invention and claims and above-mentioned accompanying drawing are for distinguishing similar object, and need not be used for describing specific order or precedence.Should be appreciated that the data used like this can be exchanged in the appropriate case, so as embodiments of the invention described herein can with except here diagram or describe those except order implement.In addition, term " comprises " and " having " and their any distortion, and intention is to cover not exclusive comprising.
When not conflicting, the embodiment in the application and the feature in embodiment can combine mutually.Below with reference to the accompanying drawings and describe the present invention in detail in conjunction with the embodiments.
Fig. 1 is the process flow diagram of the first embodiment of disposal route according to tables of data of the present invention.As shown in Figure 1, the method comprises following step S101 to step S104:
Step S101, obtains the data rows in tables of data.
The data rows obtained in tables of data can be obtain a data rows in tables of data, also can be obtain the multiple data rows in tables of data.
Such as, a student information data table, this tables of data stores the family information of student, the relevant informations such as school grade situation.As shown in table 1 below:
Table 1
In this step, the data rows obtained in tables of data can be obtain multiple data rows, and the plurality of data rows is the multiple data rows for representing different attribute in tables of data.For table 1, obtain the student name in table 1, the data rows such as sex, nationality and mathematics achievement.
Step S102, detects the filtration condition of data rows.
Detecting the filtration condition of data rows, can be the filtration condition detecting a data rows in tables of data, also can be the filtration condition detecting multiple data rows in tables of data.
To the one or more data rows got in tables of data, can filtercondition be pre-set to one or more data rows, according to the filtercondition pre-set, filter operation is performed to one or more data rows, detect the filtration condition of data rows.Wherein, the filtration condition of one or more data rows has 2 kinds, is be in filtration condition and be not in filtration condition respectively.
Be described for table 1, the filtercondition that his-and-hers watches 1 are arranged is data achievement lower than the student information of 70 points, and the data rows in his-and-hers watches 1 is filtered.Word message in data rows is arranged to runic be used for representing that this data rows is in filtration condition, as shown in the table:
Table 2
In this step, can detect the filtration condition of multiple data rows in tables of data, the filtration condition of the plurality of data rows has 2 kinds, is be in filtration condition and be not in filtration condition respectively.As shown in table 2, by detecting whether the word of multiple data rows in tables of data is runic, can judge that the filtration condition of this data rows is as being in filtration condition or not being in filtration condition.Detect that the data rows of mathematics achievement is in filtration condition by the method.
It should be noted that, arbitrary form can be set to the data rows being in filtration condition, can judging that this data rows is in filtration condition by this formal intuition, such as, can being arranged to text color in data rows red for representing that data rows is in filtration condition.
Step S103, according to the overall filter identification in the filtration condition updated data table of the data rows detected.
The filtration condition of the one or more data rows detected can for being in filtration condition and not being in filtration condition.Being in filtration condition and not being in the overall filter identification in filtration condition updated data table according to this one or more data rows.Overall filter identification is provided with in tables of data, overall situation filter identification is for representing whether tables of data is in filtration condition, overall situation filter identification comprises the first mark and the second mark, first mark is for representing that tables of data is in filtration condition, and the second mark is for representing that tables of data is not in filtration condition.
Particularly, by obtaining the filtration condition of data rows and the mapping relations of overall filter identification, by the filtration condition of data rows that detects and mapping relations, obtain the overall filter identification corresponding with the filtration condition of the data rows detected, by the overall filter identification in the overall filter identification updated data table that acquires.
According to the overall filter identification in the filtration condition updated data table of the data rows detected in Table 1, as shown in the table:
Table 4
In this step, the filtration condition of the one or more data rows detected can for being in filtration condition and not being in filtration condition.Being in filtration condition and not being in the overall filter identification in filtration condition updated data table according to data rows.As shown in table 4, the data rows of Chinese Achievement Test is in filtration condition.The overall filter identification in overall filter identification updated data table corresponding to filtration condition is according to the data rows of Chinese Achievement Test.
Preferably, in order to promote the renewal speed of the overall filter identification in tables of data, in the disposal route of the tables of data provided in the embodiment of the present invention, comprise according to the overall filter identification in the filtration condition updated data table of the data rows detected: the total columns being in the data rows of filtration condition by the filtration condition statistics of the data rows detected; When total columns of the data rows being in filtration condition is 0, upgrading overall filter identification is the second mark; When total columns of the data rows being in filtration condition is greater than 0, upgrading overall filter identification is the first mark.
Be in total columns of the data rows of filtration condition by statistics, upgrade overall filter identification fast by the situation of total columns, improve the renewal speed of the overall filter identification in tables of data, ensure that upgrading in time to overall filter identification.
Preferably, in order to better promote the renewal speed of the overall filter identification in tables of data, in the disposal route of the tables of data provided in the embodiment of the present invention, comprising according to the overall filter identification in the filtration condition updated data table of the data rows detected: when detecting successively the filtration condition of multiple data rows, judging whether to detect the data rows being in filtration condition; If the data rows being in filtration condition detected, upgrading overall filter identification state is the first mark.
By detecting the filtration condition of data rows successively, if data rows detected be in filtration condition, upgrade overall filter identification immediately, better improve the renewal speed of the overall filter identification in tables of data.Ensure that upgrading in time to overall filter identification.
Preferably, remove the processing speed of filtercondition to promote, in the disposal route of the tables of data provided in the embodiment of the present invention, the method also comprises: judge that the overall filter identification of display is the first mark or the second mark; When the overall filter identification judging to show is the first mark, to the overall filter identification executable operations of removing, wherein, is provided with in tables of data and removes overall filter identification, removing all filterconditions of overall filter identification for clearing data in table; After the filtercondition of table that clears data, in tables of data, show the second mark.
When judging tables of data process filtration condition, to the overall filter identification executable operations of removing, achieving filterconditions all in the table that clears data, improving the processing speed removing filtercondition.
Step S104, shows overall filter identification in tables of data.
The disposal route of the tables of data that the embodiment of the present invention provides, by obtaining the data rows in tables of data; Detect the filtration condition of data rows; According to the overall filter identification in the filtration condition updated data table of the data rows detected; In tables of data, show overall filter identification, solve tables of data and intuitively display itself whether can not be in the problem of filtration condition, achieve database and intuitively display itself whether can be in filtration condition.
It should be noted that, can perform in the computer system of such as one group of computer executable instructions in the step shown in the process flow diagram of accompanying drawing, and, although show logical order in flow charts, but in some cases, can be different from the step shown or described by order execution herein.
The embodiment of the present invention additionally provides a kind for the treatment of apparatus of tables of data, it should be noted that, the treating apparatus of the tables of data of the embodiment of the present invention may be used for the disposal route performing the tables of data that the embodiment of the present invention provides.Below the treating apparatus of the tables of data that the embodiment of the present invention provides is introduced:
Fig. 2 is the schematic diagram of the first embodiment for the treatment of apparatus according to tables of data of the present invention.As shown in Figure 2, this device comprises: acquiring unit 10, detecting unit 20, updating block 30 and display unit 40.
Acquiring unit 10, for obtaining the data rows in tables of data.
Detecting unit 20, for detecting the filtration condition of data rows.
Updating block 30, for according to the overall filter identification in the filtration condition updated data table of data rows detected, wherein, overall filter identification is provided with in tables of data, overall situation filter identification is for representing whether tables of data is in filtration condition, overall situation filter identification comprises the first mark and the second mark, and the first mark is for representing that tables of data is in filtration condition, and the second mark is used for identification data table and is not in filtration condition.
Display unit 40, for showing overall filter identification in tables of data.
The treating apparatus of the tables of data that the embodiment of the present invention provides, obtains the data rows in tables of data by acquiring unit 10.Detecting unit 20 detects the filtration condition of data rows.Updating block 30 is according to the overall filter identification in the filtration condition updated data table of the data rows detected, wherein, overall filter identification is provided with in tables of data, overall situation filter identification represents whether tables of data is in filtration condition, overall situation filter identification comprises the first mark and the second mark, first label table shows that tables of data is in filtration condition, and the second label table shows that tables of data is not in filtration condition.Display unit 40 shows overall filter identification in tables of data, solves tables of data and intuitively display itself whether can not be in the problem of filtration condition, achieves database and intuitively display itself whether can be in filtration condition.
Fig. 3 is the schematic diagram of the second embodiment for the treatment of apparatus according to tables of data of the present invention.This embodiment can as a kind of preferred implementation embodiment illustrated in fig. 2, and as shown in Figure 3, this device comprises: acquiring unit 10, detecting unit 20, updating block 30 and display unit 40.Wherein, updating block 30 also comprises: the first acquisition module 301, second acquisition module 302 and the first update module 303.
Acquiring unit 10, detecting unit 20, the effect of updating block 30 and display unit 40 with act on identical in above-described embodiment, do not repeat them here.
First acquisition module 301, for the mapping relations of the filtration condition and overall filter identification that obtain data rows.
Second acquisition module 302, obtains the overall filter identification corresponding with the filtration condition of the data rows detected for the filtration condition of data rows that detects and mapping relations.
First update module 303, for the overall filter identification in the overall filter identification updated data table that basis acquires.
Fig. 4 is the schematic diagram of the second embodiment for the treatment of apparatus according to tables of data of the present invention.This embodiment can as a kind of preferred implementation embodiment illustrated in fig. 2, and as shown in Figure 4, this device comprises: acquiring unit 10, detecting unit 20, updating block 30 and display unit 40.Wherein, updating block 30 also comprises: statistical module 304, second update module 305 and the 3rd update module 306.
Acquiring unit 10, detecting unit 20, the effect of updating block 30 and display unit 40 with act on identical in above-described embodiment, do not repeat them here.
Statistical module 304, the filtration condition statistics for the data rows detected is in total columns of the data rows of filtration condition.
Second update module 305, for when total columns of the data rows being in filtration condition is 0, upgrading overall filter identification is the second mark.
3rd update module 306, during for being greater than 0 at total columns of the data rows being in filtration condition, upgrading overall filter identification is the first mark.
Fig. 5 is the schematic diagram of the second embodiment for the treatment of apparatus according to tables of data of the present invention.This embodiment can as a kind of preferred implementation embodiment illustrated in fig. 2, and as shown in Figure 5, this device comprises: acquiring unit 10, detecting unit 20, updating block 30 and display unit 40.Wherein, updating block 30 also comprises: the first judge module 307 and the 4th update module 308.
Acquiring unit 10, detecting unit 20, the effect of updating block 30 and display unit 40 with act on identical in above-described embodiment, do not repeat them here.
First judge module 307, for when detecting successively the filtration condition of multiple data rows, judges whether to detect the data rows being in filtration condition.
4th update module 308, if for the data rows being in filtration condition being detected, upgrading overall filter identification state is the first mark.
Fig. 6 is the schematic diagram of the second embodiment for the treatment of apparatus according to tables of data of the present invention.This embodiment can as a kind of preferred implementation embodiment illustrated in fig. 2, and as shown in Figure 6, this device comprises: acquiring unit 10, detecting unit 20, updating block 30, display unit 40, second judge module 50, processing module 60 and display module 70.
Acquiring unit 10, detecting unit 20, the effect of updating block 30 and display unit 40 with act on identical in above-described embodiment, do not repeat them here.
Second judge module 50, for judging that the overall filter identification shown is the first mark or the second mark.
Processing module 60, for when the overall filter identification judging to show is the first mark, to the overall filter identification executable operations of removing, wherein, being provided with in tables of data and removing overall filter identification, removing all filterconditions of overall filter identification for clearing data in table.
Display module 70, for after the filtercondition of table that clears data, shows the second mark in tables of data.
Obviously, those skilled in the art should be understood that, above-mentioned of the present invention each module or each step can realize with general calculation element, they can concentrate on single calculation element, or be distributed on network that multiple calculation element forms, alternatively, they can realize with the executable program code of calculation element, thus, they can be stored and be performed by calculation element in the storage device, or they are made into each integrated circuit modules respectively, or the multiple module in them or step are made into single integrated circuit module to realize.Like this, the present invention is not restricted to any specific hardware and software combination.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any amendment done, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. a disposal route for tables of data, is characterized in that, comprising:
Obtain the data rows in tables of data;
Detect the filtration condition of described data rows;
The overall filter identification in described tables of data is upgraded according to the filtration condition of the described data rows detected, wherein, described overall filter identification is provided with in described tables of data, described overall filter identification is for representing whether described tables of data is in filtration condition, described overall filter identification comprises the first mark and the second mark, described first mark is for representing that described tables of data is in filtration condition, and described second mark is not in filtration condition for identifying described tables of data; And
Described overall filter identification is shown in described tables of data.
2. method according to claim 1, is characterized in that, comprises according to the overall filter identification that the filtration condition of the described data rows detected upgrades in described tables of data:
Obtain the filtration condition of described data rows and the mapping relations of described overall filter identification;
The overall filter identification corresponding with the filtration condition of the described data rows detected is obtained by the filtration condition of described data rows that detects and described mapping relations; And
The overall filter identification in described tables of data is upgraded according to the overall filter identification acquired.
3. method according to claim 1, is characterized in that, comprises according to the overall filter identification that the overall filter identification acquired upgrades in described tables of data:
Total columns of the data rows of filtration condition is in by the filtration condition statistics of the described data rows detected;
When total columns of the data rows being in filtration condition is 0, upgrading described overall filter identification is described second mark; And
When total columns of the data rows being in filtration condition is greater than 0, upgrading described overall filter identification is described first mark.
4. method according to claim 1, it is characterized in that, described tables of data comprises multiple data rows, the filtration condition detecting described data rows comprises and detecting successively the filtration condition of described multiple data rows, comprises according to the overall filter identification that the filtration condition of the described data rows detected upgrades in described tables of data:
When detecting successively the filtration condition of described multiple data rows, judge whether to detect the data rows being in filtration condition; And
If the data rows being in filtration condition detected, upgrading described overall filter identification state is described first mark.
5. method according to claim 1, is characterized in that, show described overall filter identification in described tables of data after, described method also comprises:
Judge that the described overall filter identification of display is described first mark or described second mark;
When judging that the described overall filter identification shown is described first mark, to the overall filter identification executable operations of removing, wherein, in described tables of data, be provided with the overall filter identification of described removing, described removing overall situation filter identification is for removing all filterconditions in described tables of data; And
After the filtercondition removing described tables of data, in described tables of data, show described second mark.
6. a treating apparatus for tables of data, is characterized in that, comprising:
Acquiring unit, for obtaining the data rows in tables of data;
Detecting unit, for detecting the filtration condition of described data rows;
Updating block, for upgrading the overall filter identification in described tables of data according to the filtration condition of the described data rows detected, wherein, described overall filter identification is provided with in described tables of data, described overall filter identification is for representing whether described tables of data is in filtration condition, described overall filter identification comprises the first mark and the second mark, and described first mark is for representing that described tables of data is in filtration condition, and described second mark is not in filtration condition for identifying described tables of data; And
Display unit, for showing described overall filter identification in described tables of data.
7. device according to claim 6, is characterized in that, described updating block comprises:
First acquisition module, for the mapping relations of the filtration condition and described overall filter identification that obtain described data rows;
Second acquisition module, obtains the overall filter identification corresponding with the filtration condition of the described data rows detected for the filtration condition of described data rows that detects and described mapping relations; And
First update module, for upgrading the overall filter identification in described tables of data according to the overall filter identification acquired.
8. device according to claim 6, is characterized in that, described updating block comprises:
Statistical module, the filtration condition statistics for the described data rows detected is in total columns of the data rows of filtration condition;
Second update module, for when total columns of the data rows being in filtration condition is 0, upgrading described overall filter identification is described second mark; And
3rd update module, during for being greater than 0 at total columns of the data rows being in filtration condition, upgrading described overall filter identification is described first mark.
9. device according to claim 6, is characterized in that, described tables of data comprises multiple data rows, and the filtration condition detecting described data rows comprises and detecting successively the filtration condition of described multiple data rows, and described updating block comprises:
First judge module, for when detecting successively the filtration condition of described multiple data rows, judges whether to detect the data rows being in filtration condition; And
4th update module, if for the data rows being in filtration condition being detected, upgrading described overall filter identification state is described first mark.
10. device according to claim 6, is characterized in that, described device also comprises:
Second judge module, for judging that the described overall filter identification shown is described first mark or described second mark;
Processing module, for when judging that the described overall filter identification shown is described first mark, to the overall filter identification executable operations of removing, wherein, in described tables of data, be provided with the overall filter identification of described removing, described removing overall situation filter identification is for removing all filterconditions in described tables of data; And
Display module, for after the filtercondition removing described tables of data, shows described second mark in described tables of data.
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 true CN104239578A (en) | 2014-12-24 |
| CN104239578B 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 (4)
| 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 |
| US20110320792A1 (en) * | 2010-06-24 | 2011-12-29 | International Business Machines Corporation | State machine-based filtering of pattern history tables based on distinguishable pattern detection |
| CN103064823A (en) * | 2012-12-25 | 2013-04-24 | 北京易时信通科技有限公司 | Method and system for processing data |
-
2014
- 2014-10-10 CN CN201410532720.2A patent/CN104239578B/en active Active
Patent Citations (4)
| 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 |
| US20110320792A1 (en) * | 2010-06-24 | 2011-12-29 | International Business Machines Corporation | State machine-based filtering of pattern history tables based on distinguishable pattern detection |
| CN103064823A (en) * | 2012-12-25 | 2013-04-24 | 北京易时信通科技有限公司 | Method and system for processing data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104239578B (en) | 2017-11-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| RU2716743C1 (en) | Method of recognizing and displaying operator access to objects of process, as well as operator system | |
| CN104809751B (en) | The method and apparatus for generating event group evolution diagram | |
| US20190156152A1 (en) | Method and apparatus for identifying a product | |
| JP2013225090A (en) | Learning device and learning program | |
| CN105148602A (en) | Prompt message output method and device | |
| CN111858951A (en) | Learning recommendation method and device based on knowledge graph and terminal equipment | |
| CN115408399A (en) | Blood relationship analysis method, device, equipment and storage medium based on SQL script | |
| CN114595343A (en) | Map display method and device, storage medium and electronic equipment | |
| CN110990514A (en) | Behavior track display method, display device and readable storage medium | |
| CN112150090A (en) | Operation planning reminding terminal and method | |
| CN110909110B (en) | Address standardization method and device, storage medium and processor | |
| CN109582410A (en) | Screenshot method, device, equipment and computer readable storage medium | |
| CN104239578A (en) | Data table processing method and device | |
| CN112988780A (en) | Data checking method and device, storage medium and electronic equipment | |
| US20160063871A1 (en) | Online learning style automated diagnostic system, online learning style automated diagnostic method and non-transitory computer readable recording medium | |
| CN103294768A (en) | Method for removing exceptional data | |
| CN106445772B (en) | Multi-data association analysis method and system | |
| CN104268277A (en) | Data reading method and device for database | |
| CN108228063B (en) | Preference scheme determination method and device and electronic equipment | |
| JP2007164463A (en) | Event analyzing apparatus and event analysis method | |
| CN110969325A (en) | Method and device for acquiring trial term of legal case | |
| CN107566189A (en) | A kind of more network interface cards of server system identify configuration device and method | |
| CN109753937A (en) | It is a kind of nesting target recognition methods and device | |
| CN108090076B (en) | Page character processing method and device | |
| CN113076316B (en) | Information relation mapping analysis method, device, equipment and storage medium |
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 |