COMP 266 Lecture Notes - Lecture 7: Database Server, Temporary File, Scalability
Question: The UBS broker company has a
database server with ...
Show transcribed image text
Expert Answer
The potential reasons for the performance can be:
1. The response time provided by the server to accounting and stock exchange
applications might be increased due to same disk usage, i.e. more reads than writes with
small I/O size.
2.Intensive bandwidth usage may occur due to which the performance may get degraded.
3.It can be insufficient number of drives to service I/O’s.
4.Poor Indexing schemes.
5.Database structure might not well normalized.
6.Scalability problems occurring due to access patterns.
Methods for reducing I/O contention:
1.Use multiple disks to store files.
2.Seperate read-only data from writable data
3.Table Placement.
Place each table on different disk drives so that queries which access multiple tables will
not create I/O contention on one disk.
4.Index Placement.
One should not place indexes on the same disk drive as other information that will likely
be accessed by a query that uses the index.
5.Temporary File Placement.
temporary files must be placed on other disk which is not used for storing data and
indexes.
find more resources at oneclass.com
find more resources at oneclass.com
Document Summary
Question: the ubs broker company has a database server with The potential reasons for the performance can be: the response time provided by the server to accounting and stock exchange applications might be increased due to same disk usage, i. e. more reads than writes with small i/o size. 2. intensive bandwidth usage may occur due to which the performance may get degraded. 3. it can be insufficient number of drives to service i/o s. Place each table on different disk drives so that queries which access multiple tables will not create i/o contention on one disk. One should not place indexes on the same disk drive as other information that will likely be accessed by a query that uses the index.