About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Publication
IEEE TKDE
Paper
An Evaluation of Starburst’s Memory Resident Storage Component
Abstract
As part of the Starburst extensible database oroiect. we have designed and implemented a memory resident storage component that can coexist along side traditional disk-oriented storage components. The memory resident storage component shares the code of Starburst'*s common services, such as query optimization, plan generation, query evaluation, record manipu-lation, and transaction management. In this paper, we describe the design of Starburst’s memory resident storage component, contrast it with Starburst’s default disk-oriented storage component, and compare the performance of the two storage components using the Wisconsin Benchmarks. Our results show that a memory resident storage component can perform significantly better than a disk-oriented storage component, even when the disk-oriented storage component has all of its data cached in memory. The benchmark results show that, by using memory resident techniques, overall query execution can be improved by up to a factor of four. © 1992, IEEE. All rights reserved.