Non-query optimisations, Database Management System

Part: Recommended (Non-query) Optimisations

This section entitled "Recommended (non-query) optimisations" should be a brief report containing recommended optimisations you would recommend if you had total control of the database implementation. Web references will be permitted for this section, but must be presented using the Harvard System. 

Provide recommendations to areas like...

  • Operating System
  • Recommended processor
  • Recommended network connection
  • Recommended DBMS Parameter settings (i.e. buffer-size, cache-size etc.)
  • Use of RAID technology

Marks will be awarded for the use of references to reputable sources of information to support your proposals.

Helpfulness

If you post your Part 2 to Moodle, before your actual submission and somebody spots an improvement or slight error in your work that person will get a 5 mark bonus for helping. (A maximum of 2 bonus's will be awarded, but you don't have to stop being helpful).

Posted Date: 2/26/2013 12:41:14 AM | Location : United States







Related Discussions:- Non-query optimisations, Assignment Help, Ask Question on Non-query optimisations, Get Answer, Expert's Help, Non-query optimisations Discussions

Write discussion on Non-query optimisations
Your posts are moderated
Related Questions
How can you Start MySQL Server? To start the mysql program type it is name in the command- line prompt. After starting mysql program just display A welcome letter using the

what is view?explain

Define Two phase commit Two phase commit: To make sure atomicity, all the sites where a transaction is being executed must agree on the final outcome of the execution. The tran

Write the syntax of creating an INDEX ? Syntax of Creating an Index: CREATE [BITMAP] [UNIQUE] INDEX ON ( [, ] . . .);

What function divides one numeric expression by another and returns the remainder? MOD function divides one numeric expression by another and returns the remainder.


Explain what is DDL? DDL - Data Definition Language: statements used to define the database structure or schema. Some examples: CREATE - to create objects in the database ALT

Explain data abstraction? Data abstraction Data abstraction is a methodology in which enables us to isolate how a compound data object is utilized from the details of how it is

what would go in order patient#, patient name, patien address, surgeon#, surgeon name, surgery date, surgery type, drug admin

Q.  Define a weak entity set and its identifying relationship. List the necessary conditions for a meaningful identifying relationship set of a weak entity set.    Entity is a t