SQL Database Container Provisioning Across Cluster Worker Nodes
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Traditional database management systems require significant capital investment in hardware and infrastructure, are susceptible to data loss during disasters, and have limited scalability and efficiency in data access and retrieval.
Innovation Solution
A network-based database system utilizing compute service managers, execution platforms, and metadata organization to manage and execute queries efficiently, with micro-partitioning and pruning techniques to optimize data retrieval and storage.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If traditional database management systems are used, then data storage and retrieval functionality is provided, but significant capital investment in hardware and infrastructure is required
Solution Approach 1:
The patent implements a cloud-based database system that replicates traditional database functionality through virtualized computing resources. Instead of requiring physical hardware investment, the system uses virtual instances that copy database management capabilities, allowing organizations to access database services through network connections without procuring expensive on-premises infrastructure.
Solution Approach 2:
The patent replaces the mechanical/physical database infrastructure with a network-based system. Traditional hardware-based database management is substituted with cloud-delivered database services accessed through software interfaces and network connections, eliminating the need for physical server rooms, storage arrays, and associated hardware maintenance.
2Reliability
If traditional database systems are deployed, then data storage is achieved, but the system is highly susceptible to data loss during power outage or disaster situations
Solution Approach 1:
The patent implements cloud-based database systems with inherent redundancy and disaster recovery capabilities. Data is automatically replicated across multiple geographic locations and storage systems before failures occur, providing cushioning against data loss from power outages, natural disasters, or hardware failures. The cloud provider's infrastructure includes backup systems and failover mechanisms that protect data proactively.
Solution Approach 2:
The patent introduces a cloud service provider as an intermediary between the organization and physical data storage infrastructure. This intermediary manages data replication, backup, and disaster recovery across distributed systems, shielding the organization from direct exposure to hardware failures and environmental disasters that would affect on-premises systems.
3Reliability
If traditional relational database management systems are used, then data storage is provided, but extensive computing and storage resources are required
Solution Approach 1:
The patent implements a shared cloud infrastructure where computing and storage resources are virtualized and allocated dynamically across multiple database instances and clients. A single physical infrastructure serves multiple organizational needs simultaneously, with resources allocated based on demand rather than requiring dedicated hardware for each database system.
Solution Approach 2:
The patent changes the parameters of resource allocation from fixed, dedicated hardware assignments to dynamic, virtualized resource pools. Computing power and storage capacity are adjusted automatically based on query workloads, data sizes, and service level agreements, allowing efficient utilization of resources without over-provisioning for peak demands.
4Reliability
If traditional database systems are implemented, then data storage is achieved, but limited scalability is provided
Solution Approach 1:
The patent implements a cloud-based database system where computing and storage resources are dynamic rather than static. Organizations can scale database capacity up or down automatically based on changing data volumes, query complexities, and user demands without physical hardware changes. The system adapts resource allocation in real-time to match workload requirements.
Solution Approach 2:
The patent segments database resources into virtualized units that can be independently allocated and scaled. Computing resources are divided into virtual machine instances, and storage is segmented into manageable data volumes that can be provisioned separately, allowing granular scaling of specific database components without reconfiguring entire systems.
5Ease of operation
If traditional database management is performed, then data access is provided, but multiple persons with wide range of technical skill sets are required for oversight
Solution Approach 1:
The patent implements cloud-based database services with self-service capabilities that allow users to provision, configure, and manage database instances through web interfaces and automated tools. Common database administration tasks such as user management, backup configuration, and performance monitoring are handled automatically by the cloud platform, reducing the need for specialized database administrators.
Solution Approach 2:
The patent introduces a cloud service provider as an intermediary that manages the complexity of database infrastructure between end users and physical systems. The provider handles hardware maintenance, security patching, and system optimization, allowing organizations to access database functionality without requiring in-house expertise across multiple technical disciplines.
Data Source
AI summary
The subject technology receives a first set of statements, the first set of statements comprising at least a first statement to create a particular service associated with a container service. Further, the subject technology instantiates the particular service associated with the container service, in response to the first statement, at a first cluster, the first cluster including a first set of worker nodes.