{"id":"https://openalex.org/W2900930447","doi":"https://doi.org/10.1016/j.is.2018.10.002","title":"Metadata management for scientific databases","display_name":"Metadata management for scientific databases","publication_year":2018,"publication_date":"2018-11-15","ids":{"openalex":"https://openalex.org/W2900930447","doi":"https://doi.org/10.1016/j.is.2018.10.002","mag":"2900930447"},"language":"en","primary_location":{"id":"doi:10.1016/j.is.2018.10.002","doi":"https://doi.org/10.1016/j.is.2018.10.002","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.is.2018.10.002","pdf_url":"https://www.sciencedirect.com/science/article/pii/S0306437917306385/pdf","source":{"id":"https://openalex.org/S193006928","display_name":"Information Systems","issn_l":"0306-4379","issn":["0306-4379","1873-6076"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-b","cwts-core","dongbi-b","jufo-2","norway-2","poland-100","russia-white-list-1","vabb-shw"],"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Systems","raw_type":"journal-article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://www.sciencedirect.com/science/article/pii/S0306437917306385/pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5074094001","display_name":"Pietro Pinoli","orcid":"https://orcid.org/0000-0001-9786-2851","observed_orcids":["https://orcid.org/0000-0001-9786-2851"]},"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":"Pietro Pinoli","raw_affiliation_strings":["Politecnico di Milano, Italy"],"raw_orcid":"https://orcid.org/0000-0001-9786-2851","affiliations":[{"raw_affiliation_string":"Politecnico di Milano, Italy","institution_ids":["https://openalex.org/I93860229"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5048332811","display_name":"Stefano Ceri","orcid":"https://orcid.org/0000-0003-0671-2415","observed_orcids":["https://orcid.org/0000-0003-0671-2415"]},"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":"Stefano Ceri","raw_affiliation_strings":["Politecnico di Milano, Italy"],"raw_orcid":"https://orcid.org/0000-0003-0671-2415","affiliations":[{"raw_affiliation_string":"Politecnico di Milano, Italy","institution_ids":["https://openalex.org/I93860229"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038451647","display_name":"Davide Martinenghi","orcid":"https://orcid.org/0000-0002-2726-7683","observed_orcids":["https://orcid.org/0000-0002-2726-7683"]},"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":"Davide Martinenghi","raw_affiliation_strings":["Politecnico di Milano, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Politecnico di Milano, Italy","institution_ids":["https://openalex.org/I93860229"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5079380917","display_name":"Luca Nanni","orcid":"https://orcid.org/0000-0001-7021-2007","observed_orcids":["https://orcid.org/0000-0001-7021-2007"]},"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":"Luca Nanni","raw_affiliation_strings":["Politecnico di Milano, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Politecnico di Milano, Italy","institution_ids":["https://openalex.org/I93860229"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5074094001"],"corresponding_institution_ids":["https://openalex.org/I93860229"],"apc_list":{"value":3410,"currency":"USD","value_usd":3410},"apc_paid":{"value":3410,"currency":"USD","value_usd":3410},"fwci":3.3483,"has_fulltext":true,"cited_by_count":26,"citation_normalized_percentile":{"value":0.93327187,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":98},"biblio":{"volume":"81","issue":null,"first_page":"1","last_page":"20"},"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.9458000063896179,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9458000063896179,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.02239999920129776,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.006500000134110451,"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/metadata-management","display_name":"metadata management","score":0.8989999890327454},{"id":"https://openalex.org/keywords/scientific-databases","display_name":"scientific databases","score":0.972000002861023},{"id":"https://openalex.org/keywords/relational-query-languages","display_name":"relational query languages","score":0.6340000033378601},{"id":"https://openalex.org/keywords/provenance-data","display_name":"provenance metadata","score":0.8920000195503235},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.4339999854564667}],"concepts":[{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.9105105996131897},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8598778247833252},{"id":"https://openalex.org/C153048206","wikidata":"https://www.wikidata.org/wiki/Q3454922","display_name":"Metadata repository","level":3,"score":0.635738730430603},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6129601001739502},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5623968839645386},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5078936219215393},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4950255751609802},{"id":"https://openalex.org/C136976847","wikidata":"https://www.wikidata.org/wiki/Q6822297","display_name":"Meta Data Services","level":4,"score":0.47638458013534546},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.4313095510005951},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4188438653945923},{"id":"https://openalex.org/C65610166","wikidata":"https://www.wikidata.org/wiki/Q5227399","display_name":"Database catalog","level":4,"score":0.4152792692184448},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.4138144254684448},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.36714088916778564},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.15248149633407593},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.14004334807395935},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.13636940717697144},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0922313928604126}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1016/j.is.2018.10.002","doi":"https://doi.org/10.1016/j.is.2018.10.002","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.is.2018.10.002","pdf_url":"https://www.sciencedirect.com/science/article/pii/S0306437917306385/pdf","source":{"id":"https://openalex.org/S193006928","display_name":"Information Systems","issn_l":"0306-4379","issn":["0306-4379","1873-6076"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-b","cwts-core","dongbi-b","jufo-2","norway-2","poland-100","russia-white-list-1","vabb-shw"],"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Systems","raw_type":"journal-article"},{"id":"pmh:oai:re.public.polimi.it:11311/1077880","doi":null,"is_oa":true,"landing_page_url":"http://hdl.handle.net/11311/1077880","pdf_url":"https://re.public.polimi.it/bitstream/11311/1077880/1/1-s2.0-S0306437917306385-main.pdf","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,"listed_in":[],"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":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"doi:10.1016/j.is.2018.10.002","doi":"https://doi.org/10.1016/j.is.2018.10.002","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.is.2018.10.002","pdf_url":"https://www.sciencedirect.com/science/article/pii/S0306437917306385/pdf","source":{"id":"https://openalex.org/S193006928","display_name":"Information Systems","issn_l":"0306-4379","issn":["0306-4379","1873-6076"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["ccf-b","cwts-core","dongbi-b","jufo-2","norway-2","poland-100","russia-white-list-1","vabb-shw"],"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Systems","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[{"id":"https://openalex.org/G3796392728","display_name":"Data-Driven Genomic Computing","funder_award_id":"693174","funder_id":"https://openalex.org/F4320338335","funder_display_name":"H2020 European Research Council"}],"funders":[{"id":"https://openalex.org/F4320338335","display_name":"H2020 European Research Council","ror":"https://ror.org/0472cxd90"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2900930447.pdf","grobid_xml":"https://content.openalex.org/works/W2900930447.grobid-xml"},"referenced_works_count":40,"referenced_works":["https://openalex.org/W31634058","https://openalex.org/W1524668325","https://openalex.org/W1548849615","https://openalex.org/W1552694902","https://openalex.org/W1592479693","https://openalex.org/W1720961861","https://openalex.org/W1973548654","https://openalex.org/W1979514837","https://openalex.org/W1988545508","https://openalex.org/W1991385538","https://openalex.org/W1994326726","https://openalex.org/W2006358514","https://openalex.org/W2043220030","https://openalex.org/W2054811895","https://openalex.org/W2058995344","https://openalex.org/W2060849841","https://openalex.org/W2092324613","https://openalex.org/W2098935637","https://openalex.org/W2106120981","https://openalex.org/W2107763879","https://openalex.org/W2115570304","https://openalex.org/W2119325664","https://openalex.org/W2120783706","https://openalex.org/W2133511388","https://openalex.org/W2142680014","https://openalex.org/W2142996534","https://openalex.org/W2157370893","https://openalex.org/W2158485828","https://openalex.org/W2167530798","https://openalex.org/W2167541073","https://openalex.org/W2216189112","https://openalex.org/W2259938310","https://openalex.org/W2260225750","https://openalex.org/W2293299776","https://openalex.org/W2507333165","https://openalex.org/W2611245576","https://openalex.org/W6600291067","https://openalex.org/W6600972834","https://openalex.org/W6603230187","https://openalex.org/W6725334738"],"related_works":["https://openalex.org/W2754806663","https://openalex.org/W2037824148","https://openalex.org/W92508482","https://openalex.org/W7098302898","https://openalex.org/W2084075868","https://openalex.org/W7097111446","https://openalex.org/W2972640006","https://openalex.org/W3216498749","https://openalex.org/W3098197594","https://openalex.org/W1556652972"],"abstract_inverted_index":{"Most":[0],"scientific":[1,51,248],"databases":[2,246],"consist":[3],"of":[4,84,116,151,212,220,222,234,247],"datasets":[5],"(or":[6,13,19],"sources)":[7],"which":[8],"in":[9,50,185],"turn":[10],"include":[11],"samples":[12,24,163,190,201],"files)":[14],"with":[15,27,73,194],"an":[16,134],"identical":[17],"structure":[18],"schema).":[20],"In":[21,78,99,170],"many":[22,218],"cases,":[23],"are":[25,47,191],"associated":[26,72,193],"rich":[28],"metadata,":[29],"describing":[30],"the":[31,39,55,69,124,143,149,157,167,174,188,198,232,235],"process":[32],"that":[33,86,139,164],"leads":[34],"to":[35,113,166,181,225,254,271],"building":[36,182],"them":[37],"(e.g.:":[38],"experimental":[40],"conditions":[41],"used":[42,49],"during":[43,96],"sample":[44],"generation).":[45],"Metadata":[46],"typically":[48],"computations":[52],"just":[53],"for":[54,90,153,245,260],"initial":[56],"data":[57],"selection;":[58],"at":[59],"most,":[60],"metadata":[61,152,172,195,213,241,268],"about":[62,196,204],"query":[63,92,97,144,183,205,243,274],"results":[64,75,93],"is":[65,252],"recovered":[66],"after":[67],"executing":[68],"query,":[70],"and":[71,131,179,229],"its":[74],"by":[76,118,147],"post-processing.":[77],"this":[79,100,186],"way,":[80,187],"a":[81,105,209,240,255],"large":[82],"body":[83],"information":[85],"could":[87],"be":[88],"relevant":[89],"interpreting":[91],"goes":[94],"unused":[95],"processing.":[98],"paper,":[101],"we":[102,132,230],"present":[103,217],"ScQL,":[104,171,223],"new":[106,210],"algebraic":[107],"relational":[108],"language,":[109],"whose":[110],"operations":[111],"apply":[112],"objects":[114],"consisting":[115],"data\u2013metadatapairs,":[117],"preserving":[119],"such":[120],"one-to-one":[121],"correspondence":[122],"throughout":[123],"computation.":[125],"We":[126,216],"formally":[127],"define":[128],"each":[129],"operation":[130],"describe":[133],"optimization,":[135],"called":[136],"meta-first":[137,236,265],",":[138],"may":[140],"significantly":[141],"reduce":[142],"processing":[145],"overhead":[146],"anticipating":[148],"use":[150,221],"selectively":[154],"loading":[155],"into":[156],"execution":[158],"environment":[159],"only":[160],"those":[161],"input":[162,200],"contribute":[165,180],"result":[168],"samples.":[169,249],"have":[173],"same":[175],"relevance":[176],"as":[177,270],"data,":[178],"results;":[184],"resulting":[189],"systematically":[192],"either":[197],"specific":[199],"involved":[202],"or":[203],"processing,":[206],"thereby":[207],"yielding":[208],"form":[211],"provenance":[214],".":[215],"examples":[219],"relative":[224],"several":[226],"application":[227],"domains,":[228],"demonstrate":[231],"effectiveness":[233],"optimization.":[237,261],"\u2022":[238,250,262],"ScQL:":[239],"aware":[242],"language":[244],"ScQL":[251],"compiled":[253],"lower":[256],"level":[257],"representation":[258],"suitable":[259],"The":[263],"novel":[264],"optimization":[266],"exploits":[267],"so":[269],"speed":[272],"up":[273],"evaluation.":[275]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":5},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":6}],"updated_date":"2026-11-07T11:25:07.637180","created_date":"2018-11-29T00:00:00"}