Flexible In-Memory Column Store Placement Across Disjoint Systems
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database systems inefficiently utilize resources by not considering disjoint database systems for hosting assignments, leading to suboptimal use of resources and inability to increase the number of hosted objects beyond the capacity of a single system.
Innovation Solution
Allowing users to specify node assignments for database objects across disjoint database systems, enabling independent hosting assignments in replica systems and treating volatile memory across systems as a single pool, thereby optimizing resource utilization.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If database objects are loaded into volatile memory of a single node or cluster, then query performance is improved through caching, but the number of objects that can be hosted is limited by the memory capacity of that single system
Solution Approach 1:
The patent combines the volatile memory resources of multiple disjoint database systems into a unified pool, allowing database objects to be hosted across any node in either system. This merging approach increases the total hosting capacity beyond what a single system could provide, while maintaining independent operation of each system.
Solution Approach 2:
The patent creates a universal hosting mechanism where nodes from both database systems can serve as hosting nodes for any database object. The service name mapping allows any node in either system to host objects for services from both systems, making the hosting infrastructure multi-functional and system-agnostic.
2Ease of operation
If hosting assignments are centralized in a single database system, then management is simplified, but resources from disjoint database systems remain underutilized
Solution Approach 1:
The patent enables each database system to independently manage its own hosting assignments through service name mappings configured within each system. Nodes automatically determine which objects to host based on local service mappings and object location information, eliminating the need for centralized coordination while maintaining efficient resource utilization.
Solution Approach 2:
The patent pre-configures service name mappings in each database system that identify which services should be hosted on which nodes. This preliminary setup allows nodes to automatically make optimal hosting decisions without real-time coordination, simplifying ongoing management while maximizing resource utilization.
Data Source
AI summary
Techniques are described herein for distributing distinct portions of a database object across volatile memories of selected nodes of a plurality of nodes in a clustered database system. The techniques involve storing a unit-to-service mapping that associates a unit (a database object or portion thereof) to one or more database services. The one or more database services are mapped to one or more nodes. The nodes to which a service is mapped may include nodes in disjoint database systems, so long as those database systems have access to a replica of the unit. The database object is treated as in-memory enabled by nodes that are associated with the service, and are treated as not in-memory enabled by nodes that are not associated with the service.