All WebSphere Commerce database assets are divided into groups for creation and loading. These groups are a logically related set of tables. The order in which these database asset groups are organized is important to data loading, since certain objects must exist before loading the relationship between objects.
When loading database assets in XML format for your store, you can choose to load only selected groups. These groups consist of the database assets, such as catalog or fulfillment. Before loading data groups as instructed in :
- Determine which database asset group you are loading. Each group contains dependencies which must be met before the assets can be loaded. Review the information in .
- Ensure that you have created or updated the XML files for the selected database asset group. The information in each of the asset chapters advises you on the order in which to create the database assets, but when creating or updating XML files, remember that information for a parent table must precede information for a child table.
Each database asset group draws its information from WebSphere Commerce database tables. Database assets have dependencies within their own group. That is, a database asset group cannot draw data in other XML files from a different data group, and each group is independent minus the foreign keys. However, if the database asset group needs to refer to the external data defined in another group, then you need to provide that data manually. This means that the data from one group has an external dependency on data defined outside of its domain, that is, on another database asset group. External dependencies occur when a database asset group has a foreign key relationship to the primary key of a table in another group. To load a database asset group, its external dependencies must be satisfied. To use an example from the following chart, one of the external dependencies for the store database asset group is fulfillment.FFMCENTER.FFMCENTER_ID, which indicates that the fulfillment database assets must already exist in the WebSphere Commerce database before you can load the store database asset group.
Consider the following chart before you begin your loading process. Each group of database assets is dependent on other database tables, from which the data is loaded.
Some points to remember:
- Some external dependencies may not be satisfied by a single group. Site wide or general database assets, used by every store, are pre-populated at instance creation in the bootstrap and can be readily accessed. Tables contained in database asset groups have foreign key references to this type of data. Bootstrap data is divided into common and locale-specific data. If you have a multilingual store, you need to choose the common and the locale-specific bootstrap data. For example, you need the language and member bootstrap data. The instance creation process populates the LANGUAGE table with the supported WebSphere Commerce languages for your store and creates a root organization (MEMBER.MEMBER_ID=-2001) and a default organization (MEMBER.MEMBER_ID=-2000). You must use the root organization where required, but you should create a store owner organization instead of using the default organization.
- The files listed under the External dependencies column use the following naming structure: database asset group.database table.database column. Using the store.STOREENT.STOREENT_ID file as an example, the data is taken from the store database asset group, STOREENT table, and STOREENT_ID column. File names beginning with bootstrap indicate that the data was populated during the WebSphere Commerce instance creation.
- The files listed under the External dependencies column contain foreign key references to the Related tables. These tables must be populated first.
- For presentation purposes only, the tables have been split to indicate the locale-specific tables containing multilingual information, such as product descriptions.
- The tables in the chart represent the database assets from the WebSphere Commerce starter stores. The tables may vary according to your store's size, function, and needs. Depending on your store's requirements, ensure that you include all database tables containing your store's assets, even if that particular table is not listed.
External dependencies | Related tables from the database asset XML files | Related locale-specific tables from the database asset XML files | ||
---|---|---|---|---|
Access control database assets | bootstrap.LANGUAGE.LANGUAGE_ID (root and store owner organizations), bootstrap.MEMBER.MEMBER_ID (root and store owner organizations) | accesscontrol.xmlACACTACTGP, ACACTGRP, ACACTION, ACPOLICY, ACRESCGRY, ACRESGPRES, ACRESGRP | accesscontrol.xmlACACGPDESC, ACACTDESC, ACPOLDESC, ACRSCGDES, ACRESGPDES | |
Business policy database assets | bootstrap.LANGUAGE.LANGUAGE_ID, boostrap.MEMBER.MEMBER_ID, store.STOREENT.STOREENT_ID (store owner organization) | businesspolicy.xmlPOLICY, POLICYCMD | businesspolicy.xmlPOLICYDESC | |
Campaign database assets | store.STOREENT.STOREENT_ID | campaign.xmlCAMPAIGN, COLLATERAL, EMSPOT | campaign.xmlCOLLDESC | |
Catalog database assets | bootstrap.LANGUAGE.LANGUAGE_ID, bootstrap.MEMBER.MEMBER_ID (store owner organization), store.STOREENT.STOREENT_ID, shipping.CALCODE.CALCODE_ID, tax.CALCODE.CALCODE_ID | catalog.xmlBASEITEM, CATALOG, CATENTREL, CATENTRY, CATGROUP, CATGRPREL, CATTOGRP, ITEMSPC, ITEMVERSN, RA, RADETAIL, STOREITEM, STORITMFFC, VERSIONSPC offering.xml CATGRPTPC, MGPTRDPSCN, OFFER, OFFERPRICE, TRADEPOSCN storefulfill.xml INVENTORY store-catalog.xml DISPCGPREL, DISPENTREL, STORECAT, STORECENT, STORECGRP store-catalog-shipping.xml CATENTCALCD, CATENTSHIPstore-catalog-tax.xml CATENTCALD | catalog.xmlATTRIBUTE, ATTRVALUE, BASEITMDSC, CATALOGDSC, CATENTDESC, CATGRPDESC, PKGATTR, PKGATTRVAL, | |
Command database assets | store.STOREENT.STOREENT_ID | command.xmlCMDREG, VIEWREG | N/A | |
Contract database assets | store.STOREENT.STOREENT_ID | The contract database tables are not loaded directly and follow a different process than the other WebSphere Commerce data groups. | ||
Currency database assets | store.STOREENT.STOREENT_ID | currency.xmlCURCVLIST | currency.xmlCURCONVERT, CURLIST | |
Fulfillment database assets | bootstrap.LANGUAGE.LANGUAGE_ID, boostrap.MEMBER.MEMBER_ID (store owner organization) | fulfillment.xmlFFMCENTER, STADDRESS | fulfillment.xmlFFMCENTDS | |
Organization database assets | bootstrap.LANGUAGE.LANGUAGE_ID (root and store owner organizations), boostrap.MEMBER.MEMBER_ID (root and store owner organizations) | organization.xmlADDRBOOK, ADDRESS, MBRREL, MEMBER, ORGENTITY | N/A | |
Shipping database assets | bootstrap.LANGUAGE.LANGUAGE_ID, bootstrap.MEMBER.MEMBER_ID (store owner organization), fulfillment.FFMCENTER.FFMCENTER_ID, store.STOREENT.STOREENT_ID | shipping.xmlCALCODE, CALRULE, CRULESCALE, JURST, JURSTGPREL, JURSTGROUP, SHIPMODE, STENCALUSG shipping.xml SHPJCRULE, SHPARRANGE | shipping.xmlCALCODEDSC, CALRANGE, CALRLOOKUP, CALSCALE, SHPMODEDSC | |
Store database assets | bootstrap.LANGUAGE.LANGUAGE_ID, bootstrap.MEMBER.MEMBER_ID (store owner organization), bootstrap.SETCURR.SETCURR_ID, fulfillment.FFMCENTER.FFMCENTER_ID | store.xmlINVADJCODE, RTNREASON, STORE, STORENT, STORELANG, VENDOR | store.xmlFFMCENTDS, INVADJDESC, RTNRSNDESC, STADDRESS, STOREENTDS, STORLANGDS, VENDORDESC | |
Store default database assets | shipping.SHIPMODE.SHIPMODE_ID (if applicable, this file must be loaded first), contract.CONTRACT.CONTRACT_ID, store.STOREENT.STOREENT_ID | store-default.xmlSTOREDEF | N/A | |
Tax database assets | bootstrap.LANGUAGE.LANGUAGE_ID, boostrap.MEMBER.MEMBER_ID (store owner organization), store.STOREENT.STOREENT_ID, fulfillment.FFMCENTER.FFMCENTER_ID, store.STOREENT.STOREENT_ID | tax.xmlCALCODE, CALRANGE, CALRLOOKUP, CALRULE, CALSCALE, CRULESCALE, JURST, JURSTGROUP, JURSTGPREL, STENCALUSG, TAXCGRY, TAXJCRULE taxfulfill.xmlTAXJCRULE | tax.xmlCALCODEDSC, CALSCALEDS, TAXCGRYDS |