{"id":"https://openalex.org/W2159115664","doi":"https://doi.org/10.1145/1376616.1376693","title":"Efficient bulk insertion into a distributed ordered table","display_name":"Efficient bulk insertion into a distributed ordered table","publication_year":2008,"publication_date":"2008-06-09","ids":{"openalex":"https://openalex.org/W2159115664","doi":"https://doi.org/10.1145/1376616.1376693","mag":"2159115664"},"language":"en","primary_location":{"id":"doi:10.1145/1376616.1376693","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1376616.1376693","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2008 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"},"type":"conference-paper","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/A5002175828","display_name":"Adam Silberstein","orcid":null},"institutions":[{"id":"https://openalex.org/I4210134091","display_name":"Yahoo (United States)","ror":"https://ror.org/040dkzz12","country_code":"US","type":"company","lineage":["https://openalex.org/I4210134091"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Adam Silberstein","raw_affiliation_strings":["Yahoo! Research, Santa Clara, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Yahoo! Research, Santa Clara, CA, USA","institution_ids":["https://openalex.org/I4210134091"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112027889","display_name":"Brian F. Cooper","orcid":null},"institutions":[{"id":"https://openalex.org/I4210134091","display_name":"Yahoo (United States)","ror":"https://ror.org/040dkzz12","country_code":"US","type":"company","lineage":["https://openalex.org/I4210134091"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Brian F. Cooper","raw_affiliation_strings":["Yahoo! Research, Santa Clara, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Yahoo! Research, Santa Clara, CA, USA","institution_ids":["https://openalex.org/I4210134091"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101897152","display_name":"Utkarsh Srivastava","orcid":"https://orcid.org/0009-0002-7952-559X"},"institutions":[{"id":"https://openalex.org/I4210134091","display_name":"Yahoo (United States)","ror":"https://ror.org/040dkzz12","country_code":"US","type":"company","lineage":["https://openalex.org/I4210134091"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Utkarsh Srivastava","raw_affiliation_strings":["Yahoo! Research, Santa Clara, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Yahoo! Research, Santa Clara, CA, USA","institution_ids":["https://openalex.org/I4210134091"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5049077665","display_name":"Erik Vee","orcid":null},"institutions":[{"id":"https://openalex.org/I4210134091","display_name":"Yahoo (United States)","ror":"https://ror.org/040dkzz12","country_code":"US","type":"company","lineage":["https://openalex.org/I4210134091"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Erik Vee","raw_affiliation_strings":["Yahoo! Research, Santa Clara, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Yahoo! Research, Santa Clara, CA, USA","institution_ids":["https://openalex.org/I4210134091"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038067571","display_name":"Ramana Yerneni","orcid":null},"institutions":[{"id":"https://openalex.org/I4210134091","display_name":"Yahoo (United States)","ror":"https://ror.org/040dkzz12","country_code":"US","type":"company","lineage":["https://openalex.org/I4210134091"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ramana Yerneni","raw_affiliation_strings":["Yahoo! Research, Santa Clara, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Yahoo! Research, Santa Clara, CA, USA","institution_ids":["https://openalex.org/I4210134091"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5103029034","display_name":"Raghu Ramakrishnan","orcid":"https://orcid.org/0000-0003-1704-8644"},"institutions":[{"id":"https://openalex.org/I4210134091","display_name":"Yahoo (United States)","ror":"https://ror.org/040dkzz12","country_code":"US","type":"company","lineage":["https://openalex.org/I4210134091"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Raghu Ramakrishnan","raw_affiliation_strings":["Yahoo! Research, Santa Clara, CA, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Yahoo! Research, Santa Clara, CA, USA","institution_ids":["https://openalex.org/I4210134091"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I4210134091"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":40,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"765","last_page":"778"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9994000196456909,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9994000196456909,"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/T11478","display_name":"Caching and Content Delivery","score":0.9993000030517578,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9962000250816345,"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/partition","display_name":"Partition (number theory)","score":0.782387375831604},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7348704934120178},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.6737138628959656},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.5641219019889832},{"id":"https://openalex.org/keywords/range","display_name":"Range (aeronautics)","score":0.538544774055481},{"id":"https://openalex.org/keywords/bin","display_name":"Bin","score":0.5363819003105164},{"id":"https://openalex.org/keywords/cluster","display_name":"Cluster (spacecraft)","score":0.5259547233581543},{"id":"https://openalex.org/keywords/throughput","display_name":"Throughput","score":0.47231078147888184},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.4563884735107422},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.44260451197624207},{"id":"https://openalex.org/keywords/bin-packing-problem","display_name":"Bin packing problem","score":0.4230548143386841},{"id":"https://openalex.org/keywords/sort","display_name":"sort","score":0.4187953472137451},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.34768030047416687},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.3329404592514038},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.19691607356071472},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.16209977865219116},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.14658868312835693},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.13681042194366455},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.13370168209075928},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.11913305521011353},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.09094849228858948}],"concepts":[{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.782387375831604},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7348704934120178},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.6737138628959656},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.5641219019889832},{"id":"https://openalex.org/C204323151","wikidata":"https://www.wikidata.org/wiki/Q905424","display_name":"Range (aeronautics)","level":2,"score":0.538544774055481},{"id":"https://openalex.org/C156273044","wikidata":"https://www.wikidata.org/wiki/Q4913766","display_name":"Bin","level":2,"score":0.5363819003105164},{"id":"https://openalex.org/C164866538","wikidata":"https://www.wikidata.org/wiki/Q367351","display_name":"Cluster (spacecraft)","level":2,"score":0.5259547233581543},{"id":"https://openalex.org/C157764524","wikidata":"https://www.wikidata.org/wiki/Q1383412","display_name":"Throughput","level":3,"score":0.47231078147888184},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.4563884735107422},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.44260451197624207},{"id":"https://openalex.org/C87219788","wikidata":"https://www.wikidata.org/wiki/Q814581","display_name":"Bin packing problem","level":3,"score":0.4230548143386841},{"id":"https://openalex.org/C88548561","wikidata":"https://www.wikidata.org/wiki/Q347599","display_name":"sort","level":2,"score":0.4187953472137451},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.34768030047416687},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3329404592514038},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.19691607356071472},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.16209977865219116},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.14658868312835693},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.13681042194366455},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.13370168209075928},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.11913305521011353},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.09094849228858948},{"id":"https://openalex.org/C555944384","wikidata":"https://www.wikidata.org/wiki/Q249","display_name":"Wireless","level":2,"score":0.0},{"id":"https://openalex.org/C146978453","wikidata":"https://www.wikidata.org/wiki/Q3798668","display_name":"Aerospace engineering","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1376616.1376693","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1376616.1376693","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2008 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.139.1062","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.139.1062","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://infolab.stanford.edu/~usriv/papers/bulkload.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W254944847","https://openalex.org/W1489512665","https://openalex.org/W1511750901","https://openalex.org/W1559749472","https://openalex.org/W1568232141","https://openalex.org/W1588987386","https://openalex.org/W1739920298","https://openalex.org/W1992527911","https://openalex.org/W1999984505","https://openalex.org/W2000444555","https://openalex.org/W2066671865","https://openalex.org/W2068739275","https://openalex.org/W2102428370","https://openalex.org/W2102959957","https://openalex.org/W2105175890","https://openalex.org/W2106433410","https://openalex.org/W2108026089","https://openalex.org/W2112053513","https://openalex.org/W2122465391","https://openalex.org/W2142644005","https://openalex.org/W2150013559","https://openalex.org/W2153704625","https://openalex.org/W2624304035","https://openalex.org/W3134267570","https://openalex.org/W4238556425"],"related_works":["https://openalex.org/W2797538013","https://openalex.org/W2026961896","https://openalex.org/W173368591","https://openalex.org/W2034272113","https://openalex.org/W2138242427","https://openalex.org/W2104955674","https://openalex.org/W4288260564","https://openalex.org/W2068892231","https://openalex.org/W2096053066","https://openalex.org/W2001915926"],"abstract_inverted_index":{"We":[0,94,161,189],"study":[1],"the":[2,31,67,80,107,120,125,137,143,147,152],"problem":[3,165,176],"of":[4,20,30,45,66,77,91,139,154,169,177,201],"bulk-inserting":[5],"records":[6,39,69],"into":[7,41,60,73],"tables":[8],"in":[9,99],"a":[10,17,27,74,96,101,134,167,175,183,194,199],"system":[11,196],"that":[12,42,124,163,206],"horizontally":[13],"range-partitions":[14],"data":[15,78],"over":[16,211],"large":[18],"cluster":[19,92,200],"shared-nothing":[21],"machines.":[22],"Each":[23],"table":[24],"partition":[25,155],"contains":[26],"contiguous":[28],"portion":[29],"table's":[32],"key":[33],"range,":[34],"and":[35,52,114,142,158,180,204],"must":[36,150],"accept":[37],"all":[38],"inserted":[40,68],"range.":[43],"Examples":[44],"such":[46],"systems":[47],"include":[48],"BigTable[8]":[49],"at":[50,55],"Google,":[51],"PNUTS":[53],"[15]":[54],"Yahoo!":[56],"During":[57],"bulk":[58],"inserts":[59],"an":[61],"existing":[62],"table,":[63],"if":[64],"most":[65],"end":[70],"up":[71],"going":[72],"small":[75],"number":[76],"partitions,":[79],"obtained":[81],"throughput":[82,145],"may":[83],"be":[84,129],"very":[85],"poor":[86],"due":[87],"to":[88,174],"ineffective":[89],"use":[90],"parallelism.":[93],"propose":[95],"novel":[97],"approach":[98,192],"which":[100],"planning":[102,121,148],"phase":[103,122,149],"is":[104,133,166],"invoked":[105],"before":[106],"actual":[108],"insertions.":[109],"By":[110],"creating":[111],"new":[112],"partitions":[113,117,141],"intelligently":[115],"distributing":[116],"across":[118],"machines,":[119,203],"ensures":[123],"insertion":[126,159],"load":[127],"will":[128],"well-balanced.":[130],"Since":[131],"there":[132],"tradeoff":[135],"between":[136],"cost":[138],"moving":[140],"resulting":[144],"gain,":[146],"minimize":[151],"sum":[153],"movement":[156],"time":[157],"time.":[160],"show":[162,205],"this":[164],"variation":[168],"NP-hard":[170],"bin-packing,":[171],"reduce":[172],"it":[173,207],"packing":[178],"vectors,":[179],"then":[181],"give":[182],"solution":[184],"with":[185],"provable":[186],"approximation":[187],"guarantees.":[188],"evaluate":[190],"our":[191],"on":[193,198],"prototype":[195],"deployed":[197],"50":[202],"yields":[208],"significant":[209],"improvements":[210],"more":[212],"na\u00efve":[213],"techniques.":[214]},"counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":5},{"year":2012,"cited_by_count":3}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}