Database Object Type Mapping for Automated Transfer

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing methods for transferring objects between database management systems (DBMS) require manual user intervention, as the unique identifier (TOID) created in the source DBMS is not valid in the target DBMS, leading to inefficiencies in data interpretation and transfer.

Innovation Solution

The target DBMS inspects the object to determine its type by identifying source identifiers for objects involved in inheritance hierarchies or by analyzing characteristics for basic types, assigning a target identifier to enable seamless import without manual intervention, allowing for 'fileless export/import' and creating local snapshots from remote tables.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If manual user intervention is used to create objects at the target DBMS, then the TOID is valid at the target DBMS and identifies the proper object type, but it requires manual user intervention and reduces efficiency

Engineering Contradiction:

ImproveTOID validityVSAvoidmanual intervention requirement

Core Design Contradiction:

ReliabilityVSEase of operation

Solution Approach 1:

The system performs self-service by automatically detecting the object type at the target DBMS and creating the appropriate TOID mapping without requiring manual user intervention. The target DBMS inspects the transferred object, determines its type based on characteristics, and autonomously establishes the valid TOID association, thereby resolving the contradiction between reliability and ease of operation.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The patent applies preliminary action by pre-establishing TOID mapping information at the source DBMS before object transfer. This mapping information is included with the object during transfer, enabling the target DBMS to automatically resolve TOID validity issues without manual intervention, thus improving both reliability and operational efficiency.

Inventive Principle:

Principle #10Preliminary action

2Productivity

If TOID from source DBMS is transferred to target DBMS, then object transfer is simplified, but the TOID is not valid at the target DBMS and cannot properly identify the object type

Engineering Contradiction:

Improveobject transfer efficiencyVSAvoidTOID validity

Core Design Contradiction:

ProductivityVSReliability

Solution Approach 1:

The patent introduces an intermediary TOID mapping mechanism that bridges the source and target DBMS. The mapping information acts as a mediator, translating the source TOID into a valid target TOID. This intermediary layer enables efficient object transfer while ensuring TOID validity at the target DBMS, resolving the contradiction between productivity and reliability.

Inventive Principle:

Principle #24Intermediary (Mediator)

Solution Approach 2:

The system creates a copy of the TOID mapping information from the source DBMS and adapts it for use at the target DBMS. This copied and adapted mapping information maintains the object transfer efficiency while ensuring the TOID is valid and properly identifies the object type in the target environment, thus resolving the contradiction.

Inventive Principle:

Principle #26Copying

3Extent of automation

If automated object transfer is implemented, then manual intervention is eliminated, but the target DBMS cannot determine how to interpret objects with foreign TOIDs

Engineering Contradiction:

Improveautomated transfer capabilityVSAvoidobject type interpretation

Core Design Contradiction:

Extent of automationVSDifficulty of detecting and measuring

Solution Approach 1:

The patent applies preliminary action by pre-packaging TOID mapping information with the object during transfer. This advance preparation enables the target DBMS to automatically interpret the object type without difficulty, as the mapping information is already available. This resolves the contradiction between automation extent and interpretation difficulty.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The TOID mapping information serves as an intermediary that facilitates automated object type interpretation at the target DBMS. This mediator provides the necessary translation layer, allowing the target system to automatically understand and interpret objects with foreign TOIDs, thus enabling full automation without increasing interpretation difficulty.

Inventive Principle:

Principle #24Intermediary (Mediator)

Data Source

PatentUS8359336B2Interpreting remote objects at a local site

Publication Date: 2013.01.22 ORACLE INT CORP

AI summary

A method and apparatus for receiving objects is provided. Embodiments provide for receiving, from a source database server, at a target database server, an object. If the object type of the object is involved in an inheritance hierarchy, then the target database server inspects the object to determine a source identifier that identifies to a source database server the object type associated with the object. The target database determines a target identifier that identifies to the target database server the object type associated with the object based on a mapping that associates source identifiers to target identifiers. Alternately, if the object type of the object is not involved in an inheritance hierarchy, then the target database server inspects the object to determine a set of characteristics of the object. The target database server determines the target identifier for the object based on the characteristics of the object.