Visual representation of a cell-based calendar transparently overlaid with event visual indicators for mining data records

• US 9,460,444 B2
• Filed: 09/03/2010
• Issued: 10/04/2016
• Est. Priority Date: 09/03/2010
• Status: Active Grant

• Current Assignee: Micro Focus LLC (Open Text Corporation)
• Original Assignee: Hewlett Packard Enterprise Development LP (Hewlett-Packard Enterprise Company)
• Inventors: Hao, Ming C., Dayal, Umeshwar, Haug, Lars-Erik, Rohrdantz, Christian
• Primary Examiner(s): Joseph, Shawn S
• Application Number:
  US12/807,378
• Publication Number:
  US 20120060080A1
• Time in Patent Office: 2,223 Days
• Field of Search: 715/217
• US Class Current: 1/1
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06Q 30/0203 Market surveys; Market polls

Abstract

A system causes display of a visual representation of a cell-based calendar having cells representing data records, where the cells have corresponding visual indicators corresponding to values of the respective data records. The cells are arranged in plural blocks corresponding to time intervals of the cell-based calendar. Event visual indicators transparently overlay cells in at least some of the plural blocks, where the event visual indicators represent events that occurred in time intervals corresponding to the at least some blocks. The events are separate from activities represented by the data records. Providing the event visual indicators transparently overlaid over the cells in the at least some blocks depict a relationship and relative impact between the data records and the events.

Claims

1. A method for mining data records comprising:

causing, by a system having a processor, display of a visual representation of a cell-based calendar having cells representing the data records, wherein the cells have corresponding visual indicators corresponding to values of the respective data records;

arranging the cells in plural blocks corresponding to time intervals of the cell-based calendar; and

providing event visual indicators that transparently overlay cells in at least some of the plural blocks, wherein the event visual indicators represent events that occurred in time intervals corresponding to the at least some blocks, wherein the events are separate from activities represented by the data records, and wherein providing the event visual indicators transparently overlaid over the cells in the at least some blocks depict a relationship and relative impact between the data records and the events.

2. The method of claim 1, wherein the cell-based calendar has rows and columns, wherein the rows represent first time intervals, and the columns represent sub-intervals of the first time intervals.

3. The method of claim 1, further comprising allowing interaction with the visual representation of the cell-based calendar that allows for mining of the data records without having to individually read the data records.

4. The method of claim 1, wherein providing the event visual indicators comprises providing transparencies over the at least some blocks, the transparencies having respective different colors to represent different types of the events.

5. The method of claim 4, wherein the visual indicators of the cells comprise different colors to represent corresponding different values of the data records.

6. The method of claim 1, wherein the blocks are arranged into plural segments that correspond to different attributes in the data records over time.

7. The method of claim 1, wherein the data records correspond to customer surveys, and wherein displaying the visual representation of the cell-based calendar allows for an understanding of feedback provided in the customer surveys without having to read the customer surveys individually, and wherein the cells in the at least some blocks have different visual indicators based on respective different values of an attribute in the corresponding customer surveys.

8. The method of claim 1, further comprising:

receiving a selection to drill down into a portion of the cell-based calendar; and

causing display of a second visual representation of the portion, wherein the second visual representation has at least one axis that differs from a corresponding axis of the cell-based calendar.

21. The method of claim 1, further comprising:

receiving, by the system, the data records from at least one data source over a network.

9. An article comprising at least one non-transitory computer-readable storage medium storing instructions that upon execution cause a computer to:

present for display a first visual representation of a calendar having a first axis representing first time intervals and a second axis representing second time intervals, wherein the calendar has blocks of cells, and wherein the cells have respective visual indicators representing corresponding values of corresponding activities;

integrate, into the first visual representation, event visual indicators that represent respective events, wherein the event visual indicators are transparently overlaid over the cells in respective ones of at least some of the blocks;

receive a selection to drill down into a portion of the calendar; and

present for display a second visual representation of the portion, wherein the second visual representation has a first axis and a second axis at least one of which differs from the corresponding first axis and second axis of the calendar.

10. The article of claim 9, wherein the instructions upon execution cause the computer to further:

detect additional events; and

add additional event visual indicators to the first visual representation for the respective detected additional events.

11. The article of claim 9, wherein the event visual indicators are transparency colors, and the visual indicators of the cells are colors corresponding to values of an attribute corresponding to the activities.

12. The article of claim 9, wherein the event visual indicators overlaying the cells in the at least some blocks provide a depiction of a relationship and relative impact between the activities and the events that are external to the activities.

13. The article of claim 9, wherein the instructions upon execution cause the computer to further:

receive data records containing the values of corresponding activities,

wherein presenting for display the first visual representation comprises performing real-time display of the data records in the first visual representation.

14. The article of claim 9, wherein the event visual indicators that represent respective events comprise different transparency colors, wherein the different transparency colors represent corresponding different types of events.

15. The article of claim 9, wherein each of the event visual indicators overlays cells in at least one of the blocks based on a time associated with the corresponding event.

16. The article of claim 9, wherein the calendar has plural rows, wherein each row has multiple sub-rows containing cells for respective multiple, different attributes.

17. The article of claim 16, wherein each of the sub-rows has plural ones of the blocks that contain cells of a corresponding one of the attributes, and wherein one of the event visual indicators overlays cells in a group of the blocks for the multiple attributes.

18. A system comprising:

at least one processor; and

a calendar-based visualization module executable on the at least one processor to;

cause display of a visual representation of a cell-based calendar having cells representing data records, wherein the cells have corresponding visual indicators corresponding to attribute values of the respective data records;

arrange the cells in plural blocks corresponding to time intervals of the cell-based calendar; and

provide event visual indicators that transparently overlay the cells in at least some of the plural blocks, where the event visual indicators represent external events separate from activities represented by the data records, wherein positioning of the event visual indicators is based on time of occurrence of the corresponding events, and where providing the event visual indicators transparently overlaid over the cells in the at least some blocks depicts a relationship and relative impact between the data records and the events.

19. The system of claim 18, wherein the event visual indicators comprise transparency colors, wherein a transparency color overlaid over cells in a particular one of the at least some blocks allows the cells of the particular block to be visible through the transparency color.

20. The system of claim 18, wherein different transparency colors represent different types of external events.