Re: How to create a DBMS from scratch?

From: Robert Sundström <robert.sundstrom_at_upright.se>
Date: Thu, 17 Oct 2002 12:25:17 GMT
Message-ID: <aom9vi$i3n$1@yggdrasil.utfors.se>

In article <aogmib$mdf57$1_at_ID-158542.news.dfncis.de>, "manuel" <mrm_at_cemag.de> wrote:
>I would also recommend reading 'Transaction processing: concepts and
>Techniques'Jim Gray and Andreas Reuter. it describes the basic concepts of
>tp monitors but has quite a complete chapter on indexing and locking.

Not that I believe concurrency control was within the scope of the original posters assignment but one problem with that book is that is talks a lot about locking protocols and treats other sorts of concurrency protocols (such as optimistic concurrency control) as mere 'exotics'. The only reason locking has catched on in the database world is that it is a simple concept to understand.

In nearly all aspects locking is inferior, mainly because it restricts access _other_ users access to data. A poorly written application will degrade server performance uniformly, which open up for a bag of administration hassles on large systems with many applications.

-
Robert Sundström, Mimer SQL Development
Upright Database Technology AB, http://www.mimer.com Validate your SQL statements at http://developer.mimer.com/parser Received on Thu Oct 17 2002 - 07:25:17 CDT