Skip to main content

Table Migration Project

Project Backgound​

In the basis of data systems, there are often tables with very large and complex data that can affect the performance and efficiency of the work process. Splitting one large table into several smaller tables is a frequently used solution to overcome this problem. This process also has an impact on eliminating the use of third-party services that usually support the System Administrator's work in creating courses.

Objectives​

  1. Improves Performance: By breaking down one large table into several smaller tables, it is expected that the access time and queries to the data will be faster and more efficient.
  2. Work Process Optimisation: Enable separation of the use of third-party services, resulting in a more structured and focused work process.
  3. Increased Scalability: Make it easy to add or reduce tables as needed without disrupting the entire system.

Scopes​

  1. Existing Table Analysis: Analyse existing tables to identify data that can be split into multiple tables.
  2. New Table Design: Designing a new smaller table structure based on the analysis results.
  3. Data Migration: Moving data from large tables to new tables according to the design that has been made.
  4. Integration with Third Party: Customise the use of Admin Panel and Regular Academy for each new table formed according to the needs of the work process.

Benefits​

  1. Data Access Efficiency: Query against smaller tables will be faster and more efficient.
  2. Flexibility in Using Admin Panel: Being able to use homemade products more specifically and optimally according to the characteristics and data needs of each table.
  3. Better Data Management: Separation of data into multiple tables allows for more structured and organized data management.

Implementation Process​

  1. Identify Data that Can Be Split: Identifying parts of the data that have strong relationships and can be split into smaller tables.
  2. Table Structure Design: Designing new tables by considering the relationships between tables and the needs of homemade products.
  3. Data Migration and Transformation: Moving data from large tables to new tables while ensuring data integrity is maintained.
  4. System Customisation and Admin Panel: Adjusting the working system and integration with the Admin Panel according to the new table structure.
  5. Testing and Validation: Perform testing to ensure that the changes do not cause problems and the system runs as expected.

Project Team Involved​

  • Project Manager: Media
  • BackEnd Engineer: Naufal, Kukuh, Fauzan
  • FrontEnd Engineer: Dilla, Syehfi
  • Mobile Engineer: Fandy
  • System Administrator: Sukma
  • Technical Writer: Media
  • Quality Assurance: Zikel