1 / 17

Module 15

Module 15. Object and Content Relationships (Supplemental). Module Objectives. Describe the purpose of the dmr_content object List the different types of object-content relationships Describe how renditions are associated with an object

Download Presentation

Module 15

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Module 15 Object and Content Relationships (Supplemental)

  2. Module Objectives • Describe the purpose of the dmr_content object • List the different types of object-contentrelationships • Describe how renditions are associatedwith an object • Describe how content is managed whenobjects are versioned • Explain how a version tree is maintained • Explain how objects are associated withpermission sets Object and Content Relationships

  3. What is a Content File? • Content Files • Object-Content Relationships • Version Relationships • Permission Set Relationships • A content file • Can be text, graphics, images and other information that make up an object • Can be of formats including HTML, XML, and XSL • Is linked with any subtype of dm_sysobject (except folders and cabinets) such as dm_document • Information about the format and location of a content file is contained in the dmr_content object dmr_content dm_sysobject (metadata) content file Object and Content Relationships

  4. The dmr_content Object • Links the object to the content file • Is a read-only object that users and applications may query Object and Content Relationships

  5. dm_ sysobject: Content-related Properties Object and Content Relationships

  6. dm_sysobject and dmr_content • Content Files • Object-Content Relationships • Version Relationships • Permission Set Relationships • There are several possible relationshipsbetween SysObjects and content files: One SysObject / rendition(s) as content files One SysObject / one content file One SysObject / many content files (multi-page) Object and Content Relationships

  7. One SysObject / One Content File Repository dm_document content file r_object_id = 09000001800bcc8f i_contents_id = 0600000180015e18r_page_cnt = 1 dmr_content r_object_id = 0600000180015e18parent_id[0] = 09000001800bcc8f page[0] = 0 Object and Content Relationships

  8. Useful Queries: Objects and Content • Retrieve information about a specific content file: • Which objects depend on a specific content file: select r_object_id, parent_id, page, rendition, content_size, set_time, set_client, set_file from dmr_content where any parent_id = '090009dd800039a4' select r_object_id, object_name, a_content_type, r_object_type, r_lock_owner, r_link_cnt from dm_sysobject where i_contents_id = ‘0600030980000c78’ Object and Content Relationships

  9. One SysObject / Many Content Files • i_contents_id references only the first page: dm_document r_object_id = 09000001800bcc8fi_contents_id = 0600000180015e18r_page_cnt = 3 dmr_content r_object_id = 0600000180015e18parent_id[0] = 09000001800bcc8fpage[0] = 0 dmr_content r_object_id = 0600000180015e1aparent_id[0] = 09000001800bcc8fpage[0] = 1 dmr_content r_object_id = 0600000180015e1bparent_id[0] = 09000001800bcc8fpage[0] = 2 Object and Content Relationships

  10. Useful Queries: Multiple Content Files • How many content files are associated witha specific object: • What are the object IDs of the content objectsassociated with a specific object: select r_page_cnt from dm_document where r_object_id = ‘09000001800bcc8f’ select r_object_id from dmr_content where any parent_id = ‘09000001800bcc8f’ Object and Content Relationships

  11. One SysObject / Rendition(s) • Each rendition file is stored as a separate content object dm_document r_object_id = 09000001800bcc8fi_contents_id = 0600000180015e18 a_content_type = msw6 dmr_content dmr_content r_object_id = 0600000180015e18 parent_id[0] = 09000001800bcc8f page[0] = 0rendition = 0full_format = msw8 r_object_id = 0600000180015e20parent_id[0] = 09000001800bcc8fpage[0] = 0rendition = 2full_format = pdf rendition property 0=original content 1=server generated 2 =client generated Object and Content Relationships

  12. Useful Queries: Renditions • Display all objects that have renditions: • Display all of my objects that have PDF renditions: select r_object_id, object_name, a_content_type, r_object_type,r_lock_owner, r_link_cnt from dm_document where r_object_id in (select parent_id from dmr_content where rendition > 0) select r_object_id, object_name, a_content_type, r_object_type, r_lock_owner, r_link_cnt from dm_document where r_object_id in (select parent_id from dmr_content where full_format='pdf’ and rendition > 0) and owner_name = user Object and Content Relationships

  13. Versioning Content • Content Files • Object-Content Relationships • Version Relationships • Permission Set Relationships Check in as New Version Save as Same Version version 1.0 version 1.1 version 1.0 dm_document dm_document dm_document dmr_content dmr_content dmr_content dmr_content Many SysObjects / Many Content Files One SysObject / Many Content Files Object and Content Relationships

  14. Version Relationships r_object_id = 09000001800a327b i_antecedent_id = 0000000000000000 i_chronicle_id = 09000001800a327b i_direct_desc = 1 i_latest_flag = 0 version 1.0 dm_document i_antecedent_id = 09000001800a327b i_chronicle_id = 09000001800a327b r_object_id = 09000001800bcc8f i_direct_desc = 1 i_latest_flag = 0 version 1.1 dm_document i_antecedent_id = 09000001800bcc8f i_chronicle_id = 09000001800a327b r_object_id = 09000001800bd1a3 i_direct_desc = 0 i_latest_flag = 1 version 2.0 dm_document Object and Content Relationships

  15. Permission Set Relationships • Permission sets are associated with objects through theacl_name and acl_domain attributes of the SysObject: dm_document acl_name = internal_reviewersacl_domain = sdalton dm_acl owner_name = sdaltonobject_name = internal_reviewers Object and Content Relationships

  16. Test Your Knowledge • Content Files • Object-Content Relationships • Version Relationships • Permission Set Relationships • True/False: SysObjects are related tocontent files through the dmr_contentobject. • True/False: Rendition content files are maintainedby the dmr_rendition object. • Which of these operations adds a new content file to the repository not a new SysObject:A) Create a new versionB) Create a renditionC) Save as the same versionD) Add a component to a virtual document Object and Content Relationships

  17. Classroom Exercise: Lab 15 • During the exercise, you will: • Issue DQL queries to gain informationabout object and content relationships • Issue DQL queries to gain informationabout renditions Object and Content Relationships

More Related