Data consistency in a multi-layer datawarehouse

• US 20060004801A1
• Filed: 05/03/2004
• Published: 01/05/2006
• Est. Priority Date: 05/03/2004
• Status: Abandoned Application

• Current Assignee: SAP AG (SAP SE)
• Original Assignee: SAP AG (SAP SE)
• Inventors: Dressler, Christian, Zimmerer, Peter K., Hoefer, Felix F., Lux, Matthias
• Application Number:
  US10/838,822
• Publication Number:
  US 20060004801A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

Systems, methods, and computer program products for data consistency in a database management system. A method may be provided that modifies a plurality of data packages stored in different data containers within a database management system. That method may include receiving a request at the database management system to modify a first data package in a first data container, and modifying the first data package and a second data package in a second data container based on common data in the first and second data packages. Modifying the first and second data packages may include deleting and/or invalidating the first and second data packages. Modifying the first and second data packages based on common data may include modifying the first and second data packages based on an association of the first and second data packages that is formed by a delta management system.

Claims

1. A method of modifying a plurality of data packages stored in different data containers within a database management system, the method comprising:

receiving a request at the database management system to modify a first data package in a first data container; and

modifying the first data package and a second data package in a second data container based on common data in the first and second data packages.

2. A method in accordance with the method of claim 1, wherein modifying the first and second data packages comprises deleting the first and second data packages.

3. A method in accordance with the method of claim 1, wherein modifying the first and second data packages comprises invalidating the first and second data packages.

4. A method in accordance with the method of claim 1, further comprising:

modifying an Nth data package in an Nth data container based on common data in the Nth data package and an (N−

1)th data package in an (N−

1)th data container.

5. A method in accordance with the method of claim 4, wherein modifying the Nth data package based on common data in the Nth and (N−

1)th data packages comprises modifying the Nth data package based on an association of the Nth and (N−

1)th data packages, the method further comprising;

forming at a delta management system the association of the Nth and (N−

1)th data packages based on common data in the Nth and (N−

1)th data packages.

6. A method in accordance with the method of claim 1, wherein modifying the first and second data packages based on common data comprises modifying the first and second data packages based on an association of the first and second data packages, the method further comprising:

forming at a delta management system the association of the first and second data packages based on common data in the first and second data packages.

7. A method in accordance with the method of claim 1, wherein modifying the first and second data packages comprises modifying the first and second data packages substantially in parallel.

8. A method in accordance with the method of claim 1, wherein modifying the first and second data packages comprises modifying the first and second data packages at substantially the same time.

9. A method in accordance with the method of claim 1, wherein modifying the first and second data packages comprises modifying the first data package prior to modifying the second data package.

10. A database management system comprising:

a plurality of data containers comprising at least a first data container and a second data container;

a computer system in communication with the plurality of data containers, the computer system configured to perform operations comprising;

receiving a request at the database management system to modify a first data package in the first data container; and

modifying the first data package and a second data package in the second data container based on common data in the first and second data packages.

11. A database management system in accordance with claim 10, wherein the operation of modifying the first and second data packages comprises deleting the first and second data packages.

12. A database management system in accordance with claim 10, wherein the operation of modifying the first and second data packages comprises invalidating the first and second data packages.

13. A database management system in accordance with claim 10, wherein the computer system is further configured to perform operations comprising:

modifying an Nth data package in an Nth data container based on common data in the Nth data package and an (N−

1)th data package in an (N−

1)th data container.

14. A database management system in accordance with claim 13, wherein modifying the Nth data package based on common data in the Nth and (N−

1)th data packages comprises modifying the Nth data package based on an association of the Nth and (N−

1)th data packages and the computer system is further configured to perform operations comprising;

forming at a delta management system the association of the Nth and (N−

1)th data packages based on common data in the Nth and (N−

1)th data packages.

15. A database management system in accordance with claim 10, wherein modifying the first and second data packages based on common data comprises modifying the first and second data packages based on an association of the first and second data packages, and the computer system is further configured to perform operations comprising:

forming at a delta management system the association of the first and second data packages based on common data in the first and second data packages.

16. A database management system in accordance with claim 10, wherein the operation of modifying the first and second data packages comprises modifying the first and second data packages substantially in parallel.

17. A database management system in accordance with claim 10, wherein the operation of modifying the first and second data packages comprises modifying the first and second data packages at substantially the same time.

18. A database management system in accordance with claim 10, wherein the operation of modifying the first and second data packages comprises modifying the first data package prior to modifying the second data package.

19. A computer program product, tangibly embodied on an information carrier, the computer program product comprising instructions operable to cause data processing apparatus to:

receive a request at a database management system to modify a first data package in a first data container; and

modify the first data package and a second data package in a second data container based on common data in the first and second data packages.

20. A computer program product in accordance with claim 19, wherein the instructions operable to cause data processing apparatus to modify the first and second data packages comprise instructions to delete the first and second data packages.

21. A computer program product in accordance with claim 19, wherein the instructions operable to cause data processing apparatus to modify the first and second data packages comprise instructions to invalidate the first and second data packages.

22. A computer program product in accordance with claim 19, wherein

the instructions operable to cause data processing apparatus to modify the first and second data packages based on common data comprise instructions to modify the first and second data packages based on an association of the first and second data packages;

the association is formed at a delta management system; and

the association is based on common data in the first and second data packages.

23. A computer program product in accordance with claim 19, wherein the computer program product further comprises instructions operable to cause data processing apparatus to:

modify an Nth data package in an Nth data container based on common data in the Nth data package and an (N−

1)th data package in an (N−

1)th data container.

24. A computer program product in accordance with claim 23, wherein

the instructions operable to cause data processing apparatus to modify the Nth data package based on common data in the Nth and (N−

1)th data packages comprise instructions to modify the Nth data package based on an association of the Nth and (N−

1)th data packages;

the association is formed at a delta management system; and

the association is based on common data in the Nth and (N−

1)th data packages.