COMP3760/6760: Enterprise Systems Integration
Assignment 3 (Group Assignment): System Integration
Task 1 Web Service Design (4 marks)
Suppose you are wrapping the GSO support process (figure 1) as a web service, which allows a user to create a
request for an incident raised. You are required to:
• Identify the two necessary functions of this GSO service;
• For each of the above functions, identify the input/output messages;
• Use WSDL interface definition constructs to specify the above identified functions with input/output
Task 2 XML Schema Design (4 marks)
For the above input/output messages, write their XML Schemas. You need to include the following:
• Two different ways of specifying complex types, one is defined inside the element, the other defines a
complex type first, then (re-)uses it as a complex type of an element;
• Use constraints on the values of a simple typed element, on the occurrence of elements;
• Pick up one xml schema, construct a sample xml document.
Task 3 EAI and Database Integration (4 marks)
Suppose LCPL’s head office in Sydney maintains a personnel database containing information such as Senior
Planners, Optimisation Manager, Planners, Site Engineer, Planning Manager, Scheduler, Systems Analyst and
Business Analyst along with their detailed information. Other sites have their own databases containing
information on projects undertaken, issues and incidents reported, changes made and staff in charge of issues to
be resolved etc. In order to support the need of business analysis, LCPL sees a need to integrate systems running
across Australia and New Zealand. The objective of business analysis is to allow managers to make better
decisions on the project chosen, supply management and human resource management.
For example, suppose an applicant wishes to check the frequencies of various issues reported in the system and
the information on staff assigned to those issues. This request would actually require data from multiple
disparate back-end systems and different sites. In this case, there is a need to decompose the request into
multiple requests to be sent to the different back-end database applications, gather the information sent back, and
assemble this information in the form of a single uniformed response (i.e. recompose).
• Design simple database schemas for the above scenario and explain what kind of integration technique
you would use. Assume the back-end databases are relational.
• Design and draw a tiered EAI system handling this situation whereby users gain direct access to business
applications and data.
• Explain how queries will be decomposed and replies recomposed. You may make the necessary
Task 4 Discussion (4 marks, @ 600 words)
“LCPL is an actual mining and construction enterprise headquartered in Sydney with more than 5000
employees across Australia. LCPL undertakes projects within the Asia-Pacific region, mainly in Australia and
New Zealand. The company delivers projects for clients across the infrastructure, resources, civil engineering,
energy and telecommunications sectors”, from this description we can image there are different systems
implemented in different sites of LCPL. Use what you have learned in the unit to discuss the following:
• The possible issues relating to integration (from different layers/aspects) using examples;
• The possible technologies potentially used to support system integration at various levels/aspects;
• The options and considerations of the technologies along with their advantages and disadvantages
Submission: one submission per group, together with the project description and log.
本网站支持淘宝 支付宝 微信支付 paypal等等交易。如果不放心可以用淘宝交易！
E-mail: [email protected] 微信:itcsdx