Parallelism of transaction execution-data fragmentation, Database Management System

Parallelism of transaction execution: A transaction can be divided into various sub-queries that can operate on fragments in parallel. This enhances the degree of concurrency in the system, therefore allowing transactions to execute efficiently.

 

Posted Date: 3/13/2013 8:35:21 AM | Location : United States







Related Discussions:- Parallelism of transaction execution-data fragmentation, Assignment Help, Ask Question on Parallelism of transaction execution-data fragmentation, Get Answer, Expert's Help, Parallelism of transaction execution-data fragmentation Discussions

Write discussion on Parallelism of transaction execution-data fragmentation
Your posts are moderated
Related Questions
(a) Why did SAP introduce the extended star schema?

#Use the following database schema: 1) Patient—PatientID, Name, DOB 2) Doctor—DoctorID, Name, MedLicenseNumber, Phone 3) Medication—MedicationID, BrandName, GenericName 4) Prescrip

Define Outer join Outer join - If there are any type of values in the one table that do not have corresponding value(s) in the other, in an equi-join which will not be selected

What is storage manager?  A  storage  manager  is  a  program  module  that  gives  the  interface  between the Low level data  kept in a database and the application programs

a.  Construct a query around any one of the functional divisions you made in 4a such that if executed in the distributed design of 4 would require reconstruction of at least two ho

Explain Interblock gap? Interblock Gap - A track of a disk is separated into equal-sized disk blocks. Blocks are separated through fixed-size gaps, called as interblock gaps th

Design Of Distributed Databases: The distributed databases are mainly relational at local level. So a local database schema is the similar as that of a centralised database design

What is database Trigger? A database trigger is a PL/SQL block that can explained to automatically execute for insert, update, and delete statements against a table. The trigge

what are the reasons having variable length records

The domain that you will model in this assignment is that of courses and students at a university. So as not to make the task too large and unspecified, you will here get a descrip