In this paper, we propose a data mining-based approach to public buffe management in distributed database systems where database buffers are organized into tow areas: public and private. While the private buffer areas ocntain pages to be updated by particular users, te public buffer area contains pages shared among users from differnet sites. Different from traditional buffer management strategies where limited knowledge of user access patterns is used, the proposed apporach discrovers knowledge from page access sequences of suer transactions and uses it to guide public buffer placement and replacement. The knowledge to be discovered and the discovery algortihms are discussed. The effectiveness of the proposed approach was investigated through a simulation study. The results indicate that with the help of the discovered knowledge, the public buffer hit ratio can be improved significantly.
展开▼