Database management help, Basic Computer Science

Suppose that you are writing a stored procedure to record new purchases. Suppose that
you know that while your procedure is running, another stored procedure that records
shipment data can be running, and a third stored procedure that updates shipper data
can also be running.

1. Give an example of a dirty read, a nonrepeatable read, and a phantom read among
this group of stored procedures.

2. What concurrency control measures are appropriate for the stored procedure that
you are creating?

3. What concurrency control measures are appropriate for the two other stored
procedures?

Posted Date: 4/23/2012 11:21:26 PM | Location : United States







Related Discussions:- Database management help, Assignment Help, Ask Question on Database management help, Get Answer, Expert's Help, Database management help Discussions

Write discussion on Database management help
Your posts are moderated
Related Questions
The CPU has four internal registers, each of 16 bits. The first four, AX, BX, CX, and DX are common use registers and can also be used as 8 bit registers, if used in such a way it

Another way of classifying a computer system is based upon its size and capabilities: Microcomputers: Microcomputers are systems based on the use of microprocessors. A Micr

what is operator and operator associatively

Input unit: These are used to read data and transfer to primary memory contained in CPU through keyboard or floppy disk or mouse etc. Central Processing Unit (CPU): This consists o

A router is a device which has played an important role in the development and existence of the Internet. Routers are designed to transmit data from other network users to specific

Word Processing Software : The main use for word processing is found in secretarial offices and small publishing companies. However, if you are involved in generating your own cor

Examples of Online Databases: The adoption of modern technology has resulted in the proliferation of machine readable databases. The National Library of Medicine (USA) designe

Give birth to new life forms A research of Artificial Life will definitely throw light on what it means for a complex application to be 'alive'. Moreover, ALife researchers th

Multiprocessor DSP Systems Over modern times several organizations have provided forums made up of several DSPs. More lately, semiconductor organizations have been providing sn

SYSTEMS SOFTWARE Systems Software generally is the software which control the computers and other peripherals. Ex: MS DOS, Windows 95, Unix, NetWare and Windows NT et