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

What are the purpose for having variable length records, What are the purpo...

What are the purpose for having variable length records? What kinds of separator characters are required for each? Variable-Length Records - Variable-length records are thos

Implementation of database, The ER diagram clearly showing the additional t...

The ER diagram clearly showing the additional tables you have implemented. SQL table creation scripts for the tables you have set up. SQL scripts showing the sample data you

List the table modification commands in sql, List the table modification co...

List the table modification commands in SQL? A) Deletion B) Updates C) Insertion D) Update of a view

Entity Relationship for music band managem modeliing, i am required to come...

i am required to come up with entities relationships, optionality and cardinality from a scenario. there is a night club and bookings for a musician band

What is key, What is key ? Key - A single attribute or a combination of...

What is key ? Key - A single attribute or a combination of two or more attributes of an entity set which is used to recognize one or more instances (rows) of the set (table) is

Types of locks, Types of Locks There are two necessary types of locks: ...

Types of Locks There are two necessary types of locks: Binary lock : This locking mechanism has two states for to a data item: locked or unlocked Multiple-mode loc

Which sorting technique is used to sort databases, Which sorting technique ...

Which sorting technique is used to sort databases, whose sizes are very big?  Give one such algorithm.  Why do sorting techniques like quicksort, insertion sort, etc.  not applied

Data fragmentation in distributed database system, brief history,definition...

brief history,definition,current trends and future trends if any of data fragmentation

System level permissions-data control, System level permissions : With the ...

System level permissions : With the use of data dictionary you can view them.       Let us take the table name as user_sys_privs (used in oracle).       DESCRIBE USER_SYS_PRI

Why do you go for sorting your query results, Why do you go for sorting you...

Why do you go for sorting your query results? SQL SELECT command to fetch data from MySQL table. Whenever you select rows, the MySQL server is free to return them in any order

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