Natural-language search is at the center of a storm of ever-increasing web-driven demand for human-computer communication & 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 & CONTAINS predicates, custom thesauruses, and stop lists; Showing you how to optimize full-text query performance through features like full-text indexes & iFilters; Providing examples that help you understand & 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 & 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.