{"id":"https://openalex.org/W2973476981","doi":"https://doi.org/10.1145/3345252.3345285","title":"A Basic Testbed for JSON Data Processing in SQL Data Servers","display_name":"A Basic Testbed for JSON Data Processing in SQL Data Servers","publication_year":2019,"publication_date":"2019-06-21","ids":{"openalex":"https://openalex.org/W2973476981","doi":"https://doi.org/10.1145/3345252.3345285","mag":"2973476981"},"language":"en","primary_location":{"id":"doi:10.1145/3345252.3345285","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3345252.3345285","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 20th International Conference on Computer Systems and Technologies","raw_type":"proceedings-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/A5017411739","display_name":"Ionu\u0163 Hrubaru","orcid":null},"institutions":[{"id":"https://openalex.org/I138164181","display_name":"Alexandru Ioan Cuza University","ror":"https://ror.org/022kvet57","country_code":"RO","type":"education","lineage":["https://openalex.org/I138164181"]}],"countries":["RO"],"is_corresponding":false,"raw_author_name":"Ionu\u0163 Hrubaru","raw_affiliation_strings":["Alexandru Ioan Cuza University of Ia\u015fi, Rom\u00e2nia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Alexandru Ioan Cuza University of Ia\u015fi, Rom\u00e2nia","institution_ids":["https://openalex.org/I138164181"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088185331","display_name":"George Talab\u0103","orcid":null},"institutions":[{"id":"https://openalex.org/I138164181","display_name":"Alexandru Ioan Cuza University","ror":"https://ror.org/022kvet57","country_code":"RO","type":"education","lineage":["https://openalex.org/I138164181"]}],"countries":["RO"],"is_corresponding":false,"raw_author_name":"George Talab\u0103","raw_affiliation_strings":["Alexandru Ioan Cuza University of Ia\u015fi, Rom\u00e2nia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Alexandru Ioan Cuza University of Ia\u015fi, Rom\u00e2nia","institution_ids":["https://openalex.org/I138164181"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5020885076","display_name":"Marin Fotache","orcid":"https://orcid.org/0000-0002-5873-159X"},"institutions":[{"id":"https://openalex.org/I138164181","display_name":"Alexandru Ioan Cuza University","ror":"https://ror.org/022kvet57","country_code":"RO","type":"education","lineage":["https://openalex.org/I138164181"]}],"countries":["RO"],"is_corresponding":false,"raw_author_name":"Marin Fotache","raw_affiliation_strings":["Alexandru Ioan Cuza University of Ia\u015fi, Rom\u00e2nia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Alexandru Ioan Cuza University of Ia\u015fi, Rom\u00e2nia","institution_ids":["https://openalex.org/I138164181"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.3719,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.65198698,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"278","last_page":"283"},"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.9993000030517578,"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.9993000030517578,"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/T11106","display_name":"Data Management and Algorithms","score":0.9965000152587891,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T11719","display_name":"Data Quality and Management","score":0.9882000088691711,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/json","display_name":"JSON","score":0.9812511205673218},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.808927059173584},{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.684855043888092},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6369855999946594},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6330924034118652},{"id":"https://openalex.org/keywords/server","display_name":"Server","score":0.5894654989242554},{"id":"https://openalex.org/keywords/testbed","display_name":"Testbed","score":0.5266579985618591},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.37097859382629395},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.23780471086502075},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.2236185371875763}],"concepts":[{"id":"https://openalex.org/C2780416260","wikidata":"https://www.wikidata.org/wiki/Q2063","display_name":"JSON","level":2,"score":0.9812511205673218},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.808927059173584},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.684855043888092},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6369855999946594},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6330924034118652},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.5894654989242554},{"id":"https://openalex.org/C31395832","wikidata":"https://www.wikidata.org/wiki/Q1318674","display_name":"Testbed","level":2,"score":0.5266579985618591},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.37097859382629395},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.23780471086502075},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.2236185371875763}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3345252.3345285","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3345252.3345285","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 20th International Conference on Computer Systems and Technologies","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W2052987550","https://openalex.org/W2163344730","https://openalex.org/W2438877200","https://openalex.org/W2574472735","https://openalex.org/W2582743722","https://openalex.org/W2619959750","https://openalex.org/W2752005949","https://openalex.org/W2970515629","https://openalex.org/W4254687493","https://openalex.org/W4399576166"],"related_works":["https://openalex.org/W3027072330","https://openalex.org/W3127890688","https://openalex.org/W2904616523","https://openalex.org/W4385834214","https://openalex.org/W2621972978","https://openalex.org/W3129344858","https://openalex.org/W3001928035","https://openalex.org/W2791661407","https://openalex.org/W4320802139","https://openalex.org/W4301431331"],"abstract_inverted_index":{"NoSQL":[0],"data":[1,74,105],"stores,":[2],"especially":[3],"the":[4,37,69,79,119],"document":[5],"database":[6,124],"systems":[7],"family":[8],"(i.e.":[9],"MongoDB,":[10],"CouchDB,":[11],"Couchbase)":[12],"implemented":[13],"a":[14,22,47],"long-awaited":[15],"feature":[16],"for":[17,25,58],"many":[18],"software":[19],"application":[20],"developers:":[21],"flexible":[23],"schema":[24,84],"storing":[26,59],"and":[27,36,60,90,108],"processing":[28],"data.":[29,100],"The":[30],"idea":[31],"of":[32,40,51,71,102,121],"schemalessness":[33],"seemed":[34],"reasonable":[35],"classic":[38],"trouble":[39],"impedance":[41],"mismatch":[42],"finally":[43],"might":[44],"have":[45],"had":[46],"solution.":[48],"Main":[49],"producers":[50],"SQL/relational":[52],"servers":[53],"reacted":[54],"by":[55],"providing":[56],"support":[57],"querying":[61],"JSON":[62,73,88,99],"attributes":[63],"within":[64],"tables.":[65],"This":[66],"paper":[67],"approaches":[68],"problem":[70],"comparing":[72],"query":[75],"performance":[76,120],"based":[77],"on":[78],"well-established":[80],"TPC-H":[81,93],"benchmark.":[82],"Normalized":[83],"was":[85,110],"converted":[86],"into":[87],"format,":[89],"all":[91],"22":[92],"queries":[94],"were":[95],"translated":[96],"to":[97,117],"process":[98],"Performance":[101],"two":[103],"popular":[104],"servers,":[106],"Oracle":[107],"PostgreSQL,":[109],"compared.":[111],"Resulted":[112],"testbed":[113],"can":[114],"be":[115],"used":[116],"assess":[118],"any":[122],"relational/SQL":[123],"engines":[125],"that":[126],"supports":[127],"JSON.":[128]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}