Explain concurrency control, Database Management System

Assignment Help:

Explain concurrency control?

Concurrency control

Oracles multiversion concurrency control varies from the concurrency mechanism used by some other data base vendors. Read only queries are given a read -consistent snapshot which is view if the data base as it existed at the particular point in time, having all update that we were committed by that point in time and not containing any updates that were not committed at any point in time therefore read clock are not used in read only queries don't interfere with other data base activity in term of locking.

Managed stand by data base

To make sure high availability oracle provide a managed stand by data base future A stand by data base is a copy of the regular data base i.e. in solved on the separate system. If a catastrophic failure occur on the primary system, the stand by system is activate and take over there by minimizing effect on failure on a availability. Oracle keeps the stand by data base up to date by constantly applying archived redo logs that are shipped from the primary data base the back up data base can be brought online in readonly mode and used for reporting and decision support queries

 

 


Related Discussions:- Explain concurrency control

By the relations get details of employees working in sql, Consider the rela...

Consider the relations: PROJECT(proj#,proj_name,chief_architect) EMPLOYEE(emp#,emp_name) ASSIGNED(proj#,emp#) Use relational algebra to express the subsequent queries: (i) Get

Normalize table 3nf , Normalize the following tables upto and including the...

Normalize the following tables upto and including the 3NF. Submit a 1 page printout of only the final set of normalized tables in Data Architect. Just use Data Architect to do the

Lock, lock and types of lock

lock and types of lock

List and describe the different types of indexes, Question 1 Indexes are o...

Question 1 Indexes are ocasionally defines on a single field of a file called an indexing field. List and describe the different types of indexes Question 2 Consider a book i

Construct substantial data model, PART MARKING:  We will only mark TWO of t...

PART MARKING:  We will only mark TWO of the four questions below but you must submit answers to all four. We will choose the questions we mark randomly and we will supply you with

Identification of concurrency, Identification of concurrency Identifica...

Identification of concurrency Identification of concurrency: Dynamic model identifies concurrency. Two objects are said to be parallel (concurrent) if they can receive events a

Define shared locks, Define Shared locks? Ans: Shared lock: Throughout ...

Define Shared locks? Ans: Shared lock: Throughout concurrent execution of transactions, earlier than a transaction can access a data item, it has to obtain a lock on it. Now he

Explain the equijoin, Explain the θ-join and equijoin Refer tables Car ...

Explain the θ-join and equijoin Refer tables Car and Boat which list models of cars and boats and their relevant prices. Assume a customer wants to buy a car and a boat, but sh

Relational model, A model in database system mostly defines the organisatio...

A model in database system mostly defines the organisation of data or structure and a set of operations on that data. Relational model is a easy model in which database is represen

Need for a database management system, NEED FOR A DATABASE MANAGEMENT SYSTE...

NEED FOR A DATABASE MANAGEMENT SYSTEM A Database is a structured, persistent collection of data of an organisation. The database management system (DBMS) manages the database o

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