Browse > Article
http://dx.doi.org/10.5762/KAIS.2011.12.7.3227

Design, Implementation, and Performance Evaluation of an Embedded RDBMS Miracle  

Seo, Nam-Won (Department of Computer Engineering, Hoseo University)
Kim, Keong-Yul (Department of Computer Engineering, Hoseo University)
Kim, Su-Hee (Department of Computer Engineering, Hoseo University)
Publication Information
Journal of the Korea Academia-Industrial cooperation Society / v.12, no.7, 2011 , pp. 3227-3235 More about this Journal
Abstract
In this paper, a relational embedded DBMS was designed and a prototype 'Miracle' RDBMS (MDB) was developed. MDB is written in C and works on Unix, Linux and Windows platforms locally. It accesses database through SQL interfaces and API functions and uses $B^+$ tree index. It guarantees ACID in transactions and supports low concurrency control and processes SQL statements on a single table. To evaluate the performance of MDB on an ARM board EZ-S3C6410 and to compare the performance of MDB with that of SQLite, an experiment was carried out to estimate processing times for insertion, selection, update and deletion operations. The result shows that the average times for selections and insertions in MDB were 38.46% and 22.86% faster than those in SQLite, respectively, but the average times for updates and deletions in SQLite were 28.33% and 26.00% faster than MDB, respectively, This experiment shows that fetching data from database and sending data to database in MDB is faster than in SQLite, but $B^+$ tree index is implemented more effectively in SQlite than in MDB.
Keywords
Embedded Relational DBMS; Design and Implementation; Data Processing Time;
Citations & Related Records
연도 인용수 순위
  • Reference
1 JeongJeong Woo, GongJun Sa, "Embedded Linux Basics and Applications", Hanbit Media, inc. 2007
2 YongJin Sin, "Maximizing Through-put with Embedded DBMS," Embedded World, May, 2008.
3 Dong-SeoK Lee, Nam-Won Seo, Dong-Hyun Nam, Georgy Ni, Su-Hee Kim, "Design and Implementation of an Embedded DBMS", Korea Information Science Society, Vol.36 No.2C, pp. 82-86, 2009, 11.
4 http://www.sybase.com/products/databasemanagement/advantagedatabaseserver
5 http://www.oracle.com/us/products/database/berkeley-db/index.html
6 http://en.wikipedia.org/wiki/Extensible_Storage_Engine
7 http://www.sqlite.org
8 http://en.wikipedia.org/wiki/Embedded_database
9 http://blog.paran.com/blog/detail/postBoard.kth?blogDataId=552438&pmcId=mtkim&page=0&totalCount=0&pageStyle=null&myCateId=0&yearMonth=null&rDay=null&style=Board
10 Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widsom. Database System Implementation DepARMent of Computer Science Stanford University, 2000.
11 http://en.wikipedia.org/wiki/B%2B_tree
12 Raghu Ramakrishnan, Johannes Gehrke. Database Management Systems 3rd Edition. McGraw-Hill, 2007.
13 http://blog.naver.com/runter1