Blog - Page 2 of 44 - Vlad Mihalcea

Posted on March 3, 2021 by vladmihalcea

Merge Join Algorithm

Last modified:

Introduction

In this article, we are going to see how the Merge Join Algorithm, also known as Sort-Merge Join, works and when it’s suitable for a relational database system to employ it in order to execute an SQL JOIN query.

Leave a Comment

Posted on February 25, 2021 by vladmihalcea

MySQL Query Profiling Using Performance Schema

Last modified:

Follow @vlad_mihalcea

Introduction

In this article, I’m going to explain how to do query profiling using the MySQL Performance Schema.

The Performance Schema has been available since MySQL 5.5.3 and allows MySQL to instrument SQL queries and store their trace information in various tables that you can later inspect in order to determine why a given SQL statement is slow.

On older versions of MySQL, you might have used the SHOW PROFILE command, but since this feature has been deprecated, you should now use the Performance Schema for SQL query profiling.

Leave a Comment

Posted on February 18, 2021 by vladmihalcea

SQL Server OPENJSON – Map JSON to a relational table

Last modified:

Follow @vlad_mihalcea

Introduction

In this article, I’m going to explain how the SQL Server OPENJSON function works and how it can help you transform a JSON object into a relational database table.

When using a relational database system, it’s a very good idea to design the database schema according to the relational model. However, there are specific situations when the relational model is way too strict, and that’s when a JSON column type might be very handy.

For instance, as I explained in this article, when designing an audit log table, it’s much more convenient to store the before and after row snapshots in JSON columns, as this strategy will accommodate future target table modifications while also avoiding duplicating every target table column in the audit log table. Thanks to the JSON column approach, we can even use a single audit log table for all target tables that we are auditing.

Leave a Comment

Posted on February 10, 2021 by vladmihalcea

Hash Join Algorithm

Last modified:

Follow @vlad_mihalcea

Introduction

In this article, we are going to see how the Hash Join Algorithm works and when it’s suitable for a relational database system to employ it in order to execute an SQL JOIN query.

Leave a Comment

Posted on February 3, 2021 by vladmihalcea

High-Performance Java Persistence Newsletter, Issue 23

Last modified:

Follow @vlad_mihalcea

Introduction

Welcome to a new issue of the High-Performance Java Persistence Newsletter in which we share articles, videos, workshops, and StackOverflow answers that are very relevant to any developer who interacts with a database system using Java.

Leave a Comment

Posted on January 27, 2021 by vladmihalcea

Nested Loop Join Algorithm

Last modified:

Follow @vlad_mihalcea

Introduction

In this article, we are going to see how the Nested Loop Join Algorithm works and when it’s suitable for a relational database system to employ it in order to execute an SQL JOIN query.

4 Comments

Posted on January 20, 2021 by vladmihalcea

Connection Monitoring with JPA and Hibernate

Last modified:

Follow @vlad_mihalcea

Introduction

In this article, I’m going to show you how you can set up connection monitoring for your JPA and Hibernate application, no matter if you are using Spring or other application frameworks.

Leave a Comment

Posted on January 13, 2021 by vladmihalcea

Maven and Gradle Hibernate Enhance Plugin

Last modified:

Follow @vlad_mihalcea

Introduction

In this article, I’m going to explain how the configure the Maven and Gradle Hibernate Enhance Plugin.

The goal of the Hibernate Enhance plugin is to instrument the JPA entity bytecode in order to improve the effectiveness and efficiency of the associated data access operations.

Leave a Comment

Posted on January 6, 2021 by vladmihalcea

Hibernate LazyToOne annotation

Last modified:

Follow @vlad_mihalcea

Introduction

In this article, I’m going to explain how the Hibernate LazyToOne annotation works and why you should use NO_PROXY lazy loading with bytecode enhancement.

Without the LazyToOneOption.NO_PROXY annotation, the parent-side of a @OneToOne association is always going to be fetched eagerly even if you set it to FetchType.LAZY and enabled bytecode enhancement lazy loading.

Leave a Comment

Posted on December 29, 2020 by vladmihalcea

High-Performance Java Persistence Newsletter, Issue 22

Last modified:

Follow @vlad_mihalcea

Introduction

Welcome to a new issue of the High-Performance Java Persistence Newsletter in which we share articles, videos, workshops, and StackOverflow answers that are very relevant to any developer who interacts with a database system using Java.

Vlad Mihalcea

Merge Join Algorithm

Introduction

MySQL Query Profiling Using Performance Schema

Introduction

SQL Server OPENJSON – Map JSON to a relational table

Introduction

Hash Join Algorithm

Introduction

Nested Loop Join Algorithm

Introduction

Connection Monitoring with JPA and Hibernate

Introduction

Maven and Gradle Hibernate Enhance Plugin

Introduction

Hibernate LazyToOne annotation

Introduction

Let’s connect

Find Article

Book

Video Course

Hypersistence Optimizer

Training

ERP Contact

Tutorials

Social Media

About

Meta