Application of a Large-Scale Database System for the Analysis and Design of the US EPR™ Standard Nuclear Power Plant

Due to the increased size and complexity of large-scale commercial and industrial structures, it is increasingly challenging to manage key engineering data including analysis and design results of these structures. This paper presents a novel approach of using large-scale database systems as a means to gather, organize and manage key analysis and design results of a large-scale structure. Specifically, this paper describes in detail the development process of the backend database management system (DBMS) for the U.S. EPR™ Standard Nuclear Power Plant (NPP) Nuclear Island (NI) structures. The database system consists of three parent database tables to represent three representative groups of load combinations applicable to the U.S. EPR™ Standard NPP. Inheriting all characteristics of an applicable parent table, a primary child table in the database system represents a particular U.S. EPR™ NI Safety-Related structure in its entirety while a secondary child table a group of slabs or walls of the structure. Each secondary table is comprised of database fields that are representative of various structural demands, section capacities, reinforcing ratios, and demand-to-capacity ratios for three reinforced concrete design conditions (i.e., combined axial force and bending design, in-plane shear design, and out-of-plane shear design). The complete database system with fully populated tables is a central repository where all analysis and design results for the U.S. EPR™ NI Common Basemat structures are stored and sorted. To facilitate data queries from the developed backend database system, this paper introduces a user-friendly frontend interface program developed using Visual Basic Application (VBA) with Excel. Potential benefits of the developed database system are demonstrated with simple application examples involving simple data queries only followed by complex engineering tasks that require a more advanced form of data queries.