Skip to main content

Concurrency Control Issues

  • Pessimistic Concurrency Control
    • The transactions are been checking for violating the serialization consistency before letting it execute is called pessimistic concurrency control
      • Two phase locking Scheme
        • Read /Write lock as a phase
        • Unlock – another phase
        • Both the above phases wont interleave, because of this, there may be deadlock, which can be detected by means of deadlock detection algorithm and if deadlock is there, one of the transactions is aborted with the nearer timestamp.
      • Multiversion Scheme
        • There are three locks Read, Write and Certify
        • Read lock – Read the needed data from the database
        • Write lock – Writing to its own private space
        • Certify lock – Updates to the database, this stage is the committed stage.

      General locking Rules

Lock Already Set

Lock Requested

Read

Write

Certify

Read

Granted

Granted

Blocked

Write

Granted

Granted

Granted

Certify

Blocked

Granted

Blocked


 

Locking rules for priority Inversion

Lock Already Set by a Low Priority Transaction

Lock Requested by a High Priority Transaction

Read

Write

Certify

Read

Granted

L-Aborted

Can't Occur*

Write

Granted/Blocked#

Granted

Granted

Certify

Conversion

Granted

Conversion

In the above table,

L-Aborted - Low Priority Transaction Aborted

Conversion – Low Priority Transaction is converted to write lock

* - already the transaction is aborted, so no reading lock set.


 

If we reduce transaction abortion, then in the above table, L-aborted may be when the HPT requesting the certify lock, while the HPT requesting Write lock which will be granted.


 

Lock Already Set by a High Priority Transaction

Lock Requested by a Low Priority Transaction

Read

Write

Certify

Read

Granted

Granted

Blocked

Write

Blocked

Granted

Granted/Blocked#

Certify

Blocked

Granted

Blocked

# - depending on the implementaion


 

  • Optimistic Concurrency Control
    • The transactions are first allowed to run, after that they are checked for violating the Serialization Consistency
      • Read Phase
        • Reads from the database and writes to its own private address space
      • Validation Phase
        • Checked for violating the serialization consistency.
      • Write Phase (if needed)
        • If the Serialization consistency is not violated in the above phase, then this phase is needed to update to the database
    • So this method is optimistic in the sense that, the transaction are execute and put into the private address space where it is checked for violating the serialization consistency.
    • A and T are two transactions where A's timestamp precedes T's timestamp. The serialization consistency is not violated due to T if the following conditions are true.
      • A has completed its write phase before T starts its read phase.
      • The write set of A is distinct from both the read and write set of T.
    • If the above conditions are not satisfied, then T will be aborted as its timestamp is nearer.

Comments

Popular posts from this blog

Installing ns-3.34 in Ubuntu 20.04

This post shows how to install ns 3.34 in Ubuntu 20.04 LTS Prerequisites: Fresh installation of Ubuntu Version 20.04 LTS  ns3.34 can be downloaded from here Follow the video link for complete step by step instructions on the installation.  This version fixes the compilation issues of vanet-routing-compare.cc (bug in ns3.33)  Issue the following commands after opening a terminal  $ sudo apt update $ sudo apt install g++ python3 python3-dev python-dev pkg-config sqlite3 python3-setuptools git qt5-default gir1.2-goocanvas-2.0 python3-gi python3-gi-cairo python3-pygraphviz gir1.2-gtk-3.0 ipython3 openmpi-bin openmpi-common openmpi-doc libopenmpi-dev autoconf cvs bzr unrar openmpi-bin openmpi-common openmpi-doc libopenmpi-dev tcpdump wireshark libxml2 libxml2-dev Unzip or untar the ns-allinone-3.34.tar.bz2 in the home folder (in my case its /home/pradeepkumar) $ cd ns-allinone-3.34/ $ ./build.py --enable-examples --enable-tests  Once the installation is completed, you may get an output show

Installation of ns3 in Windows 10 and Windows 11 OS using WSL (Windows Subsystem for Linux)

This post shows how to install ns-3.33 in Windows 10 through WSL (Windows Subsystem for Linux) This posts works for Windows 11 also (I have tested it on a Windows 11 ISO and it works the Same way as mentioned in the following post.) This post will work for ns-3.3x version. Prerequisites : Install Windows Subsystem for Linux with GUI: Please refer the following video  System Information: OS used: Windows 10 and WSL (Ubuntu 20.04) GUI: XServer for Windows NS3 Version: ns-3.33 See the following complete video on how to install ns3 in Windows 10 Step 0 : Open XLaunch Step 1 :  Open WSL using PowerShell and open it as Administrator Command:/  wsl $ xfce4-session The GUI of Ubuntu Opens within Windows 10 OS. Step 2 : Download ns3 from nsnam.org website through Mozilla Firefox browser Step 3: Open a Terminal  $ sudo apt update $ sudo apt install build-essential autoconf automake libxmu-dev python3-pygraphviz cvs mercurial bzr git cmake p7zip-full python3-matplotlib python-tk python3-dev qt5-q

Installing NS-3.32 in Ubuntu 20.04

This is about installing ns version 3.32 in Ubuntu 20.04 LTS. #ns3 #ns3 .32 #networksimulation The commands used in the video are given here. $] sudo apt update $] sudo apt install build-essential autoconf automake libxmu-dev python3-pygraphviz cvs mercurial bzr git cmake p7zip-full python3-matplotlib python-tk python3-dev qt5-qmake qt5-default gnuplot-x11 wireshark Download the ns-allinone-3.32.tar.bz2 package from nsnam.org and copy it to /home/ folder See the full video for detailed instructions Extract it either in GUI or using command $] tar jxvf ns-allinone-3.32.tar.bz2 $] cd ns-allinone-3.32/ $] ./build.py --enable-examples --enable-tests The above command will take some time to install all the packages  You can see the output as shown below ns3 To check whether ns3 installed successfully, use the following commands. $] cd ns-3.32/ $] ./waf --run hello-simulator You should get the output as Hello Simulator $] ./waf --run first This is the example from the ns-3.32/exa