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
Secondary Indexes Let consider the student database and its clustering index and primary (only one will be applicable at a time). Now consider the state when the database is to

Java program for horrizontal fragmentation in distributed database

Question 1 Define OLTP? Explain the Differences between OLTP and Data Warehouse Question 2 What is Architecture? Explain various components involved in it Question

Determine the minimal set of functional dependencies for the following data. This table is part of the OHSU database of extracurricular activities and tracks the DMICE band's co

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

Describe association design of an object by giving one suitable example of it. The Design of Associations Associations are "glue" of advanced object oriented analysis and

Write a program within embedded SQL to associative the total trip expenses of the salesman named ‘John' for the relations. EXEC SQL BEGIN DECLARE SECTION; long total_expenses;

What are the disadvantages of file processing system? The drawbacks of file processing systems are a) Data redundancy and inconsistency b) Complexity in accessing data

What it creates while a primary key is combined with a foreign key? It creates Parent-Child relation ship between the tables that connect them while a primary key is combined w

Eliminate Redundant Data In the "Database Relation" above, the primary key is made up of the D-ID and the Emp-ID. The database-name relies only on the D-ID. The similar databas