This content has been marked as final. Show 5 replies
1 person found this helpful
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
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?
As for standard and custom metadata, I'd say yes.1 person found this helpful
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.
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?
Edited by: SSJ on Jan 28, 2013 12:54 AM
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.
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)