增值锁:同时支持DBMS中的事务和查询

[1992 Proceedings] Second International Workshop on Research Issues on Data Engineering: Transaction and Query Processing Pub Date : 1992-02-02 DOI:10.1109/RIDE.1992.227428

Luis L. Cova, Wei Sun

{"title":"增值锁:同时支持DBMS中的事务和查询","authors":"Luis L. Cova, Wei Sun","doi":"10.1109/RIDE.1992.227428","DOIUrl":null,"url":null,"abstract":"This paper presents an approach value-added locking (VAL), that allows effective transaction processing and the execution of complex, read-only, and long-lived queries simultaneously on the same database. VAL integrates the concepts of altruistic locking and quasi-copies to provide a mechanism that allows users, application designers to database administrators to fine-tune the system performance in terms of transaction throughput and queries' average response times. By deploying VAL, a significant gain in system performance may be expected. It also shows that a conventional concurrency control mechanisms such as 2-phase locking becomes a special case of the approach.<<ETX>>","PeriodicalId":138660,"journal":{"name":"[1992 Proceedings] Second International Workshop on Research Issues on Data Engineering: Transaction and Query Processing","volume":"52 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"1992-02-02","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Value-added locking: concurrently supporting transactions and queries in DBMS\",\"authors\":\"Luis L. Cova, Wei Sun\",\"doi\":\"10.1109/RIDE.1992.227428\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"This paper presents an approach value-added locking (VAL), that allows effective transaction processing and the execution of complex, read-only, and long-lived queries simultaneously on the same database. VAL integrates the concepts of altruistic locking and quasi-copies to provide a mechanism that allows users, application designers to database administrators to fine-tune the system performance in terms of transaction throughput and queries' average response times. By deploying VAL, a significant gain in system performance may be expected. It also shows that a conventional concurrency control mechanisms such as 2-phase locking becomes a special case of the approach.<<ETX>>\",\"PeriodicalId\":138660,\"journal\":{\"name\":\"[1992 Proceedings] Second International Workshop on Research Issues on Data Engineering: Transaction and Query Processing\",\"volume\":\"52 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"1992-02-02\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"[1992 Proceedings] Second International Workshop on Research Issues on Data Engineering: Transaction and Query Processing\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/RIDE.1992.227428\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"[1992 Proceedings] Second International Workshop on Research Issues on Data Engineering: Transaction and Query Processing","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/RIDE.1992.227428","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 0

摘要

本文提出了一种增值锁定(VAL)方法，它允许在同一数据库上同时进行有效的事务处理和执行复杂的、只读的和长期存在的查询。VAL集成了利他锁定和准复制的概念，提供了一种机制，允许用户、应用程序设计人员和数据库管理员根据事务吞吐量和查询的平均响应时间对系统性能进行微调。通过部署VAL，可以预期系统性能的显著提高。它还表明，传统的并发控制机制(如两阶段锁定)成为该方法的一种特殊情况

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

Value-added locking: concurrently supporting transactions and queries in DBMS

This paper presents an approach value-added locking (VAL), that allows effective transaction processing and the execution of complex, read-only, and long-lived queries simultaneously on the same database. VAL integrates the concepts of altruistic locking and quasi-copies to provide a mechanism that allows users, application designers to database administrators to fine-tune the system performance in terms of transaction throughput and queries' average response times. By deploying VAL, a significant gain in system performance may be expected. It also shows that a conventional concurrency control mechanisms such as 2-phase locking becomes a special case of the approach.<>

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

[1992 Proceedings] Second International Workshop on Research Issues on Data Engineering: Transaction and Query Processing

自引率

0.00%

发文量