Problems occur while implement locking in sql server, DOT NET Programming

Assignment Help:

What are the problems that can occur if you do not implement locking properly in SQL SERVER?

The problems that occur if you do not implement locking properly in SQL SERVER is as follows:

Lost Updates:

The Lost updates occurs if you let two transactions change the same data at the same time, and the transaction which completes first is lost. You requireto watch out for the lost updates with the READ UNCOMMITTED isolation level. This isolation level disregards any type of locks, so two simultaneous data modifications are not aware of each other. Suppose that the customer has due of 2000$ to be paid. He paid 1000$ & again buys a product of 500$. Now say that these two transactions are now been entered from two different counters of the company. Now both counter user starts making entry at the same time 10:00 AM. Actually say at 10:01 AM the customer should have 2000$-1000$+500 = 1500$ pending to be paid. But as said in the lost updates the first transaction is not considered and the second transaction overrides it. So the final pending is 2000$+500$ = 2500$.....I hope the company does not loose the customer.

Non-Repeatable Read:

The Non-repeatable reads occurs if a transaction is able to read the similar row multiple times and gets a different value every time. Again, this problem is most likely to occur with the READ UNCOMMITTED isolation level. Because you let two transactions change data at the similar time, you can get some unexpected results. For an instance, a customer wants to book flight, so the travel agent checks for the flights availability. The Travel agent finds a seat and goes ahead to book the seat.While the travel agent is booking the seat, some another travel agent books the seat. When the travel agent goes to update the record, he gets error saying that "Seat is already booked". In brief the travel agent gets different status at the different times for the seat.

Dirty Reads:

The Dirty reads are a special case of non-repeatable read. This happens only if you run a report while transactions are changing the data that you're reporting on. For example there is a customer invoice report which runs on 1:00 AM in the afternoon and after that all invoices are sent to the respective customer for payments. Let us say one of the customer has 1000$ to be paid. The Customer pays 1000$ at 1:00 AM and at the same time report is run. Actually the customer has no money pending but is still issued an invoice.

Phantom Reads:

The Phantom reads occur due to a transaction being able to read a row on the first read, but not being able to change the same row due to another transaction deleting rows from the similar table. Lets say you edit a record in the mean time someone comes and deletes the record, you then go for updating the record which does not exist.Panicked. Interestingly, the phantom reads can occur even with the default isolation level supported by the SQL Server: READ COMMITTED. The only isolation level that doesn't allow phantoms is SERIALIZABLE, which assures that every transaction is completely isolated from others. In other words, no one can acquire any type of locks on the affected row while it is being changed.


Related Discussions:- Problems occur while implement locking in sql server

Use of attribute, What is the use of attribute  ? This attribute wo...

What is the use of attribute  ? This attribute works as a compatibility option. We know that ASP worked in STA model and ASP.NET works in MTA model, but what if your ASP.NET

Ewdedewdew, ssasadsdsdsddewdewdwedewdewdewededewdewdewdewdewdewdewdwedssa s...

ssasadsdsdsddewdewdwedewdewdewededewdewdewdewdewdewdewdwedssa sdedwdew dedewdew ewdewdew ewdewdew dedew ewdew ewd ewde ew ew

Content page creation, NopCommerce v3.10 - Content Page Creation, Product I...

NopCommerce v3.10 - Content Page Creation, Product Import and Site Customization Project Description: I have an existing website with about 800 products and we could like to

Construct a .net wrapper for a c++, Construct a .NET wrapper for a C++ Dll ...

Construct a .NET wrapper for a C++ Dll - repost Project Description: We have a classic VC++ Dll (source code of DLL not required) that requires a .NET wrapper built by you. U

Develop one web based application, Project Description: Specifically i n...

Project Description: Specifically i need develop one web based application which have student registration and according to semester and each time it will change as per semester

I need some a vba expert urgent, I need some a VBA expert urgent Project...

I need some a VBA expert urgent Project Description: I require a VBA expert for scraping data from internet. .NET, Excel, Data Processing, Visual Basic

Why does an organization need to manage the workloads, Why does an organiza...

Why does an organization need to manage the workloads? The workload can be explained as an independent service or a set of code that can be implemented. It can be everything f

Monitoring system, hello there im stuck in my project and need to finish of...

hello there im stuck in my project and need to finish off it in a week or 8 days ,,and its .net and databases..please need a help

Looking for web designer, Looking for web designer Project Description: ...

Looking for web designer Project Description: I am seeking website designer with developing skills of Html, .Net and also supports in all browsers. Please ping your previous

What is windows workflow foundation, What is Windows Workflow Foundation (W...

What is Windows Workflow Foundation (WF)? Windows Workflow Foundation (WF) is a technology that was first introduced in .NET Framework 3.0. WF having of a programming model, a

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd