• Proceedings of the Korea Contents Association Conference
• /
• 2006.05a
• /
• pp.125-127
• /
• 2006

A number of museums and related parties have tangible heritage data and those data are collected by different types and formats. In these days, there are no service which connect each others so if a user wants to search a data, user have to log on certain homepage and search data. In general relational database systems have used for tangible heritage but sometime there is no ontology information for such relational database system. Therefore, for efficient searching of tangible heritage, we need a method which is extracting ontology information from relational database system. And we need a method which makes alignment between local ontologies extracted from relational database system and global ontology which has global information of tangible heritage. In this paper, we propose a system which can search tangible heritage efficiently using a method of extracting ontology from RDBMS and a method of aligning between local ontology and global ontology.

• The Transactions of the Korea Information Processing Society
• /
• v.4 no.1
• /
• pp.29-53
• /
• 1997

Conventional switching systems have been using flat file systems or relational database systems to deal with their operational data. However, newly emerged requirements for advanced switching systems make relational database systems no longer proper solutions. This paper defines object-oriented interfaces that effectively incorporate data characteristics of switching systems. In addition, it exemplifies how the method works on an actual database systems for the TDX-10 switching system.

• ETRI Journal
• /
• v.22 no.3
• /
• pp.41-51
• /
• 2000

An important use of data warehousing is to provide temporal views over the history of source data. It is significant that nearly all data warehouses are dependent on relational database technology, yet relational databases provide little or no real support for temporal data. Therefore, in is difficult to obtain accurate information for time-varying data. In this paper, we are going to design a temporal data warehouse to support time-varying data efficiently. For this purpose, we present a method to support temporal query by combining a temporal query process layer with the relational database which is used as a source database in an existing data warehouse. We introduce the Temporal Aggregate Tree Strategy (TATS), and suggest its algorithm for the way to aggregate the time-varying data that is changed by the time when the temporal view is created. In addition, The TATS and the materialized view creation method of the existing data warehouse have been evaluated. As a result, the TATS reduces the size of the fact table and it shows a good performance for the comparison factor in case of processing the query for time-varying data.

• International conference on construction engineering and project management
• /
• 2005.10a
• /
• pp.509-514
• /
• 2005

In recent years, use of the web technologies and on-line process has immensely swapped single-user platform practice. This study attempted to develop preliminary cost estimating program by means of Web technologies based on statistical modeling results. A prototype Web-based Preliminary Item-Level Cost Estimating System (WBPILCES) using open source software was developed as an on-line estimating tool in this research. The primary objective is to study the possible flexibility of implementing a centralized information system that will be maintained by the Texas Department of Transportation (TxDOT) IT division. The full-scale deployment of proposed information architecture is expected to seamlessly integrate with legacy database system currently used by TxDOT so as to streamline data storage, cost growth tracking and estimates documentation.

• International conference on construction engineering and project management
• /
• 2009.05a
• /
• pp.1346-1351
• /
• 2009

In this paper we propose a framework for an Object Relational IFC Server (OR-IFC Server). Enormous amounts of information are generated in each project. Today, many BIM systems are developed by various CAD software vendors. Industry Foundation Classes (IFC) developed by International Alliance for Interoperability (IAI) is an open standard data model for exchanging data between the various BIM tools. The IFC provides a foundation for exchanging and sharing of information directly between software applications and define a shared building project model. The IFC model server is a database management system that can keep track of transactions, modifications, and deletions. It plays a role as an information hub for storing and sharing information between various parties involved in construction projects. Users can communicate with each other via the internet and utilize functions implemented in the model server such as partial data import/export, file merge, version control, etc. IFC model servers using relational database systems have been developed. However, they suffered from slow performance and long transaction time due to a complex mapping process between the IFC structure and a relational-database structure because the IFC model schema is defined in the EXPRESS language which is object-favored language. In order to simplify the mapping process, we developed a set of rules to map the IFC model to an object-relational database (ORDB). Once the database has been configured, only those pieces of information that are required for a specific information-exchange scenario are extracted using the pre-defined information delivery manual (IDM). Therefore, file sizes will be reduced when exchanging data, meaning that files can now be effectively exchanged and shared. In this study, the framework of the IFC server using ORDB and IDM and the method to develop it will be examined.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 1996.04a
• /
• pp.179-182
• /
• 1996

Database management systems are now used in almost every organization to maintain and utilize important collections of information. Relational DBMSs have a firm theoretical base. However, it lacks important features needed for representing certain critical aspects of an entity. One alternatives to remedy this problem is to adopt the object-oriented approach to the data model development process. In this paper, we tried to show the advantages of object-oriented data model design process for the development of extended relational database schema needed for the integrated plant information system at H. Heavy Industry Co.

• Proceedings of the KSR Conference
• /
• 1998.05a
• /
• pp.323-329
• /
• 1998

Fatigue strength database system was developed for Windows 95 on personal computer. The relational database management system Visual Foxpro 5.0 was used. The database system developed contains 3,147 S-N curves and 311 $\varepsilon$-N ones for 437 material symbols and has the ability to search data by material symbol that each specification marks differently. Visual Basic 5.0 was used for graphic presentation and statistical treatment of the data searched.

• 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.

• Journal of Society of Preventive Korean Medicine
• /
• v.13 no.2
• /
• pp.115-128
• /
• 2009

Background : Currently, ontology research has led the trend of technical development in medical informatics area. For Korean medicine, the reference terminology should be developed to facilitate the ontology research. Objective : This research aimed to design the management system for traditional Korean medical terms. Method :We built the internet-based system in which multi-users work simultaneously by using the relational database system(SQL Server2005) and visual studio 2005. Result : By this system, researchers can collect, refine, and inspect Korean medicine terms efficiently, and the terms can be transcribed into synonym, Korean, Chinese, and simplified Chinese. It enables the terms be input into the system accurately and managed by its classification. Conclusion : We developed the concept groups and its hierarchy system for Korean medicine terms which provides the basis for ontology system.

• Journal of Korea Multimedia Society
• /
• v.1 no.2
• /
• pp.142-153
• /
• 1998

In this paper, Java Method approach for the integration of Web and Object-Relational DBMS is proposed. For the purpose, we extend to use Java language in programming user-defined function which is one of important characteristic of Object-Relational DBMS with object concept. Therefore we can retrieve not only database objects but also their associated Java methods to run in clients. Finally, to demonstrate the feasibility of the proposed Java Method technique, we designed and implemented this Java method system based on three-tier client/server architecture using JDBC(Java Database Connectivity) and Java RMI(Remote Method Invocation).