Proceedings of the 42nd Annual Conference on Deep Foundations, 2017, New Orleans, LA, USA, (DFI)
Data Normalization and User Interface Design for the Nevada Department of Transportation Deep Foundation Load Test Database
Austin Metz, Kevin Stanton and Ramin Motamed
A recent study calibrated Load and Resistance Factor Design (LRFD) resistance factors for local soil conditions in the Las Vegas Valley. As a part of this calibration, an extensive database of drilled shaft load tests and associated subsurface soil information were collected and compiled. This database, deemed the Nevada Department of Transportation Deep Foundation Load Test Database or NDFLTD, was designed with the presentation of load test data, the subsurface soil conditions, and the spatial distribution of the data in mind. In addition, the NDFLTD was developed in a way that allows additional data to be added as it becomes available. As such, the rules of database normalization were followed to allow for additional and different types of data to be added to the database and reports. Microsoft Access was chosen to present the data because it is easily accessible to anyone with Microsoft office software, it has a quick learning curve, and it has the ability to present a relational database. The largest obstacle faced when creating the NDFLTD was normalizing the data used in the LRFD calibration, with the goal of reaching the 5th normal form.
|article #2771; publication #1037 (AM-2017)|