• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 2004.10a
• /
• pp.126-132
• /
• 2004

The database design for the management of bridge measurement information is presented in this paper. To express the associated data generated during the whole process of ambient measurement efficiently, requirements analysis for database construction is performed. And to define objects and organize schema conceptual and logical design are performed, which convert data model into logical schema. Finally, physical design is performed using DDL(data defined language). This database is based on the object-relational data modeling approach that has rich expressive power and good reusability in comparison with the traditional entity-relational modeling.

• Proceedings of the KIEE Conference
• /
• 1988.07a
• /
• pp.640-643
• /
• 1988

This paper is concerned with distributed INGRES database system. The main motivation is to provide dynamic reconfiguration and global database consistency. Dynamic reconfiguration will provide proper initial environment to newly generated system. By use of transaction characteristic, database can be maintained in consistent state.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.21 no.47
• /
• pp.139-148
• /
• 1998

CALS IDB (Integrated database) is one of core technologies that embodies the principle of a shared data environment for the life cycle related data in CALS environment. In this study, to successfully share the data, we first classified the data types employed in the CALS environment and then discussed the data heterogeneity issued in data integration processes. To effectively solve this heterogeneity, we proposed the federated database systems as a candidate system especially focusing on the major functions and core element technologies.

• Proceedings of the Korea Multimedia Society Conference
• /
• 2012.05a
• /
• pp.300-300
• /
• 2012

A database is an organized collection of data, today typically in digital form. The data are typically organized to model relevant aspects of reality, in a way that supports processes requiring this information. A good database is designed for a specific use and is constructed with the possibility of growth. In this project, we collect music education data of the East Asia and try to build a database that can share the primary data based on this collection. Hence we can provide opportunity to study about Korea modern music and culture in a broader perspective. In this paper, we explore the database construction methodology for implementing on this project and we see over about data entry and management.

• Proceedings of the KIEE Conference
• /
• 2003.11a
• /
• pp.275-277
• /
• 2003

This paper deals with Object-oriented Database(OODB) which is designed for power system analysis, and describes load flow analysis using OODB. Database management systems are widely used and achieve high reliability of data management in the engineering fields. However conventional database systems, relational database system, have disadvantages in application to power system analysis. This paper presents advantages of OODB for modeling complex data of a power system analysis. The OODB supports data modeling requirements of GUI applications and the performance is well acceptable for GUI applications.

• Korean Journal of Construction Engineering and Management
• /
• v.16 no.5
• /
• pp.105-113
• /
• 2015

In order to evaluate the energy performance of buildings, it is important to determine reliable information of energy utilization during operating phase. It is also required to establish the database which have the amounts of population deducted by objective filtering and analysis. In this study, all energy sources were applied to evaluate synthetically the energy performance of Multi-Family Housings(MFH) using district heating and the amounts of population were obtained sufficiently through data searching in Seoul and neighbor cities. Finally the database of source energy utilization and $CO_2$ emission in 325 MFH complexes were established through cross validation between data sources and statistical analysis. Additionally, further ideas have been proposed to improve existing MFH Management Information System.

• Geomechanics and Engineering
• /
• v.7 no.1
• /
• pp.37-53
• /
• 2014

A Web-based pile load test (WBPLT) system was developed and implemented in this study. Object-oriented and concept-based software design techniques were adopted to integrate the pile load test database into the system. A total of 673 case histories of pile load test were included in the database. The data consisted of drilled shaft and driven precast concrete pile axial load tests in drained, undrained, and gravel loading conditions as well as pre-analyzed data and back-calculated design parameters. Unified modeling language, a standard software design tool, was utilized to design the WBPLT system architecture with five major concept-based components. These components provide the static structure and dynamic behavior of system message flows in a visualized manner. The open-source Apache Web server is the building block of the WBPLT system, and PHP Web programming language implements the operation of the WBPLT components, particularly the automatic translation of user query into structured query language. A simple search and inexpensive query can be implemented through the Internet browser. The pile load test database is helpful, and data can be easily retrieved and utilized worldwide for research and advanced applications.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.21 no.45
• /
• pp.121-133
• /
• 1998

This study suggests an efficient algorithm for updating discovered association rules in large database, because a database may allow frequent or occasional updates, and such updates may not only invalidate some existing strong association rules, but also turn some weak rules into strong ones. FUP and DMI update efficiently strong association rules in the whole updated database reusing the information of the old large item-sets. Moreover, these algorithms use a pruning technique for reducing the database size in the update process. This study updates strong association rules efficiently in the whole updated database reusing the information of the old large item-sets. An updating algorithm that is suggested in this study generates the whole candidate item-sets at once in an incremental database in view of the fact that it is difficult to find the new set of large item-sets in the whole updated database after an incremental database is added to the original database. This method of generating candidate item-sets is different from that of FUP and DMI. After generating the whole candidate item-sets, if each item-set in the whole candidate item-sets is large at an incremental database, the original database is scanned and the support of each item-set in the whole candidate item-sets is updated. So, the whole large item-sets in the whole updated database is found out. An updating algorithm that is suggested in this study does not use a pruning technique for reducing the database size in the update process. As a result, an updating algoritm that is suggested updates fast and efficiently discovered large item-sets.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.19 no.37
• /
• pp.251-261
• /
• 1996

Databases are critical to business information systems and RDBMS is most widely used for the database system. Normalization was designed to control various anomalies(insert, update, and delete anomalies). However normalized database design does not account for the tradeoffs necessary for the performance reason. In this research, we model a database design problem without storage constraint. Given a normalized database design, in this model, we do the denormalization of duplicating columns in order in reduce frequent join processes. In this paper, we consider insert, update, delete, and storage cost, and the anomalies are treated by additional disk I/O cost necessary for each insert, update transaction. We propose a branch and bound method, and show considerable cost reduction.

• KSII Transactions on Internet and Information Systems (TIIS)
• /
• v.3 no.3
• /
• pp.235-250
• /
• 2009

An understanding of performance of database driven network applications is critical in combating slow performance of e-commerce web sites, besides efficient web page design, and high quality and well-maintained web server equipment. This paper describes a method of measuring performance from the user viewpoint, which can help enormously in making realistic assessment of true performance of database driven applications. The performance measurements were taken at user locations by using several specially designed JavaScript functions along with ASP scripts. A performance study is presented in this paper, comparing performance of data access using stored procedures with the traditional way of querying a database. It is generally believed that stored procedures have performance benefits as they are pre-compiled. However, our study shows that the data access approach using stored procedures provides significant benefits(by about 30%) over the traditional approach for querying a commercial MySQL database, only when retrieving a substantial amount of data(at least 10,000 rows of data).