{"id":"https://openalex.org/W4387005584","doi":"https://doi.org/10.1109/e-science58273.2023.10254872","title":"Database Evolution, by Scientists, for Scientists: A Case Study","display_name":"Database Evolution, by Scientists, for Scientists: A Case Study","publication_year":2023,"publication_date":"2023-09-25","ids":{"openalex":"https://openalex.org/W4387005584","doi":"https://doi.org/10.1109/e-science58273.2023.10254872"},"language":"en","primary_location":{"id":"doi:10.1109/e-science58273.2023.10254872","is_oa":false,"landing_page_url":"http://dx.doi.org/10.1109/e-science58273.2023.10254872","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2023 IEEE 19th International Conference on e-Science (e-Science)","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/A5089856608","display_name":"Robert Schuler","orcid":"https://orcid.org/0000-0002-8956-5707"},"institutions":[{"id":"https://openalex.org/I1174212","display_name":"University of Southern California","ror":"https://ror.org/03taz7m60","country_code":"US","type":"education","lineage":["https://openalex.org/I1174212"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Robert E. Schuler","raw_affiliation_strings":["Information Sciences Institute, University of Southern California,Marina del Rey,CA,USA","Information Sciences Institute, University of Southern California, Marina del Rey, CA, USA"],"affiliations":[{"raw_affiliation_string":"Information Sciences Institute, University of Southern California,Marina del Rey,CA,USA","institution_ids":["https://openalex.org/I1174212"]},{"raw_affiliation_string":"Information Sciences Institute, University of Southern California, Marina del Rey, CA, USA","institution_ids":["https://openalex.org/I1174212"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001845207","display_name":"Jitin Singla","orcid":"https://orcid.org/0000-0001-6225-0783"},"institutions":[{"id":"https://openalex.org/I154851008","display_name":"Indian Institute of Technology Roorkee","ror":"https://ror.org/00582g326","country_code":"IN","type":"education","lineage":["https://openalex.org/I154851008"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Jitin Singla","raw_affiliation_strings":["Indian Institute of Technology Roorkee,Department of Biosciences and Bioengineering,Roorkee,Uttarakhand,India","Department of Biosciences and Bioengineering, Indian Institute of Technology Roorkee, Roorkee, Uttarakhand, India"],"affiliations":[{"raw_affiliation_string":"Indian Institute of Technology Roorkee,Department of Biosciences and Bioengineering,Roorkee,Uttarakhand,India","institution_ids":["https://openalex.org/I154851008"]},{"raw_affiliation_string":"Department of Biosciences and Bioengineering, Indian Institute of Technology Roorkee, Roorkee, Uttarakhand, India","institution_ids":["https://openalex.org/I154851008"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042417574","display_name":"Brinda Vallat","orcid":"https://orcid.org/0000-0002-4076-8984"},"institutions":[{"id":"https://openalex.org/I102322142","display_name":"Rutgers, The State University of New Jersey","ror":"https://ror.org/05vt9qd57","country_code":"US","type":"education","lineage":["https://openalex.org/I102322142"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Brinda Vallat","raw_affiliation_strings":["Institute for Quantitative Biomedicine, Rutgers, The State University of New Jersey,Piscataway,NJ,USA","Institute for Quantitative Biomedicine, Rutgers, The State University of New Jersey, Piscataway, NJ, USA"],"affiliations":[{"raw_affiliation_string":"Institute for Quantitative Biomedicine, Rutgers, The State University of New Jersey,Piscataway,NJ,USA","institution_ids":["https://openalex.org/I102322142"]},{"raw_affiliation_string":"Institute for Quantitative Biomedicine, Rutgers, The State University of New Jersey, Piscataway, NJ, USA","institution_ids":["https://openalex.org/I102322142"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5089374061","display_name":"Kate L. White","orcid":"https://orcid.org/0000-0001-8894-9621"},"institutions":[{"id":"https://openalex.org/I1174212","display_name":"University of Southern California","ror":"https://ror.org/03taz7m60","country_code":"US","type":"education","lineage":["https://openalex.org/I1174212"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kate L. White","raw_affiliation_strings":["Bridge Institute, University of Southern California,Department of Chemistry,Los Angeles,CA,USA","Department of Chemistry, Bridge Institute, University of Southern California, Los Angeles, CA, USA"],"affiliations":[{"raw_affiliation_string":"Bridge Institute, University of Southern California,Department of Chemistry,Los Angeles,CA,USA","institution_ids":["https://openalex.org/I1174212"]},{"raw_affiliation_string":"Department of Chemistry, Bridge Institute, University of Southern California, Los Angeles, CA, USA","institution_ids":["https://openalex.org/I1174212"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5071896859","display_name":"Helen M. Berman","orcid":"https://orcid.org/0000-0002-3337-0660"},"institutions":[{"id":"https://openalex.org/I1174212","display_name":"University of Southern California","ror":"https://ror.org/03taz7m60","country_code":"US","type":"education","lineage":["https://openalex.org/I1174212"]},{"id":"https://openalex.org/I102322142","display_name":"Rutgers, The State University of New Jersey","ror":"https://ror.org/05vt9qd57","country_code":"US","type":"education","lineage":["https://openalex.org/I102322142"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Helen M. Berman","raw_affiliation_strings":["Rutgers, The State University of New Jersey,Department of Chemistry and Chemical Biology,Piscataway,NJ,USA","Department of Quantitative and Computational Biology, University of Southern California, Los Angeles, CA, USA","Department of Chemistry and Chemical Biology, Rutgers, The State University of New Jersey, Piscataway, NJ, USA"],"affiliations":[{"raw_affiliation_string":"Rutgers, The State University of New Jersey,Department of Chemistry and Chemical Biology,Piscataway,NJ,USA","institution_ids":["https://openalex.org/I102322142"]},{"raw_affiliation_string":"Department of Quantitative and Computational Biology, University of Southern California, Los Angeles, CA, USA","institution_ids":["https://openalex.org/I1174212"]},{"raw_affiliation_string":"Department of Chemistry and Chemical Biology, Rutgers, The State University of New Jersey, Piscataway, NJ, USA","institution_ids":["https://openalex.org/I102322142"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5085298473","display_name":"Carl Kesselman","orcid":"https://orcid.org/0000-0003-0917-1562"},"institutions":[{"id":"https://openalex.org/I1174212","display_name":"University of Southern California","ror":"https://ror.org/03taz7m60","country_code":"US","type":"education","lineage":["https://openalex.org/I1174212"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Carl Kesselman","raw_affiliation_strings":["Information Sciences Institute, University of Southern California,Marina del Rey,CA,USA","Information Sciences Institute, University of Southern California, Marina del Rey, CA, USA"],"affiliations":[{"raw_affiliation_string":"Information Sciences Institute, University of Southern California,Marina del Rey,CA,USA","institution_ids":["https://openalex.org/I1174212"]},{"raw_affiliation_string":"Information Sciences Institute, University of Southern California, Marina del Rey, CA, USA","institution_ids":["https://openalex.org/I1174212"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5089856608"],"corresponding_institution_ids":["https://openalex.org/I1174212"],"apc_list":null,"apc_paid":null,"fwci":0.2012,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.50641902,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":"3","issue":null,"first_page":"1","last_page":"10"},"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9975000023841858,"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"}},{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9944000244140625,"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/database-schema","display_name":"Database schema","score":0.7539780735969543},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7392091751098633},{"id":"https://openalex.org/keywords/schema-evolution","display_name":"Schema evolution","score":0.6951349973678589},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6805676817893982},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.6259763836860657},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.5465852618217468},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5449073314666748},{"id":"https://openalex.org/keywords/database-testing","display_name":"Database testing","score":0.5417038798332214},{"id":"https://openalex.org/keywords/database-theory","display_name":"Database theory","score":0.5308144092559814},{"id":"https://openalex.org/keywords/intelligent-database","display_name":"Intelligent database","score":0.5016698837280273},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4988715648651123},{"id":"https://openalex.org/keywords/data-administration","display_name":"Data administration","score":0.4795812666416168},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.4601500630378723},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.4559110403060913},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.4175613820552826},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2128690779209137}],"concepts":[{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.7539780735969543},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7392091751098633},{"id":"https://openalex.org/C2780660560","wikidata":"https://www.wikidata.org/wiki/Q3951893","display_name":"Schema evolution","level":4,"score":0.6951349973678589},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6805676817893982},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.6259763836860657},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.5465852618217468},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5449073314666748},{"id":"https://openalex.org/C78161392","wikidata":"https://www.wikidata.org/wiki/Q5227414","display_name":"Database testing","level":4,"score":0.5417038798332214},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.5308144092559814},{"id":"https://openalex.org/C162189203","wikidata":"https://www.wikidata.org/wiki/Q6044092","display_name":"Intelligent database","level":5,"score":0.5016698837280273},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4988715648651123},{"id":"https://openalex.org/C115842085","wikidata":"https://www.wikidata.org/wiki/Q4057846","display_name":"Data administration","level":4,"score":0.4795812666416168},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.4601500630378723},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.4559110403060913},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.4175613820552826},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2128690779209137},{"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/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":1,"locations":[{"id":"doi:10.1109/e-science58273.2023.10254872","is_oa":false,"landing_page_url":"http://dx.doi.org/10.1109/e-science58273.2023.10254872","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2023 IEEE 19th International Conference on e-Science (e-Science)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.6200000047683716}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":37,"referenced_works":["https://openalex.org/W89541942","https://openalex.org/W1514391626","https://openalex.org/W1562548864","https://openalex.org/W1969432763","https://openalex.org/W2001835324","https://openalex.org/W2022424113","https://openalex.org/W2035741146","https://openalex.org/W2048715559","https://openalex.org/W2064766209","https://openalex.org/W2088108067","https://openalex.org/W2113429499","https://openalex.org/W2117404091","https://openalex.org/W2149410920","https://openalex.org/W2155028447","https://openalex.org/W2166934660","https://openalex.org/W2270216281","https://openalex.org/W2280660020","https://openalex.org/W2302501749","https://openalex.org/W2435931733","https://openalex.org/W2585020226","https://openalex.org/W2591741271","https://openalex.org/W2770021808","https://openalex.org/W2789504060","https://openalex.org/W2901432962","https://openalex.org/W2945526390","https://openalex.org/W3046670147","https://openalex.org/W3097233586","https://openalex.org/W3112952736","https://openalex.org/W3163603576","https://openalex.org/W3174400887","https://openalex.org/W3193415673","https://openalex.org/W3202643159","https://openalex.org/W4211082830","https://openalex.org/W4245777329","https://openalex.org/W4298068285","https://openalex.org/W4312444110","https://openalex.org/W6603622961"],"related_works":["https://openalex.org/W2080297823","https://openalex.org/W1980366592","https://openalex.org/W2939083868","https://openalex.org/W4200232656","https://openalex.org/W2388281777","https://openalex.org/W2379497744","https://openalex.org/W2998585934","https://openalex.org/W1588786827","https://openalex.org/W4387005584","https://openalex.org/W1507769052"],"abstract_inverted_index":{"Database":[0],"management":[1,34],"systems":[2,35,66],"have":[3,103],"been":[4,72],"used":[5],"to":[6,24,58,85,109,122,128,137,141],"great":[7],"advantage":[8],"for":[9,32,54,61,67,153,156,175],"industry":[10],"usage":[11,83],"scenarios.":[12],"As":[13],"science":[14,55],"becomes":[15],"increasingly":[16],"dependent":[17],"on":[18,117,135],"carefully":[19],"organized":[20],"and":[21,26,63,106,111,130,133,158,186],"curated":[22],"data":[23],"inform":[25],"drive":[27],"new":[28,211],"discoveries,":[29],"the":[30,88,91,104,169,184,190,193],"need":[31,126],"database":[33,76,92,118,154,163,174],"has":[36,71],"grown":[37],"significantly.":[38],"The":[39],"long":[40],"standing":[41],"\u201c20":[42],"questions\u201d":[43],"method":[44],"was":[45],"advocated":[46],"in":[47,56,87,168],"early":[48],"studies":[49],"of":[50,82,90,162,171,183],"applying":[51],"relational":[52],"databases":[53,114,132],"order":[57],"elicit":[59],"requirements":[60],"designing":[62],"developing":[64],"information":[65,143,207],"scientific":[68,113],"data.":[69],"It":[70],"observed,":[73],"however,":[74],"that":[75,100,199],"designs":[77],"become":[78],"outdated":[79],"within":[80],"months":[81],"leading":[84],"degradation":[86],"quality":[89],"schema.":[93],"In":[94,145],"addition,":[95],"there":[96],"is":[97],"limited":[98],"evidence":[99],"scientists":[101,125,157],"themselves":[102],"tools":[105,127,140],"processes":[107,187],"necessary":[108],"develop":[110,142],"maintain":[112],"without":[115],"reliance":[116],"administrators.":[119],"Beyond":[120],"learning":[121],"query":[123],"databases,":[124],"create":[129],"evolve":[131,204],"guidance":[134],"how":[136],"apply":[138],"those":[139],"systems.":[144],"this":[146],"paper,":[147],"we":[148],"present":[149],"a":[150,159,166,172,180,200,205],"simplified":[151],"methodology":[152],"evolution":[155,164],"case":[160],"study":[161],"by":[165,189,210],"scientist":[167,191,201],"context":[170],"research":[173,212],"cell":[176],"modeling.":[177],"We":[178],"include":[179],"detailed":[181],"analysis":[182],"activities":[185],"employed":[188],"during":[192],"schema":[194],"evolution.":[195],"Our":[196],"results":[197],"show":[198],"can":[202],"successfully":[203],"complex":[206],"system":[208],"driven":[209],"requirements.":[213]},"counts_by_year":[{"year":2024,"cited_by_count":1}],"updated_date":"2025-12-21T01:58:51.020947","created_date":"2025-10-10T00:00:00"}