A database design for the med power supply network (1983)
During the 1981-82 summer vacation, I worked for the Christchurch Municipal Electricity Department (MED) developing and implementing a vehicle information system. During this period, Chris Axford, MED Staff Planning Engineer, first presented me with the problems involved in the design of a future MED Engineering Database. The MED operates a complex electricity supply network about which it is necessary to maintain a vast quantity of technical information for operational, maintenance and planning purposes. Many small manual information systems in the forms of cards, maps, books etc. presently exist within the engineering divisions. These systems are often inaccessible and they lack co-ordination, flexibility and accuracy. A well designed centralised computer database would not suffer from these limitations. Such a system would provide for any user a common pool of accurate and up to date information accessible on a straightforward and systematic basis. Engineering studies, statistical surveys and reports that are at present very hard to obtain could be produced with relative ease. The problems and limitations of existing systems coupled with the obvious advantages of a centralised computer-based database makes a database system an obvious future requirement for the MED engineering divisions. The major database design difficulty lies in the development of a data structure to represent the network configuration. The complexity and vastness inherent in the design of the proposed database makes this design an ideal problem for an Honours Project. The major aim of this project was to achieve the initial design step towards future database implementation. Progress towards this goal was aided by the interested supervision of Chris Axford and the guidance of Dr. Cooper.
ANZSRC Fields of Research08 - Information and Computing Sciences::0806 - Information Systems::080604 - Database Management
09 - Engineering::0906 - Electrical and Electronic Engineering
RightsCopyright Paul J. Commons
Showing items related by title, author, creator and subject.
Wilson, R. P. (University of Canterbury, 1989)Many of the methods and models so far developed for database schema design have proved to be complex, highly theoretical in nature, and often have NP complete aspects. The method investigated in this project [Smith 1985] ...
A guide to schema design methods : a supplementary technical report to "a survey of a database technique" Neil, S. (University of Canterbury, 1988)In this document some of the major different schools of schema design methods will be outlined. This is important because the different schools, and different specific examples of these schools, will be referred to in ...
Neil, S. (University of Canterbury, 1988)This project is primarily concerned with the area of Database schema design methods. It is split into two main parts: the first is concerned with an academic investigation of the diagramming technique, and the second ...