Data Mapper Pattern in Java: Decoupling Data Storage from Business Logic
- Also known as
- Intent of the Data Mapper Pattern
- Detailed Explanation of Data Mapper Pattern with Real-World Examples
- Programmatic Example of Data Mapper Pattern in Java
- When to Use the Data Mapper Pattern in Java
- Data Mapper Pattern Java Tutorials
- Real-World Applications of Data Mapper Pattern in Java
- Benefits and Trade-offs of Data Mapper Pattern
- Related Java Design Patterns
- References and Credits
Also known as
- Object-Relational Mapping (ORM)
Intent of the Data Mapper Pattern
The Data Mapper pattern aims to create an abstraction layer between the database and the business logic, allowing them to evolve independently. It maps data from the database objects to in-memory data structures and vice versa, minimizing direct dependencies between the application's core logic and the underlying database structure. This decoupling is essential in promoting maintainability and flexibility in Java programming.
Detailed Explanation of Data Mapper Pattern with Real-World Examples
Real-world example
Consider a library system where books are stored in a database with complex relationships and various attributes such as title, author, publication year, and genre. In this scenario, a Data Mapper pattern can be used to map the database records of books to in-memory objects in the application. The Data Mapper would handle the retrieval, storage, and update of book objects in the database, allowing the application's business logic to work directly with the book objects without concern for the underlying database structure. This separation makes it easier to change the database schema without affecting the business logic, and vice versa.
In plain words
A layer of mappers that moves data between objects and a database while keeping them independent of each other.
Wikipedia says
A Data Mapper is a Data Access Layer that performs bidirectional transfer of data between a persistent data store (often a relational database) and an in-memory data representation (the domain layer). The goal of the pattern is to keep the in-memory representation and the persistent data store independent of each other and the data mapper itself. This is useful when one needs to model and enforce strict business processes on the data in the domain layer that do not map neatly to the persistent data store.
Sequence diagram

Programmatic Example of Data Mapper Pattern in Java
The Data Mapper is a design pattern that separates the in-memory objects from the database. Its responsibility is to transfer data between the two and also to isolate them from each other. This pattern promotes theSingle Responsibility Principle andSeparation of Concerns.
In the data-mapper module, the pattern is demonstrated using aStudent
class and aStudentDataMapper
interface.
TheStudent
class is a simple POJO (Plain Old Java Object) that represents a student. It has properties like studentId, name, and grade.
public class Student { private int studentId; private String name; private char grade; // ...}
TheStudentDataMapper
interface defines the operations that can be performed onStudent
objects. These operations includeinsert
,update
,delete
, andfind
.
public interface StudentDataMapper { void insert(final Student student); void update(final Student student); void delete(final Student student); Optional<Student> find(final int studentId); // ...}
TheStudentDataMapperImpl
class implements theStudentDataMapper
interface. It contains the actual logic for interacting with the database.
public class StudentDataMapperImpl implements StudentDataMapper { // ... @Override public void insert(final Student student) { // Insert student into the database } @Override public void update(final Student student) { // Update student in the database } @Override public void delete(final Student student) { // Delete student from the database } @Override public Optional<Student> find(final int studentId) { // Find student in the database } // ...}
TheApp
class contains the main method that demonstrates the use of theStudentDataMapper
. It creates aStudent
object, inserts it into the database, finds it, updates it, and finally deletes it.
public class App { public static void main(final String...args) { final var mapper = new StudentDataMapperImpl(); var student = new Student(1,"Adam",'A'); mapper.insert(student); final var studentToBeFound = mapper.find(student.getStudentId()); student= new Student(student.getStudentId(),"AdamUpdated",'A'); mapper.update(student); mapper.delete(student); }}
Program output:
13:54:29.234 [main] DEBUG com.iluwatar.datamapper.App -- App.main(), student : Student(studentId=1, name=Adam, grade=A), is inserted13:54:29.237 [main] DEBUG com.iluwatar.datamapper.App -- App.main(), student : Optional[Student(studentId=1, name=Adam, grade=A)], is searched13:54:29.237 [main] DEBUG com.iluwatar.datamapper.App -- App.main(), student : Student(studentId=1, name=AdamUpdated, grade=A), is updated13:54:29.238 [main] DEBUG com.iluwatar.datamapper.App -- App.main(), student : Student(studentId=1, name=AdamUpdated, grade=A), is going to be deleted
When to Use the Data Mapper Pattern in Java
Use the Data Mapper in any of the following situations
- When there's a need to decouple the in-memory objects from the database entities to promote theSingle Responsibility Principle andSeparation of Concerns.
- In applications requiring an ORM tool to bridge the gap between object-oriented models and relational databases.
- When working with complex database schemas where direct data manipulation and object creation lead to cumbersome and error-prone code.
Data Mapper Pattern Java Tutorials
- Spring Boot RowMapper (ZetCode)
- Spring BeanPropertyRowMapper tutorial (ZetCode)
- Data Transfer Object Pattern in Java - Implementation and Mapping (StackAbuse)
Real-World Applications of Data Mapper Pattern in Java
- ORM frameworks such as Hibernate in Java.
- Data access layers in enterprise applications where business logic and database management are kept separate.
- Applications requiring database interactions without tying the code to a specific database implementation.
Benefits and Trade-offs of Data Mapper Pattern
Benefits:
- PromotesSingle Responsibility Principle by separating persistence logic from business logic.
- Enhances maintainability and readability by centralizing data interaction logic.
- Improves application's ability to adapt to changes in the database schema with minimal changes to the business logic.
Trade-offs:
- Introduces complexity through the additional abstraction layer.
- Might lead to performance overhead due to the abstraction layer, especially in large-scale applications or with complex queries.
- Requires developers to learn and understand the abstraction layer in addition to the database and ORM framework being used.
Related Java Design Patterns
- Active Record: Combines data access logic and business logic in the domain entities themselves, contrary to Data Mapper's separation of concerns.
- Object–Relational Mapping (ORM): A technique to map object-oriented programming language data to a relational database.
- Repository: Provides an abstraction of the data layer, acting as a collection of domain objects in memory.
- Unit of Work: Manages transactions and keeps track of the objects affected by a business transaction to ensure changes are consistent and transactional.