{"id":"https://openalex.org/W2558797943","doi":"https://doi.org/10.4018/jdm.2016070101","title":"Path Expressions in SQL","display_name":"Path Expressions in SQL","publication_year":2016,"publication_date":"2016-07-01","ids":{"openalex":"https://openalex.org/W2558797943","doi":"https://doi.org/10.4018/jdm.2016070101","mag":"2558797943"},"language":"en","primary_location":{"id":"doi:10.4018/jdm.2016070101","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdm.2016070101","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","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/A5011184968","display_name":"Marko Junkkari","orcid":"https://orcid.org/0009-0009-8741-3863"},"institutions":[{"id":"https://openalex.org/I166825849","display_name":"Tampere University","ror":"https://ror.org/033003e23","country_code":"FI","type":"education","lineage":["https://openalex.org/I166825849"]},{"id":"https://openalex.org/I4210133110","display_name":"Tampere University","ror":null,"country_code":"FI","type":null,"lineage":["https://openalex.org/I4210133110"]}],"countries":["FI"],"is_corresponding":true,"raw_author_name":"Marko Junkkari","raw_affiliation_strings":["School of Information Sciences, University of Tampere, Tampere, Finland"],"affiliations":[{"raw_affiliation_string":"School of Information Sciences, University of Tampere, Tampere, Finland","institution_ids":["https://openalex.org/I166825849","https://openalex.org/I4210133110"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5060391673","display_name":"Johanna Vainio","orcid":"https://orcid.org/0000-0002-7827-5982"},"institutions":[{"id":"https://openalex.org/I4210133110","display_name":"Tampere University","ror":null,"country_code":"FI","type":null,"lineage":["https://openalex.org/I4210133110"]},{"id":"https://openalex.org/I166825849","display_name":"Tampere University","ror":"https://ror.org/033003e23","country_code":"FI","type":"education","lineage":["https://openalex.org/I166825849"]}],"countries":["FI"],"is_corresponding":false,"raw_author_name":"Johanna Vainio","raw_affiliation_strings":["School of Information Sciences, University of Tampere, Tampere, Finland"],"affiliations":[{"raw_affiliation_string":"School of Information Sciences, University of Tampere, Tampere, Finland","institution_ids":["https://openalex.org/I166825849","https://openalex.org/I4210133110"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5016991161","display_name":"Kati Iltanen","orcid":"https://orcid.org/0000-0001-5645-0148"},"institutions":[{"id":"https://openalex.org/I4210133110","display_name":"Tampere University","ror":null,"country_code":"FI","type":null,"lineage":["https://openalex.org/I4210133110"]},{"id":"https://openalex.org/I166825849","display_name":"Tampere University","ror":"https://ror.org/033003e23","country_code":"FI","type":"education","lineage":["https://openalex.org/I166825849"]}],"countries":["FI"],"is_corresponding":false,"raw_author_name":"Kati Iltanen","raw_affiliation_strings":["School of Information Sciences, University of Tampere, Tampere, Finland"],"affiliations":[{"raw_affiliation_string":"School of Information Sciences, University of Tampere, Tampere, Finland","institution_ids":["https://openalex.org/I166825849","https://openalex.org/I4210133110"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5068305613","display_name":"Paavo Arvola","orcid":"https://orcid.org/0000-0001-7209-8033"},"institutions":[{"id":"https://openalex.org/I4210133110","display_name":"Tampere University","ror":null,"country_code":"FI","type":null,"lineage":["https://openalex.org/I4210133110"]},{"id":"https://openalex.org/I166825849","display_name":"Tampere University","ror":"https://ror.org/033003e23","country_code":"FI","type":"education","lineage":["https://openalex.org/I166825849"]}],"countries":["FI"],"is_corresponding":false,"raw_author_name":"Paavo Arvola","raw_affiliation_strings":["School of Information Sciences, University of Tampere, Tampere, Finland"],"affiliations":[{"raw_affiliation_string":"School of Information Sciences, University of Tampere, Tampere, Finland","institution_ids":["https://openalex.org/I166825849","https://openalex.org/I4210133110"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5031133743","display_name":"Heidi Kari","orcid":null},"institutions":[{"id":"https://openalex.org/I166825849","display_name":"Tampere University","ror":"https://ror.org/033003e23","country_code":"FI","type":"education","lineage":["https://openalex.org/I166825849"]},{"id":"https://openalex.org/I4210133110","display_name":"Tampere University","ror":null,"country_code":"FI","type":null,"lineage":["https://openalex.org/I4210133110"]}],"countries":["FI"],"is_corresponding":false,"raw_author_name":"Heidi Kari","raw_affiliation_strings":["School of Information Sciences, University of Tampere, Tampere, Finland"],"affiliations":[{"raw_affiliation_string":"School of Information Sciences, University of Tampere, Tampere, Finland","institution_ids":["https://openalex.org/I166825849","https://openalex.org/I4210133110"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5086854307","display_name":"Jaana Kek\u00e4l\u00e4inen","orcid":"https://orcid.org/0000-0002-4025-9522"},"institutions":[{"id":"https://openalex.org/I4210133110","display_name":"Tampere University","ror":null,"country_code":"FI","type":null,"lineage":["https://openalex.org/I4210133110"]},{"id":"https://openalex.org/I166825849","display_name":"Tampere University","ror":"https://ror.org/033003e23","country_code":"FI","type":"education","lineage":["https://openalex.org/I166825849"]}],"countries":["FI"],"is_corresponding":false,"raw_author_name":"Jaana Kek\u00e4l\u00e4inen","raw_affiliation_strings":["School of Information Sciences, University of Tampere, Tampere, Finland"],"affiliations":[{"raw_affiliation_string":"School of Information Sciences, University of Tampere, Tampere, Finland","institution_ids":["https://openalex.org/I166825849","https://openalex.org/I4210133110"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5011184968"],"corresponding_institution_ids":["https://openalex.org/I166825849","https://openalex.org/I4210133110"],"apc_list":null,"apc_paid":null,"fwci":0.5791,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.73261305,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"27","issue":"3","first_page":"1","last_page":"22"},"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.9998000264167786,"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.9998000264167786,"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.9955999851226807,"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/T12127","display_name":"Software System Performance and Reliability","score":0.991599977016449,"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/computer-science","display_name":"Computer science","score":0.8772252798080444},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7611837387084961},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.698243260383606},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.5958917140960693},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5762110948562622},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.5600778460502625},{"id":"https://openalex.org/keywords/path-expression","display_name":"Path expression","score":0.5136682391166687},{"id":"https://openalex.org/keywords/path","display_name":"Path (computing)","score":0.49999427795410156},{"id":"https://openalex.org/keywords/sql-injection","display_name":"SQL injection","score":0.48924684524536133},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4597397744655609},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.45189806818962097},{"id":"https://openalex.org/keywords/correctness","display_name":"Correctness","score":0.44943368434906006},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.43968015909194946},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.42897331714630127},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.42684367299079895},{"id":"https://openalex.org/keywords/autocommit","display_name":"Autocommit","score":0.41305607557296753},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3794556260108948},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.16848424077033997}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8772252798080444},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7611837387084961},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.698243260383606},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5958917140960693},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5762110948562622},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.5600778460502625},{"id":"https://openalex.org/C61114434","wikidata":"https://www.wikidata.org/wiki/Q7144649","display_name":"Path expression","level":3,"score":0.5136682391166687},{"id":"https://openalex.org/C2777735758","wikidata":"https://www.wikidata.org/wiki/Q817765","display_name":"Path (computing)","level":2,"score":0.49999427795410156},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.48924684524536133},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4597397744655609},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.45189806818962097},{"id":"https://openalex.org/C55439883","wikidata":"https://www.wikidata.org/wiki/Q360812","display_name":"Correctness","level":2,"score":0.44943368434906006},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.43968015909194946},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.42897331714630127},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.42684367299079895},{"id":"https://openalex.org/C33882796","wikidata":"https://www.wikidata.org/wiki/Q4826222","display_name":"Autocommit","level":5,"score":0.41305607557296753},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3794556260108948},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.16848424077033997},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/jdm.2016070101","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdm.2016070101","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdm000:v:27:y:2016:i:3:p:1-22","is_oa":false,"landing_page_url":"http://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/JDM.2016070101","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","score":0.5,"display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":35,"referenced_works":["https://openalex.org/W99131893","https://openalex.org/W319014924","https://openalex.org/W1497040040","https://openalex.org/W1519179082","https://openalex.org/W1537280715","https://openalex.org/W1560626952","https://openalex.org/W1568607665","https://openalex.org/W1587459293","https://openalex.org/W1608492534","https://openalex.org/W1795886231","https://openalex.org/W1964523235","https://openalex.org/W1968365094","https://openalex.org/W1980548249","https://openalex.org/W1980556028","https://openalex.org/W1991439756","https://openalex.org/W1992655841","https://openalex.org/W2012056301","https://openalex.org/W2014250801","https://openalex.org/W2022953871","https://openalex.org/W2023745308","https://openalex.org/W2044840147","https://openalex.org/W2050994110","https://openalex.org/W2054805201","https://openalex.org/W2072031888","https://openalex.org/W2077924815","https://openalex.org/W2085832100","https://openalex.org/W2090253867","https://openalex.org/W2093369250","https://openalex.org/W2111000784","https://openalex.org/W2136598571","https://openalex.org/W2138615052","https://openalex.org/W2150147167","https://openalex.org/W2161967143","https://openalex.org/W2751199251","https://openalex.org/W2988119170"],"related_works":["https://openalex.org/W151073879","https://openalex.org/W2384863017","https://openalex.org/W2785432546","https://openalex.org/W2379897365","https://openalex.org/W2322276287","https://openalex.org/W1890767558","https://openalex.org/W2803214644","https://openalex.org/W2791515211","https://openalex.org/W2359391484","https://openalex.org/W4238156210"],"abstract_inverted_index":{"This":[0],"article":[1],"focuses":[2],"on":[3],"testing":[4],"a":[5,18,102],"path-oriented":[6,24,50,124],"querying":[7,84],"approach":[8,25],"to":[9,21],"hierarchical":[10,85,107],"data":[11,74,86],"in":[12,38,49,57,87,109,122,131],"relational":[13,65,110],"databases.":[14,111],"The":[15],"authors":[16],"execute":[17],"user":[19,90],"study":[20],"compare":[22],"the":[23,58,68,89,113,116],"and":[26,35,62,75,127],"traditional":[27],"SQL":[28,76,100,125],"from":[29],"two":[30],"perspectives:":[31],"correctness":[32],"of":[33,45,60],"queries":[34,108,126],"time":[36,121],"spent":[37,118],"querying.":[39],"They":[40],"also":[41],"analyze":[42],"what":[43],"kinds":[44],"errors":[46,130],"are":[47,55,67],"typical":[48],"SQL.":[51],"Path-oriented":[52,99],"query":[53,132],"languages":[54],"popular":[56],"context":[59],"object-orientation":[61],"XML.":[63],"However,":[64],"databases":[66],"most":[69,78],"common":[70,79],"paradigm":[71],"for":[72,80,105],"storing":[73],"is":[77,101],"manipulating":[81],"data.":[82],"When":[83],"SQL,":[88],"must":[91],"specify":[92],"join":[93],"conditions":[94],"explicitly":[95],"between":[96],"hierarchy":[97],"levels.":[98],"new":[103],"alternative":[104],"expressing":[106],"In":[112],"authors'":[114],"study,":[115],"users":[117],"significantly":[119],"less":[120],"writing":[123],"made":[128],"fewer":[129],"formulation.":[133]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-12-08T00:00:00"}