• Proceedings of the Korean Association of Geographic Inforamtion Studies Conference
• /
• 2008.10a
• /
• pp.100-105
• /
• 2008

EPCglobal은 기업 간의 물류 활동 촉진과 글로벌 유통물류 시스템 구축을 위하여 EPCglobal Architecture Framework을 제시 하였다. EPCglobal Architecture Framework의 한 구성 요소인 EPCIS(Electronic Product Code Information Services)는 EPC, 시간, 위치와 같은 물류 관련 정보에 대해 저장 및 검색 서비스를 제공한다. EPCIS는 단발성 질의(poll)와 연속 질의(subscribe) 검색 서비스를 제공한다. EPCIS의 연속 질의는 시스템 자동화 및 재고 관리, 공급망 관리를 위해 다양한 응용에서 활용이 가능하다. 일반적으로 연속 질의 처리를 위해서는 등록된 연속 질의와 입력된 데이터를 순차적으로 비교하는 Sequential Matching 기법을 사용한다. Sequential Matching기법은 등록된 연속 질의 수가 증가 할 경우 많은 부하를 발생 시키고, 이로 인해 시스템 처리 지연이 발생한다. 본 논문에서는 EPCIS의 시공간 EPC 데이터의 연속질의 처리 성능 향상을 위해 선택률 기반 효율적인 연속질의 처리 기법을 제안한다. 13차원의 도메인을 여러 개의 질의 색인으로 구성하고, 등록된 질의 정보를 기반으로 선택률을 계산한다. 선택률에 의해 변경되는 동적 질의 실행 계획을 제안함으로써, EPCIS에서 시공간 EPC 데이터의 연속질의 처리에 대해 평균 60%의 성능이 향상이 가능하도록 하였다.

• Proceedings of the Korean Information Science Society Conference
• /
• 1998.10b
• /
• pp.123-125
• /
• 1998

지리 정보 시스템이서 다중 공간 조인과 같은 많은 기하 계산을 필요로 하는 질의를 처리하기 위해서는 질의에 대한 병렬화 작업을 통해 실행 시간을 최소화 하는 것이 필수적이다. 다중 공간 조인은 정제에서 많은 시간을 소비하므로 여과와 정제를 분리하여 각각을 수행하는 것이 정제 시간을 단축하게 되고 따라서 좋은 성능을 나타낼 수 있다. 그러므로 다중 공간 조인을 병렬화 하기 위해서는 다중 공간 여과와 정제 각각에 대해 병렬 실행 계획을 세우는 것이 중요하다. 이 논문에서는 우선적으로 병렬 공간 여과를 수행하기 위한 두가지 알고리즘, 즉 blush tree을 사용한 다중 공간 여과와 pipelining을 사용한 다중 공간 여과의 병렬화를 비교한다. 그리고, 다중 공간 여과의 결과로서 생성되는 중간 결과 테이블에서 데이터의 중복에 따라 정제 성능의 저하가 발생되는데, 이를 효율적으로 제거하기 위한 두가지 그래프 생성 알고리즘을 제안하고 이를 비교한다. 그리고, 생성된 그래프에서 병렬 정제를 수행하기 위한 여러 가지 분할 알고리즘을 제안하고 이를 비교 평가한다. 이런 일련의 작업을 통해 우수한 성능의 병렬 다중 공간 조인 방법을 제안하고 성능 평가를 통해 최적의 병렬 수행 방법을 도출한다.

• Journal of the Korean Society of Earth Science Education
• /
• v.14 no.2
• /
• pp.159-172
• /
• 2021

This study is an action study that plans a instructional strategy for improving experimental activities and interactions in online science classes and suggests improvement plans based on the results. To this end, from July 7 to September 9, 2020, the 'Earth and the Moon' unit class was conducted for 20 6th grade elementary school students located in G Metropolitan City. For the class, smart devices and alternative experiments were planned in the experimental activity category, and an online chat room and Q&A strategy were planned in the interaction category. Among the collected data, class activity papers, homework assignments, reflection journals, online conversation contents, and Q&A contents were input into the matrix and analyzed by writing analytical texts. As a result of the implementation, smart devices and alternative experiments provided opportunities for exploration, but there was a risk of misconception formation and hindered experimental activities. The online chat room and Q&A provided opportunities for communication and examination and feedback on scientific concepts. Through this action study, the researcher was able to reflect on the class while writing class reflection notes, and suggested the role of smart devices in terms of the effectiveness and efficiency of science classes.

• The Journal of Korea Institute of Information, Electronics, and Communication Technology
• /
• v.10 no.1
• /
• pp.1-8
• /
• 2017

In this paper we present a spatial big data query processing system that can store spatial data in Hadoop and query the data with SQL-based query language. The system stores large-scale spatial data in HDFS-based storage system, and supports spatial queries expressed in SQL-based query language extended for spatial data processing. It supports standard spatial data types and functions defined in OGC simple feature model in the query language. This paper presents the development of core functions of the system including query language parsing, query validation, query planning, and connection with storage system. We compares the performance of the suggested system with an existing system, and our experiments show that the system shows about 58% performance improvement of query execution time over the existing system when executing region query for spatial data stored in Hadoop.

• The Journal of the Korea Contents Association
• /
• v.8 no.4
• /
• pp.48-54
• /
• 2008

This paper analyzes cost tradeoffs between memory usage and computation for window-based operators in data stream environments. It identifies generic operator network constructs, and sets up a cost model for the estimation of the expected memory reduction and the computation overheads when window memory relocations are applied to each operator network construct. This cost model helps to identify the utility of window memory relocations. It also helps to apply window memory relocation to improve a query execution plan to save memory usage. The proposed approach contributes to expand the scope of query processing and optimization in data stream environments. It also provides a basis to develop a cost estimation model for the query optimization using window memory relocations.

• Journal of Korean Library and Information Science Society
• /
• v.49 no.1
• /
• pp.99-122
• /
• 2018

The Korean government has established a plan on the 'service operating system of public libraries', which divides the local libraries into a central library, regional libraries, and small branches. However, due to the low interest of the libraries and, above all, the structural problems caused by the dualization of the library administrative bodies, no action plans have been developed. This study intends to propose an integrated operating system for public libraries in Busan metropolitan and to design specific roles and functions according to the library status. To the ends, this study examined the Korean government's plan for public library operation, analyzed the operation cases of foreign public libraries, and finally suggested the detailed action plan of an integrated operating system based on the case of Busan Metropolitan City. The data were collected from literature review and on site field survey, supplemented by e-mail inquiry and official statistical information.

• Journal of KIISE:Databases
• /
• v.35 no.1
• /
• pp.1-16
• /
• 2008

Join queries having heavy cost are necessary to Data Stream Management System in Sensor Network where plural short information is generated. It is reasonable that each join operator has a sliding-window constraint for preventing DISK I/O because the data stream represents the infinite size of data. In addition, the join operator should be able to take multiple inputs for overall results. It is possible for the MJoin operator with sliding-windows to do so. In this paper, we consider the data stream environment where multiple MJoin operators are registered and propose MMJoin which deals with issues of building and processing a globally shared query considering characteristics of the MJoin operator with sliding-windows. First, we propose a solution of building the global shared query execution plan. Second, we solved the problems of updating a window size and routing for a join result. Our study can be utilized as a fundamental research for an optimization technique for multiple continuous joins in the data stream environment.

• The KIPS Transactions:PartD
• /
• v.10D no.6
• /
• pp.927-934
• /
• 2003

Database query optimates the selectivety of a query to find the most efficient access plan. Multi-dimensional selectivity estimation technique is required for a query with multiple attributes because the attributes are not independent each other. Histogram is practically used in most commercial database products because it approximates data distributions with small overhead and small error rates. However, histogram is inadequate for a query with multiple attributes because it incurs high storage overhead and high error rates. In this paper, we propose a novel method for multi-dimentional selectivity estimation. Compressed information from a large number of small-sized histogram buckets is maintained using the discrete cosine transform. This enables low error rates and low storage overheads even in high dimensions. Extensive experimental results show adventages of the proposed approach.

• The KIPS Transactions:PartD
• /
• v.11D no.2
• /
• pp.281-292
• /
• 2004

Selectivity estimation for spatial query is very important process used in finding the most efficient execution plan. Many works have been performed to estimate accurate selectivity. Although they deal with some problems such as false-count, multi-count, they can not get such effects in little memory space. Therefore, we propose a new technique called MW Histogram which is able to compress summary data and get reasonable results and has a flexible structure to react dynamic update. Our method is based on two techniques : (a) MinSkew partitioning algorithm which deal with skewed spatial datasets efficiently (b) Wavelet transformation which compression effect is proven. The experimental results showed that the MW Histogram which the buckets and wavelet coefficients ratio is 0.3 is lower relative error than MinSkew Histogram about 5%-20% queries, demonstrates that MW histogram gets a good selectivity in little memory.

• Journal of the Korean Society of Food Science and Nutrition
• /
• v.40 no.10
• /
• pp.1430-1437
• /
• 2011

Synthesis conditions of cocoa butter equivalents were optimized using the response surface method (RSM) by interesterification of canola oil (Ca), palmitic ethyl ester (PEE), and stearic ethyl ester (StEE). The reaction was catalyzed by immobilized lipase (Lipozyme TLIM) from Thermomyces lanuginosa to produce structured lipids containing a composition of triacylglycerols similar to cocoa butter. Reaction conditions were optimized using D-optimal design with the three reaction factors of the substrate molar ratio of canola oil to palmitic ethyl ester and stearic ethyl ester (Ca : PEE : StEE=1:1:3, 1:1.66:5, 1:2:6, 1:2.33:7, 1:3:9, $X_1$), enzyme ratio (2~6%, $X_2$), and reaction time (30~270 min, $X_3$). The optimal conditions that minimized acyl-migration while maximizing 1-palmitoyl-2-oleoyl-3-stearoyl glycerol (POS), 1,3-distearoyl-2-oleoyl glycerol (SOS), and 1,3-dipalmitoyl-2-oleoyl glycerol (POP) were predicted, resulting in Ca : PEE : StEE=1:3:9, 6% of enzyme ratio, and 40 min of reaction time. The reaction product of structured lipids was synthesized again under the same conditions, showing 10.43 area% of acyl-migration, 25.31 area% of POS/PSO, 19.79 area% of SOS, and 11.22 area% of POP.