{"id":"https://openalex.org/W3122240221","doi":"https://doi.org/10.1145/3428757.3429103","title":"Non-native Techniques for Storing JSON Documents into Relational Tables","display_name":"Non-native Techniques for Storing JSON Documents into Relational Tables","publication_year":2020,"publication_date":"2020-11-30","ids":{"openalex":"https://openalex.org/W3122240221","doi":"https://doi.org/10.1145/3428757.3429103","mag":"3122240221"},"language":"en","primary_location":{"id":"doi:10.1145/3428757.3429103","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3428757.3429103","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 22nd International Conference on Information Integration and Web-based Applications & Services","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/A5002658946","display_name":"Du\u0161an Petkovi\u0107","orcid":"https://orcid.org/0000-0002-5188-2811"},"institutions":[{"id":"https://openalex.org/I4210142109","display_name":"Rosenheim Technical University of Applied Sciences","ror":"https://ror.org/03hbmgt12","country_code":"DE","type":"education","lineage":["https://openalex.org/I4210142109"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Du\u0161an Petkovi\u0107","raw_affiliation_strings":["Technical University of Applied Sciences, Rosenheim, Germany"],"affiliations":[{"raw_affiliation_string":"Technical University of Applied Sciences, Rosenheim, Germany","institution_ids":["https://openalex.org/I4210142109"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5002658946"],"corresponding_institution_ids":["https://openalex.org/I4210142109"],"apc_list":null,"apc_paid":null,"fwci":0.4625,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.6845312,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"16","last_page":"20"},"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.9998999834060669,"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.9998999834060669,"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.9979000091552734,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9858999848365784,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.9600511789321899},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8362748026847839},{"id":"https://openalex.org/keywords/adjacency-list","display_name":"Adjacency list","score":0.7589674592018127},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6236873865127563},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.5655002593994141},{"id":"https://openalex.org/keywords/xml","display_name":"XML","score":0.5207272171974182},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4461551010608673},{"id":"https://openalex.org/keywords/data-structure","display_name":"Data structure","score":0.4299353361129761},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3860208988189697},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3740803599357605},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.344274640083313},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.21698197722434998},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.15519943833351135},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1442621648311615}],"concepts":[{"id":"https://openalex.org/C2780416260","wikidata":"https://www.wikidata.org/wiki/Q2063","display_name":"JSON","level":2,"score":0.9600511789321899},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8362748026847839},{"id":"https://openalex.org/C110484373","wikidata":"https://www.wikidata.org/wiki/Q264398","display_name":"Adjacency list","level":2,"score":0.7589674592018127},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6236873865127563},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5655002593994141},{"id":"https://openalex.org/C8797682","wikidata":"https://www.wikidata.org/wiki/Q2115","display_name":"XML","level":2,"score":0.5207272171974182},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4461551010608673},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.4299353361129761},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3860208988189697},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3740803599357605},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.344274640083313},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.21698197722434998},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.15519943833351135},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1442621648311615}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3428757.3429103","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3428757.3429103","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 22nd International Conference on Information Integration and Web-based Applications & Services","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/W26976588","https://openalex.org/W1987748328","https://openalex.org/W2011716962","https://openalex.org/W2087060113","https://openalex.org/W2438877200","https://openalex.org/W2626449734","https://openalex.org/W2766131495","https://openalex.org/W2788226411","https://openalex.org/W2944053120","https://openalex.org/W6672147481"],"related_works":["https://openalex.org/W2577820972","https://openalex.org/W4323776979","https://openalex.org/W2380368790","https://openalex.org/W2559176074","https://openalex.org/W4281677580","https://openalex.org/W2367643486","https://openalex.org/W4281778737","https://openalex.org/W4210714665","https://openalex.org/W2391941239","https://openalex.org/W4281893301"],"abstract_inverted_index":{"The":[0,67,90],"natural":[1],"way,":[2],"how":[3],"JSON":[4,62],"documents":[5,63],"can":[6,32,54,97,121],"be":[7,33,55,98,122],"queried":[8],"and":[9,46,71],"modified":[10],"is":[11,76,92,110,141],"to":[12,60,69,78,100],"store":[13,61],"them":[14],"first":[15],"in":[16,64,104],"relational":[17,26,65,139],"environment.":[18],"In":[19,35],"such":[20,28],"a":[21,93,111],"case,":[22],"the":[23,47,108,114,132,135,145,148,156],"features":[24],"of":[25,84,113,116,137,144,147],"DBMSs":[27],"as":[29],"transaction":[30],"processing,":[31],"used.":[34],"this":[36],"paper":[37],"we":[38],"compare":[39,72],"two":[40,74,85],"different":[41,86],"mapping":[42],"techniques:":[43],"Adjacency":[44,153,161],"List":[45,162],"Single-Table":[48],"Data":[49],"Mapping":[50],"(STDM)":[51],"algorithm,":[52],"which":[53,96,120],"used,":[56],"among":[57],"other":[58],"techniques,":[59],"tables.":[66],"reason":[68],"choose":[70],"these":[73],"techniques":[75],"due":[77],"their":[79],"origin:":[80],"both":[81],"are":[82],"representatives":[83],"non-native":[87],"storing":[88],"techniques.":[89],"former":[91],"general":[94],"technique,":[95],"applied":[99],"any":[101],"data":[102],"presented":[103],"hierarchical":[105],"form,":[106],"while":[107],"latter":[109],"representative":[112],"family":[115],"XML-to-Relational":[117],"storage":[118],"algorithms,":[119],"used":[123],"for":[124],"JSON,":[125],"too.":[126],"Our":[127],"results":[128],"show":[129],"that":[130],"using":[131],"STDM":[133,157],"algorithm":[134,158],"size":[136,146],"resulting":[138],"table":[140,150],"approximately":[142],"70%":[143],"corresponding":[149],"generated":[151],"with":[152],"List.":[154],"Additionally,":[155],"significantly":[159],"outperforms":[160],"concerning":[163],"time.":[164]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}