Go Faster! The TransRelational™ Approach to DBMS Implementation

  • 0 Ratings
  • 0 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
  • 0 Want to read
  • 0 Currently reading
  • 0 Have read

Buy this book

Last edited by ISBNbot2
August 22, 2020 | History

Go Faster! The TransRelational™ Approach to DBMS Implementation

  • 0 Ratings
  • 0 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

You can download the book for free via the link below.

Publish Date
Publisher
Bookboon

Buy this book

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

Add another edition?

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

Open Library
OL25879370M
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 / OPDS | Wikipedia citation
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.