CN100527124C - Device and method for automatically detecting and tracking data change - Google Patents
Device and method for automatically detecting and tracking data change Download PDFInfo
- Publication number
- CN100527124C CN100527124C CNB2007100286117A CN200710028611A CN100527124C CN 100527124 C CN100527124 C CN 100527124C CN B2007100286117 A CNB2007100286117 A CN B2007100286117A CN 200710028611 A CN200710028611 A CN 200710028611A CN 100527124 C CN100527124 C CN 100527124C
- Authority
- CN
- China
- Prior art keywords
- data
- equipment
- module
- variation
- border
- 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
Images
Abstract
The invention involves an automated software testing and data follow the changes the region data devices and methods. An automatic detection and follow the changes in data devices, including data equipment and performance of equipment, including the equipment described in the data: data-editing module, used to handle data entry, delete operation; data storage module, which is used to describe records data content and the location of data, data detection module, used to monitor the changes in data storage module, and is responsible for notification following border control module; border control module, used to record, inspect and modify data equipment borders, the border when modified after responsible for notifying performance equipment; performance of equipment is referred to the carrier of information, providing visual information to the data through the device performance data equipment displayed. The invention devices and the main features of the method, existing source data changes dependent on the designated users, and in this invention changes in the source data can be triggered by software to their own.
Description
Technical field
The present invention relates to computer software fields, relate in particular to a kind of automatic detection and follow the apparatus and method of data variation in the software data zone.
Background technology
In a lot of softwares, we can quote some data and realize the needed function of user, as chart, formula, PivotTables or the like.The source data of quoting when realizing these functions all is given, and it is a fixing zone.After these functions realize,, just can only go to address this problem by the method that the user manually changes the source data scope if the source data of quoting need increase or reduce.
With the chart in the form software (for example Microsoft Excel, WPS Office form or the like) is example, during with the chart representation of data, needs to specify a source data, increases if desired or the minimizing data, just must reset source data.Present form software can accomplish to change the graphics source data, but can not accomplish " change automatically "; In other words, the source data of existing chart changes the appointment that depends on the user.
Present form software can change the data source of chart by 4 kinds of modes:
1) uses " source data " dialog box
2) use formula bar series editor formula
3) use drag area
4) use API
More than 4 kinds of methods all be to belong to a kind of method after all: that is exactly to change quoting of graphics source data area.But they are not triggered by software itself automatically.
Summary of the invention
The object of the invention is to overcome deficiency of the prior art, the invention provides a kind of automatic detection data variation and follow the apparatus and method of data variation automatically, can initiatively not change under the situation of source data scope the user, allow the function that realized follow the data area of variation (increase or reduce) automatically.
In order to solve the problems of the technologies described above, be achieved through the following technical solutions: a kind of automatic detection and follow the device of data variation, it comprises data equipment and performance equipment, it is characterized in that, described data equipment comprises:
Data editing module, it is used for the operation such as input, deletion of deal with data;
Data memory module, it is used for the position of the content and the data of record data;
Data detection module, it is used for the variation of supervising data storage module data content or Data Position, and is responsible for notifying following border control module;
Border control module is used to write down, check and revise the border of the data area of data equipment, is responsible for notifying performance equipment after revise on the border;
Described performance equipment is the carrier of information, information intuitively is provided, in order to the data in the data equipment are shown by performance equipment, performance equipment is according to the shown information of automatically updating data after upgrading in the described border control module, and the variation of data equipment is initiatively shown.
The present invention also discloses a kind of automatic detection and follows the method for data variation, and it comprises following process:
1, operations such as the input of data editing module deal with data, deletion, and these information are passed to data memory module;
2, the operated data message of data memory module record data editor module;
3, data detection module detects data message whether variation has taken place, if change, then gives border control module with change notification, and carry out step 4, if do not change then forward step 6 to;
4, after border control module is received the notice of data detection module, check whether data variation occurs on the border of data area of data equipment, if, the data that border control module writes down according to data memory module are searched a scope that data are arranged of the maximum adjacent with initial boundary, then the border of the border of the new range that obtains as data equipment; If not, execution in step 6;
5, border control module notice performance equipment border situation of change, performance equipment be according to the shown information of automatically updating data after upgrading in the border control module, and the variation of data equipment is initiatively shown;
6, finish.
The principal feature of apparatus of the present invention and method is that existing source data changes the appointment that depends on the user, and the variation of source data in the present invention can trigger by software self.The problem that the present invention solves safeguards that with manual the mapping relations of " performance equipment " and " data equipment " become automatic maintenance exactly.It does not need to reset the source data of quoting and just can automatically data variation be displayed.So for the user, simplified extensive work, especially under some source datas need regularly more news.
Description of drawings
Fig. 1 is the graph of a relation between first kind of data equipment and the performance equipment in apparatus of the present invention;
Fig. 2 is the graph of a relation between second kind of data equipment and the performance equipment in apparatus of the present invention;
Fig. 3 is the graph of a relation between the third data equipment and the performance equipment in apparatus of the present invention;
Fig. 4 is the process flow diagram of the inventive method;
Fig. 5 is figure before data equipment changes among the inventive method first embodiment;
Fig. 6 is that data equipment changes back figure among the inventive method first embodiment;
Embodiment
A kind of automatic detection of the present invention and the device of following data variation comprise performance equipment and data equipment.
Performance equipment is the carrier of information, and it provides information (for example chart) intuitively to the people; In order to the data in the data equipment are shown by performance equipment.
Data equipment is the source of information, it is the data set provider of performance equipment, it can be the two dimension also can be three-dimensional (two dimension be meant that data are in same table, three-dimensional is meant that data are in a plurality of tables), and it has the notion on " scope " and " border ", it has occupied the certain physical position, for example the cell zone in the form software.
Introduce the relation between data equipment and the performance equipment below for example:
1) referring to Fig. 1, in electrical form, the content of cell B1 is formula "=SUM (A1:A3) ", and there is numeral A1:A3 the inside, cell zone.So, the formula in the cell B1 shows equipment exactly, and cell zone A1:A3 is exactly a data equipment.
2) referring to Fig. 2, in electrical form, a chart precedents zone A1:A3 is arranged, chart shows equipment exactly so, and regional A1:A3 is exactly a data equipment.
3) referring to Fig. 3, in the electrical form, have a PivotTables with cell zone A1:C4 as data source, PivotTables shows equipment exactly so, regional A1:C4 is exactly a data equipment.Correspondingly, pivot chart is the graphic form of PivotTables based on PivotTables, thereby pivot chart also can be used as performance equipment.
The zone of data equipment data selected generally is a regular domain, that is to say it must is monolithic zone or regular multi-disc zone (strict alignment between the subregion).That is to say, be a rectangular area under the situation of two dimension, is a cube zone under the three-dimensional situation.
Around the former data in the scope from no datat to data being arranged or, just can causing the variation on data equipment border from data being arranged in no datat.Elicitation procedure is caused by editing operation.At this time its can self-verifying original source data next-door neighbour around the row or column of data is arranged, till finding a sky, again with new zone as source data.Performance equipment will comprise the data updated scope like this.
Data equipment comprises with lower module:
Data editing module is used for the operation such as input, deletion of deal with data;
Data memory module is used for record data, comprises the position of the content and the data of data, but is not limited to above-mentioned data message;
For instance, in form software, a numeral 1 is arranged in the cell A1, data memory module can write down content (numeral 1) and position (A1) of this cell so;
Data detection module is used for the variation of supervising data storage module data content or Data Position, and responsible notice need obtain the module (as border control module) of monitoring message;
Border control module, notice performance equipment is responsible on the border that is used to write down, check and revise data equipment after revise on the border.
Especially, data detection module and border control module can be in same higher level's module.
Introduce the workflow of the inventive method below in conjunction with accompanying drawing 4:
1. (under original state, data equipment necessarily has a border, is called initial boundary under the original state.And data equipment necessarily has scope), the work beginning;
2. data editing module is carried out an editing operation instruction, accepts editor's data message, and information is passed to data memory module;
3. the operated new data message of data memory module record data editor module;
4. whether the information in the data detection module detection data memory module changes, if, carry out step 5, if not, then jump to step 7;
5. after border control module is received the notice of data detection module, check whether data variation occurs on the border of data equipment, if, the data that border control module writes down according to data memory module are searched a scope that data are arranged of the maximum adjacent with initial boundary, then the border of the border of the new range that obtains as data equipment; Otherwise keep initial boundary constant, jump to step 7;
6. border control module notice performance equipment border situation of change, performance equipment be according to the shown information of automatically updating data after upgrading in the border control module, and the variation of data equipment is initiatively shown;
7. end-of-job.
The detected activity of data detection module can be active or passive.The meaning of active detecting is exactly whether the data detection module information in the Monitoring Data memory module of initiatively going changes, at any time the state of data query memory module.And passive detection just is meant that an editing operation of carrying out by data editing module causes that the data memory module recorded content changes, thereby the trigger data detection module monitors this variation.
On the dialog box of performance dialog box of equipment and data equipment, can provide an option, allow the user specify and whether the range of source data is appointed as automatically.
As follows to this option regulation:
＜I〉when creating performance equipment, be the zone that meets automatic source data if detect the cell zone of user's selection, provide this option in the first step of creating guide so;
＜II〉when using the dialog box of data equipment,, provide this option so if detect the requirement that meets automatic source data.
Usually, can be chosen as automated manner acquiescently.
Further specify the inventive method below by an exemplary embodiments.
With WPS Office form is example, as shown in Figure 5, a data equipment T is arranged, and its scope is A1:C3, and its border comprises A4:D4 and D1:D3.The form of tentation data memory module record cell lattice is Cell=＜position, data 〉, suppose that empty data are remembered into nil, the form of regional record is the set of Cell, the form of data memory module posting field A1:D4 is so:
{<A1，1>，<A2，1>，<A3，1>，<A4，nil>，
<B1，1>，<B2，1>，<B3，1>，<B4，nil>，
<C1，1>，<C2，1>，<C3，1>，<C4，nil>，
<D1，nil>，<D2，nil>，<D3，nil>，<D4，nil>}
(1) under the original state, the border of T is { A1:A4 U D1:D3}
(2) as shown in Figure 6, the tentation data load module accepted the input data 2,2,2}, and the input data pass to data memory module.
(3) data memory module record new data, record is being described below of regional A1:D4 afterwards:
{<A1，1>，<A2，1>，<A3，1>，<A4，nil>，
<B1，1>，<B2，1>，<B3，1>，<B4，nil>，
<C1，1>，<C2，1>，<C3，1>，<C4，nil>，
<D1，2>，<D2，2>，<D3，2>，<D4，nil>}
Meanwhile, data detection module monitors data memory module variation has taken place.
(4) data detection module notice border control module, the notified back of border control module check the border data on the A1:A4 U D1:D3} whether with original state under consistent, under this routine situation, this moment data boundary and original state under inconsistent, that is to say that variation has taken place data boundary, has increased new data.So the Boundary Detection module comprises into these new datas by the change scope.Thereby the new range of data equipment becomes A1:C4, and new border becomes { A5:D5 U D1:D4}.Do not embody performance equipment in this example,, so, after data equipment changes this variation is reflected on the performance equipment automatically if add performance equipment in this example.
Below explain in detail some terms among the present invention:
Data memory module is used for record and manages the table an of three-dimensional (or two dimension), and this table is referred to as the data summary table.The data summary table is made up of several layers, and each layer all is a bivariate table, and this bivariate table is made up of several rows and some row, and the infall of a certain particular row and a certain particular column is referred to as data cell.Especially, when the number of plies was 1, the data summary table just deteriorated to a bivariate table.
Suppose U representative data unit, data cell can be expressed as＜r so, c, d 〉, wherein r represent the row number, c represent row number, d represents level number.
Data cell includes but is not limited to describe the attribute of position and describes the attribute of the value that it comprises.These two attributes are represented with P and V respectively.The position of data of description unit and value can be with (P V) represents.
Suppose T representative data summary table, the data summary table can be expressed as the set of data cell so, promptly
T＝{Ui|i＝1，2，3，……}
Continuous data cell (rectangle or cube that one or more data cell forms) is referred to as the data area, and the data area is the subclass of data summary table.
Suppose that R represents the data area, so R={t|t ε T}.
For convenience of description, we can be designated as (Ua with the data area, Ub, Uc), wherein Ua represents the data cell position at the place, the upper left corner of data area ground floor, Ub represents the data cell position at the place, the lower right corner of data area ground floor, and Uc represents the data cell position at the place, the lower right corner of the last one deck in data area.
It is benchmark that the border, data area refers to the data area, it capable dimension and the row dimension on increase simultaneously a formed data area of unit with it capable dimension and the row dimension on reduce the difference set of a formed data area of unit simultaneously.The tentation data zone boundary represents that with B the tentation data region R is (＜r
1, c
1, d
1,＜r
2, c
2, d
2,＜r
3, c
3, d
3) B=(＜r so
1+ 1, c
1+ 1, d
1,＜r
2+ 1, c
2+ 1, d
2,＜r
3+ 1, c
3+ 1, d
3)-(＜r
1-1, c
1-1, d
1,＜r
2-1, c
2-1, d
2,＜r
3-1, c
3-1, d
3)
" scope " of " data equipment " of our indication is exactly by the formed set in one or more data areas.Suppose that this scope represents with S, so S={r|r ε R}.
" border " of " data equipment " refers to the union on border, data area of each element (data area) of S.
That is to say, suppose S={s1, s2 ..., sn} supposes that " border " of " data equipment " represented with Q, so:
Each element si of S is a data zone, supposes that the border, data area of this data area is bi, Q={b1 so, and b2 ..., bn}.
Above example is the unrestricted technical scheme of the present invention in order to explanation only.Any modification or partial replacement that does not break away from spirit and scope of the invention all should be encompassed in the middle of the claim scope of the present invention.
Claims (10)
1, a kind of automatic detection and follow the device of data variation, it comprises data equipment and performance equipment, it is characterized in that, described data equipment comprises:
Data editing module, it is used for input, the deletion action of deal with data;
Data memory module, it is used for the position of the content and the data of record data;
Data detection module, it is used for the variation of supervising data storage module data content or Data Position, and is responsible for notifying following border control module;
Border control module is used to write down, check and revise the border of the data area of data equipment, is responsible for notifying performance equipment after revise on the border;
Described performance equipment is the carrier of information, information intuitively is provided, in order to the data in the data equipment are shown by performance equipment, performance equipment is according to the shown information of automatically updating data after upgrading in the described border control module, and the variation of data equipment is initiatively shown.
2, automatic detection according to claim 1 and follow the device of data variation is characterized in that described data detection module and border control module are arranged in same higher level's module.
3, automatic detection according to claim 1 and follow the device of data variation is characterized in that the data area of described data equipment is two dimension or three-dimensional.
4, automatic detection according to claim 1 and follow the device of data variation is characterized in that there is scope the data area of described data equipment, and occupies certain display space.
5, automatic detection according to claim 1 and follow the device of data variation is characterized in that described performance equipment is formula.
6, automatic detection according to claim 1 and follow the device of data variation is characterized in that described performance equipment is chart.
7, automatic detection according to claim 1 and follow the device of data variation is characterized in that described performance equipment is PivotTables.
8, automatic detection according to claim 1 and follow the device of data variation is characterized in that described performance equipment is pivot chart.
9, a kind of automatic detection and follow the method for data variation is characterized in that it comprises following process:
A. the input of data editing module deal with data, deletion action, and these information are passed to data memory module;
B. the operated data message of data memory module record data editor module;
C. data detection module detects data message whether variation has taken place, if change, then gives border control module with change notification, and carries out step D, if do not change then forward step F to;
D. after border control module is received the notice of data detection module, check whether data variation occurs on the border of data area of data equipment, if, the data that border control module writes down according to data memory module are searched a scope that data are arranged of the maximum adjacent with initial boundary, then the border of the border of the new range that obtains as data equipment; If not, execution in step F;
E. border control module notice performance equipment border situation of change, performance equipment be according to the shown information of automatically updating data after upgrading in the border control module, and the variation of data equipment is initiatively shown.
F. finish
10, automatic detection according to claim 9 and follow the method for data variation is characterized in that: the detected activity of described data detection module can be initiatively or passive.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2007100286117A CN100527124C (en) | 2007-06-15 | 2007-06-15 | Device and method for automatically detecting and tracking data change |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2007100286117A CN100527124C (en) | 2007-06-15 | 2007-06-15 | Device and method for automatically detecting and tracking data change |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101071414A CN101071414A (en) | 2007-11-14 |
| CN100527124C true CN100527124C (en) | 2009-08-12 |
Family
ID=38898642
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB2007100286117A Active CN100527124C (en) | 2007-06-15 | 2007-06-15 | Device and method for automatically detecting and tracking data change |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100527124C (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102063421A (en) * | 2010-12-29 | 2011-05-18 | 东莞市创锐电子技术有限公司 | System for editing test item document in test program |
| CN102799652B (en) * | 2012-06-29 | 2014-11-12 | 用友软件股份有限公司 | Multidimensional data presentation device and multidimensional data presentation method |
| CN103020031A (en) * | 2012-12-19 | 2013-04-03 | 珠海金山办公软件有限公司 | Method and device for updating data pivot table intelligently |
| CN104978114A (en) * | 2014-04-01 | 2015-10-14 | 珠海金山办公软件有限公司 | Method and device for displaying chart |
-
2007
- 2007-06-15 CN CNB2007100286117A patent/CN100527124C/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN101071414A (en) | 2007-11-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9858069B2 (en) | Transitioning between iterations in agile software development | |
| US11195136B2 (en) | Business performance bookmarks | |
| US8332773B2 (en) | Method and system for generating a control system user interface | |
| US7552399B2 (en) | Extensible icons with multiple drop zones | |
| US11270066B2 (en) | Temporary formatting and charting of selected data | |
| US6104398A (en) | Fast and efficient means for grouped object selection and deselection | |
| CN1790327B (en) | System and method for interactively linking data shapes in a diagram | |
| US20140089035A1 (en) | Mining Operation Control and Review | |
| US20050086093A1 (en) | Asset management systems | |
| US20080270720A1 (en) | Management device and management method | |
| US20150143279A1 (en) | Methods and systems for optimizing user interfacescreen space and content | |
| EP1408398A2 (en) | System and method for managing software applications in a graphical user interface | |
| CN105373522A (en) | Gesture-based on-chart data filtering | |
| EP3504619B1 (en) | Apparatus and method for managing notification | |
| US20080028363A1 (en) | Method and apparatus for creating a custom workflow | |
| US8380762B2 (en) | Database application including spilt views | |
| US9501751B1 (en) | Virtual interactive taskboard for tracking agile software development | |
| CN100527124C (en) | Device and method for automatically detecting and tracking data change | |
| US20120210215A1 (en) | Method and apparatus for providing networked assistance and feedback control for consumer electronic devices | |
| US20170192662A1 (en) | Displaying a series of reports within a single user interface | |
| CN103069353A (en) | Facility management device, screen display method, and recording medium | |
| JP2006221230A (en) | System, computer program, and method for adjusting work shift | |
| CN104123061A (en) | Process icon combination control system and electronic device | |
| JP5682452B2 (en) | CHANGE MANAGEMENT SUPPORT DEVICE, CHANGE MANAGEMENT SUPPORT METHOD, AND CHANGE MANAGEMENT SUPPORT PROGRAM | |
| US20150178357A1 (en) | Method and system for displaying MES records in a grid on an MES client screen |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C56 | Change in the name or address of the patentee | ||
| CP01 | Change in the name or title of a patent holder |
Address after: Jinshan computer Building No. 8 Jingshan Hill Road, Lane 519015 Zhuhai Jida Lianshan Guangdong city of Zhuhai Province Patentee after: Zhuhai Kingsoft Software Co., Ltd. Address before: Jinshan computer Building No. 8 Jingshan Hill Road, Lane 519015 Zhuhai Jida Lianshan Guangdong city of Zhuhai Province Patentee before: Zhuhai Jinshan Software Co., Ltd. |