| 姓名 |
楊珈瑀(Chia-yu Yang)
查詢紙本館藏 |
畢業系所 |
資訊工程學系 |
| 論文名稱 |
在 Android 平板電腦上設計並實作一數位內容管理與互動服務
(The Design and Development of a Digital Content Management and Interaction Service for Android Tablet)
|
| 相關論文 | |
| 檔案 |
 [Endnote RIS 格式]
[Bibtex 格式]
 [相關文章]  [文章引用]  [完整記錄]  [館藏目錄]  至系統瀏覽論文 ( 永不開放)
|
| 摘要(中) |
隨著可攜式裝置的普及，其中又以平板電腦比起手機更為方便閱讀與操作，比起筆記型電腦更為方便攜帶，以及Android應用程式開發框架的發展，數位學習不僅跳脫了以往時間與空間的限制，更使研究人員獲得更多開放的環境與資源來進行相關服務的開發；且考量到平板電腦可能處於無網路環境中，或需透過網路進行數位內容學習的方式可能造成裝置電量的迅速耗損，故本服務設計以平板電腦本地端的SD Card儲存裝置，以及外接式硬碟來分別存放大量而豐富的數位內容教材資源，亦將數位內容題庫教材整合於高移植（跨平台）性的SQLite資料庫中，期望在未來能以同樣的教材資源資料庫，即可於不同平台上存取；而為了防堵具有版權所屬之教材資料被任意重製，以SQLCipher工具配合SQL命令以AES-256演算法進行資料庫加密，再經由本實作應用程式存取SQLCipher for Android函示庫將解密後的資料呈現於適當的使用者介面中，提供相關行動化數位內容學習之操作。
綜合以上所述，為達到行動化數位學習的目標，本論文實作設計以搭載Android 4.0.3作業系統之ASUS Eee Pad Transformer Prime TF201平板電腦為開發基礎，在其上建置並管理本地端的學習教材資源，且設計與開發一Android應用系統，具體實現三大行動化數位內容學習服務：多媒體影音教材移植、數位內容互動，及學習歷程記錄。
|
| 摘要(英) |
With popularity of mobile devices, the tablets are easier for reading and operation than mobile phones and more portable than notebooks. Also with development of Android application development framework, the digital content learning not only escapes from the limitation on time and space but allows researchers to develop related services via more open environment and resources. Besides, taking into consideration that tablets may be situated at a non-network environment, or device power may be depleted rapidly since the continuous connection to wireless internet while doing the process of mobile learning from online digital contents, so the design of the proposed service is making use of local SD Card in tablet and external hard disk as storages for a large amount of rich digital content material resources. Also, the resources of exam materials will be integrated into a SQLite database, which owns the feature of high portability for different platforms (cross-platform). In addition, for preventing from the arbitrary reproduction of digital content materials with copyrights, the material database is encrypted with AES-256 algorithm through making SQL commands on SQLCipher tool. Then, presenting the decrypted data on the appropriate user interface via accessing to the methods provided from “SQLCipher for Android” libraries, which are included in the implementation of the proposed service, furthermore, users can operate all the digital content learning activities with mobility.
To sum up, for achieving the goal of mobile learning, based on the environment of ASUS Eee Pad Transformer Prime TF201 tablet equipped with Android 4.0.3, the implementation of the proposed service builds and manages local digital content material resources, with design and development of an Android system for realization of three m-learning activities: “Multimedia Material Delivery”, “Digital Content Interaction”, and “Learning Record Presentation”.
|
| 關鍵字(中) |
★ 平板電腦
★ Android
★ SQLCipher
★ SQLite
★ 行動化數位內容學習
★ 數位內容 |
關鍵字(英) |
★ tablet
★ Android
★ SQLCipher
★ SQLite
★ m-learning
★ digital content |
| 論文目次 |
摘 要 i
ABSTRACT ii
誌 謝 iv
TABLE OF CONTENT v
LIST OF FIGURES vii
LIST OF TABLES ix
1. Introduction 1
1-1 Motivation 2
1-2 Organization 5
2. Background and Related Work 6
2-1 Android 6
2-1-1 Brief Introduction to Android 6
2-1-2 The Trend of Android Tablet 7
2-2 SQLite 8
2-2-1 Brief Introduction to SQLite 8
2-2-2 SQLite in Android 14
2-3 SQLCipher 15
2-3-1 Brief Introduction to SQLCipher 15
2-3-2 AES Algorithm 16
2-3-3 SQLCipher APIs 17
3. System Architecture 18
3-1 System Goal 18
3-2 System Overview 20
3-2-1 System Components 23
3-2-2 Software Modules 24
3-2-3 Content Delivery Mechanism 29
3-2-4 Content Management Mechanism 32
4. System Implementation 35
4-1 Material Database Pre-processing 35
4-1-1 Modification of MS SQL Server (.mdf) Database 36
4-1-2 Converting MS SQL Server Database (.mdf) to SQLite Database (.db) 42
4-1-3 Encrypting SQLite Database Using SQLCipher 43
4-2 Digital Content Management and Interaction Service Program Design 45
4-2-1 The Employment of Android UI Components 46
4-2-2 Service Operation 55
5. Conclusion and Future Work 58
LIST OF REFERENCES 60
|
| 參考文獻 |
[1] 林欣玫：影響數位學習學習成效之相關因素探討。2011年10月13日，取自http://web.tiec.tp.edu.tw/gccce2007/00gccce2007/article/online_learning.pdf。
[2] INSIDE：網路數位學習的現況。2011年4月7日，取自http://www.inside.com.tw/2011/04/07/e-learning-overview。
[3] Lnw Rilak. Android mobile OS had 38.5% market share in 2011 and will be up to half of the world in 2015 Retrieved June 15, 2012, from http://blog.lnw.co.th/2011/04/08/android-%E0%B8%AA%E0%B8%B8%E0%B8%94%E0%B8%A2%E0%B8%AD%E0%B8%94-mobile-os-%E0%B8%81%E0%B8%B4%E0%B8%99%E0%B8%AA%E0%B9%88%E0%B8%A7%E0%B8%99%E0%B9%81%E0%B8%9A%E0%B9%88%E0%B8%87%E0%B8%95%E0%B8%A5%E0%B8%B2/#more-3168
[4] android developers (n.d.). What is Android? Retrieved Oct. 13, 2011, from http://developer.android.com/guide/basics/what-is-android.html
[5] developer.com (n.d.). Android: A Brief Introduction Retrieved June 17, 2012, from http://www.developer.com/ws/android/programming/Android-A-Brief-Introduction-3763991.htm
[6] perfecte.ro (n.d.). 2013 tablet computer’s trend: Android tablet computer Retrieved June 10, 2012, from http://club.perfecte.ro/2012/05/29/2013-tablet-computers-trend-android-tablet-computer/
[7] SQLite.org (n.d.). Distinctive Features Of SQLite Retrieved Feb. 8, 2012, from http://www.sqlite.org/different.html
[8] FindTheBest (n.d.). Microsoft SQL Server V.S. SQLite Retrieved Feb. 10, 2012, from http://database-management-systems.findthebest.com/compare/26-53/Microsoft-SQL-Server-vs-SQLite
[9] android developers (n.d.). Data Storage Retrieved Feb. 22, 2012, from http://developer.android.com/guide/topics/data/data-storage.html#db
[10] SQLCipher (n.d.). Features Retrieved March 8, 2012, from http://sqlcipher.net/
[11] hwaci.com (n.d.). The SQLite Encryption Extension (SEE) Retrieved March 5, 2012, from http://www.hwaci.com/sw/sqlite/see.html
[12] sqlite-crypt.com (n.d.). SQLITE CRYPT Retrieved March 6, 2012, from http://sqlite-crypt.com/
[13] wikipedia.org (n.d.). Advanced Encryption Standard Retrieved March 25, 2012, from http://en.wikipedia.org/wiki/Advanced_Encryption_Standard
[14] SQLCipher (n.d.). SQLCipher API Retrieved March 8, 2012, from http://sqlcipher.net/sqlcipher-api/
[15] 林永坚：浅谈Windows Phone 7本地数据库的选择。2012年3月13日，取自http://www.cnblogs.com/procoder/archive/2010/09/27/Windows-Phone-Database.html
[16] dan_ardelean. Sqlite Client for Windows Phone Retrieved March 16, 2012, from http://sqlitewindowsphone.codeplex.com/releases
[17] ASUS：ASUS Eee Pad 40 pin轉外接USB 2.0連接埠。2012年4月1日，取自http://shop.asus.com.tw/shop/tw/zh-TW/Home/1-Products/1500-ASUS-Collection/1936-Eee-Pad-Accessories/1937-Transformer-Prime-TF201-Accessories/90-XB2UOKEX00010-.aspx
[18] Gossip@caterpillar：Java Gossip: File。2012年4月20日，取自http://caterpillar.onlyfun.net/Gossip/JavaGossip-V2/FileClass.htm
[19] MSDN (n.d.). String Functions (Transact-SQL) Retrieved May 2, 2012, from http://msdn.microsoft.com/en-us/library/ms181984
[20] liron.levi. Convert SQL Server DB to SQLite DB Retrieved March 16, 2012, from http://www.codeproject.com/Articles/26932/Convert-SQL-Server-DB-to-SQLite-DB
[21] SQLCipher (n.d.). ATTACH Retrieved March 8, 2012, from http://sqlcipher.net/sqlcipher-api/#attach
[22] android developers (n.d.). SparseBooleanArray Retrieved March 30, 2012, from http://developer.android.com/reference/android/util/SparseBooleanArray.html
|
| 指導教授 |
吳曉光(Hsiao-kuang Wu)
|
審核日期 |
2012-7-25 |
| 推文 |
 facebook  plurk  twitter  funp  google  live  udn  HD  myshare  reddit  netvibes  friend  youpush  delicious  baidu
|
| 網路書籤 |
 Google bookmarks  del.icio.us  hemidemi myshare
|
