Concurrency control in trusted database management systems

Thuraisingham, Bhavani; Ko, Hai-Ping

doi:10.1145/166635.166654

Cited by 9 publications

(1 citation statement)

References 27 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The design of secure CC protocols in the context of con-m7J./Jo7d (Iar,ahse systems has been investigated by sevrral research groups (see [20] for a survey). In compari-SIm.…”

Section: Related Workmentioning

confidence: 99%

Secure transaction processing in firm real-time database systems

GeorgeBinto

HaritsaJayant

1997

SIGMOD Rec.

View full text Add to dashboard Cite

ll,uli. rt:al-t.iliif,{lat,al]aseapplications miseinsdety-criticd installations andmilitary systems where enforcing security t> irtt~Ml to th(, successor the enterprise. A secure real-time (liiti]l)~<(, svstrm has to simultaneously satisfy two require-II1(J1l Is guarauree data security and minimize the number ,,1 Ititw,d transaction deadlines. We investigate here the p,ukmuance implications, in terms of missed deadlines, of gu;uallt.veiug secorit.y in a real-time database system. In lwtitulal. w{' focus on the concurrency control aspects of 1111> 15>11(, (hlr lll;l]tl ({)jlt.ril)~it,iollsu et hefollowing: First, we iden-Lt]"vwhich a.umug the previously proposed real-time concur-IIIK.K((lrlt.rol protocols" are capable of providing protection ,i~;iil~si })[}th (Im:(t aud imlirect (covert channels) means of lllla!ltt]~mzrd Mress to data. Second. using a detailed simolimou model of a firm-deadline real-time database system, wv profile the real-time performance of a representative set ,)1 illtw, s~~(ur[ (om.orrmi(:y control protocols. Our exper-IILIIIIIIs show that. a prioritized optimistic concurrency control protocol. OPT-WAIT, provides the best overall perforii,ium Third. we propose and evaluate a novel durd ap-lmMrlI to secure t,rimsaction concurrency control that al-1,,~~> tll(' rml-time (latabase system to simultaneously use tlIffIw,III c(ulrvlrreucy control mechanisms for guaranteeing (,{II IIIV ,UI{I fijr imprcn,iug real-time performance. By appropriately ckoosing these different mechanisms, we have IML(OII al)h, to (Iesign hyfwui concurrency control algorithms 111,11 lJII)\.1~1{1 (,v(,II Iwttw performance than OPT-WAIT.

show abstract

“…The design of secure CC protocols in the context of con-m7J./Jo7d (Iar,ahse systems has been investigated by sevrral research groups (see [20] for a survey). In compari-SIm.…”

Section: Related Workmentioning

confidence: 99%

Secure transaction processing in firm real-time database systems

GeorgeBinto

HaritsaJayant

1997

SIGMOD Rec.

View full text Add to dashboard Cite

show abstract

Concurrency control for real‐time and mobile transactions: Historical view, challenges, and evolution of practices

Chaudhry

Yousaf

2021

Concurrency and Computation

View full text Add to dashboard Cite

Recently, mobile computing has changed the way that spatial data and GIS are processed. Unlike wired and stand-alone GIS, now the trend has been switched from offline to real-time data processing using location aware services, such as GPS technology. The increased usage of location aware services in multiuser real-time environment has made transaction management incredibly significant. If the simultaneous query operations on the same data item are not handled intelligently then this results in data inconsistency issue. Concurrency control protocol is one of the primary aspects that helps in overcoming this issue a in multiuser environment. To the best of our knowledge, the impact of technological advancements on concurrency control has not been thoroughly studied in the literature. In this article, we explored the literature on concurrency control algorithms in depth with respect to real-time applications and the applications with moving objects. We defined a taxonomy of concurrency control solutions and assessed the maturity of these solutions in the light of characteristics of real-time and mobile environment. We compared the most recent developments made in the literature and presented meaningful insights. Challenges are also identified and discussed, which can assist in doing research in this domain in future. K E Y W O R D S concurrency control, mobile, real time 1 INTRODUCTION IoT (Internet of Things) emerged as a promising technology that has revolutionized the way of living. GPS-based devices and sensors are commonly used in majority of the applications. The convergence of multiple domains such as real-time GIS, mobile computing, and IoT has made it necessary to solve the computing problem considering the requirements of each domain. Mobile GIS domain integrates several technologies: GPS, mobile computing, and GIS. In recent times, the data processing environment deals with varying kinds of sensors. The real-time data collected by sensors need to be processed in timely manner to ensure efficient data management. The sensors can be categorized into two types depending on their mobility: fixed and agile/mobile sensors. Fixed sensors are spatially fixed, whereas mobile sensors change their location with respect to time. Mobile sensors collect data on geographical grounds and this data can be referred to as spatiotemporal data. This has given rise to a new research domain of real-time mobile data processing and management. Thus, real-time processing domain emerged with respect to time depending on the nature of sensor technology and evolution of IoT. The future processing systems are expected to meet the requirements of spatiotemporal and real-time data, leading toward a new domain of real-time GIS. Real-time data can be used for both static and dynamic processing. For example, in the first aspect, mobile sensors can process and analyze the real-time spatiotemporal data for dynamic processing. On the other hand, real-time data can be collected and saved in a log for future offline analysis (static processing).

show abstract