Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Skip to main content
Springer Nature Link
Log in

Priority Scheduling of Transactions in Distributed Real-Time Databases

  • Published:
Real-Time Systems Aims and scope Submit manuscript

Abstract

One of the most important issues in the design of distributed real-time database system (DRTDBS) is transaction scheduling which consists of two parts: priority scheduling and real-time concurrency control. In the past studies, mostly, these issues are studied separately although they have a very close interaction with each other. In this paper, we propose new priority assignment policies for DRTDBS and study their impact on two typical real-time concurrency control protocols (RT-CCPs), High Priority Two Phase Locking (HP-2PL) and Optimistic Concurrency Control with Broadcast Commit (OCC-BC). Our performance results show that many factors, such as data conflict resolution, degree of data contention and transaction restarts, that are unique to database systems, have significant impact on the performance of the policies which in turn affect the performance of the real-time concurrency control protocols. OCC-BC is more affected by the priority assignment policies than HP-2PL owing to the late detection of conflict. In the design of priority assignment policies, we have found that neither the purely deadline driven policies nor data contention driven policies are suitable for DRTDBS. Our proposed policy, the Mixed Method (MM), which considers both transaction timeliness and data contention, outperforms other policies over a wide range of system parameter settings.

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

Access this article

Log in via an institution

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

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

  • Abbott, R., Garcia-Molina, H. 1990. Scheduling I=O requests with deadlines: A performance evaluation. Proc. IEEE Real-Time Systems Symposium.

  • Abbott, R., and Garcia-Molina, H. 1992. Scheduling real-time transactions: A performance evaluation. ACM Transactions on Database Systems 17(3): 513–560.

    Google Scholar 

  • Adelberg, B., Kao, B., and Garcia-Molina, H. 1994. Emulating soft real-time scheduling using traditional operating scheduler. Proc.Real-time Systems Symposium. San Juan, pp. 292–298.

  • Aranha, R. F. M., Ganti, V., Narayanan, S., Muthukrishnan, C. R., Prasad, S. T. S., and Ramamritham, K. 1996. Implementation of real-time database system. Information Systems 21(1): 55–74.

    Google Scholar 

  • Bernstein, P. A., Hadzilacos, V., and Goddman, N. 1987. Concurrency Control and Recovery in DatabaseSystems. Mass.: Addison-Wesley.

    Google Scholar 

  • Bestavros, A. 1996. Advances in real-time database systems research. ACM SIGMOD Record 25(1): 3–7.

    Google Scholar 

  • Bestarvos, A., Lin, K. J., and Son, S. H. 1997. Real-time Database Systems: Issues and Applications. Mass.: Kluwer Academic.

    Google Scholar 

  • Ceri, S., and Pelagatti, G. 1985. Distributed Databases: Principles and Systems. Singapore: McGraw-Hill.

    Google Scholar 

  • Chen, Y. W., and Gruenwald, L. 1996. Effects of deadline propagation on scheduling nested transactions in distributed real-time database systems. Information Systems 21(1): 103–124.

    Google Scholar 

  • Gray, J., and Reuter, A. 1993. Transaction Processing: Concepts and Techniques. California: Morgan Kaufmann.

    Google Scholar 

  • Haritsa, J. R., Livny, M., and Carey, M. J. 1990. On being optimistic about real-time constraints. Proc.9th ACM Symposium on Principles of Database Systems.

  • Haritsa, J. R., Livny, M., and Carey, M. J. 1991. Earliest deadline scheduling for real-time database systems. Proc.IEEE Real-Time System Symposium, pp. 232–242.

  • Haritsa, J. R., Carey, M. J., and Livny, M. 1992. Data access scheduling in firm real-time database systems. Journal of Real-Time Systems 4(3): 203–242.

    Google Scholar 

  • Haritsa, J. R., Livny, M., and Carey, M. J. 1993. Value-based scheduling in real-time database systems. The VLDB Journal 2(2): 117–152.

    Google Scholar 

  • Huang, J., and Stankovic, J. 1991. Experimental evaluation of real-time concurrency control schemes. Proc.17th VLDB Conference, pp. 35–46.

  • Huang, J., Stankovic, J., Ramamritham, K., and Towsley, D. 1992. Priority inheritance in soft real-time databases. Journal of Real-Time Systems 4(3): 243–268.

    Google Scholar 

  • Kao, B., and Garcia-Molina, H. 1993. Deadline assignment in a distributed soft real-time system. Proc.13th International Conference on Distributed Computing Systems, pp. 428–437.

  • Lam, K. Y., and Hung, S. L. 1995. Concurrency control for time-constrained transactions in distributed databases systems. The Computer Journal 38(9): 704–715.

    Google Scholar 

  • Lee, J., and Son, S. H. 1993. Using dynamic adjustment of serialization order for real-time database systems. Proc.14th IEEE Real-time Systems Symposium. North Carolina, pp. 66–75.

  • Lee, V. C. S., Lam, K. Y., and Hung, S. L. 1996. Impact of high speed network on performance of distributed real-time database systems. Journal of Systems Architecture 42(6/7): 531–546.

    Google Scholar 

  • Liu, C. L., and Layland, J. L. 1973. Scheduling algorithms for multiprogramming in a hard-real-time environment. Journal of ACM 20(1): 46–61.

    Google Scholar 

  • OPNET Modeling Manual. 1996. Release 2.5, Washington, DC: MIL 3 Inc.

    Google Scholar 

  • Ozsoyoglu, G., and Snodgrass, R. T. 1995. Temporal and real-time databases: A survey. IEEE Transactions on Knowledge and Data Engineering 7(4): 513–532.

    Google Scholar 

  • Pang, H., Livny, M., and Carey, M. J. 1992. Transaction scheduling in multiclass real-time database systems. Proc.IEEE Real-Time Systems Symposium.

  • Purimetla, B., Sivasankaran, R. M., Stankovic, J. A., Ramamritham, K., and Towsley, D.1994. Priority assignment in real-time active databases. Proc.3rd International Conference on Parallel and Distributed Information Systems. Austin, pp. 176–184.

  • Purimetla, B., et al. 1996. Real-time databases: Issues and applications. Advances in Real-Time Systems. Prentice Hall.

  • Ramamritham, K. 1993. Real-time databases. International Journal of Distributed and Parallel Databases 1(2).

  • Stankovic, J., Spuri, M., and Natale, M. D. 1995. Implications of classical scheduling results for real-time systems. IEEE Computer 28(6): 16–25.

    Google Scholar 

  • Ulusoy, O. 1994. Processing of real-time transactions in a replicated database systems. Journal of Distributed and Parallel Databases 2(4): 405–436.

    Google Scholar 

  • Ulusoy, O. 1995. An evaluation of network access protocols for distributed real-time database systems. Proc.1st International Workshop on Active and Real-time Database Systems. Sweden.

  • Xiong, M., Stankovic, J. A., Ramamritham, K., Towley, D., and Sivasankaran, R. 1996. Maintaining temporal consistency: Issues and algorithms. Proc.First International Workshops on Real-time Databases: Issues and Applications. California, pp. 2–7.

  • Xiong, M., Sivasankaran, R., Stankovic, J. A., Ramamritham, K., and Towley, D. 1997. Scheduling access to temporal data in real-time databases. Real-Time Database Systems: Issues and Applications. Mass.: Kluwer Academc.

    Google Scholar 

  • Yu, P. S., Wu, K. L., Lin, K. J., and Son, S. H. 1994. On real-time databases: Concurrency control and scheduling. Proceedings of IEEE 82(1): 140–157.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Dept. of Computer Science, City University of Hong Kong, 83 Tat Chee Avenue, Kowloon, Hong Kong

    Victor C. S. Lee

  2. Dept. of Computer Science, City University of Hong Kong, 83 Tat Chee Avenue, Kowloon, Hong Kong

    Kam-Yiu Lam

  3. Dept. of Computer Science, The University of Hong Kong, Pokfulam, Hong Kong

    Ben Kao

Authors
  1. Victor C. S. Lee
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Kam-Yiu Lam
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Ben Kao
    View author publications

    You can also search for this author in PubMed Google Scholar

Rights and permissions

Reprints and permissions

About this article

Cite this article

Lee, V.C.S., Lam, KY. & Kao, B. Priority Scheduling of Transactions in Distributed Real-Time Databases. Real-Time Systems 16, 31–62 (1999). https://doi.org/10.1023/A:1008003902423

Download citation

  • Issue Date:

  • DOI: https://doi.org/10.1023/A:1008003902423

Search

Navigation