• IE interfaces
• /
• v.16 no.4
• /
• pp.485-495
• /
• 2003

This paper reports on the application of the integration of mathematical programming model and database in a decision support system (DSS) for the planning of the multi-reservoir operating system. The DSS is based on a multi-objective, mixed-integer goal programming (MIGP) model, which can generate efficient solutions via the weighted-sums method (WSM). The major concern of this study is seamless, efficient integration between the mathematical model and the database, because there are significant differences in structure and content between the data for a mathematical model and the data for a conventional database application. In order to load the external optimization results on the database, we developed a systematic way of naming variable/constraint so that a rapid identification of variables/constraints is possible. An efficient database structure for planning of the multi-reservoir operating system is presented by taking advantage of the naming convention of the variable/constraint.

• Korean Journal of Construction Engineering and Management
• /
• v.6 no.4 s.26
• /
• pp.190-198
• /
• 2005

This study describes the digitalization of technical documents of construction projects using database for storage and XML for exchange format on the web. First, for this purpose, the requirements for effective digitalization are identified. Second, the strategies for using database and XML are presented. These strategies include the way to store and search for the technical documents, to draw up the XML document for some parts of the technical documents, to arrange the components in their proper hierarchy, to manage the graphics and mathematical expressions in database and XML documents. Finally we discussed the validities of the results of this study by partial implementation for structural design sheets which has all the characteristics of technical documents.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.15 no.5
• /
• pp.1111-1118
• /
• 2011

Several data from equipments on shipboard have been used for the safe navigation of ships. Due to the varieties of data, however, there may be difficulties to manage those data separately. Therefore, it can be effective to develop database for the integrated management of ship data. However, the database may become full soon because huge amount of data are saved continuously. To cope with this problem, this paper proposes multistage database which can always keep the database under full by means of sampling mechanism. To verify the functionality of the methodology, a prototype system has been implemented and tested.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.6 no.5
• /
• pp.653-660
• /
• 2002

This paper proposes a method for storing graphs and defining graph algorithms based on the well-developed relational database. In this method, graphs are represented in the form of relations. Each vertex and edge of a graph is represented as tuples of the table and saved in a database. We developed a library of graph operations for the storage and management of graphs and the development of graph applications. Furthermore, we defined graph algorithms in terms of relational algebraic operations such as projection, selection, and join. They can be implemented with the database language such as SQL. This database approach provides an efficient methodology to deal with very large-scale graphs and to support the development of graph applications.

• Journal of the Korean Institute of Gas
• /
• v.12 no.3
• /
• pp.56-63
• /
• 2008

We have garnered 3,593 data of gas [Natural Gas (NG) and Liquefied Petroleum Gas (LPG)] accidents reported for 16 years from 1991, and then analyzed the accidents according to their types and causes based on the classified database. According to the results the gas leak has been the most common accident followed by the explosion and then fire accidents. The most frequent accident-occurring locations for fire, explosion and leak are recognized around the valve, hose and pipeline, respectively. In addition, we have applied the Poisson analysis to predict the most-likely probabilities of fire, explosion and release in the upcoming 5 years. From this research we have assured the successive database updating will highly improve the anticipating-probability accuracy and thus it will play a key role as a significant safety-securing guideline against the gas disasters.

• Journal of KIISE:Databases
• /
• v.29 no.2
• /
• pp.89-98
• /
• 2002

As XML has become an emerging standard for information exchange on the World Wide Web it has gained attention in database communities to extract information from XML seen as a database model. Recently, many researchers have addressed the problem of storing XML data and processing XML queries using traditional database engines. Here, most of them have used relational database systems. In this paper, we show that OODBSs can be another solution. Our technique generates an OODB schema from DTDs and processes XML queries, Especially, we show that the semi-structural part of XML data can be represented by the 'inheritance' and that this can be used to improve query processing.

• Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
• /
• v.40 no.5
• /
• pp.393-402
• /
• 2022

Effective data management of underground facilities is very important in terms of human life. For this, input of up-to-date and high-accuracy data should be preceded. Therefore, it is important to have an efficient data input method. In this study, by developing a sewage facility site survey program using open source software, paper drawings could be replaced with tablet PCs. By using a tablet PC, figures and property information acquired from the field are transmitted in real time through a database server. PostGIS query is developed to automate structured editing to minimize manual work in constructing a GIS (Geographic Information System) database for sewage facilities. did. In addition, the database was built using the sewage facility GIS database building program. As a result of comparing and analyzing the existing sewage facility database construction, work process, and work time, the work process was simplified and work time was shortened. In addition, through simple customization of open source software, it will be able to be used for field surveys and database construction in other fields.

• Journal of Internet Computing and Services
• /
• v.23 no.2
• /
• pp.71-77
• /
• 2022

In this paper, a database is collected for extending the speech synthesis model to a model that synthesizes speech according to emotions and generating facial expressions. The database is divided into male and female data, and consists of emotional speech and facial expressions. Two professional actors of different genders speak sentences in Korean. Sentences are divided into four emotions: happiness, sadness, anger, and neutrality. Each actor plays about 3300 sentences per emotion. A total of 26468 sentences collected by filming this are not overlap and contain expression similar to the corresponding emotion. Since building a high-quality database is important for the performance of future research, the database is assessed on emotional category, intensity, and genuineness. In order to find out the accuracy according to the modality of data, the database is divided into audio-video data, audio data, and video data.

• Structural Engineering and Mechanics
• /
• v.69 no.5
• /
• pp.579-589
• /
• 2019

Numerous experimental studies have been conducted on reinforced concrete (RC) beams strengthened in shear with externally bonded fiber reinforced polymer (EBFRP). The objectives of this work are to study the behavioral trends of shear strengthened EBFRP RC beams after updating the existing database. The previously published databases have been updated, enriched and cross checked for completeness, redundancy and consistency. The updated database now contains data on 698 EBFRP beams and covers the time span from 1992 to 2018. The collected database then refined applying certain filters and used to investigate and capture better interactions among various influencing parameters affecting the shear strength of EBFRP beams. These parameters include the type and properties of FRP, fiber orientation as well as the strengthening scheme, the shear and the longitudinal steel reinforcement ratios, the shear span ratio, and the geometry of the member. The refined database is used to test the prediction accuracy of the existing design models. Considerable scatters are found in the results of all tested prediction models and in many occasions the predictions are unsafe. To better understand the shear behavior of the EBFRP RC beams and then enhance the prediction models, it was concluded that focused experimental programs should be carried out.

• Wind and Structures
• /
• v.32 no.5
• /
• pp.439-452
• /
• 2021

The concept of Performance objective assessment is extended to wind engineering. This approach applies using the Database-Assisted Design technique, relying on the aerodynamic database provided by the National Institute of Standards and Technology (NIST). A structural model of a low-rise building is analyzed to obtain influence coefficients for internal forces and displacements. Combining these coefficients with time histories of pressure coefficients on the envelope produces time histories of load effects on the structure, for example knee and ridge bending moments, and eave lateral drift. The peak values of such effects are represented by an extreme-value Type I Distribution, which allows the estimation of the gust wind speed leading to the mean hourly extreme loading that cause specific performance objective compromises. Firstly a fully correlated wind field over large tributary areas is assumed and then relaxed to utilize the denser pressure tap data available but with considerably more computational effort. The performance objectives are determined in accordance with the limit state load combinations given in the ASCE 7-16 provisions, particularly the Load and Resistance Factor Design (LRFD) method. The procedure is then repeated for several wind directions and different dominant opening scenarios to determine the cases that produce performance objective criteria. Comparisons with two approaches in ASCE 7 are made.