RE: Normalization was Left AS/400 and Returned

[rob@xxxxxxxxx]

Good points.

Many of the calculations would be better served by a nice SQL view that 
includes UDF's to do things like calculating BPCS on hand.

How would a user, using an Excel spreadsheet say give me all the shipping 
going out today using a stored procedure?

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/05/2005 11:48 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: Normalization was Left AS/400 and Returned






> From: rob@xxxxxxxxx
> 
> The users are going to generate their own queries.  If we insisted on
a
> strictly programmer controlled access via stored procedures, etc, then
> what would happen but the users insisting on us duplicating all data
to a
> PC so that they can run their own queries against it.

You've said this sort of thing before, and I simply disagree.  The users
don't need access to every field in the database.  In addition, I'll bet
that there are lots of calculations that would be better served if you
provided a single programmatic access rather than forcing them to do the
calculations themselves.

But we're out of architecture and into the land of business
requirements.  At that point, you have to decide whether your business
requirements override best architectural practices.  I can't make that
decision for you, obviously.  I can just tell you that you are locking
your database into your user's Excel and Access queries, and from an
architectural standpoint that's a bad place to be.

Joe

-- 
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.