{"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":{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/3345252.3345285","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-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"],"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"],"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"],"affiliations":[{"raw_affiliation_string":"Alexandru Ioan Cuza University of Ia\u015fi, Rom\u00e2nia","institution_ids":["https://openalex.org/I138164181"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.396,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.590114,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":77,"max":79},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9993,"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.9993,"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.9965,"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.9882,"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.9812511},{"id":"https://openalex.org/keywords/nosql","display_name":"NoSQL","score":0.68485504},{"id":"https://openalex.org/keywords/testbed","display_name":"Testbed","score":0.526658}],"concepts":[{"id":"https://openalex.org/C2780416260","wikidata":"https://www.wikidata.org/wiki/Q2063","display_name":"JSON","level":2,"score":0.9812511},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.80892706},{"id":"https://openalex.org/C2779599972","wikidata":"https://www.wikidata.org/wiki/Q82231","display_name":"NoSQL","level":3,"score":0.68485504},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6369856},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6330924},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.5894655},{"id":"https://openalex.org/C31395832","wikidata":"https://www.wikidata.org/wiki/Q1318674","display_name":"Testbed","level":2,"score":0.526658},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3709786},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.23780471},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.22361854}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/3345252.3345285","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"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/W4385834214","https://openalex.org/W4320802139","https://openalex.org/W4301431331","https://openalex.org/W3129344858","https://openalex.org/W3127890688","https://openalex.org/W3027072330","https://openalex.org/W3001928035","https://openalex.org/W2904616523","https://openalex.org/W2791661407","https://openalex.org/W2621972978"],"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]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2973476981","counts_by_year":[{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":1}],"updated_date":"2024-12-12T03:11:35.777284","created_date":"2019-09-26"}