Translating time-independent data using database operations

• US 20070094233A1
• Filed: 12/28/2005
• Published: 04/26/2007
• Est. Priority Date: 10/24/2005
• Status: Abandoned Application

• Current Assignee: SAP AG (SAP SE)
• Original Assignee: SAP AG (SAP SE)
• Inventors: Otter, Wolfgang, Dipper, Stefan, Rueger, Christel, Hagen, Tobias
• Application Number:
  US11/321,720
• Publication Number:
  US 20070094233A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2456 Join operations
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A method and system for linking the contents of two or more at least partially time-independent tables in a multidimensional data source are disclosed. A join operation is generated for the two or more at least partially time-independent tables. The join operation includes a query instruction that is executable on the multidimensional data source, and the query instruction has at least one time attribute. A pseudo time dependency between the two or more at least partially time-independent tables is determined. A time interval for the join operation is generated based on the pseudo time dependency. The join operation is then executed using the time interval as the at least one time attribute.

Claims

1. A computer-implemented method of linking the contents of two or more at least partially time-independent tables in a multidimensional data source, the method comprising:

generating a join operation for the two or more at least partially time-independent tables, the join operation including a query instruction executable on the multidimensional data source, the query instruction having at least one time attribute;

determining a pseudo time dependency between the two or more at least partially time-independent tables;

generating a time interval for the join operation based on the pseudo time dependency; and

executing the join operation using the time interval as the at least one time attribute.

2. A computer-implemented method in accordance with claim 1, wherein the join operation is an inner join operation.

3. A computer-implemented method in accordance with claim 1, wherein the join operation is a left outer join operation.

4. A computer-implemented method in accordance with claim 2, wherein the at least one time attribute is based on a date.

5. A computer-implemented method in accordance with claim 2, wherein the at least one time attribute is based on a time.

6. A computer-implemented method in accordance with claim 3, wherein the at least one time attribute is based on a date.

7. A computer-implemented method in accordance with claim 3, wherein the at least one time attribute is based on a time.

8. A computer-implemented method in accordance with claim 1, wherein executing the join operation includes:

determining a result set of the join operation, the result set including a plurality of data records; and

determining a pseudo time-dependent record based on the result set.

9. A computer-implemented method in accordance with claim 8, wherein executing the join operation further includes:

calculating a new time interval based on the pseudo time-dependent record;

determining if the new time interval overlaps a previous time interval generated from the pseudo time dependency;

retaining each data record of the plurality of data records if the new time interval overlaps the previous time interval generated from the pseudo time dependency; and

initializing each data record of the plurality of data records if the new time interval does not overlap the previous time interval generated from the pseudo time dependency.

10. A computer-implemented method in accordance with claim 9, wherein executing the join operation further includes:

recalculating the new time interval based on the overlap of the previous time interval with a previous new time interval; and

determining a new result set of the join operation.

11. A computer-implemented method of linking the contents of two or more at least partially time-independent tables in a multidimensional data source, the method comprising:

determining a pseudo time dependency between the two or more at least partially time-independent tables;

generating a first time interval for the join operation based on the pseudo time dependency; and

executing a join operation using the first time interval.

12. A computer-implemented method in accordance with claim 11, wherein executing the join operation includes:

determining a result set of the join operation, the result set including a plurality of data records; and

determining a pseudo time-dependent record based on the result set.

13. A computer-implemented method in accordance with claim 12, wherein executing the join operation further includes:

calculating a new time interval based on the pseudo time-dependent record;

determining if the new time interval overlaps the first time interval;

retaining each data record of the plurality of data records if the new time interval overlaps the first time interval; and

initializing each data record of the plurality of data records if the new time interval does not overlap the first time interval.

14. A computer-implemented method in accordance with claim 13, wherein executing the join operation further includes:

recalculating the new time interval based on the overlap of the previous time interval with a previous time interval; and

determining a new result set of the join operation.

15. A computer-implemented method in accordance with claim 14, wherein executing the join operation further includes:

sorting the new result set of the join operation; and

displaying the sorted new result set on a display.

16. A computer program product, tangible embodied on a computer-readable medium, operable to cause a data processing apparatus to:

determine a pseudo time dependency between the two or more at least partially time-independent tables;

generate a first time interval for the join operation based on the pseudo time dependency; and

execute a join operation using the first time interval.

17. A computer program product in accordance with claim 16, further comprising a code module configured to cause the computer to generate the join operation for the two or more at least partially time-independent tables, the join operation including a query instruction executable on the multidimensional data source, the query instruction having at least one time attribute.

18. A computer program product in accordance with claim 17, wherein the at least one time attribute includes the first time interval.

19. A computer program product in accordance with claim 17, wherein the join operation is an inner join operation.

20. A computer program product in accordance with claim 17, wherein the join operation is a left outer join operation.