{"id":"https://openalex.org/W2903300941","doi":"https://doi.org/10.1145/3226595.3226614","title":"Looking back at Postgres","display_name":"Looking back at Postgres","publication_year":2018,"publication_date":"2018-12-01","ids":{"openalex":"https://openalex.org/W2903300941","doi":"https://doi.org/10.1145/3226595.3226614","mag":"2903300941"},"language":"en","primary_location":{"id":"doi:10.1145/3226595.3226614","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3226595.3226614","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":"preprint","indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/1901.01973","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5043626252","display_name":"Joseph M. Hellerstein","orcid":"https://orcid.org/0000-0002-7712-4306"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Joseph M. Hellerstein","raw_affiliation_strings":["","University of California\u2013Berkeley"],"affiliations":[{"raw_affiliation_string":"","institution_ids":[]},{"raw_affiliation_string":"University of California\u2013Berkeley","institution_ids":["https://openalex.org/I95457486"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5043626252"],"corresponding_institution_ids":["https://openalex.org/I95457486"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.21704745,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"205","last_page":"224"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9977999925613403,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T11106","display_name":"Data Management and Algorithms","score":0.9977999925613403,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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"}},{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.9965999722480774,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/join","display_name":"Join (topology)","score":0.49301835894584656},{"id":"https://openalex.org/keywords/compensation","display_name":"Compensation (psychology)","score":0.46666449308395386},{"id":"https://openalex.org/keywords/recall","display_name":"Recall","score":0.43877556920051575},{"id":"https://openalex.org/keywords/psychology","display_name":"Psychology","score":0.41756951808929443},{"id":"https://openalex.org/keywords/management","display_name":"Management","score":0.3686116635799408},{"id":"https://openalex.org/keywords/social-psychology","display_name":"Social psychology","score":0.16135957837104797}],"concepts":[{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.49301835894584656},{"id":"https://openalex.org/C2780023022","wikidata":"https://www.wikidata.org/wiki/Q1338171","display_name":"Compensation (psychology)","level":2,"score":0.46666449308395386},{"id":"https://openalex.org/C100660578","wikidata":"https://www.wikidata.org/wiki/Q18733","display_name":"Recall","level":2,"score":0.43877556920051575},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.41756951808929443},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.3686116635799408},{"id":"https://openalex.org/C77805123","wikidata":"https://www.wikidata.org/wiki/Q161272","display_name":"Social psychology","level":1,"score":0.16135957837104797},{"id":"https://openalex.org/C180747234","wikidata":"https://www.wikidata.org/wiki/Q23373","display_name":"Cognitive psychology","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"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/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"doi:10.1145/3226595.3226614","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3226595.3226614","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"},{"id":"pmh:oai:arXiv.org:1901.01973","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1901.01973","pdf_url":"https://arxiv.org/pdf/1901.01973","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},{"id":"mag:2903300941","is_oa":true,"landing_page_url":"https://arxiv.org/pdf/1901.01973.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"arXiv (Cornell University)","raw_type":null},{"id":"doi:10.48550/arxiv.1901.01973","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.1901.01973","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:1901.01973","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1901.01973","pdf_url":"https://arxiv.org/pdf/1901.01973","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W41850619","https://openalex.org/W125925666","https://openalex.org/W1974021718","https://openalex.org/W2044849727","https://openalex.org/W2061587502","https://openalex.org/W2072627547","https://openalex.org/W2086906616","https://openalex.org/W2117034946","https://openalex.org/W2118269922","https://openalex.org/W2123586642","https://openalex.org/W2128912667","https://openalex.org/W2131300191","https://openalex.org/W2133384222","https://openalex.org/W2167184472","https://openalex.org/W2325507490","https://openalex.org/W2408615375"],"related_works":["https://openalex.org/W2963463805","https://openalex.org/W324051101","https://openalex.org/W72293001","https://openalex.org/W2610578739","https://openalex.org/W2619069455","https://openalex.org/W2892195954","https://openalex.org/W1989664572","https://openalex.org/W2337049022","https://openalex.org/W842191656","https://openalex.org/W3109226719","https://openalex.org/W237146395","https://openalex.org/W2741175218","https://openalex.org/W2074553782","https://openalex.org/W2518638325","https://openalex.org/W2971769034","https://openalex.org/W2593492151","https://openalex.org/W570066687","https://openalex.org/W2738393043","https://openalex.org/W2595437008","https://openalex.org/W1996316237"],"abstract_inverted_index":{"This":[0],"is":[1],"a":[2,38,52,72,104],"recollection":[3],"of":[4,33,58,61,71,74,110,122],"the":[5,17,20,59,69,78,94,107,111,123,128],"UC":[6],"Berkeley":[7],"Postgres":[8,66],"project,":[9,129],"which":[10],"was":[11,24,50,68,97],"led":[12],"by":[13],"Mike":[14],"Stonebraker":[15,49],"from":[16,120],"mid-1980's":[18],"to":[19,99,149],"mid-1990's.":[21],"The":[22,65],"article":[23],"solicited":[25],"for":[26],"Stonebraker's":[27,43],"Turing":[28],"Award":[29],"book,":[30],"as":[31,103],"one":[32],"many":[34],"personal/historical":[35],"recollections.":[36],"As":[37],"result":[39],"it":[40],"focuses":[41],"on":[42,117,127],"design":[44],"ideas":[45],"and":[46,54,77,145],"leadership.":[47],"But":[48],"never":[51],"coder,":[53],"he":[55],"stayed":[56],"out":[57],"way":[60],"his":[62],"development":[63],"team.":[64],"codebase":[67],"work":[70],"team":[73,102],"brilliant":[75],"students":[76,126],"occasional":[79],"university":[80],"\"staff":[81],"programmers\"":[82],"who":[83],"had":[84],"little":[85],"more":[86,91,124],"experience":[87],"(and":[88],"only":[89],"slightly":[90],"compensation)":[92],"than":[93],"students.":[95],"I":[96,113,146],"lucky":[98],"join":[100],"that":[101],"student":[105],"during":[106],"latter":[108],"years":[109],"project.":[112],"got":[114],"helpful":[115],"input":[116],"this":[118],"writeup":[119],"some":[121],"senior":[125],"but":[130],"any":[131,140],"errors":[132],"or":[133],"omissions":[134],"are":[135],"mine.":[136],"If":[137],"you":[138],"spot":[139],"such,":[141],"please":[142],"contact":[143],"me":[144],"will":[147],"try":[148],"fix":[150],"them.":[151]},"counts_by_year":[],"updated_date":"2026-03-11T14:59:36.786465","created_date":"2025-10-10T00:00:00"}