Example of database optimisation, Database Management System

Create 1 experiment to demonstrate an aspect of query optimisation by using access-path structures (indexes), decomposition, or denormalisation. Once satisfied with your experiment, post it as a new discussion topic to the AllQuestionsForum on moodle with the subject title _Experiment1_identifier, and the body containing a description of the experiment for all to see (you must use
the format described below for your experiments)
To Do:

Create 1 practical experiment following this format:
Hypothesis (Reason/Theory behind proposing this experiment.):
This section must include references to relevant text-books and/or web-resources. Outline what you're trying to prove; 
Transaction Analysis;
Expected Output (how the experiment was supposed to behave);
Explain - using examples and references to relevant resources - how the experiment might be expected to
behave. If the results don't correlate to what you expected, make an educated comment as to how you believe
the MySQL DBMS implementation affected the results.


 SQL Query: the exact query being tested (must be a query that clearly demonstrate your hypothesis)
            State of DB before change
  EXPLAIN output
  Time Taken for Query Execution
 Change you made to the DB (demonstrate your hypothesis)
State of the DB after 
 EXPLAIN output
 Time Taken for Query Execution


Detail how you carried out the experiment. Detail how you used EXPLAIN or similar DBMS tools. Detail any important considerations such as having to re-load a fresh database, turn off caching etc., state why it is necessary to prepare in the way you suggest.

Posted Date: 2/26/2013 12:39:53 AM | Location : United States

Related Discussions:- Example of database optimisation, Assignment Help, Ask Question on Example of database optimisation, Get Answer, Expert's Help, Example of database optimisation Discussions

Write discussion on Example of database optimisation
Your posts are moderated
Related Questions
Q. Describe how an ER schema can be represented by relation schemas and constraints arising from ER design can be mapped to constraints on a relation schema.     The entity rela

Replicating Data One approach that may support efficient access to dissimilar applications as above may be to give access to every of the applications from dissimilar replicate

In which relational modes, cardinality is termed? Answer : Cardinality is termed in a number of tuples relational modes.

Define Hash files organization a. Hashing includes computing the address of a data item by calculating a function on the search key value.   b. A hash function h is a functi

What is a homogeneous distributed database? In homogeneous distributed databases, all sites have the same database management system software, are aware of one another, and agr

Ancestry database records information about family trees . Following information is recorded about each person: FIRSTNAME first name SURNAME surname MNAME maiden name (if

Show a centralised schema to support the operation of the system you have chosen, including in particular: the product catalogue; the outlets and respective stocks; customer record

real life situations where database management system are most suitable

what are the reasons having variable length records

What three major types of actions includes databases? Briefly discuss these The three major types of actions including databases are: (i) Defining: It includes specifyin