After that, we show to what extent these features are supported in RDBMSs. Features, described in the standard, are separated in several groups and described using examples. In this paper, we discuss first XPath and XQuery Full Text specified in the W3C standard. XQuery Full Text search provides a narrower form of full-text queries, while the search process operates on parts of XML documents, such as elements and attributes. Therefore, the search process operates on documents, and returning results are again documents. Direct access of external JSON data should be supported, too.įull-text queries search information in documents using words and several special operators.

The support of modification of parts of a JSON document using the SQL UPDATE statement is necessary. Handling JSON documents as first-class objects in SQL would provide the potential for greater capability for users and for better performance. From our point of view, the following should be specified in one of the future proposals of SQL/JSON: JSON documents should be first-class objects in SQL (native storage). In this paper we discuss the JSON features specified in the proposal and show to what extent different relational database systems have integrated them.Īt the end of the paper we describe the main drawbacks of the proposal and the ways to solve them. For this reason, the SQL standardization committee published a proposal called SQL/JSON. Therefore, the support of storage and query access for JSON documents in the context of relational DBMSs is necessary. This access can be supported using JSON (Java Script Object Notation). Recently, a new era of application development is emerging, which is based upon the ease of access to modern compute resources, such as mobile devices.

Microsoft sql server 2016 full mega