International Journal For Multidisciplinary Research

E-ISSN: 2582-2160   •   Impact Factor: 9.24

A Widely Indexed Open Access Peer Reviewed Multidisciplinary Bi-monthly Scholarly International Journal

Call for Paper Volume 7, Issue 2 (March-April 2025) Submit your research before last 3 days of April to publish your research paper in the issue of March-April.
Submit Research Paper Join as a Reviewer

Plagiarism is checked by the leading plagiarism checker TurnItIn

Call for Paper

Volume 7 Issue 2
March-April 2025

Submit your research paper

Indexing Partners
Academia Advanced Sciences Index Bielefeld Academic Search Engine CiteSeer DRJI Google Scholar Independent Search Engine & Directory Network ISI (International Scientific Indexing) Issuu Mendeley Research Networks
RefSeek ResearcherId - Thomson Reuters ResearchGate Scirus Scribd Semantic Scholar UTeM - Universiti Teknikal Malaysia Melaka Wiki for Call for Papers WorldCat Zenodo

SQL Meets JSON - Leveraging Relational Data Formats

Author(s) AzraJabeen Mohamed Ali
Country United States
Abstract The paper "SQL Meets JSON - Leveraging Relational Data Formats" explores the convergence of SQL and JSON, focusing on how modern relational database management systems (RDBMS) have evolved to support JSON data types, functions, and queries. In the era of data-driven applications, integrating
structured relational databases with the flexibility of semi-structured data formats like JSON has become increasingly important. Traditional relational databases, designed to handle structured data in predefined schemas, are now tasked with managing dynamic, hierarchical, and evolving data, often stored in JSON
format. This paper examines how RDBMS platforms such as SQL Server handles JSON data, providing tools to store, query, and manipulate JSON alongside relational data. It discusses the advantages of this integration, including flexibility in schema design, enhanced querying capabilities, and the ability to manage both structured and semi-structured data in a unified platform. The paper also highlights key techniques for leveraging JSON in SQL environments, such as using JSON functions, indexing strategies, and real-world applications where combining the two formats offers tangible benefits. The discussion concludes with insights into the future of SQL and JSON integration, emphasizing the role of hybrid data models in addressing the growing demands for scalability, flexibility, and performance in data management.
Keywords JSON, SQL, relational database, Arrays, injestion, RDBMS, storage, JSON_VALUE, JSON_ARRAY, OPENJSON
Field Lainnya
Published In Volume 3, Issue 4, July-August 2021
Published On 2021-07-07
DOI https://doi.org/10.36948/ijfmr.2021.v03i04.21629
Short DOI https://doi.org/g82h6n
View / Download PDF File

Share this



E-ISSN 2582-2160
CrossRef

CrossRef DOI is assigned to each research paper published in our journal.

IJFMR DOI prefix is
10.36948/ijfmr

Downloads
Research Paper Format Copyright Permission Form and Undertaking Form Cover Page Vol 7 Isu 2Cover Page Vol 7 Isu 1Cover Page Vol 6 Isu 6

All research papers published on this website are licensed under Creative Commons Attribution-ShareAlike 4.0 International License, and all rights belong to their respective authors/researchers.

CC-BY-SA Open Access

About IJFMR
Fees & Payment
Current Issue
Publication Archive 		Submit Research Paper
Track Submission Status
Publication Guidelines
Publication Ethics
Peer Review & Plagiarism 		Join as a Reviewer
Editors & Reviewers
Reviewer Referral Program
Get Reviewer Membership Certi. 		Website/Journal Policies
Usage Policy
Content Policies
Privacy Policy
Contact Us +91-9687-828-838 editor@ijfmr.com