FYP Final Report v1.0.0
Copyright and All Rights Reserved To: Pee-Lo Team @2003/04
23
For building XML web services to cater the need of older or existing systems, a technical paper
and a series of three posters have been written by us are attached at Appendix A and Appendix B
to explain how the concept works.
3.2 Solution Architecture Explained
In the next following few subsections, we will discuss on how our prototype system is built in a
more technical approach. It is 3-tier client/server architecture.
We will begin from the lowest point, the Database Layer then followed by the XML Web Services
Layer and finally the Client Access Layer.
3.3 Database Layer
In the context of our prototype system, we choose to use the Microsoft SQL Server 2000. In actual
fact, any DBMS can be used but for simplicity sake, we opt for Microsoft SQL Server 2000 (SQL
Server from here onwards). The deployment of SQL Server is simple enough. We just need to
prepare the tables, assigned the relationships, set the security access and the whole thing is up
and running. Note however, if our system is really to be used in real environment, more setting has
to be done to the DBMS like better security, traffic control and such.
The Database Layer acts very independently. It sets the foundation for its ancestor layer; the XML
Web Services Layer to interact with it. Things that are contained in this layer are all those related
to build and maintain the database. Some of the following items are as follow:
DB tables, relationship diagrams and access control
Traffic/Activities Logs
DB Backup Functions
Figure 4 shows a snapshot of how SQL Server looks like.