Pro Full-Text Search in SQL Server 2008

Businesses today want actionable insights into their data—they want their data to reveal itself to them in a natural and user–friendly form. What could be more natural than human language? Natural–language search is at the center of a storm of ever–increasing web–driven demand for human–computer communication and information access. SQL Server 2008 provides the tools to take advantage of the features of its built–in enterprise–level natural–language search engine in the form of Integrated Full–Text Search (iFTS). Integrated Full–Text Search uses text–aware relational queries to provide your users with fast access to content. Whether you want to set up an enterprise–wide Internet or intranet search engine or create less ambitious natural–language search applications, this book will teach you how to get the most out of SQL Server 2008 Integrated Full–Text Search:

• Introducing powerful Integrated Full–Text Search features in SQL Server such as the FREETEXT and CONTAINS predicates, custom thesauruses, and stop lists
• Showing you how to optimize full–text query performance through features like full–text indexes and iFilters
• Providing examples that help you understand and apply the power of Integrated Full–Text Search in your daily projects

What you’ll learn

• Harness the power of iFTS for your applications.
• Administer iFTS catalogs and indexes.
• Use new iFTS features such as stop lists and iFTS–based dynamic management functions.
• Optimize and tune iFTS queries.
• Implement language–aware, natural–language searches for data.
• Simplify searches of structured and unstructured content.

Who is this book for?

The audience for this book includes SQL Server SQL and Transact–SQL developers, and also .NET developers, who want to take advantage of the new Integrated Full–Text Search (iFTS) functionality available in SQL Server 2008.

About the Apress Pro Series

The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.

You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard–won solutions to problems you will face in your professional programming career.

如今，企業希望從數據中獲得可操作的洞察力，他們希望數據以自然且用戶友好的形式呈現給他們。有什麼比人類語言更自然的呢？自然語言搜索是一場風暴的中心，這場風暴是由不斷增長的基於網絡的人機通信和信息訪問需求所引起的。SQL Server 2008提供了利用其內置的企業級自然語言搜索引擎的功能的工具，即集成全文搜索（iFTS）。集成全文搜索使用文本感知的關聯查詢，為用戶提供快速訪問內容的能力。無論您是想建立企業級的互聯網或內部網搜索引擎，還是創建規模較小的自然語言搜索應用程序，本書將教您如何充分利用SQL Server 2008集成全文搜索的功能：

- 介紹SQL Server中強大的集成全文搜索功能，如FREETEXT和CONTAINS謂詞、自定義詞庫和停用詞列表
- 展示如何通過全文索引和iFilters等功能優化全文查詢性能
- 提供示例，幫助您理解並應用集成全文搜索的強大功能於日常項目中

您將學到什麼：

- 利用iFTS為您的應用程序提供強大的功能
- 管理iFTS目錄和索引
- 使用新的iFTS功能，如停用詞列表和基於iFTS的動態管理函數
- 優化和調整iFTS查詢
- 實現對數據的語言感知、自然語言搜索
- 簡化結構化和非結構化內容的搜索

本書適合的讀者群體包括SQL Server SQL和Transact-SQL開發人員，以及希望利用SQL Server 2008中提供的新的集成全文搜索（iFTS）功能的.NET開發人員。

關於Apress Pro系列：

Apress Pro系列書籍是實用的專業教程，可幫助您在職業生涯中不斷提升自己。

在這個競爭激烈的時代，您已經找到了工作，現在需要在這個艱難的競爭環境中磨練自己的技能。Apress Pro系列擴展了您在所需領域的技能和專業知識。掌握Pro系列書籍的內容，您將始終能夠在專業開發項目中完成工作。Apress Pro系列書籍由各自領域的專家撰寫，為您提供在職業編程生涯中所面臨的問題的寶貴解決方案。