Development of drilled shaft load tests database and web-based system

• Main Authors: Min-Ru Liao, 廖敏如
• Other Authors: Yit-Jin Chen
• Format: Others
• Language: zh-TW
• Published: 2012
• Online Access: http://ndltd.ncl.edu.tw/handle/33738920664094566049

碩士 === 中原大學 === 土木工程研究所 === 100 === A pile load test is regarded as an essential tool not only for verifying the reliability of pile design but also for providing a rational construction. Moreover, the information about pile load tests can be used as bases in the development of theoretical formulas through back-calculation analysis. However, most pile load test data are in flat-file storage and are not well-organized. The lack of management of these useful data can result to difficulty in retrieval of specific information or even possible data loss. In this study, axial drilled shaft load test data were collected from around the world and were collated. The Entity-Relationship (ER model) model was used to design the structure of the database in order to store and manipulate the data in the MySQL database system. Through the MySQL database, an administrator can effectively manage the database information, and can easily store and manipulate data. Further, the use of SQL (Structured Query Language) provides quick browsing or query from the information contained in the database. To develop a more user-friendly database system, after completion of the drilled shaft load test database, a web-based system was developed. The web-based system enabled direct browsing and faster retrieval of pile load test information. To achieve the purpose of data sharing, this system is made accessible to geotechnical engineers and researchers. The data can be useful bases for design and construction analysis. The web-based system also includes “upload” function which allows user to upload useful and essential pile load test data. This can permit the extensibility of the database resulting to better contribution in the field of geotechnical engineering.