{"id":"https://openalex.org/W2117404091","doi":"https://doi.org/10.1145/1656437.1656444","title":"Automating database schema evolution in information system upgrades","display_name":"Automating database schema evolution in information system upgrades","publication_year":2009,"publication_date":"2009-10-25","ids":{"openalex":"https://openalex.org/W2117404091","doi":"https://doi.org/10.1145/1656437.1656444","mag":"2117404091"},"language":"en","primary_location":{"id":"doi:10.1145/1656437.1656444","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1656437.1656444","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2nd International Workshop on Hot Topics in Software Upgrades","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/A5010481434","display_name":"Carlo Curino","orcid":"https://orcid.org/0000-0003-3712-7358"},"institutions":[{"id":"https://openalex.org/I161318765","display_name":"University of California, Los Angeles","ror":"https://ror.org/046rm7j60","country_code":"US","type":"education","lineage":["https://openalex.org/I161318765"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Carlo Curino","raw_affiliation_strings":["University of California at Los Angeles","University of California at Los Angeles**"],"affiliations":[{"raw_affiliation_string":"University of California at Los Angeles","institution_ids":["https://openalex.org/I161318765"]},{"raw_affiliation_string":"University of California at Los Angeles**","institution_ids":["https://openalex.org/I161318765"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100882166","display_name":"Hyun Jin Moon","orcid":null},"institutions":[{"id":"https://openalex.org/I161318765","display_name":"University of California, Los Angeles","ror":"https://ror.org/046rm7j60","country_code":"US","type":"education","lineage":["https://openalex.org/I161318765"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hyun J. Moon","raw_affiliation_strings":["University of California at Los Angeles","University of California at Los Angeles**"],"affiliations":[{"raw_affiliation_string":"University of California at Los Angeles","institution_ids":["https://openalex.org/I161318765"]},{"raw_affiliation_string":"University of California at Los Angeles**","institution_ids":["https://openalex.org/I161318765"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5113467760","display_name":"Carlo Zaniolo","orcid":null},"institutions":[{"id":"https://openalex.org/I161318765","display_name":"University of California, Los Angeles","ror":"https://ror.org/046rm7j60","country_code":"US","type":"education","lineage":["https://openalex.org/I161318765"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Carlo Zaniolo","raw_affiliation_strings":["University of California at Los Angeles","University of California at Los Angeles**"],"affiliations":[{"raw_affiliation_string":"University of California at Los Angeles","institution_ids":["https://openalex.org/I161318765"]},{"raw_affiliation_string":"University of California at Los Angeles**","institution_ids":["https://openalex.org/I161318765"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5010481434"],"corresponding_institution_ids":["https://openalex.org/I161318765"],"apc_list":null,"apc_paid":null,"fwci":4.3506,"has_fulltext":false,"cited_by_count":23,"citation_normalized_percentile":{"value":0.94659486,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"5"},"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.9994000196456909,"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.9994000196456909,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9934999942779541,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.991599977016449,"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/schema-evolution","display_name":"Schema evolution","score":0.912307620048523},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8044520020484924},{"id":"https://openalex.org/keywords/schema-migration","display_name":"Schema migration","score":0.7827796936035156},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.7233501076698303},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.577095091342926},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.5344539880752563},{"id":"https://openalex.org/keywords/information-schema","display_name":"Information schema","score":0.5180994868278503},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.5100911259651184},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.4423708915710449},{"id":"https://openalex.org/keywords/testbed","display_name":"Testbed","score":0.43142884969711304},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4302240312099457},{"id":"https://openalex.org/keywords/usability","display_name":"Usability","score":0.428924024105072},{"id":"https://openalex.org/keywords/documentation","display_name":"Documentation","score":0.41387826204299927},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3760141134262085},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.35364967584609985},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2467372715473175},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.21946898102760315},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.21808448433876038},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.11062964797019958}],"concepts":[{"id":"https://openalex.org/C2780660560","wikidata":"https://www.wikidata.org/wiki/Q3951893","display_name":"Schema evolution","level":4,"score":0.912307620048523},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8044520020484924},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.7827796936035156},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.7233501076698303},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.577095091342926},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.5344539880752563},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.5180994868278503},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.5100911259651184},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.4423708915710449},{"id":"https://openalex.org/C31395832","wikidata":"https://www.wikidata.org/wiki/Q1318674","display_name":"Testbed","level":2,"score":0.43142884969711304},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4302240312099457},{"id":"https://openalex.org/C170130773","wikidata":"https://www.wikidata.org/wiki/Q216378","display_name":"Usability","level":2,"score":0.428924024105072},{"id":"https://openalex.org/C56666940","wikidata":"https://www.wikidata.org/wiki/Q788790","display_name":"Documentation","level":2,"score":0.41387826204299927},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3760141134262085},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.35364967584609985},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2467372715473175},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.21946898102760315},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.21808448433876038},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.11062964797019958},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"score":0.0},{"id":"https://openalex.org/C138496976","wikidata":"https://www.wikidata.org/wiki/Q175002","display_name":"Developmental psychology","level":1,"score":0.0},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1656437.1656444","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1656437.1656444","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2nd International Workshop on Hot Topics in Software Upgrades","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.158.3460","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.158.3460","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.ucla.edu/~zaniolo/papers/hotswup.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G3946280536","display_name":null,"funder_award_id":"IIS 0917333","funder_id":"https://openalex.org/F4320337389","funder_display_name":"Division of Information and Intelligent Systems"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320337389","display_name":"Division of Information and Intelligent Systems","ror":"https://ror.org/053a2cp42"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":37,"referenced_works":["https://openalex.org/W84440064","https://openalex.org/W89541942","https://openalex.org/W1493688518","https://openalex.org/W1500615737","https://openalex.org/W1507539036","https://openalex.org/W1513236376","https://openalex.org/W1556253886","https://openalex.org/W1599833144","https://openalex.org/W1800215808","https://openalex.org/W1859545522","https://openalex.org/W1976308909","https://openalex.org/W2001835324","https://openalex.org/W2004281168","https://openalex.org/W2020228538","https://openalex.org/W2042893791","https://openalex.org/W2057069578","https://openalex.org/W2065188484","https://openalex.org/W2065530596","https://openalex.org/W2067308467","https://openalex.org/W2091001077","https://openalex.org/W2107664716","https://openalex.org/W2124031328","https://openalex.org/W2125822162","https://openalex.org/W2128149591","https://openalex.org/W2140957972","https://openalex.org/W2143397294","https://openalex.org/W2148386493","https://openalex.org/W2151793071","https://openalex.org/W2153531297","https://openalex.org/W2153737095","https://openalex.org/W2163004878","https://openalex.org/W2172147512","https://openalex.org/W2997050146","https://openalex.org/W6603422750","https://openalex.org/W6629538277","https://openalex.org/W6638563781","https://openalex.org/W7020729299"],"related_works":["https://openalex.org/W166845585","https://openalex.org/W2153512431","https://openalex.org/W2103472145","https://openalex.org/W1513459549","https://openalex.org/W1483477772","https://openalex.org/W2105315220","https://openalex.org/W1512552654","https://openalex.org/W2148067883","https://openalex.org/W3205223094","https://openalex.org/W1591654213"],"abstract_inverted_index":{"The":[0,74,200],"complexity,":[1],"cost,":[2],"and":[3,25,55,82,88,97,113,138,158,171,184,193,236,268],"down-time":[4],"currently":[5],"created":[6],"by":[7,43,186],"the":[8,14,20,39,60,80,130,146,163,196,209,225],"database":[9,131,218,272],"schema":[10,63,110,136,165,204,275],"evolution":[11,111,205],"process":[12,90],"is":[13,94,252],"source":[15],"of":[16,22,62,109,117,148,176,198,228,254],"incessant":[17],"problems":[18,41],"in":[19,51,195,202],"life":[21],"information":[23,45,53,256],"systems":[24,46,54],"a":[26,106,115],"major":[27],"stumbling":[28],"block":[29],"that":[30,38,84,93,221,253],"prevent":[31],"graceful":[32],"upgrades.":[33],"Furthermore,":[34,179],"our":[35],"studies":[36],"shows":[37],"serious":[40],"encountered":[42],"traditional":[44],"are":[47],"now":[48],"further":[49],"exacerbated":[50],"web":[52],"cooperative":[56],"scientific":[57],"databases":[58],"where":[59,258],"frequency":[61],"changes":[64,150,223],"has":[65,71],"increased":[66],"while":[67],"tolerance":[68],"for":[69,212,241,271],"downtimes":[70],"nearly":[72],"disappeared.":[73],"PRISM":[75,142,180,259],"project":[76],"seeks":[77],"to":[78,122,143,160,265],"develop":[79],"methods":[81],"tools":[83],"turn":[85],"this":[86,101,128],"error-prone":[87],"time-consuming":[89],"into":[91],"one":[92],"controllable,":[95],"predictable":[96],"avoids":[98],"down-time.":[99],"Toward":[100],"goal,":[102],"we":[103,248],"have":[104,249],"assembled":[105],"large":[107],"testbed":[108],"histories,":[112],"developed":[114],"language":[116],"Schema":[118],"Modification":[119],"Operators":[120],"(SMO)":[121],"express":[123],"concisely":[124],"these":[125,149,231],"histories.":[126],"Using":[127],"language,":[129],"administrator":[132],"can":[133],"specify":[134],"new":[135,164],"changes,":[137],"then":[139],"rely":[140],"on":[141,151,162,190],"(i)":[144],"predict":[145],"effect":[147],"current":[152],"applications,":[153],"(ii)":[154],"translate":[155],"old":[156],"queries":[157,270],"updates":[159],"work":[161],"version,":[166],"(iii)":[167],"perform":[168],"data":[169],"migration,":[170],"(iv)":[172],"generate":[173],"full":[174],"documentation":[175],"intervened":[177],"changes.":[178],"achieves":[181],"good":[182],"usability":[183],"scalability":[185],"incorporating":[187],"recent":[188],"advances":[189],"mapping":[191,261],"composition":[192],"invertibility":[194],"implementation":[197],"(ii).":[199],"progress":[201],"automating":[203],"so":[206],"achieved":[207],"provides":[208],"enabling":[210],"technology":[211],"other":[213],"advances,":[214],"such":[215],"as":[216,224],"light-weight":[217],"design":[219],"methodologies":[220],"embrace":[222],"regular":[226],"state":[227],"software.":[229],"While":[230],"topics":[232],"remain":[233],"largely":[234],"unexplored,":[235],"thus":[237],"provide":[238],"rich":[239],"opportunities":[240],"future":[242],"research,":[243],"an":[244],"important":[245],"area":[246],"which":[247],"been":[250],"investigated":[251],"archival":[255],"systems,":[257],"query":[260],"techniques":[262],"were":[263],"used":[264],"support":[266],"flashback":[267],"historical":[269],"archives":[273],"under":[274],"evolution.":[276]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}