跳到主要內容

臺灣博碩士論文加值系統

(100.24.118.144) 您好!臺灣時間:2022/12/06 05:54
字體大小: 字級放大   字級縮小   預設字形  
回查詢結果 :::

詳目顯示

: 
twitterline
研究生:林昇逸
研究生(外文):Sheng-Yi Lin
論文名稱:新型資料庫應用在磨課師平台之研究與探討
論文名稱(外文):A Study of Applying NewSQL to MOOCs Platform
指導教授:黃仁竑黃仁竑引用關係
指導教授(外文):Ren-Hung Hwang
口試委員:賴槿峰黃啟富葉瑞峰
口試委員(外文):Chin-Feng LaiChi-Fu HuangJui-Feng She
口試日期:2014-07-25
學位類別:碩士
校院名稱:國立中正大學
系所名稱:資訊工程研究所
學門:工程學門
學類:電資工程學類
論文種類:學術論文
論文出版年:2014
畢業學年度:102
語文別:中文
論文頁數:44
中文關鍵詞:MySQLNoSQLNewSQLACIDInnoDB
外文關鍵詞:MySQLNoSQLNewSQLACIDInnoDB
相關次數:
  • 被引用被引用:3
  • 點閱點閱:1287
  • 評分評分:
  • 下載下載:292
  • 收藏至我的研究室書目清單書目收藏:5
在資訊通訊科技相關技術的蓬勃發展下,人們對於數位學習的使用需求與日俱增,造就了全世界對數位學習的熱潮。為了能夠處理大量使用者同時存取資料庫的需求,處理海量資料的NoSQL資料庫便因應而生。現今所發展出來的NoSQL資料庫眾多,但大多數的NoSQL資料庫,並沒有辦法提供關聯式資料庫中的ACID(atomicity, consistency, isolation, durability)資料庫設計模式,再加上要將關聯式資料庫轉移至NoSQL資料庫是一件非常困難且複雜的事情,也並非所有的資料都適合用NoSQL資料庫來儲存。因此,本篇論文主要以NewSQL應用在MOOCs平台上來做一探討。透過在MySQL中加上NoSQL介面,讓MySQL能夠直接對其底層的InnoDB儲存引擎進行存取,來加速資料庫的存取速度,藉此改良MySQL的執行效能,同時降低系統負載。另外,在程式設計介面方面,NewSQL提供了InnoDB API,讓程式設計師能夠直接與MySQL的InnoDB溝通,藉由略過SQL語法的解析與最佳化等步驟,來加速平台運行速度。讓原本以關聯式資料庫為基礎設計的網頁應用系統,能夠直接套用NewSQL架構,使得資料庫有更好的效能提昇,並兼顧原本採用關聯式資料庫設計的好處。
In the booming of ICT-related technology, people’s demand for the use of e-Learning grows and e-Learning becomes a wave all over the world. In order to let users deal with accessing big data from database simultaneously, NoSQL databases have been developed. Many of NoSQL databases appear today, but most of the NoSQL databases have no way to provide ACID (atomicity, consistency, isolation, durability) design mode like the relational databases, and it is difficult and complex to migrate and store relational databases to NoSQL databases. Therefore, this paper mainly applied NewSQL to MOOCs platform. Through add NoSQL interface to MySQL, it can access the underlying InnoDB storage engine to accelerate the access speed of the database directly, thereby improving the MySQL performance and reducing system load. In addition, at the side of programming design interface, NewSQL provides InnoDB API, so that programmers can communicate directly with MySQL's InnoDB. Through skipped by SQL syntax parsing and optimization speed up platform running speed. Let web applications system based on relational database can be directly applied NewSQL architecture. Therefore, it can has the benefits for using original relational database and improves a better database performance.
目錄
1. 緒論 1
1.1 研究背景 1
1.2 研究動機 2
1.3 研究目的與貢獻 4
1.4 論文架構 4
2. 相關研究 5
3. 方法架構 13
3.1 如何利用NEWSQL來強化效能 13
3.2 NEWSQL架構下的MOOCS平台之資料庫查詢分類與優化 14
4. 模擬分析 19
4.1 實驗環境與參數 19
4.2 模擬結果探討 23
5. 結論與未來展望 34
6. 參考文獻 35


[1]Armando Fox, “From MOOCs to SPOCs,” Communications of the ACM, vol. 56, no. 12, Dec. 2013.
[2]Bill Tucker, “The Flipped Classroom”, Education Next, 2012.
[3] J. Polorny, “NoSQL databases: a step to database scalability in web environment,” in Proc. of the 13th International Conference on Information Integration and Web-based Applications and Services, iiWAS’11, New York, USA, 2011, pp. 278-283.
[4]NoSQL. [Online] http://nosql-database.org/.
[5]教育部數位學習服務平台. [Online] http://ups.moe.edu.tw/.
[6]MySQL. [Online] http://www.mysql.com/.
[7]Jaroslav Pokorny, International Journal of Web Information Systems, Vol. 9 No.1, 2013, pp.69-82.
[8]MySQL及NoSQL使用指南. [Online] http://www.mysql.com/why-mysql/white-papers/mysql-nosql-user-guide/
[9]R. Elmasri, S. B.Navathe, Fundamentals Of Database Systems, 6th ed, 2010, pp. 751-754.
[10]Handlersocket. [Online] http://yoshinorimatsunobu.blogspot.tw/search/label/handlersocket
[11]H. Shim, Y. Sohn, Y. Sung, Y. Kang, I. Kim, and O. Kwon, “An Object-oriented Approach for Extending MySQL into NoSQL with Enhanced Performance and Scalability,” DBKDA 2014 : The Sixth International Conference on Advances in Databases, Knowledge, and Data Applications, Apr. 2014.
[12]memcached with InnoDB. [Online] http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached.html
[13]memcache. [Online] http://memcached.org/
[14]Giuseppe DeCandia, Deniz Hastorun, Madan Jampani, Gunavardhan Kakulapati,
Avinash Lakshman, Alex Pilchin, Swaminathan Sivasubramanian, Peter Vosshall
and Werner Vogels, “Dynamo: Amazon’s Highly Available Key-value Store,” SOSP of ACM, vol.41 Issue 6, Dec 2007, pp.208
[15] Benefits of the InnoDB / memcached Combination. [Online] http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-benefits.html
[16] X. Wang, B. Zhou and W.Li, “A Streaming Protocol for Memcached,” Information Technology Journal of Asian Network for Scientific Information, pp1777-1778
[17]Developing a memcached Application. [Online] http://dev.mysql.com/doc/refman/5.6/en/ha-memcached-interfaces.html
[18] SASL. [Online] https://tools.ietf.org/html/rfc2222
[19] SASL memcached. [Online] http://blog.couchbase.com/sasl-memcached-now-available
[20] AWStat. [Online] http://awstats.sourceforge.net/
[21] VMware. [Online] http://www.vmware.com/
[22]Chien-Wei Huang, “Improving the Performance of Relational Database: A Hybrid Approach of SQL and NoSQL Database,” pp.14-19.
[23] Jmeter. [Online] http://jmeter.apache.org/
QRCODE
 
 
 
 
 
                                                                                                                                                                                                                                                                                                                                                                                                               
第一頁 上一頁 下一頁 最後一頁 top