Checking and Verifying Temporal Data Validity Using Valid Time Temporal Dimension and Queries in Oracle 12C

Gohil, Jaypalsinh A.; Dolia, Prashant M.

doi:10.5121/ijdms.2015.7402

Cited by 4 publications

(3 citation statements)

References 4 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Generally, a conflict between two operations indicates that their order of execution is important. Read operations do not conflict with each other, hence the ordering of read operations does not matter [13].…”

Section: Concurrency Controlmentioning

confidence: 99%

“…As visible from the below figure 1, this experimental study starts with designing three relations namely COURSE, STUDENTS and third temporal relation STUDENT_COURSE by using the PERIOD FOR clause at the time of creation of relation STUDENT_COURSE suing following query [13,14]. CREATE The structures of three tables along with its records are as follows:…”

Section: Acquiring Optimistic Lock On Temporal Relation 41 Temporal mentioning

confidence: 99%

See 1 more Smart Citation

Graphical Representation of Optimistic Locking and Concurrency Control for Temporal Database using Oracle 12c Enterprise Manager

Gohil¹,

Dolia²

2016

IJCA

View full text Add to dashboard Cite

In a multiuser database environment, multiple simultaneous transactions may update the same data. Transactions executing simultaneously must produce meaningful and consistent results. In multiuser database environment conflicts are common. If conflicting situations are not dealt properly then it can harm the database. To minimize the concurrency problem the locking approach is used. Our study focus on implementation of optimistic lock through trigger on data objects of temporal database to resolve the conflicts among multiple user sessions. Through step by step graphical representation this study highlights how to acquire and release an optimistic lock on data objects in case of conflict. This experimental study shows each locking, unlocking situations along with conflicting situations graphically through Oracle 12C enterprise manager.

show abstract

Section: Concurrency Controlmentioning

confidence: 99%

Section: Acquiring Optimistic Lock On Temporal Relation 41 Temporal mentioning

confidence: 99%

Graphical Representation of Optimistic Locking and Concurrency Control for Temporal Database using Oracle 12c Enterprise Manager

Gohil¹,

Dolia²

2016

IJCA

View full text Add to dashboard Cite

show abstract

“…The experiment starts with designing three relations namely COURSE, STUDENTS and third temporal relation STUDENT_COURSE by using the PERIOD FOR clause at the time of creation of relation STUDENT_COURSE using following query [20,21]. The following figure 3 shows the structure of table with inserted records: …”

Section: Creation Of Temporal Relationmentioning

confidence: 99%