Work

Improving rule processing in Postgres database management system

Year: 1991
Type: conference-paper
Abstract: This paper suggests methods to improve the performance of the rule subsystem of a next-generation relational database management system, called Postgres.Specifically, it will be shown that we can decompose some rules to get further optimization.Then, we will discuss how we can handle the situation when some fields are changed from indexable to nonindexable or vice versa.Finally, it is suggested that a new command be provided so that we can change indexable characteristics of more than one field at a time.Keywords: decomposition, rule processing, early or late evaluation, source and target field, read-and write-set tag, indexable characteristics, optimization, random and priority semantics, mutually disjoint conditions In Section 1, Postgres rule processing will be introduced.Then, in Sections 2 and 3, decomposing rules either by splitting their conditions or by splitting their target fields will be discussed, respectively, and some general comments about rule decomposition will be made in Section 4. We will discuss how we can change indexable characteristics of fields in Section 5. Finally, conclusions and recommendations will be given in Section 6.
Language: English
Open Access status: bronze
OpenAlex ID: W2017807210
FWCI:
Cites: 2
Cited by:
Related to: 10