From Databases to Exchange Formats

  • Chapter
  • First Online:
Fundamentals of Information Systems Interoperability

Abstract

This chapter addresses the question of how to transform relational database content into exchange formats in order to enable data interoperability between information systems. XML is chosen as exchanged format and a detailed introduction to XML foundations is provided. Further exchange formats comprise JSON, YAML, BSON, and MSGPACK.

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

Access this chapter

Subscribe and save

Springer+ Basic
EUR 32.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 (Canada)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 29.99
Price excludes VAT (Canada)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 37.99
Price excludes VAT (Canada)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free ship** worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Information technology—database languages—sql—part 14: Xml-related specifications (sql/xml). Tech. Rep. ISO/IEC 9075-14 (2006)

    Google Scholar 

  2. Atzeni, P., Bugiotti, F., Cabibbo, L., Torlone, R.: Data modeling in the NoSQL world. Comput. Stand. Interfaces 67, 103149 (2020). https://doi.org/10.1016/j.csi.2016.10.003

    Article  Google Scholar 

  3. Bahta, R., Atay, M.: Translating JSON data into relational data using schema-oblivious approaches. In: Lo, D., Kim, D., Gamess, E. (eds.) ACM Southeast Conference, pp. 233–236. ACM, New York (2019). https://doi.org/10.1145/3299815.3314467

    Google Scholar 

  4. Bertino, E., Catania, B.: Integrating XML and databases. IEEE Internet Comput. 5(4), 84–88 (2001). https://doi.org/10.1109/4236.939454

    Article  Google Scholar 

  5. Boureet, R.: Xml and Databases (2005). http://www.rpbourret.com/xml/XMLAndDatabases.htm

  6. Davoudian, A., Chen, L., Liu, M.: A survey on NoSQL stores. ACM Comput. Surv. 51(2), 40:1–40:43 (2018). https://doi.org/10.1145/3158661

  7. Florescu, D., Kossmann, D.: Storing and querying XML data using an RDMBS. IEEE Data Eng. Bull. 22(3), 27–34 (1999)

    Google Scholar 

  8. Forresi, C., Gallinucci, E., Golfarelli, M., Hamadou, H.B.: A dataspace-based framework for OLAP analyses in a high-variety multistore. VLDB J. 30(6), 1017–1040 (2021). https://doi.org/10.1007/s00778-021-00682-5

    Article  Google Scholar 

  9. Grinberg, A.: Shredding XML, pp. 101–134. Apress, Berkeley (2018). https://doi.org/10.1007/978-1-4842-3117-3_4

  10. Holupirek, A., Scholl, M.H.: Implementing filesystems by tree-aware DBMSS. Proc. VLDB Endow. 1(2), 1623–1630 (2008)

    Article  Google Scholar 

  11. Meike Klettke, H.M.: XML & Datenbanken Konzepte, Sprachen und Systeme. dpunkt.verlag (2003)

    Google Scholar 

  12. Moos, A.: XQuery und SQL/XML in DB2-Datenbanken. Vieweg+Teubner, Berlin (2008)

    Google Scholar 

  13. Schöning, H.: XML und Datenbanken. Carl Hanser Verlag, München Wien (2003)

    Google Scholar 

  14. Schweinsberg, K., Wegner, L.M.: Advantages of complex SQL types in storing XML documents. Future Gener. Comput. Syst. 68, 500–507 (2017). https://doi.org/10.1016/j.future.2016.02.013

    Article  Google Scholar 

  15. Kazakos, W., Schmidt, A., Tomczyk, P.: Datenbanken und XML. Springer, Berlin (2002)

    Book  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2024 Springer Nature Switzerland AG

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Rinderle-Ma, S., Mangler, J., Ritter, D. (2024). From Databases to Exchange Formats. In: Fundamentals of Information Systems Interoperability. Springer, Cham. https://doi.org/10.1007/978-3-031-48322-6_2

Download citation

  • DOI: https://doi.org/10.1007/978-3-031-48322-6_2

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-031-48321-9

  • Online ISBN: 978-3-031-48322-6

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Navigation