Transcript 2nd Presentation

An Investigation into
Database Farming for
Improved Performance
Presented by: Russell Yong
Supervisor: Prof Peter Wentworth
Quick Recap

Databases used in major
corporations require:
Expensive software (Oracle, IBM, SAP)
 Tremendous amounts of hardware is
needed to produce acceptable
performance levels

Quick Recap
Use a less expensive hardware and
software (SQL Server 2000)
 Use tried and tested techniques

(Back-end server farming)

To produce a high-performance webservice (Disconnected data model)
Disconnected
Web-server
http requests
Dataset
Clients
Web service
Farm of databases
Problems
Course Work 
 .NET’s Threading Problem
 Queries are hard coded
 Demonstration <- .NET ‘gods’

Progression
Queries from multiple sources
simultaneously (Generic class)
 Time saving (primitive timing)
 Elegant recovery from exceptions

Where to from here?
Implement as a web service
 Get hold of a big enough test
database – perhaps with
performance issues
 User definable queries

Where to from here?
Decide on a query strategy
 Start performance tests
 Benchmarks
 Investigate various performance
enhancing configurations

Questions ?
P.S
 Don’t forget to watch Sanlam Money
Game on SABC 3 on the 15 August at
20:30