Application-Aware Storage Manager for Database Scaling

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Conventional database management systems face limitations in scaling beyond two coupled systems due to complexity in implementing replicated architectures, which affects their capacity to handle large numbers of data queries and transactions efficiently.

Innovation Solution

A method for managing data storage based on application awareness, where an application-aware management interface provides a database interface to the data storage system, allowing for automatic allocation and generation of storage resources, enabling easy scaling of database applications across multiple storage systems.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If replicated database architecture is implemented to handle large numbers of data queries and transactions, then the capacity to handle workloads is improved, but the system complexity increases significantly

Engineering Contradiction:
Improvecapacity to handle data queries and transactionsVSAvoidcomplexity of replicated architecture
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The patent introduces an application-aware storage manager as an intermediary component between the database management system and the storage subsystem. This manager automatically handles storage resource allocation, mapping, and management across distributed storage systems, thereby reducing the complexity of replicated database architectures while enabling them to handle larger workloads.

Inventive Principle:
Principle #24Intermediary (Mediator)

Solution Approach 2:

The storage manager performs self-service by automatically provisioning and managing storage resources based on application requirements. It dynamically allocates storage space, manages mapping between logical and physical storage locations, and handles storage operations without requiring manual configuration or complex architecture management, thus reducing overall system complexity.

Inventive Principle:
Principle #25Self-service

2Device complexity

If manual configuration of storage resources is used for database systems, then device complexity is reduced, but the ease of operation and scaling is worsened

Engineering Contradiction:
Improveconfiguration complexityVSAvoidease of scaling
Core Design Contradiction:
Device complexityVSEase of operation

Solution Approach 1:

The storage manager enables self-service by automatically provisioning storage resources, dynamically allocating space, and managing storage mappings based on application needs. This eliminates manual configuration requirements and simplifies scaling operations, allowing database systems to be easily expanded without complex manual intervention.

Inventive Principle:
Principle #25Self-service

Solution Approach 2:

The system performs preliminary actions by pre-configuring storage policies, allocation strategies, and mapping rules that are automatically applied when storage resources are needed. This preparation eliminates the need for manual configuration during scaling operations, significantly improving ease of operation while maintaining low complexity.

Inventive Principle:
Principle #10Preliminary action

Data Source

PatentUS8984031B1Managing data storage for databases based on application awareness
Publication Date: 2015.03.17 EMC IP HLDG CO LLC
  • US8984031B1 patent drawing
  • US8984031B1 patent drawing
  • US8984031B1 patent drawing

AI summary

A method is used in managing data storage for databases based on application awareness. Content is received via any of a file system interface, a block based interface, and an object based interface to a data storage system, which executes a general purpose operating system. Based on software installed on the data storage system and running on the general purpose operating system, an application-aware management interface is used to provide a database interface to the data storage system. Based on the database interface, database queries are accepted at the data storage system.