So I would take it you consider a request for a report that covers the ten year period from 5 years ago to 15 years ago as a special request since the data needed is in two different places? Does this rule also cover student data? We are a college and have students who's transcripts can cover 15, 20, even 30 years or more for those that graduate, get a job, then come back for skills updating or a new career. You most likely only have to worry about k through 12 but that is still a 13 year period for the "normal" student but any held back could have a longer period transcript. Our requests for data are all over the place. Sometimes people want 5 years of data on a report but the start/end dates could be anything from 1962 to today. Sometimes we even get requests for numbers that span the entire 45 year life of the college (it opened in 1962 as a community college). At the moment our student data warehouse is our student database. We archive nothing and everything is in the same files. Financial data we have 10 years like you but did not archive (electronically) anything put payroll data which we have back to 1989 when we brought payroll back in-house. What our plans are for a data warehouse is a place to store summary data so reports are not running against the full database and adding up the same numbers over and over again for historical data. At some point after the end of a semester will run a process to warehouse the summary numbers. And also being summary data it will run much faster and be more consistent.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Aaron Abreu
Sent: Wednesday, April 16, 2008 10:17 AM
To: midrange-l@xxxxxxxxxxxx
Subject: 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.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/midrange-l.
midrange.com
