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 3 1447
"Will Honea" <wh****@yahoo.c om> 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.
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.wash ington.edu
(replace 'x' with 'u' to respond)
"Will Honea" <wh****@yahoo.c om> 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 "performanc e wizard" to adjust your
configuration.
Of course, I don't mean you don't need to consider the db design. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 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 developer writes, find a method that matches a
|
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 design
and implimentation.
Currently I have a portable "ScriptSession" class which contains the
mechanics of looping with a user prompt, parsing a sentence and
handling syntax errors, etc., and I wan this to be a class I can use
for any script...
|
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 abstract parent
with four basic functions: Open, Read, Write, and Close.
// Note alot of the stuff has been left out
// just to give a basic picture
class IO
{
public:
|
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 the server.
However, our customer requests that both of these two objectives to be
supported by the design of the solution:
1. The photos should be encoded as JPG, and resized (if larger than a
|
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 developer writes, find a method that matches a
particular interface, and call it.
I know, in general, I should be looking at the reflection classes. Does
anyone have any design advice for me, or good working examples that would
serve as a...
| |
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. Also describes implementation
via ChangeManager (Mediator + Singleton)
2) Pattern hatching by John Vlissides
Describes Observer's implementation via Visitor Design Pattern.
3) Design Patterns Explained by Alan Shalloway and James Trott
|
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 can increase or decrease at
any time.
I'm looking for some advice on how to best design the windows form for
users to enter hours for the projects they worked on that week. I was
thinking about using a comboBox to list each project with a text...
|
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 follow for
creating a program?
I am writing a map game program. I created several objects: board
object that is an array of integers each number 0-5 is a kind of
terrain, a terrain object that is an array of terrain types and each
number of...
|
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 this app will work.
I have NEVER done any OO programming at all although I have used OO
techniques in programs of course - just never actually designed the classes
etc...
So I am just a tad nervous in re-writing this Access application as it is...
|
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 due to
the fact that the "designer" they hired had an unfortunate ability to
tink around with a program far beyond her reach. She had no concept
of any of the principles of database design, so what i'm left with is
a junkpile. The only reason I...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |