What are the objectives of query processing, Database Management System

Assignment Help:

What are the objectives of query processing?

Ans: The objectives of query processing is to transform a query written in a high level language into a accurate and efficient execution strategy expressed in a low level language and implement the strategy to retrieve the data.

Related Discussions:- What are the objectives of query processing

Fragmentation, let us consider a table having 2200 records and the fixed si...

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

Relationship cardinality, Cardinality shows the number of instances of an e...

Cardinality shows the number of instances of an entity associated with another entity participating in a relationship. Depend on the cardinality binary relationship can be further

Define specialisation and generalization in brief, Define Specialisation an...

Define Specialisation and generalization in brief? Specialisation / generalization: Generalization or Specialization represents the is a relationship set, an necessary element

The concurrent transactions, The Concurrent Transactions Almost every ...

The Concurrent Transactions Almost every commercial DBMS support multi-user environment. Therefore, allowing multiple transactions to proceed concurrently. The DBMS must make

Draw entity relationship diagram, Draw entity relationship diagram for the ...

Draw entity relationship diagram for the following scenario. A university has many departments whereas each department belongs to that particular uni. That uni has also many bui

Management and use of database, I need help with some assignments

I need help with some assignments

Differance between internal and external schema, Differance between interna...

Differance between internal and external schema? Internal and external schema: Internal Schema • Describes the physical storage structure • Uses a physical data model External

#title., losers with new information systems

losers with new information systems

What are deadlocks, What are deadlocks? How can they be avoided? Ans:...

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,

Cartesian product, If R1 and R2 are two relations or functions, then the re...

If R1 and R2 are two relations or functions, then the result of R3 = R1 × R2 is the combination of tuples that are in R1 and R2. The product is associative and commutative. Degr

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages