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
Which operations need the participating relations to be union compatible? A UNION, INTERSECTION and DIFFERENCE operations need the participating relations to be union compatibl

Information about a bank is about customers and their account. Customer has a name, address that consists of house number, area and city, and one or more phone numbers. Account ha

What is DML Query Langauge? Data Manipulation Language (DML) - A data manipulation language is a language in which enables users to access or manipulate data as organized throu

#queDefine a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pic

Define the following constraints for the table client. (i) BAL_DUE must be at least 1000. (ii) NAME is a unique key. (i)ALTER TABLE CLIENT ADD CONSTRAINT CLIENT_BAL_DUE_C1

lock and types of lock

Draw an EER diagram that captures the "is-a" hierarchy of students in another simple database. The database captures both the "basic" information (say, student ID and student name)

Describe the capabilities offered via MySQL client APIs? . • Checking for errors. . • Connecting to the MySQL server, selecting a database, disconnecting from the server

what is the relationship between receipt and owner entities in computer sales and service company

What is meant by functional dependencies? Consider a relation schema R and α C R and β C R. The functional dependency α ->β  holds on relational schema R if in any legal relati