- About TEAM
By: Raoul Miller – Enterprise Architect
Whenever you are working with an application like WebCenter Content that is heavily dependent on the database, it is useful to have knowledge of the underlying structure of that database. With that in mind, I recently used Oracle’s great (free) tool called Oracle SQL Developer Data Modeler (quite a mouthful) to model the structure of the database for a WebCenter Content and WebCenter Imaging instance.
I then added some of the descriptions of the entries in the rows based on earlier versions of this data model dating back to Stellent 7.1 (I’m happy to post those earlier data models, too, if they are useful to anyone).
A couple of observations I will leave for you to ponder:
A very useful tip for anyone deploying WebCenter Content and leveraging custom metadata for queries – remember that second bullet point above and create your own indexes on custom metadata columns in DOCMETA – your searches will execute up to ten times faster.