{"id":"https://openalex.org/W3096946058","doi":"https://doi.org/10.1016/j.cageo.2020.104641","title":"TubeDB: An on-demand processing database system for climate station data","display_name":"TubeDB: An on-demand processing database system for climate station data","publication_year":2020,"publication_date":"2020-10-27","ids":{"openalex":"https://openalex.org/W3096946058","doi":"https://doi.org/10.1016/j.cageo.2020.104641","mag":"3096946058"},"language":"en","primary_location":{"id":"doi:10.1016/j.cageo.2020.104641","doi":"https://doi.org/10.1016/j.cageo.2020.104641","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.cageo.2020.104641","pdf_url":"https://www.sciencedirect.com/science/article/pii/S009830042030618X/pdf","source":{"id":"https://openalex.org/S61699894","display_name":"Computers & Geosciences","issn_l":"0098-3004","issn":["0098-3004","1873-7803"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","cwts-core","dongbi-b","jufo-1","norway-1","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","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computers & Geosciences","raw_type":"journal-article"},"volume":null,"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://www.sciencedirect.com/science/article/pii/S009830042030618X/pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5025613818","display_name":"Stephan W\u00f6llauer","orcid":"https://orcid.org/0000-0002-3623-8294","observed_orcids":["https://orcid.org/0000-0002-3623-8294"]},"institutions":[{"id":"https://openalex.org/I161103922","display_name":"Philipps University of Marburg","ror":"https://ror.org/01rdrb571","country_code":"DE","type":"education","lineage":["https://openalex.org/I161103922"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Stephan W\u00f6llauer","raw_affiliation_strings":["Philipps-University Marburg, Environmental Informatics, Faculty of Geography, Deutschhausstrasse 12, 35032, Marburg, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Philipps-University Marburg, Environmental Informatics, Faculty of Geography, Deutschhausstrasse 12, 35032, Marburg, Germany","institution_ids":["https://openalex.org/I161103922"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5046750467","display_name":"Dirk Zeuss","orcid":"https://orcid.org/0000-0001-6457-2866","observed_orcids":["https://orcid.org/0000-0001-6457-2866"]},"institutions":[{"id":"https://openalex.org/I161103922","display_name":"Philipps University of Marburg","ror":"https://ror.org/01rdrb571","country_code":"DE","type":"education","lineage":["https://openalex.org/I161103922"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Dirk Zeuss","raw_affiliation_strings":["Philipps-University Marburg, Environmental Informatics, Faculty of Geography, Deutschhausstrasse 12, 35032, Marburg, Germany"],"raw_orcid":"https://orcid.org/0000-0001-6457-2866","affiliations":[{"raw_affiliation_string":"Philipps-University Marburg, Environmental Informatics, Faculty of Geography, Deutschhausstrasse 12, 35032, Marburg, Germany","institution_ids":["https://openalex.org/I161103922"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003008077","display_name":"Falk H\u00e4nsel","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I161103922","display_name":"Philipps University of Marburg","ror":"https://ror.org/01rdrb571","country_code":"DE","type":"education","lineage":["https://openalex.org/I161103922"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Falk H\u00e4nsel","raw_affiliation_strings":["Philipps-University Marburg, Environmental Informatics, Faculty of Geography, Deutschhausstrasse 12, 35032, Marburg, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Philipps-University Marburg, Environmental Informatics, Faculty of Geography, Deutschhausstrasse 12, 35032, Marburg, Germany","institution_ids":["https://openalex.org/I161103922"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5039254107","display_name":"Thomas Nau\u00df","orcid":"https://orcid.org/0000-0003-3422-0960","observed_orcids":["https://orcid.org/0000-0003-3422-0960"]},"institutions":[{"id":"https://openalex.org/I161103922","display_name":"Philipps University of Marburg","ror":"https://ror.org/01rdrb571","country_code":"DE","type":"education","lineage":["https://openalex.org/I161103922"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Thomas Nauss","raw_affiliation_strings":["Philipps-University Marburg, Environmental Informatics, Faculty of Geography, Deutschhausstrasse 12, 35032, Marburg, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Philipps-University Marburg, Environmental Informatics, Faculty of Geography, Deutschhausstrasse 12, 35032, Marburg, Germany","institution_ids":["https://openalex.org/I161103922"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5025613818"],"corresponding_institution_ids":["https://openalex.org/I161103922"],"apc_list":{"value":3200,"currency":"USD","value_usd":3200},"apc_paid":{"value":3200,"currency":"USD","value_usd":3200},"fwci":2.6375,"has_fulltext":true,"cited_by_count":28,"citation_normalized_percentile":{"value":0.88679245,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":93,"max":99},"biblio":{"volume":"146","issue":null,"first_page":"104641","last_page":"104641"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T14427","display_name":"Environmental Monitoring and Data Management","score":0.9990000128746033,"subfield":{"id":"https://openalex.org/subfields/1907","display_name":"Geology"},"field":{"id":"https://openalex.org/fields/19","display_name":"Earth and Planetary Sciences"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T14427","display_name":"Environmental Monitoring and Data Management","score":0.9990000128746033,"subfield":{"id":"https://openalex.org/subfields/1907","display_name":"Geology"},"field":{"id":"https://openalex.org/fields/19","display_name":"Earth and Planetary Sciences"},"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.00039999998989515007,"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/T11937","display_name":"Research Data Management Practices","score":0.00039999998989515007,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/meteorological-station-data","display_name":"weather station data","score":0.9670000076293945},{"id":"https://openalex.org/keywords/time-series-databases","display_name":"time series databases","score":0.7820000052452087},{"id":"https://openalex.org/keywords/data-quality-control","display_name":"data quality control","score":0.7350000143051147},{"id":"https://openalex.org/keywords/missing-value-interpolation","display_name":"missing value interpolation","score":0.8619999885559082},{"id":"https://openalex.org/keywords/temporal-aggregation","display_name":"temporal aggregation","score":0.9300000071525574},{"id":"https://openalex.org/keywords/r-package","display_name":"R package","score":0.5559999942779541},{"id":"https://openalex.org/keywords/environmental-sensor-data","display_name":"environmental sensor data","score":0.5590000152587891},{"id":"https://openalex.org/keywords/data-archiving","display_name":"data archiving","score":0.5519999861717224}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8200422525405884},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6182133555412292},{"id":"https://openalex.org/C132964779","wikidata":"https://www.wikidata.org/wiki/Q2110223","display_name":"Raw data","level":2,"score":0.5528252124786377},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.47737810015678406},{"id":"https://openalex.org/C138827492","wikidata":"https://www.wikidata.org/wiki/Q6661985","display_name":"Data processing","level":2,"score":0.4492732286453247},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.44925105571746826},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4132017493247986},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.1848134696483612},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/j.cageo.2020.104641","doi":"https://doi.org/10.1016/j.cageo.2020.104641","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.cageo.2020.104641","pdf_url":"https://www.sciencedirect.com/science/article/pii/S009830042030618X/pdf","source":{"id":"https://openalex.org/S61699894","display_name":"Computers & Geosciences","issn_l":"0098-3004","issn":["0098-3004","1873-7803"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","cwts-core","dongbi-b","jufo-1","norway-1","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","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computers & Geosciences","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1016/j.cageo.2020.104641","doi":"https://doi.org/10.1016/j.cageo.2020.104641","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.cageo.2020.104641","pdf_url":"https://www.sciencedirect.com/science/article/pii/S009830042030618X/pdf","source":{"id":"https://openalex.org/S61699894","display_name":"Computers & Geosciences","issn_l":"0098-3004","issn":["0098-3004","1873-7803"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["anvur-scientific","cwts-core","dongbi-b","jufo-1","norway-1","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","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computers & Geosciences","raw_type":"journal-article"},"sustainable_development_goals":[],"sustainable_development_goals_aurora":[{"score":0.800000011920929,"id":"https://metadata.un.org/sdg/13","display_name":"Climate action"}],"study_designs":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320320879","display_name":"Deutsche Forschungsgemeinschaft","ror":"https://ror.org/018mejw64"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3096946058.pdf","grobid_xml":"https://content.openalex.org/works/W3096946058.grobid-xml"},"referenced_works_count":44,"referenced_works":["https://openalex.org/W784579088","https://openalex.org/W1791987072","https://openalex.org/W1937291376","https://openalex.org/W1982918096","https://openalex.org/W1999008353","https://openalex.org/W2018163757","https://openalex.org/W2072193727","https://openalex.org/W2077766806","https://openalex.org/W2097686432","https://openalex.org/W2104923072","https://openalex.org/W2113000322","https://openalex.org/W2116659053","https://openalex.org/W2127949150","https://openalex.org/W2147742121","https://openalex.org/W2283727311","https://openalex.org/W2304175625","https://openalex.org/W2582743722","https://openalex.org/W2617133263","https://openalex.org/W2618708155","https://openalex.org/W2749874879","https://openalex.org/W2765507745","https://openalex.org/W2809881943","https://openalex.org/W2887294330","https://openalex.org/W2890039624","https://openalex.org/W2924400300","https://openalex.org/W2924932526","https://openalex.org/W2945049259","https://openalex.org/W2950895106","https://openalex.org/W2953950763","https://openalex.org/W2963024689","https://openalex.org/W2964810011","https://openalex.org/W2967262902","https://openalex.org/W3093286053","https://openalex.org/W3100650712","https://openalex.org/W3102704970","https://openalex.org/W4249427614","https://openalex.org/W6646214454","https://openalex.org/W6678695831","https://openalex.org/W6752850141","https://openalex.org/W6754471117","https://openalex.org/W6762198982","https://openalex.org/W6764463505","https://openalex.org/W6765224430","https://openalex.org/W6784411148"],"related_works":["https://openalex.org/W2084395052","https://openalex.org/W2352265713","https://openalex.org/W2792375448","https://openalex.org/W3024941504","https://openalex.org/W2360242447","https://openalex.org/W2386554709","https://openalex.org/W2610098438","https://openalex.org/W2898899725","https://openalex.org/W2378356576","https://openalex.org/W2383657100"],"abstract_inverted_index":{"Geographers,":[0],"ecologists,":[1],"and":[2,27,33,56,126,132,152,204,215,223,241],"other":[3],"environmental":[4],"scientists":[5,240],"are":[6,66],"typically":[7],"required":[8],"to":[9,51,88,142,166,175,231],"utilise":[10],"non-continuous":[11],"measurements":[12],"from":[13],"various":[14],"types":[15],"of":[16,20,36,129,148,180,238],"sensors":[17],"as":[18,74,105,121],"part":[19],"their":[21],"research":[22,247],"activities.":[23,248],"However,":[24],"data":[25,60,104,173,233],"management":[26],"processing":[28,91,99,109,203],"require":[29],"advanced":[30],"computer":[31],"skills":[32],"specific":[34],"knowledge":[35,188],"the":[37,43,102,113,127,167],"measurement":[38],"sensors.":[39],"Here,":[40],"we":[41],"present":[42],"Tube":[44],"Database":[45],"(TubeDB),":[46],"an":[47,62,89,97,159,212],"easy-to-operate":[48],"software":[49],"system":[50],"archive,":[52],"quality":[53,124],"control,":[54],"query,":[55],"further":[57],"process":[58],"time-series":[59,118,149,181,192,197,232],"in":[61,191],"efficient":[63],"manner.":[64],"Data":[65],"imported":[67],"by":[68,76],"loading":[69],"any":[70],"unprocessed":[71],"raw":[72,103],"formats":[73],"recorded":[75],"climate":[77,201],"stations":[78],"into":[79],"TubeDB.":[80],"When":[81],"a":[82,86,106,139,183,208,235],"user":[83,136],"requests":[84],"data,":[85,119],"query":[87],"on-demand":[90],"unit":[92],"is":[93,138],"created":[94],"that":[95],"builds":[96,111],"individual":[98],"flow":[100,110],"with":[101,211],"source.":[107],"The":[108,134],"on":[112],"typical":[114],"preparation":[115],"steps":[116],"for":[117,163,234,245],"such":[120],"temporal":[122],"aggregation,":[123],"checks,":[125],"interpolation":[128],"missing":[130],"values":[131],"transformations.":[133],"primary":[135],"interface":[137],"web-based":[140],"application":[141,210],"allow":[143],"easy":[144,229],"access,":[145],"rapid":[146],"visualisations":[147],"within":[150,182],"seconds,":[151],"powerful":[153],"product-export":[154],"functionality.":[155],"We":[156],"also":[157],"provide":[158],"R":[160,168],"package":[161],"(rTubeDB)":[162],"seamless":[164],"connection":[165],"programming":[169],"environment.":[170],"TubeDB":[171,217,227],"enables":[172,228],"requesters":[174],"assemble":[176],"individually":[177],"processed":[178],"sets":[179],"web-browser":[184],"without":[185],"requiring":[186],"sensor-specific":[187],"or":[189],"experience":[190],"processing.":[193],"This":[194],"complements":[195],"existing":[196],"databases,":[198],"which":[199],"miss":[200],"data-specific":[202],"visualisation":[205],"capabilities.":[206],"As":[207],"self-contained":[209],"embedded":[213],"database":[214],"webserver,":[216],"has":[218],"both":[219],"low":[220,224],"hardware":[221],"demands":[222],"installation":[225],"complexity.":[226],"access":[230],"wide":[236],"range":[237],"non-computer":[239],"will":[242],"be":[243],"useful":[244],"many":[246]},"counts_by_year":[{"year":2026,"cited_by_count":6},{"year":2025,"cited_by_count":8},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":6}],"updated_date":"2026-10-08T09:06:37.294493","created_date":"2025-10-10T00:00:00"}