Unified Database Clone System with Lineage Visualization

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

The complexity of creating clones in computing systems, particularly in large enterprise environments with multiple database and storage systems, poses challenges for users and administrators due to the numerous variations and permutations in cloning techniques and management requirements.

Innovation Solution

A unified system for cloning is introduced, which includes a user interface for visually managing relationships and lineages of sources and clones, along with mechanisms to create, maintain, and administer clones across different underlying systems, eliminating the need for users to learn specific procedures for each system.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If multiple different database and storage systems are used to maintain data for cloning, then the system can support diverse data sources and clone types, but the complexity of creating and managing clones increases exponentially

Engineering Contradiction:
Improvesupport for diverse data sources and clone typesVSAvoidcomplexity of creating and managing clones
Core Design Contradiction:
Adaptability or versatilityVSDevice complexity

Solution Approach 1:

The patent implements a universal cloning system that provides a single unified interface capable of creating clones from multiple different database and storage systems. The system abstracts the underlying diversity of data sources behind a common cloning mechanism, allowing users to work with a consistent set of procedures regardless of the specific source system being cloned.

Inventive Principle:
Principle #6Universality (Multi-functionality)

Solution Approach 2:

The patent introduces an intermediary cloning system that sits between the diverse data sources and the user. This intermediary layer handles the complexity of different cloning techniques and procedures for various database and storage systems, translating user requests into system-specific operations without exposing the underlying complexity to users.

Inventive Principle:
Principle #24Intermediary (Mediator)

2Reliability

If each system has its own cloning procedures and techniques, then each system can be optimized for its specific requirements, but users must learn and manage multiple different cloning methods

Engineering Contradiction:
Improvesystem-specific cloning optimizationVSAvoiduser learning and management burden
Core Design Contradiction:
ReliabilityVSEase of operation

Solution Approach 1:

The patent segments the cloning functionality into two distinct layers: a user-facing unified interface layer and system-specific implementation layers. This segmentation allows each underlying system to maintain its optimized cloning procedures while presenting a consistent interface to users, effectively hiding the complexity from end users.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent creates a universal cloning interface that can handle multiple different database and storage systems through a single set of procedures. This universal layer maintains the reliability of system-specific optimizations while providing ease of operation through consistent user interactions across all systems.

Inventive Principle:
Principle #6Universality (Multi-functionality)

3Ease of operation

If a unified cloning system is implemented across multiple systems, then management and maintenance become simpler, but the system must handle numerous variations and permutations in cloning techniques

Engineering Contradiction:
Improvemanagement and maintenance simplicityVSAvoidhandling of cloning technique variations
Core Design Contradiction:
Ease of operationVSDevice complexity

Solution Approach 1:

The patent employs an intermediary unified cloning system that manages the complexity of numerous cloning technique variations. This intermediary layer provides simplified management and maintenance through a consistent interface while internally handling the diverse variations and permutations of cloning techniques required by different underlying systems.

Inventive Principle:
Principle #24Intermediary (Mediator)

Data Source

PatentUS10042908B2Method and system for implementing a unified DB clone system
Publication Date: 2018.08.07 ORACLE INT CORP
  • US10042908B2 patent drawing
  • US10042908B2 patent drawing
  • US10042908B2 patent drawing

AI summary

Disclosed are a system, method, and computer program product for a unified system for implementing clones. The unified system includes the appropriate infrastructure to create, maintain, and administer clones and supporting data sources in the computing environment. In addition, a user interface is provided that is capable of visually displaying relationships and lineages of sources and clones in the system. The user interface provides functionality to select any given object, and to trace its parent-child relationships to highlight its related parent and/or child source/clone.