2007Jurnal Akuntansi dan Keuangan (Institute of Research and Community Outreach Petra Christian University)Open access

PROTOKOL CONCURRENCY CONTROL PADA REAL-TIME DATABASE SYSTEM

Kuspriyanto Kuspriyanto, Rusdi Hs Rusdi Hs, Hartanto Hartanto

Open full text 0 citations

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.

About this research paper

What this paper is about

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.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available 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.

Key concepts: Multiversion concurrency control, Optimistic concurrency control, Computer science, Concurrency control, Non-lock concurrency control, Timestamp-based concurrency control, Distributed concurrency control, Serializability

Related papers

Back to paper searchBrowse research topicsOriginal source
PROTOKOL CONCURRENCY CONTROL PADA REAL-TIME DATABASE SYSTEM — Research Paper | ScholarLens