{"id":"https://openalex.org/W2071989194","doi":"https://doi.org/10.1145/2465351.2465355","title":"BlinkDB","display_name":"BlinkDB","publication_year":2013,"publication_date":"2013-04-15","ids":{"openalex":"https://openalex.org/W2071989194","doi":"https://doi.org/10.1145/2465351.2465355","mag":"2071989194"},"language":"en","primary_location":{"id":"doi:10.1145/2465351.2465355","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2465351.2465355","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 8th ACM European Conference on Computer Systems","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/A5102730073","display_name":"Sameer Agarwal","orcid":"https://orcid.org/0009-0003-5217-2795"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Sameer Agarwal","raw_affiliation_strings":["University of California, Berkeley"],"affiliations":[{"raw_affiliation_string":"University of California, Berkeley","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5060287971","display_name":"Barzan Mozafari","orcid":"https://orcid.org/0000-0002-3581-3875"},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Barzan Mozafari","raw_affiliation_strings":["Massachusetts Institute of Technology"],"affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073895064","display_name":"Aurojit Panda","orcid":"https://orcid.org/0000-0001-9664-4377"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Aurojit Panda","raw_affiliation_strings":["University of California, Berkeley"],"affiliations":[{"raw_affiliation_string":"University of California, Berkeley","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5016063506","display_name":"Henry Milner","orcid":"https://orcid.org/0009-0006-5863-7962"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Henry Milner","raw_affiliation_strings":["University of California, Berkeley"],"affiliations":[{"raw_affiliation_string":"University of California, Berkeley","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037742794","display_name":"Samuel Madden","orcid":null},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Samuel Madden","raw_affiliation_strings":["Massachusetts Institute of Technology"],"affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5041920173","display_name":"Ion Stoica","orcid":"https://orcid.org/0000-0002-5373-0088"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ion Stoica","raw_affiliation_strings":["Conviva Inc. and University of California, Berkeley"],"affiliations":[{"raw_affiliation_string":"Conviva Inc. and University of California, Berkeley","institution_ids":["https://openalex.org/I95457486"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5102730073"],"corresponding_institution_ids":["https://openalex.org/I95457486"],"apc_list":null,"apc_paid":null,"fwci":67.2013,"has_fulltext":false,"cited_by_count":703,"citation_normalized_percentile":{"value":0.99982703,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"29","last_page":"42"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998000264167786,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998000264167786,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9990000128746033,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9894999861717224,"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/computer-science","display_name":"Computer science","score":0.8829349279403687},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6580120325088501},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.5580530166625977},{"id":"https://openalex.org/keywords/node","display_name":"Node (physics)","score":0.5338213443756104},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5298678278923035},{"id":"https://openalex.org/keywords/sample","display_name":"Sample (material)","score":0.5142976641654968},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.5055298805236816},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4733857214450836},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.4624969959259033},{"id":"https://openalex.org/keywords/the-internet","display_name":"The Internet","score":0.4505239427089691},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.43464407324790955},{"id":"https://openalex.org/keywords/massively-parallel","display_name":"Massively parallel","score":0.41347530484199524},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.405131071805954},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.33008915185928345},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.32266417145729065},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.3197595477104187},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.29322874546051025},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.276419997215271},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.21815544366836548},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.11336225271224976},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.10288593173027039},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.0931849479675293}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8829349279403687},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6580120325088501},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.5580530166625977},{"id":"https://openalex.org/C62611344","wikidata":"https://www.wikidata.org/wiki/Q1062658","display_name":"Node (physics)","level":2,"score":0.5338213443756104},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5298678278923035},{"id":"https://openalex.org/C198531522","wikidata":"https://www.wikidata.org/wiki/Q485146","display_name":"Sample (material)","level":2,"score":0.5142976641654968},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.5055298805236816},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4733857214450836},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.4624969959259033},{"id":"https://openalex.org/C110875604","wikidata":"https://www.wikidata.org/wiki/Q75","display_name":"The Internet","level":2,"score":0.4505239427089691},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.43464407324790955},{"id":"https://openalex.org/C190475519","wikidata":"https://www.wikidata.org/wiki/Q544384","display_name":"Massively parallel","level":2,"score":0.41347530484199524},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.405131071805954},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.33008915185928345},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.32266417145729065},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.3197595477104187},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.29322874546051025},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.276419997215271},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.21815544366836548},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.11336225271224976},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.10288593173027039},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0931849479675293},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C66938386","wikidata":"https://www.wikidata.org/wiki/Q633538","display_name":"Structural engineering","level":1,"score":0.0},{"id":"https://openalex.org/C43617362","wikidata":"https://www.wikidata.org/wiki/Q170050","display_name":"Chromatography","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2465351.2465355","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2465351.2465355","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 8th ACM European Conference on Computer Systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/17","score":0.49000000953674316,"display_name":"Partnerships for the goals"}],"awards":[{"id":"https://openalex.org/G2063665203","display_name":null,"funder_award_id":"NetApp","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G7103680314","display_name":null,"funder_award_id":"FA8750-12-2-0331","funder_id":"https://openalex.org/F4320332180","funder_display_name":"Defense Advanced Research Projects Agency"},{"id":"https://openalex.org/G8056273921","display_name":null,"funder_award_id":"CCF-1139158","funder_id":"https://openalex.org/F4320337387","funder_display_name":"Division of Computing and Communication Foundations"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320307102","display_name":"Intel Corporation","ror":"https://ror.org/01ek73717"},{"id":"https://openalex.org/F4320307759","display_name":"General Electric","ror":"https://ror.org/013msgt25"},{"id":"https://openalex.org/F4320307764","display_name":"Microsoft","ror":"https://ror.org/00d0nc645"},{"id":"https://openalex.org/F4320307791","display_name":"Cisco Systems","ror":"https://ror.org/03yt1ez60"},{"id":"https://openalex.org/F4320307904","display_name":"Oracle","ror":"https://ror.org/006c77m33"},{"id":"https://openalex.org/F4320307999","display_name":"SAP North America","ror":"https://ror.org/01gbhv690"},{"id":"https://openalex.org/F4320308258","display_name":"Qualcomm","ror":"https://ror.org/002zrf773"},{"id":"https://openalex.org/F4320308737","display_name":"Facebook","ror":"https://ror.org/01zbnvs85"},{"id":"https://openalex.org/F4320309327","display_name":"Google","ror":"https://ror.org/00njsd438"},{"id":"https://openalex.org/F4320309411","display_name":"University of California Berkeley","ror":"https://ror.org/01an7q238"},{"id":"https://openalex.org/F4320310598","display_name":"Amazon Web Services","ror":"https://ror.org/04mv4n011"},{"id":"https://openalex.org/F4320316505","display_name":"NetApp","ror":"https://ror.org/05c4cm338"},{"id":"https://openalex.org/F4320316785","display_name":"VMware","ror":null},{"id":"https://openalex.org/F4320322183","display_name":"Huawei Technologies","ror":"https://ror.org/00cmhce21"},{"id":"https://openalex.org/F4320332169","display_name":"Directorate for Computer and Information Science and Engineering","ror":"https://ror.org/025kzpk63"},{"id":"https://openalex.org/F4320332180","display_name":"Defense Advanced Research Projects Agency","ror":"https://ror.org/02caytj08"},{"id":"https://openalex.org/F4320332195","display_name":"Samsung","ror":"https://ror.org/04w3jy968"},{"id":"https://openalex.org/F4320337387","display_name":"Division of Computing and Communication Foundations","ror":"https://ror.org/01mng8331"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":40,"referenced_works":["https://openalex.org/W135476618","https://openalex.org/W1535431348","https://openalex.org/W1586825695","https://openalex.org/W1861377444","https://openalex.org/W1964857063","https://openalex.org/W1998244781","https://openalex.org/W2020147322","https://openalex.org/W2020584928","https://openalex.org/W2022858489","https://openalex.org/W2035801804","https://openalex.org/W2037701287","https://openalex.org/W2037826478","https://openalex.org/W2043099794","https://openalex.org/W2101610060","https://openalex.org/W2103212156","https://openalex.org/W2106753423","https://openalex.org/W2110086534","https://openalex.org/W2110104287","https://openalex.org/W2131975293","https://openalex.org/W2139276812","https://openalex.org/W2144461192","https://openalex.org/W2145385038","https://openalex.org/W2150397765","https://openalex.org/W2152029707","https://openalex.org/W2164507334","https://openalex.org/W2199389590","https://openalex.org/W2284530523","https://openalex.org/W2296677182","https://openalex.org/W2912802084","https://openalex.org/W3139115194","https://openalex.org/W4241185933","https://openalex.org/W4250212406","https://openalex.org/W4251617391","https://openalex.org/W4285719527","https://openalex.org/W4299841484","https://openalex.org/W6632229964","https://openalex.org/W6676096338","https://openalex.org/W6684060480","https://openalex.org/W6758383543","https://openalex.org/W7052647445"],"related_works":["https://openalex.org/W2371740287","https://openalex.org/W2395027054","https://openalex.org/W4379390531","https://openalex.org/W3162539059","https://openalex.org/W2110065340","https://openalex.org/W906795786","https://openalex.org/W2763568062","https://openalex.org/W1590029787","https://openalex.org/W2491796624","https://openalex.org/W3113337624"],"abstract_inverted_index":{"In":[0],"this":[1],"paper,":[2],"we":[3],"present":[4],"BlinkDB,":[5],"a":[6,69,82,95,111,119,131],"massively":[7],"parallel,":[8],"approximate":[9],"query":[10,27],"engine":[11],"for":[12,29],"running":[13,39],"interactive":[14,33],"SQL":[15],"queries":[16,34,40,140],"on":[17,41,94,130,141],"large":[18],"volumes":[19],"of":[20,71,146,162],"data.":[21],"BlinkDB":[22,55,104,137],"allows":[23],"users":[24],"to":[25,143],"trade-off":[26],"accuracy":[28,97],"response":[30,99],"time,":[31,79],"enabling":[32],"over":[35,78,125],"massive":[36],"data":[37,42,77,147],"by":[38],"samples":[43,74],"and":[44,67,80,110],"presenting":[45],"results":[46],"annotated":[47],"with":[48],"meaningful":[49],"error":[50,161],"bars.":[51],"To":[52],"achieve":[53],"this,":[54],"uses":[56],"two":[57],"key":[58],"ideas:":[59],"(1)":[60],"an":[61,89,160],"adaptive":[62],"optimization":[63],"framework":[64],"that":[65,87,121,136],"builds":[66],"maintains":[68],"set":[70],"multi-dimensional":[72],"stratified":[73],"from":[75,116],"original":[76],"(2)":[81],"dynamic":[83],"sample":[84,92],"selection":[85],"strategy":[86],"selects":[88],"appropriately":[90],"sized":[91],"based":[93],"query's":[96],"or":[98],"time":[100],"requirements.":[101],"We":[102],"evaluate":[103],"against":[105],"the":[106,126],"well-known":[107],"TPC-H":[108],"benchmarks":[109],"real-world":[112],"analytic":[113],"workload":[114],"derived":[115],"Conviva":[117],"Inc.,":[118],"company":[120],"manages":[122],"video":[123],"distribution":[124],"Internet.":[127],"Our":[128],"experiments":[129],"100":[132],"node":[133],"cluster":[134],"show":[135],"can":[138],"answer":[139],"up":[142],"17":[144],"TBs":[145],"in":[148],"less":[149],"than":[150,157],"2":[151],"seconds":[152],"(over":[153],"200":[154],"x":[155],"faster":[156],"Hive),":[158],"within":[159],"2-10%.":[163]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":23},{"year":2024,"cited_by_count":22},{"year":2023,"cited_by_count":31},{"year":2022,"cited_by_count":23},{"year":2021,"cited_by_count":44},{"year":2020,"cited_by_count":66},{"year":2019,"cited_by_count":102},{"year":2018,"cited_by_count":94},{"year":2017,"cited_by_count":88},{"year":2016,"cited_by_count":76},{"year":2015,"cited_by_count":72},{"year":2014,"cited_by_count":44},{"year":2013,"cited_by_count":15},{"year":2012,"cited_by_count":2}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2016-06-24T00:00:00"}