Analysis and Design of a Filestream Based English Language Learning System

摘要

—The paper discusses the feasibility of constructing a SQL Server FILESTREAM based English language learning system (ELLS). The paper focuses on the analysis and design phase of the system. It explains the prospect of storing and managing unstructured data (e.g. Images, video, Word, Excel, PDF, MP3, etc) for educational purposes using FILESTREAM technique provided by SQL Server 2012, and how to maintain efficient storage and access to BLOB data. However, Storing unstructured data posed many challenges, such as how to maintain transactional consistency between the structured and unstructured data, how to manage backup, restore, and storage performance. The paper seeks to utilise the combination of SQL Server 2012 features and the NTFS (new technology file system) to overcome these issues and attempt to improve the efficiency and performance of the ELLS for children. The system also seeks to maintain the transactional consistency between the unstructured data and corresponding structured data. Several UML analysis techniques have been used to illustrate the analysis of the system requirements such as the Use Case diagrams, Sequence diagrams, Activity diagrams and Class diagrams. The database design of the system is also presented in this paper.