System und Verfahren zur Transaktionsbearbeitung mit verminderter Verriegelung

摘要

Apparatus and method for reading data pages 33 in a transaction processing system 20 without locking the pages are disclosed. The system maintains a Global_Committed_LSN 36 identifying the oldest uncommitted transaction accessing any of the data, and Object_Committed_LSNs 38a,38b identifying the oldest uncommitted transactions accessing particular files, tables and indexes. Each data page includes a Page_LSN 35 identifying the last transaction to have updated the page. To read a page, a transaction first latches the pages, and compares the page s Page_LSN with the Global_Committed_LSN, or with the page's respective Object_Committed_LSN. If the Page_LSN is older than the Committed_LSN with which is was compared, then the transaction reads the page without locking it, since there can be no uncommitted transaction in process which might have updated the page's data. However if the Page_LSN is younger than the Committed_LSN, the page is locked before being read.