Hi Team,
The repository contains the data in two different way
1) File System(Content)
2) RDBMS(Metadata)
I just wanted to check with you how C.S manages the relationship between File system and RDBMS?
Objects (metadata) are primarily associated with dm_sysobject object. Each dm_sysobject has associated dmr_content object (which is referenced by parent_id attribute). The information about content is stored in the dmr_content object.
There's an algorithm to determine file (content) location on File System, based on r_object_id from the database. If you search this forum, I am sure there has been discussion and explanation of how the algorithm works. Basically, the r_object_id is parsed out, and the file location -- in the file system -- is then calculated.
Here's how it's done.
Finding an Object’s Content File | dm_misc: Miscellaneous Documentum Information
There is also MFILE_URL function in DQL:
SELECT MFILE_URL('',-1,'') FROM dm_sysobject WHERE r_object_id='...'
That's very useful. Thanks for the tip
