New Zealand's new Copyright Law presumes 'Guilt Upon Accusation' and will Cut Off Internet Connections without a trial. is against this unjust law - help us

A Space for All Things .NET Related

Answering the Queries Your Users Really Want to Ask

By James Hippolite, in , posted: 6-Dec-2008 16:26

Answering the Queries Your Users Really Want to Ask  When querying a database, what do users want?
  1. They’re not sure
  2. They don’t want to be precise
  3. They do want to use their own terminology
  4. The want the answers fast
 What do we give them?
  1. Really limited choices
  2. Really strict terminology
 What we will cover
  • What can you do for me?
 Can’t we just use LIKE?
  • WHERE Description LIKE ‘%hockey%’
 Strings vs Words
  • Search for: Pen
  • Get Back: Pencil = fail
  • Or Open, pendulum, penis
  • AND
  • OR
  • (‘”exact match”’)
  • search for a sentence
  • with ranking
  • ISABOUT (with weighting)
 For true location of where to place your personalised thesaurus:  Upgrade Options
  • New Index Structure (the structure has been brought internal to the database engine)
  • Upgrade options:
    1. Import(default)
    2. Rebuild
    3. Reset
  • Possible Upgrade methods
    1. In place
    2. Restore/attach
 Potential Extensions
  • New data types
    1. XML data types
    2. CLR UDT
  • Extend the IFTS feature set
    1. snippets with hit-highlights
    2. field weighted relevance
    3. customizable tokenizing
    4. customizable proximity operator
    5. property level search
  • Be heard now!
  • IFTS can add significant value
  • Implementation -> straightforward
  • Management -> straightforward
  • Users love this
  • SQL Server 2008 has changed the game!

Other related posts:
GeekPost Weekly Newsletter Volume 4 Issue 7
MSDN Unplugged Roadshow Wellington
Right Sizing Agile Development - MSDN Magazine Webinar

Add a comment

Please note: comments that are inappropriate or promotional in nature will be deleted. E-mail addresses are not displayed, but you must enter a valid e-mail address to confirm your comments.

Are you a registered Geekzone user? Login to have the fields below automatically filled in for you and to enable links in comments. If you have (or qualify to have) a Geekzone Blog then your comment will be automatically confirmed and shown in this blog post.

Your name:

Your e-mail:

Your webpage:

JamesHip's profile

James Hippolite
New Zealand

Welcome to my technical blog. 

Here, I attempt to distill the Microsoft Certified Professional Developer knowledge I have accumulated since first qualifying MCP in 1996.  This blog started on 13 September 2007 as an off-shoot from my mixed up personal blog.  But it took a shot in the arm from Scott Hanselman's talk at TechEd New Zealand 08 "32 Ways To Make Your Blog Suck Less".