Skip to main content
SpringerLink
Log in
Book cover

International Symposium on Spatial and Temporal Databases

SSTD 2017: Advances in Spatial and Temporal Databases pp 416–420Cite as

pgMemento – A Generic Transaction-Based Audit Trail for Spatial Databases

  • Conference paper
  • First Online:

  • 1452 Accesses

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 10411))

Abstract

Within the last decades a great amount of location-based data has been integrated into spatial data infrastructures (SDI) on top of spatial databases. One essential but often neglected element for spatial data quality is the lineage, a history about how the data has been created and what transformations have been applied to it. While proprietary spatial databases offer provenance techniques to produce an audit trail for the data, open source alternatives like PostgreSQL leave it to the user to keep track of data changes. Thus, a variety of different approaches has been developed fulfilling this task. However, restore or repair functionalities are often missing or unable to work with data integrity constraints inside the database. pgMemento solves this by providing a transaction-based logging approach that allows for querying and reverting past data transformations more selectively.

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

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Notes

  1. 1.

    https://github.com/pgmemento.

  2. 2.

    http://postgis.net/.

  3. 3.

    http://pgxn.org/dist/cyanaudit/.

  4. 4.

    https://wiki.postgresql.org/wiki/Audit_trigger_91plus.

  5. 5.

    http://pgxn.org/dist/temporal_tables/.

  6. 6.

    http://andreas.scherbaum.la/writings/tablelog.pdf.

  7. 7.

    https://github.com/tudelft3d/Random3Dcity.

  8. 8.

    http://www.3dcitydb.org.

  9. 9.

    https://github.com/sebastian-r-schmidt/logicaldecoding.

References

  1. Kunde, F.: CityGML in PostGIS. Portability, management and performance analysis using the 3D City Database instance of Berlin. Master thesis, University of Potsdam (in german only) (2013)

    Google Scholar 

  2. Chaturvedi, K., Smyth, C.S., Gesquière, G., Kutzner, T., Kolbe, T.H.: Managing versions and history within semantic 3D city models for the next generation of CityGML. In: Abdul-Rahman, A. (ed.) Advances in 3D Geoinformation. LNGC, pp. 191–206. Springer, Cham (2017). doi:10.1007/978-3-319-25691-7_11

    Chapter  Google Scholar 

  3. Redweik, R., Becker, T.: Change detection in CityGML documents. In: Breunig, M., Al-Doori, M., Butwilowski, E., Kuper, P.V., Benner, J., Haefele, K.H. (eds.) 3D Geoinformation Science. LNGC. Springer, Heidelberg (2015). doi:10.1007/978-3-319-12181-9_7

    Google Scholar 

  4. Gröger, G., Kolbe, T.H., Schmittwilken, J., Stroh, V., Plümer, L.: Integrating versions, history and levels-of-detail within a 3D geodatabase. In: Gröger, G., Kolbe, T.H. (eds.) Proceedings of the 1st International Workshop on Next Generation 3D City Models, Bonn. EuroSDR Publication 49 (2005)

    Google Scholar 

  5. Kulkarni, K., Michels, J.E.: Temporal features in SQL: 2011. ACM SIGMOD Rec. 41(3), 34 (2012)

    Article  Google Scholar 

  6. Bakalov, P., Hoel, E., Menon, S., Tsotras, V.J.: Versioning of network models in a multiuser environment. In: Mamoulis, N., Seidl, T., Pedersen, T.B., Torp, K., Assent, I. (eds.) Advances in Spatial and Temporal Databases. Springer, Heidelberg (2009)

    Google Scholar 

  7. Roddick, J.F.: A survey of schema versioning issues for database systems. Inf. Softw. Technol. 37(7), 383–393 (1996)

    Article  Google Scholar 

  8. Stanislav, M.: Framework for managing distinct versions of data in relational databases. In: Ivanović, M., Thalheim, B., Catania, B., Schewe, K.-D., Kirikova, M., Šaloun, P., Dahanayake, A., Cerquitelli, T., Baralis, E., Michiardi, P. (eds.) ADBIS 2016. CCIS, vol. 637, pp. 229–234. Springer, Cham (2016). doi:10.1007/978-3-319-44066-8_24

    Chapter  Google Scholar 

  9. Wieland, M., Pittore, M.: A spatio-temporal building exposure database and information life-cycle management solution. ISPRS Int. J. Geo-Inf. 6(4), 114 (2017)

    Article  Google Scholar 

  10. De Castro, C., Grandi, F., Scala, M.: Schema versioning for multitemporal relational databases. Inf. Syst. 22(5), 249–290 (1997)

    Article  MATH  Google Scholar 

  11. van Oosterom, P.: Maintaining Consistent Topology including Historical Data in a Large Spatial Database. Auto Carto 13, Seattle, WA (1997)

    Google Scholar 

Download references

Acknowledgments

The work was supported by the Federal Ministry for Economic Affairs and Energy (BMWi) under grant agreement 01MD15001B (Project: ExCELL).

Author information

Authors and Affiliations

  1. Beuth University for Applied Sciences, Luxemburger Straße 10, 13353, Berlin, Germany

    Felix Kunde & Petra Sauer

Authors
  1. Felix Kunde
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Petra Sauer
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Felix Kunde .

Editor information

Editors and Affiliations

  1. Institute of Computer Science, Heidelberg University, Heidelberg, Germany

    Michael Gertz

  2. George Mason University, Fairfax, Virginia, USA

    Matthias Renz

  3. University of Queensland, Brisbane, Queensland, Australia

    Xiaofang Zhou

  4. ESRI, University of Minnesota, Minneapolis, Minnesota, USA

    Erik Hoel

  5. Auburn University, Auburn, Alabama, USA

    Wei-Shinn Ku

  6. Free University of Berlin, Dahlem, Berlin, Germany

    Agnes Voisard

  7. Microsoft, Redmond, Washington, USA

    Chengyang Zhang

  8. California State University, Sacramento, California, USA

    Haiquan Chen

  9. LinkedIn, Sunnyvale, California, USA

    Liang Tang

  10. University of North Texas, Denton, Texas, USA

    Yan Huang

  11. Virginia Tech, Falls Church, Virginia, USA

    Chang-Tien Lu

  12. Oracle, Redwood Shores, California, USA

    Siva Ravada

Rights and permissions

Reprints and permissions

Copyright information

© 2017 Springer International Publishing AG

About this paper

Cite this paper

Kunde, F., Sauer, P. (2017). pgMemento – A Generic Transaction-Based Audit Trail for Spatial Databases. In: Gertz, M., et al. Advances in Spatial and Temporal Databases. SSTD 2017. Lecture Notes in Computer Science(), vol 10411. Springer, Cham. https://doi.org/10.1007/978-3-319-64367-0_27

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-64367-0_27

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-64366-3

  • Online ISBN: 978-3-319-64367-0

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation