View all newsletters
Receive our newsletter - data, insights and analysis delivered to you
  1. Technology
February 21, 1997updated 05 Sep 2016 1:00pm


By CBR Staff Writer

Following our feature on Microsoft Corp’s ambitions to challenge the high-end relational database players with its SQL Server product a few weeks ago (CI No 3,099), Sybase Inc has confirmed that it is plumbing row-level locking into its SQL Server database, which will enable SAP AG’s R/3 business suite to run on top of it. Row-level locking, due by the end of the year, will mean the database can take advantage of lock management in other business packages from Baan Co NV and PeopleSoft Inc. Locking just a row of data instead of a bigger chunk, gives end users maximum access to data. But it means extra work for the database, which has to keep track of what records are being used and which are free. This can have the effect of dragging overall performance down. Sybase intends to do what the other players have done – Oracle Corp, Informix Software Inc and Computer Associates International Inc have all plumbed row-level locking into the database kernel. Having row-level locking in the kernel means a database can automatically switch to page level locking if there is heavy action, say, a batch update. Locking a bigger chunk – a page – frees the database from its extra management burden, and keeps performance up. When the load comes down again, the database can switch back to row-level locking and grant users greater access again.


Websites in our network
NEWSLETTER Sign up Tick the boxes of the newsletters you would like to receive. Tech Monitor's research, insight and analysis examines the frontiers of digital transformation to help tech leaders navigate the future. Our Changelog newsletter delivers our best work to your inbox every week.
I consent to New Statesman Media Group collecting my details provided via this form in accordance with the Privacy Policy