Project Presentation of EricPaul Stothard

1
Project Presentation of Eric-Paul Stothard

• Project Title
• Web-based query system built on XML technology
  for the Department of Trade Industry (DTI) Oil
  and Gas Directorate

Final Year Individual Project BEng Software
Engineering City University 2002
2
Presentation Outline

• The DTI Oil and Gas Directorate (Background)
• Current technologies researched and evaluated
• System requirements gathered
• System design and prototype developed
• Prototype system evaluated
• Final system developed
• Final system evaluated

3
The DTI Oil and Gas Directorate

• The Oil and Gas Directorate is responsible for
  regulation and licensing of all Oil and Gas
  production within the United Kingdom Continental
  Shelf (UKCS)
• I was employed in the Database team as a Systems
  Developer within the Information Technology
  support section (OG-IT) of the Directorate for my
  professional placement from July 2000 to
  September 2001
• Petroleum Production Reporting System (PPRS) 2000
  For the majority of my placement I developed
  and maintained PPRS 2000

4
The DTI Oil and Gas Directorate

• UK Government policy for all Government business
  processes to be available via the Internet by
  2005
• The UK Oil Portal The Oil and Gas Directorates
  e-business strategy to make 100 of its services
  available electronically
• The PPRS Extract Query Tool

5
Technologies Researched and Evaluated

• Server-side Programming
• Application Servers
• XML and XSL (XML Stylesheet Language)
• Development Tools and Integrated Development
  Environments (IDE)

6
System Requirements

• Stakeholder and user requirements
• Interviews to discover UML use-case descriptions
• Use of a mock user-interface using plain HTML
  pages
• Creation of Requirements Specification reviewed
  and signed off

7
System design and prototype

• Analysis of use-case descriptions to create
  classes and relationships
• Entity Class List and Class diagram created
• HTML Interface and Skeleton Java code (from
  design) used as starting point to develop
  prototype system
• Prototype developed using Java Server Pages
  (JSP), Java Beans, Oracle XSQL pages and XSLT
  stylesheets.

8
Prototype system evaluated

• Prototype system demonstrated and available for
  use over four weeks
• Stakeholder feedback received
• Incorporation of feedback into fixes and
  improvements for the final system
• Use-cases descriptions updated

9
Final System Developed

• Prototype as basis for the Final System
• Further functionality added to the system
• Fixes and improvements from stakeholder feedback
  made to the system

10
Final System Evaluated

• Stakeholders and users evaluation of the system
• System security evaluation UK Government
  guidelines
• System maintainability evaluation coding
  standards, documentation, ease of understanding.

11
Conclusion and Discussion

• The system is currently being used internally
  throughout the Oil and Gas Directorate
• However not available to Oil and Gas industry
  users or members of the public In the future it
  is hoped that the system will be incorporated
  into the UK Oil Portal
• Future Improvements and Enhancements
• What was learnt

12
Questions

• Thank you for your time, and I hope you enjoyed
  listening to my presentation.
• If you have any questions, I will try my best to
  answer them.
• For further information about my final year
  project you can visit the project web-site
  athttp//www.soi.city.ac.uk/ch137/project