Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!lnewsoutpeer00.lnd.ops.eu.uu.net!lnewsinpeer01.lnd.ops.eu.uu.net!emea.uu.net!news.sap-ag.de!news2!news.sap-ag.de!not-for-mail From: Daniel Dittmar Newsgroups: comp.databases.theory Subject: Re: ACID et al Date: Tue, 06 Dec 2005 13:30:20 +0100 Organization: SAP AG Lines: 27 Message-ID: References: <1133799611.341204.196810@z14g2000cwz.googlegroups.com> <1133808898.178219.154100@g47g2000cwa.googlegroups.com> <1133811654.468941.69150@f14g2000cwb.googlegroups.com> <1133867370.295735.64380@f14g2000cwb.googlegroups.com> NNTP-Posting-Host: p123523.dhcp.ber.sap.corp Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Trace: news.sap-ag.de 1133872220 22204 10.29.14.93 (6 Dec 2005 12:30:20 GMT) X-Complaints-To: newsmaster@sap.com NNTP-Posting-Date: Tue, 6 Dec 2005 12:30:20 +0000 (UTC) User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en In-Reply-To: <1133867370.295735.64380@f14g2000cwb.googlegroups.com> Xref: dp-news.maxwell.syr.edu comp.databases.theory:34910 vc wrote: > Daniel Dittmar wrote: > [...] > >>But the database engines still need row level locking (database engines >>using page level locking were not scalable enough). While db locks might >>be less relevant in certain parts of the system, they seem to be still >>very important in others. >> >>Daniel > > > Did you read what the OP actually wrote ? He does not need any > concurrency control as access to the DB is serial. > The OP thinks that most concurrency issues are handled better in the application layer than in the database layer. I described an architecture that does *mostly* that. I rephrase 'But the database engines still need row level locking' as: It is a requirement for database engines used with SAP R/3 to support row level locking. Therefor, the description in my post does not tell the complete story. An important piece is missing for which I don't have the details. Daniel