JSON_Partial_Update

This file describes how the performance tests in the paper "The Advantage of Partial Updates for Modification of JSON Data" can be reproduced. (All necessary files can be found in the zip file called "JSON_Partial_Update").Creation of the tables<br>First, the four tables must be created. The corresponding SQL statements can be found in the file "!Figure2a.docx" (see cases CT1 till CT4).Initial load<br>Second, the data must be loaded in these four tables. To load data into the "large" tables, use the SQL statements given in the file "Figure2a.docx" (see cases I3 and I4). To load the tables table_text_30K and table_json_30K with data, execute the statements given in the files INSERT_table_text and INSERT_table_json, respectively. To reach the size of the tables used in the paper, execute each INSERT statement 25 times.Different UPDATE statements<br>All UPDATE statements used for performance measurement are given in the files "!Figure2a.docx" and "!Figure2b.docx". The paper describes which UPDATE statement is used for a particular measurement. For instance, to measure the performance of the topic "Insert an Array's Element" (section 5.2.7), the UPDATE statements in IA1 till IA4 should be used. <br>