{"id":"https://openalex.org/W3086463497","doi":"https://doi.org/10.14778/3415478.3415534","title":"Native JSON datatype support","display_name":"Native JSON datatype support","publication_year":2020,"publication_date":"2020-08-01","ids":{"openalex":"https://openalex.org/W3086463497","doi":"https://doi.org/10.14778/3415478.3415534","mag":"3086463497"},"language":"en","primary_location":{"id":"doi:10.14778/3415478.3415534","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3415478.3415534","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5111489764","display_name":"Zhen Hua Liu","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zhen Hua Liu","raw_affiliation_strings":["Oracle Corporation"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041506788","display_name":"Beda Christoph Hammerschmidt","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Beda Hammerschmidt","raw_affiliation_strings":["Oracle Corporation"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5059410788","display_name":"Doug McMahon","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Doug McMahon","raw_affiliation_strings":["Oracle Corporation"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5009861573","display_name":"Hui J. Chang","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hui Chang","raw_affiliation_strings":["Oracle Corporation"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057666375","display_name":"Ying L\u00fc","orcid":"https://orcid.org/0000-0002-7698-8962"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ying Lu","raw_affiliation_strings":["Oracle Corporation"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5050309679","display_name":"Josh Spiegel","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Josh Spiegel","raw_affiliation_strings":["Oracle Corporation"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078787350","display_name":"Alfonso Colunga Sosa","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alfonso Colunga Sosa","raw_affiliation_strings":["Oracle Corporation"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073732775","display_name":"Srikrishnan Suresh","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Srikrishnan Suresh","raw_affiliation_strings":["Oracle Corporation"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5062253981","display_name":"Geeta Arora","orcid":"https://orcid.org/0000-0002-3786-545X"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Geeta Arora","raw_affiliation_strings":["Oracle Corporation"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5054790105","display_name":"Vikas Arora","orcid":"https://orcid.org/0000-0002-7410-7009"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Vikas Arora","raw_affiliation_strings":["Oracle Corporation"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle Corporation","institution_ids":["https://openalex.org/I1342911587"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I1342911587"],"apc_list":null,"apc_paid":null,"fwci":1.5455,"has_fulltext":false,"cited_by_count":16,"citation_normalized_percentile":{"value":0.84405903,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"13","issue":"12","first_page":"3059","last_page":"3071"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9988999962806702,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9988999962806702,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9929999709129333,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9919999837875366,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/json","display_name":"JSON","score":0.9916008114814758},{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.7812310457229614},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7666425704956055},{"id":"https://openalex.org/keywords/oracle","display_name":"Oracle","score":0.6146551370620728},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5689769983291626},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.43612197041511536},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.41866210103034973},{"id":"https://openalex.org/keywords/ajax","display_name":"Ajax","score":0.41335737705230713},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3232889175415039},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.32307738065719604},{"id":"https://openalex.org/keywords/web-application","display_name":"Web application","score":0.29482847452163696},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2018900215625763},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.16170266270637512}],"concepts":[{"id":"https://openalex.org/C2780416260","wikidata":"https://www.wikidata.org/wiki/Q2063","display_name":"JSON","level":2,"score":0.9916008114814758},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.7812310457229614},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7666425704956055},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.6146551370620728},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5689769983291626},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.43612197041511536},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.41866210103034973},{"id":"https://openalex.org/C504723692","wikidata":"https://www.wikidata.org/wiki/Q134471","display_name":"Ajax","level":3,"score":0.41335737705230713},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3232889175415039},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.32307738065719604},{"id":"https://openalex.org/C118643609","wikidata":"https://www.wikidata.org/wiki/Q189210","display_name":"Web application","level":2,"score":0.29482847452163696},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2018900215625763},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.16170266270637512}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3415478.3415534","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3415478.3415534","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Life in Land","id":"https://metadata.un.org/sdg/15","score":0.4099999964237213}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W1509841269","https://openalex.org/W1568607665","https://openalex.org/W1987748328","https://openalex.org/W2011716962","https://openalex.org/W2035090900","https://openalex.org/W2074935284","https://openalex.org/W2438877200","https://openalex.org/W2547306460","https://openalex.org/W2619959750","https://openalex.org/W2753780811"],"related_works":["https://openalex.org/W2354762837","https://openalex.org/W2353950779","https://openalex.org/W2385380436","https://openalex.org/W63009710","https://openalex.org/W2053247067","https://openalex.org/W2370017075","https://openalex.org/W3027072330","https://openalex.org/W2922339024","https://openalex.org/W121857219","https://openalex.org/W3120589159"],"abstract_inverted_index":{"Both":[0],"RDBMS":[1],"and":[2,14,49,63,86,109],"NoSQL":[3,87],"database":[4],"vendors":[5,19],"have":[6],"added":[7],"varying":[8],"degrees":[9],"of":[10],"support":[11],"for":[12,82],"storing":[13],"processing":[15],"JSON":[16,21,29,61,99,113],"data.":[17],"Some":[18],"store":[20],"directly":[22],"as":[23,43],"text":[24],"while":[25],"others":[26],"add":[27],"new":[28,59],"type":[30,47],"systems":[31,48],"backed":[32],"by":[33],"binary":[34],"encoding":[35],"formats.":[36],"The":[37],"latter":[38],"option":[39],"is":[40,66,102],"increasingly":[41],"popular":[42],"it":[44,65],"enables":[45],"richer":[46],"efficient":[50],"query":[51],"processing.":[52],"In":[53],"this":[54],"paper,":[55],"we":[56],"present":[57],"our":[58,94],"native":[60],"datatype":[62],"how":[64,93],"fully":[67],"integrated":[68],"with":[69],"the":[70],"Oracle":[71,76,97],"Database":[72,77],"ecosystem":[73],"to":[74,104],"transform":[75],"into":[78],"a":[79],"mature":[80],"platform":[81],"serving":[83],"both":[84,107],"SQL":[85],"style":[88],"access":[89],"paradigms.":[90],"We":[91],"show":[92],"uniquely":[95],"designed":[96],"Binary":[98],"format":[100],"(OSON)":[101],"able":[103],"speed":[105],"up":[106],"OLAP":[108],"OLTP":[110],"workloads":[111],"over":[112],"documents.":[114]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":4}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}