Network Computing is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Smooth Integrators: Page 14 of 17

NWC Inc. is in the business of creating widgets for sale on the Internet. Orders are taken online at our Web site (inc.gb.nwc.com), and widgets are produced at our Syracuse, N.Y., manufacturing facility. They are then shipped direct from our headquarters in Green Bay, Wis., to customers via a method the customers choose when they order.

Our Oracle system represents the NWC Inc. production facility, where all widgets are created. SQL Server represents a purchased package that tracks shipping of customer orders, and DB2 is our core customer and order-fulfillment system. Whenever the production facility finishes a run of widgets, it puts an entry into the Oracle database indicating how many widgets of which type were created. When a customer completes an online order form, order information is entered into the DB2 database by the order-entry system. Finally, when an order is shipped to a customer, the shipping information is updated in SQL Server.

We defined the interactions between the systems as follows:

1. When the production facility indicates it has produced a number of widgets, the information should be propagated to our core system and to the shipping system.

2. When an order is entered over the Web, order information should be propagated to the shipping database.