XML Schema Complete Reference, The

22.1. XML Schema Design Considerations

When creating an XML schema document whose XML instances will be stored in a relational database (in non-XML form), the XML schema designer needs to consider the impacts that design decisions might have on the database representation. In addition, certain decisions need to be made explicitly that would not normally affect an XML schema document. This section lists the major considerations and provides recommendations and discussion around each of them.

22.1.1. Patterns

When patterns are used, determine whether the database needs to enforce the pattern or whether the enforcement can be left solely to the XML schema processor. If database enforcement is required, be aware that SQL does not perform regular ...