Extracting information from JSON database as simple as extracting in SQL using JSONiq

Abstract

JSON is a prevalent broadly useful information encoding group, utilized in numerous databases and web administrations. It is simple for a programmer to read and write as worked in a relational database. Like XML, JSON is also a semi-structured database in nature. Extracting information from semi-structured database required special query evaluation and processing engine. Using XQuery static information from XML database can access and retrieve easily through FLWOR construct. To extract structural and semi-structural information from JSON will be done through JSONiq query language and processor. The aim of this paper is finding the similarity between the relational query and JSONiq query and proving that simple queries like join, project, select, group, filter, and aggregate as done in SQL can also be done in JSONiq with JSON database.