{"id":"https://openalex.org/W1573833643","doi":"https://doi.org/10.21236/ada184251","title":"The POSTGRES Data Model","display_name":"The POSTGRES Data Model","publication_year":1987,"publication_date":"1987-08-06","ids":{"openalex":"https://openalex.org/W1573833643","doi":"https://doi.org/10.21236/ada184251","mag":"1573833643"},"language":"en","primary_location":{"id":"doi:10.21236/ada184251","doi":"https://doi.org/10.21236/ada184251","is_oa":false,"landing_page_url":"https://doi.org/10.21236/ada184251","pdf_url":null,"source":{"id":"https://openalex.org/S4406923043","display_name":"Defense Technical Information Center (DTIC)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"OSD or Non-Service DoD Agency","raw_type":"report"},"volume":null,"type":"report","is_traditional":false,"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/A5113735960","display_name":"Lawrence A. Rowe","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Lawrence A. Rowe","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5074724644","display_name":"Michael R Stonebraker","orcid":"https://orcid.org/0000-0001-9184-9058","observed_orcids":["https://orcid.org/0000-0001-9184-9058"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Michael R. Stonebraker","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":227,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994999766349792,"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.9994999766349792,"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/T11106","display_name":"Data Management and Algorithms","score":0.00019999999494757503,"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/T10126","display_name":"Logic, programming, and type systems","score":9.999999747378752e-05,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/postgres","display_name":"Postgres","score":0.9269999861717224},{"id":"https://openalex.org/keywords/data-model","display_name":"data model","score":0.7250000238418579},{"id":"https://openalex.org/keywords/relational-model","display_name":"relational model","score":0.6759999990463257},{"id":"https://openalex.org/keywords/abstract-data-types","display_name":"abstract data types","score":0.9649999737739563},{"id":"https://openalex.org/keywords/object-oriented-data-modeling","display_name":"object-oriented data modeling","score":0.9100000262260437},{"id":"https://openalex.org/keywords/aggregation","display_name":"aggregation","score":0.8289999961853027},{"id":"https://openalex.org/keywords/generalization","display_name":"generalization","score":0.9909999966621399},{"id":"https://openalex.org/keywords/complex-objects","display_name":"complex objects","score":0.4690000116825104},{"id":"https://openalex.org/keywords/database-management-systems","display_name":"database management systems","score":0.5329999923706055}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.47431182861328125}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.21236/ada184251","doi":"https://doi.org/10.21236/ada184251","is_oa":false,"landing_page_url":"https://doi.org/10.21236/ada184251","pdf_url":null,"source":{"id":"https://openalex.org/S4406923043","display_name":"Defense Technical Information Center (DTIC)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"OSD or Non-Service DoD Agency","raw_type":"report"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W152374291","https://openalex.org/W1487932592","https://openalex.org/W1530586715","https://openalex.org/W1570983218","https://openalex.org/W1595893739","https://openalex.org/W1608295716","https://openalex.org/W1876014274","https://openalex.org/W1977101058","https://openalex.org/W1985324218","https://openalex.org/W2022843938","https://openalex.org/W2027750453","https://openalex.org/W2039601877","https://openalex.org/W2072627547","https://openalex.org/W2095219277","https://openalex.org/W2130474477","https://openalex.org/W2131300191","https://openalex.org/W2134350535","https://openalex.org/W2145343598","https://openalex.org/W2146170930","https://openalex.org/W2147869465","https://openalex.org/W2158655585","https://openalex.org/W2163765478","https://openalex.org/W2163832616","https://openalex.org/W2165467455","https://openalex.org/W2495528278","https://openalex.org/W2912093648"],"related_works":["https://openalex.org/W2401408574","https://openalex.org/W7071152622","https://openalex.org/W302582241","https://openalex.org/W7095205940","https://openalex.org/W4237407586","https://openalex.org/W7095562358","https://openalex.org/W2608242168","https://openalex.org/W174806611","https://openalex.org/W2162064942","https://openalex.org/W192026941"],"abstract_inverted_index":{"Abstract":[0],":":[1],"This":[2],"paper":[3],"describes":[4],"the":[5,19],"data":[6,25,37,39,62],"model":[7,26,30],"for":[8],"POSTGRES,":[9],"a":[10,28,55],"next-generation":[11],"extensible":[12],"database":[13],"management":[14],"system":[15],"being":[16],"developed":[17],"at":[18],"University":[20],"of":[21,40,58],"California":[22],"StR86.":[23],"The":[24],"is":[27],"relational":[29],"that":[31,76],"has":[32],"been":[33],"extended":[34],"with":[35,71],"abstract":[36],"types,":[38],"type":[41],"procedure,":[42],"and":[43,45,60,67,74],"attribute":[44],"procedure":[46],"inheritance.":[47],"These":[48],"mechanisms":[49],"can":[50],"be":[51],"used":[52],"to":[53],"simulate":[54],"wide":[56],"variety":[57],"semantic":[59],"object-oriented":[61],"modeling":[63],"constructs":[64],"including":[65],"aggregation":[66],"generalization,":[68],"complex":[69],"objects":[70],"shared":[72],"subobjects,":[73],"attributes":[75],"reference":[77],"tuples":[78],"in":[79],"other":[80],"relations.":[81]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2026-11-12T12:28:57.059296","created_date":"2016-06-24T00:00:00"}