Managing unstructured data through SQL 2008

Managing unstructured data through SQL Server 2008

SQL Server Technical Documentation

Author: Graeme Malcolm (Content Supervisor)

Technical Auditor: Shan Sinha

Project Editor: Joanne Hodgins

Release Date: August 2007

Applicable products: SQL Server 2008

Overview: The growth of digital information provides an inspiration for how businesses should store and access business data. As the core of business applications, databases must be able to integrate with unstructured data, including documents, images, video, and other multimedia formats. To be able to manage the information lifecycle, meet policy requirements, and implement content management solutions, organizations need to store and manage digitized data in all formats.

Microsoft SQL server™2008 provides a flexible solution for storing unstructured data and combining it with relational data to build a comprehensive solution around all the data in the enterprise.

Copyright

This white paper is a preliminary document and may be completely modified before the software is finally commercially released.

The information contained in this document represents the current view of Microsoft Corporation (Microsoft Corporation) on the issues discussed at the date of release. Because Microsoft must comply with changing market conditions, this document should not be construed as a commitment by the Microsoft side, and Microsoft does not guarantee the accuracy of the information given after the date of release.

This white paper is for informational purposes only. Microsoft does not make any express, implied, or statutory warranty with respect to the information in this document.

It is the user's responsibility to comply with all applicable copyright laws. Without limiting the rights under copyright, no part of this article shall be reproduced or disseminated in any form or by any means (electronic, mechanical, photocopying, recording, etc.) for any purpose, in any manner or by any instrument (electronics, machinery, photocopies, recordings, and so on), in the express written permission of Microsoft Corporation, It may not be stored or introduced into a retrieval system.

This document may involve Microsoft's patents, patent applications, trademarks, copyrights, or other intellectual property rights. Unless expressly provided by Microsoft through a written license agreement, this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.

Unless otherwise noted, the company described herein as an example, organizations, products, domain names, e-mail addresses, logos, people, places, and events are fictitious and do not have any contact with any real company, organization, product, domain name, e-mail address, logo, person, place, or event, nor should any conjecture or inference be made accordingly.

ó2007 Microsoft Corporation. All rights reserved.

Microsoft, Excel, SQL Server, and Windows are registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

All other trademarks are the property of their respective owners.

Directory

Introduction 1

Commercial power of unstructured data 1

Challenges to unstructured data 1

Challenges for storing unstructured data 2

Challenges in using unstructured data 2

Target 2 of unstructured data in SQL Server 2008

Storing unstructured data in SQL Server 2008 2

SQL Server BLOB3

FILESTREAM Property 3

Remote BLOB Storage API3

Comparison of storage options for BLOBs 4

Searching for unstructured data in SQL Server 2008 4

Integrated Full-text Search 5

Conclusion 5