Purchase Solution

Multiuser database applications

Not what you're looking for?

Ask Custom Question

Describe the issues that arise from concurrency. What are the main concerns when multiple users have access to the same data? How does a DBMS handle these situations? What is locking? How is it resolved?

Purchase this Solution

Solution Summary

Multiuser database application problems are noted.

Solution Preview

---------------------------------------------------------
Multiuser database applications encounter concurrency problems whenever several users try to access or update the same data at the same time. Concurrency has to do with separate processes or users, running or operating at the same time, trying to use the same data item(s).

In a well-developed DBMS, concurrency issues are resolved by using locks. Locking can prevent one process from reading data that is being changed by another process, and it can prevent a process from changing data that is about to be changed by another concurrent process.

Locking provides the benefit of ensuring correct data, but it also makes the other concurrent applications wait to apply their changes. The application design trade-off is to carefully lock what you ...

Purchase this Solution


Free BrainMass Quizzes
Javscript Basics

Quiz on basics of javascript programming language.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

C++ Operators

This quiz tests a student's knowledge about C++ operators.