{"id":"https://openalex.org/W2002016273","doi":"https://doi.org/10.1145/2146382.2146385","title":"Microsharding: a declarative approach to support elastic OLTP workloads","display_name":"Microsharding: a declarative approach to support elastic OLTP workloads","alternate_titles":[],"publication_year":2012,"publication_date":"2012-02-16","ids":{"openalex":"https://openalex.org/W2002016273","doi":"https://doi.org/10.1145/2146382.2146385","mag":"2002016273"},"language":"en","primary_location":{"id":"doi:10.1145/2146382.2146385","doi":"https://doi.org/10.1145/2146382.2146385","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2146382.2146385","pdf_url":null,"source":{"id":"https://openalex.org/S50071195","display_name":"ACM SIGOPS Operating Systems Review","issn_l":"0163-5980","issn":["0163-5980","1943-586X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","jufo-1"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGOPS Operating Systems Review","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2002016273"],"child_works_count":0,"type":"article","is_traditional":true,"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/A5088763786","display_name":"Junichi Tatemura","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210107353","display_name":"NEC (United States)","ror":"https://ror.org/01v791m31","country_code":"US","type":"company","lineage":["https://openalex.org/I118347220","https://openalex.org/I4210107353"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Junichi Tatemura","raw_affiliation_strings":["NEC Laboratories America, Cupertino, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"NEC Laboratories America, Cupertino, CA","institution_ids":["https://openalex.org/I4210107353"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5000883652","display_name":"Oliver Po","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210107353","display_name":"NEC (United States)","ror":"https://ror.org/01v791m31","country_code":"US","type":"company","lineage":["https://openalex.org/I118347220","https://openalex.org/I4210107353"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Oliver Po","raw_affiliation_strings":["NEC Laboratories America, Cupertino, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"NEC Laboratories America, Cupertino, CA","institution_ids":["https://openalex.org/I4210107353"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5003153029","display_name":"Hakan Hacg\u00fcm\u00fc\u015f","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210107353","display_name":"NEC (United States)","ror":"https://ror.org/01v791m31","country_code":"US","type":"company","lineage":["https://openalex.org/I118347220","https://openalex.org/I4210107353"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hakan Hacg\u00fcm\u00fc\u015f","raw_affiliation_strings":["NEC Laboratories America, Cupertino, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"NEC Laboratories America, Cupertino, CA","institution_ids":["https://openalex.org/I4210107353"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I4210107353"],"apc_list":null,"apc_paid":null,"fwci":5.8498,"has_fulltext":false,"cited_by_count":14,"citation_normalized_percentile":{"value":0.95777921,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":97},"biblio":{"volume":"46","issue":"1","first_page":"4","last_page":"11"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9854000210762024,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9854000210762024,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.011099999770522118,"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.001500000013038516,"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/oltp-workloads","display_name":"OLTP workloads","score":0.7730000019073486},{"id":"https://openalex.org/keywords/declarative-specification","display_name":"declarative specification","score":0.7329999804496765},{"id":"https://openalex.org/keywords/elastic-scalability","display_name":"elastic scalability","score":0.5720000267028809},{"id":"https://openalex.org/keywords/workload-analysis","display_name":"workload characterization","score":0.609000027179718}],"concepts":[{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.9453643560409546},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.895980954170227},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.6820066571235657},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.5938724279403687},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.5758216381072998},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.5566245913505554},{"id":"https://openalex.org/C25185021","wikidata":"https://www.wikidata.org/wiki/Q4053284","display_name":"Distributed transaction","level":4,"score":0.5101668834686279},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4915858209133148},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.44648459553718567},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.35741573572158813},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.31953346729278564},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.27711790800094604},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.10618129372596741}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2146382.2146385","doi":"https://doi.org/10.1145/2146382.2146385","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2146382.2146385","pdf_url":null,"source":{"id":"https://openalex.org/S50071195","display_name":"ACM SIGOPS Operating Systems Review","issn_l":"0163-5980","issn":["0163-5980","1943-586X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","jufo-1"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGOPS Operating Systems Review","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W1494303988","https://openalex.org/W1963979953","https://openalex.org/W1964144121","https://openalex.org/W1993535908","https://openalex.org/W2081182443","https://openalex.org/W2084761702","https://openalex.org/W2086586571","https://openalex.org/W2098970810","https://openalex.org/W2124711321","https://openalex.org/W2125391023","https://openalex.org/W2130923111","https://openalex.org/W2133681769","https://openalex.org/W2133967560","https://openalex.org/W2153704625","https://openalex.org/W2171707251","https://openalex.org/W2341655714","https://openalex.org/W2476848288","https://openalex.org/W2624304035","https://openalex.org/W3083050090","https://openalex.org/W3138135046","https://openalex.org/W4249823756"],"related_works":["https://openalex.org/W2161319241","https://openalex.org/W7096933887","https://openalex.org/W2576582381","https://openalex.org/W2520704087","https://openalex.org/W2033320920","https://openalex.org/W2020560621","https://openalex.org/W2130617154","https://openalex.org/W6987022672","https://openalex.org/W4413080816","https://openalex.org/W2133741724"],"abstract_inverted_index":{"The":[0,38],"paper":[1],"proposes":[2],"microsharding,":[3],"a":[4,23,36,42],"relational":[5],"alternative":[6],"for":[7],"the":[8,33,53],"recent":[9],"procedural":[10],"approaches":[11],"with":[12],"large-scale":[13],"data":[14],"stores":[15],"to":[16,45],"support":[17],"OLTP":[18,49],"workloads":[19],"elastically.":[20],"It":[21],"employs":[22],"declarative":[24,39],"specification,":[25],"called":[26],"transaction":[27],"classes,":[28],"of":[29],"constraints":[30],"applied":[31],"on":[32],"transactions":[34],"in":[35],"workload.":[37],"specification":[40],"enables":[41],"principled":[43],"approach":[44],"design":[46],"and":[47],"analyze":[48],"workloads.":[50],"We":[51],"discuss":[52],"current":[54],"framework":[55],"as":[56,58],"well":[57],"identify":[59],"research":[60],"directions.":[61]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2002016273","counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":4},{"year":2012,"cited_by_count":3}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
