Pro Full-Text Search in SQL Server 2008

Hilary Cotter

312 pages

Ajouter à une liste

Indisponible

Résumé

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). iFTS 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 iFTS:

Introducing powerful iFTS 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 iFTS 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 this book is 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 integrated full-text search (iFTS) functionality available in SQL Server 2008.