Re: In defense of the lowly MR

Jim,

At 08:50 AM 6/5/97 -0700, you wrote:

>> The computing public has come to expect real-time databases, and by not
>> deleting children records you run the risk of serving your users dirty data.
>
>By using joined master, childern logicals, the orphaned children are
>excluded and do not provide misleading hash totals.  "Real-time" is a
>perception of data presentation, not necessarily of data retainage.

The problem is; you (we) are no longer the sole arbiter of data
presentation.  Data users now have query tools, ODBC, file transfer, etc.
The data you once gaurded so jealously can now be strewn across a far-flung
network of disparate systems where your presentation techniques are not
acknowledged.  No, the database has to contain the whole "truth", and not
rely on clever programming in order to be interpretted correctly.

>> 
>> No need to lock a record that you're not prepared to change immently.  As
>> long as you don't lock on every read, locks are nothing to be afraid of.
>
>I believe by nature a UP processed file would lock each record as it
>went.

Then why use UP?  Better to use IF and UF versions of the same file, and
only read records with the IF version until precisely before you're ready to
update.  You have no way to prevent a user from bringing a record up on
screen and then running off to a two hour meeting, but you can, and should,
prevent them from holding a record lock for that two hours.

JMHO, of course.

jte
*************************************************
* John Earl     Gig Harbor, Washington  U.S.    *
* Email:        johnearl@blarg.net              *
*************************************************

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *