[dba-Tech] database

John Bartow john at winhaven.net
Sat Jan 26 13:32:59 CST 2013


This is the stuff I love to do!

But I will not fog the waters for you.

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Saturday, January 26, 2013 12:45 PM
To: 'Discussion of Hardware and Software issues'
Subject: Re: [dba-Tech] database

Those were my initial thoughts but then there would be issues with inventory
and the related accounting. 

Then there is the issues with whether a client ever had an unpaid invoice, a
bankruptcy or even association issues that will a have to be rolled forward
and records will still have to be flagged and situations noted. There is
also the thresholds that may establish a client, supplier or even staff as
"rated highly", "to watch" or "do not do business with" as incidents before
the five year cut-off must be carried forward. 

Some inventory has been active for twenty years while other items not...
Then there is the accounting, security and transaction files. Then there are
the issues of how much should be carried forward, in summary files... The
clients still wants to be able to chart activity even though it may have
been rolled up to five years...setting averages, viewing trends,
inventory/equipment quality, and so on.

Then there has been a lot of bad practices, especially in the accounting
where a series of book-keepers were suppose to manage things...now the
company has a real Chartered Accountant...a breathe of fresh air. 

As you are an expert at business practices any thoughts and cautions would
be appreciated?

Jim

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Saturday, January 26, 2013 10:18 AM
To: 'Discussion of Hardware and Software issues'
Subject: Re: [dba-Tech] database

Modifying the relationships to cascade delete? 

Rocky


-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Saturday, January 26, 2013 10:02 AM
To: 'Discussion of Hardware and Software issues'
Subject: [dba-Tech] database

Today and tomorrow I will be working on a huge database.

It has records going back to the late eighties and the client wants the
whole system cleared except for the last five years. Clearing data is not
difficult but leaving no orphaned records is. There are over a hundred
inter-related tables and I have been planning this with the client for a
couple of months and today is the day (the company's year-end).

Has any one else had similar experiences and any insights, recommendations
and so on?

Jim

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com



More information about the dba-Tech mailing list