Skip to main content

Uniqueness Constraints on Property Graphs

  • Conference paper
  • First Online:
Advanced Information Systems Engineering (CAiSE 2021)

Abstract

Graph database are increasingly popular for data management and analytics. As with every data model, managing the integrity of entities is fundamental for data governance but also important for the efficiency of update and query operations. In response to shortcomings of uniqueness and existence constraints in graph databases, we propose a new principled class of constraints that separates uniqueness from existence dimensions, and fully supports multiple labels and composite properties. We illustrate benefits of the constraints on real-world examples by use of the node integrity they enforce for better update and query performance. We establish axiomatic and algorithmic characterizations for reasoning about any set of constraints in our new class. We also give examples of small node samples that satisfy the same constraints as the original data set, and are useful for the elicitation of business rules, and the identification of data quality problems. Finally, we briefly discuss the role of our constraints in the design for data quality, and propose extensions to managing node integrity within graph database systems.

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

Access this chapter

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

Notes

  1. 1.

    https://db-engines.com/en/ranking_trend/graph+dbms.

  2. 2.

    http://www.omdbapi.com.

References

  1. Batini, C., Maurino, A.: Design for data quality. In: Liu, L., Özsu, M.T. (eds.) Encyclopedia of Database Systems, 2nd edn. (2018)

    Google Scholar 

  2. Bonifati, A., Fletcher, G.H.L., Voigt, H., Yakovets, N.: Querying Graphs. Morgan & Claypool Publishers, Synthesis Lectures on Data Management (2018)

    Book  Google Scholar 

  3. Codd, E.F.: A relational model of data for large shared data banks. Commun. ACM 13(6), 377–387 (1970)

    Article  Google Scholar 

  4. Fan, W., Fan, Z., Tian, C., Dong, X.L.: Keys for graphs. PVLDB 8(12), 1590–1601 (2015)

    Google Scholar 

  5. Fan, W., Lu, P.: Dependencies for graphs. ACM Trans. Database Syst. 44(2), 5:1–5:40 (2019)

    Google Scholar 

  6. Lausen, G.: Relational databases in RDF: keys and foreign keys. In: SWDB-ODBIS, pp. 43–56 (2007)

    Google Scholar 

  7. Link, S.: Old keys that open new doors. In: Foundations of Information and Knowledge Systems - 10th International Symposium, FoIKS 2018, Budapest, Hungary, May 14–18, 2018, Proceedings, pp. 3–13 (2018)

    Google Scholar 

  8. Link, S.: Neo4j keys. In: Conceptual Modeling - 39th International Conference, ER 2020, Vienna, Austria, 3–6 November, 2020, Proceedings, pp. 19–33 (2020)

    Google Scholar 

  9. Pokorný, J., Valenta, M., Kovacic, J.: Integrity constraints in graph databases. In: The 8th International Conference on Ambient Systems, Networks and Technologies (ANT 2017) / The 7th International Conference on Sustainable Energy Information Technology (SEIT 2017), 16–19 May 2017, Madeira, Portugal. Procedia Computer Science, vol. 109, pp. 975–981. Elsevier (2017)

    Google Scholar 

  10. Wei, Z., Leck, U., Link, S.: Discovery and ranking of embedded uniqueness constraints. PVLDB 12(13), 2339–2352 (2019)

    Google Scholar 

  11. Wei, Z., Leck, U., Link, S.: Entity integrity, referential integrity, and query optimization with embedded uniqueness constraints. In: 35th IEEE International Conference on Data Engineering, ICDE 2019, Macao, China, 8–11 April, 2019, pp. 1694–1697 (2019)

    Google Scholar 

  12. Wei, Z., Link, S.: Embedded functional dependencies and data-completeness tailored database design. Proc. VLDB Endow. 12(11), 1458–1470 (2019)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Sebastian Link .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2021 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Skavantzos, P., Zhao, K., Link, S. (2021). Uniqueness Constraints on Property Graphs. In: La Rosa, M., Sadiq, S., Teniente, E. (eds) Advanced Information Systems Engineering. CAiSE 2021. Lecture Notes in Computer Science(), vol 12751. Springer, Cham. https://doi.org/10.1007/978-3-030-79382-1_17

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-79382-1_17

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-79381-4

  • Online ISBN: 978-3-030-79382-1

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics