SHM data management system using MySQL databse with MATLAB and Web interfaces

  • Koo K
  • de Battista N
  • Brownjohn J
  • 20


    Mendeley users who have this article in their library.
  • 14


    Citations of this article.


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.

Author-supplied keywords

  • Data management
  • Health
  • Health monitoring
  • Monitoring
  • SHM
  • Structural health
  • structural health monitoring

Get free article suggestions today

Mendeley saves you time finding and organizing research

Sign up here
Already have an account ?Sign in

Find this document

  • PUI: 370545723
  • SCOPUS: 2-s2.0-84890874150
  • SGR: 84890874150


  • K Y Koo

  • N de Battista

  • J M W Brownjohn

Cite this document

Choose a citation style from the tabs below

Save time finding and organizing research with Mendeley

Sign up for free