Attribute Partitioning in a Self-adaptive Relational Data Base Systems

Abstract

One technique that is sometimes employed to enhance the performance of a data base management system is known as attribute partitioning. This is the process of dividing the attributes of a file into subfiles that are stored separately. By storing together those attributes that are frequently requested together by transactions, and by separating those that are not, attribute partitioning can reduce the number of pages that must be transferred from secondary storage to primary memory in order to process a transaction.