EPSRC logo

Details of Grant 

EPSRC Reference: GR/J92170/01
Title: IMPLEMENTATION OF RAM/RAID FOR HIGH PERFORMANCE DATABASES RELATIONAL DATA
Principal Investigator: McGregor, Professor D
Other Investigators:
Wilson, Dr J Cockshott, Dr P
Researcher Co-Investigators:
Project Partners:
Department: Computer and Information Sciences
Organisation: University of Strathclyde
Scheme: Standard Research (Pre-FEC)
Starts: 01 June 1994 Ends: 31 May 1996 Value (£): 150,694
EPSRC Research Topic Classifications:
Information & Knowledge Mgmt
EPSRC Industrial Sector Classifications:
Information Technologies
Related Grants:
Panel History:  
Summary on Grant Application Form
(1) Investigate entropy encoded Database architectures(2) Develop prototype compressed relational engine(3) Evaluate its performance, using telecom or other Database information.(4) Produce design capable of transferring to commercial exploitation within three years.Progress:Following an initial theoretical and experimental investigation of a number of basic variants of strategy, a workshop was held with staff of our Industrial Sponsor (GPT PLC) which discussed the early results, and requirements for high speed databases in the telecommuni-cations domain. An analytical modelling tool has been developed which enables us to estimate the space requirements of different databases, useful in evaluating suitability of potential applications. A test-bed has been produced. First test results are encouraging, (and in line with targets). Initial datasets show compression ratios of approximately 10:1 [7:1 to 15:1] relative to their corresponding conventional database representation. Relational accesses average .5ms per tuple returned (on a 486/DX66 machine). The next milestones are to investigate alternative fundamental datastructures, second order compression, and k-nearest-neighbour access, determining the space/speed trade off for a range of sizes, and types of datasets. StaffingThe project began on 1st June 1994, with the appointment of 2 staff, Mr. Colin Fyfe (an experienced researcher), as manager, and Mr. Philip Murray a Computer Science graduate with 2 years postgraduate experience. Unfortunately we lost Mr. Fyfe in November to a lecturing post, but have recruited Mr. John Gilchrist a Physics graduate, with industrial experience and an MSc in Computer Science. Intellectual PropertyA provisional application for a patent is being filed. A report has been written collating results of our initial measurements on a conventional database system. Papers are being prepared on the architecture and on performance(awaiting filing of patent).
Key Findings
This information can now be found on Gateway to Research (GtR) http://gtr.rcuk.ac.uk
Potential use in non-academic contexts
This information can now be found on Gateway to Research (GtR) http://gtr.rcuk.ac.uk
Impacts
Description This information can now be found on Gateway to Research (GtR) http://gtr.rcuk.ac.uk
Summary
Date Materialised
Sectors submitted by the Researcher
This information can now be found on Gateway to Research (GtR) http://gtr.rcuk.ac.uk
Project URL:  
Further Information:  
Organisation Website: http://www.strath.ac.uk