Concurrency control in relational databases ensures data integrity when multiple transactions happen concurrently. Various methods include locking, preventing conflicts by restricting data access; optimistic concurrency control, assuming rare conflicts and rolling back and retrying when they occur; and timestamp ordering, prioritizing transactions based on their start time. The method choice depends on the database needs... Continue reading →

Explore the intricacies of security and authentication in relational databases with our comprehensive guide. Delve into the unique security architectures of SQL Server, Oracle, MariaDB/MySQL, and PostgreSQL. Understand how each system manages user setup, authentication methods, and role-based access control. Learn about the differences and similarities in their security models, from Windows Authentication in SQL... Continue reading →

The developer discusses building a GraphQL API against a Mongo database in Java with a Spring stack. Starting with a prerequisite setup in Java 17 and Spring 3, they create a basic “Hello World” app for initialization. The API functionality is expanded by adding configurations for error handling and testing. The process includes adding application... Continue reading →

The text presents a detailed comparison between 3 popular Java libraries for accessing MongoDB: MongoDB Java Driver, Morphia, and Spring Data MongoDB, offering insights into their usability and relevance. The MongoDB Java Driver provides direct access to MongoDB for native-like interaction. Morphia is an Object-Document Mapper designed for easy code readability and maintenance. For Spring... Continue reading →

This is a continuation of my posts on relational databases, started here. Previous posts on this theme, “Data Modeling“, “Let’s Talk About Database Schema“, “The Exasperating Topic of Database Indexes“, “The Keys & Relationships of Relational Databases“, and “Relational Database Query Optimization“. Consider you’re a die-hard fan of progressive death metal, with a particular affinity... Continue reading →