473,320 Members | 1,859 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Design advice

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
Nov 12 '05 #1
3 1430
"Will Honea" <wh****@yahoo.com> wrote in message
news:Jx***************************@anon.none.net.. .
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


Check your email.
Nov 12 '05 #2
Will Honea wrote:
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.


CASE*Method
Entity Relationship Modelling
Richard Barker
Addison Wesley Publishing
ISBN 0-201-41696-4
if you can find a copy.
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #3

"Will Honea" <wh****@yahoo.com> wrote in message
news:Jx***************************@anon.none.net.. .
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


It might not be the bad design (I mean NOT totally). You can also try start
your control center, and try the "performance wizard" to adjust your
configuration.
Of course, I don't mean you don't need to consider the db design.
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Nick Malik | last post by:
reposting to a wider audience "Nick Malik" <nickmalik@hotmail.nospam.com> wrote in message news:WYONc.203854$XM6.119642@attbi_s53... > My turn to ask a question > > I am working on a plug-in...
4
by: Ian Giblin | last post by:
I am an experienced C programmer, learning C++ by writinging a mathematical toolkit in the framework of a script interpreter. I am posting here to ask for advice (or references) on the object...
3
by: fernandez.dan | last post by:
I'm still learning how to use Object Oriented concepts. I'm have a basic question dealing with design. I have two classes that deal with I/O pertaining to network and usb that inherit from an...
3
by: Sorin Dolha | last post by:
Hello, We intend to create an ASP.NET-based Web application (hosted on Internet Information Services, or IIS) and one feature of the application needs to allow the end user to upload photos to...
4
by: Nick Malik | last post by:
My turn to ask a question I am working on a plug-in for Sharepoint that will allow a developer to add workflow rules. One of the rules will inform the adapter that it should load a DLL that the...
22
by: Krivenok Dmitry | last post by:
Hello All! I am trying to implement my own Design Patterns Library. I have read the following documentation about Observer Pattern: 1) Design Patterns by GoF Classic description of Observer....
4
by: Jerry | last post by:
Hello! I'm creating an application where users can enter their hours worked on certain projects and have them saved to a database. Right now there are about 60 different projects and that number...
23
by: JoeC | last post by:
I am a self taught programmer and I have figured out most syntax but desigining my programs is a challenge. I realize that there are many ways to design a program but what are some good rules to...
20
by: Brad Pears | last post by:
I am completely new to vb .net. I am using visual Studio 2005 to redo an Access 2000 application into a .net OO application using SQL Server 2000 - so a complete rewrite and re-thinking of how...
23
by: JohnH | last post by:
I'm just recently come to work for an auto brokerage firm. My position involves performing mysterious rites, rituals and magick in order to get information out of their access database. This is...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.