This discussion is archived
5 Replies Latest reply: Jan 28, 2013 1:42 AM by jiri.machotka RSS

How database works in UCM?

980743 Newbie
Currently Being Moderated
Hi,

What is the Oracle UCM database design?

Where is the metadata info stored in UCM? And What are the columns in meta data table?

How are security groups and metadata related?

Thanks,
  • 1. Re: How database works in UCM?
    jiri.machotka Guru
    Currently Being Moderated
    What is the Oracle UCM database design?
    The best available info on data model is here: http://docs.oracle.com/cd/E10316_01/cs/cs_doc_10/documentation/admin/troubleshooting_10en.pdf (chapter Appendix A.)
    Note that it is the 10g version (95% of described tables are still the same) and that it does not contain all the tables - it is impossible as a) many tables might be added by components b) in Config Mgr admins can define custom tables
    Where is the metadata info stored in UCM? And What are the columns in meta data table?
    Standard metadata is in Revisions, custom ones in DocMeta
    How are security groups and metadata related?
    Security group is one of metadata fields in the Revisions
  • 2. Re: How database works in UCM?
    980743 Newbie
    Currently Being Moderated
    Hi Jiri,

    Thanks for your reply. The link is really helpful.
    I have below questions:

    In Revisions and DocMeta table all the meta data is stored?

    that is will i get all the meta data if i query Revisions and DocMeta table?

    Thanks
  • 3. Re: How database works in UCM?
    jiri.machotka Guru
    Currently Being Moderated
    As for standard and custom metadata, I'd say yes.

    It is actually quite easy to verify: turn on server-wide tracing for full verbose tracing on systemdatabase - see http://docs.oracle.com/cd/E23943_01/doc.1111/e10792/c03_processes.htm#CSMSP536
    Then, navigate in web GUI to see metadata details (Info, or DOC_INFO). Check what query is executed - it will contain at least one more table, Documents (it is disputable, if content of this table should be called metadata, or not).

    Feeling the urgency in your answer I can't but add a warning: if you plan to perform non read-only operations, it is advisable to use services (e.g. via RIDC) not direct database access, or you can end up with an inconsistent database.
  • 4. Re: How database works in UCM?
    980743 Newbie
    Currently Being Moderated
    Hi Jiri,

    Thanks for the reply.

    Can you please help me with below requirement:

    How can i find which meta data is used in which Profile or security groups?

    Thanks

    Edited by: SSJ on Jan 28, 2013 12:54 AM
  • 5. Re: How database works in UCM?
    jiri.machotka Guru
    Currently Being Moderated
    Can I help? I hope so, but first you will have to specify/correct your question a little bit.

    a) why do you ask? what is your intention/use case?
    It always helps to understand the context of a question - sometimes, it might be easier (and even more correct) not to do directly what's been asked.

    b)
    How can i find which meta data is used in which Profile or security groups?
    A security group is a metadata of an item, and unless the system implements some custom logic, there is no relation between SG and other metadata.
    With Profiles your question makes more sense. However, the matter is not that simple:

    - first of all, a profile is determined by a profile trigger (metadata) field as described in http://docs.oracle.com/cd/E23943_01/doc.1111/e10978/c04_metadata.htm#DAFJDCEH
    - a profile consists of rules:
     ♦ a profile can be defined as "Exclude non-rule fields" - see http://docs.oracle.com/cd/E23943_01/doc.1111/e10978/c04_metadata.htm#DAFJIEAI How is this fact related in your question? (i.e. if a field is excluded, is it "used" in a profile, or not?)
     ♦ there can be multiple rules affecting the same metadata field (e.g. some of them might "showing" it, the other might be "hiding" it - see also the next point)
     ♦ a rule might have a rule activation condition - see http://docs.oracle.com/cd/E23943_01/doc.1111/e10978/c04_metadata.htm#DAFHGFFG These conditions may determine whether or not the rule is applied based on item's metadata, usage (such as checkin vs. search), ... (in fact, whatever condition you may think of). This means that in general unless you have an item it might be impossible to determine what the result of a condition is.
    - some metadata cannot be affected by profiles - see this thread on this topic Profile question

    To sum up, depending on configuration, answering a question what metadata is displayed by a profile is not a simple task - and you'd need evaluating idocScript to do that. Which IMHO leads coming back to a)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points