Introduction to Database Systems

Overview of Data Management Evolution of Data Management Manual Handling Era File Systems Era Database Systems Era Core Concepts Data Records describing entities (text, graphics, images, audio) Data alone lacks meaning without semantic interpretation; data and semantics are inseparable Database (DB) A large collection of structured, shared d ...

Posted on Thu, 07 May 2026 04:56:06 +0000 by andrin

Database Read-Write Splitting Implementation

Core Principles of Read-Write Separation Database read-write splitting distributes query and modification operations across separate database instances to enhance system performance and scalability. This architectural pattern directs write operations to a primary instance while routing read queries to one or multiple replica instances. Key Comp ...

Posted on Thu, 07 May 2026 04:51:32 +0000 by the elegant

Automating MyBatis Code Generation with Maven and Plugin Configuration

Setting Up the Maven Project Begin by establishing a standard Maven project structure to house the generator configuration and dependencies. Configuring Maven Dependencies and Build Plugin Update the pom.xml to include the necessary libraries for MyBatis and the generator tool. The configuration below specifies the Maven plugin responsible f ...

Posted on Thu, 07 May 2026 03:30:36 +0000 by bodzan

MySQL Advanced Features: Views, Transactions, Triggers, and Performance Optimization

Views in MySQL Views are virtual tables that don't占用 any physical storage. When querying a view, MySQL retrieves data dynamically from the underlying base tables. Key Characteristics Modifications to a view propagate to the underlying base tables Changes to base tables are visible through the view when querying Views typically shouldn't be m ...

Posted on Thu, 07 May 2026 02:04:26 +0000 by recklessgeneral