• Journal of the Korea Society of Computer and Information
• /
• v.14 no.3
• /
• pp.57-64
• /
• 2009

XML has become a do facto standard for structured document and data on the Web. An XML data deluge over the network will be more, since XML based standards such as Web Service and Semantic Web gets popular. There are efforts to store and query XML documents in a relational database system and recent efforts focus on how to provide such operations using XPath and XQuery. In this paper, we present study about those research efforts and we propose a new scheme to stoγe and query XML documents in a relational database using XPath query. The scheme uses a 'shred' method to store and translates XPath queries to SQL. We also present our empirical experiments using a RDBMS.

• The Transactions of the Korea Information Processing Society
• /
• v.7 no.3
• /
• pp.879-890
• /
• 2000

Designing a multilevel database application is a complex process, and the entities and their associated security levels must be represented using an appropriate model unambiguously. It is also important to capture the semantics of a multilevel databse application as accurate and complete as possible. Owing to the focus of the IDEA Methodology for designing the non-secure database applications on the data-intensive systems, the Object Model describes the static structure of the objects in an application and their relationships. That is, the Object Model in the IDEA Methodology is an extended Entity-Relationship model giving a static description of objects. The IDEA Methodology has not been developed the multilevel secure database applications, but by using an existing methodology we could take advantage of the various techniques that have already been developed for that methodology. That is, this way is easier to design the multilevel secure schema than to develop a new model from scratch. This paper adds the security features 새？ Object Model in the IDEA Methodology, and presents the transformation from this model to a multilevel secure object oriented schema. This schema will be the preliminary work which can be the general scheme for the automatic mapping to the various commercial multilevel secure database management system such as Informix-Online/Secure, Trusted ORACLE, and Sybase Secure SQL Server.

• The Transactions of the Korea Information Processing Society
• /
• v.5 no.8
• /
• pp.1951-1959
• /
• 1998

In this paper, we propose an efficient feature extaetion method for content-based approach and implement an image retrieval system in the Oracle database. First, we estract color feature by the modified Stricker's method from input images, and this color feature and ART2 neural network are used for the rough classification of images. Next, we extract texture feature using wavelet transform, and finally exeute the detailed classification on the rough classified images from the previous step. Exsing the proposed feature extraction methods, we implement a useful image retrieval system by Extended SQI, statement on the relational database. The proposed system is implemented on the Oracle DBMS, and in the experimental results with 200 sample images, it shows the retrieval rate 90% and 81% in Recall and Precision, respectively.

• The Journal of Information Technology and Database
• /
• v.8 no.1
• /
• pp.105-116
• /
• 2001

XML is a standard markup language for exchange and storage of formed or well-formed information in World Wide Web. Because the source data of XML message for exchange of information in World Wide Web is stored in legacy database, it is necessary for the easy connection between XML application and database system. In Oracle8i, 9i, Informix and SQL2000, DBMS vendors make upgrade to DBMS for using XML. This method of upgrade between XML application and database system is Platform-dependent and DBMS-dependent. Also It is necessary for the method of the platform- and DBMS-independent connection between XML application and database system. The methods for the connection between XML DTD and RDB schema are studied for the easy connection between XML application and database system. But the study for the easy connection between XML DTD and ORDB schema is a little. For multimedia application, we use the extended DBMS from RDBMS. It is necessary for the study to the transformation from XML DTD to ORDB schema. In this paper, for easier connection between XML application and database system, we propose the method of the transformation from XML DTD to ORDB schema using Object Model.

• Proceedings of the KIEE Conference
• /
• 2004.07e
• /
• pp.99-102
• /
• 2004

21세기 정보화시대에 맞추어, 도시철도운영기관의 전략적 발전과 도시철도의 정보화 기술 축적 및 표준화된 정보 인프라 구축의 일환으로 도시철도 시설물 유지보수체계를 표준화하고 정보화시스템을 구축중에 있다. 이중, 도시철도 통신 설비의 효율적인 유지보수를 위해서 유지보수체계의 표준화 및 정보화시스템 구축을 통한 실시간 정보의 구축 및 기존 유지보수작업 이력정보의 관리가 매우 중요하다. 본 연구에서는 도시철도 통신 설비의 효율적인 유지관리를 위한 데이터베이스 설계 및 구축방안에 대하여 제시하였다. 통신 설비의 데이터베이스 구축을 위하여 표준분류체계를 수립하였고, 관리항목 및 유지보수작업항목을 표준화하였으며, 유지 보수업무절차를 표준화하고 도면 및 각종 문서양식을 표준화하였다. 통신 설비의 데이터베이스는 개체관계모델(ERB)을 사용하여 설계하였고 특히, 통신 설비는 위치정보와 밀접한 관계를 가지고 있으므로 일반 데이터 외에 GIS용 공간 데이터베이스를 구축하여 서로 연관된 Key를 가지고 상호조회가 가능하도록 설계하였다. 그리고, 통신 설비에 대한 기초 데이터를 구축하기 위한 방안으로 엑셀조사 양식을 통하여 방대한 기초 자료를 작성하고, $SQL^*$Loader 등의 데이터 변환프로그램을 활용하여 데이터베이스에 일괄 등록되도록 하는 방안을 제시하였다 또한. 도면반입절차서 및 표준도면작성지침서, 그리고 GIS DB 구축지침서를 통하여 표준화된 데이터베이스 구축이 이루어지도록 하였다.

• Proceedings of the KIEE Conference
• /
• 2004.07e
• /
• pp.130-133
• /
• 2004

21세기 정보화시대에 맞추어, 도시철도운영기관의 전략적 발전과 도시철도의 정보화 기술 축적및 표준화된 정보 인프라 구축의 일환으로 도시철도 시설물 유지보수체계를 표준화하고 정보화시스템을 구축중에 있다. 이중, 도시철도 신호 장치의 효율적인 유지보수를 위해서 유지보수체계의 표준화 및 정보화시스템 구축을 통한 실시간 정보의 구축 및 기존 유지보수작업 이력정보의 관리가 매우 중요하다. 본 연구에서는 도시철도 신호 장치의 효율적인 유지관리를 위한 데이터베이스설계 및 구축방안에 대하여 제시하였다. 신호 장치의 데이터베이스 구축을 위하여 표준분류체계를 수립하였고, 관리항목 및 유지보수작업항목을 표준화하였으며, 유지보수업무절차를 표준화하고 도면 및 각종 문서양식을 표준화하였다. 신호 장치의 데이터베이스는 개체관계모델(ERD)을 사용하여 설계하였고 특히, 신호 장치는 위치 정보와 밀접한 관계를 가지고 있으므로 일반 데이터 외에 GIS용 공간 데이터베이스를 구축하여 서로 연관된 Key를 가지고 상호조회가 가능하도록 설계하였다. 그리고, 신호 장치에 대한 기초 데이터를 구축하기 위한 방안으로 엑셀조사 양식을 통하여 방대한 기초 자료를 작성하고, SQL*Loader 등의 데이터 변환프로그램을 활용하여 데이터베이스에 일괄 등록되도록 하는 방안을 제시하였다 또한, 도면반입절차서 및 표준도면작성지침서, 그리고 GIS DB 구축지침서를 통하여 표준화된 데이터베이스 구축이 이루어지도록 하였다.

• KIPS Transactions on Software and Data Engineering
• /
• v.7 no.3
• /
• pp.113-120
• /
• 2018

In this study, we proposed a monitoring system for identifying and handling faulty sensing stream data on manufacturing equipments where low-cost sensors can be safely used. Low cost sensors will lessen the cost of implementing distributed monitoring system, but suffer from sensor noises and inaccurate sensed data. Therefore, a distributed monitoring system with low cost sensors should identify faulty signal data as either of sensor fault or machine fault, and filter out faulty signals from sensing fault. To this end, we adopted a fourier transform based diagnostic approach mixed with a weighed moving averaging method, in order to identify faulty signals. We measured how effective our approach is and found out our approach can filter out one-third faulty signals from our experimental environment. In addition, we attached wireless communication modules to reduce sensor and network installation cost. To handle massive sensor data efficiently, we employed unstructured data format with NoSQL based database.

• Journal of KIISE:Computing Practices and Letters
• /
• v.14 no.2
• /
• pp.130-142
• /
• 2008

Different from other ontology languages, TopicMap is capable of integrating numerous amount of heterogenous information resources using the locational information without any information transformation. Although many conventional editors have been developed for topic maps, they are standalone-type only for writing XTM documents. As a result, these tools request too much time for handling large-scale data and provoke practical problems to integrate with legacy systems which are mostly based on relational database. In this paper, we model a large-scale topic map structure based on XTM 1.0 into RDB structure to minimize the processing time and build up the ontology in legacy systems. We implement a topic map platform called X-TOP that can enhance the efficiency of ontology construction and provide interoperability between XTM documents and database. Moreover, we can use conventional SQL tools and other application development tools for topic map construction in X-TOP. The X-TOP is implemented to have 3-tier architecture to support flexible user interfaces and diverse DBMS. This paper shows the usability of X-TOP by means of the comparison with conventional tools and the application to healthcare cancer ontology management.

• Spatial Information Research
• /
• v.22 no.5
• /
• pp.9-18
• /
• 2014

According to the recent development of the ubiquitous computing environment, the use of spatio-temporal data from sensors with GPS is increasing, and studies on the Semantic Sensor Web using spatio-temporal data for providing different kinds of services are being actively conducted. Especially, the W3C developed the SSNO(Semantic Sensor Network Ontology) which uses sensor-related standards such as the SWE(Sensor Web Enablement) of OGC and defines classes and properties for expressing sensor data. Since these studies are available for the query processing about non-spatio-temporal sensor data, it is hard to apply them to spatio-temporal sensor data processing which uses spatio-temporal data types and operators. Therefore, in this paper, we developed the SWE based on SSNO which supports the spatio-temporal sensor data types and operators expanding spatial data types and operators in "OpenGIS Simple Feature Specification for SQL" by OGC. The system receives SensorML(Sensor Model Language) and O&M (Observations and Measurements) Schema and converts the data into SSNO. It also performs the efficient query processing which supports spatio-temporal operators and reasoning rules. In addition, we have proved that this system can be utilized for the web service by applying it to a virtual scenario.

• Journal of KIISE:Computing Practices and Letters
• /
• v.15 no.11
• /
• pp.836-840
• /
• 2009

Many researchers have studied flash memory in order to replace hard disk storages. Many FTL algorithms have been proposed to overcome physical constraints of flash memory such as erase-before-write, wear leveling, and poor write performance. Therefore, these constraints should be considered for testing FTL algorithms and the performance evaluation of flash memory. As doing the experiments, we suffer from several problems with costs and settings in experimental configuration. When we, for example, replay the traces of Oracle to evaluate the I/O performance with flash memory, it is hard to extract exact traces of I/O operations in Oracle. Since there are only write operations in the log, it is impossible to gather read operations. In MySQL and SQLite, we can gather the read operations by changing I/O functions in the source codes. But it is not easy to search for the exact points about I/O and even if we can find out the points, we might get wrong results depending on how we modify source codes to get I/O traces. The FlaSim proposed in this paper removes the difficulties when we evaluate the performance of FTL algorithms and flash memory. Our Linux drivers emulate the flash memory as a hard disk. And we can easily obtain the usage statistics of flash memory such as the number of write, read, and erase operations. The FlaSim can be gracefully extended to support the additional modules implemented by novel algorithms and ideas. In this paper, we describe the structure of FTL emulator, development tools and operating methods. We expect this emulator to be helpful for many experiments and research with flash memory.