Skip to main content
Log in

A cautious scheduler for multistep transactions

  • Published:
Algorithmica Aims and scope Submit manuscript

Abstract

Given a classC of serializable schedules, a cautiousC-scheduler is an on-line transaction scheduler that outputs schedules in classC and never resorts to rollbacks. Such a scheduler grants the current request if and only if the partial schedule it has granted so far, followed by the current request, can be extended to a schedule inC. A suitable extension is searched among the set of all possible sequences of the pending steps, which are predeclared by the transactions whose first requests have already arrived. If the partial schedule cannot be extended to a schedule inC, then the current request is delayed. An efficient cautiousCPSR-scheduler has been proposed by Casanova and Bernstein.

This paper discusses cautiousWRW-scheduling, whereWRW is the largest polynomially recognizable subclass of serializable schedules currently known. Since cautiousWRW-scheduling is, in general, NP-complete as shown in this paper, we introduce, a subclass (namedWRW #) ofWRW and discuss an efficient cautiousWRW #-scheduler. We also show that the fixed point set of the cautiousWRW #-scheduler properly containsCPSR. Therefore, ourWRW #-scheduler allows more concurrency than anyCPSR- scheduler.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  1. P. A. Bernstein, D. W. Shipman, and S. W. Wong, Formal aspects of serializability in database concurrency control,IEEE Trans. Software Engrg.,SE-5, 3 (May 1979), 203–216.

    Article  MathSciNet  Google Scholar 

  2. G. N. Buckley and A. Silberschatz, Obtaining progressive protocols for a simple multiversion database model,Proc. 9th Int. Conf. on VLDB, Oct/Nov 1983, pp. 74–80.

  3. M. J. Carey, The performance of concurrency control algorithms for database management systems, Computer Sciences Tech. Rept. No. 530, University of Wisconsin, Madison, 1984.

    Google Scholar 

  4. M. A. Casanova and P. A. Bernstein, General purpose schedulers for database systems,Acta Inform.,14 (1980), 195–220.

    Article  MATH  MathSciNet  Google Scholar 

  5. M. A. Casanova, The concurrency control problem for database systems, Lecture Notes in Computer Science, Vol. 116, Springer-Verlag, Berlin, 1981.

    Google Scholar 

  6. M. R. Garey and D. S. Johnson,Computers and Intractability-A Guide to the Theory of NP-Completeness, Freeman, San Francisco, 1979.

    MATH  Google Scholar 

  7. T. Ibaraki, T. Kameda, and T. Minoura, Serializability made simple, Tech. Rept. LCCRTR82-12, Department of CS, Simon Fraser University, Burnaby, BC, Dec. 1982.

    Google Scholar 

  8. T. Ibaraki, T. Kameda, and T. Minoura, Disjoint-interval topological sort: a useful concept in serializability theory,Proc. 9th Int. Conf. on VLDB, Oct/Nov 1983, pp. 89–91.

  9. T. Ibaraki, T. Kameda, and N. Katoh, Cautious transaction schedulers for database concurrency control, LCCR Tech. Rep. 85-6, Laboratory for Computer and Communications Research, Simon Fraser University, Burnaby, BC, 1985.

    Google Scholar 

  10. N. Katoh, T. Ibaraki, and T. Kameda, Cautious transaction schedulers with admission control,ACM Trans. Database Systems,10, 2 (June 1985), 205–229.

    Article  MATH  Google Scholar 

  11. H. T. Kung and C. H. Papadimitriou, An optimality theory of concurrency control for databases,Proc. ACM-SIGMOD Int. Conf. on Management of Data, Boston, May 1979, pp. 116–126.

  12. C. H. Papadimitriou, The serializability of concurrent database updates,J. Assoc. Comput. Mach.,26, 4 (Oct. 1979), 631–653.

    MATH  MathSciNet  Google Scholar 

  13. C. H. Papadimitriou, A theorem in database concurrency control,J. Assoc. Comput. Mach.,29, 4 (Oct. 1982), 998–1006.

    MATH  MathSciNet  Google Scholar 

  14. R. Sethi, A model of concurrent database transactions,Proc. 22nd IEEE Symp. Foundation of Comp. Sci., Oct. 1981, pp. 175–184.

  15. R. Sethi, Useless actions make a difference: Strict serializability of database updates,J. Assoc. Comput. Mach.,29, 2 (April 1982), 394–403.

    MATH  Google Scholar 

  16. M. Yannakakis, Issues of correctness in database concurrency control by locking,Proc. ACM Symp. Theory of Computing, May 1981, pp. 363–367.

Download references

Author information

Authors and Affiliations

Authors

Additional information

Communicated by C. K. Wong.

This work was supported in part by the Natural Sciences and Engineering Research Council of Canada under Grant No. A5240 and in part by the Ministry of Education, Science and Culture of Japan under Scientific Research Grant-in-Aid.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Katoh, N., Kameda, T. & Ibaraki, T. A cautious scheduler for multistep transactions. Algorithmica 2, 1–26 (1987). https://doi.org/10.1007/BF01840347

Download citation

  • Received:

  • Revised:

  • Issue Date:

  • DOI: https://doi.org/10.1007/BF01840347

Key words

Navigation