• The KIPS Transactions:PartD
• /
• v.8D no.5
• /
• pp.473-482
• /
• 2001

Integrated heterogeneous database systems provide the unified interface for users and applications today in order to access the underlying diverse data sources located in different sites. The multiple heterogeneous data sources have the different and specialized data structures and transaction processing capabilities. Because of local autonomy, the local system does not have the capability of cooperation to control the global transaction. Hence designing the global transaction manager with supporting the global serializability is difficult task. To resolve the well-known indirect conflict, we define the global transaction model by using the characteristics of global integrity constraints. And then we propose the site-locking operation and its protocol to manage the global transaction. The correctness and analysis of our site-locking protocol is proved and performance gain over the related other methods is also estimated in this paper.

• Journal of KIISE:Databases
• /
• v.33 no.7
• /
• pp.668-681
• /
• 2006

Due to its diverse advantages, XML has secured its position as a standard for data representation and exchange in the Internet. As a consequence, there has been much research on efficient storing and query processing of in data. Storing XML data in a relational database system warrants much benefit in data management and query processing; the system provides a strong query processing and data management function and can be applicable to XML data, its function being extended. In this paper, we design and implement a query translator that translates XQuery, a representative XML query language, into SQL:2003 query. SQL:2003, the latest SQL standard used as a substitute for SQL:1999, defines SQL/XML that supports XML. The main contribution of this paper is as follows: First, we look into the supporting features of XML, defined in the SQL:2003 standard, and propose a user-defined function for shortcoming sections. Second, we propose a way to translate XQuery into SQL that observes the latest SQL standard. Third, we describe in detail the design and the implementation of the translator to show its feasibility as a translator.

• The Transactions of the Korea Information Processing Society
• /
• v.4 no.2
• /
• pp.349-362
• /
• 1997

In order to make a meaningful multi-media object,it is usually necessary to apply a number of non-trival operations.If multi-media data can be encapsulated in a standaridized form and stored in a database,it is poss-ible to share and reuse multi-media data among users without repeating the same or similar operations. Based on the OLE component object model,this paper proposes the integrated computing enviroment for naive user to share and reuse of Ole objects.Various types of multi- media objects that are created by their appropriate OLE application programs can be aggreagated to form a multi-media document.In addition,the OLE objects can also be stored in database by a controlled manner.TheOLE object in a database can be retrieved by a visual query interface and reused to make a new document.This paper describes the common Platform to integrate various ment of OLE appfication programs,the separation process of an OLE object form a document,and the overall management of OLE object in a database.

• The KIPS Transactions:PartD
• /
• v.14D no.6
• /
• pp.615-622
• /
• 2007

Recently, users who want to be provided motile devices, such as PDP, PMP, and IPTV connected wireless internet, with multimedia contents are increasing due to an influence of multimedia contents. In the paper, we propose an efficient database design method for managing mobile multimedia services on home network systems. For this, we build relations using attributes required while providing multimedia services, and then design a database. Specially, we propose a database design method based on normalization theory to eliminate redundancies and update anomalies caused by a non trivial multi valued dependency in relations. In the experiments, we compare and analyze occurrence frequencies of data redundancies and update anomalies through query executions on the relation decomposed into normal forms. The results reveal that our database design is failrly effective.

• The KIPS Transactions:PartD
• /
• v.16D no.3
• /
• pp.295-306
• /
• 2009

Query execution time minimization is an important objective in distributed database design. While total time minimization is an objective for On Line Transaction Processing (OLTP), response time minimization is for Decision Support queries. We formulate the sub-query allocation problem using analytical models and solve with genetic algorithm (GA). We show that query execution plans with total time minimization objective are inefficient from response time perspective and vice versa. The procedure is tested with simulation experiments for queries of up to 20 joins. Comparison with exhaustive enumeration indicates that GA produced optimal solutions in all cases in much less time.

• Broadcasting and Media Magazine
• /
• v.1 no.4
• /
• pp.12-19
• /
• 1996

음향과 영상 자료를 디지털화하여 데이타베이스에 저장, 색인, 검색 관리를 효과적으로 할 수 있는 시스템의 사례를 중심으로 기술하였다. 특히 시스템의 설계 및 구축에 요하는 과정과 필요요소 및 관련 사항에 대해 소개하였고, 마지막으로 설계시 고려할 중요한 사항에 대해 언급하였다.

• Journal of KIISE:Databases
• /
• v.30 no.6
• /
• pp.573-584
• /
• 2003

Recent massive data generation by genomics and proteomics requires bioinformatic tools to extract the biological meaning from the massive results. Here we introduce ROSPath, a database system to deal with information on reactive oxygen species (ROS)-mediated cell signaling pathways. It provides a structured repository for handling pathway related data and tools for querying, displaying, and analyzing pathways. ROSPath data model provides the extensibility for representing incomplete knowledge and the accessibility for linking the existing biochemical databases via the Internet. For flexibility and efficient retrieval, hierarchically structured data model is defined by using the object-oriented model. There are two major data types in ROSPath data model: ‘bio entity’ and ‘interaction’. Bio entity represents a single biochemical entity: a protein or protein state involved in ROS cell-signaling pathways. Interaction, characterized by a list of inputs and outputs, describes various types of relationship among bio entities. Typical interactions are protein state transitions, chemical reactions, and protein-protein interactions. A complex network can be constructed from ROSPath data model and thus provides a foundation for describing and analyzing various biochemical processes.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 1995.04a
• /
• pp.337-348
• /
• 1995

제품의 생산 및 제조원가는 크게 직접재료비, 직접노무비, 제조간접비로 나눌 수가 있다. 본 연구는 제조업의 제품별 제조원가분석을 위하여 실제 중소기업을 대상으로 관계형 데이타베이스(Relational Database)를 구축해 보았으며, 작업자의 작업시간을 시급으로 관리하여 줌으로써 제품별 원가요소 중 직접노무비(인건비)를 여러가지 요목별로 산출해 낼수 있는 활동중심 경영관리(ABM: Activity-Based Management)를 위한 원가관리 시스템의 프로토타입(prototype)을 설계하였다. 본 시스템에서는 각 작업자별 실작업시간에 따라 발생하는 시급을 작업자의 급여테이블과 연계하여 구함으로써 작업자별 작업시간관리가 가능할 뿐만 아니라, 제품별 제조시간 조회를 통해 표준시간과 비교하는 자료로 제공될 수가 있다. 또한, 제조간접비(제조경비)는 월말 제조원가 산정시 사용자로부터 입력받아 그 달에 생산한 모든 제품에 가중치(weight)에 의해 배분해 주는 방식을 이용하였으며, 직접재료 원가(자재비)는 제품별로 데이타베이스를 구추갛여 제조원가에 반영시켰다. 그리고, 시스템에 유연성을 주기 위해 A/S 제품인 경우는 추가 자재비를 입력시킬수 있도록 고려하였으며, 재공품재고(WIP: Work-In-Progress)등의 정보를 제공함으로써 효과적인 시스템 운영이 되도록 설계하였다.

• Proceedings of the Korean Society of Precision Engineering Conference
• /
• 1992.04a
• /
• pp.245-249
• /
• 1992

CAD와 CAM 시스템 사이에서 교량역활을 지원하며, 컴퓨터 통합생산(CIM)시스템을 구축하는데 중요한 기능을 수행하는 것 중의하나인 자동공정설계(Computer Aided Process Planning :CAPP) 시스템의 첫 단계는 부품도면에 존재하는 형상 을 인식하는 것이다. 현재까지 개발된 CAPP 시스템 중 CAD 데이타베이스에서 자동적으로 형상인식을 수행하는 시스템 으로는 축대칭인 회전형상 부품을 대상으로하는 시스템이 많이 개발되어 있으나, 비회전형상 부품을 대상으로하는 시스 템은 CAD 데이타베이스의 부적절성으로 인해 제한점이 많은 부분적인 결과만 나와 있을 뿐이다. 본 연구에서는 비회전 형상 부품인 사출금형 부품을 대상으로하여 AutoCAD 시스템을 사용하여 공정설계자의 개입이 없이부품에 존재하는 형상들을 자동적으로 인식하는 알고리즘 개발에 대해서 기술하고자 한다.

• Journal of KIISE:Computing Practices and Letters
• /
• v.7 no.6
• /
• pp.661-683
• /
• 2001

There is a rapid increase in the use of digital video information in recent years, it becomes more important to manage video databases efficiently. The development of high speed data network and digital techniques has emerged new multimedia applications such as internet broadcasting, Video On Demand(VOD) combined with video data processing and computer. Video database should be construct for searching fast, efficient video be extract the accurate feature information of video with more massive and more complex characteristics. Video database are essential differences between video databases and traditional databases. These differences lead to interesting new issues in searching of video, data modeling. So, cause us to consider new generation method of database, efficient retrieval method of video. In this paper, We propose the construction and generation method of the video database based on contents which is able to accumulate the meaningful structure of video and the prior production information. And by the proposed the construction and generation method of the video database implemented the video database which can produce the new contents for the internet broadcasting centralized on the video database. For this production, We proposed the video indexing method which integrates the annotation-based retrieval and the content-based retrieval in order to extract and retrieval the feature information of the video data using the relationship between the meaningful structure and the prior production information on the process of the video parsing and extracting the representative key frame. We can improve the performance of the video contents retrieval, because the integrated video indexing method is using the content-based metadata type represented in the low level of video and the annotation-based metadata type impressed in the high level which is difficult to extract the feature information of the video at he same time.