{"id":"https://openalex.org/W2091001077","doi":"https://doi.org/10.1145/1559845.1559970","title":"PRIMA","display_name":"PRIMA","publication_year":2009,"publication_date":"2009-06-29","ids":{"openalex":"https://openalex.org/W2091001077","doi":"https://doi.org/10.1145/1559845.1559970","mag":"2091001077"},"language":"en","primary_location":{"id":"doi:10.1145/1559845.1559970","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1559845.1559970","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 ACM SIGMOD International Conference on Management of data","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/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":true,"raw_author_name":"Hyun J. Moon","raw_affiliation_strings":["UCLA, Los Angeles, CA, USA"],"affiliations":[{"raw_affiliation_string":"UCLA, Los Angeles, CA, USA","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, Milan, Italy","Politecnico di Milano, Milan (Italy)#TAB#"],"affiliations":[{"raw_affiliation_string":"Politecnico di Milano, Milan, Italy","institution_ids":["https://openalex.org/I93860229"]},{"raw_affiliation_string":"Politecnico di Milano, Milan (Italy)#TAB#","institution_ids":["https://openalex.org/I93860229"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5074777944","display_name":"Myungwon Ham","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":"Myungwon Ham","raw_affiliation_strings":["UCLA, Los Angeles, CA, USA"],"affiliations":[{"raw_affiliation_string":"UCLA, Los Angeles, CA, USA","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, Los Angeles, CA, USA"],"affiliations":[{"raw_affiliation_string":"UCLA, Los Angeles, CA, USA","institution_ids":["https://openalex.org/I2799798094"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5100882166"],"corresponding_institution_ids":["https://openalex.org/I2799798094"],"apc_list":null,"apc_paid":null,"fwci":1.3714,"has_fulltext":false,"cited_by_count":20,"citation_normalized_percentile":{"value":0.82368459,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"1019","last_page":"1022"},"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.9997000098228455,"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.9997000098228455,"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/T11181","display_name":"Advanced Data Storage Technologies","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/T11269","display_name":"Algorithms and Data Compression","score":0.9980999827384949,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8013752698898315},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.7654517889022827},{"id":"https://openalex.org/keywords/schema-evolution","display_name":"Schema evolution","score":0.7145947217941284},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.5861395597457886},{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.5288506746292114},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5163558721542358},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3313196301460266},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.10396090149879456}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8013752698898315},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.7654517889022827},{"id":"https://openalex.org/C2780660560","wikidata":"https://www.wikidata.org/wiki/Q3951893","display_name":"Schema evolution","level":4,"score":0.7145947217941284},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.5861395597457886},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.5288506746292114},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5163558721542358},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3313196301460266},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.10396090149879456}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1559845.1559970","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1559845.1559970","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W89541942","https://openalex.org/W1513236376","https://openalex.org/W1599833144","https://openalex.org/W1976308909","https://openalex.org/W2004281168","https://openalex.org/W2065530596","https://openalex.org/W2113056857","https://openalex.org/W2151793071","https://openalex.org/W2153737095","https://openalex.org/W2155801621","https://openalex.org/W7020729299"],"related_works":["https://openalex.org/W49842380","https://openalex.org/W2585807518","https://openalex.org/W2031254074","https://openalex.org/W2801431209","https://openalex.org/W1584107232","https://openalex.org/W2148067883","https://openalex.org/W2405805678","https://openalex.org/W2117404091","https://openalex.org/W2164326160","https://openalex.org/W2103472145"],"abstract_inverted_index":{"Schema":[0],"evolution":[1,164],"poses":[2],"serious":[3],"challenges":[4],"in":[5,44,107],"historical":[6,10,82],"data":[7,11,47,83],"management.":[8],"Traditionally,":[9],"have":[12],"been":[13],"archived":[14],"either":[15],"by":[16,28,36,79],"(i)":[17,80],"migrating":[18],"them":[19,38],"into":[20],"the":[21,40,46,69,74,85,102,109,112,115,121,125,132,137,144,152,162,187,197,205],"current":[22,103],"schema":[23,42,86,104,133,173],"version":[24,43,87],"that":[25],"is":[26],"well-understood":[27],"users":[29,58,97,138],"but":[30,56],"compromising":[31],"archival":[32,54],"quality,":[33,55],"or":[34],"(ii)":[35,95],"maintaining":[37],"under":[39,84,88],"original":[41],"which":[45,89,169],"was":[48],"originally":[49,92],"created,":[50,93],"leading":[51],"to":[52,59,114,139,201],"perfect":[53],"forcing":[57],"formulate":[60],"queries":[61,100,113,142],"against":[62],"complex":[63],"histories":[64,165],"of":[65,76,120,131,172,186,209],"evolving":[66,122],"schemas.":[67],"In":[68],"PRIMA":[70],"system,":[71],"we":[72],"achieve":[73],"best":[75],"both":[77,156],"approaches,":[78],"archiving":[81],"they":[90],"were":[91],"and":[94,135,161,167,177,190],"letting":[96],"express":[98],"temporal":[99,141],"using":[101],"version.":[105],"Thus,":[106],"PRIMA,":[108],"system":[110,126,153,188,193],"rewrites":[111],"(potentially":[116],"many)":[117],"pertinent":[118],"versions":[119,174],"schema.":[123],"Moreover,":[124],"o":[127],"ers":[128,182],"automatic":[129],"documentation":[130],"history,":[134],"allows":[136],"pose":[140],"over":[143],"metadata":[145],"history":[146],"itself.":[147],"The":[148,179],"proposed":[149],"demonstration":[150,180],"highlights":[151],"features":[154,189],"exploiting":[155],"a":[157,183,191],"synthetic-educational":[158],"running":[159],"example":[160],"real-life":[163],"(schemas":[166],"data),":[168],"include":[170],"hundreds":[171],"from":[175],"Wikipedia":[176],"Ensembl.":[178],"off":[181],"thorough":[184],"walk-through":[185],"hands-on":[192],"testing":[194],"phase,":[195],"where":[196],"audiences":[198],"are":[199],"invited":[200],"directly":[202],"interact":[203],"with":[204],"advanced":[206],"query":[207],"interface":[208],"PRIMA.":[210]},"counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":2},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-06-24T00:00:00"}