skip to main content
research-article
Public Access

Space-Efficient Index Scheme for PCM-Based Multiversion Databases in Cyber-Physical Systems

Published:13 October 2016Publication History
Skip Abstract Section

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.

References

  1. 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 ScholarGoogle Scholar
  2. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  3. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  4. 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 ScholarGoogle Scholar
  5. 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 ScholarGoogle Scholar
  6. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  7. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  8. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  9. 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 ScholarGoogle Scholar
  10. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  11. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  12. 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 ScholarGoogle ScholarCross RefCross Ref
  13. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  14. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  15. 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 ScholarGoogle ScholarCross RefCross Ref
  16. 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 ScholarGoogle Scholar
  17. E. A. Lee. 2010. CPS foundations. In Proceedings of the Design Automation Conference. 737--742. Google ScholarGoogle ScholarDigital LibraryDigital Library
  18. E. A. Lee and S. A. Seshia. 2011. Introduction to Embedded Systems-A Cyber-Physical Systems Approach.Google ScholarGoogle Scholar
  19. 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 ScholarGoogle Scholar
  20. D. Lomet and B. Salzberg. 1989. Access methods for multiversion data. In Proceedings of the ACM SIGMOD Conference. 315--324. Google ScholarGoogle ScholarDigital LibraryDigital Library
  21. 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 ScholarGoogle Scholar
  22. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  23. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  24. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  25. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  26. B. Salzberg and V. J. Tsotras. 1999. Comparison of access methods for time-evolving data. ACM Computing Survey 31, 2 (1999), 158--221. Google ScholarGoogle ScholarDigital LibraryDigital Library
  27. A. Silberschatz, P. B. Galvin, and G. Gagne. 2014. Operating System Concepts (9th ed.). John Wiley 8 Sons.Google ScholarGoogle Scholar
  28. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  29. UMass Trace Repository. 2012. Smart Data Set for Sustainability. (2012). http://traces.cs.umass.edu/index.php/Smart/Smart.Google ScholarGoogle Scholar
  30. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  31. 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 ScholarGoogle Scholar
  32. 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 ScholarGoogle ScholarCross RefCross Ref
  33. 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 ScholarGoogle Scholar
  34. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  35. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  36. 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 ScholarGoogle ScholarDigital LibraryDigital Library
  37. 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 ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. Space-Efficient Index Scheme for PCM-Based Multiversion Databases in Cyber-Physical Systems

          Recommendations

          Comments

          Login options

          Check if you have access through your login credentials or your institution to get full access on this article.

          Sign in

          Full Access

          PDF Format

          View or Download as a PDF file.

          PDF

          eReader

          View online with eReader.

          eReader
          About Cookies On This Site

          We use cookies to ensure that we give you the best experience on our website.

          Learn more

          Got it!