{"id":"https://openalex.org/W1974086744","doi":"https://doi.org/10.1145/1645953.1646104","title":"Generating SQL/XML query and update statements","display_name":"Generating SQL/XML query and update statements","publication_year":2009,"publication_date":"2009-11-02","ids":{"openalex":"https://openalex.org/W1974086744","doi":"https://doi.org/10.1145/1645953.1646104","mag":"1974086744"},"language":"en","primary_location":{"id":"doi:10.1145/1645953.1646104","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1645953.1646104","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 18th ACM conference on Information and knowledge management","raw_type":"proceedings-article"},"type":"conference-paper","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/A5048792890","display_name":"Matthias Nicola","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210148712","display_name":"Silicon Valley University","ror":"https://ror.org/04jk6hn97","country_code":"US","type":"education","lineage":["https://openalex.org/I4210148712"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Matthias Nicola","raw_affiliation_strings":["IBM Silicon Valley Lab, San Jose, CA, USA","IBM Silicon Valley Lab., San Jose, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Silicon Valley Lab, San Jose, CA, USA","institution_ids":["https://openalex.org/I4210148712"]},{"raw_affiliation_string":"IBM Silicon Valley Lab., San Jose, CA, USA","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5041901854","display_name":"Tim Kiefer","orcid":null},"institutions":[{"id":"https://openalex.org/I78650965","display_name":"Technische Universit\u00e4t Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Tim Kiefer","raw_affiliation_strings":["Technische Universit\u00e4t Dresden, Dresden, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t Dresden, Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1187","last_page":"1196"},"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9958000183105469,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9948999881744385,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8536449670791626},{"id":"https://openalex.org/keywords/xml-validation","display_name":"XML validation","score":0.7355409264564514},{"id":"https://openalex.org/keywords/streaming-xml","display_name":"Streaming XML","score":0.694867730140686},{"id":"https://openalex.org/keywords/xml-database","display_name":"XML database","score":0.6739121675491333},{"id":"https://openalex.org/keywords/xml-schema-editor","display_name":"XML Schema Editor","score":0.6551162600517273},{"id":"https://openalex.org/keywords/xml-encryption","display_name":"XML Encryption","score":0.604362428188324},{"id":"https://openalex.org/keywords/efficient-xml-interchange","display_name":"Efficient XML Interchange","score":0.5845766663551331},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.5124486088752747},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5050230622291565},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.46844059228897095},{"id":"https://openalex.org/keywords/document-structure-description","display_name":"Document Structure Description","score":0.4538707137107849},{"id":"https://openalex.org/keywords/xquery","display_name":"XQuery","score":0.44321465492248535},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.44015246629714966},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.29000788927078247},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.25762826204299927},{"id":"https://openalex.org/keywords/xml","display_name":"XML","score":0.20800873637199402},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.10771158337593079}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8536449670791626},{"id":"https://openalex.org/C55348073","wikidata":"https://www.wikidata.org/wiki/Q595926","display_name":"XML validation","level":3,"score":0.7355409264564514},{"id":"https://openalex.org/C44883583","wikidata":"https://www.wikidata.org/wiki/Q7622687","display_name":"Streaming XML","level":3,"score":0.694867730140686},{"id":"https://openalex.org/C183068750","wikidata":"https://www.wikidata.org/wiki/Q357393","display_name":"XML database","level":3,"score":0.6739121675491333},{"id":"https://openalex.org/C34716815","wikidata":"https://www.wikidata.org/wiki/Q8042322","display_name":"XML Schema Editor","level":3,"score":0.6551162600517273},{"id":"https://openalex.org/C173242113","wikidata":"https://www.wikidata.org/wiki/Q607488","display_name":"XML Encryption","level":4,"score":0.604362428188324},{"id":"https://openalex.org/C11508877","wikidata":"https://www.wikidata.org/wiki/Q1124477","display_name":"Efficient XML Interchange","level":3,"score":0.5845766663551331},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.5124486088752747},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5050230622291565},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.46844059228897095},{"id":"https://openalex.org/C68699486","wikidata":"https://www.wikidata.org/wiki/Q265904","display_name":"Document Structure Description","level":3,"score":0.4538707137107849},{"id":"https://openalex.org/C2780512708","wikidata":"https://www.wikidata.org/wiki/Q850661","display_name":"XQuery","level":4,"score":0.44321465492248535},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.44015246629714966},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.29000788927078247},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.25762826204299927},{"id":"https://openalex.org/C8797682","wikidata":"https://www.wikidata.org/wiki/Q2115","display_name":"XML","level":2,"score":0.20800873637199402},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.10771158337593079},{"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.1145/1645953.1646104","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1645953.1646104","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 18th ACM conference on Information and knowledge management","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.154.7292","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.154.7292","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.matthiasnicola.de/mediapool/31/315002/data/Generating_SQLXML_queries_and_updates_-_CIKM_2009.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W25756812","https://openalex.org/W1498304498","https://openalex.org/W1719639935","https://openalex.org/W1845564834","https://openalex.org/W1981097903","https://openalex.org/W2057866626","https://openalex.org/W2103268682","https://openalex.org/W2142086901","https://openalex.org/W2472547833","https://openalex.org/W6601055591","https://openalex.org/W6828392788"],"related_works":["https://openalex.org/W2038564770","https://openalex.org/W348005134","https://openalex.org/W2357844625","https://openalex.org/W1501142348","https://openalex.org/W2060533116","https://openalex.org/W2536894089","https://openalex.org/W2160808856","https://openalex.org/W1970085714","https://openalex.org/W98729882","https://openalex.org/W2047342127"],"abstract_inverted_index":{"The":[0,144,174],"XML":[1,43,83,96,122,169,186],"support":[2],"in":[3,166,171],"relational":[4,18,30,45,167,184],"databases":[5,19],"and":[6,20,31,40,44,65,140,185,201,205,210],"the":[7,61,67,78,82,93,172,193,199,212],"SQL/XML":[8,34,52,64,110,138,178],"language":[9],"are":[10],"still":[11],"relatively":[12],"new":[13],"as":[14,98,100,188],"compared":[15],"to":[16,37,90,108,121,136,190],"purely":[17],"traditional":[21],"SQL.":[22],"Today,":[23],"most":[24],"database":[25],"users":[26,36],"have":[27,208],"a":[28,134,148,151,177],"strong":[29],"SQL":[32,116,153],"background.":[33],"enables":[35],"perform":[38],"queries":[39,181],"updates":[41,183],"across":[42],"data,":[46],"but":[47,117],"many":[48],"struggle":[49],"with":[50],"writing":[51],"statements":[53,142],"or":[54,88,150,168,182],"XQuery":[55,68],"update":[56,141],"expressions.":[57],"One":[58],"reason":[59],"is":[60,76,146,176],"novelty":[62],"of":[63,66,81,162,217],"expressions":[69],"that":[70,77,155,180],"must":[71],"be":[72,86],"included.":[73],"Another":[74],"problem":[75],"tree":[79],"structure":[80],"data":[84,123,158,187],"may":[85,118],"unknown":[87],"difficult":[89],"understand":[91],"for":[92],"user.":[94],"Evolving":[95],"Schemas":[97],"well":[99],"hybrid":[101],"XML/relational":[102],"schemas":[103],"make":[104],"it":[105],"even":[106],"harder":[107],"write":[109],"statements.":[111],"Also,":[112],"legacy":[113],"applications":[114],"use":[115],"require":[119],"access":[120],"without":[124],"costly":[125],"code":[126],"changes.":[127],"Motivated":[128],"by":[129],"these":[130],"challenges,":[131],"we":[132],"developed":[133],"method":[135,214],"generate":[137],"query":[139],"automatically.":[143],"input":[145],"either":[147],"GUI":[149],"regular":[152],"statement":[154,179],"uses":[156],"logical":[157],"item":[159],"names":[160],"irrespective":[161],"their":[163],"actual":[164],"location":[165],"columns":[170],"database.":[173],"output":[175],"needed":[189],"carry":[191],"out":[192],"original":[194],"user":[195,200],"statement.":[196],"This":[197],"relieves":[198],"simplifies":[202],"schema":[203],"evolution":[204],"integration.":[206],"We":[207],"prototyped":[209],"tested":[211],"proposed":[213],"on":[215],"top":[216],"DB2":[218],"9.5.":[219]},"counts_by_year":[{"year":2015,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}