Example of database optimisation, Database Management System

Assignment Help:

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.


Related Discussions:- Example of database optimisation

Explain two phase locking protocol, Explain Two phase locking protocol ...

Explain Two phase locking protocol A transaction is consider as to follow the two-phase locking protocol if all locking operations precede the first unlock operation in the tra

What are the ways of obtaining the connection parameters, What are the ways...

What are the ways of obtaining the connection parameters?  Hardwire the parameters into the program. Ask for the parameters interactively. Get the parameters

The locking protocol, The Locking Protocol: To manage concurrency related ...

The Locking Protocol: To manage concurrency related problems we use locking. A lock is mainly a variable that is associated with a data item in the database. A lock can be located

Equi-join, explain equi-join using illustration

explain equi-join using illustration

Eliminate redundant data, Eliminate Redundant Data In the "Database Rel...

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

Attribute preservation, Attribute Preservation This is a easy and obvio...

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.

What is business intelligence, Question A What is operational intelligence...

Question A What is operational intelligence? Question B What is Business Intelligence? Explain the components of BI architecture Question C Differentiate between databas

Views-data control, Views A view is like a window by which data from ta...

Views A view is like a window by which data from tables can be changed or viewed. The table on which a view is based is known as Base table. The view is stored as a SELECT stat

Define join and outer join, Define Join and Outer Join and differentiate be...

Define Join and Outer Join and differentiate between them.      Ans: Join - It generates all the combinations of tuples from two relations which satisfy a join condition.  Oute

What is vertical fragmentation, What is vertical fragmentation? Vertica...

What is vertical fragmentation? Vertical fragmentation divides the relation by decomposing the scheme R of relation r.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd