{"id":"https://openalex.org/W2914857483","doi":"https://doi.org/10.1145/3226595.3226635","title":"OLTP through the looking glass, and what we found there","display_name":"OLTP through the looking glass, and what we found there","publication_year":2018,"publication_date":"2018-12-01","ids":{"openalex":"https://openalex.org/W2914857483","doi":"https://doi.org/10.1145/3226595.3226635","mag":"2914857483"},"language":"en","primary_location":{"id":"doi:10.1145/3226595.3226635","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3226595.3226635","pdf_url":null,"source":{"id":"https://openalex.org/S4306462870","display_name":"Association for Computing Machinery eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"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":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Making Databases Work: the Pragmatic Wisdom of Michael Stonebraker","raw_type":"book-chapter"},"type":"book-chapter","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/A5070468115","display_name":"Stavros Harizopoulos","orcid":null},"institutions":[{"id":"https://openalex.org/I1324840837","display_name":"Hewlett-Packard (United States)","ror":"https://ror.org/059rn9488","country_code":"US","type":"company","lineage":["https://openalex.org/I1324840837"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Stavros Harizopoulos","raw_affiliation_strings":["HP Labs"],"affiliations":[{"raw_affiliation_string":"HP Labs","institution_ids":["https://openalex.org/I1324840837"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5049333271","display_name":"Daniel J. Abadi","orcid":"https://orcid.org/0000-0003-3771-2995"},"institutions":[{"id":"https://openalex.org/I32971472","display_name":"Yale University","ror":"https://ror.org/03v76x132","country_code":"US","type":"education","lineage":["https://openalex.org/I32971472"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Daniel J. Abadi","raw_affiliation_strings":["Yale University"],"affiliations":[{"raw_affiliation_string":"Yale University","institution_ids":["https://openalex.org/I32971472"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037742794","display_name":"Samuel Madden","orcid":null},"institutions":[{"id":"https://openalex.org/I4210109586","display_name":"Moscow Institute of Thermal Technology","ror":"https://ror.org/021es5e59","country_code":"RU","type":"facility","lineage":["https://openalex.org/I4210109586"]}],"countries":["RU"],"is_corresponding":false,"raw_author_name":"Samuel Madden","raw_affiliation_strings":["MIT","-MIT"],"affiliations":[{"raw_affiliation_string":"MIT","institution_ids":["https://openalex.org/I4210109586"]},{"raw_affiliation_string":"-MIT","institution_ids":["https://openalex.org/I4210109586"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5074724644","display_name":"Michael Stonebraker","orcid":"https://orcid.org/0000-0001-9184-9058"},"institutions":[{"id":"https://openalex.org/I4210109586","display_name":"Moscow Institute of Thermal Technology","ror":"https://ror.org/021es5e59","country_code":"RU","type":"facility","lineage":["https://openalex.org/I4210109586"]}],"countries":["RU"],"is_corresponding":false,"raw_author_name":"Michael Stonebraker","raw_affiliation_strings":["MIT","-MIT"],"affiliations":[{"raw_affiliation_string":"MIT","institution_ids":["https://openalex.org/I4210109586"]},{"raw_affiliation_string":"-MIT","institution_ids":["https://openalex.org/I4210109586"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5070468115"],"corresponding_institution_ids":["https://openalex.org/I1324840837"],"apc_list":null,"apc_paid":null,"fwci":4.6544,"has_fulltext":false,"cited_by_count":21,"citation_normalized_percentile":{"value":0.95484911,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"409","last_page":"439"},"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.9998999834060669,"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.9998999834060669,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9995999932289124,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9991999864578247,"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/online-transaction-processing","display_name":"Online transaction processing","score":0.9391943216323853},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7022886276245117},{"id":"https://openalex.org/keywords/suite","display_name":"Suite","score":0.6195955872535706},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.534477710723877},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.5306079983711243},{"id":"https://openalex.org/keywords/heap","display_name":"Heap (data structure)","score":0.5254941582679749},{"id":"https://openalex.org/keywords/concurrency-control","display_name":"Concurrency control","score":0.47760841250419617},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.455132395029068},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.4135911762714386},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2371024191379547},{"id":"https://openalex.org/keywords/history","display_name":"History","score":0.12954717874526978},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.10423493385314941},{"id":"https://openalex.org/keywords/archaeology","display_name":"Archaeology","score":0.06710967421531677}],"concepts":[{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.9391943216323853},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7022886276245117},{"id":"https://openalex.org/C79581498","wikidata":"https://www.wikidata.org/wiki/Q1367530","display_name":"Suite","level":2,"score":0.6195955872535706},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.534477710723877},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.5306079983711243},{"id":"https://openalex.org/C134757568","wikidata":"https://www.wikidata.org/wiki/Q274089","display_name":"Heap (data structure)","level":2,"score":0.5254941582679749},{"id":"https://openalex.org/C84511453","wikidata":"https://www.wikidata.org/wiki/Q2914952","display_name":"Concurrency control","level":3,"score":0.47760841250419617},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.455132395029068},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.4135911762714386},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2371024191379547},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.12954717874526978},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.10423493385314941},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.06710967421531677}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3226595.3226635","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3226595.3226635","pdf_url":null,"source":{"id":"https://openalex.org/S4306462870","display_name":"Association for Computing Machinery eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"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":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Making Databases Work: the Pragmatic Wisdom of Michael Stonebraker","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Life below water","score":0.7099999785423279,"id":"https://metadata.un.org/sdg/14"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":111,"referenced_works":["https://openalex.org/W41850619","https://openalex.org/W83535271","https://openalex.org/W125925666","https://openalex.org/W194202986","https://openalex.org/W760598031","https://openalex.org/W1515932031","https://openalex.org/W1521148341","https://openalex.org/W1552081212","https://openalex.org/W1569583874","https://openalex.org/W1570477871","https://openalex.org/W1598618182","https://openalex.org/W1646696449","https://openalex.org/W1655990431","https://openalex.org/W1847807943","https://openalex.org/W1967435718","https://openalex.org/W1974021718","https://openalex.org/W1977101058","https://openalex.org/W1977484138","https://openalex.org/W1983170052","https://openalex.org/W1987238352","https://openalex.org/W1991199257","https://openalex.org/W1992479406","https://openalex.org/W1997020216","https://openalex.org/W1997033370","https://openalex.org/W2002099615","https://openalex.org/W2006296837","https://openalex.org/W2006816934","https://openalex.org/W2010801412","https://openalex.org/W2012056301","https://openalex.org/W2013012235","https://openalex.org/W2014977566","https://openalex.org/W2020649320","https://openalex.org/W2021078717","https://openalex.org/W2024444228","https://openalex.org/W2029036662","https://openalex.org/W2041315700","https://openalex.org/W2041442195","https://openalex.org/W2041780659","https://openalex.org/W2044469685","https://openalex.org/W2046298800","https://openalex.org/W2047182010","https://openalex.org/W2047908203","https://openalex.org/W2064766209","https://openalex.org/W2078132546","https://openalex.org/W2088221489","https://openalex.org/W2095135670","https://openalex.org/W2099561919","https://openalex.org/W2102333161","https://openalex.org/W2104954161","https://openalex.org/W2108026089","https://openalex.org/W2110631345","https://openalex.org/W2113751407","https://openalex.org/W2115173549","https://openalex.org/W2115503987","https://openalex.org/W2116436709","https://openalex.org/W2117608012","https://openalex.org/W2118269922","https://openalex.org/W2118411843","https://openalex.org/W2122465391","https://openalex.org/W2132461362","https://openalex.org/W2132692154","https://openalex.org/W2133386065","https://openalex.org/W2136390693","https://openalex.org/W2137077706","https://openalex.org/W2137901744","https://openalex.org/W2139445852","https://openalex.org/W2144261930","https://openalex.org/W2145293491","https://openalex.org/W2148294372","https://openalex.org/W2150397765","https://openalex.org/W2155651153","https://openalex.org/W2156076209","https://openalex.org/W2158049821","https://openalex.org/W2158483238","https://openalex.org/W2160404300","https://openalex.org/W2160723116","https://openalex.org/W2161163216","https://openalex.org/W2163728484","https://openalex.org/W2164128653","https://openalex.org/W2165467455","https://openalex.org/W2167184472","https://openalex.org/W2168605051","https://openalex.org/W2169012378","https://openalex.org/W2170712852","https://openalex.org/W2182688186","https://openalex.org/W2200275386","https://openalex.org/W2200545814","https://openalex.org/W2257756289","https://openalex.org/W2285144687","https://openalex.org/W2295468252","https://openalex.org/W2336692326","https://openalex.org/W2346151344","https://openalex.org/W2396881363","https://openalex.org/W2397219120","https://openalex.org/W2401974969","https://openalex.org/W2524947710","https://openalex.org/W2557049100","https://openalex.org/W2558840806","https://openalex.org/W2561190943","https://openalex.org/W2583699183","https://openalex.org/W2583914191","https://openalex.org/W2584177841","https://openalex.org/W2624304035","https://openalex.org/W2766842049","https://openalex.org/W2783360436","https://openalex.org/W3100101304","https://openalex.org/W3104265093","https://openalex.org/W3124175488","https://openalex.org/W3138135046","https://openalex.org/W3138846794","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W1555950237","https://openalex.org/W2804682780","https://openalex.org/W2084383859","https://openalex.org/W2102729946","https://openalex.org/W3166336118","https://openalex.org/W2188262136","https://openalex.org/W834810655","https://openalex.org/W2188975716","https://openalex.org/W171602259","https://openalex.org/W2240092424"],"abstract_inverted_index":{"Online":[0],"Transaction":[1],"Processing":[2],"(OLTP)":[3],"databases":[4,53],"include":[5],"a":[6],"suite":[7],"of":[8,25,45],"features---disk-resident":[9],"B-trees":[10],"and":[11,34,60],"heap":[12],"files,":[13],"locking-based":[14],"concurrency":[15],"control,":[16],"support":[17],"for":[18,22],"multi-threading---that":[19],"were":[20],"optimized":[21],"computer":[23],"technology":[24],"the":[26],"late":[27],"1970's.":[28],"Advances":[29],"in":[30,57,67],"modern":[31],"processors,":[32],"memories,":[33],"networks":[35],"mean":[36],"that":[37,50],"today's":[38],"computers":[39],"are":[40],"vastly":[41],"different":[42],"from":[43],"those":[44],"30":[46],"years":[47],"ago,":[48],"such":[49],"many":[51],"OLTP":[52,62],"will":[54],"now":[55],"fit":[56],"main":[58],"memory,":[59],"most":[61],"transactions":[63],"can":[64],"be":[65],"processed":[66],"milliseconds":[68],"or":[69],"less.":[70],"Yet":[71],"database":[72],"architecture":[73],"has":[74],"changed":[75],"little.":[76]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":4}],"updated_date":"2026-02-27T16:54:17.756197","created_date":"2025-10-10T00:00:00"}