Administration of planning file entries in planning systems with concurrent transactions

• US 20080147666A1
• Filed: 12/15/2006
• Published: 06/19/2008
• Est. Priority Date: 12/15/2006
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Wiethoff, Andreas, Reusch, Hans-Georg, Soehner, Volkmar A.
• Granted Patent: US 7,822,792 B2
• Time in Patent Office: Days
• US Class Current: 707/8
• CPC Class Codes: G06F 16/2308 Concurrency control transaction processing G06F9/466
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

After a transaction modifying a planning area in a planning system is initiated, it is determined whether there are any change objects in a consistent view of the transaction that are associated with the planning area. If there is a single change object associated with the planning area, then, the logical state of such change object is read. Alternatively, if there is more than one change object for the planning area, it is determined that the planning area must be replanned. Related apparatus, systems, methods, and articles are also described.

Claims

1. An article comprising a tangible machine-readable medium operable to cause data processing apparatus to perform operations comprising:

initiating a transaction modifying a planning area in a planning system;

determining whether there are any change objects in a consistent view of the transaction that are associated with the planning area; and

reading a logical state from a single change object to determine whether the planning area must be replanned if there is only one change object associated with the planning area;

or

determining that planning area must be replanned if there is more than one change object associated with the planning area.

2. An article as in claim 1, wherein the article is further operable to cause data processing apparatus to perform operations comprising:

generating an updated change object identifying a logical state of the planning area.

3. An article as in claim 2, wherein the updated change object is generated before the initiated transaction has been committed.

4. An article as in claim 2, wherein the article is further operable to cause data processing apparatus to perform operations comprising:

deleting any change objects for the planning area created prior to the consistent view of the initiated transaction.

5. An article as in claim 2, wherein the logical state of the generated change object comprises a flag, and wherein a first state of the flag indicates that the planning area does not require replanning, and a second state of the flag indicates that replanning is required for the planning area.

6. An article as in claim 1, wherein the article is further operable to cause data processing apparatus to perform operations comprising:

determining that replanning is not necessary if the there is no change object visible for the planning area.

7. A computer-implemented method comprising:

initiating a transaction modifying a planning area in a planning system;

determining whether there are any change objects in a consistent view of the transaction that are associated with the planning area; and

reading a logical state from a single change object to determine whether the planning area must be replanned if there is only one change object associated with the planning area;

or

determining that planning area must be replanned if there is more than one change object associated with the planning area.

8. A method as in claim 7, further comprising:

generating an updated change object identifying a logical state of the planning area.

9. A method as in claim 8, wherein the updated change object is generated before the initiated transaction has been committed.

10. A method as in claim 8, further comprising:

deleting any change objects for the planning area created prior to the consistent view of the current transaction.

11. A method as in claim 8, wherein the logical state of the generated change object comprises a flag, and wherein a first state of the flag indicates that the planning area does not require replanning, and a second state of the flag indicates that replanning is required for the planning area.

12. A method as in claim 7, further comprising:

determining that replanning is not necessary if the there is no change object visible for the planning area.

13. An article comprising a machine-readable medium embodying instructions that when performed by one or more machines result in operations comprising:

initiating a transaction modifying a set of data in a database;

determining whether there are any change objects in a consistent view of the transaction that are associated with the set of data; and

reading a logical state from a single change object if there is only one change object associated with the set of data;

or

determining that the set of data must be recalculated if there is more than one change object associated with the set of data.

14. An article as in claim 13, wherein the database is part of a planning system.

15. An article as in claim 13, wherein the article is further operable to cause data processing apparatus to perform operations comprising:

generating an updated change object identifying a logical state of the set of data.

16. An article as in claim 15, wherein the updated change object is generated before the initiated transaction has been committed.

17. An article as in claim 15, wherein the article is further operable to cause data processing apparatus to perform operations comprising:

deleting any change objects for the set of data created prior to the consistent view of the transaction.

18. An article as in claim 13, wherein the logical state of the generated change object comprises a flag, and wherein a first state of the flag indicates that the planning area does not require replanning, and a second state of the flag indicates that replanning is required for the planning area.

19. An article comprising a tangible machine-readable medium operable to cause data processing apparatus to perform operations comprising:

initiating a first transaction modifying data in a first plurality of planning areas of a planning system; and

generating a change object for each of the plurality of planning areas, each change object characterizing whether the associated planning area requires replanning.

20. An article as in claim 19, wherein the article is further operable to cause data processing apparatus to perform operations comprising:

initiating a second transaction modifying a second plurality of planning areas of the planning system;

determining whether there are pre-existing change objects in a consistent view of the second transaction that are associated with each of the second plurality of planning areas; and

reading a logical state from a single change object if there is only one pre-existing change object associated with those planning areas in the second plurality of planning areas in order to determine whether each such planning area must be replanned;

or

determining that planning areas must be replanned if there is more one than pre-existing change object associated with such planning areas.

21. An article as in claim 19, wherein the change object is generated before the transaction has been committed.