Geotechnical Earthquake Engineering and Soil Dynamics V
Next-Generation Liquefaction (NGL) Case History Database Structure
Publication: Geotechnical Earthquake Engineering and Soil Dynamics V: Liquefaction Triggering, Consequences, and Mitigation (GSP 290)
ABSTRACT
This paper presents the organizational structure (schema) of the next-generation liquefaction (NGL) relational database. The schema describes the tables, fields, and relationships among the tables, and provides an important resource for users who wish to interact with the database by writing queries. Structured relational databases are not commonly utilized in the natural hazards community, where file repositories are more commonly used and often called “databases”. This paper also discusses what a relational database is, and why this approach was adopted for the NGL project.
Get full access to this chapter
View all available purchase options and get full access to this chapter.
ACKNOWLEDGEMENTS
Financial support for the NGL project is provided by California Department of Transportation (Caltrans) through the Pacific Earthquake Engineering Research Center (PEER), and by the U.S. Nuclear Regulatory Commission (NRC) through the Southwest Research Institute (SWRI). The authors would like to thank Tom Shantz of the Caltrans, Thomas Weaver of NRC, and John Stamatakos and Miriam Juckett of SWRI for their support of the project. The authors acknowledge the contributions by Mike Liu, Sjoerd Van Ballegooey, Kristin Ulmer, Russell Green, Mike Greenfield Christine Beyzaei, and Jonathan Bray for populating the database. We would also like to acknowledge the participants of the NGL workshop for their valuable input on the schema.
REFERENCES
Bozorgnia, Y., Abrahamson, N. A., Al Atik, L., Ancheta, T. D., Atkinson, G. M., Baker, J. W., Baltay, A., Boore, D. M., Campbell, K. W., Chiou, B.S.-J., Darragh, R., Day, S., Donahue, J., Graves, R. W., Gregor, N., Hanks, T., Idriss, I. M., Kamai, R., Kishida, T., Kottke, A., Mahin, S. A., Rezaeian, S., Rowshandel, B., Seyhan, E., Shahi, S., Shantz, T., Silva, W., Spudich, P., Stewart, J. P., Watson-Lamprey, J., Wooddell, K., and Youngs, R. (2014). “NGA-West2 research project,” Earthquake Spectra,30, 973–987.
Codd, E.F. (1972). Further normalization of the data base relational model. In Data Base Systems, Courant Institute Computer Science Symposia Series, vol. 6, R. Rustin, Ed., Prentice-Hall, Englewood Cliffs, N.J.
Kishida, T., Bozorgnia, Y., Abrahamson, N.A., Ahdi, S.K., Ancheta, T.D., Boore, D.M., Campbell, K.W., Darragh, R.B., Magistrale, H., and Stewart J.P. (2017). “Development of NGA-Subduction database,” Proc. 16th World Conf. on Earthquake Eng., Santiago, Chile (Paper No. 3452).
Pérez, F. and Granger, B.E. (2007). “IPython: A System for Interactive Scientific Computing, Computing in Science and Engineering”, 9(3), 21–29. URL: http://ipython.org
Rathje, E.M., Dawson, C., Padgett, J.E., Pinelli, J.-P., Stanzione, D., Adair, A., Arduino, P., Brandenberg, S.J., Cockeril, T., Esteva, M., Haan, F.L. Jr., Hanlon, M., Kareem, A., Lowes, L., Mock, S., and Mosqueda, G. (2017). “DesignSafe: A new cyberinfrastructure for natural hazards engineering.” Natural Hazards Review. 18(3).
Stewart, J.P., Kramer, S.L., Kwak, D.Y., Greenfield, M.W., Kayen, R.E., Tokimatsu, K., Bray, J.D., Beyzaei, C.Z., Cubrinovski, M., Sekiguchi, T., Nakai, S., and Bozorgnia, Y. (2016). “PEER-NGL project: Open source global database and model development for the next-generation of liquefaction assessment procedures.” Soil Dyn. Earthquake Eng.,91, 317–328.
Information & Authors
Information
Published In
Geotechnical Earthquake Engineering and Soil Dynamics V: Liquefaction Triggering, Consequences, and Mitigation (GSP 290)
Pages: 426 - 433
Editors: Scott J. Brandenberg, Ph.D., University of California, Los Angeles, and Majid T. Manzari, Ph.D., George Washington University
ISBN (Online): 978-0-7844-8145-5
Copyright
© 2018 American Society of Civil Engineers.
History
Published online: Jun 7, 2018
ASCE Technical Topics:
- Business management
- Case studies
- Computing in civil engineering
- Construction engineering
- Construction management
- Databases
- Design (by type)
- Disaster risk management
- Disasters and hazards
- Education
- Engineering fundamentals
- Geomechanics
- Geotechnical engineering
- Information Technology (IT)
- Methodology (by type)
- Natural disasters
- Organizations
- Practice and Profession
- Project management
- Research methods (by type)
- Soil liquefaction
- Soil mechanics
- Soil properties
- Structural design
- Structural reliability
- Writing skills
Authors
Metrics & Citations
Metrics
Citations
Download citation
If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.