Query optimization
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
namitasingh
Active In SP
**

Posts: 2
Joined: Dec 2010
#1
29-12-2010, 01:18 AM


i am final year B.E student in computer science.i am making my project and implimentation on Sql Tuner. before that i need to give seminar and presentation on Query optimization and how it is implemented in Sql Tuner.i know only basic information about Query optimization so i want full seminar and presentation report on the topic "QUERY OPTIMIZATION" including its introduction, theory, basic rules,techniques, applications,advantages, disadvantages, future, current tends, uses, examples illustrating rules, supporting diagrams with their explanation.
Reply
science projects buddy
Active In SP
**

Posts: 278
Joined: Dec 2010
#2
29-12-2010, 09:43 AM

Query Optimization
For a given query, there are many plans that a database management system
(DBMS) can follow to process it and produce its answer. The final output will be the same in the different methods followed, but the cost(the amount of time that they need to run) will be different. In short, Query optimization is a function of many relational database management systems in which multiple query plans for satisfying a query are examined and a good query plan is identified. There must be a trade-off between the times required to figure out the plan and run the plan. The plan that needs the least time must be chosen. Therefore a DBMS must have a query optimization. enormous cost difference can occur between two alternatives.The resource footprint of various query plans is evaluated by the cost based query optimizers. The CPU path length, amount of disk buffer space, disk storage service time etc are the resources in the computer system that are costed. The possible access paths are examined before forming the set of query plans. depending on the complexity of the SQL query, the search space can become extremely large. The two methods of optimization are:
logical optimization: a sequence of relational algebra is generated to solve the query.
physical optimization: the means of carrying out each operation is determined here.

For full details see:
en.wikipediawiki/Query_optimization
infolab.stanford.edu/~hyunjung/cs346/ioannidis.pdf
scribddoc/39640304/Query-Optimization
scribddoc/36880940/Query-Optimization
Use Search at http://topicideas.net/search.php wisely To Get Information About Project Topic and Seminar ideas with report/source code along pdf and ppt presenaion
Reply
ghasem
Active In SP
**

Posts: 2
Joined: Feb 2011
#3
04-02-2011, 07:52 PM

hello
i need a project and implimentation of query optimization with pso algorithm.
help me pleace.
i need a query optimization with pso algorithm.
help me please.
Reply

Important Note..!

If you are not satisfied with above reply ,..Please

ASK HERE

So that we will collect data for you and will made reply to the request....OR try below "QUICK REPLY" box to add a reply to this page

Quick Reply
Message
Type your reply to this message here.


Image Verification
Please enter the text contained within the image into the text box below it. This process is used to prevent automated spam bots.
Image Verification
(case insensitive)

Possibly Related Threads...
Thread Author Replies Views Last Post
  bacterial foraging optimization algorithm code in java Guest 2 272 06-05-2016, 10:27 AM
Last Post: mkaasees
  matlab code for chaos particle swarm optimization svm Guest 1 112 12-04-2016, 02:04 PM
Last Post: mkaasees
  ppt in railway route optimization system com Guest 1 83 27-02-2016, 11:42 AM
Last Post: mkaasees
  railway route optimization technique project synopsis Guest 0 45 12-01-2016, 06:39 PM
Last Post: Guest
  seminar report on ant colony optimization Guest 0 62 30-12-2015, 01:27 PM
Last Post: Guest
  list advantages of power optimization of lfsr for low power bist Guest 1 72 16-12-2015, 10:41 AM
Last Post: mkaasees
  matlab code for chaos particle swarm optimization svm sam7050 0 98 13-12-2015, 02:16 AM
Last Post: sam7050
  matlab code for chaos particle swarm optimization svm Guest 0 56 06-12-2015, 11:09 PM
Last Post: Guest
  ppt on optimization of spur gear parameters Guest 0 63 24-11-2015, 10:15 AM
Last Post: Guest
  optimization of upfc using fuzzy logic Guest 1 62 19-11-2015, 02:50 PM
Last Post: mkaasees