Go Faster! The TransRelational™ Approach to DBMS Implementation

  • 0 Ratings
  • 1 Want to read
  • 0 Currently reading
  • 0 Have read
Not in Library

My Reading Lists:

Create a new list

Check-In

×Close
Add an optional check-in date. Check-in dates are used to track yearly reading goals.
Today

  • 0 Ratings
  • 1 Want to read
  • 0 Currently reading
  • 0 Have read

Buy this book

Last edited by Alice Kirk
April 29, 2015 | History

Go Faster! The TransRelational™ Approach to DBMS Implementation

  • 0 Ratings
  • 1 Want to read
  • 0 Currently reading
  • 0 Have read

Use Go Faster! The TransRelational™ Approach to DBMS Implementation to Improve the Performance of Your Database

Go Faster! The TransRelational™ Approach to DBMS Implementation is an ebook to download free of charge.

You can download the book via the link below.

Publish Date
Publisher
Bookboon.com

Buy this book

Edition Availability
Cover of: Go Faster! The TransRelational™ Approach to DBMS Implementation

Add another edition?

Book Details


Table of Contents

Content
1. Part I: Preliminaries
2. “Go Faster!”
2.1. Introduction
2.2. TR Technology and the Relational Model
2.3. Model vs. Implementation
2.4. So How is it Done?
2.5. Structure of the Book
3. The Historical Context
3.1. Introduction
3.2. Ordering
3.3. Indexing
3.4. Pointer Chains
3.5. Hashing
3.6. Data Compression
3.7. Concluding Remarks
4. Three Levels of Abstraction
4.1. Introduction
4.2. The Relational Level
4.3. The File Level
4.4. The TR Level
5. Part II: The Transrelational Model
6. Core Concepts
6.1. Introduction
6.2. The Crucial Idea
6.3. The Field Values Table
6.4. The Record Reconstruction Table
6.5. Building the Record Reconstruction Table
6.6. The Record Reconstruction Table is not Unique
7. Core Concepts (Continued)
7.1. Introduction
7.2. Some Remarks on Performance
7.3. TR Operators
7.4. Building the Record Reconstruction Table: An Alternative Approach
7.5. Record Reconstruction Revisited
7.6. Pointers are Field Value Surrogates
7.7. The Field Values Table is a Directory
7.8. Miscellaneous Implementation Alternatives
8. Implementing the Update Operators
8.1. Introduction
8.2. Overview
8.3. A Detailed Example
8.4. The Swap Algorithm
8.5. Using an Overflow Structure
8.6. Some Remarks on Performance
9. Major-to-Minor Orderings
9.1. Introduction
9.2. The Suppliers-Parts-Projects Example
9.3. A Preferred Record Reconstruction Table
9.4. Building a Preferred Record Reconstruction Table
9.5. Another Example
9.6. Analysis
10. Condensed Columns
10.1. Introduction
10.2. Condensing the Field Values Table
10.3. Implications for Record Reconstruction
10.4. Expanding the Record Reconstruction Table
10.5. Further Space-Saving Techniques
11. Merged Columns
11.1. Introduction
11.2. The Bill-of-Materials Example
11.3. A Foreign Key Example
11.4. Another Kind of Merging
11.5. Concluding Remarks
12. Implementing the Relational Operators
12.1. Introduction
12.2. Restrict
12.3. Project
12.4. Extend
12.5. Summarize
12.6. Join
12.7. Union, Intersect, and Difference
12.8. Materializing Derived Relations
12.9. A Note Regarding Optimization
12.10. A Note Regarding Constraints
12.11. What's Missing?
13. Part III: Disk-Based Implementation
14. General Disk Considerations
14.1. Introduction
14.2. What's the Problem?
14.3. Addressing the Problem
14.4. Compressing the Field Values Table
14.5. Compressing the Record Reconstruction Table
14.6. Minimizing Seeks
15. File Factoring
15.1. Introduction
15.2. A Simple Example
15.3. Elaborating on the Example
15.4. Further Possibilities
15.5. Record Reconstructio
15.6. Additional Benefits
16. File Banding
16.1. Introduction
16.2. A Simple Example
16.3. Elaborating on the Example
16.4. How it's Really Done
16.5. Controlled Redundancy
17. Stars and Zigzags
17.1. Introduction
17.2. A Simple Example
17.3. Elaborating on the Example
17.4. What Happens on Disk
17.5. Controlled Redundancy
18. Part IV: Conclusion
19. The Future Looks Bright Ahead
19.1. Introduction
19.2. The TR Model Summarized
19.3. Analysis
19.4. A Review of the Benefits
19.5. Possible Future Developments
20. Appendixes
21. Appendix A: Exercises
22. Appendix B: References and Bibliography

ID Numbers

Open Library
OL25672448M
ISBN 13
9788776819057

Links outside Open Library

Community Reviews (0)

Feedback?
No community reviews have been submitted for this work.

Lists

This work does not appear on any lists.

History

Download catalog record: RDF / JSON
April 29, 2015 Edited by Alice Kirk Edited without comment.
April 29, 2015 Created by Alice Kirk Added new book.