EPSRC Reference: |
GR/J92170/01 |
Title: |
IMPLEMENTATION OF RAM/RAID FOR HIGH PERFORMANCE DATABASES RELATIONAL DATA |
Principal Investigator: |
McGregor, Professor D |
Other Investigators: |
|
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: |
|
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 |