INCREASING THE FUNCTIONALITY OF SOFTWARE THROUGH DATA RESTRUCTURING (Case Study: Academic Information System of Faculty of Computer Science, Universitas Sriwijaya)

• Main Author: FACHRURROZI (NIM 23506007), M.
• Format: Theses
• Language: Indonesia
• Online Access: https://digilib.itb.ac.id/gdl/view/8580
• Institution: Institut Teknologi Bandung

Academic Information system is one important part in college's academic activity. System must be able to accommodate changes due to technology and data amount growth and improvement, so change in software must be made to improve its functionality. This change can affect data that exist in old system, thus data have to be protected so it can be used in new system later. One usable method is data restructuring, which is to change data structure and its DBMS environment. Data restructuring is conducted with some steps, consist of old system analysis, data reengineering, implementation of reengineering result by moving data from the old to the new system, and conducting test to data in it's new environment. Analysis Phase is conducted to detect "database smells" that exist in old system databases. Later, reengineering step conducted to overcome its problems until "database smells" can be avoided. Testing can be conducted by undertaking query to every information request from data, for example, viewing student's Transcript. Data restructuring process is slow due to poor documentation, forcing engineer to conduct survey and tracing of the old system. Usage of tools is conducted to move data that exist in old system into new system.