Data migration: Difference between revisions

Latest revision as of 10:42, 2 January 2023

System Fundamentals^[1]

When we move data from one system to another we transfer it. However, when you aim to permanently move data (most commonly when you are building a new system), we can say you are migrating data. Please know this is almost always a deliberate process.

There are several problems that may arise as part of data migration:

Data Loss: There is a risk of data loss during the migration process. This can occur due to various reasons such as network issues, hardware failures, or data corruption.
Data Incompatibility: The source and destination systems may use different data formats or structures, leading to data incompatibility issues.
Data Integrity: Data integrity problems can arise if the migrated data is not consistent with the original data. For example, if there are foreign key constraints in the destination system, the migrated data must satisfy these constraints.
Performance Issues: The migrated data may not be optimized for the destination system, leading to performance issues.
Security Risks: There is a risk of unauthorized access to the data during the migration process.
Dependencies: There may be dependencies between different data elements that are not taken into account during the migration process, leading to issues.
Complexity: Migrating large volumes of data can be a complex process, requiring specialized tools and resources.

Overall, it is important to plan and test the data migration process carefully to minimize the risks and ensure a smooth transition.

Standards[edit]

Discuss problems that may arise as a part of data migration.

References[edit]

↑ http://www.flaticon.com/

[1] ttp://www.flaticon.com/

[1]

@@ Line 1: / Line 1: @@
 [[file:system_fund.png|right|frame|System Fundamentals<ref>http://www.flaticon.com/</ref>]]
-Data migration definition
+When we move data from one system to another we transfer it. However, when you aim to permanently move data (most commonly when you are building a new system), we can say you are '''migrating''' data. Please know this is almost always a '''deliberate''' process.
-== Real-world practical advice ==
+There are several problems that may arise as part of data migration:
-When a system implementation is poorly planned, there is an increased chance the system will fail. Don't just think "hey, I'll just make sure the system works". You must be responsible for ensuring there is a good plan for implementation. I have seen perfectly good systems fail because implementation was done poorly. It comes down to '''good planning'''.
+# Data Loss: There is a risk of data loss during the migration process. This can occur due to various reasons such as network issues, hardware failures, or data corruption.
+# Data Incompatibility: The source and destination systems may use different data formats or structures, leading to data incompatibility issues.
+# Data Integrity: Data integrity problems can arise if the migrated data is not consistent with the original data. For example, if there are foreign key constraints in the destination system, the migrated data must satisfy these constraints.
+# Performance Issues: The migrated data may not be optimized for the destination system, leading to performance issues.
+# Security Risks: There is a risk of unauthorized access to the data during the migration process.
+# Dependencies: There may be dependencies between different data elements that are not taken into account during the migration process, leading to issues.
+# Complexity: Migrating large volumes of data can be a complex process, requiring specialized tools and resources.
-There is another real-world issue you should be aware of. There is a wide range of emotional reactions to change. Some users will welcome change, others will be uncertain, some will be openly hostile whilst others will attempt to sabotage it. Training issues may require organizations to restructure their workforce. New systems often accompany a wide range of emotional reactions. Communication about the change, and sensitivity about users change should be well-managed.
+Overall, it is important to plan and test the data migration process carefully to minimize the risks and ensure a smooth transition.
-== Do you understand this material? ==
-A small business has a computer kiosk inside the store which allows customers to sign up for a email newsletter. If a customer signs up for a newsletter inside the store, they will get a 10% discount on their first purchase at the store. The owner hopes this 10% discount will be an incentive for customers to sign up for the email newsletter.  The business will then regularly  email the customers special offers and savings. The business owner expects to benefit from this system by having increased sales. The customers expect to benefit from this system by having access to special offers, to save money, and to see what is new and trendy at their store.
-Question 1: Evaluate alternative installation processes.
-Question 2: Write a plan for implementing this system. Explain your rationale.
-== Do you have an advanced understanding of this material? ==
-A school of 900 students has a secure web-based application which manages attendance data. The school administrators carefully track attendance for the students so it can identify when students have been absent for a customizable threshold. For example, the school might set a threshold of 5 absences within 30 days, which then automatically notifies the student, parent, and teacher there is a problem with attendance. The threshold might be 3 times within 10 days, or something like that. The system keeps track of attendance and tardies. The system has customizable attendance codes. For example, "absence for school trip", "excused absence", "medical absence" are all allowed absence codes.
-School administrators expect to benefit by having data about attendance so they can support students and parents to be in school. School administrators also expect to benefit by giving parents and students information about attendance (so parents can support their children to be in school). Finally, school administrators expect to benefit by using attendance data to apply for government funding (as they can prove how many students were in class on a specific day).
-Parents expect to benefit by knowing when their children are in school or miss school. This way parents can support their children to be in school. Being in school is a '''shared value''' between the school and the parent.
-Students expect to benefit by understanding how many days of school of they have missed. The school expects students to have a strong "ownership of learning" and manage their attendance.
-Question 1: Evaluate alternative installation processes.
-Question 2: Write a plan for implementing this system. Explain your rationale.
 == Standards ==
-* Discuss problems that may arise as a part of data migration. [[Level 3]]
+* Discuss problems that may arise as a part of data migration.
 == References ==