My mistake... I guess they moved the articles to:
http://www.ralphkimball.com/html/articles.html
One of these is a most excellent article on building a star-schema for a transaction-based data warehouse:
http://www.intelligententerprise.com/db_area/archives/1999/993003/warehouse.shtml
And here is the magazine link (I think my finger slipped... that's the problem with long URLs. Why don't they just call it easy to remember, like "206.189.201.158" or something ? ;-)
http://www.intelligententerprise.com/
Technology: no place for wimps.
Greg
-----Original Message-----
From: Steven Yong [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 07, 2003 6:29 PM
To: jdjlist
Subject: [jdjlist] RE: Logging to a Database
Is the intelligententreprise.com domain name valid?
Steven
> Dear James,
>
> 1) Why not just use plain JDBC? you will need a special recording DB schema
> if you're serious. I would suggest using a star-schema arrangement that
> allows you to calculate transaction speed, track entry on the per-item
> basis, and make all kinds of useful reports ("How long did it take on
> average to ship items this month when John Doe is the shipping clerk on
> duty?")
> See more articles on that type of schema on intelligententreprise.com. They
> have a wealth of info in the "Articles" section.
>
> Alternatively, just use a single table with a 255 "context" column, and
> maybe CLOB/BLOB column to hold transaction-related XML/binary files. But
> that is much less flexible, more for just record-keeping. This is what we
> have, but it's hard to do reports with this arrangement.
>
> 2) Specify each machine with a unique name in some sort of a config file on
> each machine. 1.4 has great Properties support, so you can use that class to
> read it at start up time.
>
> Greg
>
> -----Original Message-----
> From: James Stauffer [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 05, 2003 10:33 AM
> To: jdjlist
> Subject: [jdjlist] RE: Logging to a Database
>
>
> Also it doesn't look like the 1.4 logging has a good way to record the
> machine. We have 10 load-balanced servlet engines and I would also like to
> record the machine. Ideas?
>
>
> James Stauffer
>
> -----Original Message-----
> From: James Stauffer [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 05, 2003 12:24 PM
> To: jdjlist
> Subject: [jdjlist] Logging to a Database
>
>
>
> Does anyone have suggestions for logging to a database? Is
> java.util.logging.SocketHandler the best way? What would be used to read on
> the other side? Can I set it up to normally log to the Database and if that
> errors use FileHandler?
>
> James Stauffer
>
> ---
> You are currently subscribed to jdjlist as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
> [EMAIL PROTECTED]
> http://www.sys-con.com/fusetalk ---
> You are currently subscribed to jdjlist as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to
> [EMAIL PROTECTED]
> http://www.sys-con.com/fusetalk
>
>
>
> ---
> You are currently subscribed to jdjlist as: [EMAIL PROTECTED]
> To unsubscribe send a blank email to [EMAIL PROTECTED]
> http://www.sys-con.com/fusetalk
>
---
You are currently subscribed to jdjlist as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
http://www.sys-con.com/fusetalk
You are currently subscribed to jdjlist as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
http://www.sys-con.com/fusetalk
