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

Oracle/sql, can you create a database for me in oracle/sql

can you create a database for me in oracle/sql

Describe the grant function and explain security, Describe the GRANT functi...

Describe the GRANT function and explain, how it associates to security. What kind of privileges may be granted? How are they revoked? Ans: Since more than one user can aacce

Draw the architecture of mysql, Data Base Management System 1. Draw the...

Data Base Management System 1. Draw the Architecture of MySQL and explain about its subsystems briefly. 2. Elaborate with the help of an example the concept of Primary key a

Design an entity relation model, Funky Festivals Specification Funky Fe...

Funky Festivals Specification Funky Festivals organise music festivals which take place at various venues throughout the UK.  A venue needs to be booked before a Festival can t

Explain the uses of deadlock, Explain the uses of deadlock It will lea...

Explain the uses of deadlock It will lead to deadlock since this is the only place where incoming acknowledgements are processed. Without this code, sender will keep timing ou

What is null described testing for null in sql?, What is NULL? Give an exa...

What is NULL? Give an example to described testing for NULL in SQL? The NULL SQL keyword is used to represent either a missing value or a value which is not applicable in a re

B+ tree, construct a B+ tree for the following set of key value (2,3,5,7,11...

construct a B+ tree for the following set of key value (2,3,5,7,11,19,23,29,31) in ascending order where the pointers that will fit in one node is as follows:A. four B. six C. eigh

BOGUS VS GENUINE EMPOWERMENT, what is bogus empowerment. And what is genuin...

what is bogus empowerment. And what is genuine empowerment

What are the types of reference, What are the types of reference?explain it...

What are the types of reference?explain it with suitable examples? Object oriented language given the ability to refer the object attribute of the type can be referred to the s

Explain growing phase of locking, Explain Growing Phase of locking Grow...

Explain Growing Phase of locking Growing Phase: In this phase the transaction can only obtain locks, but cannot release any lock. The transaction enters the growing phase as so

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