• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.26 no.3
• /
• pp.1-9
• /
• 2003

Databases are central to business information systems and RDBMS is most widely used for the database system. Normalization was designed to control various anomalies (insert, update, delete anomalies). However, normalized database design does not account for the tradeoffs necessary for performance. In this research, I model a database design method considering denormalization of duplicating attributes in order to reduce frequent join processes. This model considers response time for processing each select, insert, update, delete transaction, and for treating anomalies. A branch and bound method is proposed for this model.

• Asia pacific journal of information systems
• /
• v.7 no.3
• /
• pp.23-37
• /
• 1997

Although numerous models and solution algorithms to design efficient distributed databases have been developed, very few have been validated for their effectiveness. In this paper, we develop a simulation system which can be used to analyze and validate the average response time of distributed database designs. Our simulation system models comprehensive query processing strategies such as semijoin as well as a concurrency control mechanism We analyze and validate an average response time distributed database design model using our simulation system.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 1995.09a
• /
• pp.46-58
• /
• 1995

Although numerous distributed database design models and solution algorithms have been developed, very few have been validated. Validation is critical to the successful application of such models to distributed database design. In this paper, we develop a simulation system for distributed database design. We then analyze and validate an average response time model using simulation. The simulation results demonstrate that the average response time model is reasonably accurate.

• Proceedings of the Korean Society for Noise and Vibration Engineering Conference
• /
• 2000.06a
• /
• pp.619-624
• /
• 2000

Design of experiments based on Taguchi's orthogonal array is utilized for exploring the design space and for building response surface models of insulator and isolator database in order to facilitate the effective solution of multi-objective optimization commonly occurred in NVH problems. Response surface models, called engineering database of design space, provide an efficient means to rapidly model the trade-off among many conflicting NVH goals in automotive. In the design of insulator and isolator in automotive interior part, it is important not only to construct effective matrices of NVH but also to build up engineering database of current products. The experimental design especially based on orthogonal array and the nonlinear optimization algorithms are successfully used together to obtain the optimal design of insulator and isolator. The $2^{nd}$ order response surface models of absorption coefficient and insertion loss are constructed by using modified Taguchi's $L_{12}2^13^7$ orthogonal array and successfully used in optimal design of insulator and isolator.

• Earthquakes and Structures
• /
• v.14 no.5
• /
• pp.389-398
• /
• 2018

The seismic isolation system makes a structure isolated from ground motions to protect the structure from seismic events. Seismic isolation techniques have been implemented in full-scale buildings and bridges because of their simplicity, economic effectiveness, inherent stability and reliability. As for the responses of an isolated structure due to seismic events, it is well known that the most uncertain aspects are the seismic loading itself and structural properties. Due to the randomness of earthquakes and uncertainty of structures, seismic response distributions of an isolated structure are needed when evaluating the seismic fragility assessment (or probabilistic seismic safety assessment) of an isolated structure. Seismic response time histories are useful and often essential elements in its design or evaluation stage. Thus, a large number of non-linear dynamic analyses should be performed to evaluate the seismic performance of an isolated structure. However, it is a monumental task to gather the design or evaluation information of the isolated structure from too many seismic analyses, which is impractical. In this paper, a new methodology that can evaluate the seismic fragility assessment of an isolated structure is proposed by using stochastic response database, which is a device that can estimate the seismic response distributions of an isolated structure without any seismic response analyses. The seismic fragility assessment of the isolated nuclear power plant is performed using the proposed methodology. The proposed methodology is able to evaluate the seismic performance of isolated structures effectively and reduce the computational efforts tremendously.

• Earthquakes and Structures
• /
• v.9 no.5
• /
• pp.937-956
• /
• 2015

Seismic isolation systems decouple structures from ground motions to protect them from seismic events. Seismic isolation devices have been implemented in many full-scale buildings and bridges because of their simplicity, economic effectiveness, inherent stability, and reliability. It is well known that the most uncertain aspect for obtaining the accurate responses of an isolated structure from seismic events is the seismic loading itself. It is needed to know the seismic response distributions of the isolated structure resulting from the randomness of earthquakes when probabilistic designing or probabilistic evaluating an isolated structure. Earthquake time histories are useful and often an essential element for designing or evaluating isolated structures. However, it is very challenging to gather the design and evaluation information for an isolated structure from many seismic analyses. In order to evaluate the seismic performance of an isolated structure, numerous nonlinear dynamic analyses need to be performed, but this is impractical. In this paper, the concept of the stochastic response database (SRD) is defined to obtain the seismic response distributions of an isolated structure instantaneously, thereby significantly reducing the computational efforts. An equivalent model of the isolated structure is also developed to improve the applicability and practicality of the SRD. The effectiveness of the proposed methodology is numerically verified.

• Journal of the Korean Institute of Gas
• /
• v.19 no.5
• /
• pp.61-68
• /
• 2015

This study develop accident response program for the hazardous materials(HAZMAT) transport vehicle with materials database and guidelines for accident response. Guidelines was developed by guideline develop processes of FEMA after identify hazards. Developed material database was applied the GHS. also database was optimized by removing data that can confuse to accident response. Finally, This study verify developed programs through case study.

• Korean Journal of Construction Engineering and Management
• /
• v.5 no.4 s.20
• /
• pp.79-86
• /
• 2004

One of the most difficult tasks in pavement management information systems is establishing the links between performance measures of a structure and the design and construction inputs. In-situ pavement performance can be considered a response variable to many project input variables, such as design, construction, and traffic loading effects. If we are to fully understand the component of pavement performance and specify the inputs through design and construction specifications to achieve that performance we must develop quantitative relationship between input and response variables through a scientific, fully integrated Pavement Performance Analysis System (PPAS). Hence, the objective of this study is to design a database model required for developing an effective database template that will allow analysis of pavement performance measures based on design and construction information linked by location. In order to select the most appropriate database model, a conceptual database model (Entity Relationship Model) and dimensional model, which is believed to be the most effective modeling technique for data warehouse project, are designed and compared. It is believed that other state highway agencies could adopt the proposed design strategy for implementing a PPAS at the discretion of the state highway agencies.

• Journal of the Earthquake Engineering Society of Korea
• /
• v.20 no.4
• /
• pp.235-243
• /
• 2016

Korea is part of a region of low to moderate seismicity located inside the Eurasian plate with bedrock located at depths less than 30 m. However, the spectral acceleration obtained from site response analyses based on the geologic conditions of inland areas of the Korean peninsula are significantly different from the current Korean seismic code. Therefore, suitable site classification scheme and design response spectra based on local site conditions in the Korean peninsula are required to produce reliable estimates of earthquake ground motion. In this study, site-specific response analyses were performed at more than 300 sites with at least 100 sites at each site categories of $S_C$, $S_D$, and $S_E$ as defined in the current seismic code in Korea. The process of creating a huge database of input parameters - such as shear wave velocity profiles, normalized shear modulus reduction curves, damping curves, and input earthquake motions - for site response analyses were described. The response spectra and site coefficients obtained from site response analyses were compared with those proposed for the site categories in the current code. Problems with the current seismic design code were subsequently discussed, and the development and verifications of new site classification system and corresponding design response spectra are detailed in companion papers (II-development of new site categories and design response spectra and III-Verifications)

• Journal of Korea Multimedia Society
• /
• v.22 no.2
• /
• pp.225-230
• /
• 2019

There are several methods which efficiencies of database are uprise. One of the well-known methods is that segments of database satisfying a query was rapidly accessed and processed. So if it is possible to search completely parallel multiple database segment types which satisfy a query, the response time of the query will be reduced. The matter of obtaining CPS(Completely Parallel Searchable) distribution without redundancy can be viewed as graph theoretic problem, and the operation of ring sum on the graph is used for CPS. In this paper, the parallel algorithm is proposed.