{"id":"https://openalex.org/W2153737095","doi":"https://doi.org/10.14778/1453856.1453952","title":"Managing and querying transaction-time databases under schema evolution","display_name":"Managing and querying transaction-time databases under schema evolution","publication_year":2008,"publication_date":"2008-08-01","ids":{"openalex":"https://openalex.org/W2153737095","doi":"https://doi.org/10.14778/1453856.1453952","mag":"2153737095"},"language":"en","primary_location":{"id":"doi:10.14778/1453856.1453952","is_oa":false,"landing_page_url":"https://doi.org/10.14778/1453856.1453952","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/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":"healthcare","lineage":["https://openalex.org/I2799798094"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hyun J. Moon","raw_affiliation_strings":["UCLA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UCLA","institution_ids":["https://openalex.org/I2799798094"]}]},{"author_position":"middle","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":false,"raw_author_name":"Carlo A. Curino","raw_affiliation_strings":["Politecnico di Milano"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Politecnico di Milano","institution_ids":["https://openalex.org/I93860229"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038619283","display_name":"Alin Deutsch","orcid":null},"institutions":[{"id":"https://openalex.org/I2800935791","display_name":"UC San Diego Health System","ror":"https://ror.org/01kbfgm16","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I2800935791"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alin Deutsch","raw_affiliation_strings":["UC San Diego"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UC San Diego","institution_ids":["https://openalex.org/I2800935791"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5065289152","display_name":"Chien-Yi Hou","orcid":null},"institutions":[{"id":"https://openalex.org/I2800935791","display_name":"UC San Diego Health System","ror":"https://ror.org/01kbfgm16","country_code":"US","type":"healthcare","lineage":["https://openalex.org/I2800935791"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Chien-Yi Hou","raw_affiliation_strings":["UC San Diego"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UC San Diego","institution_ids":["https://openalex.org/I2800935791"]}]},{"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":"healthcare","lineage":["https://openalex.org/I2799798094"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Carlo Zaniolo","raw_affiliation_strings":["UCLA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UCLA","institution_ids":["https://openalex.org/I2799798094"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":15.19,"has_fulltext":false,"cited_by_count":79,"citation_normalized_percentile":{"value":0.98860338,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"1","issue":"1","first_page":"882","last_page":"895"},"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9878000020980835,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9803000092506409,"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.8308165073394775},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.6896663904190063},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.666552722454071},{"id":"https://openalex.org/keywords/schema-migration","display_name":"Schema migration","score":0.6571717262268066},{"id":"https://openalex.org/keywords/information-schema","display_name":"Information schema","score":0.6327031254768372},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.63165283203125},{"id":"https://openalex.org/keywords/schema-evolution","display_name":"Schema evolution","score":0.6220425963401794},{"id":"https://openalex.org/keywords/document-structure-description","display_name":"Document Structure Description","score":0.6003316044807434},{"id":"https://openalex.org/keywords/xml-schema-editor","display_name":"XML Schema Editor","score":0.5864689350128174},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5621640682220459},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5456517338752747},{"id":"https://openalex.org/keywords/xquery","display_name":"XQuery","score":0.4639650583267212},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.4519405961036682},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.44979995489120483},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.41186583042144775},{"id":"https://openalex.org/keywords/xml","display_name":"XML","score":0.3575176000595093},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3571428656578064},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.26525643467903137},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.22458946704864502},{"id":"https://openalex.org/keywords/gender-schema-theory","display_name":"Gender schema theory","score":0.09310898184776306}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8308165073394775},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.6896663904190063},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.666552722454071},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.6571717262268066},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.6327031254768372},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.63165283203125},{"id":"https://openalex.org/C2780660560","wikidata":"https://www.wikidata.org/wiki/Q3951893","display_name":"Schema evolution","level":4,"score":0.6220425963401794},{"id":"https://openalex.org/C68699486","wikidata":"https://www.wikidata.org/wiki/Q265904","display_name":"Document Structure Description","level":3,"score":0.6003316044807434},{"id":"https://openalex.org/C34716815","wikidata":"https://www.wikidata.org/wiki/Q8042322","display_name":"XML Schema Editor","level":3,"score":0.5864689350128174},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5621640682220459},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5456517338752747},{"id":"https://openalex.org/C2780512708","wikidata":"https://www.wikidata.org/wiki/Q850661","display_name":"XQuery","level":4,"score":0.4639650583267212},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.4519405961036682},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.44979995489120483},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.41186583042144775},{"id":"https://openalex.org/C8797682","wikidata":"https://www.wikidata.org/wiki/Q2115","display_name":"XML","level":2,"score":0.3575176000595093},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3571428656578064},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.26525643467903137},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.22458946704864502},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"score":0.09310898184776306},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"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":4,"locations":[{"id":"doi:10.14778/1453856.1453952","is_oa":false,"landing_page_url":"https://doi.org/10.14778/1453856.1453952","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"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.141.6398","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.141.6398","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/vldb08-prima.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.420.19","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.420.19","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://db.ucsd.edu/dblab-intranet/pubsFileFolder/316.pdf","raw_type":"text"},{"id":"pmh:oai:re.public.polimi.it:11311/545190","is_oa":false,"landing_page_url":"http://hdl.handle.net/11311/545190","pdf_url":null,"source":{"id":"https://openalex.org/S4306400312","display_name":"Virtual Community of Pathological Anatomy (University of Castilla La Mancha)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I79189158","host_organization_name":"University of Castilla-La Mancha","host_organization_lineage":["https://openalex.org/I79189158"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"info:eu-repo/semantics/conferenceObject"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Decent work and economic growth","score":0.550000011920929,"id":"https://metadata.un.org/sdg/8"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W89541942","https://openalex.org/W1513236376","https://openalex.org/W1524214323","https://openalex.org/W1538827254","https://openalex.org/W1556253886","https://openalex.org/W1558832481","https://openalex.org/W1599833144","https://openalex.org/W1976308909","https://openalex.org/W1988668397","https://openalex.org/W1992752048","https://openalex.org/W2004281168","https://openalex.org/W2034664050","https://openalex.org/W2042893791","https://openalex.org/W2065530596","https://openalex.org/W2067308467","https://openalex.org/W2079588361","https://openalex.org/W2087257109","https://openalex.org/W2103849501","https://openalex.org/W2113056857","https://openalex.org/W2115055535","https://openalex.org/W2119984902","https://openalex.org/W2125822162","https://openalex.org/W2151793071","https://openalex.org/W2153471319","https://openalex.org/W2155419928","https://openalex.org/W2155801621","https://openalex.org/W2163004878","https://openalex.org/W4206031975","https://openalex.org/W6631409916","https://openalex.org/W6633513001","https://openalex.org/W6677498057","https://openalex.org/W6683247490","https://openalex.org/W7020729299"],"related_works":["https://openalex.org/W166845585","https://openalex.org/W2103472145","https://openalex.org/W1513459549","https://openalex.org/W2105315220","https://openalex.org/W2153512431","https://openalex.org/W1591654213","https://openalex.org/W2137027610","https://openalex.org/W2801323518","https://openalex.org/W1512552654","https://openalex.org/W2561775104"],"abstract_inverted_index":{"The":[0,41,91,123,203],"old":[1],"problem":[2,32],"of":[3,7,38,50,59,95,132,143,158,205],"managing":[4],"the":[5,48,57,60,104,110,115,127,140,144,177,194,197,201,206,219],"history":[6,49],"database":[8,53,65],"information":[9,21],"is":[10,43,97,101,148,164],"now":[11],"made":[12],"more":[13,120],"urgent":[14],"and":[15,62,129,162,183,215],"complex":[16],"by":[17,33,168,200],"fast":[18],"spreading":[19],"web":[20],"systems,":[22],"such":[23,134],"as":[24],"Wikipedia.":[25],"Our":[26],"PRIMA":[27,167],"system":[28,124],"addresses":[29],"this":[30],"difficult":[31],"introducing":[34,170],"two":[35],"key":[36,93],"pieces":[37],"new":[39],"technology.":[40],"first":[42],"a":[44,51,68],"method":[45],"for":[46,139,151],"publishing":[47],"relational":[52],"in":[54,166],"XML,":[55],"whereby":[56],"evolution":[58,100,223],"schema":[61,86,99,112,121,160,181,222],"its":[63],"underlying":[64],"are":[66],"given":[67,85],"unified":[69],"representation.":[70],"This":[71,146],"temporally":[72],"grouped":[73],"representation":[74],"makes":[75],"it":[76,163],"easy":[77],"to":[78,103,175,191],"formulate":[79],"sophisticated":[80],"historical":[81,152],"queries":[82,108,135,153,195],"on":[83],"any":[84],"version":[87],"using":[88,196],"standard":[89],"XQuery.":[90],"second":[92],"piece":[94],"technology":[96],"that":[98],"transparent":[102],"user:":[105],"she":[106],"writes":[107],"against":[109,211],"current":[111],"while":[113],"retrieving":[114],"data":[116,214,217],"from":[117,218],"one":[118],"or":[119],"versions.":[122],"then":[125],"performs":[126],"labor-intensive":[128],"error-prone":[130],"task":[131],"rewriting":[133],"into":[136],"equivalent":[137],"ones":[138],"appropriate":[141],"versions":[142,161,182],"schema.":[145],"feature":[147],"particularly":[149],"important":[150],"spanning":[154],"over":[155],"potentially":[156],"hundreds":[157],"different":[159],"realized":[165],"(i)":[169],"Schema":[171],"Modification":[172],"Operators":[173],"(SMOs)":[174],"represent":[176],"mappings":[178],"between":[179],"successive":[180],"(ii)":[184],"an":[185],"XML":[186],"integrity":[187],"constraint":[188],"language":[189],"(XIC)":[190],"efficiently":[192],"rewrite":[193],"constraints":[198],"established":[199],"SMOs.":[202],"scalability":[204],"approach":[207],"has":[208],"been":[209],"tested":[210],"both":[212],"synthetic":[213],"real-world":[216],"Wikipedia":[220],"DB":[221],"history.":[224]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":8},{"year":2019,"cited_by_count":3},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":7},{"year":2012,"cited_by_count":9}],"updated_date":"2026-08-02T14:50:37.381335","created_date":"2025-10-10T00:00:00"}