PROTOKOL CONCURRENCY CONTROL PADA REAL-TIME DATABASE SYSTEM
Kuspriyanto Kuspriyanto, Rusdi Hs Rusdi Hs, Hartanto Hartanto
Abstract
Kuspriyanto Kuspriyanto, Rusdi Hs Rusdi Hs, Hartanto Hartanto
Abstract
Control Concurrency on RTDBS more complex than in conventional database system. Besides guarantee database consistency, on RTDBS control concurrency can support transaction deadlines. Mean while validities and value of data item change depend on time. Conventional control concurrency algorithm can be divided to two groups: Pessimistic Concurrency Control (PCC) and Optimistic Concurrency Control (OCC). PCC prevent conflict between transactions executed while OCC overcome between transactions after that transaction executed that restarted in conflict happened. These algorithms have weakness if applied in RTDBS that gives tight time on transaction execution because as a parameter is number of transactions done before deadlines, not only number of concurrency maximum and throughput. To overcome those two algorithms weakness some researches done. Between results modifications is speculative concurrency control and Hybrid concurrency control for the Nested model. But between alternatives there are some weaknesses, so it needs development for better control concurrency for RTDBS.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
Control Concurrency on RTDBS more complex than in conventional database system. Besides guarantee database consistency, on RTDBS control concurrency can support transaction deadlines. Mean while validities and value of data item change depend on time. Conventional control concurrency algorithm can be divided to two groups: Pessimistic Concurrency Control (PCC) and Optimistic Concurrency Control (OCC). PCC prevent conflict between transactions executed while OCC overcome between transactions after that transaction executed that restarted in conflict happened. These algorithms have weakness if applied in RTDBS that gives tight time on transaction execution because as a parameter is number of transactions done before deadlines, not only number of concurrency maximum and throughput. To overcome those two algorithms weakness some researches done. Between results modifications is speculative concurrency control and Hybrid concurrency control for the Nested model. But between alternatives there are some weaknesses, so it needs development for better control concurrency for RTDBS.
Key concepts: Multiversion concurrency control, Optimistic concurrency control, Computer science, Concurrency control, Non-lock concurrency control, Timestamp-based concurrency control, Distributed concurrency control, Serializability