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
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

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? 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

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  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? Data ware housing applications needs the transformation of data from many sources into a cohesive reliable step set of data configured a


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

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? Natural Language Interfaces - These interfaces accept requests written within English or a few other language and attempt to "understand" t