Smart Structures and Systems

Techno-Press (테크노프레스)
권호 표지
DOI QR코드

DOI QR Code

A NoSQL data management infrastructure for bridge monitoring

  • Jeong, Seongwoon (Department of Civil and Environmental Engineering, Stanford University) ;
  • Zhang, Yilan (Department of Civil and Environmental Engineering, University of Michigan) ;
  • O'Connor, Sean (Department of Civil and Environmental Engineering, University of Michigan) ;
  • Lynch, Jerome P. (Department of Civil and Environmental Engineering, University of Michigan) ;
  • Sohn, Hoon (Department of Civil and Environmental Engineering, Korea Advanced Institute of Science and Technology) ;
  • Law, Kincho H. (Department of Civil and Environmental Engineering, Stanford University)
  • Received : 2015.12.22
  • Accepted : 2016.02.17
  • Published : 2016.04.25
⟨ Previous Next ⟩

Abstract

Advances in sensor technologies have led to the instrumentation of sensor networks for bridge monitoring and management. For a dense sensor network, enormous amount of sensor data are collected. The data need to be managed, processed, and interpreted. Data management issues are of prime importance for a bridge management system. This paper describes a data management infrastructure for bridge monitoring applications. Specifically, NoSQL database systems such as MongoDB and Apache Cassandra are employed to handle time-series data as well the unstructured bridge information model data. Standard XML-based modeling languages such as OpenBrIM and SensorML are adopted to manage semantically meaningful data and to support interoperability. Data interoperability and integration among different components of a bridge monitoring system that includes on-site computers, a central server, local computing platforms, and mobile devices are illustrated. The data management framework is demonstrated using the data collected from the wireless sensor network installed on the Telegraph Road Bridge, Monroe, MI.

Keywords

References

  1. Ali, N., Chen, S.S., Srikonda, R. and Hu, H. (2014), "Development of concrete bridge data schema for interoperability", Transportation Research Record, 2406(1), 87-97. https://doi.org/10.3141/2406-10
  2. Bernstein, H.M., Jones, S.A. and Russo, M.A. (2012), "The business value of BIM in North America: multi-year trend analysis and user ratings (2007-2012)", SmartMarket Report, McGraw-Hill Construction, Bedford, MA.
  3. Branson, R. (2014), "Facebook‟s Instagram: Making the switch to Cassandra from Redis, a 75% "Insta" savings," [Online article], Retrieved from: http://planetcassandra.org/blog/interview/facebooks-instagram-making-the-switch-to-cassandra-from-redis-a-75-insta-savings/ (accessed on 16 Dec 2015).
  4. Chen S.S. (2013), "Bridge Data Protocols for Interoperability Local Failure Bridge Data Protocols for Interoperability and Life Cycle Management", [Online article], Retrieved from: http://iug.buildingsmart.org/resources/itm-and-iug-meetings-2013-munich/infra-room/bridge-data-protocols-for-interoperability-and-life-cycle-management (accessed on 16 Dec 2015).
  5. Chen, S.S. and Shirole, A.M. (2006), "Integration of information and automation technologies in bridge engineering and management: Extending the state of the art", Transportation Research Record, 1976(1), 3-12. https://doi.org/10.3141/1976-03
  6. Cheng, J.C.P. and Das, M. (2013), "A cloud computing approach to partial exchange of BIM models", Proceedings of the 30th CIB W78 International Conference.
  7. Cheng, J.C.P., Law, K.H., Bjornsson, H., Jones, A. and Sriram, R. (2010), "A service oriented framework for construction supply chain integration", Autom. Constr., 19(2), 245-260. https://doi.org/10.1016/j.autcon.2009.10.003
  8. Chodorow, K. (2013), "MongoDB: the definitive guide", O'Reilly Media, Inc., [Online book], Retrieved from: http://proquest.safaribooksonline.com/9781449381578?uicode=stanford (accessed on 16 Dec 2015).
  9. Cross, E.J., Koo, K.Y., Brownjohn, J.M.W. and Worden, K. (2013), "Long-term monitoring and data analysis of the Tamar Bridge", Mech. Syst. Signal Pr., 35(1-2), 16-34. https://doi.org/10.1016/j.ymssp.2012.08.026
  10. Datastax (2011), "Netflix gives users exactly what they want-every time," [Online article], Retrieved from: http://www.datastax.com/wp-content/uploads/2011/09/CS-Netflix.pdf (accessed on 16 Dec 2015).
  11. Datastax (2012), "eBay engages customers with personalized recommendations," [Online article], Retrieved from: http://www.datastax.com/wp-content/uploads/2012/12/DataStax-CS-eBay.pdf (accessed on 16 Dec 2015).
  12. Eastman, C., Teicholz, P., Sacks, R. and Liston, K. (2011), BIM handbook: a guide to building information modeling for owners, managers, designers, engineers, and contractors, John Wiley & Sons, Inc., Hoboken, NJ.
  13. Grolinger, K., Higashino, W.A., Tiwari, A. and Capretz, M.A. (2013), "Data management in cloud environments: NoSQL and NewSQL data stores", J. Cloud Comput.: Adv., Syst. Appl., 2(1), 22. https://doi.org/10.1186/2192-113X-2-22
  14. Han, J., Haihong, E., Le, G. and Du, J. (2011), "Survey on NoSQL database", Proceedings of the ICPCA 2011.
  15. Hecht, R. and Jablonski, S. (2011), "NoSQL Evaluation: A use case oriented survey", Proceedings of CSC 2011.
  16. Hewitt, E. (2010), "Cassandra: the definitive guide," O'Reilly Media, Inc., [Safari Book Online], Retrieved from: http://proquest.safaribooksonline.com/9781449399764 (accessed on 16 Dec 2015).
  17. Hou, R., Zhang, Y., O‟Connor, S., Hong, Y. and Lynch, J.P. (2015), "Monitoring and identification of vehicle-bridge interaction using mobile truck-based wireless sensors", Proceedings of the 11th International Workshop on Advanced Smart Materials and Smart Structures Technology, August 1-2, 2015, University of Illinois, Urbana-Champaign, United States.
  18. Hows, D., Membrey, P. and Plugge, E. (2014). "MongoDB Basics," Apress. [Online book], Retrieved from: http://link.springer.com/book/10.1007%2F978-1-4842-0895-3 (accessed on 20 Dec 2015)
  19. Jang, S., Jo, H., Cho, S., Mechitov, K., Rice, J.A., Sim, S., Jung, H., Yun, C., Spencer, Jr., B.F. and Agha, G. (2010), "Structural health monitoring of a cable-stayed bridge using smart sensor technology: deployment and evaluation", Smart Struct. Syst., 6(5-6), 439-459. https://doi.org/10.12989/sss.2010.6.5_6.439
  20. Jeong, S., Byun, J., Kim, D., Sohn, H., Bae, I.H. and Law, K.H. (2015a), "A data management infrastructure for bridge monitoring", Proceedings of the SPIE Smart Structures/NDE Conference, art no. 94350P.
  21. Jeong, S., Zhang, Y., Lynch, J., Sohn, H. and LAW, K.H. (2015b), "A NoSQL-based data management infrastructure for bridge monitoring database", Proceedings of the Structural Health Monitoring 2015 (IWSHM 2015), Stanford University, Stanford, CA, USA, September 1-3, 2015.
  22. Karaman, S.G., Chen, S.S. and Ratnagaran, B.J. (2013), "Three-dimensional parametric data exchange for curved steel bridges", Transportation Research Record, 2331(1), 27-34. https://doi.org/10.3141/2331-03
  23. Koh, H., Park, W. and Kim, H. (2013). "Recent activities on operational monitoring of long-span bridges in Korea," Proceedings of SHMII 2013, pp. 66-82.
  24. Law, K.H., Cheng, J.C.P., Fruchter, R. and Sriram, R. (2016), "Cloud applications in engineering", In Encyclopedia of Cloud Computing, (Eds., Murugesan, S. and Bojanova, I.), Wiley. (in press).
  25. Law, K.H., Smarsly, K. and Wang, Y. (2014), "Sensor data management technologies for infrastructure asset management", In Sensor Technologies for Civil Infrastructures: Applications in Structural Health Monitoring, (Eds., Wang, M.L., Lynch, J.P. and Sohn, H.), Woodhead Publishing, Cambridge, UK, 2(1), 3-32.
  26. Le, T.D., Kim, S.H., Nguyen, M.H., Kim, D., Shin, S.Y., Lee, K.E. and da Rosa Righi, R. (2014), "EPC information services with No-SQL datastore for the internet of things", Proceedings of IEEE RFID 2014.
  27. Li, H., Ou, J., Zhao, X., Zhou, W., Li, H., Zhou, Z. and Yang, Y. (2006), "Structural health monitoring system for the Shandong Binzhou Yellow River Highway Bridge", Comput.-Aided Civil. Infrastruct. Eng., 21(4), 306-317. https://doi.org/10.1111/j.1467-8667.2006.00437.x
  28. Li, T., Liu, Y., Tian, Y., Shen, S. and Mao, W. (2012), "A storage solution for massive IoT data based on NoSQL", Proceedings of the 2012 IEEE International Conference on Green Computing and Communications.
  29. Lynch, J.P., Kamat, V., Li, V.C., Flynn, M., Sylvester, D., Najafi, K., Gordon, T., Lepech, M., Emami-Naeini, A., Krimotat, A., Ettouney, M., Alampalli, S. and Ozdemir, T. (2009), "Overview of a cyber-enabled wireless monitoring system for the protection and management of critical infrastructure systems", Proceedings of the SPIE-The International Society for Optical Engineering, 7294, art no. 72940L.
  30. Lynch, J.P. and Loh, K.J. (2006), "A summary review of wireless sensors and sensor networks for structural health monitoring", Shock Vib. Digest, 38(2), 91-130. https://doi.org/10.1177/0583102406061499
  31. Marzouk, M.M. and Hisham, M. (2011), "Bridge information modeling in sustainable bridge management", Proceedings of the ICSDC 2011.
  32. McFadin, P. (2015), "Getting Started with Time Series Data Modeling," [Online article], Retrieved from: https://academy.datastax.com/demos/getting-started-time-series-data-modeling (accessed on 16 Dec 2015).
  33. McNeill, D.K. (2009), "Data management and signal processing for structural health monitoring of civil infrastructure systems", In Structural Health Monitoring of Civil Infrastructure Systems, (Eds., Karbhari, V. M. and Ansari, F.), CRC Press, Boca Raton, FL.
  34. O'Connor, S.M., Zhang, Y., Lynch, J., Ettouney, M. and van der Linden, G. (2014), "Automated analysis of long-term bridge behavior and health using a cyber-enabled wireless monitoring system", Proceedings of SPIE-The International Society for Optical Engineering, 9063, art. no. 90630Y.
  35. O'Connor, S.M., Zhang, Y. and Lynch, J.P. (2015), "Automated outlier detection framework for identifying damage states in multi-girder steel bridges using long-term wireless monitoring data, Proceedings of the SPIE Smart Structures/NDE Conference, art no. 94370N.
  36. Open Geospatial Consortium (2014), "OGC(R) SensorML: Model and XML Encoding Standard" [online article], Retrieved from: http://www.opengeospatial.org/standards/sensorml (accessed on 16 Dec 2015).
  37. Overschee, P.V. (2002), "Subspace Identification for Linear Systems," [Matlab package]. Retrieved from: http://www.mathworks.com/matlabcentral/fileexchange/2290-subspace-identification-for-linear-systems (accessed on 16 Dec 2015).
  38. Padhy, R.P., Patra, M.R. and Satapathy, S.C. (2011), "RDBMS to NoSQL: Reviewing some next-generation non-relational databases", Int. J. Adv. Eng. Sci. Technol., 11(1), 15-30.
  39. Pedregosa, F., Varoquaux, G., Gramfort, A., Michel, V., Thirion, B., Grisel, O., Blondel, M., Prettenhofer, P., Weiss, R., Dubourg, V. and Vanderplas, J. (2011), "Scikit-learn: Machine learning in Python", J. Machine Learning Res., 12, 2825-2830.
  40. Ray, S. (2002), "Interoperability standards in the semantic web", J. Comput. Inform. Sci. Eng.-ASME, 2, 65-69. https://doi.org/10.1115/1.1480024
  41. Samec, V., Stamper, J., Sorsky, H. and Gilmore, T.W. (2014), "Long span suspension bridges-bridge information modeling", Proceedings of the IABMAS 2014.
  42. Shirole, A.M., Chen, S.S. and Puckett, J.A. (2008), "Bridge information modeling for the life cycle: progress and challenges", Proceedings of the IBSMC08-025.
  43. Smarsly, K., Law, K.H. and Hartmann, D. (2013), "A cyberinfrastructure for integrated monitoring and life-cycle management of wind turbines", Proceedings of EG-ICE 2013.
  44. Sohn, H., Lim, H.J. and Yang, S. (2015), "A fatigue crack detection methodology", Smart Sensors for Health and Environment Monitoring-Springer, KAIST, 233-253.
  45. Thantriwatte, T.A.M.C. and Keppetiyagama, C.I. (2011), "NoSQL query processing system for wireless ad-hoc and sensor networks", Proceedings of the International Conference on Advances in ICT for Emerging Regions, ICTer 2011, art. no. 6075030.
  46. Zhang, Y., Kurata, M., Lynch, J.P., Van der Linden, G., Sederat, H. and Prakash, A. (2012), "Distributed cyberinfrastructure tools for automated data processing of structural monitoring data", Proceedings of the SPIE-The International Society for Optical Engineering, 8347, art no. 83471Y.
  47. Zhang, Y., O‟Connor, S., van der Linden, G., Prakash, A. and Lynch, J. (2016), "SenStore: A scalable cyberinfrastructure platform for implementation of data-to-decision frameworks for infrastructure health management", J. Comput. Civil Eng., 10.1061/(ASCE)CP.1943-5487.0000560, 04016012.
  48. Zhou, G.D. and Yi, T.H. (2013), "Recent developments on wireless sensor networks technology for bridge health monitoring", Mathematical Problems in Engineering, 947867.

Cited by

  1. Big data-enabled multiscale serviceability analysis for aging bridges☆ vol.2, pp.3, 2016, https://doi.org/10.1016/j.dcan.2016.05.002
  2. An information modeling framework for bridge monitoring vol.114, 2017, https://doi.org/10.1016/j.advengsoft.2017.05.009
  3. Big Data for transportation and mobility: recent advances, trends and challenges vol.12, pp.8, 2018, https://doi.org/10.1049/iet-its.2018.5188
  4. A scalable cloud-based cyberinfrastructure platform for bridge monitoring vol.15, pp.1, 2019, https://doi.org/10.1080/15732479.2018.1500617
  5. Development of a BIM-Based Data Management System for Structural Health Monitoring with Application to Modular Buildings: Case Study vol.33, pp.3, 2016, https://doi.org/10.1061/(asce)cp.1943-5487.0000826
  6. The role of structured and unstructured data managing mechanisms in the Internet of things vol.23, pp.2, 2016, https://doi.org/10.1007/s10586-019-02986-2
  7. Big data platform for health monitoring systems of multiple bridges vol.7, pp.4, 2020, https://doi.org/10.12989/smm.2020.7.4.345
  8. IFC and Monitoring Database System Based on Graph Data Models vol.2021, pp.None, 2021, https://doi.org/10.1155/2021/4913394
  9. Critical review of data-driven decision-making in bridge operation and maintenance vol.18, pp.1, 2016, https://doi.org/10.1080/15732479.2020.1833946