{"id":14998,"date":"2022-06-16T19:38:41","date_gmt":"2022-06-16T23:38:41","guid":{"rendered":"https:\/\/carleton.ca\/scs\/?page_id=14998"},"modified":"2026-06-09T10:09:48","modified_gmt":"2026-06-09T14:09:48","slug":"tr-193-realizing-a-spatial-topological-data-model-in-a-relational-database-management-system","status":"publish","type":"page","link":"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1991\/tr-193-realizing-a-spatial-topological-data-model-in-a-relational-database-management-system\/","title":{"rendered":"TR-193: Realizing a Spatial Topological Data Model in a Relational Database Management System"},"content":{"rendered":"\n<section class=\"w-screen px-6 cu-section cu-section--white ml-offset-center md:px-8 lg:px-14\">\n    <div class=\"space-y-6 cu-max-w-child-5xl  md:space-y-10 cu-prose-first-last\">\n\n            <div class=\"cu-textmedia flex flex-col lg:flex-row mx-auto gap-6 md:gap-10 my-6 md:my-12 first:mt-0 max-w-5xl\">\n        <div class=\"justify-start cu-textmedia-content cu-prose-first-last\" style=\"flex: 0 0 100%;\">\n            <header class=\"font-light prose-xl cu-pageheader md:prose-2xl cu-component-updated cu-prose-first-last\">\n                                    <h1 class=\"cu-prose-first-last font-semibold !mt-2 mb-4 md:mb-6 relative after:absolute after:h-px after:bottom-0 after:bg-cu-red after:left-px text-3xl md:text-4xl lg:text-5xl lg:leading-[3.5rem] pb-5 after:w-10 text-cu-black-700 not-prose\">\n                        TR-193: Realizing a Spatial Topological Data Model in a Relational Database Management System\n                    <\/h1>\n                \n                                \n                            <\/header>\n\n                    <\/div>\n\n            <\/div>\n\n    <\/div>\n<\/section>\n\n\n\n<p>Carleton University<br><a href=\"https:\/\/carleton.ca\/scs\/research\/scs-technical-reports\/technical-reports-1991\/\">Technical Report<\/a>&nbsp;<strong>TR-193<\/strong><br>August 1991<\/p>\n\n\n\n<h2 id=\"realizing-a-spatial-topological-data-model-in-a-relational-database-management-system\" class=\"wp-block-heading\">Realizing a Spatial Topological Data Model in a Relational Database Management System<\/h2>\n\n\n\n<p>Ekow J. Otoo &amp; M.M. Allam<\/p>\n\n\n\n<h3 id=\"abstract\" class=\"wp-block-heading\">Abstract<\/h3>\n\n\n\n<p>A Spatial Topological Data Model is presented for defining spatial entities and the rela\u00adtionships between them. The spatial entities are assumed to be vector encoded. The model is specialized for defining the geographic features in geographic information system. It is first described using an Entity Relationship diagram (ER-diagram). This is then translated, in a consistent manner, into a set of relational schemes. Although the paper focuses on the use of a relational database management system to represent a spatial topology model for vector data, the diagram can equally well be translated into a collection of object classes for an eventual implementation in an object oriented database. The model is simple, flex\u00adible, extendible and non-redundant. By maintaining sites of GIS databases that adhere to the proposed modeling technique, distributed processing in a network of heterogeneous GIS database can be easily achieved. Attribute information is easily associated to the defined spatial entities in a simple manner using the relational join operation.<\/p>\n\n\n\n<p><a href=\"https:\/\/carleton.ca\/scs\/wp-content\/uploads\/sites\/260\/TR-193.pdf\">TR-193.pdf<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Carleton UniversityTechnical Report&nbsp;TR-193August 1991 Realizing a Spatial Topological Data Model in a Relational Database Management System Ekow J. Otoo &amp; M.M. Allam Abstract A Spatial Topological Data Model is presented for defining spatial entities and the rela\u00adtionships between them. The spatial entities are assumed to be vector encoded. The model is specialized for defining the [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":11908,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_cu_dining_location_slug":"","footnotes":"","_links_to":"","_links_to_target":""},"cu_page_type":[],"class_list":["post-14998","page","type-page","status-publish","hentry"],"acf":{"cu_post_thumbnail":""},"_links":{"self":[{"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/pages\/14998","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/comments?post=14998"}],"version-history":[{"count":2,"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/pages\/14998\/revisions"}],"predecessor-version":[{"id":24517,"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/pages\/14998\/revisions\/24517"}],"up":[{"embeddable":true,"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/pages\/11908"}],"wp:attachment":[{"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/media?parent=14998"}],"wp:term":[{"taxonomy":"cu_page_type","embeddable":true,"href":"https:\/\/carleton.ca\/scs\/wp-json\/wp\/v2\/cu_page_type?post=14998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}