🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: net.database
Article #141

Re: UNIX + database (long quick overview)

#141
From: Jeff Anton
Date: Thu, 29 Aug 1985 18:20
38 lines
2431 bytes
In article <5909@utzoo.UUCP> henry@utzoo.UUCP (Henry Spencer) writes:
>> Locking (concurrency): Locking, what locking?
>> UNIX file locking schemas are, in general, bad.
>> ...
>> A DBMS would be well off with three (3) levels of locks,
>> (operating system people LISTEN!)  ...
>
>If you database people could manage to get your act together and agree
>on something for more than 15 milliseconds, maybe we *would* listen.
>The main reason nobody wants to put database-oriented locking into an
>operating system is that no two database people agree on what they want.
>
>The existing Unix locking schemes are simple, hence often inadequate,
>because nobody wants to go through the hassle of implementing a complex
>mechanism when there is no consensus on what it should look like.

Ok, no name calling.  File locking is a feature of almost every
major operating system.  UNIX aviods the issue and I can appreciate
the reasons.  UNIX has survived, in part, because what it does it
does in a generalized way.  What is needed is a generalized view
of file locking.  Simple applications such as mail (mail is not
that simple but stuffing mailboxs is) don't need more than flock(2).
Complex applications, DBMS's and custom databases, will need
better locking.  How about range locking with arbitrary levels
and user defined conflict conditions?  This should cover all the
bases.  I can imagine how to do it as well.  If the /usr/group lockf
call could be so generalized we could have backward compatability
and forward progress.

I know it's not all that simple.  But if I did build the above
locking call, would it be accepted by the OS world?  Maybe.
-- 
C knows no bounds.
					Jeff Anton
					U.C.Berkeley
					Ingres Group
					ucbvax!anton
					anton@BERKELEY.EDU
Technical Details
Message-ID: <10233@ucbvax.ARPA>
Path: arc1-ca.pugleaf.net!utzoo!watmath!clyde!burl!ulysses!ucbvax!anton
References: <10185@ucbvax.ARPA> <5909@utzoo.UUCP>

Show Full Headers
Complete Article Headers
Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP
Posting-Version: version B 2.10.3 4.3bsd-beta 6/6/85; site ucbvax.ARPA
Path: arc1-ca.pugleaf.net!utzoo!watmath!clyde!burl!ulysses!ucbvax!anton
From: anton@ucbvax.ARPA (Jeff Anton)
Newsgroups: net.database
Subject: Re: UNIX + database (long quick overview)
Message-ID: <10233@ucbvax.ARPA>
Date: Thu, 29-Aug-85 14:20:03 EDT
Article-I.D.: ucbvax.10233
Posted: Thu Aug 29 14:20:03 1985
Date-Received: Sat, 31-Aug-85 06:22:12 EDT
References: <10185@ucbvax.ARPA> <5909@utzoo.UUCP>
Reply-To: anton@ucbvax.UUCP (Jeff Anton)
Organization: University of California at Berkeley
Lines: 38