Speedup query processing, Database Management System

Speedup Query Processing:A query that includes data at various sites can be split into sub-queries. These sub- queries can be implemented in parallel by various sites. Such parallel sub-query evaluation permits faster processing of a user's query. In such type of cases in which data is replicated, queries might be sent to the least heavily loaded sites.

 

Posted Date: 3/12/2013 5:56:18 AM | Location : United States







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

Write discussion on Speedup query processing
Your posts are moderated
Related Questions
Automated system for appointment with sms and call confirmation with service providers and user has to be initiate automatically. After selecting time and date to use service, s

Example:  //REVOKE ALL ON EMP FROM MCA12;                              (All permissions will be cancelled) You can also cancel only some of the permissions. Drop: A user-


What is meant by the degree of relationship set? The degree of relationship type is the number of participating entity types.

entity relationship diagram about finance

Describe the functions and features of foreign key? Foreign Key : The primary key of one file or table that is implanted in another file or table to implement the relationships

what is view?explain

Explain data dictonary on oracle ? Data Dictionary - Data dictionaries are the system tables in which contain descriptions of the database objects and how they are structured.

What are deadlocks?  How can they be avoided?  Ans: Deadlock considers to a particular condition when two or more processes are every waiting for another to release a resource,

A Relation Schema represented by R(A1, A2, ..., An) is made up of the relation name the list of attributes and R Ai that it contains. A relation is described as a set of tuples