An Object-Oriented Database Schema Transformation Model for Heterogeneous Data Migration

International Journal of Computer Science and Technology Vol. 2, No. 4, April 2000 | pp. 25–32

DOI: 10.46882/2000/IJCST/000016

Research Article

Title: An Object-Oriented Database Schema Transformation Model for Heterogeneous Data Migration

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 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, 2000; Revised: February 18, 2000; Accepted: March 11, 2000; Published: April 22, 2000.

Citation: Jones, R. K., & Okafor, A. (2000). An Object-Oriented Database Schema Transformation Model for Heterogeneous Data Migration. International Journal of Computer Science and Technology, 2(4), 25–32.

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