...
- An anchor is a fragment, as such it can have properties
- The first element of the xpath array is the name of the anchor. All the children append elements to that.
- All the fragments have a reference to the anchor point.
- The full xpath is stored as text
- The parent ID column in the fragment table is there for transactional integrity. It references the id column to prevent creating orphan records under concurrency. It also serves lookup performance for parent/children.
- A schema node identifier can be inferred from the xpath (in fact, for containers it is the xpath bar the first element). There is no need to link it to a model set.
- The link between anchor points and module sets is purely for storing the association. The DB SPI has no notion of the model semantics.
The proposed DB for this schema is Postgres (as it uses some Postgres specific datatypes)
...