Creating a Physical Schema for XML

The Physical Schema will be a storage location for the tables associated with the XML file.

To Create a Physical Schema for XML:

Note: If you have just created a Data Server, ignore step 1. The Physical Schema window should already be opened.

  1. Select the appropriate XML Data Server then right-click and select Insert Physical Schema. The Physical Schema window will appear.

  2. Name the Schema and Work Schema. Note that if you have named the schema with the s=<schema name> property of the JDBC URL of the XML Data Server, you must use the same schema name here.

  3. Check the Default box if you want this schema to be the default for this data server (The first physical schema is always the default). For more information, see Physical Schema. Note that for XML files, you do not need any other Physical Schemas

  4. Go to the Context tab

  5. Select a Context and an existing Logical Schema for this new Physical Schema, then go to step 8.
    If no XML Logical Schema exists yet, proceed to step 6

  6. Click the button

  7. Select an existing Context from the left column, then type the name of a Logical Schema into the right column. This XML Logical Schema is automatically created and associated with this physical schema in this context

Warning ! A Logical Schema can be associated with only one Physical Schema in a given Context

  1. Click OK