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

SYBASE DOES ABOUT TURN ON ITS ROW LEVEL LOCKING POLICY

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.

á

Content from our partners
Unlocking growth through hybrid cloud: 5 key takeaways
How businesses can safeguard themselves on the cyber frontline
How hackers’ tactics are evolving in an increasingly complex landscape

Websites in our network
Select and enter your corporate email address 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.
  • CIO
  • CTO
  • CISO
  • CSO
  • CFO
  • CDO
  • CEO
  • Architect Founder
  • MD
  • Director
  • Manager
  • Other
Visit our privacy policy for more information about our services, how New Statesman Media Group may use, process and share your personal data, including information on your rights in respect of your personal data and how you can unsubscribe from future marketing communications. Our services are intended for corporate subscribers and you warrant that the email address submitted is your corporate email address.
THANK YOU