| 研究生: |
江奇偉 Chiang, Chi-wei |
|---|---|
| 論文名稱: |
基於SQLite提供隨插即用之儲存引擎 Enabling Storage Engines of Plug-and-Play in SQLite |
| 指導教授: |
蕭宏章
Hsiao, Hung-Chang |
| 學位類別: |
碩士 Master |
| 系所名稱: |
電機資訊學院 - 資訊工程學系 Department of Computer Science and Information Engineering |
| 論文出版年: | 2015 |
| 畢業學年度: | 103 |
| 語文別: | 英文 |
| 論文頁數: | 24 |
| 中文關鍵詞: | 儲存引擎 、資料庫 |
| 外文關鍵詞: | Storage engine, Database |
| 相關次數: | 點閱:89 下載:0 |
| 分享至: |
| 查詢本校圖書館目錄 查詢臺灣博碩士論文知識加值系統 勘誤回報 |
SQLite資料庫是十分普及的資料庫能,著重於embedded library 的執行方式,有別於一般資料庫需要額外的機器作為server端,SQLite資料庫可將程式碼嵌入到任何應用程式上一起執行,甚至本身就可以作為一支獨立的程式。然而SQLite在儲存資料的方式只有一種,這樣的做法很受限制,因為不同的資料型態或是資料使用方式會有各自最恰當的儲存資料方法來加速處理資料的時間或減少儲存資料的空間。而目前現有的MariaDB已經有一套可抽換storage engine的架構,所以本篇論文想讓SQLite能夠透過整合MariaDB的handler部分而擁有可抽換式的storage engine,來適應各種使用環境。
SQLite is a widely deployed and used database engine, which implements a serverless SQL database engine. Unlike most SQL database engines, SQLite is not implemented as a separate server process, and it can be embedded into an end program. However, there is few storage engine for SQLite up to this point. Different storage engines are suitable for different data usage and data types for improving data access time or reducing data space. MariaDB has already implemented a handler to manage different storage engines. Therefore, we propose an approach to enable storage engines of plug-and-play in SQLite by integrating with MariaDB storage engine handler.
[1.]Most Widely Deployed and Used Database Engine, http://sqlite.org/mostdeployed.html
[2.]The Architecture Of SQLite, https://www.sqlite.org/arch.html
[3.]The CSV Storage Engine, https://dev.mysql.com/doc/refman/5.5/en/csv-storage-engine.html
[4.]Introduction to InnoDB, https://dev.mysql.com/doc/refman/5.5/en/innodb-introduction.html
[5.]LevelDB Storage Engine, https://mariadb.com/kb/en/mariadb/leveldb/
[6.]What is a Transaction? , https://msdn.microsoft.com/en-us/library/aa366402(VS.85).aspx
[7.]Well-Known Users of SQLite, https://www.sqlite.org/famous.html
[8.]The Architecture Of SQLite, https://www.sqlite.org/arch.html
[9.]The Lemon Parser Generator, https://www.sqlite.org/src/doc/trunk/doc/lemon.html
[10.]LALR parser, https://en.wikipedia.org/wiki/LALR_parse
[11.]Johnson, Stephen C. Yacc: Yet another compiler-compiler. Vol. 32. Murray Hill, NJ: Bell Laboratories, 1975.
[12.]MariaDB An enhanced, drop-in replacement for MySQL, https://mariadb.org/
[13.]Storage Engines, https://mariadb.com/kb/en/mariadb/storage-engines/
校內:2020-08-24公開