{"id":"https://openalex.org/W2913521398","doi":"https://doi.org/10.1145/3226595.3226639","title":"The implementation of POSTGRES","display_name":"The implementation of POSTGRES","publication_year":2018,"publication_date":"2018-12-01","ids":{"openalex":"https://openalex.org/W2913521398","doi":"https://doi.org/10.1145/3226595.3226639","mag":"2913521398"},"language":"en","primary_location":{"id":"doi:10.1145/3226595.3226639","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3226595.3226639","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/A5074724644","display_name":"Michael Stonebraker","orcid":"https://orcid.org/0000-0001-9184-9058"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Michael Stonebraker","raw_affiliation_strings":["","Dept. of Electr. Eng. & Comput. Sci, California Univ, Berkeley, CA, USA"],"affiliations":[{"raw_affiliation_string":"","institution_ids":[]},{"raw_affiliation_string":"Dept. of Electr. Eng. & Comput. Sci, California Univ, Berkeley, CA, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113735960","display_name":"Lawrence A. Rowe","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Lawrence A. Rowe","raw_affiliation_strings":["","Dept. of Electr. Eng. & Comput. Sci, California Univ, Berkeley, CA, USA"],"affiliations":[{"raw_affiliation_string":"","institution_ids":[]},{"raw_affiliation_string":"Dept. of Electr. Eng. & Comput. Sci, California Univ, Berkeley, CA, USA","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5018476224","display_name":"Michael Hirohama","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Michael Hirohama","raw_affiliation_strings":["","Dept. of Electr. Eng. & Comput. Sci, California Univ, Berkeley, CA, USA"],"affiliations":[{"raw_affiliation_string":"","institution_ids":[]},{"raw_affiliation_string":"Dept. of Electr. Eng. & Comput. Sci, California Univ, Berkeley, CA, USA","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5074724644"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.0342,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.79265062,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"519","last_page":"559"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9976999759674072,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9976999759674072,"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9968000054359436,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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.9926999807357788,"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/programmer","display_name":"Programmer","score":0.7993412613868713},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6812106370925903},{"id":"https://openalex.org/keywords/advice","display_name":"Advice (programming)","score":0.6257548332214355},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.5578932762145996},{"id":"https://openalex.org/keywords/scratch","display_name":"Scratch","score":0.5495253801345825},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.44804370403289795},{"id":"https://openalex.org/keywords/picasso","display_name":"PICASSO","score":0.43153905868530273},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.2896290421485901},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.28827905654907227},{"id":"https://openalex.org/keywords/visual-arts","display_name":"Visual arts","score":0.08547589182853699}],"concepts":[{"id":"https://openalex.org/C2778514511","wikidata":"https://www.wikidata.org/wiki/Q1374194","display_name":"Programmer","level":2,"score":0.7993412613868713},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6812106370925903},{"id":"https://openalex.org/C2779955035","wikidata":"https://www.wikidata.org/wiki/Q4686785","display_name":"Advice (programming)","level":2,"score":0.6257548332214355},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.5578932762145996},{"id":"https://openalex.org/C2781235140","wikidata":"https://www.wikidata.org/wiki/Q275131","display_name":"Scratch","level":2,"score":0.5495253801345825},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.44804370403289795},{"id":"https://openalex.org/C32916116","wikidata":"https://www.wikidata.org/wiki/Q13217498","display_name":"PICASSO","level":3,"score":0.43153905868530273},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.2896290421485901},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.28827905654907227},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.08547589182853699},{"id":"https://openalex.org/C205783811","wikidata":"https://www.wikidata.org/wiki/Q11629","display_name":"Painting","level":2,"score":0.0},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3226595.3226639","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3226595.3226639","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":[{"score":0.4099999964237213,"display_name":"Partnerships for the goals","id":"https://metadata.un.org/sdg/17"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":108,"referenced_works":["https://openalex.org/W41850619","https://openalex.org/W52590956","https://openalex.org/W112959345","https://openalex.org/W125925666","https://openalex.org/W199780592","https://openalex.org/W760598031","https://openalex.org/W1499512641","https://openalex.org/W1521148341","https://openalex.org/W1537448616","https://openalex.org/W1552081212","https://openalex.org/W1573833643","https://openalex.org/W1646696449","https://openalex.org/W1967435718","https://openalex.org/W1974021718","https://openalex.org/W1977101058","https://openalex.org/W1977484138","https://openalex.org/W1980839297","https://openalex.org/W1983170052","https://openalex.org/W1987238352","https://openalex.org/W1991199257","https://openalex.org/W1992479406","https://openalex.org/W1995358377","https://openalex.org/W1997020216","https://openalex.org/W1997033370","https://openalex.org/W2002099615","https://openalex.org/W2006296837","https://openalex.org/W2010801412","https://openalex.org/W2012056301","https://openalex.org/W2012534139","https://openalex.org/W2013012235","https://openalex.org/W2014977566","https://openalex.org/W2020649320","https://openalex.org/W2021078717","https://openalex.org/W2024444228","https://openalex.org/W2027276583","https://openalex.org/W2029036662","https://openalex.org/W2035382654","https://openalex.org/W2041442195","https://openalex.org/W2041780659","https://openalex.org/W2043489637","https://openalex.org/W2044469685","https://openalex.org/W2046298800","https://openalex.org/W2047182010","https://openalex.org/W2054819113","https://openalex.org/W2064766209","https://openalex.org/W2072627547","https://openalex.org/W2078132546","https://openalex.org/W2090636890","https://openalex.org/W2099561919","https://openalex.org/W2103920867","https://openalex.org/W2104954161","https://openalex.org/W2110631345","https://openalex.org/W2113906833","https://openalex.org/W2115173549","https://openalex.org/W2115503987","https://openalex.org/W2116436709","https://openalex.org/W2117034946","https://openalex.org/W2117608012","https://openalex.org/W2118269922","https://openalex.org/W2126043109","https://openalex.org/W2132063146","https://openalex.org/W2132461362","https://openalex.org/W2132692154","https://openalex.org/W2137901744","https://openalex.org/W2139445852","https://openalex.org/W2144261930","https://openalex.org/W2148294372","https://openalex.org/W2150397765","https://openalex.org/W2156076209","https://openalex.org/W2158655585","https://openalex.org/W2161163216","https://openalex.org/W2162702010","https://openalex.org/W2163728484","https://openalex.org/W2163765478","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/W2205031991","https://openalex.org/W2215315499","https://openalex.org/W2257756289","https://openalex.org/W2285144687","https://openalex.org/W2295468252","https://openalex.org/W2296139130","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/W2766842049","https://openalex.org/W2783360436","https://openalex.org/W2912039080","https://openalex.org/W3100101304","https://openalex.org/W3104265093","https://openalex.org/W3124175488","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W576672846","https://openalex.org/W3167029115","https://openalex.org/W568048806","https://openalex.org/W1592254927","https://openalex.org/W1604257981","https://openalex.org/W2914069804","https://openalex.org/W616822150","https://openalex.org/W78128566","https://openalex.org/W624278697","https://openalex.org/W2497709958"],"abstract_inverted_index":{"Currently,":[0],"POSTGRES":[1],"is":[2,12,82,131],"about":[3],"90":[4],"000":[5],"lines":[6],"of":[7,30,54,79,103,122,136],"code":[8],"in":[9,60],"C":[10],"and":[11,18,56,88,93],"being":[13,132],"used":[14],"by":[15,27,35],"assorted":[16],"\"bold":[17],"brave\"":[19],"early":[20],"users.":[21],"The":[22,77],"system":[23],"has":[24],"been":[25],"constructed":[26],"a":[28,36,51],"team":[29],"five":[31],"part-time":[32],"students":[33],"led":[34],"full-time":[37],"chief":[38],"programmer":[39],"over":[40],"the":[41,86,114,126],"last":[42],"three":[43],"years.":[44],"During":[45],"this":[46,80,107],"period,":[47],"we":[48,63,70,91,109],"have":[49],"made":[50,92],"large":[52],"number":[53],"design":[55,87],"implementation":[57,89],"choices.":[58],"Moreover,":[59],"some":[61,102,121],"areas":[62],"would":[64],"do":[65],"things":[66],"quite":[67],"differently":[68],"if":[69],"were":[71],"to":[72,83,94,97,113],"start":[73],"from":[74],"scratch":[75],"again.":[76],"purpose":[78],"paper":[81],"reflect":[84],"on":[85,134],"decisions":[90],"offer":[95],"advice":[96],"implementors":[98],"who":[99],"might":[100],"follow":[101],"our":[104,111],"paths.":[105],"In":[106,118],"paper,":[108,120],"restrict":[110],"attention":[112],"DBMS":[115],"\"backend\"":[116],"functions.":[117],"another":[119],"us":[123],"treat":[124],"Picasso,":[125],"application":[127],"development":[128],"environment":[129],"that":[130],"built":[133],"top":[135],"POSTGRES.":[137]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}