{"id":"https://openalex.org/W2020758731","doi":"https://doi.org/10.1145/2484838.2484880","title":"Real-time collaborative analysis with (almost) pure SQL","display_name":"Real-time collaborative analysis with (almost) pure SQL","publication_year":2013,"publication_date":"2013-07-29","ids":{"openalex":"https://openalex.org/W2020758731","doi":"https://doi.org/10.1145/2484838.2484880","mag":"2020758731"},"language":"en","primary_location":{"id":"doi:10.1145/2484838.2484880","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2484838.2484880","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 25th International Conference on Scientific and Statistical Database Management","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/A5016115127","display_name":"Daniel Halperin","orcid":"https://orcid.org/0000-0003-0118-0931"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Daniel Halperin","raw_affiliation_strings":["University of Washington"],"affiliations":[{"raw_affiliation_string":"University of Washington","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5044515635","display_name":"Fran\u00e7ois Ribalet","orcid":"https://orcid.org/0000-0002-7431-0234"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Francois Ribalet","raw_affiliation_strings":["University of Washington"],"affiliations":[{"raw_affiliation_string":"University of Washington","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5052717111","display_name":"Konstantin Weitz","orcid":null},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Konstantin Weitz","raw_affiliation_strings":["University of Washington"],"affiliations":[{"raw_affiliation_string":"University of Washington","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5045508458","display_name":"Mak A. Saito","orcid":"https://orcid.org/0000-0001-6040-9295"},"institutions":[{"id":"https://openalex.org/I4210090531","display_name":"Institut Fran\u00e7ais de la Mer","ror":"https://ror.org/00ggqtz82","country_code":"FR","type":"education","lineage":["https://openalex.org/I4210090531"]},{"id":"https://openalex.org/I66958751","display_name":"Woods Hole Oceanographic Institution","ror":"https://ror.org/03zbnzt98","country_code":"US","type":"funder","lineage":["https://openalex.org/I66958751"]}],"countries":["FR","US"],"is_corresponding":false,"raw_author_name":"Mak A. Saito","raw_affiliation_strings":["Woods Hole Oceanographic Institute"],"affiliations":[{"raw_affiliation_string":"Woods Hole Oceanographic Institute","institution_ids":["https://openalex.org/I66958751","https://openalex.org/I4210090531"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007124763","display_name":"Bill Howe","orcid":"https://orcid.org/0000-0001-8588-8472"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Bill Howe","raw_affiliation_strings":["University of Washington"],"affiliations":[{"raw_affiliation_string":"University of Washington","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5087975584","display_name":"E. Virginia Armbrust","orcid":"https://orcid.org/0000-0001-7865-5101"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"E. Virginia Armbrust","raw_affiliation_strings":["University of Washington"],"affiliations":[{"raw_affiliation_string":"University of Washington","institution_ids":["https://openalex.org/I201448701"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5016115127"],"corresponding_institution_ids":["https://openalex.org/I201448701"],"apc_list":null,"apc_paid":null,"fwci":2.325,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.91250749,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"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.994700014591217,"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.994700014591217,"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/T10895","display_name":"Species Distribution and Climate Change","score":0.9807999730110168,"subfield":{"id":"https://openalex.org/subfields/2302","display_name":"Ecological Modeling"},"field":{"id":"https://openalex.org/fields/23","display_name":"Environmental Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.9779000282287598,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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.8040469884872437},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7791200280189514},{"id":"https://openalex.org/keywords/variety","display_name":"Variety (cybernetics)","score":0.5653455853462219},{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.5631691813468933},{"id":"https://openalex.org/keywords/field","display_name":"Field (mathematics)","score":0.4793199300765991},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.4760800898075104},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.4437708556652069},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.43972644209861755},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4255150258541107},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.38076886534690857},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3037900924682617}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8040469884872437},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7791200280189514},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.5653455853462219},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.5631691813468933},{"id":"https://openalex.org/C9652623","wikidata":"https://www.wikidata.org/wiki/Q190109","display_name":"Field (mathematics)","level":2,"score":0.4793199300765991},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.4760800898075104},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.4437708556652069},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.43972644209861755},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4255150258541107},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.38076886534690857},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3037900924682617},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2484838.2484880","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2484838.2484880","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 25th International Conference on Scientific and Statistical Database Management","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G5697444881","display_name":null,"funder_award_id":"1205233","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G6304593479","display_name":null,"funder_award_id":"1154074","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320306202","display_name":"Gordon and Betty Moore Foundation","ror":"https://ror.org/006wxqw41"},{"id":"https://openalex.org/F4320307102","display_name":"Intel Corporation","ror":"https://ror.org/01ek73717"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W1514391626","https://openalex.org/W2004957580","https://openalex.org/W2014830756","https://openalex.org/W2088150079","https://openalex.org/W2093189534","https://openalex.org/W2167149779","https://openalex.org/W2482467070"],"related_works":["https://openalex.org/W2573939812","https://openalex.org/W2120098008","https://openalex.org/W1639806124","https://openalex.org/W4366145086","https://openalex.org/W2902831276","https://openalex.org/W2540682188","https://openalex.org/W4385834214","https://openalex.org/W3022423983","https://openalex.org/W12347151","https://openalex.org/W2957025774"],"abstract_inverted_index":{"We":[0],"consider":[1],"a":[2,17,37,63,68,91,97,109,198,204,210,230],"case":[3,51],"study":[4],"using":[5,67],"SQL-as-a-Service":[6],"to":[7,115,126,134,158,187],"support":[8,159],"\"instant":[9],"analysis\"":[10],"of":[11,59,70,93,145,174,220],"weakly":[12],"structured":[13],"relational":[14],"data":[15,54,84],"at":[16,178],"multi-investigator":[18],"science":[19,161,201,236],"retreat.":[20],"Here,":[21],"\"weakly":[22],"structured\"":[23],"means":[24],"tabular,":[25],"rows-and-columns":[26],"datasets":[27],"that":[28,34,152,168,206],"share":[29],"some":[30],"common":[31],"context,":[32],"but":[33,167],"have":[35],"limited":[36],"priori":[38],"agreement":[39],"on":[40],"file":[41],"formats,":[42],"relationships,":[43],"types,":[44],"schemas,":[45],"metadata,":[46],"or":[47],"semantics.":[48],"In":[49,141,213],"this":[50,103,142,214,221],"study,":[52],"the":[53,80,120,172,175,179,218],"were":[55,185],"acquired":[56],"from":[57,90,182,203],"hundreds":[58],"distinct":[60],"locations":[61],"during":[62],"multi-day":[64],"oceanographic":[65],"cruise":[66,81],"variety":[69,92],"physical,":[71],"biological,":[72],"and":[73,76,131,137,148,190,227],"chemical":[74],"sensors":[75],"assays.":[77],"Months":[78],"after":[79],"when":[82],"preliminary":[83],"processing":[85],"was":[86,154,207],"complete,":[87],"40+":[88],"researchers":[89,181],"disciplines":[94],"participated":[95],"in":[96,123],"two-day":[98],"\"data":[99],"synthesis":[100],"workshop.\"":[101],"At":[102],"workshop,":[104],"two":[105],"computer":[106],"scientists":[107],"used":[108],"web-based":[110],"query-as-a-service":[111],"platform":[112],"called":[113],"SQLShare":[114],"perform":[116],"\"SQL":[117],"stenography\":":[118],"capturing":[119],"scientific":[121],"discussion":[122],"real":[124],"time":[125],"integrate":[127],"data,":[128],"test":[129],"hypotheses,":[130],"populate":[132],"visualizations":[133],"then":[135],"inform":[136],"enhance":[138],"further":[139],"discussion.":[140],"\"field":[143],"test\"":[144],"our":[146,224],"technology":[147],"approach,":[149],"we":[150,169,216],"found":[151],"it":[153],"not":[155],"only":[156],"feasible":[157],"interactive":[160],"Q&A":[162],"with":[163],"essentially":[164],"pure":[165],"SQL,":[166],"significantly":[170],"increased":[171],"value":[173],"\"face":[176],"time\"":[177],"meeting:":[180],"different":[183],"fields":[184],"able":[186],"validate":[188],"assumptions":[189],"resolve":[191],"ambiguity":[192],"about":[193],"each":[194],"others'":[195],"fields.":[196],"As":[197],"result,":[199],"new":[200,231],"emerged":[202],"meeting":[205],"originally":[208],"just":[209],"planning":[211],"meeting.":[212],"paper,":[215],"describe":[217],"details":[219],"experiment,":[222],"discuss":[223],"major":[225],"findings,":[226],"lay":[228],"out":[229],"research":[232],"agenda":[233],"for":[234],"collaborative":[235],"database":[237],"services.":[238]},"counts_by_year":[{"year":2022,"cited_by_count":2},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}