Declarative Database Entity Changes With Atomic Incremental Updates

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Conventional database systems face issues with atomicity when multiple ALTER commands are executed outside of a DDL-compatible database transaction, leading to potential intermediate changes being visible to users.

Innovation Solution

Implementing declarative statements for creating and modifying database entities, such as tables, in an atomic and incremental manner using a 'CREATE OR ALTER' command, ensuring all changes are committed in a single transaction.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If multiple ALTER commands are executed outside of a DDL-compatible database transaction, then the commands can be run flexibly and independently, but atomicity is lost and intermediate changes become visible to users

Engineering Contradiction:

Improveflexibility of executing ALTER commandsVSAvoidatomicity of changes

Core Design Contradiction:

Ease of operationVSReliability

Solution Approach 1:

The patent merges multiple ALTER commands into a single DDL-compatible transaction, ensuring that all changes are applied atomically. This combines previously separate operations into one unified transactional unit, preventing intermediate states from being visible while maintaining operational flexibility through the transaction interface.

Inventive Principle:

Principle #5Merging (Combining)

2Productivity

If multiple ALTER commands are executed outside of a DDL-compatible database transaction, then each command can be executed independently, but intermediate changes are visible to users causing data integrity issues

Engineering Contradiction:

Improveindependent execution of commandsVSAvoidvisibility of intermediate changes

Core Design Contradiction:

ProductivityVSLoss of information

Solution Approach 1:

The system performs preliminary validation and planning of all ALTER commands within the transaction before any changes are applied. This preliminary action ensures that the complete set of changes is prepared and validated, then executed atomically as a unit, preventing any intermediate changes from becoming visible to users.

Inventive Principle:

Principle #10Preliminary action

3Ease of manufacture

If conventional ALTER commands are used, then simple modifications can be made, but lack of atomicity requires additional transaction management complexity

Engineering Contradiction:

Improvesimplicity of modificationVSAvoidtransaction management complexity

Core Design Contradiction:

Ease of manufactureVSDevice complexity

Solution Approach 1:

The patent creates a universal DDL-compatible transaction framework that handles multiple ALTER commands with atomicity guarantees built-in. This multi-functional transaction system can accommodate various types of ALTER operations while providing consistent atomicity and visibility control, reducing the need for complex external transaction management logic.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Data Source

PatentUS12547612B2Atomic and incremental target state definitions for database entities

Publication Date: 2026.02.10 SNOWFLAKE INC

AI summary

Techniques for creating and modifying database entities, such as tables, tasks, etc., using declarative statements are described. Declarative statements specify a target state of the entity without specifying specific actions. The techniques described herein apply changes to the database entity atomically and incrementally.