SQLite Database and its Application on Embedded Platform

SQLite Database and its Application on Embedded Platform

  IJCTT-book-cover
 		 International Journal of Computer Trends and Technology (IJCTT)          
 
© 2019 by IJCTT Journal
Volume-67 Issue-2
Year of Publication : 2019
Authors : Y.V. Sai Bharadwaj, Sai Bhageerath Yarrapatruni, Dr. Prasada Rao YVSSSV
DOI :  10.14445/22312803/IJCTT-V67I2P101

MLA

MLA Style: Y.V. Sai Bharadwaj, Sai Bhageerath Yarrapatruni, Dr. Prasada Rao YVSSSV "SQLite Database and its Application on Embedded Platform" International Journal of Computer Trends and Technology 67.2 (2019): 1-6.

APA Style:Y.V. Sai Bharadwaj, Sai Bhageerath Yarrapatruni, Dr. Prasada Rao YVSSSV (2019). SQLite Database and its Application on Embedded Platform. International Journal of Computer Trends and Technology, 67(2), 1-6.

Abstract
SQLite is an embedded database system, which is popularly used in embedded environments like mobile devices, remote sensing, control systems, information appliances etc. It has turned out to be the focal point for development works in related areas. Reliability, robustness, security, fast and high efficiency, flexibility and so on, are unique to it among many other embedded databases. This paper outlines the basic features, structure and the key technologies of main embedded databases, analyses the characteristics, architecture and the interface functions of SQLite. Also, a detailed porting process from SQLite to ARM-Linux platform is discussed and a development case on home gateway over ARM-Linux is examined.

Reference
[1] Chunyue Bi et al., “Research and Application of SQLite Embedded Database Technology”, WSEAS TRANSACTIONS on COMPUTERS, Issue 1, Volume 8, January 2009, pp. 83-91.
[2] B. Schneier, A. Shostack. Breaking up is hard to do: Modeling Security Threats for Smart Cards. USENIX Symposium on Smart Cards, 1999.
[3] R. Munz: Usage Scenarios of DBMS, Keynote, 25th International Conference on Very Large Data Bases, Edinburgh, UK, 1999, http://www.dcs.napier.ac.uk/~vldb99/Industrial SpeakerSlides/SAPVLDB.pdf
[4] Jiang MF et al., “Discovering Structure from Document Databases”, Lecture Notes in Computer Science, vol 1574. Springer
[5] Rick F, et al., Introduction to SQL: Mastering the Relational Database Language, Addison Wesley, 2006.
[6] Hector.Garcia-Molina, et al., Database System Implementation, Prentice Hall, 2001.
[7] Mike Owens and Grant Allen, “The Definitive Guide to SQLite”, Apress 2nd edition, 2006.
[8] SQLite homepage [EB/OL], http://www.sqlite.org.
[9] Oracle Berkeley DB SQL API vs SQLite API- Integration, Benefits and Differences, Oracle White paper, Nov 2016, pp. 1-11.
[10] Mike Owens, Embedding SQL Database with SQLite, Linux Journal, June 2003.
[11] P. Bohannon, D. Lieuwen, R. Rastogi, A. Silberschatz, S. Seshadri, S. Sudarshan, "The Architecture of the Dalí Main-Memory Storage Manager", Multimedia Tools and Applications, vol. 4, no. 2, pp. 115-151, 1997.
[12] Michael A.Olson, Selecting and implementing an EDS, IEEE Computer, 2000,33(7). 27-34.
[13] Ling-yun, Li-Jun, The Development and Application of Script Program Based on SQLite, China Academic Journal Electronic Publing House, 1994-2008.
[14] Cisco Visual Networking Index: Global Mobile Data Traffic Forecast Update, 2012-2017, Cisco, February 2013.
[15] Chaudhuri, S., Narasayya, V., “AutoAdmin „WhatIf? Index Analysis Utility,” Proceedings of the ACM SIGMOD Conference, Seattle, 1998.
[16] Rick F, van der Lans. Introduction to SQL: Mastering the Relational Database Language, Addison Wesley, 2006.

Keywords
Embedded Database; SQLite; Porting; ARM-Linux; Home Gateway