DBPrism CMS runs as Java Stored Procedure using sqlj into the Oracle JVM (database side)
It includes several components:
- wwwIndex.sqlj, this code implements two public entries point, header and content.
Header provides the context information of the page. Content provides the content
of the document uploaded by the user.
- avQuery.sqlj, is an extension to the code available on the Oracle Technology
Network for converting AltaVista query syntax into Oracle Text syntax. Its main
entry point is doSearch which performs the query and show a result as document-v10.dtd
compliant document.
- cmsNews.java, is the code that queries the tables which store MoreOver News,
it uses Oracle XML Query functionality to do it.
- cmsFaq.sqlj, queries faq_topics and faq_sections tables using Oracle XML Query
functions and transform this result into a document-v10.dtd document using an
stylesheet stored into the CMS repository.
DBPrism CMS is easily installed using $CMS_HOME/scripts/install.[sh|bat] script.
Also the external cache invalidation code (ESI cache sync) could be activated through
$CMS_HOME/scripts/enable-cache-sync.[sh|bat] script.
|