United States   Change   |   All Microsoft Sites

Home

White Paper: Managing Unstructured Data with SQL Server 2008

The proliferation of digital content has significant implications for the way in which organizations store and access business data. Increasingly, databases that are at the core of business applications must be integrated with unstructured data in the form of documents, images, video content, and other multimedia formats. Organizations increasingly need to be able to store and manage digital data of all formats in order to manage the information life cycle, meet compliance requirements, and implement content management solutions.

Microsoft SQL Server 2008 provides a flexible solution for storing unstructured data and combining it with relational data to build comprehensive solutions that encompass the full range of data across an organization.

Included in This Document

  • Introduction

  • Business Drivers for Unstructured Data

    • Challenges for Unstructured Data

    • Goals for Unstructured Data in SQL Server 2008

  • Storing Unstructured Data in SQL Server 2008

    • SQL Server BLOBs

    • The FILESTREAM Attribute

    • The Remote BLOB Store API

    • Comparing BLOB Storage Options

  • Searching Unstructured Data in SQL Server 2008

    • Integrated Full Text Search

  • Conclusion

Download White Paper