proofreading help 1/8

Hi Experts,

Could you please help me with the edit of the following section only:

1. Summary up to Example 1

at: http://www.experts-exchange.com/articles/20279/Isolation-levels-beginner-level.html

Upcoming questions below are only FYI. They are not a part of this question.
1. Summary up to Example 1
2. Example 1 up to Sample Table
3. Sample Table up to Example 1 part 2
4. Example 1 part 2 up to Example 2
5. Example 2 up to Example 3
6. Example 3 up to Example 4
7. Example 4 up to Conclusion (not ready yet)
8. Conclusion                               (not ready yet)
LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jmcgOwnerCommented:
I have more a general comment than a specific proofread.

Your summary, I think, fails to present the overall motivation for why databases offer these isolation level options.

To be considered proper database transactions, transactions need to have the ACID properties. Providing fully guaranteed transaction semantics, however, can be expensive in terms of time and machine resources. Programmers, with perhaps a better overview of the needs of the application, can relax some of the requirements. They specify lower levels of isolation because they know that the data anomalies, etc, possible with the lower isolation level either can't occur or are acceptable, in exchange for higher performance, i.e. fewer transactions blocked waiting for other transactions to complete.

Then when you get into your examples, you not only have to explain what a "dirty read" is and how it might arise, and so on, but you also have to explain why that might be acceptable in one situation but perhaps not in others.

In the "Sell a car" transaction, the transaction should be aborted if the credit check fails, not reversed by an explicit additional update. If the inventory lookup does not care that there might be a car or two waiting for a credit check, it can tolerate a lower isolation level so that it is not blocked while the credit checks are completed.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
jmcg,

Thank you for your comments. I am preparing this for technical review. Meaning this is posted for English proof reading only at this point.

FYI, I have 300 characters limit (with spaces) for summary. Although I am writing about ACID later on but I am not required to do so. This article assumes the reader knows about Transaction ACID elements but wants understand Isolation Levels.

re:>  In the "Sell a car" transaction, the transaction should be aborted if the credit check fails, not reversed by an explicit additional update.

It seems you have not thoroughly read the article (and it was not necessary to read it anyway). But because you have mentioned here is my response.

I am very well aware of the fact we do not required to have an explicit additional update. That part of the code is trying to illustrate the nature of Dirty Read (without use of Isolation or Try/Catch, Transaction, etc.).

You are welcome to just focus on English wording if you like.

Thanks

Mike
0
jmcgOwnerCommented:
I did spot one typo: seconded
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

jmcgOwnerCommented:
I've now read any number of articles on this general topic. What you need is an approach to the topic that is more than just paraphrasing the Wikipedia and Mike the Oracle Guy articles. Who is your distinct audience? What's your special insight?

Sorry to come off rather critical, but you need to aim higher.
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
jmcg,

It is 1:30 AM and I am supposed to getup 6:00 AM for marathon training  (5 miles only for now). But before signing off, I would like to say your inputs have been very effective and appreciated.

I need to rearrange the material and provide some disclaimer and links so reader could familiarize themselves with ACID, etc. prior to focusing on Isolation part.

My thinking is, without using isolation or Transaction in a very simple form illustrate what Dirty Read, Lost Update, etc. is. And then show how utilizing Isolation Types could help. Also, as you have discussed make a comparisons among them as far as resource use or tolerance for bad data or lockouts.

Mike
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
I have deleted following 5 questions to redo my article.

2. Example 1 up to Sample Table
3. Sample Table up to Example 1 part 2
4. Example 1 part 2 up to Example 2
5. Example 2 up to Example 3
6. Example 3 up to Example 4

I will post them again when my makeover is done.

Thanks,

Mike
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Proofreading

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.