在資訊通訊科技相關技術的蓬勃發展下,人們對於數位學習的使用需求與日俱增,造就了全世界對數位學習的熱潮。為了能夠處理大量使用者同時存取資料庫的需求,處理海量資料的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.