{"id":"https://openalex.org/W2004281168","doi":"https://doi.org/10.14778/1453856.1453939","title":"Graceful database schema evolution","display_name":"Graceful database schema evolution","publication_year":2008,"publication_date":"2008-08-01","ids":{"openalex":"https://openalex.org/W2004281168","doi":"https://doi.org/10.14778/1453856.1453939","mag":"2004281168"},"language":"en","primary_location":{"id":"doi:10.14778/1453856.1453939","is_oa":false,"landing_page_url":"https://doi.org/10.14778/1453856.1453939","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","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/A5010481434","display_name":"Carlo Curino","orcid":"https://orcid.org/0000-0003-3712-7358"},"institutions":[{"id":"https://openalex.org/I93860229","display_name":"Politecnico di Milano","ror":"https://ror.org/01nffqt88","country_code":"IT","type":"education","lineage":["https://openalex.org/I93860229"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"Carlo A. Curino","raw_affiliation_strings":["Politecnico di Milano","Politecnico di Milano, Milan, Italy"],"affiliations":[{"raw_affiliation_string":"Politecnico di Milano","institution_ids":["https://openalex.org/I93860229"]},{"raw_affiliation_string":"Politecnico di Milano, Milan, Italy","institution_ids":["https://openalex.org/I93860229"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100882166","display_name":"Hyun Jin Moon","orcid":null},"institutions":[{"id":"https://openalex.org/I2799798094","display_name":"UCLA Health","ror":"https://ror.org/01d88se56","country_code":"US","type":"funder","lineage":["https://openalex.org/I2799798094"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hyun J. Moon","raw_affiliation_strings":["UCLA","UCLA ,"],"affiliations":[{"raw_affiliation_string":"UCLA","institution_ids":["https://openalex.org/I2799798094"]},{"raw_affiliation_string":"UCLA ,","institution_ids":["https://openalex.org/I2799798094"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5113467760","display_name":"Carlo Zaniolo","orcid":null},"institutions":[{"id":"https://openalex.org/I2799798094","display_name":"UCLA Health","ror":"https://ror.org/01d88se56","country_code":"US","type":"funder","lineage":["https://openalex.org/I2799798094"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Carlo Zaniolo","raw_affiliation_strings":["UCLA","UCLA ,"],"affiliations":[{"raw_affiliation_string":"UCLA","institution_ids":["https://openalex.org/I2799798094"]},{"raw_affiliation_string":"UCLA ,","institution_ids":["https://openalex.org/I2799798094"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5010481434"],"corresponding_institution_ids":["https://openalex.org/I93860229"],"apc_list":null,"apc_paid":null,"fwci":20.9664,"has_fulltext":false,"cited_by_count":178,"citation_normalized_percentile":{"value":0.9948527,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":100},"biblio":{"volume":"1","issue":"1","first_page":"761","last_page":"772"},"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.9962000250816345,"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.9962000250816345,"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/T11719","display_name":"Data Quality and Management","score":0.9932000041007996,"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"}},{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.991100013256073,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"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/computer-science","display_name":"Computer science","score":0.7941011786460876},{"id":"https://openalex.org/keywords/schema-evolution","display_name":"Schema evolution","score":0.744637668132782},{"id":"https://openalex.org/keywords/schema-migration","display_name":"Schema migration","score":0.7307753562927246},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.7195241451263428},{"id":"https://openalex.org/keywords/information-schema","display_name":"Information schema","score":0.7064238786697388},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6213838458061218},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.5566471815109253},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.5084551572799683},{"id":"https://openalex.org/keywords/document-structure-description","display_name":"Document Structure Description","score":0.4903419017791748},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.4835624396800995},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.4806315004825592},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4794396460056305},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4292179346084595},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.24712923169136047},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.1893938183784485},{"id":"https://openalex.org/keywords/xml","display_name":"XML","score":0.16912612318992615}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7941011786460876},{"id":"https://openalex.org/C2780660560","wikidata":"https://www.wikidata.org/wiki/Q3951893","display_name":"Schema evolution","level":4,"score":0.744637668132782},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.7307753562927246},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.7195241451263428},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.7064238786697388},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6213838458061218},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.5566471815109253},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.5084551572799683},{"id":"https://openalex.org/C68699486","wikidata":"https://www.wikidata.org/wiki/Q265904","display_name":"Document Structure Description","level":3,"score":0.4903419017791748},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.4835624396800995},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.4806315004825592},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4794396460056305},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4292179346084595},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.24712923169136047},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.1893938183784485},{"id":"https://openalex.org/C8797682","wikidata":"https://www.wikidata.org/wiki/Q2115","display_name":"XML","level":2,"score":0.16912612318992615},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0},{"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}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/1453856.1453939","is_oa":false,"landing_page_url":"https://doi.org/10.14778/1453856.1453939","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4399999976158142,"display_name":"Reduced inequalities","id":"https://metadata.un.org/sdg/10"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":31,"referenced_works":["https://openalex.org/W89541942","https://openalex.org/W175746151","https://openalex.org/W1500615737","https://openalex.org/W1513236376","https://openalex.org/W1556253886","https://openalex.org/W1560604137","https://openalex.org/W1599833144","https://openalex.org/W1800215808","https://openalex.org/W1859545522","https://openalex.org/W1993268751","https://openalex.org/W2001835324","https://openalex.org/W2020228538","https://openalex.org/W2042893791","https://openalex.org/W2065188484","https://openalex.org/W2067308467","https://openalex.org/W2095395853","https://openalex.org/W2107664716","https://openalex.org/W2115055535","https://openalex.org/W2124031328","https://openalex.org/W2125822162","https://openalex.org/W2128149591","https://openalex.org/W2140957972","https://openalex.org/W2148386493","https://openalex.org/W2153531297","https://openalex.org/W2153737095","https://openalex.org/W2155419928","https://openalex.org/W2163004878","https://openalex.org/W2172147512","https://openalex.org/W2489748212","https://openalex.org/W4235498869","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W166845585","https://openalex.org/W2103472145","https://openalex.org/W1513459549","https://openalex.org/W2105315220","https://openalex.org/W2137027610","https://openalex.org/W2153512431","https://openalex.org/W1591654213","https://openalex.org/W1512552654","https://openalex.org/W2801323518","https://openalex.org/W2148067883"],"abstract_inverted_index":{"Supporting":[0],"graceful":[1],"schema":[2,38,52,87,131,157,209],"evolution":[3,53],"represents":[4],"an":[5,55,212],"unsolved":[6],"problem":[7],"for":[8,44,215],"traditional":[9],"information":[10,18],"systems":[11],"that":[12,135,199],"is":[13],"further":[14],"exacerbated":[15],"in":[16,27],"web":[17],"systems,":[19],"such":[20,144],"as":[21,170],"Wikipedia":[22,205],"and":[23,57,68,73,80,92,100,163,179,194,203,206,219],"public":[24],"scientific":[25],"databases:":[26],"these":[28,184],"projects":[29],"based":[30],"on":[31,96,154,191],"multiparty":[32],"cooperation":[33],"the":[34,61,66,82,85,97,103,137,141,155],"frequency":[35],"of":[36,50,84,123,143,149,167],"database":[37,176],"changes":[39,169],"has":[40,46],"increased":[41],"while":[42],"tolerance":[43],"downtimes":[45],"nearly":[47],"disappeared.":[48],"As":[49],"today,":[51],"remains":[54],"error-prone":[56],"time-consuming":[58],"undertaking,":[59],"because":[60],"DB":[62],"Administrator":[63],"(DBA)":[64],"lacks":[65],"methods":[67],"tools":[69,134,218],"needed":[70,171],"to":[71,94,127,139,152,172,222],"manage":[72],"automate":[74],"this":[75,115],"endeavor":[76],"by":[77,118,186],"(i)":[78,120],"predicting":[79],"evaluating":[81],"effects":[83,142],"proposed":[86],"changes,":[88,132,145],"(ii)":[89,133],"rewriting":[90],"queries":[91,151],"applications":[93],"operate":[95],"new":[98,156],"schema,":[99],"(iii)":[101,146],"migrating":[102],"database.":[104],"Our":[105],"PRISM":[106,182,217],"system":[107],"takes":[108],"a":[109,121,197],"big":[110],"first":[111],"step":[112],"toward":[113],"addressing":[114],"pressing":[116],"need":[117],"providing:":[119],"language":[122],"Schema":[124],"Modification":[125],"Operators":[126],"express":[128],"concisely":[129],"complex":[130],"allow":[136],"DBA":[138],"evaluate":[140],"optimized":[147],"translation":[148],"old":[150],"work":[153],"version,":[158],"(iv)":[159],"automatic":[160],"data":[161,174],"migration,":[162],"(v)":[164],"full":[165],"documentation":[166],"intervened":[168],"support":[173,223],"provenance,":[175],"flash":[177],"back,":[178],"historical":[180],"queries.":[181,225],"solves":[183],"problems":[185],"integrating":[187],"recent":[188],"theoretical":[189],"advances":[190],"mapping":[192],"composition":[193],"invertibility,":[195],"into":[196],"design":[198],"also":[200],"achieves":[201],"usability":[202],"scalability.":[204],"its":[207],"170+":[208],"versions":[210],"provided":[211],"invaluable":[213],"testbed":[214],"validating":[216],"their":[220],"ability":[221],"legacy":[224]},"counts_by_year":[{"year":2025,"cited_by_count":5},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":6},{"year":2020,"cited_by_count":13},{"year":2019,"cited_by_count":6},{"year":2018,"cited_by_count":6},{"year":2017,"cited_by_count":9},{"year":2016,"cited_by_count":10},{"year":2015,"cited_by_count":11},{"year":2014,"cited_by_count":10},{"year":2013,"cited_by_count":18},{"year":2012,"cited_by_count":18}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}
