Abstract
Cache management has strong impact on database query performance. Literature survey has shown, tuning the database cache may improve performance significantly. Materialization of intermediates in database cache plays vital role in improving the response time. We propose an enhancement to a column store database structure by building additional intelligence in the form of an adaptive and efficient query cache, called KPCS (Keep Pool Column Store). The proposed algorithm is evaluated against the TPC-H schema to demonstrate effectiveness in terms of significant performance gains.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
