Processor and data storage enabling efficient data reporting

• US 10,510,033 B2
• Filed: 10/02/2015
• Issued: 12/17/2019
• Est. Priority Date: 10/02/2015
• Status: Active Grant

• Current Assignee: Avaya Incorporated
• Original Assignee: Avaya Incorporated
• Inventors: Miryala, Sreekanth
• Primary Examiner(s): Tran, Anhtai V
• Application Number:
  US14/873,412
• Publication Number:
  US 20170097965A1
• Time in Patent Office: 1,537 Days
• Field of Search: None
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: G06F 17/40 Data acquisition and logging for input to computer G06F3/00
• CPC Class Codes: G06F 2201/86 Event-based monitoring
• CPC Class Codes: G06Q 10/0639 Performance analysis of employees; Performance analysis of enterprise or organisation operations

Abstract

Even with modern high-speed processors and bandwidth, many systems implement intensive data reporting components that tax resources. Even very small improvements in reporting efficiencies can result in significant cost and resource savings, as well as improvements in the performance of such resources. Recording facts (e.g., events) with a standardized time and time interval based upon a universal reference, such as Coordinated Universal Time (UTC), and reporting based upon local time and local intervals improves data processing throughput with limited report granularity. For example, since forty-eight intervals comprise most of the world'"'"'s time zones, reports simply designating facts as occurring within one of the forty-eight intervals and one of the thirty-minute intervals greatly improves operability and throughput.

Claims

1. A system, comprising:

a computer-readable expression of a fact record comprising;

a fact detail;

a fact date as observed in Coordinated Universal Time (UTC); and

a fact interval identifying one of a number of day-segment intervals of a calendar date as observed in UTC, wherein the number of day-segmenting intervals are uniform and more than five and less than sixty minutes;

a computer-readable expression of a time zone map comprising a record further comprising;

a time zone key indicating a selected global time zone;

a date key indicating a UTC date;

an interval key identifying one of the number of the day-segmenting intervals;

a UTC date key;

a UTC interval key; and

wherein the UTC date key and UTC interval keys identify a local date and a local interval for an associated value for the time zone key, date key, and interval key; and

a server that accesses a time zone and generates a report for the fact comprising the fact detail and translating the fact date and fact interval via accessing the associated combination of the UTC date key and UTC interval key and reporting the fact detail as occurring on the date indicated by the UTC date key and the time of occurrence as the UTC interval key and wherein the server further accesses a date interval key comprising a first concatenation with the date key and wherein the report is generated for facts having a second concatenation comprising the fact date and fact interval and the first concatenation matches the second concatenation.

2. The system of claim 1, wherein the time zone key comprises a value selected from the range of one to the number of day-segment intervals.

3. The system of claim 2, wherein the number of day-segment intervals is forty-eight and the interval key is a thirty-minute interval.

4. The system of claim 1, wherein the fact further comprises a sub-interval unit of time and the server reports the fact as occurring with a value comprised of the sub-interval unit of time and the UTC interval key.

5. The system of claim 1, further comprising a first database comprising the computer-readable expression of the fact record.

6. The system of claim 5, wherein the first database comprises a plurality of the fact records.

7. The system of claim 1, further comprising a second database comprising the computer-readable expression of a time zone map.

8. The system of claim 5, wherein the first database comprises a plurality of the time zone map records, each associated with one time zone.

9. A method, comprising:

accessing a fact record comprising;

a fact detail;

a fact date as observed in Coordinated Universal Time (UTC); and

a fact interval identifying one of a number of day-segment intervals of a calendar date as observed in UTC, wherein the number of day-segmenting intervals are uniform and more than five and less than sixty minutes;

accessing a time zone map comprising a record further comprising;

a time zone key indicating a selected global time zone;

a date key indicating a UTC date;

an interval key identifying one of the number of the day-segment intervals;

a UTC date key;

a UTC interval key; and

wherein the UTC date key and UTC interval keys identify a local date and a local interval for an associated value for the time zone key, date key, and interval key; and

generating a report for the fact comprising the fact detail and translating the fact date and fact interval via accessing the associated combination of the UTC date key and UTC interval key and reporting the fact detail as occurring on the date indicated by the UTC date key and the time of occurrence as the UTC interval key;

creating a first concatenation of the date interval key and the date key; and

creating a second concatenation of the fact date and fact interval; and

wherein generating the report further comprises generating a report for facts associated with the second concatenation matching the first concatenation.

10. The method of claim 9, wherein the time zone key comprises a value selected from the range of one to the number of day-segment intervals.

11. The method of claim 10, wherein number of day-segment intervals is forty-eight and the interval key is a thirty-minute interval.

12. The method of claim 9, wherein the fact further comprises a sub-interval unit of time and the server reports the fact as occurring at a value comprised of the sub-interval unit of time and the UTC interval key.

13. The method of claim 9, further comprising:

receiving the fact detail from a data reporting component;

accessing a UTC time of the fact;

accessing a UTC date of the fact;

storing in the fact record the UTC date as the date; and

storing in the fact record the UTC time divided by the number of day-segment intervals interval as fact interval.

14. A non-transitory computer-readable medium comprising instructions thereon that when read by a computer cause the computer to perform:

accessing a fact record comprising;

a fact detail;

a fact date as observed in Coordinated Universal Time (UTC); and

a fact interval identifying one of a number of day-segment intervals of a calendar date as observed in UTC, wherein the number of day-segmenting intervals are uniform and more than five and less than sixty minutes;

accessing a time zone map comprising a record further comprising;

a time zone key indicating a selected global time zone;

a date key indicating a UTC date;

an interval key identifying one of the number of the day-segment intervals;

a UTC date key; and

a UTC interval key; and

wherein the UTC date key and UTC interval keys identify a local date and a local interval for an associated value for the time zone key, date key, and interval key; and

generating a report for the fact comprising the fact detail and translating the fact date and fact interval via accessing the associated combination of the UTC date key and UTC interval key and reporting the fact detail as occurring on the date indicated by the UTC date key and the time of occurrence as the UTC interval key; and

accessing a date interval key comprising a first concatenation with the date key and wherein the report is generated for facts having a second concatenation comprising the fact date and fact interval and wherein the first concatenation matches the second concatenation.

15. The non-transitory computer-readable medium of claim 14, wherein the time zone key comprises a value selected from the range of one to the number of day-segment intervals.

16. The non-transitory computer-readable medium of claim 14, wherein number of day-segment intervals is forty-eight and the interval key is a thirty-minute interval.

17. The non-transitory computer-readable medium of claim 14, wherein the fact further comprises a sub-interval unit of time and the instructions further report the fact as occurring at a value comprised of the sub-interval unit of time and the UTC interval key.

18. The non-transitory computer-readable medium of claim 14, further comprising instructions to access a first database comprising the computer-readable expression of the fact record.