Skip to Content
0
Former Member
Oct 04, 2009 at 12:31 AM

Sequence of operations - Direct Delta, Queued Delta, Unserialized V3 Update

40 Views

Is the below understanding about each update method correct?

a) Direct Delta

- The user selects a process (e.g. creating, updating or deleting a purchase order), fills the fields in the screen, presses SAVE.

- A module makes inserts, updates and deletes on the Application Tables.

- This or another module inserts delta relevant information (e.g.: before and after image, the key for deletion, reverse image, etc) about this PO in the Communication Structures.

- Another module reads the Comm Structures and inserts this information in the Delta Queue.

- COMMIT the operations in the App Tables and in the Delta Queue.

- The user receives a success message.

b) Queued Delta

- The user selects a process, fills the fields in the screen, presses SAVE.

- A module makes inserts, updates and deletes on the App Tables.

- This or another module inserts delta relevant information about this PO in the Comm Structures.

- Another module reads the Comm Structures and inserts this information in the Extraction Queue.

- COMMIT the operations in the App Tables and in the Extraction Queue.

- The user receives a success message.

- Periodically, a Collective Run inserts this information in the Delta Queue and deletes it from the Extraction Queue.

c) Unserialized V3 Update

- The user selects a process, fills the fields in the screen, presses SAVE.

- A module makes inserts, updates and deletes on the App Tables.

- COMMIT the operations in the App Tables.

- The user receives a success message.

- This or another module inserts delta relevant information about this PO in the Comm Structures.

- Another module reads the Comm Structures and inserts this information in the Information Structures (also known as Statistical Tables), as part of the LIS data flow u2013 as I understand it has nothing to do with LO data extraction, but it is coded this way.

- If the inserts into the Information Structures work well, another module reads the Comm Structures and inserts this information in the Update Table.

- Periodically, a Collective Run inserts this information in the Delta Queue and deletes it from the Update Table.

Thanks

César Menezes