Distributed query and transaction processing

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 horizontal and two vertical fragments, as well as a choice of one replica.

b.  Using the centralised schema of 3, show an optimum query plan for your query.

c.  Show two distributed query plans for your query. One assumes all data is transported to another site. The other plan achieves close to minimum data transport and use of at least one semijoin. Using the quantitative analysis of 2 and assumptions based on 3 and 4, estimate the cost of each plan in terms of bytes of data transmitted. Show your working.

d. Sketch a process to update the product catalogue. The process will have a coordinating transaction and subtransactions responsible for the product table, outlet table and the shopping cart. At least part of the product table will be replicated, so there will be a separate process for each replica. Use a synchronised replication protocol. The process will detail the messages sent from process to process and the read-item and write-item for each database access. Other aspects of the process can be briefly described in English. Annotate the process with resource lock/unlock commands corresponding to a twophase locking protocol. Justify your claim that the protocol is two-phase locking in your specific case.

Posted Date: 3/8/2013 5:57:04 AM | Location : United States

Ask an Expert

Related Discussions:- Distributed query and transaction processing, Assignment Help, Ask Question on Distributed query and transaction processing, Get Answer, Expert's Help, Distributed query and transaction processing Discussions

Write discussion on Distributed query and transaction processing
Your posts are moderated

Write your message here..

Related Questions

Define rotational latency time, Define rotational latency time. The ti... Define rotational latency time. The time spent waiting for the sector to be accessed to appear under the head is known as the rotational latency time.

Define single valued and multivalued attributes, Define single valued and m... Define single valued and multivalued attributes.  Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes.   M

State about the advance object design, ADVANCE OBJECT DESIGN Introduct... ADVANCE OBJECT DESIGN Introduction Analysis is the initial step of the OMT methodology. It is apprehensive with devising a precise, concise, correct and understandable mo

Draw an entity-relationship model, Draw an Entity-Relationship model for ... Draw an Entity-Relationship model for the relational schema given in the Appendix. Show all the entities, relationships, relationship names, and attributes and also underline the

What is primary key explain, What is primary Key Explain? Primary Key ... What is primary Key Explain? Primary Key - Primary key is one of the candidate keys. It should be selected such in which its attribute values are never, or very rarely, chang

Define variable-length records arise in database, What are the ways in whic... What are the ways in which the variable-length records arise in database systems? Storage of many record types in a file. Record types that permit variable lengths for one o

Define mysql_fetch_object(), What are the differences among MySQL_fetch_arr... What are the differences among MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()? Mysql_fetch_object returns the result from the database like objects while mysql

What is the meaning of recovery, What is the meaning of Recovery? In d... What is the meaning of Recovery? In deferred update methods, if a transaction fails before arriving its commit point, it will not have altered the database in any way, so UNDO

DBMS , need a DBMS system on any data for assignment. need a DBMS system on any data for assignment.

#title., WHY SHOULD NULL IN A RELATION BE AVOID AS possible? WHY SHOULD NULL IN A RELATION BE AVOID AS possible?