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

Physical database design issues, Physical Database Design Issues The da... Physical Database Design Issues The database design includes the process of logical design with the use of E-R diagram, normalisation, etc., followed by the physical design.

Physical location of record is determined by which formula, The physical lo... The physical location of a record is determined by which mathematical formula that transforms a file key into a record location? The physical location of a record is determined

Distinguish among different kinds of parameters, How can one distinguish am... How can one distinguish among different kinds of parameters? Input parameters are used to pass data to subroutines. Output parameters are used to pass data from subrout

Enterprise applications integration, The figure below depicts the conceptu... The figure below depicts the conceptual diagram of a banking system. (a) Describe one example relevant to the system in figure, for each of the 4 types of enterprise appl

Advantages of database systems, Problem 1. Describe the following a)... Problem 1. Describe the following a) Advantages of Database Systems b) Functions of a DBMS Explanation of part (a) and (b) 2. Explain the following concepts w

Estimate the transaction states, Suppose an instruction takes 1 nanosecond ... Suppose an instruction takes 1 nanosecond to execute (on average), a page fault takes 20 microseconds of processor time, and it takes 300 microseconds of disk time to read or write

Define a table in sql known as client for store information, Define a table... Define a table in SQL known as Client that is used to store information about the clients. Define CLIENT_NO as the primary key whose first letter must begin with ‘C'. Also ensure t

Characteristics, what are the main characteristics of database what are the main characteristics of database

Normal forms, normal forms normal forms

Query processor in database management system, Query Processor The qu... Query Processor The query language processor is responsible for taking query language statements or shifting them from the English-like syntax of the query language to a form