|
Pro Full-Text Search in SQL Server 2008 |  | Authors: Hilary Cotter, Michael Coles
Publisher: Apress
Category: Book
List Price: $49.99
Buy New: $0.97
as of 7/30/2010 03:47 CDT details
You Save: $49.02 (98%)
New (23) Used (17) from $0.97
Seller: best_bargain_books3
Rating:  3 reviews
Sales Rank: 562689
Media: Paperback
Edition: 1
Pages: 312
Number Of Items: 1
Shipping Weight (lbs): 1.3
Dimensions (in): 9.1 x 6.9 x 1
ISBN: 1430215941
Dewey Decimal Number: 005.7585
EAN: 9781430215943
ASIN: 1430215941
Publication Date: December 2, 2008
Availability: Usually ships in 1-2 business days
| |
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product 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). 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.
|
| Customer Reviews:
Detailed And Informative March 27, 2010
YisMan
great detail excelent samples. heeavy on theory AND practice. everything neesary for utiluzing fts. includes loads of best-practices
Pro Full-TextSearch in SQL Server 2008 September 14, 2009
Darcel Gibbs (St. Louis, MO)
0 out of 3 found this review helpful
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!
If you use iFTS, you need this book February 10, 2009
James A. Luetkehoelter (Wisconsin, USA)
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 :)
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2009, SQL Server 2008 Books. All Rights Reserved.
In association with Amazon.com | |
