Re: Storing XML application logs in the database
- From: Nigel Thomas <nigel.cl.thomas@xxxxxxxxxxxxxx>
- To: warren.puziewicz@xxxxxxxxxxxxxxxxxx, Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Jan 2010 10:42:53 +0000
Warren
If you want to understand some of the pros/cons of the different storage
formats for XML, you can start by looking at Oracle ACE Marcus Gralike's
posts at his blog www.liberidu.com. See in particular the category Binary-,
CLOB-, Object-Relational Storage <http://www.liberidu.com/blog/?cat=23>.
One other point. If you make the application logs real XML rather than "XML
like" (even if they contain some "free format" text elements) then you and
your developers will have the freedom to query/transform them using
*any *standard
XML tool (not just Oracle). For example, you'll be able to open the log with
a browser, or with a tool like XMLSpy; you can use XSLT to process logs (eg
to get out performance stats) without necessarily using the Oracle database.
That will make the logs more useful/valuable in the long run.
Regards Nigel
Other related posts:
