I just got stuck with cleaning up a mess of records for a group I
belong to - circa 80k memebers - that are being kept on a variety of
spreadsheets and Access databases by a bunch of different people.
Hopeless mess, it is. I happen to have a DB2 license I can use so
that's where I want to stuff all this data. I'm no DBA - done a lot
of programming for DB2/Oracle over the years even a bit of SAP stuff
along with some light weight admin tasks but when it comes to design
of a database to efficiently hold all this crap I'm, at best, a
tinkerer. After a bit of messing with it I find I'm quite good at
organizing tables so that queries take forever to run, so that's my
main objective - organizing things right from the gitgo. Is there a
good reference for design considerations/strategies around? I don't
want the full course, just enough basics to keep me from creating a
briar patch.
--
Will Honea