EFFICIENT MIGRATION OF DATABASES FROM TERADATA TO GOOGLE BIGQUERY: A FRAMEWORK FOR MODERN DATA WAREHOUSING
Ashok Gadi Parthi, Balakrishna Pothineni, Deepak Jayabalan, Amey Ram Banarse, Durgaraman Maruthavanan · Journal of Software Engineering · 2024
The migration of legacy data warehouses like Teradata to cloud-native platforms such as Google BigQuery is a transformative step toward modernizing data management and analytics.This paper presents a structured framework to address technical, operational, and strategic challenges, including schema incompatibilities, query translation, and compliance requirements.Leveraging tools like Google's Schema Conversion Tool, Pub/Sub, and Dataflow, the framework ensures seamless schema transformation, data migration, and query optimization.Emphasis is placed on data security, regulatory compliance, and cost-efficiency.By aligning technical goals with business objectives and fostering user adoption, this guide equips organizations to unlock the full potential of scalable and real-time cloud analytics.Actionable insights and real-world use cases provide a definitive roadmap for successful migrations.