System and method for time dimension management for a data analyzing

• US 8,434,026 B2
• Filed: 05/09/2005
• Issued: 04/30/2013
• Est. Priority Date: 05/09/2005
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Stewart, Ian, Kelly, Floyd, Breedvelt-Schouten, Ilse
• Primary Examiner(s): Pesin, Boris
• Assistant Examiner(s): HEFFINGTON, JOHN M
• Application Number:
  US11/124,907
• Publication Number:
  US 20060253475A1
• Time in Patent Office: 2,913 Days
• Field of Search: 715/764, 715/776, 715/963, 715/703, 715/733, 715/765, 715/767, 715/783, 715/790, 715/794, 715/813, 715/815, 715/822, 715/823, 715/824, 715/825, 715/835
• US Class Current: 715/835
• CPC Class Codes: G06Q 10/109 Time management, e.g. calendars, reminders, meetings or time accounting

Abstract

A time dimension management system is provided for managing time dimension of a data analyzing system for analyzing data stored in a data store based on a time data structure. The time dimension management system comprises a date selector controller and a calendar coordinator. The date selector controller is provided for controlling a date selector that presents to a user a standard calendar and a business calendar. The date selector controller has a standard calendar manager for managing presentation of the standard calendar for allowing the user to select a date on the standard calendar, and a business calendar manager for managing presentation of the business calendar to represent the time data structure that the data analyzing system uses, and allowing the user to select a date on the business calendar. The calendar coordinator is provided for coordinating the standard calendar manager and the business calendar manager to indicate a selected date on the standard calendar and the business calendar.

Claims

1. A time dimension management system comprising:

a computer; and

a date selector controller, executable by the computer, to control a date selector that displays a standard calendar and a business calendar, the date selector controller comprising;

a standard calendar manager to display the standard calendar to allow user selection of a time period, the standard calendar representing a standard time data structure; and

a business calendar manager to display the business calendar, the displayed business calendar representing a business time data structure different from the standard time data structure, the business time data structure comprising two or more separate time levels, each of the two or more separate time levels representing a respective independent set of time periods, wherein each independent set of time periods is associated with a different unit of time, wherein at least one time period of one of the independent sets of time periods has a duration that is different from the time period included in the standard calendar, wherein each of the independent sets of time periods includes a respective continuum of time periods, wherein the displayed business calendar comprises multiple selectable cells each corresponding to a time period of a respective independent set of time periods, and wherein the multiple selectable cells of the displayed business calendar are graphically arranged to represent a hierarchy of the two or more time levels,

wherein the date selector controller provides a visual, side-by-side navigation of both the standard calendar and the business calendar, such that when a new time period is selected in one of the displayed standard calendar and the displayed business calendar, the date selector controller automatically updates a view of the other calendar to visually indicate the selected new time period.

2. The time dimension management system as recited in claim 1, further comprising:

a calendar coordinator, executable by the computer, to coordinate the standard calendar manager and the business calendar manager to visually indicate the selected new time period in both the standard calendar and the business calendar based at least in part on the respective standard and business time data structures,

wherein the business calendar manager further comprises a time cell handler to present the multiple selectable cells of the business calendar.

3. The time dimension management system as recited in claim 1, wherein the business calendar manager further comprises a time dimensional selection handler to present the business calendar as a time dimensional selector for selecting at least one time period in at least one of the two or more time levels.

4. The time dimension management system as recited in claim 2, wherein the calendar coordinator provides links between the time periods associated with the two or more time levels and corresponding time periods on the standard calendar.

5. The time dimension management system as recited in claim 1 further comprising a time level selection controller to control presentation of a time level selector to allow user selection of one of the two or more time levels represented by the business time data structure.

6. The time dimension management system as recited in claim 1 further comprising a validity time indication controller to control presentation of a validity time indicator.

13. The time dimension management system of claim 1,

wherein the business time data structure represents a generational hierarchy of time levels comprising one or more parent time levels and one or more child time levels, and

wherein, if a cell corresponding to one of the time periods of the parent time levels in the displayed business calendar is selected to select the new time period, the date selector controller automatically maintains a visual selection of a previously selected cell corresponding to one of the time periods of the child time level in the displayed business calendar and updates, based at least in part on the selected new time period, the view of the standard calendar to visually indicate the selected new time period.

14. The time dimension management system of claim 1,

wherein the business time data structure represents a generational hierarchy of time levels comprising one or more parent time levels and one or more child time levels,

wherein one of the parent time levels comprises a quarter time level,

wherein a child time level of the quarter time level comprises a month time level, and

wherein if a cell corresponding to a quarter time period of the quarter time level in the displayed business calendar is selected to select the new time period, the date selector controller automatically maintains a visual selection of a previously selected cell corresponding to one of the month time periods of the month time level in the displayed business calendar and updates, based at least in part on the selected new time period, the view of the standard calendar to visually indicate the selected new time period.

15. The time dimension management system of claim 14, wherein updating the view of the standard calendar to visually indicate the selected new time period comprises updating the view of the standard calendar to visually indicate the month time period of the selected new time period corresponding to the previously selected cell of the month time level.

7. A method comprising:

displaying, by a computer, a standard calendar to allow user selection on the computer of a time period, the standard calendar representing a standard time data structure;

displaying, by the computer, a business calendar that represents a business time data structure, different from the standard time data structure, the business time data structure comprising two or more separate time levels, each of the two or more separate time levels representing a respective independent set of time periods, wherein each independent set of time periods is associated with a different unit of time, wherein at least one time period of the independent sets of time periods has a duration that is different from the time period included in the standard calendar, wherein each of the independent sets of time periods includes a respective continuum of time periods, wherein the displayed business calendar comprises multiple selectable cells each corresponding to a time period of a respective independent set of time periods, and wherein the multiple selectable cells of the displayed business calendar are graphically arranged to represent a hierarchy of the two or more time levels; and

providing, by the computer, a visual, side-by-side navigation of both the standard calendar and the business calendar, such that when a new time period is selected in one of the displayed standard calendar and the displayed business calendar, a view of the other calendar is automatically updated by the computer to visually indicate the selected new time period.

8. The method as recited in claim 7, wherein providing the business calendar further comprises presenting a time dimensional selector as the business calendar, the time dimensional selector to allow user selection of at least one time period in at least one of the two or more time levels.

9. The method as recited in claim 8, further comprising providing links between the time periods associated with the two or more time levels and corresponding time periods on the standard calendar.

10. The method as recited in claim 7, further comprising controlling presentation of a time level selector to allow user selection of one of the two or more time levels represented by the business time data structure.

16. The method of claim 7,

wherein the business time data structure represents a generational hierarchy of time levels comprising one or more parent time levels and one or more child time levels, and

wherein, if a cell corresponding to one of the time periods of the parent time levels in the displayed business calendar is selected to select the new time period, the computer automatically maintains a visual selection of a previously selected cell corresponding to one of the time periods of the child time level in the displayed business calendar and updates, based at least in part on the selected new time period, the view of the standard calendar to visually indicate the selected new time period.

17. The method of claim 7,

wherein the business time data structure represents a generational hierarchy of time levels comprising one or more parent time levels and one or more child time levels,

wherein one of the parent time levels comprises a quarter time level,

wherein a child time level of the quarter time level comprises a month time level, and

wherein if a cell corresponding to a quarter time period of the quarter time level in the displayed business calendar is selected to select the new time period, the computer automatically maintains a visual selection of a previously selected cell corresponding to one of the month time periods of the month time level in the displayed business calendar and updates, based at least in part on the selected new time period, the view of the standard calendar to visually indicate the selected new time period.

18. The method of claim 17, wherein updating the view of the standard calendar to visually indicate the selected new time period comprises updating the view of the standard calendar to visually indicate the month time period of the selected new time period corresponding to the previously selected cell of the month time level.

11. A computer readable memory containing computer executable instructions that, when executed, cause a computer to:

display a standard calendar to allow user selection of a time period, the standard calendar representing a standard time data structure;

display a business calendar that represents a business time data structure, different from the standard time data structure, the business time data structure comprising two or more separate time levels, each of the two or more separate time levels representing a respective independent set of time periods, wherein each independent set of time periods is associated with a different unit of time, wherein at least one time period of one of the independent sets of time periods has a duration that is different from the time period included in the standard calendar, wherein each of the independent sets of time periods includes a respective continuum of time periods, wherein the displayed business calendar comprises multiple selectable cells each corresponding to a time period of a respective independent set of time periods, wherein each of the multiple selectable cells comprises an unlabelled cell that is displayed without any text, wherein each unlabelled cell provides a visual representation of a placement of a time period corresponding to a respective unlabelled cell within the business time data structure, and wherein the multiple selectable cells of the displayed business calendar are graphically arranged to represent a hierarchy of the two or more time levels; and

provide a visual, side-by-side navigation of both the standard calendar and the business calendar, such that when a new time period is selected in one of the displayed standard calendar and the displayed business calendar, a view of the other calendar is automatically updated to visually indicate the selected new time period.

12. A computer readable memory containing computer executable instructions that, when executed, cause a computer to:

display a standard calendar to allow user selection of a time period, the standard calendar representing a standard time data structure;

display a business calendar that represents a business time data structure, different from the standard time data structure, the business time data structure comprising two or more separate time levels, each of the two or more separate time levels representing a respective independent set of time periods, wherein each independent set of time periods is associated with a different unit of time, wherein at least one time period of one of the independent sets of time periods has a duration that is different from the time period included in the standard calendar, wherein each of the independent sets of time periods includes a respective continuum of time periods, wherein the displayed business calendar comprises multiple selectable cells each corresponding to a time period of a respective independent set of time periods, and wherein the multiple selectable cells of the displayed business calendar are graphically arranged to represent a hierarchy of the two or more time levels; and

provide a visual navigation of both the standard calendar and the business calendar, such that when a new time period is selected in one of the displayed standard calendar and the displayed business calendar, a view of the other calendar is automatically updated to visually indicate the selected new time period.

19. The computer readable memory of claim 12,

wherein the business time data structure represents a generational hierarchy of time levels comprising one or more parent time levels and one or more child time levels, and

wherein if a cell corresponding to one of the time periods of the parent time levels in the displayed business calendar is selected to select the new time period, the computer automatically maintains a visual selection of a previously selected cell corresponding to one of the time periods of the child time level in the displayed business calendar and updates, based at least in part on the selected new time period, the view of the standard calendar to visually indicate the selected new time period.

20. The computer readable memory of claim 12,

wherein the business time data structure represents a generational hierarchy of time levels comprising one or more parent time levels and one or more child time levels,

wherein one of the parent time levels comprises a quarter time level,

wherein a child time level of the quarter time level comprises a month time level, and

wherein, if a cell corresponding to a quarter time period of the quarter time level in the displayed business calendar is selected to select the new time period, the computer automatically maintains a visual selection of a previously selected cell corresponding to one of the month time periods of the month time level in the displayed business calendar and updates, based at least in part on the selected new time period, the view of the standard calendar to visually indicate the selected new time period.

21. The computer readable memory of claim 20, wherein updating the view of the standard calendar to visually indicate the selected new time period comprises updating the view of the standard calendar to visually indicate the month time period of the selected new time period corresponding to the previously selected cell of the month time level.