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.

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

Account:

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
Explain the term- Query. Queries are used to repossess and show specific records in a table. They can also be used to show specific fields of specific records, which meet the co

In this practical assignment, we will run through a complete database application development cycle, starting with the schema design, from an initial data import to database applic

What are the Requirements of algorithm designer Algorithm designer should: i) Select proper algorithm so as to minimize implementation cost ii) Find most appropriate d

What is the difference between the function module and a normal ABAP/4 subroutine? In contrast to normal subroutines function modules have uniquely exact interface.  Declaring da

Determine the Derived attribute to avoid re-computation Each class box consists of an ordered list of attributes and operations, each represented as a next string. We can find

It defines that the tuple in one relation that refers to another relation must refer to an existing tuple in that relation. This constraint is states on two relations (not essentia

Security And Integrity After Reading the concepts of database recovery in the last section, let us now deal with a vital concept that helps in minimizing consistency errors in

I have 10+ yrs exp in oracle Sql ,Pl/SQl,Forms ,Reports. I am expert in assignements & Online tutoring so i want to join you. Please guide me. Thanks Brajesh Shukla +91 9899641535

Attribute Preservation This is a easy and obvious necessity that includes preserving all the attributes that were there in the relation that is being decomposed.

Normal 0 false false false EN-US X-NONE X-NONE