RE: Website & Oracle Backend for static content - OT?

A couple of other folks have mentioned that there are full-blown content management systems for this sort of thing that would likely be far more efficient than rolling your own system to update content directly in Oracle.

Depending on the requirements, however, you might consider using something like Oracle Files (formerly internet File System) to store the static data. Users could view edit the documents just as if it were on a file system, but under the covers everything would be in Oracle, so you'd have the same sorts of security/ auditing/ etc that you'd expect.

If you have a large community of department admins that are updating static content as one of many roles in the organization, a full fledged content management system, or even rolling out source control to the desktops, might be overkill and might burn more training time than it saved. Being able to expose a file system like interface to those that just need a file system interface can be a real benefit here.

Justin Cave <jcave_at_ddbcinc.com>
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Deen Dayal Sent: Friday, March 04, 2005 12:02 AM
To: oracle-l_at_freelists.org
Subject: Website & Oracle Backend for static content - OT?

We want to control/track and audit changes to this static content; somebody
came up with the idea of putting all the web pages content into an oracle
database and develop some User Interface to modify the content. On daily basis all the changed static content is extracted and pushed to site.

Here are my questions

1. Did anybody do this kind of work? Is there any software which can accomplish what we are trying to do?
2. How people out there control/manage/audit/track their static content with thousands of pages of html/graphics etc.
3. Going with our idea of Oracle Database as the backend how the user identifies/searches for the content in the User Interface. Let's say he/she wants edit 3rd paragraph in http://somesite/somepath/some.html how does he search for that text and pull it in the GUI to edit.
4. Any other ideas to implement this??

Can anybody out there point me to any docs or websites which deal with these
issues?

Any help in this regard is greatly appreciated.

Thanks
Deen

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 04 2005 - 02:20:21 CST