{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,12,31]],"date-time":"2025-12-31T04:25:36Z","timestamp":1767155136307,"version":"3.37.3"},"reference-count":15,"publisher":"Springer Science and Business Media LLC","issue":"3","license":[{"start":{"date-parts":[[2017,10,24]],"date-time":"2017-10-24T00:00:00Z","timestamp":1508803200000},"content-version":"unspecified","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Datenbank Spektrum"],"published-print":{"date-parts":[[2017,11]]},"DOI":"10.1007\/s13222-017-0267-4","type":"journal-article","created":{"date-parts":[[2017,10,24]],"date-time":"2017-10-24T07:23:05Z","timestamp":1508829785000},"page":"277-287","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":12,"title":["SQL\/JSON Standard: Properties and Deficiencies"],"prefix":"10.1007","volume":"17","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-5188-2811","authenticated-orcid":false,"given":"Du\u0161an","family":"Petkovi\u0107","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2017,10,24]]},"reference":[{"key":"267_CR1","volume-title":"Avro","author":"Avro","year":"2017","unstructured":"Avro (2017) Avro. \n                        http:\/\/avro.apache.org\/\n                        \n                    . Accessed 25 Aug 2017"},{"key":"267_CR2","unstructured":"Bestgen, R. \u2013 Using DB2 for i with XML and JSON, schd.ws\/hosted_files\/commons17\/6d\/26AD"},{"key":"267_CR3","volume-title":"BSON","author":"creative comments","year":"2017","unstructured":"BSON. \n                        http:\/\/bsonspec.org\/\n                        \n                    . Accessed 25 Aug 2017"},{"key":"267_CR4","volume-title":"Enabling JSON document stores in relational systems","author":"C Chasseur","year":"2013","unstructured":"Chasseur C, Li Y, Patel J (2013) Enabling JSON document stores in relational systems. Sixteenth International Workshop on the Web and Databases, New York, 23.6.2013."},{"key":"267_CR5","first-page":"1247","volume-title":"JSON data management supporting schema-less development in RDBMS","author":"CH Liu","year":"2014","unstructured":"Liu CH, Hammerschmidt B, McMahon D (2014) JSON data management supporting schema-less development in RDBMS. Proceedings of the 2014 International Conference on Management of Data, Snowbird, 22.06.2014-27.06.2014, pp 1247\u20131258"},{"key":"267_CR6","volume-title":"Closing the functional and performance gap between SQL and noSQL","author":"CH Liu","year":"2016","unstructured":"Liu CH, Hammerschmidt B, McMahon D, Li Y, Chang HJ (2016) Closing the functional and performance gap between SQL and noSQL. Proceedings of the 2016 International Conference on Management of Data, San Fransisco, 26.06.2016-01.07.2016."},{"key":"267_CR7","volume-title":"JSON in oracle database","author":"Oracle Help Center","year":"2017","unstructured":"Oracle Help Center (2017) JSON in oracle database. \n                        http:\/\/docs.oracle.com\/database\/121\/ADXDB\/json.htm#ADXDB6246\n                        \n                    . Accessed 25 Aug 2017"},{"key":"267_CR8","volume-title":"SQL server 2016, A Beginner\u2019s Guide","author":"D Petkovi\u0107","year":"2016","unstructured":"Petkovi\u0107 D (2016) SQL server 2016, A Beginner\u2019s Guide. McGraw-Hill, New York"},{"issue":"5","key":"267_CR9","first-page":"14","volume":"168","author":"D Petkovi\u0107","year":"2017","unstructured":"Petkovi\u0107 D (2017) JSON integration in relational database systems. Int J Comput Appl 168(5):14\u201319","journal-title":"Int J Comput Appl"},{"key":"267_CR10","volume-title":"PostgreSQL 9.4, JSON types","author":"PostgreSQL","year":"2017","unstructured":"PostgreSQL (2017) PostgreSQL 9.4, JSON types. \n                        www.postgresql.org\/docs\/9.4\/static\/datatype-json.html\n                        \n                    . Accessed 25 Aug 2017"},{"key":"267_CR11","volume-title":"PostgreSQL 9.4, JSON functions","author":"PostgreSQL","year":"2017","unstructured":"PostgreSQL (2017) PostgreSQL 9.4, JSON functions. \n                        www.postgresql.org\/docs\/9.4\/static\/functions-json.html\n                        \n                    . Accessed 25 Aug 2017"},{"key":"267_CR12","volume-title":"SQL server: JSON data","author":"Microsoft","year":"2017","unstructured":"Microsoft (2017) SQL server: JSON data. \n                        https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/json\/json-data-sql-server\n                        \n                    . Accessed 25 Aug 2017"},{"key":"267_CR13","volume-title":"Sinew: a new SQL system for multi-structured data","author":"D Tahara","year":"2014","unstructured":"Tahara D (2014) Sinew: a new SQL system for multi-structured data. Proceedings of the 2014 International Conference on Management of Data, Snowbird, 22.06.2014-27.06.2014."},{"key":"267_CR14","volume-title":"ANSI SQL\/JSON: part 1","author":"F Zemke","year":"2014","unstructured":"Zemke F, Hammerschmidt B, Kulkarni K, Liu Z, McMahon D, Melton J, Michels J, \u00d6zcan F, Pirahesh H (2014) ANSI SQL\/JSON: part 1. \n                        https:\/\/www.wiscorp.com\/pub\/DM32.2-2014-00024R1_JSON-SQL-Proposal-1.pdf\n                        \n                    . Accessed 25 Aug 2017"},{"key":"267_CR15","volume-title":"ANSI SQL\/JSON: part 2\u00a0: querying JSON","author":"F Zemke","year":"2014","unstructured":"Zemke F, Hammerschmidt B, Kulkarni K, Liu Z, McMahon D, Melton J, Michels J, \u00d6zcan F, Pirahesh H (2014) ANSI SQL\/JSON: part 2\u00a0: querying JSON. \n                        www.wiscorp.com\/pub\/DM32.2-2014-00025r1-sql-json-part-2.pdf\n                        \n                    . Accessed 27 Aug 2017"}],"container-title":["Datenbank-Spektrum"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/article\/10.1007\/s13222-017-0267-4\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s13222-017-0267-4.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s13222-017-0267-4.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2017,10,27]],"date-time":"2017-10-27T04:51:15Z","timestamp":1509079875000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/s13222-017-0267-4"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2017,10,24]]},"references-count":15,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2017,11]]}},"alternative-id":["267"],"URL":"https:\/\/doi.org\/10.1007\/s13222-017-0267-4","relation":{},"ISSN":["1618-2162","1610-1995"],"issn-type":[{"type":"print","value":"1618-2162"},{"type":"electronic","value":"1610-1995"}],"subject":[],"published":{"date-parts":[[2017,10,24]]}}}