Master of Science
(Clare) Xueqing Tang, Ph.D.
Stephen Hyzny, M.S.
Soon-Ok Park, Ph.D.
Data is sometimes unstructured, such as text documents, images, and videos. This unstructured data is regularly stored outside the database, different from its structured data. This separation can cause data management problems. Or, if the data is connected with regulated storage, the performance and the file streaming capabilities and can degrade.
FILESTREAM incorporates the SQL Server Database Engine with an NTFS file system by loading varbinary(max) BLOB data as files. And make them available to the file system. Transact-SQL statements can update, query, search, insert, and or back up FILESTREAM data. The Win32 file system interface affords streaming access to data. One of the greatest advantages to using file is that the files are backed up with the regular SQL data.
FILESTREAM uses the NT system cache for caching file data. This aids in reducing any effect that FILESTREAM data might have on Database Engine performance. The SQL Server buffer pool is not used so this memory is available for query processing. FILESTREAM data is not encrypted at any time even when transparent data encryption is turned on.
Massey, Derrick, "Filestream Enhancement to the Courseweb Grading System" (2013). All Capstone Projects. 62.