{"id":"https://openalex.org/W3201392296","doi":"https://doi.org/10.1145/3538712.3538715","title":"Northlight: Declarative and Optimized Analysis of Atmospheric Datasets in SparkSQL","display_name":"Northlight: Declarative and Optimized Analysis of Atmospheric Datasets in SparkSQL","publication_year":2022,"publication_date":"2022-07-06","ids":{"openalex":"https://openalex.org/W3201392296","doi":"https://doi.org/10.1145/3538712.3538715","mag":"3201392296"},"language":"en","primary_location":{"id":"doi:10.1145/3538712.3538715","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3538712.3538715","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3538712.3538715","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"34th International Conference on Scientific and Statistical Database Management","raw_type":"proceedings-article"},"type":"preprint","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3538712.3538715","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5068204058","display_name":"Justus Henneberg","orcid":"https://orcid.org/0009-0008-1076-0640"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Justus Henneberg","raw_affiliation_strings":["Johannes Gutenberg-University, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Johannes Gutenberg-University, Germany","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005397258","display_name":"Felix Schuhknecht","orcid":"https://orcid.org/0000-0002-0165-4116"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Felix Schuhknecht","raw_affiliation_strings":["Johannes Gutenberg-University, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Johannes Gutenberg-University, Germany","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075376553","display_name":"Philipp Reutter","orcid":"https://orcid.org/0000-0001-8932-6565"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Philipp Reutter","raw_affiliation_strings":["Johannes Gutenberg-University, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Johannes Gutenberg-University, Germany","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5076992397","display_name":"Nils Brast","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Nils Brast","raw_affiliation_strings":["Johannes Gutenberg-University, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Johannes Gutenberg-University, Germany","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5017730275","display_name":"Peter Spichtinger","orcid":"https://orcid.org/0000-0003-4008-4977"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Peter Spichtinger","raw_affiliation_strings":["Johannes Gutenberg-University, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Johannes Gutenberg-University, Germany","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.398,"has_fulltext":true,"cited_by_count":3,"citation_normalized_percentile":{"value":0.89132048,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"12"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9951000213623047,"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"}},"topics":[{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9951000213623047,"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/T11106","display_name":"Data Management and Algorithms","score":0.9912999868392944,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.991100013256073,"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/computer-science","display_name":"Computer science","score":0.8046340346336365},{"id":"https://openalex.org/keywords/python","display_name":"Python (programming language)","score":0.7949092388153076},{"id":"https://openalex.org/keywords/scripting-language","display_name":"Scripting language","score":0.7675631046295166},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.7641600370407104},{"id":"https://openalex.org/keywords/raw-data","display_name":"Raw data","score":0.5339006185531616},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5011858940124512},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.49618297815322876},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.4893593192100525},{"id":"https://openalex.org/keywords/representation","display_name":"Representation (politics)","score":0.458060085773468},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.37002864480018616},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.35152363777160645},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3477397561073303},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3324739933013916},{"id":"https://openalex.org/keywords/systems-engineering","display_name":"Systems engineering","score":0.12856602668762207}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8046340346336365},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.7949092388153076},{"id":"https://openalex.org/C61423126","wikidata":"https://www.wikidata.org/wiki/Q187432","display_name":"Scripting language","level":2,"score":0.7675631046295166},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.7641600370407104},{"id":"https://openalex.org/C132964779","wikidata":"https://www.wikidata.org/wiki/Q2110223","display_name":"Raw data","level":2,"score":0.5339006185531616},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5011858940124512},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.49618297815322876},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.4893593192100525},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.458060085773468},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.37002864480018616},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.35152363777160645},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3477397561073303},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3324739933013916},{"id":"https://openalex.org/C201995342","wikidata":"https://www.wikidata.org/wiki/Q682496","display_name":"Systems engineering","level":1,"score":0.12856602668762207},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C94625758","wikidata":"https://www.wikidata.org/wiki/Q7163","display_name":"Politics","level":2,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3538712.3538715","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3538712.3538715","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3538712.3538715","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"34th International Conference on Scientific and Statistical Database Management","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3538712.3538715","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3538712.3538715","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3538712.3538715","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"34th International Conference on Scientific and Statistical Database Management","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G638400772","display_name":null,"funder_award_id":"P2018-02-003","funder_id":"https://openalex.org/F4320309895","funder_display_name":"Carl-Zeiss-Stiftung"}],"funders":[{"id":"https://openalex.org/F4320309895","display_name":"Carl-Zeiss-Stiftung","ror":"https://ror.org/03ng4kg22"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3201392296.pdf","grobid_xml":"https://content.openalex.org/works/W3201392296.grobid-xml"},"referenced_works_count":32,"referenced_works":["https://openalex.org/W2017369298","https://openalex.org/W2026651123","https://openalex.org/W2030102203","https://openalex.org/W2038412523","https://openalex.org/W2050722640","https://openalex.org/W2107763879","https://openalex.org/W2119738171","https://openalex.org/W2131975293","https://openalex.org/W2133641981","https://openalex.org/W2135110893","https://openalex.org/W2204857797","https://openalex.org/W2221106743","https://openalex.org/W2395641228","https://openalex.org/W2501812170","https://openalex.org/W2515920125","https://openalex.org/W2518732252","https://openalex.org/W2604239613","https://openalex.org/W2604258491","https://openalex.org/W2695879227","https://openalex.org/W2768050605","https://openalex.org/W2784012696","https://openalex.org/W2792297482","https://openalex.org/W2892712926","https://openalex.org/W2918763263","https://openalex.org/W2952652959","https://openalex.org/W3002999603","https://openalex.org/W3025949386","https://openalex.org/W3046390352","https://openalex.org/W3093553400","https://openalex.org/W3120271627","https://openalex.org/W3134529714","https://openalex.org/W4236315184"],"related_works":["https://openalex.org/W2529681551","https://openalex.org/W2235766367","https://openalex.org/W1582950852","https://openalex.org/W1852679760","https://openalex.org/W2976477659","https://openalex.org/W2551776835","https://openalex.org/W2086733238","https://openalex.org/W1977776381","https://openalex.org/W1537913012","https://openalex.org/W3017187763"],"abstract_inverted_index":{"Research":[0],"in":[1,44,72,101],"atmospheric":[2],"physics,":[3],"meteorology,":[4],"and":[5,105,121,149],"weather":[6],"prediction":[7],"requires":[8],"the":[9,25,32,39,45,66,102,128,129,133],"processing":[10],"of":[11,24,79,132],"very":[12],"large":[13],"multi-dimensional":[14,153],"observational":[15],"or":[16,59,143],"modeled":[17],"datasets":[18],"on":[19,65],"a":[20,77,92,151],"daily":[21],"basis.":[22],"One":[23],"numerous":[26],"existing":[27],"array":[28],"engines":[29,115],"looks":[30,47],"like":[31],"natural":[33],"choice":[34],"for":[35,97],"this":[36,98],"task.":[37],"Interestingly,":[38],"actual":[40],"data":[41,54,68,122,144],"analysis":[42],"situation":[43],"community":[46],"surprisingly":[48],"different:":[49],"Researchers":[50],"often":[51],"process":[52],"their":[53,158],"manually":[55],"using":[56],"hand-written":[57],"Python":[58],"Julia":[60],"scripts":[61],"that":[62],"directly":[63],"operate":[64],"raw":[67],"files.":[69],"This":[70],"results":[71],"poor":[73,85],"performance":[74],"due":[75,87],"to":[76,88,91,156],"lack":[78],"data-driven":[80],"optimizations,":[81],"as":[82,84],"well":[83],"scalability":[86],"being":[89],"restricted":[90],"single":[93],"physical":[94],"machine.":[95],"Reasons":[96],"trend":[99],"lie":[100],"high":[103],"complexity":[104],"upfront":[106],"effort":[107],"associated":[108],"with":[109],"any":[110],"specialized":[111,152],"system:":[112],"Distributed":[113],"large-scale":[114],"must":[116,123,147],"be":[117,124,125],"set":[118],"up":[119],"carefully":[120],"converted/transferred":[126],"into":[127],"proprietary":[130],"representation":[131],"system.":[134],"The":[135],"users,":[136],"who":[137],"are":[138],"typically":[139],"not":[140],"computer":[141],"scientists":[142],"management":[145],"experts,":[146],"adopt":[148],"use":[150],"query":[154],"language":[155],"formulate":[157],"analytical":[159],"tasks.":[160]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2022,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}