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

State about the activity diagram, State about the Activity Diagram Act...

State about the Activity Diagram Activity diagrams show flow from one activity to other. It is an ongoing non atomic execution within a state machine. Activity finally results

Explain controlled redundancy, Explain controlled redundancy? Controll...

Explain controlled redundancy? Controlled redundancy : The replication of data within the data warehouse for the purposes of improved data access or understand ability.

What is relational dbms, What is Relational DBMS This is our subject of...

What is Relational DBMS This is our subject of study. A DBMS is relational if the data is organized into relations, that is, tables. In RDBMS, all data are kept in the well-kno

Three levels of ANSI-SPARC architecture, a need some real life examples of...

a need some real life examples of database management systems three level of ANSI SPARC architecture life teacher and student ,company and employee or for NGO etc.

Describe domain constraints, Describe domain constraints. Domain constr...

Describe domain constraints. Domain constraints contain entity integrity and referential integrity. The domain is a set of values that might be assigned to an attribute. The en

Create the logical database schema, 1.  Based on the dependency diagram, cr...

1.  Based on the dependency diagram, create a database whose tables are in at least 2NF, showing the dependency diagram for each table (as shown in class).  Label the types of depe

Give an example of enforcement in typing, Give an example of enforcement in...

Give an example of enforcement in Typing. You can understand the idea of enforcement as it makes sure objects of dissimilar classes may not be interchanged as below:  Exampl

Creation of indexes, Creation of Indexes Automatically: When a primar...

Creation of Indexes Automatically: When a primary key or Unique constraint is show in a table definition then a unique index is formed automatically. Manually: User can

What is key, What is key ? Key - A single attribute or a combination of...

What is key ? Key - A single attribute or a combination of two or more attributes of an entity set which is used to recognize one or more instances (rows) of the set (table) is

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