Log4J logs

[lyanch]

Does anyone have any experience on reporting off of Log4J logs? They will be stored within an oracle 9i database, and I have been assured that each bit of data will have its own column. I am just wondering about the log format. Any experience or comments would be appreciated.

Thanks in advance

Lisa

 

[Turkbear]

Hi,
While I am not familiar with those logs, you can get the Table description(s) from Oracle ( after the logs are stored in Oracle, how they start out is irrelevant)..
The DBA should provide you with the metadata you need to design reports using the Oracle data structure(s).

 

[lyanch]

My concern was more the log format where I would have data like this:


itemId workOrderId SubORderId UserId TimeStamp Action
456 458 45814 8 01/01/04 04:15 Que
456 458 45815 7 01/01/04 05:17 Que
456 458 45815 7 01/01/04 05:19 stop
456 458 45815 9 01/01/04 05:32 Que
456 458 45814 8 01/01/04 05:33 start
456 458 45814 8 01/01/04 05:45 stop
456 458 45814 9 01/01/04 05:46 Que
456 458 45815 9 01/01/04 05:55 start
456 458 45815 9 01/01/04 06:45 compl
456 458 45814 9 01/01/04 07:15 start
456 458 45814 9 01/01/04 08:15 compl

This obviously being a small subset of data. I would want things like time from first que to last complete at the item, work order and sub workorder level, amount of time spent in que, amount of time spent actually working by user (and I didn't show it, but two users can be working on the same sub order at the same time)

It just looks like a nightmare to me. Especially because this must be combined with data from a different database server (at least they are the same type).

Lisa

 

[Turkbear]

Hi,
You need to work with the Oracle DBAs to insure that the data model they construct from the logs meets your needs..

The log files are the source but it will be the Oracle tables you access, so the design is critical ( as is usually the case with a relational database)

The proper use of tables, views and stored procedures
can make the reporting part much easier and much more efficient.