US20080320409A1 - Tightly-Coupled Synchronized Selection, Filtering, and Sorting Between Log Tables and Log Charts - Google Patents
Tightly-Coupled Synchronized Selection, Filtering, and Sorting Between Log Tables and Log Charts Download PDFInfo
- Publication number
- US20080320409A1 US20080320409A1 US12/195,020 US19502008A US2008320409A1 US 20080320409 A1 US20080320409 A1 US 20080320409A1 US 19502008 A US19502008 A US 19502008A US 2008320409 A1 US2008320409 A1 US 2008320409A1
- Authority
- US
- United States
- Prior art keywords
- event
- format
- events
- graphical
- logged
- 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.)
- Abandoned
Links
- 238000001914 filtration Methods 0.000 title claims description 22
- 230000001360 synchronised effect Effects 0.000 title description 2
- 230000004044 response Effects 0.000 claims description 19
- 230000009471 action Effects 0.000 claims description 14
- 238000000034 method Methods 0.000 claims description 13
- 238000010168 coupling process Methods 0.000 claims description 9
- 238000005859 coupling reaction Methods 0.000 claims description 9
- 230000008878 coupling Effects 0.000 claims description 8
- 230000004048 modification Effects 0.000 claims description 3
- 238000012986 modification Methods 0.000 claims description 3
- 230000006870 function Effects 0.000 claims 1
- 238000012544 monitoring process Methods 0.000 abstract description 6
- 238000001514 detection method Methods 0.000 abstract description 4
- 230000008569 process Effects 0.000 description 9
- 230000008859 change Effects 0.000 description 6
- 238000004590 computer program Methods 0.000 description 5
- 230000008901 benefit Effects 0.000 description 3
- 230000003993 interaction Effects 0.000 description 3
- 230000000007 visual effect Effects 0.000 description 3
- 239000003086 colorant Substances 0.000 description 2
- 238000013079 data visualisation Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000002955 isolation Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000003860 storage Methods 0.000 description 2
- 239000000126 substance Substances 0.000 description 2
- 230000001944 accentuation Effects 0.000 description 1
- 230000003213 activating effect Effects 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000001364 causal effect Effects 0.000 description 1
- 230000001427 coherent effect Effects 0.000 description 1
- 238000010960 commercial process Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000007418 data mining Methods 0.000 description 1
- 230000000881 depressing effect Effects 0.000 description 1
- 239000012530 fluid Substances 0.000 description 1
- 238000002347 injection Methods 0.000 description 1
- 239000007924 injection Substances 0.000 description 1
- 239000007788 liquid Substances 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000005259 measurement Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000003924 mental process Effects 0.000 description 1
- 230000003252 repetitive effect Effects 0.000 description 1
- 239000000523 sample Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F3/0482—Interaction with lists of selectable items, e.g. menus
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2203/00—Indexing scheme relating to G06F3/00 - G06F3/048
- G06F2203/048—Indexing scheme relating to G06F3/048
- G06F2203/04803—Split screen, i.e. subdividing the display area or the window area into separate subareas
Definitions
- the present invention relates generally to an event detection and monitoring system and specifically, relates to displaying event data in both tabular and chart formats.
- the tabular and chart format data are tightly-coupled so that when a user selects an event in one format, the corresponding event in the other format is highlighted.
- An event detection and monitoring system detects the occurrence of a system event and creates a record of the event.
- Event log files are created by many different programs to record different types of events for later analysis, and can be sorted and ordered by categories such as time, date, event type, and the like. While log files in tabular format do provide a wealth of information about individual events in isolation, they do not readily illuminate patterns or clusters of events that in the aggregate may help to isolate or narrow a problem that may be causing the events being reported.
- an event log or log chart is a text file with one or more lines of text describing each event.
- Event logs may also include sorting criteria such as time of the event or of the report, name of the event, type of event, person reporting or on the scene, error code, etc.
- sorting criteria such as time of the event or of the report, name of the event, type of event, person reporting or on the scene, error code, etc.
- reading the text-based event log presents too much detail and obscures relationships between groups of events.
- Data from the event log is therefore sometimes put into a graphical format, preferably a chart, that displays only some of the data of the event log for many events simultaneously.
- the event log may be ongoing and updated as events occur, such as safety system monitoring and maintenance at a chemical manufacturing plant, or it may be a compilation of historical events, such as automated in-flight measurements downloaded from an aircraft after landing for analysis.
- log tables data presented in a tabular format
- Log tables may contain hundreds or thousands of rows of entries, which can be tedious for the user to quickly explore or navigate in order to find the desired entry or to identify a pattern of events.
- Conventional sorting and filtering software and controls can assist in culling the volume of data to absorb, but these do not take advantage of data visualization that can facilitate a data mining and exploring mode of interaction.
- Conventional sorting and filtering controls assume that users know the information they are searching for and would benefit from exploring general patterns of activity that might be more readily apparent by viewing a chart.
- Data visualization is a higher-level user interaction approach, and another tool for users in determining and analyzing problems.
- This invention provides a two-way connection between data is a tabular format and data in a chart format.
- the present invention overcomes the individual limitations of a tabular and a graphical presentation format (such as log tables and log charts) by providing a tightly coupled two-way connection between common events depicted on both of them.
- An event selected from the event log file is shared between the log table and the log chart.
- a table and chart each carry different information of the same event, and each appeals to different mental processes.
- a graphical presentation makes patterns of faults more obvious than a columnar series of text entries (depending upon the nature of the pattern and the graph). Based on which display of an event piques a user's interest, an event from that display may be selected and the corresponding event in the other display is automatically highlighted or otherwise visually offset, according to the present invention, for maximizing the information available to the user for that event.
- the selection can be a single event or multiple events being selected from the table, from the chart, or via the filter from the log file that populates the table and chart.
- the tight coupling between log tables and log charts is also beneficial when combined with conventional sorting and filtering of the event log table.
- the graphical views make user log interactions more valuable than viewing only event log tables. For example, the visual clustering of events around certain time periods readily shows repetitive problems. Such event clustering is more difficult to see in a tabular log thereby making tight coupling of log tables and log charts more valuable to users and administrators.
- the present invention is embodied in one aspect as computer program embodied on a computer readable medium.
- the program includes computer executable instructions for displaying a first portion of the logged event in a tabular format and a second portion of the logged event in a graphical format for each of a plurality of logged or recorded events.
- the first portion and second portion reflect the concept that each format carries different information of the same event. Where the first portion is the whole, the second portion is a subset of the first portion. Where a parent database carries more detail for each event than is displayed in either format, the first and second portions may be only partial portions of the entire event as recorded in the separate database.
- the computer executable instructions further cause the display of an event in the graphical format to change in response to at least one event being selected in the tabular format, and also cause the display of an event in the tabular format to change in response to the event being selected in the graphical format.
- the change in display may be a highlighting or some other visual accentuation to offset the subject event from other displayed events.
- the present invention also includes the method that is described above as being executed by the computer program, but apart from the computer program embodiment itself.
- a computer program embodied on a computer readable medium similar to that described above includes changing the display of a selected event in the graphical format to reflect a modification done to a selected event at the chart format. That is, a user may change a recorded event at the tabular format display, and that change will be automatically reflected in the graphical display.
- the system includes a computer readable first and second memory that may or may not be separate memory entities, a processor, and an input.
- the first memory stores a plurality of recorded events, each event having a first portion of data fields and a second portion of data fields. At least one data field is common to both the first and second portion, but the first and second portions are not identical (at least one data field differs). In the Figures described herein, time is the common data field, though that is only illustrative.
- the processor is coupled to the first memory, and arranges the first portion into a tabular format and the second portion into a graphical format.
- the tabular and graphical formats are combined into an output signal that, when output to a monitor, enables the monitor to display both formats simultaneously as is shown by way of example in FIGS. 2A-2B .
- the input is coupled to the processor to receive a first and a second user input.
- the first user input selects the first portion of one or more recorded events, such as an event displayed in the tabular format.
- the second user input selects the second portion of one or more recorded events, such as an event displayed in the graphical format.
- a third user input filters the plurality of events according to one of the data fields.
- the second memory is coupled to the processor, and stores computer instructions that operate in response to the user inputs.
- the computer instructions of the second memory operate to alter the output signal so that the recorded event selected by either of the first or second user input is visually offset from other recorded events in both the tabular format and the graphical format. This is true for both the first and second user inputs, so whether the user selects a recorded event in the tabular format or the graphical format, the selection is reflected in both simultaneously displayed formats.
- the third user input filters the plurality of events, so the computer instructions of the second memory operate in response to the third user input to alter the output signal so that only a subset of the plurality of recorded events are included in the output signal. That subset is consistent with the filtering of the third user input.
- FIG. 1 is a computer system that may be used to practice the present invention and displaying a log chart and log table consistent with the present invention.
- FIG. 2A is a graphical representation of events and alerts shown along a time line.
- FIG. 2B is a tabular representation of some of the events and alerts shown in FIG. 2A .
- FIG. 3 is a flow chart depicting the process for adding events to a log chart and to a log table.
- FIG. 4 is a flow chart depicting the process for viewing both a log chart and a log table from a user operating only on the log chart.
- FIG. 5A is a log chart operated on by a user in accordance with FIG. 4 .
- FIG. 5B is a log table automatically highlighted in response to the user's operation on the log chart of FIG. 5A .
- FIG. 6 is a flow chart depicting the process for viewing both a log chart and a log table from a user operating only on the log table.
- FIG. 7A is a log chart automatically highlighted in response to the user's operation on the log table of FIG. 7B in accordance with the flow chart of FIG. 6 .
- FIG. 7B is a log operated on by a user in accordance with FIG. 6 .
- FIGS. 8A and 8B is a log chart and log table, respectively, showing that events selected by a filter at the log table are highlighted in both the log table and log chart.
- FIGS. 9A and 9B are similar to FIGS. 8A and 8B , respectively, showing further action taken at the log table causes the relevant events to be emphasized and the non-relevant events to be de-emphasized in both the log table and log chart.
- the present invention is most advantageously implemented by a computer, and is therefore preferably a computer program (e.g., a set of computer instructions) embodied on a computer readable medium such as a PC or server hard drive, a magnetic tape or disk, an optical disk, an electronic media such as a memory stick, or the like.
- the computer instructions cause the computer to execute various steps to practice the invention as detailed in this disclosure and claims.
- One suitable computer system 20 is illustrated in FIG. 1 having a display such as a CRT or plasma screen that simultaneously displays a log chart 22 A and a log table 22 B, which are different representations of the same underlying data.
- the computer system further includes a user interface such as a mouse 24 A and keyboard 24 B, at least one data processor CPU 26 , a memory 28 , and a display driver 32 .
- the system 20 may also include a drive 30 for reading removable computer storage media such as magnetic diskettes, optical disks, magnetic tapes, flash memory sticks, and the like.
- the present invention embodied on a computer readable medium may be within one of those removable mediums, or may be within a non-removable medium such as the memory 28 depicted, or may be stored at a remote memory location such as a server and accessed by the described computer system 20 via a network.
- FIG. 2A shows in particular a graphical representation in chart format of events and alerts along a time line.
- An event is a report of a single coherent occurrence, such as a line pressure at a particular location, a lockout of an electrical panel, injection of a liquid into a mold at a measured temperature, an addition of a chemical to a vat, etc.
- Events that require user intervention may be referred to as alerts, such as an overvoltage at an electrical monitoring point (regardless of automatic safety mechanisms to reduce immediate risks), an elevator stuck between floors, or a low fluid level in a car reported in response to an electronic inquiry.
- alerts such as an overvoltage at an electrical monitoring point (regardless of automatic safety mechanisms to reduce immediate risks), an elevator stuck between floors, or a low fluid level in a car reported in response to an electronic inquiry.
- alerts include a vast array of possibilities, and are often represented by some automated industrial or commercial process.
- logged events are sorted by the time of occurrence.
- Each box or block 200 corresponds to the occurrence of an event or an alert entered into the events log files.
- the width of the box corresponds to a particular time interval.
- the boxes are stacked to provide a visual presentation of multiple event occurrences during the same time interval. While boxes or blocks are shown, any other symbol may be used to indicate the occurrence of an event or alert.
- FIG. 2B shows a portion of a tabular listing that details the events and alerts of FIG. 2A .
- Each row 210 corresponds to an individual event occurrence.
- the table includes information regarding the type, name, date and time, and written description of each event or alert shown in FIG. 2A .
- events are simultaneously added to the event log chart and to the event log table.
- the box 202 outlined in the chart of FIG. 2A corresponds to the selected entry 212 that is highlighted in the event log table of FIG. 2B .
- the present invention provides a two-way coupling between the graphical presentation ( FIG. 2A ) and the tabular presentation ( FIG. 2B ) to permit a user to select an event in a first format, either the chart or in the table, and to have automatically highlighted (or otherwise flagged) the corresponding symbol or row of the selected event in the other format.
- the user can select an event in the chart and then drill down and explore events in the chart.
- the row in the table containing the event corresponding to each event selected in the chart is highlighted in the table.
- the user is able to track events or alerts in the table and as a row of the table is selected, the symbol in the chart corresponding to the event selected in the table is highlighted.
- the symbol in the chart corresponding to the selected event is simultaneously updated and highlighted.
- the user can select the symbol in the chart for an event and the row in the table containing that event is simultaneously highlighted.
- Selection of a box in the chart corresponding to an event is a common investigatory technique and the corresponding row in the table is highlighted during the “fly-over” of the chart.
- the left-most column of the table in FIG. 2B includes symbols corresponding to different types of events and alerts. Sorting alerts so that they are listed at the top of the event log table, for example, is useful for the user to determine what actions are required and which actions require immediate attention. The symbols in the chart corresponding to the alerts sorted at the top of the log table are highlighted in the chart for drawing the attention of the user to those alerts. Sorting items within a table does not select any particular item, but simply reorders the rows of event data.
- multiple filtering of the table of events is performed with the boxes corresponding to the different filtered results being displayed in different colors (and/or shapes or other distinguishing indicia) to make evident the results of each of the multiple filters.
- protection-related events could be shown with one color while heal-related events could be shown in another color, thereby enabling the user to quickly correlate between the events themselves. Accordingly, protect-related events can be attended to before heal-related events.
- the invention is embodied by event log data in both a chart format and a table format.
- the processes for preparing the event logs in both tabular and chart formats are depicted in the flowchart 300 in FIG. 3 .
- the process is performed by software controlling the event detection and monitoring system.
- step 301 a conventional event log file is opened.
- the present invention includes parsing logic for the format of the given log file so that one event at a time can be read and interpreted.
- the log file is examined to ascertain whether a new event has been added, which is read at step 303 if present. An event is added as a symbol to the chart in step 304 and a new row is added to the table in step 305 corresponding to the event read from the log file.
- Each event in the log file will be represented by both a symbol in the chart and a row in the table.
- a check is made in step 302 to determine if there are additional events in the event log file that have not yet been added to the chart and table. If there are additional events, the next event is read from the event file log in step 303 and added to the chart in step 304 and to the table in step 305 . The checks and the addition processes continue until there are no additional events in the event log file that have to be added to the chart and to the table at which time the process is done in step 306 .
- FIG. 3 and this detailed description, presume that events are not originally entered in the log table but rather in a separate event log from which the log file is populated. This is a typical arrangement, in that many events are automatically performed and entered in an event log, or events are added to an event log from many disparate entry points. Where entries are made directly to the log table (e.g., where the log table serves as the event log), steps 302 - 303 of FIG. 3 refer to the log table and step 305 is deleted. Similar changes to other portions of this description are relevant where the log table and the event log are one and the same. Both the log table and event log are primarily if not exclusively text documents that list events by line entries.
- FIG. 4 is a flow chart describing steps to display, on both a log chart and the log table, an event that a user selects only from a log chart.
- FIG. 4 is best understood with reference to the log chart of FIG. 5A and the log table of FIG. 5B .
- the user positions a mouse pointer next to a desired symbol displayed on the chart 400 , such as the block 501 of the log chart 500 .
- a determination is made regarding which event corresponds to the selected symbol.
- information regarding the desired event is displayed in a tooltip next to the pointer, preferably only after the pointer remains stationary for a minimum threshold of time.
- step 405 a determination is made regarding which event corresponds to the selected symbol 501 .
- the row 511 in the log table of FIG. 5B that corresponds to the selected symbol 501 (and to the event represented by that symbol 501 ) is highlighted or otherwise identified at step 406 .
- the process is completed at step 407 .
- FIG. 6 is a flow chart describing steps to display, on both a log chart and the log table, an event that a user selects only from a log table.
- FIG. 5 is best understood with reference to the log chart of FIG. 7A and the log table of FIG. 7B .
- the user positions a mouse pointer at a row containing a desired event, such as the indicated row 711 of the log table 710 of FIG. 7B .
- a determination is made in step 602 regarding which event corresponds to the selected event in row 711 .
- information regarding the event is displayed in a tooltip next to the mouse pointer, preferably only after the pointer remains stationary for a minimum threshold of time as noted above.
- step 604 the user selects the desired row 711 by clicking on the mouse button in step 604 .
- step 605 a determination is made regarding which event corresponds to the selected row 711 .
- the symbol 701 in the log chart of FIG. 7A that corresponds to the selected row 711 (and to the event represented by that row 711 ) is highlighted or otherwise identified at step 606 .
- the process is completed at step 607 .
- FIGS. 8A-8B illustrate filtering according to one embodiment of the present invention.
- a user selects at the log table of FIG. 8B a filter icon 801 , drags it to a column header of a category 802 , and types a filter criteria (“pool”) into a filter parameter block 803 .
- the filter parameter block 803 may allow text entries as illustrated, or may allow the user to select from a fixed list of options, such as a pulldown list. Certain filters may require actuation (such as clicking the icon 801 ′ nearest the filter parameter block 803 , or depressing an enter or return key), while others may take effect as the entry to the filter parameter block 803 is made. Regardless, the filter searches for and retrieves only those events that pass the filter. In FIG.
- events 804 A, 804 B, 804 C, and 804 D each bear the filter parameter “pool” in the description category, and thus satisfy the chosen parameter.
- Events that pass the filter are marked with an indicia that distinguishes the permitted filtered-in events from the denied filtered-out events.
- the filtered-in events 804 A-D may be distinguished by a darkened background, an outline, being displayed at the top of the log chart, etc. They may also be distinguished by a change to the display of all filtered-out events 805 , such as the filtered-out events 805 being eliminated from view (the visible horizontal lines blanked as in FIG. 8B ), changed to a reduced contrast or brightness, and the like.
- the corresponding events 804 A′, 804 B′, 804 C′, and 804 D′ are similarly distinguished from the filtered-out events 805 ′ in the event chart of FIG. 8B .
- the particular distinguishing indicia used for the log chart preferably but not necessarily carries over to the log table.
- the filtered-out events 805 ′ still be displayed to provide context for the filtered-in events 804 A′-D′.
- FIG. 8A shows four filtered-in events 804 A′-D′ dispersed among 86 filtered-out events 805 ′.
- Such a multi-event view frequently isolates problems or causal relationships among events more effectively than displaying the filtered-in events 804 A′-D′ in isolation.
- the display of the log table that distinguishes filtered-in events 804 A-D from filtered-out events 805 occurs simultaneously with the display of the log chart that distinguishes filtered-in events 804 A′-D′ from filtered-out events 805 ′.
- the user inputs 801 , 801 ′, 803 for the filter may be incorporated into the display of the log table as illustrated in FIG. 8B , or of the log chart, or of the display of both or neither (a separate filter display).
- the user may choose to operate on only the filtered-in events, possibly by a pattern or relation that is revealed or suspected from the log chart of FIG. 8A . This occurs in FIG. 9A-9B , where the user can ‘drill-down’ into the data of the filtered-in events to find more revealing comnmonalities or lack thereof. In the log chart of FIG.
- a user may click a ‘select all’ icon 901 which limits at least the next operation (e.g., another filter, copying the data to another storage location, activating a probe, marking filtered-in events for a report) to only those events currently displayed in the table, which is all the filtered-in events.
- filtering by another parameter 903 operates only on the selected events 904 A-D in the log table and the corresponding selected events 904 A′-D′ in the log chart.
- the ‘select all’ command further changes the display of either or both of the filtered-in events 904 A-D, 904 A′-D′ and the non-selected events 905 , 905 ′ as compared to their display previous to the ‘select all’ choice.
- Distinguishing indicia such as those listed above in relation to FIGS. 8A-B may be used.
- the invention is capable of providing tight-coupling, two-way connection and synchronous selection (and viewing) of events between the tabular format and chart format as described above. That is, the same event is indicated in both formats, regardless of whether a row is selected in the table or a symbol is selected in the chart.
- the same tight coupling, two-way connection between the event log table and event log chart is also accomplished when the rows of the event log table are sorted or filtered in a conventional manner.
- the present invention enables a user to manipulate either a tabular or a graphical presentation of the same underlying data, and view the result of the manipulation in both the tabular and graphical presentations.
- one presentation type better indicates to a user an area or event of interest (as in a pattern visible in a graphical format)
- the user may select one or more events in that presentation type and automatically have presented the additional information made apparent by the other presentation type (as in detailed text of a columnar entry in a table).
- the two-way communication between the presentations enables greater latitude in the user's ability to first identify events or groups of events of interest.
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Human Computer Interaction (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Debugging And Monitoring (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
In an event detection and monitoring system displaying event data in both tabular and chart formats, the displays of each are tightly-coupled to one another so that when a user selects an event in one format the corresponding event in the other format is highlighted or otherwise emphasized. When a user selects a row containing an event of interest in the event log table, the symbol in the event log chart corresponding to the selected event is simultaneously highlighted. Similarly, when a user selects a symbol in the event log chart corresponding to an event of interest, the row in the event log table containing the corresponding event is simultaneously highlighted. In addition, the rows of the event log table can be sorted and filtered according to predetermined criteria, and the events selected by the filters are highlighted in the chart with indicia distinguishing the filter.
Description
- The present invention relates generally to an event detection and monitoring system and specifically, relates to displaying event data in both tabular and chart formats. The tabular and chart format data are tightly-coupled so that when a user selects an event in one format, the corresponding event in the other format is highlighted.
- An event detection and monitoring system detects the occurrence of a system event and creates a record of the event. Event log files are created by many different programs to record different types of events for later analysis, and can be sorted and ordered by categories such as time, date, event type, and the like. While log files in tabular format do provide a wealth of information about individual events in isolation, they do not readily illuminate patterns or clusters of events that in the aggregate may help to isolate or narrow a problem that may be causing the events being reported.
- When an event occurs that is recorded, relevant information about the event is placed into an event log or log chart, often displayed on a computer screen. Typically, an event log or log chart is a text file with one or more lines of text describing each event. Event logs may also include sorting criteria such as time of the event or of the report, name of the event, type of event, person reporting or on the scene, error code, etc. For a reader seeking a broad overview of numerous events in context with one another, reading the text-based event log presents too much detail and obscures relationships between groups of events. Data from the event log is therefore sometimes put into a graphical format, preferably a chart, that displays only some of the data of the event log for many events simultaneously. The event log may be ongoing and updated as events occur, such as safety system monitoring and maintenance at a chemical manufacturing plant, or it may be a compilation of historical events, such as automated in-flight measurements downloaded from an aircraft after landing for analysis.
- One usability problem with log tables (data presented in a tabular format) is that the format makes it difficult for a user to explore the tabular data except as individual entries of discrete events. Log tables may contain hundreds or thousands of rows of entries, which can be tedious for the user to quickly explore or navigate in order to find the desired entry or to identify a pattern of events. Conventional sorting and filtering software and controls can assist in culling the volume of data to absorb, but these do not take advantage of data visualization that can facilitate a data mining and exploring mode of interaction. Conventional sorting and filtering controls assume that users know the information they are searching for and would benefit from exploring general patterns of activity that might be more readily apparent by viewing a chart. Data visualization is a higher-level user interaction approach, and another tool for users in determining and analyzing problems. However, as the user drills down to the root of the problem using the chart presentation, the log table might provide the next level of more detailed information for problem determination. Both types of event log format presentations—tabular and chart—provide different benefits. Tight coupling between log tables and log charts provide the user with a more robust tool, facilitating data exploration and providing synergy.
- Currently, there are systems capable of converting data that is in tabular format into chart format. See for example Japanese Patent Nos. 2000200302 by Nishemura Hidenori et al. and U.S. Pat. No. 4,760,418 by Watanabe et al. There are also systems capable of graphing stored data. See for example Japanese Patent No. 4243493A to Nakabayashi Kazunori et al.
- There are no currently available systems known to the inventors that are capable of tightly coupling events in a log table to a log chart and events from a log chart to a log table, thereby creating two-way connections. This invention provides a two-way connection between data is a tabular format and data in a chart format.
- The present invention overcomes the individual limitations of a tabular and a graphical presentation format (such as log tables and log charts) by providing a tightly coupled two-way connection between common events depicted on both of them. An event selected from the event log file is shared between the log table and the log chart. A table and chart each carry different information of the same event, and each appeals to different mental processes. For example, a graphical presentation makes patterns of faults more obvious than a columnar series of text entries (depending upon the nature of the pattern and the graph). Based on which display of an event piques a user's interest, an event from that display may be selected and the corresponding event in the other display is automatically highlighted or otherwise visually offset, according to the present invention, for maximizing the information available to the user for that event. The selection can be a single event or multiple events being selected from the table, from the chart, or via the filter from the log file that populates the table and chart. The tight coupling between log tables and log charts is also beneficial when combined with conventional sorting and filtering of the event log table.
- The graphical views make user log interactions more valuable than viewing only event log tables. For example, the visual clustering of events around certain time periods readily shows repetitive problems. Such event clustering is more difficult to see in a tabular log thereby making tight coupling of log tables and log charts more valuable to users and administrators.
- The present invention is embodied in one aspect as computer program embodied on a computer readable medium. The program includes computer executable instructions for displaying a first portion of the logged event in a tabular format and a second portion of the logged event in a graphical format for each of a plurality of logged or recorded events. The first portion and second portion reflect the concept that each format carries different information of the same event. Where the first portion is the whole, the second portion is a subset of the first portion. Where a parent database carries more detail for each event than is displayed in either format, the first and second portions may be only partial portions of the entire event as recorded in the separate database. The computer executable instructions further cause the display of an event in the graphical format to change in response to at least one event being selected in the tabular format, and also cause the display of an event in the tabular format to change in response to the event being selected in the graphical format. The change in display may be a highlighting or some other visual accentuation to offset the subject event from other displayed events. The present invention also includes the method that is described above as being executed by the computer program, but apart from the computer program embodiment itself.
- In another aspect, a computer program embodied on a computer readable medium similar to that described above includes changing the display of a selected event in the graphical format to reflect a modification done to a selected event at the chart format. That is, a user may change a recorded event at the tabular format display, and that change will be automatically reflected in the graphical display.
- Another aspect of the present invention is a system for coupling a tabular display to a graphical display. The system includes a computer readable first and second memory that may or may not be separate memory entities, a processor, and an input. The first memory stores a plurality of recorded events, each event having a first portion of data fields and a second portion of data fields. At least one data field is common to both the first and second portion, but the first and second portions are not identical (at least one data field differs). In the Figures described herein, time is the common data field, though that is only illustrative. The processor is coupled to the first memory, and arranges the first portion into a tabular format and the second portion into a graphical format. The tabular and graphical formats are combined into an output signal that, when output to a monitor, enables the monitor to display both formats simultaneously as is shown by way of example in
FIGS. 2A-2B . The input is coupled to the processor to receive a first and a second user input. The first user input selects the first portion of one or more recorded events, such as an event displayed in the tabular format. Similarly, the second user input selects the second portion of one or more recorded events, such as an event displayed in the graphical format. A third user input filters the plurality of events according to one of the data fields. The second memory is coupled to the processor, and stores computer instructions that operate in response to the user inputs. Specifically, the computer instructions of the second memory operate to alter the output signal so that the recorded event selected by either of the first or second user input is visually offset from other recorded events in both the tabular format and the graphical format. This is true for both the first and second user inputs, so whether the user selects a recorded event in the tabular format or the graphical format, the selection is reflected in both simultaneously displayed formats. The third user input filters the plurality of events, so the computer instructions of the second memory operate in response to the third user input to alter the output signal so that only a subset of the plurality of recorded events are included in the output signal. That subset is consistent with the filtering of the third user input. - These and additional features of the present invention will become more clearly apparent when the following detailed description is read in conjunction with the accompanying drawings.
-
FIG. 1 is a computer system that may be used to practice the present invention and displaying a log chart and log table consistent with the present invention. -
FIG. 2A is a graphical representation of events and alerts shown along a time line. -
FIG. 2B is a tabular representation of some of the events and alerts shown inFIG. 2A . -
FIG. 3 is a flow chart depicting the process for adding events to a log chart and to a log table. -
FIG. 4 is a flow chart depicting the process for viewing both a log chart and a log table from a user operating only on the log chart. -
FIG. 5A is a log chart operated on by a user in accordance withFIG. 4 . -
FIG. 5B is a log table automatically highlighted in response to the user's operation on the log chart ofFIG. 5A . -
FIG. 6 is a flow chart depicting the process for viewing both a log chart and a log table from a user operating only on the log table. -
FIG. 7A is a log chart automatically highlighted in response to the user's operation on the log table ofFIG. 7B in accordance with the flow chart ofFIG. 6 . -
FIG. 7B is a log operated on by a user in accordance withFIG. 6 . -
FIGS. 8A and 8B is a log chart and log table, respectively, showing that events selected by a filter at the log table are highlighted in both the log table and log chart. -
FIGS. 9A and 9B are similar toFIGS. 8A and 8B , respectively, showing further action taken at the log table causes the relevant events to be emphasized and the non-relevant events to be de-emphasized in both the log table and log chart. - The present invention is most advantageously implemented by a computer, and is therefore preferably a computer program (e.g., a set of computer instructions) embodied on a computer readable medium such as a PC or server hard drive, a magnetic tape or disk, an optical disk, an electronic media such as a memory stick, or the like. The computer instructions cause the computer to execute various steps to practice the invention as detailed in this disclosure and claims. One
suitable computer system 20 is illustrated inFIG. 1 having a display such as a CRT or plasma screen that simultaneously displays alog chart 22A and a log table 22B, which are different representations of the same underlying data. The computer system further includes a user interface such as amouse 24A andkeyboard 24B, at least onedata processor CPU 26, amemory 28, and adisplay driver 32. Thesystem 20 may also include adrive 30 for reading removable computer storage media such as magnetic diskettes, optical disks, magnetic tapes, flash memory sticks, and the like. The present invention embodied on a computer readable medium may be within one of those removable mediums, or may be within a non-removable medium such as thememory 28 depicted, or may be stored at a remote memory location such as a server and accessed by the describedcomputer system 20 via a network. -
FIG. 2A shows in particular a graphical representation in chart format of events and alerts along a time line. An event is a report of a single coherent occurrence, such as a line pressure at a particular location, a lockout of an electrical panel, injection of a liquid into a mold at a measured temperature, an addition of a chemical to a vat, etc. Events that require user intervention may be referred to as alerts, such as an overvoltage at an electrical monitoring point (regardless of automatic safety mechanisms to reduce immediate risks), an elevator stuck between floors, or a low fluid level in a car reported in response to an electronic inquiry. Clearly, events and alerts include a vast array of possibilities, and are often represented by some automated industrial or commercial process. Events and alerts deemed important by some supervisory body or product designer are logged in whatever detail is deemed most valuable, and the increasing automation of logging certain events (pressures, voltages, volumes, robotic actions, etc.) have led to increasing volumes of data being recorded. Typically, logged events are sorted by the time of occurrence. Each box or block 200 corresponds to the occurrence of an event or an alert entered into the events log files. The width of the box corresponds to a particular time interval. When multiple events or alerts occur during the same time interval, the boxes are stacked to provide a visual presentation of multiple event occurrences during the same time interval. While boxes or blocks are shown, any other symbol may be used to indicate the occurrence of an event or alert. In addition, events and alerts can have different shapes or colors in the chart so that a user's attention is drawn to events or alerts that require intervention by the user.FIG. 2B shows a portion of a tabular listing that details the events and alerts ofFIG. 2A . Eachrow 210 corresponds to an individual event occurrence. The table includes information regarding the type, name, date and time, and written description of each event or alert shown inFIG. 2A . - As events are detected, they are simultaneously added to the event log chart and to the event log table. For example, assume the
box 202 outlined in the chart ofFIG. 2A corresponds to the selectedentry 212 that is highlighted in the event log table ofFIG. 2B . The present invention provides a two-way coupling between the graphical presentation (FIG. 2A ) and the tabular presentation (FIG. 2B ) to permit a user to select an event in a first format, either the chart or in the table, and to have automatically highlighted (or otherwise flagged) the corresponding symbol or row of the selected event in the other format. In practice, the user can select an event in the chart and then drill down and explore events in the chart. Simultaneously, the row in the table containing the event corresponding to each event selected in the chart is highlighted in the table. Alternatively, the user is able to track events or alerts in the table and as a row of the table is selected, the symbol in the chart corresponding to the event selected in the table is highlighted. - When a user selects a row containing an event of interest in the table, the symbol in the chart corresponding to the selected event is simultaneously updated and highlighted. Alternatively, the user can select the symbol in the chart for an event and the row in the table containing that event is simultaneously highlighted. Selection of a box in the chart corresponding to an event is a common investigatory technique and the corresponding row in the table is highlighted during the “fly-over” of the chart.
- It is possible to sort the events in the table and simultaneously and synchronously highlight the corresponding symbols in the chart. For example, it is possible to sort events according to event type. The left-most column of the table in
FIG. 2B includes symbols corresponding to different types of events and alerts. Sorting alerts so that they are listed at the top of the event log table, for example, is useful for the user to determine what actions are required and which actions require immediate attention. The symbols in the chart corresponding to the alerts sorted at the top of the log table are highlighted in the chart for drawing the attention of the user to those alerts. Sorting items within a table does not select any particular item, but simply reorders the rows of event data. - It is also possible to filter events. Assume, for example, that there is a pool problem. The user filters the words in the description field of the events table in
FIG. 2B for the word “pool”. Only those events in the table having the word “pool” in the description field will be displayed in the table. Simultaneously, those symbols or boxes in the chart corresponding to the events selected by the filter are highlighted in the chart. The graphical format shows the events selected by the filter in relation to the whole set of events. This view in relation to the whole provides a context and additional higher-level information to the user. - In an alternative embodiment of the invention, multiple filtering of the table of events is performed with the boxes corresponding to the different filtered results being displayed in different colors (and/or shapes or other distinguishing indicia) to make evident the results of each of the multiple filters. For example, protection-related events could be shown with one color while heal-related events could be shown in another color, thereby enabling the user to quickly correlate between the events themselves. Accordingly, protect-related events can be attended to before heal-related events.
- The invention is embodied by event log data in both a chart format and a table format. The processes for preparing the event logs in both tabular and chart formats are depicted in the
flowchart 300 inFIG. 3 . The process is performed by software controlling the event detection and monitoring system. In step 301 a conventional event log file is opened. The present invention includes parsing logic for the format of the given log file so that one event at a time can be read and interpreted. Atstep 302, the log file is examined to ascertain whether a new event has been added, which is read atstep 303 if present. An event is added as a symbol to the chart instep 304 and a new row is added to the table instep 305 corresponding to the event read from the log file. Each event in the log file will be represented by both a symbol in the chart and a row in the table. After each symbol and row pair is added, a check is made instep 302 to determine if there are additional events in the event log file that have not yet been added to the chart and table. If there are additional events, the next event is read from the event file log instep 303 and added to the chart instep 304 and to the table instep 305. The checks and the addition processes continue until there are no additional events in the event log file that have to be added to the chart and to the table at which time the process is done instep 306. - It is noted that
FIG. 3 , and this detailed description, presume that events are not originally entered in the log table but rather in a separate event log from which the log file is populated. This is a typical arrangement, in that many events are automatically performed and entered in an event log, or events are added to an event log from many disparate entry points. Where entries are made directly to the log table (e.g., where the log table serves as the event log), steps 302-303 ofFIG. 3 refer to the log table and step 305 is deleted. Similar changes to other portions of this description are relevant where the log table and the event log are one and the same. Both the log table and event log are primarily if not exclusively text documents that list events by line entries. - The simultaneous selection of events in a log chart and a log table, when a user interacts with only one of them, is described in conjunction with the
flow chart 400 inFIG. 4 (and accompanyingFIGS. 5A-5B ) and theflow chart 600 ofFIG. 6 (and accompanyingFIGS. 7A-7B ). -
FIG. 4 is a flow chart describing steps to display, on both a log chart and the log table, an event that a user selects only from a log chart.FIG. 4 is best understood with reference to the log chart ofFIG. 5A and the log table ofFIG. 5B . Referring to theflow chart 400, instep 401 the user positions a mouse pointer next to a desired symbol displayed on thechart 400, such as theblock 501 of thelog chart 500. Instep 402, a determination is made regarding which event corresponds to the selected symbol. Instep 403, information regarding the desired event is displayed in a tooltip next to the pointer, preferably only after the pointer remains stationary for a minimum threshold of time. Subsequently, the user selects thesymbol 501 by clicking on the mouse button instep 404. Instep 405, a determination is made regarding which event corresponds to the selectedsymbol 501. Therow 511 in the log table ofFIG. 5B that corresponds to the selected symbol 501 (and to the event represented by that symbol 501) is highlighted or otherwise identified atstep 406. The process is completed atstep 407. -
FIG. 6 is a flow chart describing steps to display, on both a log chart and the log table, an event that a user selects only from a log table.FIG. 5 is best understood with reference to the log chart ofFIG. 7A and the log table ofFIG. 7B . Referring to theflow chart 600, the user positions a mouse pointer at a row containing a desired event, such as theindicated row 711 of the log table 710 ofFIG. 7B . A determination is made instep 602 regarding which event corresponds to the selected event inrow 711. Instep 603, information regarding the event is displayed in a tooltip next to the mouse pointer, preferably only after the pointer remains stationary for a minimum threshold of time as noted above. Subsequently, the user selects the desiredrow 711 by clicking on the mouse button instep 604. Instep 605, a determination is made regarding which event corresponds to the selectedrow 711. Thesymbol 701 in the log chart ofFIG. 7A that corresponds to the selected row 711 (and to the event represented by that row 711) is highlighted or otherwise identified atstep 606. The process is completed atstep 607. -
FIGS. 8A-8B illustrate filtering according to one embodiment of the present invention. A user selects at the log table ofFIG. 8B afilter icon 801, drags it to a column header of acategory 802, and types a filter criteria (“pool”) into afilter parameter block 803. Thefilter parameter block 803 may allow text entries as illustrated, or may allow the user to select from a fixed list of options, such as a pulldown list. Certain filters may require actuation (such as clicking theicon 801′ nearest thefilter parameter block 803, or depressing an enter or return key), while others may take effect as the entry to thefilter parameter block 803 is made. Regardless, the filter searches for and retrieves only those events that pass the filter. InFIG. 8B ,events events 804A-D may be distinguished by a darkened background, an outline, being displayed at the top of the log chart, etc. They may also be distinguished by a change to the display of all filtered-outevents 805, such as the filtered-outevents 805 being eliminated from view (the visible horizontal lines blanked as inFIG. 8B ), changed to a reduced contrast or brightness, and the like. - Commensurate with the filtering and distinguishing of
events 804A-D in the event log ofFIG. 8B , the correspondingevents 804A′, 804B′, 804C′, and 804D′ are similarly distinguished from the filtered-outevents 805′ in the event chart ofFIG. 8B . The particular distinguishing indicia used for the log chart preferably but not necessarily carries over to the log table. As illustrated inFIG. 8A , it is preferable that the filtered-outevents 805′ still be displayed to provide context for the filtered-inevents 804A′-D′.FIG. 8A shows four filtered-inevents 804A′-D′ dispersed among 86 filtered-outevents 805′. Such a multi-event view frequently isolates problems or causal relationships among events more effectively than displaying the filtered-inevents 804A′-D′ in isolation. Preferably, the display of the log table that distinguishes filtered-inevents 804A-D from filtered-outevents 805 occurs simultaneously with the display of the log chart that distinguishes filtered-inevents 804A′-D′ from filtered-outevents 805′. Theuser inputs FIG. 8B , or of the log chart, or of the display of both or neither (a separate filter display). - Once one or
more events 804A-D, 804A′-D′ are displayed after the filtering ofFIGS. 8A-B , the user may choose to operate on only the filtered-in events, possibly by a pattern or relation that is revealed or suspected from the log chart ofFIG. 8A . This occurs inFIG. 9A-9B , where the user can ‘drill-down’ into the data of the filtered-in events to find more revealing comnmonalities or lack thereof. In the log chart ofFIG. 9B , a user may click a ‘select all’icon 901 which limits at least the next operation (e.g., another filter, copying the data to another storage location, activating a probe, marking filtered-in events for a report) to only those events currently displayed in the table, which is all the filtered-in events. In the example ofFIG. 9B , filtering by anotherparameter 903 operates only on the selectedevents 904A-D in the log table and the corresponding selectedevents 904A′-D′ in the log chart. Preferably, the ‘select all’ command further changes the display of either or both of the filtered-inevents 904A-D, 904A′-D′ and thenon-selected events FIGS. 8A-B may be used. - The invention is capable of providing tight-coupling, two-way connection and synchronous selection (and viewing) of events between the tabular format and chart format as described above. That is, the same event is indicated in both formats, regardless of whether a row is selected in the table or a symbol is selected in the chart. The same tight coupling, two-way connection between the event log table and event log chart is also accomplished when the rows of the event log table are sorted or filtered in a conventional manner.
- In the above manner, the present invention enables a user to manipulate either a tabular or a graphical presentation of the same underlying data, and view the result of the manipulation in both the tabular and graphical presentations. Where one presentation type better indicates to a user an area or event of interest (as in a pattern visible in a graphical format), the user may select one or more events in that presentation type and automatically have presented the additional information made apparent by the other presentation type (as in detailed text of a columnar entry in a table). The two-way communication between the presentations enables greater latitude in the user's ability to first identify events or groups of events of interest.
- While there has been described and several illustrated embodiments of the present invention, it will be apparent to those skilled in the art that variations and modifications are possible without deviating from the spirit and broad scope of the invention which shall be limited solely by the scope of the claims appended hereto.
Claims (22)
1-20. (canceled)
21. A memory storing a program of computer readable instructions executable by a processor for performing actions directed to controlling a display, the actions comprising:
displaying, for each of a plurality of logged events, at least a first portion of the logged event in a tabular format and at least a second portion of the logged event in a graphical format;
in response to at least one event being selected in the tabular format, changing the display of the corresponding at least one event in the graphical format;
in response to at least one event being selected in the graphical format, changing the display of the corresponding at least one event in the tabular format; and
displaying, in the graphical format, the logged events that comprise an alert requiring a user input with an indicia identifying the event as an alert and also the logged events that do not require an alert without the indicia, wherein the indicia comprises at least one of a shape, color, contrast and outline of a graphical symbol.
22. The memory of claim 21 wherein each of the plurality of logged events is displayed in the graphical format as the graphical symbol, and at least one event being selected in the graphical format comprises at least one of the graphical symbols being selected in the graphical format.
23. The memory of claim 22 wherein the graphical format defines a first axis representing time in consecutive discrete time intervals and a second axis, wherein a first and a second logged event occurring within a common discrete time interval are displayed as discrete boxes stacked along the second axis.
24. The memory of claim 21 , the actions further comprising, for each of the plurality of logged events that comprises an alert requiring a user input, displaying said at least first portion of the logged event in the graphical format with an indicia identifying the event as an alert.
25. A memory storing a program of computer readable instructions executable by a processor for performing actions directed to controlling a display, the actions comprising:
displaying, for each of a plurality of logged events, at least a first portion of the logged event in a tabular format and at least a second portion of the logged event in a graphical format;
in response to at least one event being selected in the tabular format, changing the display of the corresponding at least on event in the graphical format;
in response to at least one event being selected in the graphical format, changing the display of the corresponding at least one event in the tabular format;
filtering the plurality of logged events by a filter criteria entered within the displayed tabular format; and
displaying the logged events that pass the filtering and the logged events that do not pass the filtering in both the tabular format and the graphical format while automatically distinguishing by a displayed distinguishing indicia the logged events that pass the filtering from the logged events that do not pass the filtering in both the tabular format and the graphical format.
26. The memory of claim 25 wherein automatically distinguishing the logged events that pass the filtering from the logged events that do not pass the filtering comprises removing the logged events that do not pass the filtering from at least the tabular format display.
27. The memory of claim 25 wherein the distinguishing indicia in the graphical format comprises at least one of color or shape of a graphical symbol.
28. The memory of claim 21 , the actions further comprising:
in response to a user positioning an indicator at an event in the graphical format, displaying a tooltip proximal to the event in the graphical format that includes a text entry of the first portion.
29. The memory of claim 21 wherein changing the display of the corresponding at least one event comprises highlighting the corresponding at least one event.
30. A memory storing a program of computer readable instructions executable by a processor for performing actions directed to controlling a display, the actions comprising:
providing a display of a plurality of recorded events in both a chart format and a graphical format;
in response to selection of an event from the chart format, visually accentuating the event in both the chart format and the graphical format;
in response to selection of an event from the graphical format, visually accentuating the event in both the chart format and the graphical format; and
in response to modifying a selected event at the chart format, changing the display of the selected event in the graphical format to reflect the modification.
31. The memory of claim 30 wherein providing a display of a plurality of recorded events comprises populating said display from a separate database of recorded events, and wherein modifying a selected event at the chart format comprises updating the database from the modified selected event and subsequently refreshing the graphical format from the updated database.
32. A method comprising:
for each of a plurality of logged events in a database, displaying at least a first portion of the logged event in a tabular format and at least a second portion of the logged event in a graphical format;
in response to at least one event being selected in the tabular format, changing the display of the corresponding at least one event in the graphical format;
in response to at least one event being selected in the graphical format, changing the display of the corresponding at least one event in the tabular format; and
displaying, in the graphical format, the logged events that comprises an alert requiring a user input with an indicia identifying the event as an alert and also the logged events that do not require an alert without the indicia, wherein the indicia comprises at least one of a shape, color, contrast and outline of a graphical symbol.
33. The method of claim 32 further comprising, for each of the plurality of logged events that comprises an alert requiring a user input, displaying said at least first portion of the logged event in the graphical format with an indicia identifying the event as an alert.
34. A system for coupling a tabular display of data to a graphical display of data comprising:
a computer readable first memory to store a plurality of recorded events, each event having a first portion of data fields and a second portion of data fields wherein at least one data field is within both the first and second portion;
a processor coupled to said first memory to arrange the first portion into a tabular format and the second portion into a graphical format, said formats combined into an output signal that enables a monitor to simultaneously display said tabular format and said graphical format;
an input coupled to said processor to receive a first and a second user input that respectively selects a first and a second portion of a recorded event, and a third user input that filters the plurality of events according to one of said data fields;
a computer readable second memory coupled to said processor to store computer instructions to:
in response to each of said first and second user inputs, alter the output signal so that the recorded event selected by said user input is visually offset from other recorded events in both the tabular format and the graphical format; and
in response to the third user input, alter the output signal so that only a subset of the plurality of recorded events that is consistent with said third user input are included in said output signal
wherein the output signal enables the monitor to display the logged events that pass the filter and the logged events that do not pass the filter in both the tabular format and the graphical format while automatically distinguishing by a displayed distinguishing indicia the logged events that pass the filter from the logged events that do not pass the filter in both the tabular format and the graphical format, wherein the distinguishing indicia in the graphical format comprises at least one of a shape, color, contrast and outline of a graphical symbol.
35. The memory of claim 25 , wherein the filter criteria is one of a user text entry or a user selection from a fixed list of options.
36. The system of claim 34 , wherein the third input is displayed within the tabular format.
37. The system of claim 34 , further comprising a select-all function that operates to select only those events that pass the filter for a next operation.
38. The memory of claim 21 , the actions further comprising:
filtering the plurality of logged events by a filter criteria entered within the displayed tabular format, where the filter criteria comprises a user text entry and a user selection from a fixed pulldown list of options; and
displaying the logged events that pass the filtering and the logged events that do not pass the filtering in both the tabular format and the graphical format while automatically distinguishing by a displayed distinguishing indicia the logged events that pass the filtering from the logged events that do not pass the filtering in both the tabular format and the graphical format.
39. The memory of claim 38 where the graphical format defines a first axis representing time in consecutive discrete time intervals and a second axis, wherein a first and second logged event occurring within a common discrete time interval are displayed as discrete boxes stacked along the second axis.
40. The memory of claim 38 , the actions further comprising:
prior to an event becoming a selected event, displaying a tooltip proximal to the event in the graphical format that includes at least a text entry of the first portion of the event from the event log.
41. The memory of claim 38 where changing the display of the corresponding at least one event comprises highlighting the corresponding at least one event.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US12/195,020 US20080320409A1 (en) | 2004-02-10 | 2008-08-20 | Tightly-Coupled Synchronized Selection, Filtering, and Sorting Between Log Tables and Log Charts |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/775,376 US7446769B2 (en) | 2004-02-10 | 2004-02-10 | Tightly-coupled synchronized selection, filtering, and sorting between log tables and log charts |
US12/195,020 US20080320409A1 (en) | 2004-02-10 | 2008-08-20 | Tightly-Coupled Synchronized Selection, Filtering, and Sorting Between Log Tables and Log Charts |
Related Parent Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/775,376 Continuation US7446769B2 (en) | 2004-02-10 | 2004-02-10 | Tightly-coupled synchronized selection, filtering, and sorting between log tables and log charts |
Publications (1)
Publication Number | Publication Date |
---|---|
US20080320409A1 true US20080320409A1 (en) | 2008-12-25 |
Family
ID=34827187
Family Applications (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/775,376 Expired - Fee Related US7446769B2 (en) | 2004-02-10 | 2004-02-10 | Tightly-coupled synchronized selection, filtering, and sorting between log tables and log charts |
US12/195,020 Abandoned US20080320409A1 (en) | 2004-02-10 | 2008-08-20 | Tightly-Coupled Synchronized Selection, Filtering, and Sorting Between Log Tables and Log Charts |
Family Applications Before (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/775,376 Expired - Fee Related US7446769B2 (en) | 2004-02-10 | 2004-02-10 | Tightly-coupled synchronized selection, filtering, and sorting between log tables and log charts |
Country Status (1)
Country | Link |
---|---|
US (2) | US7446769B2 (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20110113381A1 (en) * | 2009-11-11 | 2011-05-12 | International Business Machines Corporation | Multiple check box subset selection |
US20140331179A1 (en) * | 2013-05-06 | 2014-11-06 | Microsoft Corporation | Automated Presentation of Visualized Data |
Families Citing this family (24)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7165927B2 (en) | 2002-06-19 | 2007-01-23 | Brooks Automation, Inc. | Automated material handling system for semiconductor manufacturing based on a combination of vertical carousels and overhead hoists |
KR101446511B1 (en) | 2002-10-11 | 2014-10-07 | 무라다기카이가부시끼가이샤 | Automated material handling system |
US20080126972A1 (en) * | 2005-10-26 | 2008-05-29 | Ballard Curtis C | Operator control panel event log selection |
US20070100878A1 (en) * | 2005-10-28 | 2007-05-03 | Nfr Security, Inc. | Group sorted consolidation of data in an intrusion management system |
US20090024911A1 (en) * | 2007-01-29 | 2009-01-22 | Apple Inc. | Graph data visualization tool |
US9098559B2 (en) * | 2007-08-31 | 2015-08-04 | Sap Se | Optimized visualization and analysis of tabular and multidimensional data |
US8381193B2 (en) * | 2007-09-06 | 2013-02-19 | International Business Machines Corporation | Apparatus, system, and method for visual log analysis |
WO2009034000A1 (en) * | 2007-09-11 | 2009-03-19 | Abb Ab | A system and a computer implemented method for automatically displaying process information in an industrial control system |
US8194075B2 (en) * | 2008-10-01 | 2012-06-05 | International Business Machines Corporation | Method and system for generating and displaying an interactive dynamic list view of multiply connected objects |
US8711148B2 (en) | 2008-10-01 | 2014-04-29 | International Business Machines Corporation | Method and system for generating and displaying an interactive dynamic selective view of multiply connected objects |
US8665274B2 (en) * | 2008-10-01 | 2014-03-04 | International Business Machines Corporation | Method and system for generating and displaying an interactive dynamic view of bi-directional impact analysis results for multiply connected objects |
US8669982B2 (en) * | 2008-10-01 | 2014-03-11 | International Business Machines Corporation | Method and system for generating and displaying an interactive dynamic culling graph view of multiply connected objects |
US8711147B2 (en) | 2008-10-01 | 2014-04-29 | International Business Machines Corporation | Method and system for generating and displaying an interactive dynamic graph view of multiply connected objects |
US8576218B2 (en) * | 2008-12-18 | 2013-11-05 | Microsoft Corporation | Bi-directional update of a grid and associated visualizations |
US8754889B2 (en) * | 2009-03-18 | 2014-06-17 | National Instruments Corporation | Cursor synchronization in a plurality of graphs |
US8161374B2 (en) * | 2009-10-23 | 2012-04-17 | Microsoft Corporation | Butterfly diagrams enabling multi-dimensional performance analysis |
US8510288B2 (en) | 2010-10-22 | 2013-08-13 | Microsoft Corporation | Applying analytic patterns to data |
CN102985012B (en) * | 2011-06-14 | 2015-08-05 | 株式会社东芝 | Medical image display apparatus and medical image displaying method |
US20140096085A1 (en) * | 2012-09-28 | 2014-04-03 | Andre Adam | Representing critical data fields of data table |
US9870300B2 (en) * | 2012-11-29 | 2018-01-16 | International Business Machines Corporation | Logged event frequency visualization |
US20170206268A1 (en) | 2016-01-20 | 2017-07-20 | International Business Machines Corporation | Visualization of graphical representations of log files |
EP3633603A4 (en) * | 2017-06-30 | 2020-06-17 | Shanghai United Imaging Healthcare Co., Ltd. | METHOD AND SYSTEM FOR TISSUE DENSITY ANALYSIS |
US11132378B2 (en) | 2017-11-16 | 2021-09-28 | Servicenow, Inc. | Systems and methods for interactive analysis |
US11599403B2 (en) * | 2018-10-03 | 2023-03-07 | SK Hynix Inc. | Logging mechanism for memory system |
Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US4760458A (en) * | 1983-10-17 | 1988-07-26 | Canon Kabushiki Kaisha | Image processing system |
US6199070B1 (en) * | 1998-06-18 | 2001-03-06 | International Business Machines Corporation | Using a database for program logs |
US20020083049A1 (en) * | 1998-10-05 | 2002-06-27 | Michael Forster | Data exploration system and method |
US20020184068A1 (en) * | 2001-06-04 | 2002-12-05 | Krishnan Krish R. | Communications network-enabled system and method for determining and providing solutions to meet compliance and operational risk management standards and requirements |
US20030061209A1 (en) * | 2001-09-27 | 2003-03-27 | Simon D. Raboczi | Computer user interface tool for navigation of data stored in directed graphs |
US7023440B1 (en) * | 1998-09-14 | 2006-04-04 | Fisher Rosemount Systems, Inc. | Methods and apparatus for integrated display of process events and trend data |
US7050056B2 (en) * | 2002-12-20 | 2006-05-23 | Sap Aktiengesellschaft | Interactive and web-based Gantt Chart |
US7071940B2 (en) * | 2002-10-30 | 2006-07-04 | Iviz, Inc. | Interactive data visualization and charting framework with self-detection of data commonality |
Family Cites Families (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH04243493A (en) | 1991-01-18 | 1992-08-31 | Nec Corp | Automatic graph drawing system provided with learning function |
JP2000200302A (en) | 1999-01-05 | 2000-07-18 | Nec Corp | Progress condition management system and progress condition management method |
-
2004
- 2004-02-10 US US10/775,376 patent/US7446769B2/en not_active Expired - Fee Related
-
2008
- 2008-08-20 US US12/195,020 patent/US20080320409A1/en not_active Abandoned
Patent Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US4760458A (en) * | 1983-10-17 | 1988-07-26 | Canon Kabushiki Kaisha | Image processing system |
US6199070B1 (en) * | 1998-06-18 | 2001-03-06 | International Business Machines Corporation | Using a database for program logs |
US7023440B1 (en) * | 1998-09-14 | 2006-04-04 | Fisher Rosemount Systems, Inc. | Methods and apparatus for integrated display of process events and trend data |
US20020083049A1 (en) * | 1998-10-05 | 2002-06-27 | Michael Forster | Data exploration system and method |
US20020184068A1 (en) * | 2001-06-04 | 2002-12-05 | Krishnan Krish R. | Communications network-enabled system and method for determining and providing solutions to meet compliance and operational risk management standards and requirements |
US20030061209A1 (en) * | 2001-09-27 | 2003-03-27 | Simon D. Raboczi | Computer user interface tool for navigation of data stored in directed graphs |
US7071940B2 (en) * | 2002-10-30 | 2006-07-04 | Iviz, Inc. | Interactive data visualization and charting framework with self-detection of data commonality |
US7050056B2 (en) * | 2002-12-20 | 2006-05-23 | Sap Aktiengesellschaft | Interactive and web-based Gantt Chart |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20110113381A1 (en) * | 2009-11-11 | 2011-05-12 | International Business Machines Corporation | Multiple check box subset selection |
US20140331179A1 (en) * | 2013-05-06 | 2014-11-06 | Microsoft Corporation | Automated Presentation of Visualized Data |
Also Published As
Publication number | Publication date |
---|---|
US20050177790A1 (en) | 2005-08-11 |
US7446769B2 (en) | 2008-11-04 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20080320409A1 (en) | Tightly-Coupled Synchronized Selection, Filtering, and Sorting Between Log Tables and Log Charts | |
US9984148B2 (en) | Visualization of graphical representation of log files | |
CA2617866C (en) | User interface for creating a spreadsheet data summary table | |
US7979362B2 (en) | Interactive data mining system | |
US9959267B2 (en) | Filtering user interface for a data summary table | |
US7734576B2 (en) | Apparatus and method for relating graphical representations of data tables | |
CN103678468B (en) | The system and method for improved consumption model for profiling | |
EP1922649A1 (en) | Automated placement of fields in a data summary table | |
GB2492438A (en) | System for using a graphical representation to manage record values | |
US6745140B2 (en) | Electronic test system with test results view filter | |
JP2009521060A (en) | Adaptive database system | |
US11783269B1 (en) | Systems and methods for rule management | |
US7957932B1 (en) | Data analysis systems and related methods | |
JP2006059236A (en) | Facility management apparatus and facility management program | |
US20080313557A1 (en) | System and Methods for Diagnosing and Managing Organization Change | |
JP2005165988A (en) | Table display method for managing performance evaluation index item status, table display system for managing performance evaluation index item status, and program for displaying | |
Proust | Quality and Process Methods | |
Zhang et al. | Detecting and imaging irregularities in time-series data | |
JP2005050093A (en) | Search result display program | |
CN119621223A (en) | Product-based image analysis method and image analysis device | |
Lee | Visualizations for model tracking and predictions in machine learning | |
Interface | Quick Reference Manual | |
Austin et al. | Data visualization at the individual patient level |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
STCB | Information on status: application discontinuation |
Free format text: ABANDONED -- FAILURE TO RESPOND TO AN OFFICE ACTION |