IBM SG24-6320-00 Manuale Utente

Draft Document for Review July 28, 2004 7:33 pm

Keeping Commerce Applications Updated WebSphere Commerce 5.1 to 5.6 Migration Guide

Custom tables were added to increase functionality. Tables were added to 
implement dynamic shiprates. Other tables were added to store potential 
fraudulent payment transactions.Table 4-2 provides a summary of custom tables 
that were created for use with the application.

Custom Tables

The product catalog includes all the items sold on Carrotink.com. The catalog 
contains the hierarchy for categories with the items being associated with the 
bottom level category. The top categories are the printer brand. The 
subcategories are the printer models. Some items have a 1:1 relation with their 
parent category while other items have a 1:M (1 to many) relationship. This 1:M 
relationship is due to the fact that one ink jet cartridge can work with different 
printers.

TXSearchSampleCmd
TXSearchSampleCmdImpl

N/A

Sample commands 
provided by IBM for use 
with the DB2 Text 
Extender. The controller 
command generates a 
SQL statement that is 
then used to query the 
database to return search 
results.

RURALZIPCODES
SHIPRATE
SURCHARGE
ZIPCODE
ZONE

Implements dynamic shiprates for FedEx, 
UPS, USPS. Based on factors such as 
zipcode, shipping zone, and order weight, 
the application will deliver real time ship 
rates to the customer.

XBLOCKIPS
XPOTIPS

Non-Commerce related tables. Part of 
external application that records potential 
fraudulent payment transactions.