Skip to main content
SpringerLink
Log in

Realm-based spatial data types: The ROSE algebra

  • Published:
The VLDB Journal Aims and scope Submit manuscript

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

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.

    Google Scholar 

  • 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.

    Google Scholar 

  • Bentley, J.L., and Ottmann, T. Algorithms for reporting and counting geometric intersections.IEEE Transactions on Computers, C-28:643–647, 1979.

    Google Scholar 

  • 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.

    Google Scholar 

  • 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.

    Google Scholar 

  • 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.

    Google Scholar 

  • 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.

    Google Scholar 

  • 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.

    Google Scholar 

  • 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.

    Google Scholar 

  • 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.

Download references

Author information

Authors and Affiliations

  1. Praktische Informatik IV, Fern Universität Hagen, D-58084, Hagen, Germany

    Ralf Hartmut Güting (Professor) & Markus Schneider Dipl.-Inform. (Research Assistant)

Authors
  1. Ralf Hartmut Güting
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Markus Schneider Dipl.-Inform.
    View author publications

    You can also search for this author in PubMed Google Scholar

Rights and permissions

Reprints 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

Download citation

  • Received:

  • Revised:

  • Accepted:

  • Issue Date:

  • DOI: https://doi.org/10.1007/BF01237921

Key words

Search

Navigation