Abstract
In this article, we study the indexing problem of using PCM as the storage medium for embedded multiversion databases in cyber-physical systems (CPSs). Although the multiversion B+-tree (MVBT) index has been shown to be efficient in managing multiple versions of data items in a database, MVBT is designed for databases residing in traditional block-oriented storage devices. It can have serious performance problems when the databases are on phase-change memory (PCM). Since the embedded multiversion database in CPSs may have limited storage space and are update intensive, to resolve the problems of MVBT of lack of space efficiency and heavy update cost, we propose a new index scheme, called space-efficient multiversion index (SEMI), to enhance the space utilization and access performance in serving various types of queries. In SEMI, since the number of keys in the database may be small, instead of using a B-tree index, we propose to use a binary-search tree to organize the index keys. Furthermore, multiple versions of the same data item may be stored consecutively and indexed by a single entry to maximize the space utilization and at the same time to enhance the performance in serving version-range queries. Analytical studies have been conducted on SEMI, and a series of experiments have been performed to evaluate its performance as compared with MVBT under different workloads. The experimental results have demonstrated that SEMI can achieve very high space utilization and has better performance in serving update transactions and range queries as compared with MVBT.
- S. Barker, A. Mishra, D. Irwin, E. Cecchet, P. Shenoy, and J. Albrecht. 2012. Smart*: An open data set and tools for enabling research in sustainable homes. In The 2012 Workshop on Data Mining Applications in Sustainability.Google Scholar
- B. Becker, S. Gschwind, T. Ohler, B. Seeger, and P. Widmayer. 1996. An asymptotically optimal multiversion B-tree. VLDB Journal 5, 4 (Dec. 1996), 264--275. DOI:http://dx.doi.org/10.1007/s007780050028 Google Scholar
Digital Library
- J. Chen, G. Xing, X. Wang, and X. Fu. 2011c. Fidelity-aware utilization control for cyber-physical surveillance systems. In Proceedings of the IEEE Real-Time Systems Symposium. 117--126. Google Scholar
Digital Library
- S. Chen, P. B. Gibbons, and S. Nath. 2011a. Rethinking database algorithms for phase change memory. In Proceedings of Biennial Conference on Innovative Data Systems Research (CIDR’11). 21--31.Google Scholar
- S. Chen, P. B. Gibbons, and S. Nath. 2011b. Rethinking database algorithms for phase change memory. In Proceedings of Biennial Conference on Innovative Data Systems Research (CIDR’11).Google Scholar
- S. Chen and Q. Jin. 2015. Persistent B+-trees in non-volatile main memory. Proceedings of the VLDB Endow. 8, 7 (Feb. 2015), 786--797. Google Scholar
Digital Library
- P. Chi, W.-C. Lee, and Y. Xie. 2014. Making B+-tree efficient in PCM-based main memory. In Proceedings of the International Symposium on Low Power Electronics and Design (ISLPED’14). 69--74. Google Scholar
Digital Library
- J. R. Driscoll, N. Sarnak, D. D. Sleator, and R. E. Tarjan. 1989. Making data structures persistent. Elsevier Journal of Computer and System Sciences 26, 1 (1989), 86--124. Google Scholar
Digital Library
- S. Eilert, M. Leinwander, and G. Crisenza. 2009. Phase change memory: A new memory enables new memory usage models. In IEEE International Memory Workshop (IMW'09). 1--2.Google Scholar
- S. Gao, J. Xu, B. He, B. Choi, and H. Hu. 2011. PCMLogging: Reducing transaction logging overhead with PCM. In Proceedings of the 20th ACM International Conference on Information and Knowledge Management (CIKM'11). Google Scholar
Digital Library
- T. Haapasalo, I. Jaluta, B. Seeger, S. Sippu, and E. Soisalon-Soininen. 2009. Transactions on the multiversion B+-tree. In International Conference on Extending Database Technology (EDBT'09). Google Scholar
Digital Library
- W. Hu, G. Li, J. Ni, D. Sun, and K.-L. Tan. 2014. Bp-Tree: A predictive B+-tree for reducing writes on phase change memory. IEEE Transactions on Knowledge and Data Engineering 26, 10 (2014), 2368--2381.Google Scholar
Cross Ref
- A. Ji Dou, S. Lin, and V. Kalogeraki. 2008. Real-time querying of historical data in flash-equipped sensor devices. In Proceedings of the IEEE Real-Time Systems Symposium. 335--344. Google Scholar
Digital Library
- Y.-H. Kuan, Y.-H. Chang, P.-C. Huang, and K.-Y. Lam. 2014. Space-efficient multiversion index scheme for pcm-based embedded database systems. In ACM/IEEE Design Automation Conference (DAC’14). Google Scholar
Digital Library
- S. Lai. 2003. Current status of the phase change memory and its future. In IEEE International Electron Devices Meeting (IEDM'03). 10.1.1--10.1.4. DOI:http://dx.doi.org/10.1109/IEDM.2003.1269271Google Scholar
Cross Ref
- K.-Y. Lam, J. Wang, J. K.-Y. Ng, S. Han, L. Zheng, C. H. C. Kam, and C. Zhu. 2014. SmartMood: Towards pervasive mood tracking and analysis for manic episode detection. IEEE Transactions on Human-Machine Systems 45, 1 (Feb. 2015), 126--131.Google Scholar
- E. A. Lee. 2010. CPS foundations. In Proceedings of the Design Automation Conference. 737--742. Google Scholar
Digital Library
- E. A. Lee and S. A. Seshia. 2011. Introduction to Embedded Systems-A Cyber-Physical Systems Approach.Google Scholar
- D. Liu, T. Wang, Y. Wang, Z. Shao, Q. Zhuge, and E. Sha. 2013. Curling-PCM: Application-specific wear leveling for phase change memory based embedded systems. In Proceedings of the Asia and Sound Pacific Design Automation Conference.Google Scholar
- D. Lomet and B. Salzberg. 1989. Access methods for multiversion data. In Proceedings of the ACM SIGMOD Conference. 315--324. Google Scholar
Digital Library
- Y. Ou, L. Chen, J. Xu, and T. Harder. 2014. Wear-aware algorithms for PCM-based database buffer pools. In Web-Age Information Management International Workshops. 165--176.Google Scholar
- S. Pathak, Y. C. Tay, and Q. Wei. 2011. Power and endurance aware flash-PCM memory system. In Proceedings of the International Green Computing Conference (IGCC’11). 1--6. Google Scholar
Digital Library
- M. K. Qureshi, V. Srinivasan, and J. A. Rivers. 2009. Scalable high performance main memory system using phase-change memory technology. In Proceedings of the 36th Annual International Symposium on Computer Architecture (ISCA'09). ACM, New York, NY, 24--33. DOI:http://dx.doi.org/10.1145/1555754.1555760 Google Scholar
Digital Library
- R. Rajkumar, I. Lee, L. Sha, and J. Stankovic. 2010. Cyber-physical systems: The next computing revolution. In Proceedings of the Design Automation Conference. 731--736. Google Scholar
Digital Library
- S. Raoux, G. W. Burr, M. J. Breitwisch, C. T. Rettner, Y.-C. Chen, R. M. Shelby, M. Salinga, D. Krebs, S.-H. Chen, H.-L. Lung, and C. H. Lam. 2008. Phase-change random access memory: A scalable technology. IBM Journal of Research and Development 52, 4/5 (Jul./Sept. 2008), 465--479. Google Scholar
Digital Library
- B. Salzberg and V. J. Tsotras. 1999. Comparison of access methods for time-evolving data. ACM Computing Survey 31, 2 (1999), 158--221. Google Scholar
Digital Library
- A. Silberschatz, P. B. Galvin, and G. Gagne. 2014. Operating System Concepts (9th ed.). John Wiley 8 Sons.Google Scholar
- J. Song, S. Han, A. K. Mok, D. Chen, M. Lucas, M. Nixon, and W. Pratt. 2008. WirelessHART: Applying wireless technology in real-time industrialprocess control. In Proceedings of the IEEE Real-Time and Embedded Technology and Applications Symposium. 377--386. Google Scholar
Digital Library
- UMass Trace Repository. 2012. Smart Data Set for Sustainability. (2012). http://traces.cs.umass.edu/index.php/Smart/Smart.Google Scholar
- P. J. Varman and R. M. Verma. 1997. An efficient multiversion access structure. IEEE Transactions on Knowledge and Data Engineering 9, 3 (1997), 391--409. Google Scholar
Digital Library
- J. Wang, K.-Y. Lam, Y.-H. Chang, J.-W. Hsieh, and P.-C. Huang. 2014. Block-based multi-version B+-tree for flash-based embedded database systems. IEEE Transactions on Computers 64, 4 (April 2015), 925--940.Google Scholar
- H.-S. P. Wong, S. Raoux, S. B. Kim, J. Liang, J. P. Reifenberg, B. Rajendran, M. Asheghi, and K. E. Goodson. 2010. Phase change memory. Proceedings of the IEEE 98, 12 (2010), 2201--2227. DOI:http://dx.doi.org/ 10.1109/JPROC.2010.2070050Google Scholar
Cross Ref
- M.-C. Yang, M. Kuo, C.-W. Tsao, and Y.-H. Chang. 2013. A fifty-percent rule to minimize the energy consumption of PCM-based storage systems. In IEEE 19th International Conference on Embedded and Real-Time Computing Systems and Applications (RTCSA'13).Google Scholar
- J. Yue and Y. Zhu. 2013. Accelerating write by exploiting PCM asymmetries. In Proceedings of the 2013 IEEE 19th International Symposium on High Performance Computer Architecture (HPCA'13). Google Scholar
Digital Library
- D. Zeinalipour-Yazti, S. Lin, V. Kalogeraki, D. Gunopulos, and W. A. Najjar. 2005. Microhash: An efficient index structure for flash-based sensor devices. In The 15th USENIX Conference on File and Storage Technologies (FAST'05). 31--44. Google Scholar
Digital Library
- R. Zhang and M. Stradling. 2010. The hv-tree: A memory hierarchy aware version index. Journal Proceedings of the VLDB Endowment 3, 1 (2010), 397--408. Google Scholar
Digital Library
- P. Zhou, B. Zhao, J. Yang, and Y. Zhang. 2009. A durable and energy efficient main memory using phase change memory technology. In Proceedings of the 36th Annual International Symposium on Computer Architecture (ISCA'09). 14--23. Google Scholar
Digital Library
Index Terms
Space-Efficient Index Scheme for PCM-Based Multiversion Databases in Cyber-Physical Systems
Recommendations
Linked Block-based Multiversion B-Tree index for PCM-based embedded databases
In this paper, by exploring the application characteristics of cyber-physical systems (CPS) and the performance characteristics of PCM, we propose a new B-tree index structure, called Linked Block-based Multi-Version B-Tree (LBMVBT), for indexing multi-...
Space-Efficient Multiversion Index Scheme for PCM-based Embedded Database Systems
DAC '14: Proceedings of the 51st Annual Design Automation ConferenceEmbedded database systems are widely adopted in various control and motoring systems, e.g., cyber-physical systems (CPSes). To support the functionality to access the historical data, a multiversion index is adopted to maintain multiple versions of data ...
Garbage Collection for Multiversion Index in Flash-Based Embedded Databases
Recently, flash-based embedded databases have gained their momentum in various control and monitoring systems, such as cyber-physical systems (CPSes). To support the functionality to access the historical data, a multiversion index is adopted to ...






Comments