TECHNICAL PAPERS
Feb 1, 1991

Data‐Base Management System Technology and Geographic Information Systems

Publication: Journal of Surveying Engineering
Volume 117, Issue 1

Abstract

Current operational data‐base management system technology is restrictive in its capacity to clearly model and efficiently manage complex data objects, in general, and spatial data objects, such as those handled by geographic information system (GIS) software, in particular. This has led to the prevalence of hybrid GIS software architectures, in which the lexical and geometric components of spatial data are managed in a disintegrated fashion. However, recent developments in object‐oriented DBMS technology suggest approaches for the unified management of spatial data. The need for distributed management of spatial data poses further technological challenges. Structure transfer protocols must be further developed to support real‐time interchanges of subsets of spatial database on a query‐by‐query basis. Distributed crash recovery, concurrency control, and multiple copy updated capabilities as developed for distributed relational data bases must also be provided for distributed object‐oriented data bases. Also, the technology to support physical and semantic integration needs to be further developed to allow distributed GISs to be built from pre‐existing single‐site components.

Get full access to this article

View all available purchase options and get full access to this article.

References

1.
Batini, C., Lenzerini, M., and Navathe, S. B. (1986). “A comparative analysis of methodologies for database schema integration.” ACM Comput. Surveys, 18(4), 323–364.
2.
Breitbart, Y., Olson, P. L., and Thompson, G. R. (1989). “Database integration in a distributed heterogeneous datatbase system.” Proc. of the Int. Conf. on Data Engineering, IEEE, 301–310.
3.
Ceri, S., and Pelagatti, G. (1984). Distributed databases—principles and systems. McGraw‐Hill Inc., New York, N.Y.
4.
Chen, P. P. S. (1976). “The entity‐relationship model: Toward a unified view of data.” Trans. on Database Systems, ACM, 1(1), 9–36.
5.
Chung, C. (1990). “Dataplex: An access to heterogeneous distributed databases.” Commun. ACM, 33(1), 70–80.
6.
Dayal, U., and Hwang, H. (1984). “View definition and generalization for database integration in a multidatabase system.” Trans. on Software Engrg., IEEE, 10(6), 628–645.
7.
Deen, S. M., Ofori‐Dwumfuo, G. O., and Taylor, M. C. (1985). “The architecture of a generalized distributed database system—PRECI*.” The Comput. J., 28(3), 282–290.
8.
Deen, S. M., Amin, R. R., and Taylor, M. C. (1987). “Data integration in distributed databases.” Trans. on Software Engrg., IEEE, 13(7), 860–864.
9.
Delzompo, L. A. (1989). “NFS and RPC.” Unix Networking, S. G. Kochan and P. H. Wood, eds., Hayden Books, Indianapolis, Ind., 93–131.
10.
DeMichel, L. G. (1989). “Resolving database incompatibility: An approach to performing relational operations over mismatched domains.” Trans. on Knowledge and Data Engrg., IEEE, 1(4), 485–493.
11.
Dittrich, K. (1986). “Object‐oriented database systems: The notion and the issues.” Proc. of the Int. Workshop on Object‐Oriented Database Systems, Pacific Grove, Calif., 2–4.
12.
Elmasri, R., Devor, C., and Rahimi, S. (1981). “Notes on DDTS: An apparatus for experimental research in distributed database management systems.” SIGMOD Rec., ACM, July.
13.
Elmasri, R., Larson, J., and Navathe, S. (1987). “Schema integration algorithms for logical database design and federated databases.” Tech. Report CSC‐86‐9:8212, Honeywell, Inc., Golden Valley, Minnesota.
14.
Ferrier, A., and Stangret, C. (1982). “Heterogeneity in the distributed database management system Sirius‐Delta.” Proc. of the Eighth Int. Conf. on Very Large Databases, 45–53.
15.
Frank, A. (1982). “MAPQUERY: Data base query language for retrieval of geometric data and their graphical representation.” Comput. Graph., ACM, 16(2), 199–207.
16.
Gligor, V. D. (1982). “Features of structured‐data‐transfer protocols for networks of heterogeneous database management systems” Proc. of the Workshop on Self‐Describing Data Structures, University of Maryland, College Park, Md., 228–270.
17.
Gligor, V. D., and Luckenbaugh, G. L. (1984). “Interconnecting heterogeneous database management systems.” IEEE Comput., Jan., 33–43.
18.
Gligor, V. D., and Popescu‐Zeletin, R. (1986). “Transaction management in heterogeneous database management systems, information systems.” Inf. Syst., 11(4), 287–297.
19.
Goldman, K. J., Goldman, S. A., Kanellakis, P. C., and Zdonik, S. B. (1985). “ISIS: Interface for a semantic information system.” Proc. of the ACM‐SIGMOD Int. Conf. on the Management of Data, 328—342.
20.
Hammer, M., and McLeod, D. (1981). “Datatbase description with SDM: A semantic database model.” Trans. on Database Systems, ACM, 6(3), 351–386.
21.
Herring, J. R., Larson, R. C., and Shrivakumar, J. (1988). “Extensions to the SQL query language to support spatial analysis in a topological data base.” GIS/LIS 88 'Proc., 741–750.
22.
Hull, R., and King, R. (1987). “Semantic database modelling: Survey, applications, and research issues.” Comput. Surv., ACM, 19(3), 201–260.
23.
Kent, W. (1978). Data and reality, Elsevier North‐Holland Inc., New York, N.Y.
24.
Kent, W. (1979). “Limitations of record‐based information models.” Trans. on Database Systems, ACM, 4(1), 107–131.
25.
Kent, W. (1982). “Choices in practical data design.” Proc. of the Eighth Int. Conf. on Very Large Databases, 165–180.
26.
Kent, W. (1983). “A simple guide to five normal forms in relational database theory.” Commun. ACM, 26(2), 120–125.
27.
Landers, T., and Rosenberg, R. L. (1982). “An overview of multibase.” Distributed databases, H. J. Schneider, ed., North Holland Publishing Company, 556–579.
28.
Litwin, W., and Abdellatif, A. (1987). “An overview of the multi‐database manipulation language MDSL.” Proc. IEEE, 75(5), 621–631.
29.
Manola, F. (1990). “Object‐oriented knowledge bases, part 1.” AI Expert, Mar., 26–36.
30.
Morehouse, S. (1985). “ARC/INFO: a geo‐relational model for spatial information.” Proc. of Auto‐Carto VII, 338–345.
31.
Motro, A. (1987). “Superviews: Virtual integration of multiple databases.” Trans. on Software Engrg., IEEE, 13(7), 785–798.
32.
Navathe, S. B., Sashidhar, T., and Elmasri, R. (1984). “Relationship merging in schema integration.” Proc. of the 10th Int. Conf. on Very Large Data Bases, 78–90.
33.
Nyerges, T. L. (1989). “Schema integration analysis for the development of GIS databases.” Int. J. Geog. Inf. Syst., 3(2), 153–183.
34.
Peckham, J., and Maryanski, F. (1988). “Semantic data models.” Comput. Surv., ACM, 20(3), 153–189.
35.
Developing an implementation plan for a land information network in New Brunswick. (1987). Resource Information Management Group, Department of Surveying Engineering, University of New Brunswick, Fredericton, New Brunswick, Canada.
36.
Shipman, D. W. (1981). “The functional data model and the data language DA‐PLEX.” Trans. on Database Systems, ACM, 6(1), 140–173.
37.
Smith, J. M., Bernstein, P. A., Dayal, U., Goodman, N., Landers, T., Lin, K. W. T., and Wong, E. (1981). “Multibase—Integrating heterogeneous distributed database systems.” AFIPS Conf. Proc., 50, 487–499.
38.
Smith, K. E., and Zdonik, S. B. (1987). “Intermedia: A case study of the differences between relational and object‐oriented database systems.” OOPSLA '87 Conf. Proc.—Special Issue of SIGPLAN Notices, 12(12), 452–465.
39.
Souza, J. M. (1986). “SIS—A schema integration system.” Proc. of the Fifth British Nat. Conf. on Databases, 167–185.
40.
Stonebraker, M., Wong, E., Kreps, P., and Held, G. D. (1976). “The design and implementation of INGRES.” Trans. on Database Systems, ACM, 1(3), 189–222.
41.
Stonebraker, M., and Rowe, L. A. (1986). “The design of POSTGRES.” Proc. of the ACM‐SIGMOD Conf. on the Management of Data, 340–355.
42.
Stonebraker, M. (1989). “Future trends in database systems.” Trans. on Knowledge and Data Engrg., IEEE, 1(1), 33–43.
43.
Templeton, M., Brill, D., Hwang, A., Kameny, I., and Lund, E. (1983). “An overview of the mermaid system—A frontend to heterogeneous databases.” Proc. of EASCON 1983, 387–402.
44.
Van Roessel, J. W. (1987). “Design of a spatial data structure using the relational normal forms.” Int. J. Geog. Inf. Syst., 1(1), 33–50.
45.
Wang, R., and Madnick, S. E. (1989). “Facilitating connectivity in composite information systems.” Database, 20(3), 38–46.
46.
Waugh, T. C., and Healy, R. G. (1987). “The GEOVIEW design—Relational data base approach to geographical data handling.” Int. J. Geog. Inf. Syst., 1(4), 101–118.
47.
Webster, C. (1988). “Disaggregated GIS architecture—Lessons from recent developments in multi‐site database management systems.” Int. J. of Geog. Inf. Syst., 2(1), 67–69.
48.
Wong, H. K. T., and Kuo, I. (1982). “GUIDE: Graphical user interface for database exploration.” Proc. of the Eighth Int. Conf. on Very Large Data Bases, 22–32.
49.
Yu, C. T., Guh, K., Zhang, W., Templeton, M., Brill, P., and Chen, A. L. P. (1987). “Algorithms to process distributed queries in fast local networks.” Trans. on Comput., IEEE, 36(10), 1153–1163.

Information & Authors

Information

Published In

Go to Journal of Surveying Engineering
Journal of Surveying Engineering
Volume 117Issue 1February 1991
Pages: 9 - 26

History

Published online: Feb 1, 1991
Published in print: Feb 1991

Permissions

Request permissions for this article.

Authors

Affiliations

Richard J. Pollock
Res. Asst., Dept. of Surveying Engrg., Univ. of New Brunswick, P.O. Box 4400, Fredericton, New Brunswick, Canada, E3B‐5A3
John D. McLaughlin
Chmn., Dept. of Surveying Engrg., Univ. of New Brunswick, P.O. Box 4400, Fredericton, New Brunswick, Canada

Metrics & Citations

Metrics

Citations

Download citation

If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.

Cited by

View Options

Get Access

Access content

Please select your options to get access

Log in/Register Log in via your institution (Shibboleth)
ASCE Members: Please log in to see member pricing

Purchase

Save for later Information on ASCE Library Cards
ASCE Library Cards let you download journal articles, proceedings papers, and available book chapters across the entire ASCE Library platform. ASCE Library Cards remain active for 24 months or until all downloads are used. Note: This content will be debited as one download at time of checkout.

Terms of Use: ASCE Library Cards are for individual, personal use only. Reselling, republishing, or forwarding the materials to libraries or reading rooms is prohibited.
ASCE Library Card (5 downloads)
$105.00
Add to cart
ASCE Library Card (20 downloads)
$280.00
Add to cart
Buy Single Article
$35.00
Add to cart

Get Access

Access content

Please select your options to get access

Log in/Register Log in via your institution (Shibboleth)
ASCE Members: Please log in to see member pricing

Purchase

Save for later Information on ASCE Library Cards
ASCE Library Cards let you download journal articles, proceedings papers, and available book chapters across the entire ASCE Library platform. ASCE Library Cards remain active for 24 months or until all downloads are used. Note: This content will be debited as one download at time of checkout.

Terms of Use: ASCE Library Cards are for individual, personal use only. Reselling, republishing, or forwarding the materials to libraries or reading rooms is prohibited.
ASCE Library Card (5 downloads)
$105.00
Add to cart
ASCE Library Card (20 downloads)
$280.00
Add to cart
Buy Single Article
$35.00
Add to cart

Media

Figures

Other

Tables

Share

Share

Copy the content Link

Share with email

Email a colleague

Share