Skip to main content
Erschienen in: The Journal of Supercomputing 7/2021

02.01.2021

A contention aware EQS priority assignment heuristic for cohorts in DRTDBS

verfasst von: Sarvesh Pandey, Udai Shanker

Erschienen in: The Journal of Supercomputing | Ausgabe 7/2021

Einloggen

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

search-config
loading …

Abstract

The equal slack (EQS) priority assignment method has shown promising results with distributed real-time systems. As a result, the EQS is considered the first choice for distributed real-time database systems (DRTDBS). However, the integration of EQS with the DRTDBS comes at cost of many issues—intensive data contention due to dynamic cohort priority assignment, global deadlock, and wastage of resources due to cyclic restart. To address the above problems, this paper proposes a contention aware equal slack (CA-EQS) priority assignment heuristic. The CA-EQS heuristic reduces the data contention by utilizing the size of the cohort dependency. After the execution of the first cohort, the information about its size of dependency will be piggybacked with the message that initiates the execution of immediately next cohort of a parent transaction at some other site. The reason for going with the piggybacking approach is that the dependency size of the currently executing cohort not only depends on the data items locked by it but also on the data items that are locked by the cohorts that have already completed their execution before it. This way, a true data contention level can be assessed without any extra overhead (message and time). The CA-EQS solves the problem of deadlock and cyclic restart. Results from the simulation tool validate up to 9% drop in transactions miss ratio and up to 16% reduction in a number of transactions’ rollbacks by the CA-EQS heuristic over EQS, EQF, number of locks (NL), and most dependent transactions first (MDTF).

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Literatur
1.
Zurück zum Zitat Pandey S, Shanker U (2020) Transaction scheduling protocols for controlling priority inversion: a review. Comput Sci Rev 35:100215MathSciNetCrossRef Pandey S, Shanker U (2020) Transaction scheduling protocols for controlling priority inversion: a review. Comput Sci Rev 35:100215MathSciNetCrossRef
2.
Zurück zum Zitat Pandey S, Shanker U (2016) Transaction execution in distributed real-time database systems. In: Proceedings of the International Conference on Innovations in information Embedded and Communication Systems, pp 96–100 Pandey S, Shanker U (2016) Transaction execution in distributed real-time database systems. In: Proceedings of the International Conference on Innovations in information Embedded and Communication Systems, pp 96–100
3.
Zurück zum Zitat Pandey S, Shanker U (2017) On using priority inheritance based distributed static two phase locking protocol. In: Proceedings of the International Conference on Data and Information System (ICDIS), pp 179–188 Pandey S, Shanker U (2017) On using priority inheritance based distributed static two phase locking protocol. In: Proceedings of the International Conference on Data and Information System (ICDIS), pp 179–188
4.
Zurück zum Zitat Bernstein P, Hadzilacos V, Goodman N (1987) Concurrency control and recovery in database systems. Addison-wesley, Reading Bernstein P, Hadzilacos V, Goodman N (1987) Concurrency control and recovery in database systems. Addison-wesley, Reading
5.
Zurück zum Zitat Pandey S, Shanker U (2018) Priority inversion in DRTDBS: challenges and resolutions. In: Proceedings of the ACM India Joint International Conference on Data Science and Management of Data (CoDS-COMAD ‘18), pp 305–309 Pandey S, Shanker U (2018) Priority inversion in DRTDBS: challenges and resolutions. In: Proceedings of the ACM India Joint International Conference on Data Science and Management of Data (CoDS-COMAD ‘18), pp 305–309
6.
Zurück zum Zitat Lam K, Pang CL, Son S, Cao J (1999) Resolving executing-committing conflicts in distributed real-time database systems. Comput J 42(08):674–692CrossRef Lam K, Pang CL, Son S, Cao J (1999) Resolving executing-committing conflicts in distributed real-time database systems. Comput J 42(08):674–692CrossRef
7.
Zurück zum Zitat Lam KY (1994) Concurrency control in distributed real time database systems, PhD Thesis Lam KY (1994) Concurrency control in distributed real time database systems, PhD Thesis
8.
Zurück zum Zitat Abbott RK, Molina HG (1992) Scheduling real-time transactions: a performance evaluation. ACM Trans Database Syst 17(03):513–560CrossRef Abbott RK, Molina HG (1992) Scheduling real-time transactions: a performance evaluation. ACM Trans Database Syst 17(03):513–560CrossRef
9.
Zurück zum Zitat Haritsa JR, Carey MJ, Livny M (1992) Data access scheduling in firm real-time database systems. Real-Time Syst 04(03):203–241CrossRef Haritsa JR, Carey MJ, Livny M (1992) Data access scheduling in firm real-time database systems. Real-Time Syst 04(03):203–241CrossRef
10.
Zurück zum Zitat Shanker U, Misra M, Sarje AK (2008) Distributed real time database systems: background and literature review. Int J Distrib Parallel Databases 23(02):127–149CrossRef Shanker U, Misra M, Sarje AK (2008) Distributed real time database systems: background and literature review. Int J Distrib Parallel Databases 23(02):127–149CrossRef
11.
Zurück zum Zitat Lee V, Lam K, Kao B (1999) Priority scheduling of transactions in distributed real-time databases. Real-Time Syst 16(1):31–62CrossRef Lee V, Lam K, Kao B (1999) Priority scheduling of transactions in distributed real-time databases. Real-Time Syst 16(1):31–62CrossRef
12.
Zurück zum Zitat Liu CL, Layland JW (1973) Scheduling algorithms for multiprogramming in a hard-real-time environment. J ACM (JACM) 20(1):46–61MathSciNetCrossRef Liu CL, Layland JW (1973) Scheduling algorithms for multiprogramming in a hard-real-time environment. J ACM (JACM) 20(1):46–61MathSciNetCrossRef
13.
Zurück zum Zitat Pang H, Livny M, Carey MJ (1992) Transaction scheduling in multiclass real-time database systems. In: Proceedings of IEEE Real-Time Systems Symposium (RTSS), pp 23–34 Pang H, Livny M, Carey MJ (1992) Transaction scheduling in multiclass real-time database systems. In: Proceedings of IEEE Real-Time Systems Symposium (RTSS), pp 23–34
14.
Zurück zum Zitat Datta A, Mukherjee S, Konana P, Viguier I, Bajaj A (1996) Multiclass transaction scheduling and overload management in firm real-time database systems. Inf Syst 21(1):29–54CrossRef Datta A, Mukherjee S, Konana P, Viguier I, Bajaj A (1996) Multiclass transaction scheduling and overload management in firm real-time database systems. Inf Syst 21(1):29–54CrossRef
15.
Zurück zum Zitat Kao B, Garcia-Molina H (1997) Deadline assignment in a distributed soft real-time system. IEEE Trans Parallel Distrib Syst 8(12):1268–1274CrossRef Kao B, Garcia-Molina H (1997) Deadline assignment in a distributed soft real-time system. IEEE Trans Parallel Distrib Syst 8(12):1268–1274CrossRef
16.
Zurück zum Zitat Stankovic J, Ramamritham K, Towsley D (1991) Scheduling in real-time transaction systems. In: Foundations of real-time computing: scheduling and resource management, pp 157–184 Stankovic J, Ramamritham K, Towsley D (1991) Scheduling in real-time transaction systems. In: Foundations of real-time computing: scheduling and resource management, pp 157–184
17.
Zurück zum Zitat Shanker U, Misra M, Sarje AK (2006) SWIFT—a new real time commit protocol. Distrib Parallel Databases 20(01):29–56CrossRef Shanker U, Misra M, Sarje AK (2006) SWIFT—a new real time commit protocol. Distrib Parallel Databases 20(01):29–56CrossRef
18.
Zurück zum Zitat Lee VCS, Lam KW, Hung SL (2002) Concurrency control for mixed transactions in real-time databases. IEEE Trans Comput 51(07):821–834CrossRef Lee VCS, Lam KW, Hung SL (2002) Concurrency control for mixed transactions in real-time databases. IEEE Trans Comput 51(07):821–834CrossRef
19.
Zurück zum Zitat Ulusoy O (1995) A study of two transaction-processing architectures for distributed real-time data base systems. J Syst Softw 31(02):97–108CrossRef Ulusoy O (1995) A study of two transaction-processing architectures for distributed real-time data base systems. J Syst Softw 31(02):97–108CrossRef
20.
Zurück zum Zitat Bestavros A, Lin K, Son S (2012) Real-time database systems: issues and applications, vol 396. Springer, New YorkMATH Bestavros A, Lin K, Son S (2012) Real-time database systems: issues and applications, vol 396. Springer, New YorkMATH
21.
Zurück zum Zitat Davis RI, Cucu-Grosjean L, Bertogna M, Burns A (2016) A review of priority assignment in real-time systems. J Syst Architect 65:64–82CrossRef Davis RI, Cucu-Grosjean L, Bertogna M, Burns A (2016) A review of priority assignment in real-time systems. J Syst Architect 65:64–82CrossRef
22.
Zurück zum Zitat Audsley NC (2001) On priority assignment in fixed priority scheduling. Inform Process Lett 79(1):39–44CrossRef Audsley NC (2001) On priority assignment in fixed priority scheduling. Inform Process Lett 79(1):39–44CrossRef
23.
Zurück zum Zitat Audsley NC (1991) Optimal priority assignment and feasibility of static priority tasks with arbitrary start times. Technical Report YCS164, Real- Time Systems Research Group, Department of Computer Science, University of York, UK Audsley NC (1991) Optimal priority assignment and feasibility of static priority tasks with arbitrary start times. Technical Report YCS164, Real- Time Systems Research Group, Department of Computer Science, University of York, UK
24.
Zurück zum Zitat Begam R, Xia Q, Zhu D, Aydin H (2016) Preference-oriented fixed-priority scheduling for periodic real-time tasks. J Syst Architect 69:1–14CrossRef Begam R, Xia Q, Zhu D, Aydin H (2016) Preference-oriented fixed-priority scheduling for periodic real-time tasks. J Syst Architect 69:1–14CrossRef
25.
Zurück zum Zitat Zhao Y, Zeng H (2018) The concept of unschedulability core for optimizing real-time systems with fixed-priority scheduling. IEEE Trans Comput 68(6):926–938MathSciNetCrossRef Zhao Y, Zeng H (2018) The concept of unschedulability core for optimizing real-time systems with fixed-priority scheduling. IEEE Trans Comput 68(6):926–938MathSciNetCrossRef
26.
Zurück zum Zitat Zhao Y, Zeng H (2019) The concept of maximal unschedulable deadline assignment for optimization in fixed-priority scheduled real-time systems. Real-Time Syst 55(3):667–707CrossRef Zhao Y, Zeng H (2019) The concept of maximal unschedulable deadline assignment for optimization in fixed-priority scheduled real-time systems. Real-Time Syst 55(3):667–707CrossRef
27.
Zurück zum Zitat Davis R, Bertogna M, Bonifaci V (2016) On the compatibility of exact schedulability tests for global fixed priority pre-emptive scheduling with Audsley’s optimal priority assignment algorithm. Real-Time Syst 52:113–122CrossRef Davis R, Bertogna M, Bonifaci V (2016) On the compatibility of exact schedulability tests for global fixed priority pre-emptive scheduling with Audsley’s optimal priority assignment algorithm. Real-Time Syst 52:113–122CrossRef
28.
Zurück zum Zitat Chishiro H, Takeda A, Funaoka K, Yamasaki N (2010) Semi-fixed-priority scheduling: new priority assignment policy for practical imprecise computation. In: IEEE 16th International Conference on Embedded and Real-Time Computing Systems and Applications Chishiro H, Takeda A, Funaoka K, Yamasaki N (2010) Semi-fixed-priority scheduling: new priority assignment policy for practical imprecise computation. In: IEEE 16th International Conference on Embedded and Real-Time Computing Systems and Applications
29.
Zurück zum Zitat Lee J, Chwa HS, Lee J, Shin I (2016) Thread-level priority assignment in global multiprocessor scheduling for DAG tasks. J Syst Softw 113:246–256CrossRef Lee J, Chwa HS, Lee J, Shin I (2016) Thread-level priority assignment in global multiprocessor scheduling for DAG tasks. J Syst Softw 113:246–256CrossRef
30.
Zurück zum Zitat He Q, Guan N, Guo Z (2019) Intra-task priority assignment in real-time scheduling of dag tasks on multi-cores. IEEE Trans Parallel Distrib Syst 30(10):2283–2295CrossRef He Q, Guan N, Guo Z (2019) Intra-task priority assignment in real-time scheduling of dag tasks on multi-cores. IEEE Trans Parallel Distrib Syst 30(10):2283–2295CrossRef
31.
Zurück zum Zitat Maxim D, Buffet O, Santinelli L, Cucu-Grosjean L, Davis RI (2011) Optimal priority assignment algorithms for probabilistic real-time systems. In: RTNS, pp 129–138 Maxim D, Buffet O, Santinelli L, Cucu-Grosjean L, Davis RI (2011) Optimal priority assignment algorithms for probabilistic real-time systems. In: RTNS, pp 129–138
32.
Zurück zum Zitat Peng B, Fisher N, Chantem T (2016) MILP-based deadline assignment for end-to-end flows in distributed real-time systems. In: The 24th International Conference on Real-Time Networks and Systems Peng B, Fisher N, Chantem T (2016) MILP-based deadline assignment for end-to-end flows in distributed real-time systems. In: The 24th International Conference on Real-Time Networks and Systems
33.
Zurück zum Zitat Haritsa JR, Ramamritham K, Gupta R (2000) The PROMPT real-time commit protocol. IEEE Trans Parallel Distrib Syst 11(02):160–181CrossRef Haritsa JR, Ramamritham K, Gupta R (2000) The PROMPT real-time commit protocol. IEEE Trans Parallel Distrib Syst 11(02):160–181CrossRef
34.
Zurück zum Zitat Haritsa JR, Livny M, Carey MJ (1991) Earliest deadline scheduling for real-time database systems. In: Twelfth, Real-Time Systems Symposium, Proceedings. IEEE, pp 232–242 Haritsa JR, Livny M, Carey MJ (1991) Earliest deadline scheduling for real-time database systems. In: Twelfth, Real-Time Systems Symposium, Proceedings. IEEE, pp 232–242
35.
Zurück zum Zitat Haritsa JR, Livny M, Carey MJ (1991) Earliest deadline scheduling for real-time database systems. Madison, WICrossRef Haritsa JR, Livny M, Carey MJ (1991) Earliest deadline scheduling for real-time database systems. Madison, WICrossRef
36.
Zurück zum Zitat Lee VC, Lam KY, Kao B, Lam KW, Hung SL (1996) Priority assignment for sub-transaction in distributed real-time databases. In: RTDB Lee VC, Lam KY, Kao B, Lam KW, Hung SL (1996) Priority assignment for sub-transaction in distributed real-time databases. In: RTDB
37.
Zurück zum Zitat Lee VV, Lam KY, Hung SL (1995) Virtual deadline assignment in distributed real-time database systems. In: Proceedings Second International Workshop on Real-Time Computing Systems and Applications. IEEE Lee VV, Lam KY, Hung SL (1995) Virtual deadline assignment in distributed real-time database systems. In: Proceedings Second International Workshop on Real-Time Computing Systems and Applications. IEEE
38.
Zurück zum Zitat Pandey S, Shanker U (2018) IDRC: a distributed real-time commit protocol. Proc Comput Sci 125:290–296CrossRef Pandey S, Shanker U (2018) IDRC: a distributed real-time commit protocol. Proc Comput Sci 125:290–296CrossRef
39.
Zurück zum Zitat Pandey S, Shanker U (2018) A one phase priority inheritance commit protocol. In: Proceedings of the 14th International Conference on Distributed Computing and Information Technology (ICDCIT) Bhubaneshwar, India Pandey S, Shanker U (2018) A one phase priority inheritance commit protocol. In: Proceedings of the 14th International Conference on Distributed Computing and Information Technology (ICDCIT) Bhubaneshwar, India
40.
Zurück zum Zitat Pandey S, Shanker U (2018) CART: a real-time concurrency control protocol. In: Desai BC, Hong J, McClatchey R (eds) 22nd International Database Engineering and Applications Symposium (IDEAS 2018). ACM, New York Pandey S, Shanker U (2018) CART: a real-time concurrency control protocol. In: Desai BC, Hong J, McClatchey R (eds) 22nd International Database Engineering and Applications Symposium (IDEAS 2018). ACM, New York
41.
Zurück zum Zitat Pandey S, Shanker U (2020) Race: a concurrency control protocol for time–constrained transactions. Arab J Sci Eng 45(12):10131–10146CrossRef Pandey S, Shanker U (2020) Race: a concurrency control protocol for time–constrained transactions. Arab J Sci Eng 45(12):10131–10146CrossRef
42.
Zurück zum Zitat Yu PS, Wu K-L, Lin K-J, Son SH (1994) On real-time databases: concurrency control and scheduling. Proc IEEE 82(01):140–157CrossRef Yu PS, Wu K-L, Lin K-J, Son SH (1994) On real-time databases: concurrency control and scheduling. Proc IEEE 82(01):140–157CrossRef
43.
Zurück zum Zitat Chen HR, Chin YH (2003) An adaptive scheduler for distributed real-time database systems. Inf Sci 153:55–83CrossRef Chen HR, Chin YH (2003) An adaptive scheduler for distributed real-time database systems. Inf Sci 153:55–83CrossRef
44.
Zurück zum Zitat Agrawal S, Shanker U, Singh A, Anand A (2010) SPEEDITY—a real time commit protocol. Int J Comput Appl 1(3):86–93 Agrawal S, Shanker U, Singh A, Anand A (2010) SPEEDITY—a real time commit protocol. Int J Comput Appl 1(3):86–93
45.
Zurück zum Zitat Shanker U, Vidyareddi B, Shukla A (2012) PERDURABLE: A Real Time Commit Protocol. In: Özyer T, Kianmehr K, Tan M. (eds) Recent Trends in Information Reuse and Integration. Springer, Vienna, pp 1–17 Shanker U, Vidyareddi B, Shukla A (2012) PERDURABLE: A Real Time Commit Protocol. In: Özyer T, Kianmehr K, Tan M. (eds) Recent Trends in Information Reuse and Integration. Springer, Vienna, pp 1–17
46.
Zurück zum Zitat Shanker U, Misra M, Sarje AK (2005) Priority assignment heuristic to cohorts executing in parallel. In: 9th International Conference on World Scientific and Engineering Academy and Society (WSEAS) Shanker U, Misra M, Sarje AK (2005) Priority assignment heuristic to cohorts executing in parallel. In: 9th International Conference on World Scientific and Engineering Academy and Society (WSEAS)
Metadaten
Titel
A contention aware EQS priority assignment heuristic for cohorts in DRTDBS
verfasst von
Sarvesh Pandey
Udai Shanker
Publikationsdatum
02.01.2021
Verlag
Springer US
Erschienen in
The Journal of Supercomputing / Ausgabe 7/2021
Print ISSN: 0920-8542
Elektronische ISSN: 1573-0484
DOI
https://doi.org/10.1007/s11227-020-03530-5

Weitere Artikel der Ausgabe 7/2021

The Journal of Supercomputing 7/2021 Zur Ausgabe