AU2003212019B2 - A method and computer system for displaying of time variant tabular data - Google Patents
A method and computer system for displaying of time variant tabular data Download PDFInfo
- Publication number
- AU2003212019B2 AU2003212019B2 AU2003212019A AU2003212019A AU2003212019B2 AU 2003212019 B2 AU2003212019 B2 AU 2003212019B2 AU 2003212019 A AU2003212019 A AU 2003212019A AU 2003212019 A AU2003212019 A AU 2003212019A AU 2003212019 B2 AU2003212019 B2 AU 2003212019B2
- Authority
- AU
- Australia
- Prior art keywords
- data
- time intervals
- time
- computer system
- tabular data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Preparation Of Compounds By Using Micro-Organisms (AREA)
- User Interface Of Digital Computer (AREA)
Description
AUSTRALIA
Patents Act 1990 COMPLETE SPECIFICATION STANDARD PATENT Applicant(s): SAP AKTIENGESELLSCHAFT Invention Title: A METHOD AND COMPUTER SYSTEM FOR DISPLAYING OF TIME VARIANT TABULAR DATA The following statement is a full description of this invention, including the best method of performing it known to me/us: 2002-090-EP A METHOD AND COMPUTER SYSTEM FOR DISPLAYING OF TIME VARIANT TABULAR DATA Description Field of the invention This invention relates generally to methods for displaying information using computers, and more particularly, to the presentation of information contained in electronic spreadsheets and databases in tabular form.
Background and prior art Spreadsheet and database applications allow users to view and manipulate tabular data, information organized into rows and columns. Often, the tabular data is too large to fit on the display screen. Existing applications address this problem by providing users with the ability to scroll information both vertically and horizontally. In a windowing desktop environment, such as SAP-R/3, Microsoft Windows and the like, the problem of fitting information on the screen is exacerbated, because a plurality of windows can appear on the screen simultaneously, and each window may be significantly smaller than the display screen. Furthermore, users of most windowing desktop environments may interactively or dynamically 2 2002-090-EP change the size of a window at any time, which may reduce the available space for displaying tabular data.
Several existing systems attempt to overcome the problem of using tables that are wider than the window space available to display them.
One prior art method, chiefly implemented in database applications rather than spreadsheet applications, is that when a record is selected for viewing or editing, it is displayed in a separate window or form. The disadvantage of this method is that only one record at a time may be viewed or edited in its entirety, and the viewing or editing window may obscure all or part of the window that displays tabular data in rows and columns.
Another prior art method, taught in U.S. Pat. No. 5,317,306, allows the user to determine which columns are most important to him or her, and to designate those columns as "sticky." When a table contains more columns of information than can be displayed simultaneously, the user must scroll horizontally to view an entire row. The "sticky" columns remain in the display window when the user enters a command for horizontal scrolling.
A similar prior art method is used in Microsoft Corporation's Excel spreadsheet application, in which a user may select a row, column, or cell, and choose to "freeze panes," which splits the window, thereby causing all rows and columns above and to the left of the selected position to remain frozen in place while the rest of the display remains responsive to scrolling commands. In the prior art, a user also may make additional room in the window by designating a row or column as hidden, which suppresses its display until said row or column is unhidden by a user command.
3 2002-090-EP Still another prior art method is disclosed in U.S. Pat. No.
5,621,876, which teaches a method for increasing the number of columns in the display by adding an additional column when the user selects an "increase activator" button. This method makes the window larger, if the additional column will fit on the display screen. Otherwise, it makes the other columns narrower to accommodate the additional column.
Further, US patent no. 6,313,848 shows a method of viewing wide tables with reduced need for horizontal scrolling. The method includes the steps of determining the width of each column, determining the height of each row, and determining the dynamic height and width of the workspace available for the display of tabular data within said window and dividing the tabular data into table segments, each table segment comprising one or more columns of said tabular data.
Another problem which is encountered in the prior art is the display of tabular data which is time variant. For such data no intuitive display format has been found in the prior art.
It is therefore an object of the present invention to provide an improved method and computer system for displaying of tabular data which enables to generate an intuitive and user friendly display for time variant data.
4 Summary of the invention In a first aspect the present invention provides a method of operating a digital computer for displaying of tabular data, the tabular data comprising first data being descriptive of instances of an entity and second data, each of the second data comprising a parameter value of one of the first data and having an associated first time interval of validity of the parameter value, an observation time interval covering the first time intervals, the method comprising the steps of: a) determining second time intervals, each of the second time intervals being within the boundaries of at least one of the first time intervals without partly overlapping any of the first time intervals, the concatenated second time intervals completely covering the observation time interval, b) selecting one of the second time intervals, c) displaying a table containing a sub-set of the first data, each of the first data of the sub-set having a valid parameter value during the selected second time interval.
In a second aspect the present invention provides a computer program product comprising a program component adapted to operate a computer according to the first aspect of the invention.
S:50075 4A In a third aspect the present invention provides a computer system for displaying of tabular data, the tabular data comprising first data being descriptive of instances of an entity and second data, each of the second data comprising a parameter value of one of the first data and having an associated first time interval of validity of the parameter value, an observation time interval covering the first time intervals, the computer system comprising: a) a first component for determining second time intervals, each of the second time intervals being within the boundaries of at least one of the first time intervals without partly overlapping any of the first time intervals, the concatenated second time intervals completely covering the observation time interval, b) a user input component for selecting one of the second time intervals, c) a display component for displaying a table containing a sub-set of the first data, each of the first data of the sub-set having a valid parameter value during the selected second time interval.
The present invention is directed to a method of operating a digital computer for the display of tabular, time variant data. In essence, the invention enables to identify time intervals for the convenient display of the tabular data in an intuitive way. Further this enables to S:50075 4B create a graphical user interface which allows a user to conveniently navigate through the time variant tabular data.
In accordance with a preferred embodiment of the invention an index is generated. The index comprises the time intervals as keys to tabular data which is valid during a given interval.
Further the invention is directed towards a computer program product to operate a digital computer accordingly and to a computer system which implements a method of the present invention.
Brief description of the drawings Other features and advantages of the present invention will be described in further detail with reference to the accompanying drawings. The figures of the accompanying drawings illustrate the present invention by way of example and not limitation.
Figure 1 is a block diagram of a computer system in which the present invention is embodied; Figure 2 is illustrative of time variant tabular data to be displayed, S:50075 5 2002-090-EP Figure 3 is illustrative of time intervals of validity of parameter values of instances of an entity, Figure 4 Figure 5 is illustrative of the determination of time intervals for the display cf the tabular data of figure 2, is illustrative of a tabular display of the data for a selected time interval and the elements of a graphical user interface which enable navigation through the time intervals, is illustrative of a flow chart of a preferred embodiment of a method of the present invention, shows an index which has been created in accordance with the method of figure Figure 6 Figure 7 Figure 1 shows a computer system 100 having a relational database 102. The relational database 102 has a database interface 104 for exporting of time variant tabular data.
Further the computer system 100 has a program 106 which serves to search the tabular data which has been exported from the relational database 102 via the interface 104 for time intervals where the data has constant parameter values. Further the program 106 enables a user to select a sub-set of the data contained in the tabular data exported from the relational database 102 to form the basis of the analysis.
6 2002-090-EP The intervals which have been identified by the program 106 are stored in storage 108.
Further the program 106 generates an index with the identified time intervals as keys. The keys serve to access tabular data contained in the tabular data which has been exported from the relational database 102 which is constant during a given one of such intervals. The index is stored in storage 110.
Further the computer system 100 has a graphical user interface (GUI) 112 which serves to display the tabular data. The GUI 112 contains virtual buttons, pull down or pop up menus which allow a user to interactively navigate the tabular data along a time axis. The GUI 112 is coupled to display unit 114.
Figure 2 shows a table 200 of tabular data which is exported from the relational database 102 (cf. figure 1) by way of example. The table 200 contains data which relate to an entity E. In principle the entity E can be of any category such as person, object, place, event or business data. For example, in the case of a business computer system, the entity E can relate to customers or customers' orders. Furthermore the entity E can relate to the sections of a building, each of the sections having a specific disposable size and capacity which is time variant.
The table 200 has a column 202 containing the names of instances of the entity E. In the example considered here the names are represented by For example the name can designate a certain section of a building such as garden area, parking area, living area, office area,...
Further the table 200 has a column 204 containing values of a 7 2002-090-EP parameter P 1 for the instances of the entity E contained in the column 202. The value of the parameter P 1 is time variant. For example the parameter P 1 can indicate the disposable size of a particular section of the building for planning, business or logistic purposes.
The value Pla(Iia) represents the value of the parameter P 1 of the instance a of the entity E during the time interval Ila.
Likewise Pla(I2a) represents the value of the parameter P 1 during a subsequent time interval I2a, etc.
Plb(I1b) represents the value of the parameter P 1 for the instance b of the entity E during the time interval I1b.
Likewise Plb(I2b) represents the value of the parameter P 1 of the instance b during a subsequent time interval I2b, etc.
In other words, each field within the column 204 contains a time series of the values of the parameter P 1 for the corresponding instance.
Further the table 200 contains a column 206 for storing time variant values of a parameter P 2 For example the parameter P 2 can indicate the capacity of a given section of the building.
Again the same nomenclature is used as in the case of the parameter P 1 P2a(Ila) represents the value of the parameter P 2 of the instance a of the entity E during the time interval I1a, etc.
Figure 3 shows table 200 in another format where each row of the table corresponds to one time interval I. For example the row 700 contains the values of Pla(Iia) and P2a(Ila) for the instance during the time interval I1a tla-t2a. It is to be 8 2002-090-EP noted, that the time intervals of validity of the parameter P 2 i.e. Ila, I2a, I3a, do not need to be the same as for the parameter P 1 However for simplicity and for convenience of explanation this assumption is made in the following without restriction of generality.
When the table 200 is exported from the relational database 102 (cf. figure 1) the program 106 is started to analyse the table 200 in order to identify time intervals during which no change of relevant parameter values occurs. For the purpose of this analysis a user can select one or more of the columns 204, 206, (cf. figure 2) of the table 200 to be considered for the analysis. In the case considered here the columns 204 and 206 are analysed by the program 106 in order to identify such intervals where the parameter values Pl and P 2 do not change.
The principle of this analysis is illustrated in figure 3.
Figure 4 shows a time axis 300 and the time intervals Ila, I3a; Ilb, I2b, 1 3b; Ilc, I2c, I3, during which the values of the parameters P 1 and P 2 of the respective instances a, b and c remain constant. In the example considered here the time tla is T, tlb tlc. Further in this example t2a is T 2 t2c. Likewise t2b is T 3 and tis T 4 etc. It is to be noted that there can be gaps in the tabular data, i.e. time intervals for which there is no data entry. This is the case for the time interval 12a of the instance a.
The computer program 106 (cf. figure 1) identifies such time intervals V during which all of the parameter values P 1 and P 2 considered remain constant for all of the instances of the considered entity E. For example all of the parameter values of parameters P 1 and parameters P 2 remain unchanged between the times T 1 and T 2 The corresponding time interval identified by 9 2002-090-EP the program 106 is designated as Vi1 2 etc. Further all of the parameter values of parameters P 1 and parameters P 2 remain unchanged between the times T 2 and T 3 It is to be noted that the instance is not considered for the corresponding time interval V 2 3 as there is no data for within that time interval.
Figure 5 is illustrative of a corresponding display on display unit 114 (cf. figure A window 400 with a table 402 is displayed on the display unit 114. The table 402 shows a subset of the tabular data contained in the table 200 (cf. figure 2) The sub-set is determined by the user selected time interval Vxy of the set of intervals V 1
I
2
V
2 3
V
3 V4- 5
V
5 6 and V6 7 (cf. figure Irrespective of the user's selection of a particular one of the intervals V, each of the intervals V is completely contained or equal to a time interval I,,za, Izb, Iz of the instances a, b, c, respectively, where z 1, 2, 3, This way the program 106 (cf. figure 1) provides a filter function to reduce the table 200 to the table 402 only containing data which are valid during a user selected time interval V.
The selection of one of the previously identified intervals V can be done by means of drop down list 404. When a user selects the button 406, the drop down list 404 appears and shows the intervals V which are available for the users selection.
Alternatively a user can select a time interval V by stepwise navigation. For this purpose there are buttons 408 and 410.
When the user selects button 408 the previous time interval V 10 2002-090-EP is selected. When the user selects button 410 the succeeding time interval V is selected.
For example if the present selection is the time interval V3- 4 the user can select the preceding time interval V 2 1 3 for the filter function, such that table 402 shows those data of table 200 (cf. figure 2) which do not change during the time interval
V
2 1 3 instead of interval V 3 1 4 Likewise the user can select the subsequent time interval V 4 1s by "clicking" on button 410.
Further the graphical user interface has a button 412 which corresponds to the default setting. When the button 412 is selected this means that the user selects the time interval V which contains the present time such that the table 402 shows the data which is presently valid.
Figure 6 shows a flowchart which is illustrative of a mode of operation of the computer system 100 (cf. figure 1) In step 500 tabular data is exported from the relational database 102. The tabular data can have a form which is equivalent to table 200 (cf. figure 2) In step 502 one ormore columns of the table containing parameter data is selected to form the basis of the analysis.
The analysis is performed in step 504 in order to identify time intervals V during which none of the parameter data in the selected columns change. This list of intervals V is exported in step 506 such that the graphical user interface 112 can access the list of intervals V for the creation of a corresponding drop down list (cf. drop down list 404 of 11 p 2002-090-EP figure 4)' In step 508 an index is generated containing the intervals V askeys. Each of the keys serves to access a sub-set of the parameter data contained in the table 200 which is time invariant during a given interval V. In step 510 a user selects one of the intervals V to generate a corresponding display of tabular data of the type shown in Fig. Figure 7 shows an example for such an index 600. The index 600 has the form of a look-up table and contains a list of the identified intervals V as keys. Each of the intervals V has an associated data record which indicates a subset of the table 200 containing parameter data which is time invariant during the considered time interval V. The index 600 enables to efficiently generate a table 402 (cf. figure 4) when the user navigates along the time axis.
It is to be noted that the method of the present invention is data driven, i.e. the time intervals V are not preset but are only determined by the data itself. This provides for a maximum degree of flexibility and ease of use. Furthermore it is to be noted that the time intervals V span the complete observation time and leave no gaps on the time axis which is important to ensure that a user will not miss data when navigating along the time axis. Furthermore it is also to be noted that the time intervals V can leave gaps on the time axis for periods of time where there are no relevant entries for parameter values of the instances. In other words no time intervals V are created for periods of time where no data entries exist.
11A In the claims which follow and in the preceding description of the invention, except where the context requires otherwise due to express language or necessary implication, the word "comprise" or variations such as "comprises" or "comprising" is used in an inclusive sense, i.e. to specify the presence of the stated features but not to preclude the presence or addition of further features in various embodiments of the invention.
A reference herein to a prior art document is not an admission that the document forms part of the common general knowledge in the art in Australia.
S:50075 12 2002-090-EP List of reference numerals: computer system 100 relational database 102 interface 104 program 106 storage 108 storage 110 GUI 112 display unit 114 table 200 column 202 column 204 column 206 time axis 300 window 400 table 402 drop down list 404 button 406 button 408 button 410 button 412 step 500 step 502 step 504 step 506 step 508 step 510 index 600 row 700
Claims (9)
1. A method of operating a digital computer for displaying of tabular data, the tabular data comprising first data being descriptive of instances of an entity and second data, each of the second data comprising a parameter value of one of the first data and having an associated first time interval of validity of the parameter value, an observation time interval covering the first time intervals, the method comprising the steps of: a) determining second time intervals, each of the second time intervals being within the boundaries of at least one of the first time intervals without partly overlapping any of the first time intervals, the concatenated second time intervals completely covering the observation time interval, b) selecting one of the second time intervals, c) displaying a table containing a sub-set of the first data, each of the first data of the sub-set having a valid parameter value during the selected second time interval.
2. The method of claim 1 further comprising generating an index comprising each one of the second time intervals as keys to first data and associated parameter values being valid during one of the second time intervals. 14
2002-090-EP
3. The method of claim 1 further comprising generating a menu for a user's selection of one of the second time intervals.
4. The method of claim 1 further comprising providing a selection component of a graphicaluser interface for stepwise selection of second time intervals.
5. The method of claim 1 further comprising providing a present time selection component of a graphical user interface for selecting one of the second time intervals comprising the present time.
6. The method of claim 1 further comprising exporting the tabular data from a relational database and selecting the first and the second data from the tabular data before the determination of the second time intervals.
7. A computer program product comprising a program component adapted to operate a computer according to the method of claim i.
8. A computer system for displaying of tabular data, the tabular data comprising first data being descriptive of instances of an entity and second data, each of the second data comprising a parameter value of one of the first data and having an associated first time interval of validity of the parameter value, an observation time interval covering the first time intervals, the computer system comprising: 15 2002-090-EP a) a first component for determining second time intervals, each of the second time intervals being within the boundaries of at least one of the first time intervals without partly overlapping any of the first time intervals, the concatenated second time intervals completely covering the observation time interval, b) a user input component for selecting one of the second time intervals, c) a display component for displaying a table containing a sub-set of the first data, each of the first data of the sub-set having a valid parameter value during the selected second time interval.
9. The computer system of claim 8 further comprising an index component for generating an index comprising each one of the second time intervals as keys to first data and associated parameter values being valid during one of the second time intervals. The computer system of claim 8 further comprising a menu for a user's selection of one of the second time intervals. 11. The computer system of claim 8 further comprising a selection component of a graphical user interface for stepwise selection of second time intervals. 16 12. The computer system of claim 8 further comprising a present time selection component of a graphical user interface for selecting one of the second time intervals comprising the present time. 13. The computer system of claim 8 further comprising a relational database having an export component for exporting the tabular data and for selecting first and second data of the tabular data for the purpose of determining the second time intervals. 14. A method of operating a digital computer for displaying of tabular data substantially as herein described with reference to the accompanying drawings. A computer system for displaying of tabular data substantially as herein described with reference to the accompanying drawings. 16. A computer program product for displaying of tabular data substantially as herein described with reference to the accompanying drawings. Dated this 7th day of July 2003 SAP Aktiengesellschaft By their Patent Attorneys GRIFFITH HACK S:50075
Applications Claiming Priority (4)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
EP02015347A EP1380963A1 (en) | 2002-07-10 | 2002-07-10 | A method and computer based system for displaying of time variant tabular data |
EP02015347.4 | 2002-07-10 | ||
US10/335,110 US8560936B2 (en) | 2002-07-10 | 2002-12-31 | Methods and computer systems for displaying time variant tabular data |
US10335110 | 2002-12-31 |
Publications (2)
Publication Number | Publication Date |
---|---|
AU2003212019A1 AU2003212019A1 (en) | 2004-01-29 |
AU2003212019B2 true AU2003212019B2 (en) | 2005-03-17 |
Family
ID=30771950
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
AU2003212019A Expired AU2003212019B2 (en) | 2002-07-10 | 2003-07-09 | A method and computer system for displaying of time variant tabular data |
Country Status (2)
Country | Link |
---|---|
AU (1) | AU2003212019B2 (en) |
CA (1) | CA2434759C (en) |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5799295A (en) * | 1993-12-29 | 1998-08-25 | Kabushiki Kaisha Toshiba | Constraint-based spreadsheet system capable of displaying a process of execution of programs |
US6185582B1 (en) * | 1998-06-17 | 2001-02-06 | Xerox Corporation | Spreadsheet view enhancement system |
US6651216B1 (en) * | 1999-05-10 | 2003-11-18 | Dave Sullivan | Efficiently navigating a workbook linked to a database |
-
2003
- 2003-07-07 CA CA2434759A patent/CA2434759C/en not_active Expired - Lifetime
- 2003-07-09 AU AU2003212019A patent/AU2003212019B2/en not_active Expired
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5799295A (en) * | 1993-12-29 | 1998-08-25 | Kabushiki Kaisha Toshiba | Constraint-based spreadsheet system capable of displaying a process of execution of programs |
US6185582B1 (en) * | 1998-06-17 | 2001-02-06 | Xerox Corporation | Spreadsheet view enhancement system |
US6651216B1 (en) * | 1999-05-10 | 2003-11-18 | Dave Sullivan | Efficiently navigating a workbook linked to a database |
Also Published As
Publication number | Publication date |
---|---|
CA2434759C (en) | 2014-06-17 |
CA2434759A1 (en) | 2004-01-10 |
AU2003212019A1 (en) | 2004-01-29 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US7587666B2 (en) | Methods, computer program products and data processing systems for displaying a plurality of data objects | |
US6313848B1 (en) | Folded tables: a method of viewing wide tables with reduced need for horizontal scrolling | |
US6225996B1 (en) | System and method for displaying a current value of a cell of a document | |
US6731312B2 (en) | Media player interface | |
US5140678A (en) | Computer user interface with window title bar icons | |
US5430839A (en) | Data entry screen method | |
US8214764B2 (en) | System and process for presenting search results in a histogram/cluster format | |
US5396587A (en) | Asynchronous, minimal update display system | |
US20030197738A1 (en) | Navigational, scalable, scrolling ribbon | |
US8380762B2 (en) | Database application including spilt views | |
US6615207B1 (en) | Method of formulating and presenting search queries to a tabular database through a user-interactive computer display interface | |
KR20060106643A (en) | Scrollable and re-sizeable formula bar | |
US7720887B2 (en) | Database navigation | |
US20040135811A1 (en) | Method and system for displaying data fields | |
AU2018206691B2 (en) | Data interaction cards for capturing and replaying logic in visual analyses | |
US20070209019A1 (en) | Method and device for displaying data | |
US8127245B2 (en) | Multi-dimensional systems and controls | |
US20050216864A1 (en) | Method for controlling filename display for image and video file types | |
US7712042B2 (en) | Techniques for viewing mappings and nodes | |
US20020047858A1 (en) | Graphical user interfaces | |
US8560936B2 (en) | Methods and computer systems for displaying time variant tabular data | |
US7730067B2 (en) | Database interaction | |
US8078626B1 (en) | Unified management of time related information | |
AU2003212019B2 (en) | A method and computer system for displaying of time variant tabular data | |
US20030052920A1 (en) | Document navigation system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
FGA | Letters patent sealed or granted (standard patent) | ||
MK14 | Patent ceased section 143(a) (annual fees not paid) or expired |