JSON Documents Processing Using Situation-Oriented Databases
V.V. Mironov, Artem Gusarenko, Nafisa Islamovna Yusupova, Yuri Smetanin · Acta Polytechnica Hungarica · 2020
Situation-oriented databases provide processing of documents from heterogeneous data sources under the control of a hierarchical situational model.This article discusses the problem of processing database documents in JSON format, along with XML.Two implementation approaches are discussed: (1) on the fly JSON to XML document conversion and using Document Object Model for processing XML, and (2) loading the JSON document into an associative/indexed array followed by applying the template engine.The database interpreter works with external heterogeneous data extracted from files, databases, archives, web services, data is processed using virtual documents.Examples of processing JSON documents received from a web service are analyzed.Data from the San Francisco Open Data web server is used as the JSON test source.Query in Socrata Query Language used for JSON data extraction is presented.The implementation of approaches in the research situation-oriented database prototype based on Hypertext Preprocessor is considered.