Database Consolidation Tool Bypassing Siebel BOL
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The existing methods for consolidating databases in Siebel CRM systems, such as using Siebel's EAI or EIM tools, require extensive custom configuration and are time-consuming, as they need to manage data mappings and exception handling for large-scale data migration tasks.
Innovation Solution
A method that bypasses the Business Object Layer (BOL) by associating child and parent tables through foreign key realignment, using control files to align primary keys and realign foreign key pointers, allowing for the creation of a consolidated child table that points to the parent target table, thereby streamlining the database consolidation process.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If Siebel's EAI or EIM tools are used for database consolidation, then data mapping and exception handling are managed, but extensive custom configuration and long processing time (days or weeks) are required
Solution Approach 1:
The patent extracts the database consolidation process from the complex Siebel EAI/EIM framework by directly accessing and manipulating database tables through SQL operations. This bypasses the need for extensive custom configuration of data mappings and exception handling while dramatically reducing consolidation time from days/weeks to hours
Solution Approach 2:
The consolidation process is segmented into distinct SQL operations: creating temporary tables, merging data using UNION ALL, realigning foreign keys through controlled updates, and cleaning up temporary structures. This segmentation allows each operation to be executed efficiently and independently without the overhead of comprehensive configuration
2Reliability
If Siebel's EIM tool is used for large-scale data migration, then end-to-end solution with exception handling is provided, but supporting applications and extensive configuration are required
Solution Approach 1:
The patent implements self-service through automated SQL operations that handle data migration, foreign key realignment, and data integrity maintenance without requiring supporting applications or extensive configuration. The process autonomously manages the consolidation by directly executing structured queries on the database tables
Solution Approach 2:
Instead of using the conventional approach of configuring high-level integration tools with complex data mappings, the patent inverts the approach by directly manipulating the database tables using SQL. This bottom-up approach simplifies the process by working directly with the data structures rather than configuring abstraction layers
3Stability of the object's composition
If foreign key realignment is performed through traditional methods, then data consistency is maintained, but the process is time-consuming and requires coordination through the Business Object Layer
Solution Approach 1:
The patent replaces the mechanical coordination through the Business Object Layer with direct SQL operations on database tables. Foreign key realignment is achieved through efficient UPDATE statements that directly modify the database structures, bypassing the slower application-layer coordination mechanism while maintaining data consistency through structured query operations
Data Source
AI summary
A method for consolidating a database in a Seibel CRM environment is presented. Bypassing the Business Object Layer (BOL) of the Seibel CRM environment, primary keys in a consolidated table are realigned such that a consolidated child table, created from two distinct databases, is able to point to reference items in a single parent table.