High-Performance Java Persistence
$29.95
Minimum price
$34.95
Suggested price

High-Performance Java Persistence

Get the most out of your persistence layer
  • 2,426

    Readers

  • 461

    Pages

  • 99,702

    Words

  • English

  • PDF

  • EPUB

  • MOBI

  • WEB

About the Book

For the ultimate learning experience, you should definitely enroll in my

High-Performance Java Persistence video courses.

If you're interested in a print copy, then check out the Paperback version on Amazon, Amazon.co.uk, Amazon.de or Amazon.fr.

This book is a journey into Java data access performance tuning. From connection management, to batch updates, fetch sizes and concurrency control mechanisms, it unravels the inner workings of the most common Java data access frameworks.

The first part aims to reduce the gap between application developers and database administrators. For this reason, it covers both JDBC and the database fundamentals that are of paramount importance when reducing transaction response times. In this first part, you'll learn about connection management, batch updates, statement caching, result set fetching and database transactions.

The second part demonstrates how you can take advantage of JPA and Hibernate without compromising application performance. In this second part, you'll learn about the most efficient Hibernate mappings (basic types, associations, inheritance), fetching best practices, caching and concurrency control mechanisms.

The third part is dedicated to jOOQ and its powerful type-safe querying capabilities, like window functions, common table expressions, UPSERT, stored procedures and database functions.

About the Author

Vlad Mihalcea
Vlad Mihalcea

Vlad Mihalcea is a Hibernate Developer Advocate working for Red Hat, passionate about concurrency challenges, high-performance enterprise solutions and online transaction processing.

Whenever he finds something interesting, he likes to share it on his personal blog. He believes in Open Source Software and he thinks every developer should get involved, one way or the other.

If he doesn’t find a suitable tool for a job, he takes initiative and starts a new open source project, like FlexyPool.

Packages

The Book

  • English

  • PDF

  • EPUB

  • MOBI

  • WEB

$29.95
Minimum price
$34.95
Suggested price
25% discount - Pack of 3

This package is for 3 copies of the "High-Performance Java Persistence" at a 25% discount.

  • English

  • PDF

  • EPUB

  • MOBI

  • WEB

$64.95
Minimum price
$74.95
Suggested price

Reader Testimonials

Lukas Eder
Lukas Eder

Java Champion, founder and CEO of Data Geekery GmbH, the company behind jOOQ

This book is a must-read for everyone aiming to push their relational databases to the limit with their Java application.

Rafael Winterhalter
Rafael Winterhalter

Java Champion, creator of Byte Buddy

There is no resource that better summarizes the performance implications of using JDBC, either directly or via JPA and Hibernate. If you are talking to a database on the JVM, add this book to your reading shelf.

Markus Eisele
Markus Eisele

Java Champion, Developer Advocate at Lightbend

Object to database mapping is one of the core requirements in many Java EE related projects. And the available frameworks make it easy for their users to get started. But as soon as you hit particular requirements around distributed transactions or performance you realise how much database and framework knowledge is required to implement them. Vlad made his insane experience available in an easy-to-read book. If you are dealing with JPA or Hibernate, this book is a must read.

Antonio Goncalves
Antonio Goncalves

Java Champion, co-creator of AllCraft.io

Writing a book is difficult, but writing a book about performance and persistence is a real challenge. If you want to understand how locking, sharding, replication, database concurrency control work, then this book is for you. Vlad gives you plenty of tips and tricks on Hibernate, helping you diagnose your performance issues (e.g. mapping, fetching, or caching). I learn a lot by reading his book and I highly recommend it if you use relational databases and ORM tools such as Hibernate.

Eugen Paraschiv
Eugen Paraschiv

Owner of Baeldung, Spring courses author

Good books on persistence are few and far between. This is something else - it's deeply researched but also entirely practical. I'm basically using it as a reference for everything SQL. Plus, the transaction chapter is a must read.

Simeon Malchev
Simeon Malchev

Software engineer & enthusiast, creator of Vibur DBCP

This book is a highly recommended resource for every developer who is serious about learning and mastering the difficult topic of designing and implementing high performance Java database applications. The book covers in detail the performance aspect of the plain JDBC and Hibernate programming, explains the theoretical and practical implications of the database transactions, and discusses some rare topics such as the database connection pool sizing and statement caching.

Table of Contents

  •  
    • Preface
      • The database server and the connectivity layer
      • The application data access layer
        • The ORM framework
        • The native query builder framework
      • Video Course
        • Testimonials
  • I JDBC and Database Essentials
    • 1. Performance and Scaling
      • 1.1 Response time and throughput
      • 1.2 Database connections boundaries
      • 1.3 Scaling up and scaling out
        • 1.3.1 Master-Slave replication
        • 1.3.2 Multi-Master replication
        • 1.3.3 Sharding
    • 2. JDBC Connection Management
      • 2.1 DriverManager
      • 2.2 DataSource
        • 2.2.1 Why is pooling so much faster?
      • 2.3 Queuing theory capacity planning
      • 2.4 Practical database connection provisioning
        • 2.4.1 A real-life connection pool monitoring example
          • 2.4.1.1 Concurrent connection request count metric
          • 2.4.1.2 Concurrent connection count metric
          • 2.4.1.3 Maximum pool size metric
          • 2.4.1.4 Connection acquisition time metric
          • 2.4.1.5 Retry attempts metric
          • 2.4.1.6 Overall connection acquisition time metric
          • 2.4.1.7 Connection lease time metric
    • 3. Batch Updates
      • 3.1 Batching Statements
      • 3.2 Batching PreparedStatements
        • 3.2.1 Choosing the right batch size
        • 3.2.2 Bulk processing
      • 3.3 Retrieving auto-generated keys
        • 3.3.1 Sequences to the rescue
    • 4. Statement Caching
      • 4.1 Statement lifecycle
        • 4.1.1 Parser
        • 4.1.2 Optimizer
          • 4.1.2.1 Execution plan visualization
        • 4.1.3 Executor
      • 4.2 Caching performance gain
      • 4.3 Server-side statement caching
        • 4.3.1 Bind-sensitive execution plans
      • 4.4 Client-side statement caching
    • 5. ResultSet Fetching
      • 5.1 ResultSet scrollability
      • 5.2 ResultSet changeability
      • 5.3 ResultSet holdability
      • 5.4 Fetching size
      • 5.5 ResultSet size
        • 5.5.1 Too many rows
          • 5.5.1.1 SQL limit clause
          • 5.5.1.2 JDBC max rows
          • 5.5.1.3 Less is more
        • 5.5.2 Too many columns
    • 6. Transactions
      • 6.1 Atomicity
      • 6.2 Consistency
      • 6.3 Isolation
        • 6.3.1 Concurrency control
          • 6.3.1.1 Two-phase locking
          • 6.3.1.2 Multi-Version Concurrency Control
        • 6.3.2 Phenomena
          • 6.3.2.1 Dirty write
          • 6.3.2.2 Dirty read
          • 6.3.2.3 Non-repeatable read
          • 6.3.2.4 Phantom read
          • 6.3.2.5 Read skew
          • 6.3.2.6 Write skew
          • 6.3.2.7 Lost update
        • 6.3.3 Isolation levels
          • 6.3.3.1 Read Uncommitted
          • 6.3.3.2 Read Committed
          • 6.3.3.3 Repeatable Read
          • 6.3.3.4 Serializable
      • 6.4 Durability
      • 6.5 Read-only transactions
        • 6.5.1 Read-only transaction routing
      • 6.6 Transaction boundaries
        • 6.6.1 Distributed transactions
          • 6.6.1.1 Two-phase commit
        • 6.6.2 Declarative transactions
      • 6.7 Application-level transactions
        • 6.7.1 Pessimistic and optimistic locking
          • 6.7.1.1 Pessimistic locking
          • 6.7.1.2 Optimistic locking
  • II JPA and Hibernate
    • 7. Why JPA and Hibernate matter
      • 7.1 The impedance mismatch
      • 7.2 JPA vs. Hibernate
      • 7.3 Schema ownership
      • 7.4 Entity state transitions
      • 7.5 Write-based optimizations
      • 7.6 Read-based optimizations
      • 7.7 Wrap-up
    • 8. Connection Management and Monitoring
      • 8.1 JPA connection management
      • 8.2 Hibernate connection providers
        • 8.2.1 DriverManagerConnectionProvider
        • 8.2.2 C3P0ConnectionProvider
        • 8.2.3 HikariCPConnectionProvider
        • 8.2.4 DatasourceConnectionProvider
        • 8.2.5 Connection release modes
      • 8.3 Monitoring connections
        • 8.3.1 Hibernate statistics
          • 8.3.1.1 Customizing statistics
      • 8.4 Statement logging
        • 8.4.1 Statement formatting
        • 8.4.2 Statement-level comments
        • 8.4.3 Logging parameters
          • 8.4.3.1 DataSource-proxy
          • 8.4.3.2 P6Spy
    • 9. Mapping Types and Identifiers
      • 9.1 Types
        • 9.1.1 Primitive types
        • 9.1.2 String types
        • 9.1.3 Date and Time types
        • 9.1.4 Numeric types
        • 9.1.5 Binary types
        • 9.1.6 UUID types
        • 9.1.7 Other types
        • 9.1.8 Custom types
      • 9.2 Identifiers
        • 9.2.1 UUID identifiers
          • 9.2.1.1 The assigned generator
        • 9.2.2 The legacy UUID generator
          • 9.2.2.1 The newer UUID generator
        • 9.2.3 Numerical identifiers
          • 9.2.3.1 Identity generator
          • 9.2.3.2 Sequence generator
          • 9.2.3.3 Table generator
          • 9.2.3.4 Optimizers
            • 9.2.3.4.1 The hi/lo algorithm
            • 9.2.3.4.2 The default sequence identifier generator
            • 9.2.3.4.3 The default table identifier generator
            • 9.2.3.4.4 The pooled optimizer
            • 9.2.3.4.5 The pooled-lo optimizer
          • 9.2.3.5 Optimizer gain
            • 9.2.3.5.1 Sequence generator performance gain
            • 9.2.3.5.2 Table generator performance gain
          • 9.2.3.6 Identifier generator performance
    • 10. Relationships
      • 10.1 Relationship types
      • 10.2 @ManyToOne
      • 10.3 @OneToMany
        • 10.3.1 Bidirectional @OneToMany
        • 10.3.2 Unidirectional @OneToMany
        • 10.3.3 Ordered unidirectional @OneToMany
        • 10.3.4 @OneToMany with @JoinColumn
        • 10.3.5 Unidirectional @OneToMany Set
      • 10.4 @ElementCollection
        • 10.4.1 @ElementCollection List
        • 10.4.2 @ElementCollection Set
      • 10.5 @OneToOne
        • 10.5.1 Unidirectional @OneToOne
        • 10.5.2 Bidirectional @OneToOne
      • 10.6 @ManyToMany
        • 10.6.1 Unidirectional @ManyToMany List
        • 10.6.2 Unidirectional @ManyToMany Set
        • 10.6.3 Bidirectional @ManyToMany
        • 10.6.4 The @OneToMany alternative
      • 10.7 Hypersistence Optimizer
        • 10.7.1 Testimonials
    • 11. Inheritance
      • 11.1 Single table
        • 11.1.1 Data integrity constraints
      • 11.2 Join table
      • 11.3 Table-per-class
      • 11.4 Mapped superclass
    • 12. Flushing
      • 12.1 Flush modes
      • 12.2 Events and the action queue
        • 12.2.1 Flush operation order
      • 12.3 Dirty Checking
        • 12.3.1 The default dirty checking mechanism
          • 12.3.1.1 Controlling the Persistence Context size
        • 12.3.2 Bytecode enhancement
    • 13. Batching
      • 13.1 Batching insert statements
      • 13.2 Batching update statements
      • 13.3 Batching delete statements
    • 14. Fetching
      • 14.1 DTO projection
        • 14.1.1 DTO projection pagination
        • 14.1.2 Native query DTO projection
      • 14.2 Query fetch size
      • 14.3 Fetching entities
        • 14.3.1 Direct fetching
          • 14.3.1.1 Fetching a Proxy reference
          • 14.3.1.2 Natural identifier fetching
        • 14.3.2 Query fetching
        • 14.3.3 Fetching associations
          • 14.3.3.1 FetchType.EAGER
          • 14.3.3.2 FetchType.LAZY
            • 14.3.3.2.1 The N+1 query problem
            • 14.3.3.2.2 How to catch N+1 query problems during testing
            • 14.3.3.2.3 LazyInitializationException
            • 14.3.3.2.4 The Open Session in View Anti-Pattern
            • 14.3.3.2.5 Temporary Session Lazy Loading Anti-Pattern
          • 14.3.3.3 Associations and pagination
        • 14.3.4 Attribute lazy fetching
        • 14.3.5 Fetching subentities
      • 14.4 Entity reference deduplication
      • 14.5 Query plan cache
    • 15. Caching
      • 15.1 Caching flavors
      • 15.2 Cache synchronization strategies
        • 15.2.1 Cache-aside
        • 15.2.2 Read-through
        • 15.2.3 Write-invalidate
        • 15.2.4 Write-through
        • 15.2.5 Write-behind
      • 15.3 Database caching
      • 15.4 Application-level caching
        • 15.4.1 Entity aggregates
        • 15.4.2 Distributed key-value stores
        • 15.4.3 Cache synchronization patterns
        • 15.4.4 Synchronous updates
        • 15.4.5 Asynchronous updates
          • 15.4.5.1 Change data capture
      • 15.5 Second-level caching
        • 15.5.1 Enabling the second-level cache
        • 15.5.2 Entity cache loading flow
        • 15.5.3 Entity cache entry
          • 15.5.3.1 Entity reference cache store
        • 15.5.4 Collection cache entry
        • 15.5.5 Query cache entry
        • 15.5.6 Cache concurrency strategies
          • 15.5.6.1 READ_ONLY
            • 15.5.6.1.1 Inserting READ_ONLY cache entries
            • 15.5.6.1.2 Updating READ_ONLY cache entries
            • 15.5.6.1.3 Deleting READ_ONLY cache entries
          • 15.5.6.2 NONSTRICT_READ_WRITE
            • 15.5.6.2.1 Inserting NONSTRICT_READ_WRITE cache entries
            • 15.5.6.2.2 Updating NONSTRICT_READ_WRITE cache entries
            • 15.5.6.2.3 Risk of inconsistencies
            • 15.5.6.2.4 Deleting NONSTRICT_READ_WRITE cache entries
          • 15.5.6.3 READ_WRITE
            • 15.5.6.3.1 Inserting READ_WRITE cache entries
            • 15.5.6.3.2 Updating READ_WRITE cache entries
            • 15.5.6.3.3 Deleting READ_WRITE cache entries
            • 15.5.6.3.4 Soft locking concurrency control
          • 15.5.6.4 TRANSACTIONAL
            • 15.5.6.4.1 XA_Strict mode
            • 15.5.6.4.2 XA mode
            • 15.5.6.4.3 Inserting TRANSACTIONAL cache entries
            • 15.5.6.4.4 Updating TRANSACTIONAL cache entries
            • 15.5.6.4.5 Deleting TRANSACTIONAL cache entries
        • 15.5.7 Query cache strategy
          • 15.5.7.1 Tablespace query cache invalidation
          • 15.5.7.2 Native SQL statement query cache invalidation
    • 16. Concurrency Control
      • 16.1 Hibernate optimistic locking
        • 16.1.1 The implicit optimistic locking mechanism
          • 16.1.1.1 Resolving optimistic locking conflicts
          • 16.1.1.2 Splitting entities
          • 16.1.1.3 Versionless optimistic locking
            • 16.1.1.3.1 OptimisticLockType.DIRTY update caveat
      • 16.2 The explicit locking mechanism
        • 16.2.1 PESSIMISTIC_READ and PESSIMISTIC_WRITE
          • 16.2.1.1 Lock scope
          • 16.2.1.2 Lock timeout
        • 16.2.2 LockModeType.OPTIMISTIC
          • 16.2.2.1 Inconsistency risk
        • 16.2.3 LockModeType.OPTIMISTIC_FORCE_INCREMENT
        • 16.2.4 LockModeType.PESSIMISTIC_FORCE_INCREMENT
  • III JOOQ
    • 17. Why jOOQ matters
      • 17.1 How jOOQ works
      • 17.2 DML statements
      • 17.3 Java-based schema
      • 17.4 Upsert
        • 17.4.1 Oracle
        • 17.4.2 SQL Server
        • 17.4.3 PostgreSQL
        • 17.4.4 MySQL
      • 17.5 Batch updates
      • 17.6 Inlining bind parameters
      • 17.7 Complex queries
      • 17.8 Stored procedures and functions
      • 17.9 Streaming
      • 17.10 Keyset pagination

Authors have earned$9,549,183writing, publishing and selling on Leanpub, earning 80% royalties while saving up to 25 million pounds of CO2 and up to 46,000 trees.

Learn more about writing on Leanpub

The Leanpub 45-day 100% Happiness Guarantee

Within 45 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

See full terms

Free Updates. DRM Free.

If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).

Most Leanpub books are available in PDF (for computers), EPUB (for phones and tablets) and MOBI (for Kindle). The formats that a book includes are shown at the top right corner of this page.

Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.

Learn more about Leanpub's ebook formats and where to read them

Write and Publish on Leanpub

You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses! Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks. Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. It really is that easy.

Learn more about writing on Leanpub

Top Books

  1. #1

    Algebra-Driven Design

    Sandy Maguire

    A how-to field guide on building leak-free abstractions and algebraically designing real-world applications.

  2. #2

    Production Haskell

    Matt Parsons

    Are you excited about Haskell, but don't know where to begin? Are you thrilled by the technical advantages, but worried about the unknown pitfalls? This book has you covered.

  3. #3

    Machine Learning Engineering

    Andriy Burkov

    "If you intend to use machine learning to solve business problems at scale, I'm delighted you got your hands on this book."

    —Cassie Kozyrkov, Chief Decision Scientist at Google

    "Foundational work about the reality of building machine learning models in production."

    —Karolis Urbonas, Head of Machine Learning and Science at Amazon

  4. #4

    CCIE Service Provider Version 4 Written and Lab Exam Comprehensive Guide

    Nicholas Russo

    The service provider landscape has changed rapidly over the past several years. Networking vendors are continuing to propose new standards, techniques, and procedures for overcoming new challenges while concurrently reducing costs and delivering new services. Cisco has recently updated the CCIE Service Provider track to reflect these changes; this book represents the author's personal journey in achieving that certification.

  5. #5

    CCIE SP v4.1 - Workbook

    Łukasz Bromirski, Piotr Jablonski, and Nicholas Russo

    Are you striving to prepare to and pass CCIE SP lab exam? Take the opportunity and get this workbook! With the attached initial cfg files you will prepare yourself for the CCIE SP exam as well as learn SP technologies applicable to all kinds of today modern networks! This workbook covers blueprint topics and provides challenging examples.

  6. #6

    Ansible for DevOps

    Jeff Geerling

    Ansible is a simple, but powerful, server and configuration management tool. Learn to use Ansible effectively, whether you manage one server—or thousands.

  7. #7

    The Hundred-Page Machine Learning Book

    Andriy Burkov

    Everything you really need to know in Machine Learning in a hundred pages.

  8. #8

    Cloud Strategy

    Gregor Hohpe

    “Strategy is the difference between making a wish and making it come true.” A successful migration to the cloud shouldn’t be driven by wishes, but guided by a sound strategy, frameworks, and decision models. This book tells you how—without becoming superficial nor getting lost in technology and product details.

  9. #9

    C++ Best Practices

    Jason Turner

    Level up your C++, get the tools working for you, eliminate common problems, and move on to more exciting things!

  10. #10

    Thinking with Types

    Sandy Maguire

    This book aims to be the comprehensive manual for type-level programming. It's about getting you from here to there---from a competent Haskell programmer to one who convinces the compiler to do their work for them.

Top Bundles

  1. #1

    Quality Software

    11 Books

    The Quality Software Bundle is for managers, would-be managers, and any of us who find themselves being managed and confused. This comprehensive bundle covers the entire span of software development approaches, from hacking through waterfall, cascade, prototyping, Iterative enhancement, reusable code, off-the-shelf, to Agile teams. The bundle...
  2. #2

    The Node.js Bundle

    3 Books

    This bundle combines three bestselling Leanpub Node.js books into a package that gives you everything you need to get started with developing Node.js applications at an unbeatable price.
  3. #3

    The Tester's Library

    8 Books

    The Tester's Library consists of eight five-star books that every software tester should read and re-read. As bound books, this collection would cost over $200. Even as e-books, their price would exceed $80, but in this bundle, their cost is only $49.99. Here are the books, and why they should be in your library: Perfect Software and Other...
  4. #4

    agile

    11 Books

    In this bundle, you will find 10 different agile books. They are about different aspects of being agile. - finding a job - doing coding dojo's - Retrospectives - Personal kanban - a non-typical coaching book and even a book that gives you an insight in the lives of some agile people.
  5. #5

    WTFlop 6M + HU - Beta Bundle

    6 Books

  6. #6

    Fifty Quick Ideas

    3 Books

    Get all three books for the price of two! Fifty Quick Ideas books are full of practical, real-world techniques that you can use to improve teamwork, build better products and build them in a better way.
  7. #7

    Growing Agile: Coach's Guide Series

    4 Books

    This bundle provides a collection of training and workshop plans for a variety of agile topics. The series is aimed at agile coaches, trainers and ScrumMasters who often find themselves needing to help teams understand agile concepts. Each book in the series provides the plans, slides, handouts and activity instructions to run a number of...
  8. #8

    Marionette.js A to Z

    3 Books

    Marionette.js has become a popular Backbone-based javascript library, because it helps you avoid boiler-plate code and focus on what makes your app special. But how do you get started?Whether you want to finally get started with dynamic client-side programming (like one reader did), or are an experienced front-end dev who has inherited a...
  9. #9

    Build A Better Backbone App

    3 Books

    The best way to learn new development skills is through experience, but that takes time you don't have.Get the best of both worlds with this bundle: you'll learn how to produce modern web applications by learning from experienced developers like Derick Bailey and David Sulc. BackboneJS is one of the favorite tools on the web today, but it...
  10. #10

    People Skills—Soft but Difficult

    7 Books

    Perhaps you've been told that "lack of people skills" has been holding you back. No wonder: you may have had hundreds of hours of technical training, but little or no "people skills" guidance.You've heard it said that people skills are "soft," whereas technical skills are "hard." For you, though, technical skills are "easy," but people skills...

Publish Early, Publish Often

  • Path
  • There are many paths, but the one you're on right now on Leanpub is:
  • › High-performance-java-persistence

Leanpub is copyright © 2010-2020 Ruboss Technology Corp. All rights reserved.