Skip navigation

Bookboon.com Last ned gratis eBøker og lærebøker

Choose a category

Go Faster!

The TransRelational™ Approach to DBMS Implementation

Go Faster!
4,6 (11 vurderinger)
ISBN: 978-87-7681-905-7
1 utgave
Sider : 287
  • Pris: 129,00 kr
  • Pris: €13,99
  • Pris: £13,99
  • Pris: ₹250
  • Pris: $13,99
  • Pris: 129,00 kr
  • Pris: 129,00 kr

Last ned GRATIS med 4 enkle steg…

Vi beklager, men for å laste ned våre bøker eller se våre videoer må du ha en nettleser som støtter JavaScript.
Kan vi friste med noen KOSTNADSFRIE e-bøker og relevante Bookboon-oppdateringer?
Etter å ha oppgitt e-postadressen blir en bekreftelsesmail sendt til din mailbox. Vennligst godkjenn den for å motta vår ukentlig eBok-oppdatering. Eventuell kontaktinformasjon som blir oppgitt, vil ikke bli oppgitt til noen tredjepart.
eLib
Lås opp ditt selskaps læringspotensial
Se demo

Korporat eBibliotek

Utforsk våre Firmaløsninger for ansattes læring

Dette er en Premium-eBok

Bookboon Premium - Få tilgang til over 800 eBøker - uten annonser

Du kan få gratis tilgang til dette i én måned - og 800 andre bøker med Premium-abonnementet. Du kan også kjøpe boken nedenfor

  • Start en 30 dagers gratis prøveperiode. Etter prøveperioden: 39,99 kr p/m
  • Start en 30 dagers gratis prøveperiode. Etter prøveperioden: €5,99 p/m
  • Start en 30 dagers gratis prøveperiode. Etter prøveperioden: £4,99 p/m
  • Start en 30 dagers gratis prøveperiode. Etter prøveperioden: ₹299 p/m
  • Start en 30 dagers gratis prøveperiode. Etter prøveperioden: $3,99 p/m
  • Start en 30 dagers gratis prøveperiode. Etter prøveperioden: 39,99 kr p/m
  • Start en 30 dagers gratis prøveperiode. Etter prøveperioden: 39,99 kr p/m
eLib
Lås opp ditt selskaps læringspotensial
Klikk her!

Korporat eBibliotek

Utforsk våre Firmaløsninger for ansattes læring

Om boken

  1. Beskrivelse
  2. Innhold

Beskrivelse

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.

In the database world, the relational model of database management was a massive leap forward, hailed as a breakthrough idea. Critics, however, pegged it as difficult, if not impossible, to implement in an efficient manner. Database administrators worked over the years to improve performance and have met with some success. Unfortunately, database management products have since become increasingly complex and unwieldy. But now there is another option.

Author C.J. Date, an expert in relational database technology, says the next “quantum leap” is the TransRelational Approach. This is a new and dramatically different way to implement the relational model for databases. The TransRelational Approach is faster than today’s SQL database products, with greater data independence. In addition, database administrators will find their jobs to be far simpler after implementing the TransRelational Approach.

Innhold

  1. Part I: Preliminaries
  2. “Go Faster!”
    1. Introduction
    2. TR Technology and the Relational Model
    3. Model vs. Implementation
    4. So How is it Done?
    5. Structure of the Book
  3. The Historical Context
    1. Introduction
    2. Ordering
    3. Indexing
    4. Pointer Chains
    5. Hashing
    6. Data Compression
    7. Concluding Remarks
  4. Three Levels of Abstraction
    1. Introduction
    2. The Relational Level
    3. The File Level
    4. The TR Level
  5. Part II: The Transrelational Model
  6. Core Concepts
    1. Introduction
    2. The Crucial Idea
    3. The Field Values Table
    4. The Record Reconstruction Table
    5. Building the Record Reconstruction Table
    6. The Record Reconstruction Table is not Unique
  7. Core Concepts (Continued)
    1. Introduction
    2. Some Remarks on Performance
    3. TR Operators
    4. Building the Record Reconstruction Table: An Alternative Approach
    5. Record Reconstruction Revisited
    6. Pointers are Field Value Surrogates
    7. The Field Values Table is a Directory
    8. Miscellaneous Implementation Alternatives
  8. Implementing the Update Operators
    1. Introduction
    2. Overview
    3. A Detailed Example
    4. The Swap Algorithm
    5. Using an Overflow Structure
    6. Some Remarks on Performance
  9. Major-to-Minor Orderings
    1. Introduction
    2. The Suppliers-Parts-Projects Example
    3. A Preferred Record Reconstruction Table
    4. Building a Preferred Record Reconstruction Table
    5. Another Example
    6. Analysis
  10. Condensed Columns
    1. Introduction
    2. Condensing the Field Values Table
    3. Implications for Record Reconstruction
    4. Expanding the Record Reconstruction Table
    5. Further Space-Saving Techniques
  11. Merged Columns
    1. Introduction
    2. The Bill-of-Materials Example
    3. A Foreign Key Example
    4. Another Kind of Merging
    5. Concluding Remarks
  12. Implementing the Relational Operators
    1. Introduction
    2. Restrict
    3. Project
    4. Extend
    5. Summarize
    6. Join
    7. Union, Intersect, and Difference
    8. Materializing Derived Relations
    9. A Note Regarding Optimization
    10. A Note Regarding Constraints
    11. What's Missing?
  13. Part III: Disk-Based Implementation
  14. General Disk Considerations
    1. Introduction
    2. What's the Problem?
    3. Addressing the Problem
    4. Compressing the Field Values Table
    5. Compressing the Record Reconstruction Table
    6. Minimizing Seeks
  15. File Factoring
    1. Introduction
    2. A Simple Example
    3. Elaborating on the Example
    4. Further Possibilities
    5. Record Reconstructio
    6. Additional Benefits
  16. File Banding
    1. Introduction
    2. A Simple Example
    3. Elaborating on the Example
    4. How it's Really Done
    5. Controlled Redundancy
  17. Stars and Zigzags
    1. Introduction
    2. A Simple Example
    3. Elaborating on the Example
    4. What Happens on Disk
    5. Controlled Redundancy
  18. Part IV: Conclusion
  19. The Future Looks Bright Ahead
    1. Introduction
    2. The TR Model Summarized
    3. Analysis
    4. A Review of the Benefits
    5. Possible Future Developments
  20. Appendixes
  21. Appendix A: Exercises
  22. Appendix B: References and Bibliography
This website uses cookies to improve user experience. By using our website you consent to all cookies in accordance with EU regulation.