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