+ 2

In shared lock which is applied in reading time , the others can write the data ?

Question is related to dbms

9th Oct 2020, 4:38 PM
Muhammad
Muhammad - avatar
6 odpowiedzi
+ 4
please make the question more clear, I don’t understand
9th Oct 2020, 4:40 PM
Galaxy-Coding (inactive)
Galaxy-Coding (inactive) - avatar
+ 2
I think most importent is: what is dbms?
9th Oct 2020, 4:41 PM
Alexander Thiem
Alexander Thiem - avatar
+ 2
Dbms means data base management system concept
9th Oct 2020, 4:43 PM
Muhammad
Muhammad - avatar
+ 1
In data base concept we have transaction concept, there we have two types locks 1: shared lock 🔐 applied in data reading time 2: exclusive lock 🔐 applied in data writing time So in case a shared lock is already applied , other can either read or write too
10th Oct 2020, 6:09 AM
Muhammad
Muhammad - avatar
+ 1
Database management system
7th Jan 2024, 3:54 AM
Muhammad
Muhammad - avatar
0
No, when one query has locked an item for reading, no other query may write to that item to avoid inconsistencies on the readers point of view. Atleast that’s how it was taught to me.
7th Jan 2024, 9:03 AM
Alexander Thiem
Alexander Thiem - avatar