Database Object Creation via Server-Based Reference Linking
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current data management between different software programs and operating systems is inefficient, particularly when transferring database objects, as existing methods like copy/paste and drag/drop lack dynamic control and require manual modification, limiting the ability to seamlessly share and modify data across disparate applications.
Innovation Solution
A computer-implemented method that allows users to create a new database object by selecting a source database object and specifying a target database type, enabling dynamic data transfer and modification through a 'pick and place' technique using a server-based software application, independent of operating systems or web browsers, with options for further actions on the transferred data.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If copy/paste or drag/drop functions are used to transfer data between software programs, then data can be transferred between applications, but the user must manually modify the transferred data and lacks dynamic control during the transfer process
Solution Approach 1:
The system performs preliminary actions by pre-defining object types, database objects, and fields with their structures and relationships before data transfer occurs. This preparation enables automatic data mapping and transformation during transfer, eliminating the need for manual modification after transfer and resolving the contradiction between ease of operation and time loss.
2Adaptability or versatility
If import/export functionality is used to transfer data between database management software programs, then data transfer between programs is enabled, but the files must meet certain criteria and are program-specific, limiting versatility
Solution Approach 1:
The system implements universality by creating a platform-independent data transfer mechanism that works across different software programs and operating systems. By defining universal object types and database objects with standardized structures, the system enables data transfer between any compatible applications without being program-specific, while the centralized server management simplifies the complexity of multiple import/export functions.
3Productivity
If individual database objects are selected, copied, and pasted from one location to another, then data can be transferred between applications, but the process is daunting and inefficient
Solution Approach 1:
The system implements copying at the object type level rather than individual object level. By copying the structure and definition of object types, database objects, and fields once, the system enables automatic instantiation and transfer of multiple instances across applications. This resolves the contradiction by dramatically improving productivity while maintaining ease of operation through automated processes.
4Extent of automation
If data is transferred using traditional methods, then data gets incorporated into the target program, but the user lacks dynamic control during the paste/drop/import phase and must modify data manually afterward
Solution Approach 1:
The system implements feedback mechanisms that allow users to review, modify, and control data transformation parameters during the transfer process. The predefined object types and database objects provide structured feedback about data mapping and transformation options, enabling dynamic control while maintaining high automation. This resolves the contradiction by providing both automated transfer and user control over the transformation process.
Data Source
AI summary
A method and computer program product for performing the method are provided. The method includes receiving a first user selection of a source database object to be used in the creation of a new database object. The source database object has a first predefined database object type. The method also includes storing a reference to the selected source database object in association with a user identifier associated with the first user selection; receiving a second user selection of a second predefined database object type to be used in the creation of the new database object. The second database object type is different from the first database object type. The method also includes determining if a user identifier associated with the second user selection is stored in association with the user identifier associated with the stored reference, and if so, creating the new database object using the referenced source database object.