A Structural Dependency Mapping Model for Relational Hierarchy Transformations

International Journal of Computer Science and Technology Vol. 4, No. 5, May 2002 | pp. 33–40

DOI: 10.46882/2002/IJCST/000041

Research Article

Title: A Structural Dependency Mapping Model for Relational Hierarchy Transformations

Names of Authors: Robert K. Jones¹, Amara Okafor²

Authors’ Affiliations: ¹Department of Software Engineering, Australian National University, Canberra, Australia; ²Department of Computer Science, University of Ibadan, Ibadan, Nigeria.

Abstract:
Enterprise computing centers face significant interoperability and data-loss challenges when migrating legacy records into modern object-oriented database management architectures. Structural differences between traditional tabular records and hierarchical object classes often cause runtime exceptions, broken relational linkages, and slow querying speeds. This paper introduces a formal, automated schema transformation model designed to map entity-relationship structures into optimized object-oriented formats smoothly. The framework uses a structural dependency mapping engine that evaluates table constraints, foreign key mappings, and cardinality indices before constructing equivalent class inheritance trees. We tested the execution efficiency of our migration engine by transferring an enterprise resource planning database containing 50 million records and 400 interconnected tables. The system completed the complete structural transformation process without requiring human repair scripts, achieving 100% data integrity preservation. Post-migration query benchmarks show a 31.4% improvement in complex data retrieval operations, validating that our object nesting logic successfully avoids high-overhead join statements in production environments.

Keywords: Database Migration, Schema Transformation, Object-Oriented Databases, Data Integrity, Relational Mapping, Enterprise Software.

Manuscript Timeline: Received: January 08, 2002; Revised: February 18, 2002; Accepted: March 11, 2002; Published: May 22, 2002.

Citation: Jones, R. K., & Okafor, A. (2002). A Structural Dependency Mapping Model for Relational Hierarchy Transformations. International Journal of Computer Science and Technology, 4(5), 33–40.

Subscribe to read the full article: https://internationalscholarsjournals.org/subscribe-to-read