Data Access Patterns

Data access patterns deal with how data is retrieved, stored, and managed within a system. They focus on providing efficient and flexible mechanisms for interacting with data sources, often abstracting away the underlying implementation details.

Wikipedia

Table Data Gateway

creational data access

The Table Data Gateway pattern provides an interface to a database table that encapsulates the table’s structure and ensures data consistency. It isolates the database-specific access logic from the rest of the application, making it easier to switch databases or modify the data access layer without impacting the core …

Read More
Query Object

behavioral data access

The Query Object pattern encapsulates complex data retrieval logic into dedicated objects. Instead of scattering database or service queries throughout your application’s logic, you move them into these query objects. This promotes separation of concerns, making your domain models cleaner and more focused on their core …

Read More
Identity Map

behavioral data access

The Identity Map pattern ensures that each object has a unique representation in memory. It maintains a registry of objects already loaded from the database, and when an object is requested, the map checks if it already exists before retrieving it from the persistence store. This reduces memory consumption and improves …

Read More
Row Data Gateway

creational data access

The Row Data Gateway pattern provides an interface to a database table. It encapsulates all the direct database access logic and exposes methods to perform operations on the table rows as objects. The gateway maps rows from one or more tables to objects, effectively presenting a higher-level, object-oriented view of …

Read More

Table Data Gateway

Query Object

Identity Map

Row Data Gateway