Chap. 7. Cases where extended transactions are recommended:

1. Chap. 7. Cases where extended transactions are recommended: • ERP systems • E-commerce • Mobile-commerce • Patient records/Elektronisk patientjournal • Airline reservation systems • CSCW systemer • Distributed calender systems • Mobile applications • Supply chain management • Library systems • Banking systems

2. Enterprise Resource Planning(ERP)

3. A distributed modular ERP system have relaxed ACID properties across the autonomous databases of the ERP modules. Exercise:How would you implement relaxed ACID properties between the modules?

4. A distributed modular ERP system have relaxed ACID properties across the autonomous databases of the ERP modules. Exercise:How would you replicate the department table?

5. A data model for an integrated E-commerce/ERP system: Exercise.Suppose a distributed modular ERP system has Sale, Accounting, Procurement, and CRM modules. What tables/table fragments should these modules own?

6. Exercise: How would you implement relaxed ACID properties in the E-Government module?

7. Concept definitions used in logistic exercise: Pallet = wooden skeleton where packages may be stored in such a way that they all can be moved by a truck. Collie = alle the packages that are stored on a pallet(palle). Leg = Route or subroute where the transportation does not have stops

8. ER-diagram of a logistics management system Transport Orders Orderlines Customers Route-leg hierarchy from to from Packages, Collies and Containers Routes and legs Locations to Transport operator Damagerelationship Physical containers Package- Collie hierarchy Container-routes relationships of order 3 Scheduled routes and legs Transport medias like ships, airplanes, and trucks. How should the transport orders and sub-orders to sub-contractors be replicated in order to optimize the transports?

9. Global ER-diagram of integrated logistics management Transport Orders Orderlines Customers Route-leg hierarchy from to from Packages, Collies and Containers Routes and legs Locations to Transport operator Damagerelationship Physical containers Package- Collie hierarchy Container-routes relationships of order 3 Scheduled routes and legs Transport medias like ships, airplanes, and trucks. Describe the local databases in the central location of the transport company, the locations of the sub-contractors, and the mobile locations of the Transport medias. Design a workflow with focus on the integration of the local database locations.

10. Petri net:Work flowof a global E-commerce transactions where the stocks are in the locations of the different suppliers. OR split

11. Sub- Petri net of activity 2 AND split AND join OR split May the suppliers be transport sub-contractors?

12. Global ER-diagram of integrated logistics management Transport Orders Orderlines Customers Route-leg hierarchy from to from Packages, Collies and Containers Routes and legs Locations to Transport operator Damagerelationship Physical containers Package- Collie hierarchy Container-routes relationships of order 3 Scheduled routes and legs Transport medias like ships, airplanes, and trucks. How would you recommend to integrate and later merge the shipping companies Maersk and P&O Nedlloyd if Maersk had used the logistics architecture above?

13. Exercise. Suppose a production firm has central planning and de-central production. How would you recommend to design the planning and production modules of a distributed modular ERP system that support the organization of the compamy?

14. Exercise: How would you implement/replicate the tables Network Branches?

15. Design a modile distributed calender system! ER-diagram of an integrated calender and meating system:

16. Exercise: How would you implement relaxed ACID properties in the Supplier module?

17. Exercise: Describe and design the local databases for a distributed brewery with many different production, sale and depot locations. Can a distributed modular ERP system bee used to integrate the different locations?

18. EHR records should be craeted by Hospital service modules that are exchangable as the modules in a distributed modular ERP system. That is, Hospital service modules should offer and only use reading, compensatable, and retriable SOA services from other modules. Electronic Health Records (EHR)

19. Suppose all Health records are owned by the ”CRM module”. How would you recommend to integrate a new module that make test results that later are used for making diagnoses? How would you recommend to integrate the diagnose module? How would you recommend to integrate the Surgery planning module and the Surgery module itself? Electronic Health Records (EHR)

22. The 0-safe design with local commit: The 0-safe design with local commit is recommended when it is possible to implement sufficient local countermeasures against the isolation anomalies. Example.

23. The 0-safe design with deferred commit: The 0-safe design with deferred commit is recommended when update delays should be minimized, and when it is not possible to implement sufficient local countermeasures against the isolation anomalies. Example.

24. Health Records Database Entities with different versions of 0-safe design Deffered commit Local commit

25. Entities with different versions of 0-safe design Entities with the basic 1-safe design

26. Overview of the most important EHR integr. architectures

34. Overview of the most important EHR integr. architectures

35. Countermeasures against missing isolation property

36. Properties of different EHR database design methods

37. EHR Datawarehouse:

38. Properties of different EHR database design methods

39. Chap. 7. EHR integration with ERP:

40. Design a Distributed Airline Database Design local databases and the workflow of an integrated distributed database that integrate the e-commerce sale of different airline companies in a way that optimize performance, availability and consistency of a common distributed airline system with local databases in the airline companies, airports, and “sale offices” at e.g. travel agents, hotels and e-commerce servers. (Do not use a GDS in this exercise).

41. Exercise: Design local databases and the workflow of an integrated distributed database that integrate the e-commerce sale of different airline companies, hotel chains in a way that optimize performance, availability and consistency of a common distributed system with local databases in the airline companies, hotel chains, airports, car rental companies, and “sale offices” at e.g. travel agents, hotels and e-commerce servers. (Do not use a GDS in this exercise). Describe the workflow of the integrated e-commerce system.

42. Exercise How would you recommend integrating two airline companies? Does it make any difference whether the companies are in alliance or not? What problems may occur if travel arrangements are converted while some of the flights are not finished yet? Can the ideas of a distributed modular ERP system be used?

43. Exercise: A GDS (Global Distribution Service) is a worldwide computerized reservation system for reserving airline tickets, hotel rooms, rental cars, and other travel related items. The largest GDSs are Amadeus, Galileo, Sabre, and Worldspan. Design an integrated distributed database that integrate the databases of different airline companies and hotel chains in a way that optimize performance, availability and consistency of a common distributed system with local databases in GDSs, the airline companies, hotel chains, airports, and “sale offices” at e.g. travel agents, hotels and e-commerce servers. The relationships of the diagram illustrate that a travel product stored in one system may be stored in many other systems from where data are replicated in sequence from left to right between the different types of systems. How would you design relaxed ACID properties in the global distributed system?

44. How would you design a workflow for flexible transactions? Root transaction Committing subtransaction

45. Routing by using flexible transactions. Question 1. Describe a Petri net workflow for flexible transactions. Question 2. Change the Petri net workflow in such a way that it also functions for recovered transactions. Syntax for the State diagram: Event [condition] Action

46. Workflow of flexible transactions.

47. Input Workflow for making mobile control of supplier deliveries. Input is supplier orders or deliveries. New Supplier orders. Reduced product delivery Product deliveries Delivery larger than ordered ANDSPLIT Accepted product deliveries Orderlines are replicated to the mobile controllers Select a con-trol action Update the local stock ANDJOIN Delivery matches an Orderline Accepted product deliveries Reduced orderline Orderlines Delivery less than ordered ANDSPLIT Replicate the mobile registrations to the central ERP system What is the most important part of the workflow from a system integration point of view? Delivery is not ordered Error reports End of workflow

48. Input Workflow for making mobile control of supplier deliveries. Input is supplier orders or deliveries. New Supplier orders. Reduced product delivery Product deliveries Delivery larger than ordered ANDSPLIT Accepted product deliveries Orderlines are replicated to the mobile controllers Select a con-trol action Update the local stock ANDJOIN Delivery matches an Orderline Accepted product deliveries Reduced orderline Orderlines Delivery less than ordered ANDSPLIT Replicate the mobile registrations to the central ERP system How would you implement the database of the workflow? Delivery is not ordered Error reports End of workflow

49. A:

50. Allokation of fragments: Allocation is the physical placement of fragments in different locations. Allocated fragments may be redundant. Exercise:How are the tables fragmented and allocated in a distributed ERP system? Can the Product and Product stock tables be integrated to a single table locally? Can a DDBMS allocate fragments from different tables in a single local table?