Two phase locking and timestamping algorithm in SQL server

Question

0.00/5 (No votes)

See more:

hello
I am doing a research thesis on concurrency control in distributed database. I am looking at how to efficiently improve serializability in transaction in distributed database and I want to use C# and SQL Server to implement it. I want to combine the two-phase locking algorithm with timestamp algorithm to improve serializability in distributed database.
I need ideas on how to achieve that and if possible where to start. Any form of tutorials will be a great relief.

What I have tried:

I need ideas and tutorials on how to combine two-phase locking and timestamping algorithm

Posted 17-Aug-19 1:31am

MaximusDebois

Updated 17-Aug-19 5:09am

Add a Solution

Comments

Wendelius 17-Aug-19 8:13am

With timestamping algorithm, do you mean optimistic concurrency control or something else? Normally two phase locking is based on pessimistic locking so these are not necessarily usable together.

MadMyche 17-Aug-19 9:35am

The OP never replied when you answered these questions back in January

Wendelius 17-Aug-19 11:01am

That's true, I didn't recall that we've talked about this with the OP before...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MadMyche · Answer 1 · 2019-08-17T05:10:00

So we are now 7 months into what was a Master's Thesis
Jan 2019: How to control concurrency in distributed database[^]

Quote:
i am very new programmer trying to learn c# and sql server. I am doing a masters thesis on concurrency control in distributed database. I want help on how to control concurrency control in distributed database using c# and sql server. If possible a source code will be gladly welcome
What I have tried: i am new to c# programming and so i have not tried anything yet since i don't know to even start

And we have made some progress, coming up with an algorithm back in May
Implement a concurrency control algorithm in distributed database[^]

Quote:
Am writing thesis on concurrency control in distributed database. I am looking at how to deal with the lost update problem in distributed database. Am using some proposed algorithm to deal with this problem but don't know how to implement it with trigger in sql server 2017.
What I have tried: I have tried nothing since I have no idea

So now that everyone is on the same page....

This is what I would do:
1. Review how those 2 disparate protocols are implemented.
2. Determine which one of the 2 methods is going to take precedence.
3. Create the new order of operations
4. Create a generic solution not tied to any particular RDBMS
5. Finally begin implementation of the generic solution onto a specific version

My Opinions:

1. Working in C# is way too high level and disconnected from the perceived issue; the overhead associated with getting the data is going to have a greater time loss than the margin of error in the timestamp methodology.

2. Requesting the community for Ideas and Tutorials on how to do your research is an insult to the education system; not much better than asking Google to solve 2+2.