Storage Strategy in the Repository Database

Microsoft® Repository's database storage model differs from its run-time object model. While the run-time object model is designed to accommodate run-time operations conveniently, the database model is designed to accommodate storage efficiently.

To save space in the database, Repository can sometimes store a single copy of a property value, even if that property value describes many object versions. Similarly, Repository can sometimes store a single copy of a relationship, even if many different object versions have that relationship.

Repository anticipates which object versions are especially likely to share property values and relationships and which object versions are less likely to. It uses these guidelines:

• Two versions of the same object are likely to share property values and collections, but two versions of different objects are less likely to do so. In other words, if two object versions are not on the same version graph, they are not especially likely to share property values or relationships. (See The Version Graph.)
  
  
• Within a version graph, two versions that are near each other are more likely to share values; two versions that are far apart are less likely to share values. Repository arranges each version graph into branches. (See Branches in the Version Graph.) Each branch contains versions that are especially likely to share values.
  
  
• Although property values and collections can change, they do not change back and forth frequently. More commonly, a value holds for a few consecutive versions of an object, and then that value changes to a new value, which holds for a few more versions of the object. Thus, when Repository stores a property value, it stores the property value for an entire range of object versions. (See Ranges in the Version Graph.)

  Similarly, in a single row of the RTblRelships table, Repository can indicate that every object version in a range (of origin object versions) has a relationship to every object version in a range (of destination object versions).

The following table summarizes how Repository stores versions and relationships.