|Oracle8i Application Developer's Guide - XML
Release 3 (8.1.7)
Part Number A86030-01
Business Solutions Using Oracle XML, 8 of 10
Problem. Company X needs to build an online shopping cart the products on which come from various vendors. Company X want to receive orders online and then according to what product is ordered funnel the order to the correct vendor accordingly.
At the vendor site, the user adds items to their shopping basket, then clicks on a button to indicate that they are done shopping. The vendor sends back the contents of the shopping basket to the Company X's application as an XML file containing the part numbers, quantities, and prices that the user has chosen.
Items from the "shopping basket" are automatically added to the new purchase requisition as line items.
Customer orders are compiled into XML and delivered to the appropriate vendor databases for processing. XSL is used to transform and divide the cart for compliant transfers. Data is stored in a relational database and materialized using XML. See Figure 2-4.