44 O. Avci et al. Fig. 5.4 Illustration of the real-time web-based damage detection system structures to compute the probability of damage values that display the existing structural condition. The system is also capable of evaluating vibration serviceability levels for human comfort. As a result, the raw vibration signals, the extracted damage indices, and vibration levels at each accelerometer location are published to an online MySQL database through the MATLAB Database Toolbox. In the setup used by the authors, the raw acceleration signals are updated every 2 seconds, and the damage indices and acceleration vibration levels are updated every 30 seconds. MySQL database is used to test the developed damage detection system. MySQL is an open-source database used for the development of scalable web applications. Through PHP scripting, a web application can connect, interact, and manipulate a MySQL database [62–64]. A connection can be formed between MATLAB and MySQL databases using the Database Toolbox along with a suitable JDBC driver. MySQL database presented in this paper includes three tables per structure, as shown in Fig. 5.4. In the figure, the first table is for storing the raw vibration signals, while the second and third tables are for storing the extracted damage indices and vibration levels, respectively. The stored data can be viewed and downloaded via phpMyAdmin, a software used for MySQL Databases. The authors also developed a web application enabling the user to monitor the structural condition and vibration levels of multiple structures. This web application efficiently works on personal computers and smartphones. Based on the application interface shown in Fig. 5.4, for each monitored structure, the existing damage indices (shown as DI) and vibration levels (shown as RMS) are placed on the top left corner of each frame dedicated to the monitored structure. The real-time raw acceleration time-history signal at a selected location is shown under the frame of the monitored structure. The users can choose from the various accelerometer locations on the structure to see raw acceleration signals in real time. The web application communicates with the MySQL Database through PHP scripts which conduct the required SQL queries. JavaScript and JSON are utilized to update the interface every second to get the latest information from the database. These updates enable the live display of live raw accelerations, vibration levels, and real-time damage indices.
RkJQdWJsaXNoZXIy MTMzNzEzMQ==