Design of a spatial data structure using the relational normal forms
- 1 January 1987
- journal article
- research article
- Published by Taylor & Francis in International Journal of Geographical Information Science
- Vol. 1 (1) , 33-50
- https://doi.org/10.1080/02693798708927791
Abstract
In previous work, a relational data structure aimed at the exchange of spatial data between systems was developed. As this data structure was relational it was of first normal form, but compliance with the higher normal forms was not investigated. Recently, a new procedural method for composing fully normalized data structures from the basic data fields has been developed by H. C. Smith, as an alternative to the process of non-loss decomposition which is difficult to understand. Smith's method has been applied to data fields required to store points, lines and polygons in a chain-node spatial data model. When geographic domain, coverage layer and map are also considered, the procedure naturally leads to a catalogue model, needed for the exchange of spatial data. Although the method produces a fully normalized data structure, it is not as easy to identify which normal forms are responsible for the ultimate arrangement of the data fields into relations, but the benefits of these criteria for data base development also apply to spatial data structures and related ancillary data.Keywords
This publication has 3 references indexed in Scilit:
- Database design: composing fully normalized tables from a rigorous dependency diagramCommunications of the ACM, 1985
- Digital cartographic data standards; an interim proposed standardOpen-File Report, 1985
- A simple guide to five normal forms in relational database theoryCommunications of the ACM, 1983