This paper represents a SHM data management system (SDMS) built on MySQL database management system (DBMS) for efficient storage, retrieval and sharing of extremely large measurement data sets constantly acquired from SHM systems. The SDMS have a MATLAB interface and Web Interfaces so that SHM researchers can access vast data sets of the SDMS easily & instantly. MySQL is a relational DBMS with open sources, freely usable under the GNU General Public License. Two types of database tables were utilized in the data management system: 1) time history tables and 2) a summary table. Time history tables store raw time history measurements from each measurement system. After data processing or averaging for each 30 minutes record of high-rate sampled data, a compressed or represented value is stored into the summary table in order to provide an overview of the full data set. MATLAB interfaces to the database are developed based on mYm, an open source MySQL Wrapper for MATLAB, to retrieve SHM data into the MATLAB workspace with a few simple commands and to store processed results back into the database. Application examples of the SDMS are presented for Tamar Bridge and Humber Bridge.
Mendeley saves you time finding and organizing research
Choose a citation style from the tabs below