Check nearby libraries
Buy this book
Use Go Faster! The TransRelational™ Approach to DBMS Implementation to Improve the Performance of Your Database
You can download the book for free via the link below.
Publish Date
2013
Publisher
Bookboon
Check nearby libraries
Buy this book
Showing 1 featured edition. View all 1 editions?
Edition | Availability |
---|---|
1
Go Faster! The TransRelational™ Approach to DBMS Implementation
2013, Bookboon
8776819051 9788776819057
|
aaaa
Libraries near you:
WorldCat
|
Book Details
Table of Contents
Innhold
Part I: Preliminaries
“Go Faster!”
Introduction
TR Technology and the Relational Model
Model vs. Implementation
So How is it Done?
Structure of the Book
The Historical Context
Introduction
Ordering
Indexing
Pointer Chains
Hashing
Data Compression
Concluding Remarks
Three Levels of Abstraction
Introduction
The Relational Level
The File Level
The TR Level
Part II: The Transrelational Model
Core Concepts
Introduction
The Crucial Idea
The Field Values Table
The Record Reconstruction Table
Building the Record Reconstruction Table
The Record Reconstruction Table is not Unique
Core Concepts (Continued)
Introduction
Some Remarks on Performance
TR Operators
Building the Record Reconstruction Table: An Alternative Approach
Record Reconstruction Revisited
Pointers are Field Value Surrogates
The Field Values Table is a Directory
Miscellaneous Implementation Alternatives
Implementing the Update Operators
Introduction
Overview
A Detailed Example
The Swap Algorithm
Using an Overflow Structure
Some Remarks on Performance
Major-to-Minor Orderings
Introduction
The Suppliers-Parts-Projects Example
A Preferred Record Reconstruction Table
Building a Preferred Record Reconstruction Table
Another Example
Analysis
Condensed Columns
Introduction
Condensing the Field Values Table
Implications for Record Reconstruction
Expanding the Record Reconstruction Table
Further Space-Saving Techniques
Merged Columns
Introduction
The Bill-of-Materials Example
A Foreign Key Example
Another Kind of Merging
Concluding Remarks
Implementing the Relational Operators
Introduction
Restrict
Project
Extend
Summarize
Join
Union, Intersect, and Difference
Materializing Derived Relations
A Note Regarding Optimization
A Note Regarding Constraints
What's Missing?
Part III: Disk-Based Implementation
General Disk Considerations
Introduction
What's the Problem?
Addressing the Problem
Compressing the Field Values Table
Compressing the Record Reconstruction Table
Minimizing Seeks
File Factoring
Introduction
A Simple Example
Elaborating on the Example
Further Possibilities
Record Reconstructio
Additional Benefits
File Banding
Introduction
A Simple Example
Elaborating on the Example
How it's Really Done
Controlled Redundancy
Stars and Zigzags
Introduction
A Simple Example
Elaborating on the Example
What Happens on Disk
Controlled Redundancy
Part IV: Conclusion
The Future Looks Bright Ahead
Introduction
The TR Model Summarized
Analysis
A Review of the Benefits
Possible Future Developments
Appendixes
Appendix A: Exercises
Appendix B: References and Bibliography
ID Numbers
Links outside Open Library
Community Reviews (0)
Feedback?History
- Created December 8, 2015
- 4 revisions
Wikipedia citation
×CloseCopy and paste this code into your Wikipedia page. Need help?
August 22, 2020 | Edited by ISBNbot2 | normalize ISBN |
December 8, 2015 | Edited by Alice Kirk | Edited without comment. |
December 8, 2015 | Edited by Alice Kirk | Added new cover |
December 8, 2015 | Created by Alice Kirk | Added new book. |