Publication Date

Summer 2013

Document Type

Project Summary

Degree Name

Master of Science

Department

Computer Science

First Advisor

(Clare) Xueqing Tang, Ph.D.

Second Advisor

Stephen Hyzny, M.S.

Third Advisor

Soon-Ok Park, Ph.D.

Abstract

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.

Comments

Abstract derived by OPUS staff.

Download

Share

COinS