Browse > Article
http://dx.doi.org/10.12989/sss.2016.17.4.669

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)
Publication Information
Smart Structures and Systems / v.17, no.4, 2016 , pp. 669-690 More about this Journal
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
cyber infrastructure; bridge monitoring; bridge information modeling; NoSQL database;
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
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.   DOI
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.   DOI
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.   DOI
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.   DOI
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.   DOI
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 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.
20 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.   DOI
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.   DOI
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 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.   DOI
28 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.   DOI
29 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.
30 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.
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 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).
35 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.
36 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.
37 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).
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.   DOI
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 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.
43 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.
44 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.
45 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.
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.   DOI
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.