Re: Is there an midrange Data Warehouse forum or, if not...

Dave,

keeping in mind that we are a public school
system with a limited budget, our data warehouse is
pretty much limited to our state auditing records
retention laws..
I guess you could call this a "poor mans" data warehouse..
but it does work and we can produce 10 year reports
(or more)
ad hoc as we get requests for them...

our time period is generally applied to all
applications as 10 years.. so we try to keep accounting data
on the live files for 10 fiscal years.. however.. payroll is another
issue.. at some 70,000 detail rows of data per year times
our largest row lenth (2,000+ bytes per check), we have to
hold the check data to 2 years..

the "plan" to accumalate past 10 years is to provide a
menu option for "historical reports" that changes your
lib list to a library that contains identical file names, but
only the data older than 10 years. This way the same
menu reports can be used for current data or archived
data, but the nightly backups will not have to bear the
burden of backing up those libs every night.

This archive library approach lets us use our existing
reports for retrieval and any special reporting is done
using SQL and CL's (with input parms)
(in other words, we have to write our
data warehouse reports ourselves), but we do catalog
the reports and save them for future use.



The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public-records request, do not send electronic mail to this entity. Instead, contact this office by phone or in writing.