1 / 15

Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System

Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System. Introduction. Current environment Complex database systems Numerous functionalities. Problems. Numerous functionalities Complex interfaces High level SQL Unpredictable performance Tuning problems

vida
Download Presentation

Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Rethinking Database System Architecture:Towards a Self-tuning RISC-style Database System Emre Yenier - 9802389

  2. Introduction • Current environment • Complex database systems • Numerous functionalities Emre Yenier - 9802389

  3. Problems • Numerous functionalities • Complex interfaces • High level SQL • Unpredictable performance • Tuning problems • Need for better (thinner) systems • Difficulty in researches Emre Yenier - 9802389

  4. Solution • RISC Style Architecture • Smaller, specialized components • Narrow interfaces • Smaller footprints • More suitable for tuning Emre Yenier - 9802389

  5. Previous Trials • Common problem causes • Universality • Cost • Transparency • Resource sharing Emre Yenier - 9802389

  6. Previous Trials (Cont.) • Concepts • DB system generators • Extensible kernel systems • Unbundled technology Emre Yenier - 9802389

  7. Proposal • Query Processor • Single table selection processor • Select – Project – Join (SPJ) processor • SQL Processor Emre Yenier - 9802389

  8. Proposal (Cont.) • Storage Manager • Disk management • Caching • Logging • Recovery • Concurrency control • Index manager Emre Yenier - 9802389

  9. Considerations • Need for more building blocks • Avoid complexity • Identify functionality • Identify interfaces • Each block is self-tuning • Each block has predictable performance • Performance loss is tolerable Emre Yenier - 9802389

  10. Required Actions • Support limited data types • Leave SQL • Separate resources • Preconfigure Emre Yenier - 9802389

  11. Prerequisites • Universal glue • Functionality selection • Self-tuning Emre Yenier - 9802389

  12. Research Opportunities • Implementation of proposed system Emre Yenier - 9802389

  13. Conclusion • Database systems became uncontrollable • RISC style architectures can have impact on the future of database systems Emre Yenier - 9802389

  14. Questions ? Emre Yenier - 9802389

  15. Thank You… Emre Yenier - 9802389

More Related