Browse > Article

T-Cache: a Fast Cache Manager for Pipeline Time-Series Data  

Shin, Je-Yong (경북대학교 컴퓨터공학과)
Lee, Jin-Soo (경북대학교 컴퓨터공학과)
Kim, Won-Sik (경북대학교 컴퓨터공학과)
Kim, Seon-Hyo (경북대학교 컴퓨터공학과)
Yoon, Min-A (경북대학교 컴퓨터공학과)
Han, Wook-Shin (경북대학교 컴퓨터공학과)
Jung, Soon-Ki (경북대학교 컴퓨터공학과)
Park, Se-Young (경북대학교 컴퓨터공학과)
Abstract
Intelligent pipeline inspection gauges (PIGs) are inspection vehicles that move along within a (gas or oil) pipeline and acquire signals (also called sensor data) from their surrounding rings of sensors. By analyzing the signals captured in intelligent PIGs, we can detect pipeline defects, such as holes and curvatures and other potential causes of gas explosions. There are two major data access patterns apparent when an analyzer accesses the pipeline signal data. The first is a sequential pattern where an analyst reads the sensor data one time only in a sequential fashion. The second is the repetitive pattern where an analyzer repeatedly reads the signal data within a fixed range; this is the dominant pattern in analyzing the signal data. The existing PIG software reads signal data directly from the server at every user#s request, requiring network transfer and disk access cost. It works well only for the sequential pattern, but not for the more dominant repetitive pattern. This problem becomes very serious in a client/server environment where several analysts analyze the signal data concurrently. To tackle this problem, we devise a fast in-memory cache manager, called T-Cache, by considering pipeline sensor data as multiple time-series data and by efficiently caching the time-series data at T-Cache. To the best of the authors# knowledge, this is the first research on caching pipeline signals on the client-side. We propose a new concept of the signal cache line as a caching unit, which is a set of time-series signal data for a fixed distance. We also provide the various data structures including smart cursors and algorithms used in T-Cache. Experimental results show that T-Cache performs much better for the repetitive pattern in terms of disk I/Os and the elapsed time. Even with the sequential pattern, T-Cache shows almost the same performance as a system that does not use any caching, indicating the caching overhead in T-Cache is negligible.
Keywords
Caching; Time series data; Intelligent PIG;
Citations & Related Records
Times Cited By KSCI : 1  (Citation Analysis)
연도 인용수 순위
1 http://www.businessweek.com/magazine/content/02\_17/b3780129.htm
2 http://www.tuboscopepipeline.com/Products.htm
3 BJ Pipeline Inspection Services, GEODENT/GEODISPLAY Software Manual, 1997
4 R. Agthoven, 'Ultrasonic Inspection of Riser a New and Simple Approach,' European Conference on Non-Destructive Testing (ECNDT), Vol.3, No.11, Nov. 1998
5 http://www.3p-services.com
6 http://www.gepower.com/pii
7 A. Kemper and D. Kossman, 'Dual-Buffering Strategies in Object Bases,' In Proc. Int'l Conf. Very Large Data Bases (VLDB), 1994
8 D.K. Kim et al., 'Development of the Caliper System for a Geometry PIG Based on Magnetic Field Analysis,' KSME International Journal, Vol.17, No.12, pp. 1835-1843, 2003   과학기술학회마을
9 S. Westwood and D. Hektner, Data Integration Ensures Integrity, BJ Services company, Mar. 2003
10 SCADA in the Energy Industry -- A Janus View, EnergyPulse, 2004. (also available at http://www.newton-evans.com/news/EnergyPulseArticle.pdf)
11 W. Han, K. Whang, and Y. Moon, 'A Formal Framework for Prefetching Based on the Type-Level Access Pattern in Object-Relational DBMSs,' IEEE Transactions on Knowledge and Data Engineering, Vol.17, No.10, pp. 1436-1488, Oct. 2005   DOI   ScienceOn
12 T. H. Cormen et al., Introduction to Algorithms, MIT Press and McGraw-Hill, 2001
13 P. Michailides et al., NPS 8 Geopig: Inertial Measurement and Mechanical Caliper Technology, BJ Services company, June 2002
14 W. Han and et al., 'A Scalable Pipeline Data Processing Framework Using Database and Visualization Techniques,' In Proc. Int'l Conf. on Intelligent Computing, pp. 334-344, Aug. 2007