Abstract
Spatial data types or algebras for database systems should (1) be fully general, that is, closed under set operations, (2) have formally defined semantics, (3) be defined in terms of finite representations available in computers, (4) offer facilities to enforce geometric consistency of related spatial objects, and (5) be independent of a particular DBMS data model, but cooperate with any. We present an algebra that usesrealms as geometric domains underlying spatial data types. A realm, as a general database concept, is a finite, dynamic, user-defined structure underlying one or more system data types. Problems of numerical robustness and topological correctness are solved within and below the realm layer so that spatial algebras defined above a realm have very nice algebraic properties. Realms also interact with a DMBS to enforce geometric consistency on object creation or update. The ROSE algebra is defined on top of realms and offers general types to represent point, line, and region features, together with a comprehensive set of operations. It is described within a polymorphic type system and interacts with a DMBS data model and query language through an abstractobject model interface. An example integration of ROSE into the object-oriented data model O2 and its query language is presented.
Article PDF
Similar content being viewed by others
Avoid common mistakes on your manuscript.
References
Bancilhon, F. Query languages for object-oriented database systems: Analysis and a proposal.Proceedings of the BTW (Datenbanksysteme in Büro, Technik und Wissenschaft), Zürich, 1989.
Bancilhon, F., Cluet, S., and Delobel, C. A query language for the O2 object-oriented database system.Proceedings of the Second Workshop on Database Programming Languages, Salishan, OR, 1989.
Bancilhon, F., Delobel, C., and Kanellakis, P. The O2Book. San Mateo, CA: Morgan-Kaufmann, 1992.
Becker, L., and Güting, R.H. Rule-based optimization and query processing in an extensible geometric database system.ACM Transactions on Database Systems, 17:247–303, 1992.
Bentley, J.L., and Ottmann, T. Algorithms for reporting and counting geometric intersections.IEEE Transactions on Computers, C-28:643–647, 1979.
Egenhofer, M.J., Frank, A., and Jackson, J.P. A topological data model for spatial databases.Proceedings of the First International Symposium on Large Spatial Databases, Santa Barbara, CA, 1989.
Frank A. and Kuhn, W. Cell graphs: A provable correct method for the storage of geometry.Proceedings of the Third International Symposium on Spatial Data Handling, Seattle, 1986.
Gargano, M., Nardelli, E., and Talamo, M. Abstract data types for the logical modeling of complex data.Information Systems, 16(5):565–584, 1991.
Greene, D. and Yao, F. Finite-resolution computational geometry.Proceedings of the Twenty-seventh IEEE Symposium on Foundations of Computer Science, Toronto, 1986.
Güting, R.H. Geo-relational algebra: A model and query language for geometric database systems.Proceedings of the International Conference on Extending Database Technology, Venice, Italy, 1988a.
Güting, R.H. Modeling non-standard database systems by many-sorted algebras. Fachbereich Informatik, Universität Dortmund, Report 255, 1988b.
Güting, R.H. Gral: An extensible relational database system for geometric applications.Proceedings of the Fifteenth International Conference on Very Large Data Bases, Amsterdam, 1989.
Güting, R.H. Second-order signature: A tool for specifying data models, query processing, and optimization.Proceedings of the ACM SIGMOD Conference, Washington, DC, 1993.
Güting, R.H., de Ridder, T., and Schneider, M. Implementation of the ROSE algebra: Efficient algorithms for realm-based spatial data types. Fern Universität Hagen, Informatik-Report 170, 1995.
Güting, R.H. and Schneider, M. Realms: A foundation for spatial data types in database systems.Proceedings of the Third International Symposium on Large Spatial Databases, Singapore, 1993.
Henrich, A., Six, H.-W., and Widmayer, P. The LSD tree: Spatial access to multidimensional point- and non-point-objects.Proceedings of the Fifteenth International Conference on Very Large Data Bases, Amsterdam, 1989.
Joseph, T., and Cardenas, A. PICQUERY: A high level query language for pictorial database management.IEEE Transactions on Software Engineering, 14:630–638, 1988.
Lipeck, U. and Neumann, K. Modelling and manipulating objects in geoscientific databases.Proceedings of the Fifth International Conference on the Entity-Relationship Approach, Dijon, France, 1986.
Nievergelt, J., and Preparata, F.P. Plane-sweep algorithms for intersecting geometric figures.Communications of the ACM, 25:739–747, 1982.
Orenstein, J., and Manola, F. PROBE spatial data modeling and query processing in an image database application.IEEE Transactions on Software Engineering. 14:611–629, 1988.
O2 User's Manual, Version 4.1. O2 Technology, 1993.
de Ridder, T. Die ROSE-Algebra: Implementierung geometrischer Datentypen und Operationen für erweiterbare Datenbanksysteme (The ROSE algebra: Implementation of geometric data types and operations for extensible database systems). Fernuniversität Hagen, Fachbereich Informatik, Diplomarbeit (Master Thesis), 1994.
de Ridder, T. The ROSE system. Modula-2 Program System (Source Code). Fern-Universität Hagen, Praktische Informatik IV, Software Report 1, 1995. Available as a LATEX file for printing and/or as a compressed collection of ASCII files.
Rossopoulos, N., Faloutsos, C., and Sellis, T. An efficient pictorial database system for PSQL.IEEE Transactions on Software Engineering, 14:639–650, 1988.
Schek, H.J. and Weikum, G. Erweiterbarkeit, Kooperation, Föderation von Datenbanksystemen (Extensibility, Cooperation, Federation of Database Systems).Proceedings of the BTW (Datenbanksysteme in Büro, Technik und Wissenschaft), Kaiserslautern, 1991.
Scholl, M. and Voisard, A. Thematic map modeling.Proceedings of the First International Symposium on Large Spatial Databases, Santa Barbara, CA, 1989.
Svensson, P. and Huang, Z. Geo-SAL: A query language for spatial data analysis.Proceedings of the Second International Symposium on Large Spatial Databases, Zürich, 1991.
Tomlin, C.D.Geographic Information Systems and Cartographic Modeling. Englewood Cliffs, NJ: Prentice Hall, 1990.
Voisard, A. Bases de données géographiques: du modèle de données à l'interface utilisateur. Ph.D. Thesis, University of Paris-Sud (Centre d'Orsay), 1992.
Author information
Authors and Affiliations
Rights and permissions
About this article
Cite this article
Güting, R.H., Schneider, M. Realm-based spatial data types: The ROSE algebra. VLDB Journal 4, 243–286 (1995). https://doi.org/10.1007/BF01237921
Received:
Revised:
Accepted:
Issue Date:
DOI: https://doi.org/10.1007/BF01237921