Study and Optimization of Database on Android Platform

Abstract:

Due to the poor database performance situation on Android operating system, put forward a methods of database access performance optimization. The paper first analyze the Android database access principle, architecture of SQLite and Berkeley DB, and methods of Berkeley DB in concurrent access, then put forward a method of porting Berkeley DB to Android to replace SQLite to enhance the database access performance. Finally a series of practical benchmark results shows that the porting brings performance improvement effect.

• Periodical: Applied Mechanics and Materials (Volumes 263-266)
• Pages: 1754-1758
• DOI: https://doi.org/10.4028/www.scientific.net/AMM.263-266.1754
• Online since: December 2012
• Authors: Gang Wang, Ming Yu Zhao
• Keywords: Android, Berkeley DB, Database, Embedded, SQLite

References

[1] ZHAN Chengguo, ZHU Wei, XU Min: Man-machine interface design and implementation based on Android for measuring and control unit, Electric Power Automation Equipment, Vol.32, No.1, Jan.(2012)

[2] CAI Li, DAI Nina, DENG Ming: Design of car virtual instrument based on OBD for Android, Application of Electronic Technique, Vol.37, No.12, Dec.(2011)

[3] YAO YuMin, LIU Weiguo: Study of Android's Architecture and Its Application Development, Computer System & Applications, Vol.17, No.11, Nov.(2008)

[4] REN Junwei, LIN Dongdai: Research of Platform Independent Programming Using JNI Technology, Application Research of Computers, Vol.25, No.7, Jul.(2005)

[5] Information on http://www.oracle.com/technetwork/products/berkeleydb/overview/index.html

[6] WAN Maning, GUAN Yong, HAN Xiangjun, Research on Typical Technologies of embedded database-SQLite and Berkeley DB, Control & Automation, Vol.22, No.2, Feb.(2006)

[7] Mike Owens: Oracle Berkeley DB SQL API vs. SQLite API – Integration, Benefits and Differences(Oracle, 2010)

[8] Information on http://www.sqlite.org/

[9] Michael Owens:The Definitive Guide to SQLite(Apress, Berkeley 2006)