Data Migration Tools and Technologies
Expert-defined terms from the Certificate in Master Data Migration course at London School of Business and Administration. Free to read, free to share, paired with a professional course.
Abstract Data Type refers to a high #
level concept used to define the structure and behavior of data in a system, it is a key concept in data migration, as it helps to ensure that data is properly organized and managed during the migration process. Related terms include Data Modeling, Data Warehousing, and metadata management. In the context of data migration, abstract data types are used to define the structure and relationships of data, making it easier to transform and load data into a new system.
API stands for Application Programming Interface, it is a set of rules an… #
Related terms include Data Integration, Data Synchronization, and web services. In data migration, APIs are used to connect to source and target systems, extract data, and load it into the new system.
Archive refers to a repository of historical data that is no longer activ… #
Related terms include Data Retention, Data Storage, and backup and recovery. In data migration, archives are often migrated to a new system, where they can be stored and managed more efficiently.
Authentication is the process of verifying the identity of users or syste… #
Related terms include Authorization, Data Security, and access control. In data migration, authentication is used to control access to source and target systems, and to ensure that data is properly secured during the migration process.
Backup refers to the process of creating a copy of data, so that it can b… #
Related terms include Data Recovery, Data Storage, and disaster recovery. In data migration, backups are used to create a copy of the source data, so that it can be restored if something goes wrong during the migration process.
Cloud Computing refers to the use of remote servers and internet c… #
Related terms include Cloud Storage, Cloud Security, and infrastructure as a service. In data migration, cloud computing is used to host the target system, and to provide a scalable and secure environment for data storage and processing.
Data Compression is the process of reducing the size of data, so that it… #
Related terms include Data Encryption, Data Encoding, and data reduction. In data migration, data compression is used to reduce the size of the data, so that it can be transferred more quickly and efficiently.
Data Encryption is the process of scrambling data, so that it can only be… #
Related terms include Data Security, Data Protection, and access control. In data migration, data encryption is used to protect sensitive data, such as personal identifiable information or financial data.
Data Governance refers to the processes and policies that are used… #
Related terms include Data Quality, Data Security, and compliance management. In data migration, data governance is used to ensure that data is properly validated, cleansed, and transformed during the migration process.
Data Integration refers to the process of combining data from multiple <i… #
Related terms include Data Synchronization, Data Transformation, and data warehousing. In data migration, data integration is used to combine data from multiple sources, and to create a unified view of the data.
Data Mapping is the process of defining the relationships between differe… #
Related terms include Data Transformation, Data Validation, and data quality management. In data migration, data mapping is used to define the relationships between the source and target data, and to ensure that data is properly transformed and loaded into the new system.
Data Migration is the process of transferring data from one system … #
Related terms include Data Integration, Data Synchronization, and data transformation. In data migration, data is transferred from the source system to the target system, using a variety of tools and techniques.
Data Modeling is the process of creating a conceptual representati… #
Related terms include Data Warehousing, Data Governance, and metadata management. In data migration, data modeling is used to create a conceptual representation of the data, and to ensure that the data is properly structured and organized.
Data Profiling is the process of analyzing the quality and stru… #
Related terms include Data Quality, Data Governance, and data validation. In data migration, data profiling is used to analyze the quality and structure of the data, and to identify areas for improvement.
Data Quality refers to the accuracy , completeness , and consiste… #
Related terms include Data Governance, Data Validation, and data cleansing. In data migration, data quality is used to ensure that the data is accurate, complete, and consistent, and to identify areas for improvement.
Data Security refers to the protection of data from unauthorized a… #
Related terms include Data Encryption, Data Access Control, and compliance management. In data migration, data security is used to protect sensitive data, such as personal identifiable information or financial data.
Data Synchronization is the process of coordinating the update of… #
Related terms include Data Integration, Data Transformation, and data warehousing. In data migration, data synchronization is used to coordinate the update of data across multiple sources, and to ensure that the data is consistent and up-to-date.
Data Transformation is the process of converting data from one format<… #
Related terms include Data Mapping, Data Validation, and data quality management. In data migration, data transformation is used to convert data from the source system to the target system, and to ensure that the data is properly formatted and structured.
Data Validation is the process of checking the accuracy and com… #
Related terms include Data Quality, Data Governance, and data cleansing. In data migration, data validation is used to check the accuracy and completeness of the data, and to identify areas for improvement.
Data Warehousing refers to the process of storing and managing lar… #
Related terms include Data Integration, Data Synchronization, and data governance. In data migration, data warehousing is used to store and manage large amounts of data, and to create a unified view of the data.
Database Management System refers to a software system that is used to <i… #
Related terms include Data Modeling, Data Governance, and data security. In data migration, database management systems are used to store and manage data, and to provide a platform for data integration and transformation.
ETL stands for Extract, Transform, and Load, it is a process that is used… #
Related terms include Data Integration, Data Transformation, and data warehousing. In data migration, ETL is used to extract data from multiple sources, transform it into a consistent format, and load it into the target system.
Extract refers to the process of retrieving data from a source sys… #
Related terms include Transform, Load, and data integration. In data migration, extract is used to retrieve data from the source system, and to create a copy of the source data.
Governance refers to the processes and policies that are used to <… #
Related terms include Data Quality, Data Security, and compliance management. In data migration, governance is used to ensure that data is properly managed and controlled, and to identify areas for improvement.
Informatica is a software company that provides data integration a… #
Related terms include Data Integration, Data Transformation, and data warehousing. In data migration, informatica is used to integrate and transform data, and to provide a comprehensive platform for data migration.
JSON stands for JavaScript Object Notation, it is a format that is used t… #
Related terms include XML, CSV, and data serialization. In data migration, JSON is used to represent data in a structured and human-readable way, and to provide a flexible and scalable format for data exchange.
Load refers to the process of loading data into a target system, l… #
Related terms include Extract, Transform, and data integration. In data migration, load is used to load data into the target system, and to create a unified view of the data.
Metadata refers to data that is used to describe other data, metad… #
Related terms include Data Modeling, Data Governance, and data quality management. In data migration, metadata is used to describe the data, and to provide context and meaning to the data.
Microsoft SQL Server is a database management system that is used to s… #
Related terms include Data Modeling, Data Governance, and data security. In data migration, Microsoft SQL Server is used to store and manage data, and to provide a comprehensive platform for data migration.
MySQL is a database management system that is used to store and <i… #
Related terms include Data Modeling, Data Governance, and data security. In data migration, MySQL is used to store and manage data, and to provide a comprehensive platform for data migration.
Oracle is a database management system that is used to store and <… #
Related terms include Data Modeling, Data Governance, and data security. In data migration, Oracle is used to store and manage data, and to provide a comprehensive platform for data migration.
PostgreSQL is a database management system that is used to store a… #
Related terms include Data Modeling, Data Governance, and data security. In data migration, PostgreSQL is used to store and manage data, and to provide a comprehensive platform for data migration.
Quality refers to the accuracy , completeness , and consistency</… #
Related terms include Data Governance, Data Validation, and data cleansing. In data migration, quality is used to ensure that the data is accurate, complete, and consistent, and to identify areas for improvement.
SAP is a software company that provides enterprise resource planni… #
Related terms include Data Integration, Data Transformation, and data warehousing. In data migration, SAP is used to integrate and transform data, and to provide a comprehensive platform for data migration.
Security refers to the protection of data from unauthorized access… #
Related terms include Data Encryption, Data Access Control, and compliance management. In data migration, security is used to protect sensitive data, such as personal identifiable information or financial data.
SQL stands for Structured Query Language, it is a language that is used t… #
Related terms include Data Modeling, Data Governance, and data security. In data migration, SQL is used to manage and manipulate data, and to provide a flexible and scalable way to manage and transform data.
Talend is a software company that provides data integration and <i… #
Related terms include Data Integration, Data Transformation, and data warehousing. In data migration, Talend is used to integrate and transform data, and to provide a comprehensive platform for data migration.
Transform refers to the process of converting data from one format … #
Related terms include Extract, Load, and data integration. In data migration, transform is used to convert data from the source system to the target system, and to ensure that the data is properly formatted and structured.
XML stands for Extensible Markup Language, it is a format that is used to… #
Related terms include JSON, CSV, and data serialization. In data migration, XML is used to represent data in a structured and human-readable way, and to provide a flexible and scalable format for data exchange.