{"id":"https://openalex.org/W2026427349","doi":"https://doi.org/10.1109/icde.2010.5447913","title":"Osprey: Implementing MapReduce-style fault tolerance in a shared-nothing distributed database","display_name":"Osprey: Implementing MapReduce-style fault tolerance in a shared-nothing distributed database","publication_year":2010,"publication_date":"2010-01-01","ids":{"openalex":"https://openalex.org/W2026427349","doi":"https://doi.org/10.1109/icde.2010.5447913","mag":"2026427349"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2010.5447913","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2010.5447913","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2010 IEEE 26th International Conference on Data Engineering (ICDE 2010)","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/A5111375326","display_name":"Christopher Yang","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":true,"raw_author_name":"Christopher Yang","raw_affiliation_strings":["MIT, CSAIL, Cambridge, MA, USA","CSAIL, MIT, 77 Massachusetts Ave, Cambridge, 02139, USA"],"affiliations":[{"raw_affiliation_string":"MIT, CSAIL, Cambridge, MA, USA","institution_ids":[]},{"raw_affiliation_string":"CSAIL, MIT, 77 Massachusetts Ave, Cambridge, 02139, USA","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5050562909","display_name":"Christine Yen","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":"Christine Yen","raw_affiliation_strings":["MIT, CSAIL, Cambridge, MA, USA","CSAIL, MIT, 77 Massachusetts Ave, Cambridge, 02139, USA"],"affiliations":[{"raw_affiliation_string":"MIT, CSAIL, Cambridge, MA, USA","institution_ids":[]},{"raw_affiliation_string":"CSAIL, MIT, 77 Massachusetts Ave, Cambridge, 02139, USA","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113570211","display_name":"Ceryen Tan","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":"Ceryen Tan","raw_affiliation_strings":["MIT, CSAIL, Cambridge, MA, USA","CSAIL, MIT, 77 Massachusetts Ave, Cambridge, 02139, USA"],"affiliations":[{"raw_affiliation_string":"MIT, CSAIL, Cambridge, MA, USA","institution_ids":[]},{"raw_affiliation_string":"CSAIL, MIT, 77 Massachusetts Ave, Cambridge, 02139, USA","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"last","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 R. Madden","raw_affiliation_strings":["MIT, CSAIL, Cambridge, MA, USA","CSAIL, MIT, 77 Massachusetts Ave, Cambridge, 02139, USA"],"affiliations":[{"raw_affiliation_string":"MIT, CSAIL, Cambridge, MA, USA","institution_ids":[]},{"raw_affiliation_string":"CSAIL, MIT, 77 Massachusetts Ave, Cambridge, 02139, USA","institution_ids":["https://openalex.org/I63966007"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5111375326"],"corresponding_institution_ids":["https://openalex.org/I63966007"],"apc_list":null,"apc_paid":null,"fwci":16.7647,"has_fulltext":false,"cited_by_count":73,"citation_normalized_percentile":{"value":0.99358949,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"657","last_page":"668"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","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"}},"topics":[{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9980999827384949,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9968000054359436,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8219399452209473},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5789961814880371},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.5605632066726685},{"id":"https://openalex.org/keywords/node","display_name":"Node (physics)","score":0.5300336480140686},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.48596036434173584},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.44603586196899414},{"id":"https://openalex.org/keywords/distributed-database","display_name":"Distributed database","score":0.43375590443611145},{"id":"https://openalex.org/keywords/fault-tolerance","display_name":"Fault tolerance","score":0.429330050945282},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.36257678270339966},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.12284272909164429}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8219399452209473},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5789961814880371},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.5605632066726685},{"id":"https://openalex.org/C62611344","wikidata":"https://www.wikidata.org/wiki/Q1062658","display_name":"Node (physics)","level":2,"score":0.5300336480140686},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.48596036434173584},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.44603586196899414},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.43375590443611145},{"id":"https://openalex.org/C63540848","wikidata":"https://www.wikidata.org/wiki/Q3140932","display_name":"Fault tolerance","level":2,"score":0.429330050945282},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.36257678270339966},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12284272909164429},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"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/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","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}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/icde.2010.5447913","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2010.5447913","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2010 IEEE 26th International Conference on Data Engineering (ICDE 2010)","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.158.1145","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.158.1145","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://db.csail.mit.edu/pubs/OspreyDB.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.477.3061","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.477.3061","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://dspace.mit.edu/openaccess-disseminate/1721.1/59970/","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W94011511","https://openalex.org/W1852059679","https://openalex.org/W1929853380","https://openalex.org/W1991152532","https://openalex.org/W2034747525","https://openalex.org/W2057123981","https://openalex.org/W2080427212","https://openalex.org/W2101373066","https://openalex.org/W2103201239","https://openalex.org/W2119565742","https://openalex.org/W2124645273","https://openalex.org/W2125775320","https://openalex.org/W2173213060","https://openalex.org/W2950416404","https://openalex.org/W3139963143","https://openalex.org/W6638950451"],"related_works":["https://openalex.org/W3161249280","https://openalex.org/W2267059662","https://openalex.org/W2364268683","https://openalex.org/W4388411807","https://openalex.org/W1519906715","https://openalex.org/W2478803962","https://openalex.org/W3169430512","https://openalex.org/W2384804534","https://openalex.org/W2154069781","https://openalex.org/W4281381431"],"abstract_inverted_index":{"In":[0,205],"this":[1,206],"paper,":[2],"we":[3],"describe":[4],"a":[5,15,45,93,98,114,120,143,154,167,182,196,244,248],"scheme":[6],"for":[7,247],"tolerating":[8],"and":[9,23,34,81,134,224,254,272,280],"recovering":[10],"from":[11],"mid-query":[12],"faults":[13],"in":[14,70,110,124],"distributed":[16,245],"shared":[17],"nothing":[18],"database.":[19],"Rather":[20],"than":[21],"aborting":[22],"restarting":[24],"queries,":[25],"our":[26],"system,":[27],"Osprey,":[28],"divides":[29],"running":[30,118],"queries":[31],"into":[32,166],"subqueries,":[33],"replicates":[35],"data":[36,250,252],"such":[37],"that":[38,171,259,273],"each":[39,135],"subquery":[40,179,198],"can":[41],"be":[42,235],"rerun":[43,85],"on":[44,86,119,139,175],"different":[46],"node":[47,50,109,215],"if":[48],"the":[49,63,111,125,176,186,190,208,225,260,264,270,274],"initially":[51],"responsible":[52],"fails":[53],"or":[54,73],"returns":[55],"too":[56],"slowly.":[57],"Our":[58,256],"approach":[59],"is":[60,90,113,129,137,217,227,266],"inspired":[61],"by":[62,263],"fault":[64,281],"tolerance":[65,282],"properties":[66],"of":[67,101,127,169,185,189,210],"Map":[68],"Reduce,":[69],"which":[71],"map":[72],"reduce":[74],"jobs":[75,83],"are":[76,84,172,194],"greedily":[77],"assigned":[78,195,236],"to":[79,104,158,214,269],"workers,":[80],"failed":[82],"other":[87],"workers.":[88],"Osprey":[89],"implemented":[91],"using":[92,142],"middleware":[94,265],"approach,":[95],"with":[96],"only":[97,181],"small":[99,183,218,249,267],"amount":[100,209],"custom":[102],"code":[103],"handle":[105],"cluster":[106],"coordination.":[107],"Each":[108,178],"system":[112,117,226,246,275],"discrete":[115],"database":[116,132],"separate":[121],"machine.":[122],"Data,":[123],"form":[126],"tables,":[128],"partitioned":[130],"amongst":[131],"nodes":[133,193,233],"partition":[136],"replicated":[138],"several":[140],"nodes,":[141],"technique":[144],"called":[145],"chained":[146],"declustering":[147],"[1].":[148],"A":[149],"coordinator":[150],"machine":[151],"acts":[152],"as":[153,199,243],"standard":[155],"SQL":[156,164],"interface":[157],"users;":[159],"it":[160],"transforms":[161],"an":[162],"input":[163],"query":[165],"set":[168,253],"subqueries":[170],"then":[173],"executed":[174],"nodes.":[177],"represents":[180],"fraction":[184],"total":[187],"execution":[188],"query;":[191],"worker":[192],"new":[197],"they":[200],"finish":[201],"their":[202],"current":[203],"one.":[204],"greedy-approach,":[207],"work":[211],"lost":[212],"due":[213],"failure":[216],"(at":[219],"most":[220],"one":[221],"subquery's":[222],"work),":[223],"automatically":[228],"load":[229,278],"balanced,":[230],"because":[231],"slow":[232],"will":[234],"fewer":[237],"subqueries.":[238],"We":[239],"demonstrate":[240],"Osprey's":[241],"viability":[242],"warehouse":[251],"workload.":[255],"experiments":[257],"show":[258],"overhead":[261],"introduced":[262],"compared":[268],"workload,":[271],"shows":[276],"promising":[277],"balancing":[279],"properties.":[283]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":7},{"year":2013,"cited_by_count":14},{"year":2012,"cited_by_count":13}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}