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 TexLive 2019 in Ubuntu 18.04

Installation of TexLive 2019 in Linux (Ubuntu 18.04 LTS)
TeX (Tech)

Installation of TexLive 2019

Please watch the video for full installation



I used .iso file to download, the Total size is 3.3GB for Linux,

and i used the torrent file to download, it took me just 20 min to download the entire .iso file

Extract the .iso file to a folder and open a terminal

$] sudo ./install-tl
(it goes into a terminal mode, which is faster compared to the GUI Mode)

$] sudo ./install-tl -gui
after the installation, set the PATH, MANPATH and INFOPATH as suggested by LATEX

export PATH=$PATH:/usr/local/texlive/2019/bin/x86_64-linux
export MANPATH=/usr/local/texlive/2019/texmf-dist/doc/man
export INFOPATH=/usr/local/texlive/2019/texmf-dist/doc/info

put these lines in to the /home/pradeepkumar/.bashrc

$] gedit /home/pradeepkumar/.bashrc
We have installed TexLive 2019 and texstudio.

To install texstudio

$] sudo apt install texstudio
The look and feel of TexStudio looks like this image.


texlive, it install everyt…

Implementing a new system call in Kernel version 2.6.32

A system call is used by application or user programs to request service from the operating systems. Since the user programs does not have direct access to the kernel whereas the OS has the direct access. OS can access the hardware through system calls only.The following files has to be modified for implementing a system call/usr/src/linux-2.6.32.5/arch/x86/kernel/syscall_table_32.S/usr/src/linux-2.6.32.5/arch/x86/include/asm/unistd_32.h/usr/src/linux-2.6.32.5/include/linux/syscalls.h/usr/src/linux-2.6.32.5/MakefileNew set of files to be createdCreate a new directory newcall/ inside the path “/usr/src/linux-2.6.32.5/” Create new files Makefile, newcall.c and put them in the /usr/src/linux-2.6.32.5/newcall/ folder Create new user files (in any folder of Linux) to test the system call
testnewcall.c, testnewcall.h (created in /home/pradeepkumar) syscall_table_32.S Find the file /usr/src/linux-2.6.32.5/arch/x86/kernel/syscall_table_32.S and add the following line at the end
"…

Electrical Machine Design (equations)

FactorsDC Machine Transformers Induction Machines Synchronous MachinesOutput EquationPa=CoD2Ln, where Pa=P/h for generators, Pa=P for motorsFor Single Phase
Q=2.22 f Bm Ai Kw Aw d10-3
For Three Phase
Q=3.33 f Bm Ai Kw Aw d 10-3Q=CoD2 L ns
KVA Input Q=
HP * 0.746 / Cos f * hQ=CoD2 L ns
KVA Input Q=
HP * 0.746 / Cos f * h
For Turbo alternators
Q=1.11Bavac KwsVa2 L 10-3/nsOutput CoefficientCo=Bav ac* 10-3where Bav-magnetic loading and ac - electric loadingDNACo=11 Kws Bav ac 10-3Co=11 Kws Bav ac 10-3 Choice of Magnetic LoadingFlux Density in Teeth Frequency of Flux Reversals Size of machineDNAMagnetizing current, Flux Density, Iron lossIron loss, Stability, Voltage Rating, Parallel Operation, Transient ShortCircuit current Choice of Electric LoadingTemperature rise,
speed of machine, Voltage, Armature reaction, CommutationDNAOverload Capacity, Copper losses, Temperature rise, Leakage ReactanceCopper loss, Synchronous reactance, Temperature rise, Stray Load losses,
Voltage rating Flux …