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

Ask an Expert

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

Write your message here..

Related Questions

Economics, Economics: It is now usually accepted that it costs less to make... Economics: It is now usually accepted that it costs less to make a system of smaller computers with the equivalent power of a one large computer. It is more cost-effective to get s

Database Management System, Assume that you are responsible for selecting a... Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

What is the function of io/m signal in the 8085, What is the function of IO... What is the function of IO/M signal in the 8085? It is a status signal. It is used to differentiate among memory locations and I/O operations. When this signal is low (IO/M = 0

What is primary index, Primary Index In primary index, there is a one-t... Primary Index In primary index, there is a one-to-one relationship among the entries in the index table and the records in the major table. Primary index can be of two types:

Advantages and drawbacks of ddbms, Advantages And Drawbacks Of Ddbms  T... Advantages And Drawbacks Of Ddbms  There are various reasons for building distributed database systems, with sharing of data, reliability and availability, and speedup of query

Write short notes on data ware housing, Write short notes on data ware hous... Write short notes on data ware housing? Data ware housing applications needs the transformation of data from many sources into a cohesive reliable step set of data configured a

Types of database, what are the type of the database what are the type of the database

Tuples-attributes , Consider a relation s over the attributes A and B wit... Consider a relation s over the attributes A and B with the following characteristics: 5,000 tuples with 10 tuples per page A 2-level B+ tree index on attribute

Explain the term- event, Event Occurrence of a process is called event... Event Occurrence of a process is called event. In other words, the object can receive many input instructions. The changes which occur due to these instructions are known as e

What is natural language interfaces, What is Natural Language Interfaces? ... What is Natural Language Interfaces? Natural Language Interfaces - These interfaces accept requests written within English or a few other language and attempt to "understand" t