Data Integrity Examples

A record transformer that keeps row indices and source values in every error, so a failing batch traces back to the exact offending record.

A staged data pipeline that runs named stages in order, stops at the first failure, and reports which stage and record index broke.

A dependency free validator for the common JSON Schema subset that reports every violation with its JSON path instead of stopping at the first mismatch.

Uses the time element with datetime attribute to represent dates and times in a machine-readable format for scheduling and display.

Demonstrates common ArrayList operations including add, remove, iterate, sort, and filter with practical examples for managing a list of items.

Uses the java.time API to work with dates, times, durations, periods, and formatting, demonstrating modern date-time manipulation and parsing.

Implements a generic Box class with type bounds, demonstrating how generics provide compile-time type safety while working with constrained type parameters.

Demonstrates HashMap operations including put, get, merge, computeIfAbsent, and iteration with entrySet, keySet, and forEach methods.

Demonstrates LinkedList operations including addFirst, addLast, peek, poll, and bidirectional iteration with ListIterator for queue and deque patterns.

Demonstrates Java record classes as concise immutable data carriers with automatic constructors, accessors, equals, hashCode, and toString methods.

Creates various index types including B-tree, partial, expression, and composite indexes to optimize different query patterns and access paths.

Uses DELETE with subquery conditions to remove specific rows and RETURNING to capture deleted data for audit logging and referential cleanup.

Demonstrates INSERT statements with multiple rows, column lists, and ON CONFLICT upsert behavior for inserting or updating data atomically.

Uses the MERGE statement to perform conditional INSERT, UPDATE, or DELETE operations based on source-target matching for data synchronization.

Creates a stored procedure with parameter validation, error handling, dynamic SQL, and cursor operations for encapsulating complex business logic.

Defines a table with comprehensive constraints including primary key, foreign keys, check constraints, unique constraints, and default values.

Demonstrates explicit transaction control with SET TRANSACTION isolation levels, savepoints, and conditional rollback for safe multi-step operations.

Performs UPDATE with a FROM clause to join additional tables and uses RETURNING to retrieve modified rows for verification and auditing.