Standard Objects
As discussed each object type has 2 tables in its underlying database, information about an instance of an object type is also stored in some other tables like dmi_object_type which is an internal table to identify the object based on its r_object_id property. This table has only 2 columns, r_object_id and i_type. Since all the content objects will be stored under the subtypes of dm_sysobject, the attributes of dm_sysobjects are shared with all instances.
The following diagram shows how the information about an instance is stored in the database.
HVS Objects
HVS stands for High Volume Server which is an optional component for content server which provides high rate of ingestion capacity and low disk storage. HVS uses light weight object types and shareable object types. Storing information for the instances of these object types is different than instances of standard object types.
The following diagram shows how the information of an object instance is stored in the database for HVS objects.