Optimizing Data Storage in Handling Dynamic Input Fields with JSON String Compression
Irfan Darmawan, Alam Rahmatulloh, Iqbal Muhammad Fajar Nuralam, Rianto Rianto, Rohmat Gunawan · 2020
Dynamic input fields are a solution for managing multiple input values in a web-based application form. Dynamic multiple image upload is an implementation of the dynamic input field. Handling dynamic upload of multiple images by storing the image path will cause the existence of similar string data in one field in the table stored in the database. Creating a unique table in a database to store dynamic data is a workable solution. However, it is potentially a waste of tables and records, so that the database file size becomes larger and data access speeds are longer. To overcome this problem in this study, string data obtained from the dynamic input field are converted into JSON format and compressed with Zlib, before being saved into the database. The experimental results in this study indicate that the integration of JSON and Zlib can be applied to the handling of dynamic input field forms. The average speed of the data storage process by applying this technique is 50.36% faster than the conventional method. In comparison, the database file size decreased by about 37.58% smaller than using conventional techniques.