Blog: Archive

agsdix-fas fa-home

Blog: Home

agsdix-fas fa-pen-fancy

Blog: CEO's Corner

agsdix-fas fa-code

Blog: Tech Talk

Blog: Product Releases

agsdix-fas fa-chalkboard-teacher

Blog: Viewing

Blog: Conversion

SharePoint databases ”should not include binary files”

by | Nov 20, 2008

SharePoint administrators have been told to omit binary files from databasesBinary files should not be included in SharePoint databases, according to an EMC representative.

Andrew Chapman, general manager of the SharePoint technologies group and senior director of the compliance applications groups for EMC”s content management and archiving business unit, makes the claim on the company”s Never Talk When You Can Nod blog.

He explains that databases are the correct places in which to store metadata about a project – such as its title.

Related information such as security details, which site the project came from and the folder location may also be stored.

But he warns against including binary files – such as zip archives, PowerPoint slideshows and Adobe Acrobat portable documents – in such a database.

"Databases excel at managing lots of ickle bits of data but they suck when it comes to managing large binary objects," he explains.

Companies looking to allow centralized access to binary files could instead opt for a document viewer to permit different formats to be opened by employees accessing the IT network from a workstation or over the internet.

Mr Chapman previously argued that SharePoint, when compared with other enterprise content management systems, is "intuitive, fun to use and definitely aimed at the end-user community."

The addition of a cross-format document viewer could render the platform even easier for workers with many different files to handle.ADNFCR-1861-ID-18886761-ADNFCR