| | |  | Software Engineering | Home » » » Pro Full-Text Search in SQL Server 2008 (Expert's Voice in SQL Server) | | | | | | | Product Promotions: | | | | | Description: | | 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. | | | Features: | |
• ISBN13: 9781430215943
• Condition: New
• Notes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!
| | | Product Details: | | | Author:
| Hilary Cotter | | Paperback:
| 312 pages | | Publisher:
| Apress | | Publication Date:
| December 02, 2008 | | Language:
| English | | ISBN:
| 1430215941 | | Product Length:
| 9.31 inches | | Product Width:
| 6.99 inches | | Product Height:
| 0.76 inches | | Product Weight:
| 1.33 pounds | | Package Length:
| 9.1 inches | | Package Width:
| 6.9 inches | | Package Height:
| 1.0 inches | | Package Weight:
| 1.3 pounds | | Average Customer Rating:
|  based on 3 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 3 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
2 of 2 found the following review helpful:
If you use iFTS, you need this bookFeb 10, 2009
By James A. Luetkehoelter
Those of you that know me know that I don't endorse anything lightly. MVP Michael Coles sent me a number of his books in exchange for mine (still coming Michael), and I just finished perusing the first one on my list: Pro Full-Text Search in SQL Server 2008. I highly endorse this book to anyone jumping into the Full-Text arena - and my hope is that more and more are, it is a great technology. Michael and Hilary Cotter (who contributed, not sure where, but it matters not) did a fine job with it. Make no mistake, this is a difficult topic to tackle and a complicated feature in SQL Server 2008. Even if you have worked with Full-Text Search in 2005, there's a lot to learn since it changes dramatically in SQL Server 2008. It's well written, organized and very detailed. Will it tell you everything you need to know about Full-Text Search - of course not. But it covers quite a bit.
This is not a book for a novice. The first few chapters focus on the basics of administration, but the book quickly moves into some fairly complicated ways in which the technology may be used. One of my favorite sections is a discussion on multilingual databases. This is an extremely important chapter - if you don't work with multilingual data yet, trust me, you will. Even for languages with a Latin character set can create confusion for Full-Text Search if it isn't aware of how the language uses accent marks. For example, in French there is the accent a gu (or aigu) - é and the accent grave - è. There can be words that are very similar in spelling, but use different accents. How does FTS know how to decide what matches? And those same accent symbols in Spanish may have completely different rules. Now through in languages like Arabic (reverse order) and Chinese, and the ability to truly match words and phrases can be very difficult. This book shows how this can be accomplished with real examples.
More practical examples follow showing how to full-text-index blob data, blogs, create custom thesauri, etc. It even covers the dynamic management views for Full-Text Search. I highly recommend this book, which I don't say often about anything :)
1 of 1 found the following review helpful:
Detailed And InformativeMar 27, 2010
By YisMan
great detail excelent samples. heeavy on theory AND practice. everything neesary for utiluzing fts. includes loads of best-practices
0 of 6 found the following review helpful:
Pro Full-TextSearch in SQL Server 2008Sep 14, 2009
By Darcel Gibbs
Delivery was quick. The book arrived as stated in the description new and clean. The material is helpful in my present job position. Great buy!
| | |
|
