{"id":"https://openalex.org/W2017807210","doi":"https://doi.org/10.1145/327164.328644","title":"Improving rule processing in Postgres database management system","display_name":"Improving rule processing in Postgres database management system","alternate_titles":[],"publication_year":1991,"publication_date":"1991-01-01","ids":{"openalex":"https://openalex.org/W2017807210","doi":"https://doi.org/10.1145/327164.328644","mag":"2017807210"},"language":"en","primary_location":{"id":"doi:10.1145/327164.328644","doi":"https://doi.org/10.1145/327164.328644","is_oa":true,"landing_page_url":"https://doi.org/10.1145/327164.328644","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/327164.328644","source":{"id":"https://openalex.org/S7407087687","display_name":"ACM Annual Conference on Computer Science (CSC)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 19th annual conference on Computer Science - CSC '91","raw_type":"proceedings-article"},"parent_works":[],"lineage":["https://openalex.org/W2017807210"],"child_works_count":0,"type":"conference-paper","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/327164.328644","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5047190433","display_name":"Kejongsok Kim","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I57328836","display_name":"North Dakota State University","ror":"https://ror.org/05h1bnb22","country_code":"US","type":"education","lineage":["https://openalex.org/I57328836"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Kejongsok Kim","raw_affiliation_strings":["Department of Computer Science, North Dakota State University, Fargo, ND","Department of Computer Science, North Dakota, State University, Fargo, ND#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, North Dakota State University, Fargo, ND","institution_ids":["https://openalex.org/I57328836"]},{"raw_affiliation_string":"Department of Computer Science, North Dakota, State University, Fargo, ND#TAB#","institution_ids":["https://openalex.org/I57328836"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5047190433"],"corresponding_institution_ids":["https://openalex.org/I57328836"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"506","last_page":"514"},"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.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":0.0,"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.8370000123977661},{"id":"https://openalex.org/keywords/database-triggers","display_name":"database triggers","score":0.7900000214576721},{"id":"https://openalex.org/keywords/rule-processing","display_name":"rule processing","score":0.9010000228881836},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.4830000102519989}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.759003221988678},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6064881682395935}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/327164.328644","doi":"https://doi.org/10.1145/327164.328644","is_oa":true,"landing_page_url":"https://doi.org/10.1145/327164.328644","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/327164.328644","source":{"id":"https://openalex.org/S7407087687","display_name":"ACM Annual Conference on Computer Science (CSC)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 19th annual conference on Computer Science - CSC '91","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/327164.328644","doi":"https://doi.org/10.1145/327164.328644","is_oa":true,"landing_page_url":"https://doi.org/10.1145/327164.328644","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/327164.328644","source":{"id":"https://openalex.org/S7407087687","display_name":"ACM Annual Conference on Computer Science (CSC)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 19th annual conference on Computer Science - CSC '91","raw_type":"proceedings-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2017807210.pdf","grobid_xml":"https://content.openalex.org/works/W2017807210.grobid-xml"},"referenced_works_count":2,"referenced_works":["https://openalex.org/W2072627547","https://openalex.org/W2116133297"],"related_works":["https://openalex.org/W2066640470","https://openalex.org/W2116133297","https://openalex.org/W4241318929","https://openalex.org/W1980839297","https://openalex.org/W7052423565","https://openalex.org/W2307099048","https://openalex.org/W7129277122","https://openalex.org/W1967087829","https://openalex.org/W199780592","https://openalex.org/W2090636890"],"abstract_inverted_index":{"This":[0],"paper":[1],"suggests":[2],"methods":[3],"to":[4,31,51],"improve":[5],"the":[6,9,42],"performance":[7],"of":[8,12,72,157],"rule":[10,81,108,140],"subsystem":[11],"a":[13,60,78],"next-generation":[14],"relational":[15],"database":[16],"management":[17],"system,":[18],"called":[19],"Postgres.Specifically,":[20],"it":[21,56],"will":[22,36,110,131,142,149,166],"be":[23,63,111,132,143,167],"shown":[24],"that":[25,59,66],"we":[26,35,39,67,152],"can":[27,40,68,153],"decompose":[28],"some":[29,45,136],"rules":[30,119],"get":[32],"further":[33],"optimization.Then,":[34],"discuss":[37,150],"how":[38,151],"handle":[41],"situation":[43],"when":[44],"fields":[46,130,158],"are":[47],"changed":[48],"from":[49],"indexable":[50,70,94,155],"nonindexable":[52],"or":[53,84,125],"vice":[54],"versa.Finally,":[55],"is":[57],"suggested":[58],"new":[61],"command":[62],"provided":[64],"so":[65],"change":[69,154],"characteristics":[71,156],"more":[73],"than":[74],"one":[75],"field":[76],"at":[77],"time.Keywords:":[79],"decomposition,":[80],"processing,":[82],"early":[83],"late":[85],"evaluation,":[86],"source":[87],"and":[88,98,116,135,164],"target":[89,129],"field,":[90],"read-and":[91],"write-set":[92],"tag,":[93],"characteristics,":[95],"optimization,":[96],"random":[97],"priority":[99],"semantics,":[100],"mutually":[101],"disjoint":[102],"conditions":[103,124],"In":[104],"Section":[105,146,160,170],"1,":[106],"Postgres":[107],"processing":[109],"introduced.Then,":[112],"in":[113,145,159,169],"Sections":[114],"2":[115],"3,":[117],"decomposing":[118],"either":[120],"by":[121,126],"splitting":[122,127],"their":[123,128],"discussed,":[133],"respectively,":[134],"general":[137],"comments":[138],"about":[139],"decomposition":[141],"made":[144],"4.":[147],"We":[148],"5.":[161],"Finally,":[162],"conclusions":[163],"recommendations":[165],"given":[168],"6.":[171]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2017807210","counts_by_year":[],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2016-06-24T00:00:00"}
