DBPrism CMS uses two database schemas for storing code (CMS_CODE) and data (CMS_DATA).
Then every CMS user has his database schema but it uses the CMS code trough grants and public sinonyms.
CMS data is stored into the table CMS_DOCS which resides on CMS_DATA schema, in that case the access control is made using XMLDB WebDAV ACLs, this access is implemented using Oracle Virtual Private Database support but is transparent from the point of view of DBPrism CMS.
In this release of the CMS only one CMS_DATA and CMS_CODE schemas can be installed on a particular Oracle instance because some scripts grants the access to the public schema, but this limitation will be eliminated in future releases.
The following table summarize the database objects stored on CMS_CODE schema.
| Name | Type | Description |
|---|---|---|
| CMSj | PLSQL Java Wrapper | PLSQL package wrapper for Core and Front End Java Implementation. |
| SEARCH | PLSQL Java Wrapper | PLSQL package wrapper for AvQuery.java Stored Procedure |
| CACHE | PLSQL Package | ESI invalidation protocol code for sending XML messages to Cocoon Cache. |
| CMSSchemaUtils | PLSQL Package | Some helper procedures for the CMS Front End, including functionality such as update public page, publish public page, and the AQ PLSQL consummer for the invalidation message queue, among others. |
| CMSRSS, FAQ, CMSNEWS | PLSQL Java Wrapper | Wrapper Call Specs for the Java Stored Procedures cmsRss.java, cmsFaq.java and cmsNews.java. |
| UploadRss, UploadNews | PLSQL Procedures | Procedures for uploading MoreOver News and RSS Channels, also sent ESI Invalidation messages to the cache host. |
| publicPendingPages | PLSQL Procedure | Procedure for publishing pending pages. Called automatically by the DBMS_SCHEDULER system. |
| com.prism.cms.core.Util.java | Java Stored Procedure | Helper Java Class with miscelaneous functionality, such as export/import methods for content assets in jar format. |
| com.prism.cms.core.wwwIndex.java | Java Stored Procedure | Core funtionality for DBPrism CMS, it implements functionalities such as load the content assets, make CMS metadata for the page, sitemap, and others. |
| com.prism.cms.ext.AvQuery.java | Java Stored Procedure | CMS Search functionality using Oracle Text. |
| com.prism.cms.ext.cmsFaq.java | Java Stored Procedure | CMS FAQ presentation code, convers the content of the CMS_FAQ tables into document-v20.xsd XML. |
| com.prism.cms.ext.cmsRss.java | Java Stored Procedure | RSS loader and presentation code, converts the content of RSS_ITEMS, RSS_CHANNELS and RSS_SITES tables into document-v20.xsd XML, also it can load these tables from Internet using HTTP from RSS 2.0 feeds. |
| com.prism.cms.ext.cmsNews.java | Java Stored Procedure | News loader and presentation code, converts the content of NEWS_CATEGORIES and NEW_ARTICLES tables into document-v20.xsd XML, also loads news from MoreOver web site. |
| com.prism.cms.frontend.Actions.java | Java Stored Procedure | Helper class for DBPrism CMS Front End, including methods for getting server side JDBC connection, parsing of XForms arguments, cookies and others. |
| com.prism.cms.frontend.PageActions.java | Java Stored Procedure | Java code for the CMS Front End XForms Actions, ingluding operations related to pages such as addPage, delPage, updateLicense and others. |
| com.prism.cms.frontend.DirectoryActions.java | Java Stored Procedure | Java code for the CMS Front End XForms Actions, ingluding operations related to directories such as addDir, delDir, updatePropertiesDir and others. |
| com.prism.cms.frontend.WorkflowActions.java | Java Stored Procedure | Java code for the CMS Front End XForms Actions, ingluding operations related to the publication Workflow such as approveRequest, linkPage, updatePublicURL and others. |
| com.prism.cms.frontend.Reports.java | Java Stored Procedure | Java code for the CMS Front End Reports, some example of reports are, listOfPublicLinks, listOfRelatedPages, nonPublicPages, and others. |
