skip to main content
10.1145/3299815.3314467acmconferencesArticle/Chapter ViewAbstractPublication Pagesacm-seConference Proceedingsconference-collections
short-paper

Translating JSON Data into Relational Data Using Schema-oblivious Approaches

Published: 18 April 2019 Publication History

Abstract

JSON (JavaScript Object Notation) has become popular as the data exchange standard over the Web. JSON has been gaining more popularity over XML due to its simplicity, compactness and ability to fit into the object types of programming languages. The large sizes of JSON data has been primarily stored and managed by NoSQL document store systems. While NoSQL systems appeal to the developers due to the native support for the object types of programming languages, they do not provide mechanisms to support ACID properties for the transactions that occur over sensitive JSON data. In this paper, we propose to store and manage JSON data in relational database systems to get advantages of transaction management and concurrency control mechanisms. We elaborate whether JSON can be effectively stored in a relational database system as an alternative to NoSQL document stores as well as whether schema-oblivious XML-to-Relational mapping techniques can be adopted to the process of JSON-to-Relational mapping.

References

[1]
M. Piech and R. Marcjan, 2018. A New Approach to Storing Dynamic Data in Relational Databases Using JSON. Computer Science (AGH) 19(1) (2018)
[2]
Z. H. Liu, B. C. Hammerschmidt, and D. McMahon, 2014. JSON Data Management: Supporting Schema-less Development in RDBMS. SIGMOD Conference 2014, pp. 1247--1258, Snowbird, Utah, USA.
[3]
C. Chasseur, Y. Li, and J. M. Patel. 2013. Enabling JSON Document Stores in Relational Systems. WebDB 2013, pp. 1--6, New York, NY, USA.
[4]
M. Atay, A. Chebotko, D. Liu, S. Lu, and F. Fotouhi, 2007. Efficient Schema-based XML-to-Relational data mapping. Information Systems Journal 32 (3), pp. 458--476.
[5]
M. Atay, A. Chebotko, S. Lu, and F. Fotouhi, 2007. XML-to-SQL Query Mapping in the Presence of Multi-valued Schema Mappings and Recursive XML Schemas, 18th Int. Conf. on Database and Expert Sys. Apps., Regensburg, Germany.
[6]
J. Shanmugasundaram, K. Tufte, C. Zhang, G. He, D.J. DeWitt, and J.F. Naughton, Relational Databases for Querying XML Documents: Limitations and Opportunities, VLDB, 1999, pp. 302--314, Edinburgh, Scotland, UK.
[7]
D. Lee and W. Chu, Constraints-preserving Transformation from XML Document Type Definition to Relational Schema, ER, 2000, Salt Lake City, UT, USA.
[8]
P. Bohannon, J. Freire, P. Roy, and J. Simeon, From XML Schema to Relations: a Cost-based Approach to XML Storage, ICDE, 2002, San Jose, CA, USA.
[9]
D. Florescu and D. Kossmann, Storing and Querying XML Data Using an RDBMS, IEEE Data Eng. Bull. 22 (3) (1999), pp. 27--34.
[10]
M. Yoshikawa, T. Amagasa, T. Shimura, and S. Uemura. XRel: A Path-Based Approach to Storage and Retrieval of XML Documents using Relational Databases. ACM Trans. on Internet Technology (TOIT). 1, 2 (Nov. 2001), pp. 110--141.
[11]
A. Deutsch, M.F. Fernandez, and D. Suciu, Storing Semistructured Data with STORED, SIGMOD Conference, 1999, pp. 431--442, Philadelphia, PA, USA.
[12]
A. Schmidt, M. Kersten, M. Windhouwer, and F. Waas, Efficient Relational Storage and Retrieval of XML Documents, WebDB, 2000, Dallas, Texas, USA.
[13]
T. Grust, Accelerating XPath Location Steps, SIGMOD Conference, June 2002, pp. 109--120, Madison, Wisconsin, USA.
[14]
A. Kurt and M. Atay, An Experimental Study on Query Processing Efficiency of Native-XML and XML-enabled Relational Database Systems, Lecture Notes in Computer Science, Volume 2544, pp. 268--284, Dec 2002, Aizu-Wakamatsu, Japan.
[15]
US Zip Code Data Catalog, https://catalog.data.gov/dataset

Cited By

View all
  • (2023)A Survey on Mapping Semi-Structured Data and Graph Data to Relational DataACM Computing Surveys10.1145/356744455:10(1-38)Online publication date: 2-Feb-2023
  • (2022)Invisible XML coming into focusProceedings of Balisage: The Markup Conference 202210.4242/BalisageVol27.Eccl01Online publication date: 2022
  • (2020)Non-native Techniques for Storing JSON Documents into Relational TablesProceedings of the 22nd International Conference on Information Integration and Web-based Applications & Services10.1145/3428757.3429103(16-20)Online publication date: 30-Nov-2020

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
ACMSE '19: Proceedings of the 2019 ACM Southeast Conference
April 2019
295 pages
ISBN:9781450362511
DOI:10.1145/3299815
  • Conference Chair:
  • Dan Lo,
  • Program Chair:
  • Donghyun Kim,
  • Publications Chair:
  • Eric Gamess
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than the author(s) must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected].

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 18 April 2019

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. DBMS
  2. Data Mapping
  3. Data Translation
  4. Database
  5. JSON
  6. RDBMS
  7. Relational
  8. Schema-less
  9. Schema-oblivious
  10. XML

Qualifiers

  • Short-paper
  • Research
  • Refereed limited

Conference

ACM SE '19
Sponsor:
ACM SE '19: 2019 ACM Southeast Conference
April 18 - 20, 2019
GA, Kennesaw, USA

Acceptance Rates

Overall Acceptance Rate 502 of 1,023 submissions, 49%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)28
  • Downloads (Last 6 weeks)7
Reflects downloads up to 15 Feb 2025

Other Metrics

Citations

Cited By

View all
  • (2023)A Survey on Mapping Semi-Structured Data and Graph Data to Relational DataACM Computing Surveys10.1145/356744455:10(1-38)Online publication date: 2-Feb-2023
  • (2022)Invisible XML coming into focusProceedings of Balisage: The Markup Conference 202210.4242/BalisageVol27.Eccl01Online publication date: 2022
  • (2020)Non-native Techniques for Storing JSON Documents into Relational TablesProceedings of the 22nd International Conference on Information Integration and Web-based Applications & Services10.1145/3428757.3429103(16-20)Online publication date: 30-Nov-2020

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media