Stateless Catalog Object Processing for Scalable Data Nodes

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing data storage and retrieval systems face scalability limitations due to bottlenecks in shared-disk systems and disruptive data rearrangement in shared-nothing architectures, leading to inefficiencies and complexity in managing data across multiple processing nodes.

Innovation Solution

A data processing platform that decouples data storage resources from computing resources, allowing dynamic scaling and fault-tolerant operation, with a cloning technique that creates duplicate catalog objects based on metadata rather than data copies, enabling efficient data management and access.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If a shared-disk system is used where all data is stored on a shared storage device accessible from all processing nodes, then data consistency is ensured, but the shared storage device and communication links become bottlenecks that slow data read and write operations as the number of processing nodes increases

Engineering Contradiction:
Improvedata consistencyVSAvoiddata read and write speed
Core Design Contradiction:
ReliabilityVSProductivity

Solution Approach 1:

The system segments data storage by creating a dedicated storage node separate from computing nodes. Each computing node can access the centralized storage device independently, eliminating the bottleneck where all nodes shared the same storage device. This segmentation allows parallel data access without interference while maintaining consistency through the centralized storage architecture.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The system introduces a storage device as an intermediary component that mediates between computing nodes and data storage. This intermediary centralized storage device provides a single point of truth for data consistency while allowing multiple computing nodes to access it concurrently without creating bottlenecks in the computing node interconnections.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Adaptability or versatility

If a shared-nothing architecture is used where data is distributed across multiple processing nodes, then scalability is improved, but data rearrangement becomes time-consuming and disruptive when new nodes are added or removed

Engineering Contradiction:
ImprovescalabilityVSAvoiddata rearrangement time
Core Design Contradiction:
Adaptability or versatilityVSLoss of time

Solution Approach 1:

The centralized storage device acts as an intermediary that maintains data location information and routing metadata. When new nodes are added or removed, the system only needs to update this metadata in the centralized storage device rather than physically rearranging data across the network, significantly reducing the time and disruption required for node addition/removal.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The system creates virtual copies or views of data locations through the centralized storage device's metadata management. New nodes can be assigned virtual mappings to existing data locations without actual data movement, allowing rapid node addition while maintaining data accessibility through the centralized indexing mechanism.

Inventive Principle:
Principle #26Copying

3Productivity

If a shared-nothing architecture is used where each processing node performs both storage and processing functions, then resource utilization is improved, but management complexity increases due to data distribution across many nodes

Engineering Contradiction:
Improveresource utilizationVSAvoiddata management complexity
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The system segments the storage function from computing functions by introducing a dedicated centralized storage device. This separation allows computing nodes to focus on processing while the centralized storage handles data management, reducing the complexity at individual nodes while maintaining high resource utilization through the coordinated architecture.

Inventive Principle:
Principle #1Segmentation

Data Source

PatentUS12541534B2Using stateless nodes to process data of catalog objects
Publication Date: 2026.02.03 SNOWFLAKE INC
  • US12541534B2 patent drawing
  • US12541534B2 patent drawing
  • US12541534B2 patent drawing

AI summary

A system and method of using a stateless node to process data of a catalog object. The method includes accessing a catalog object comprising metadata associated with a dataset. The method includes distributing, by one or more processors, a task to a stateless node to cause the stateless node to process the dataset without storing information indicative of a particular state of the stateless node.