Tuesday 21 June 2011

Searching words of wisdom

I’m currently working on a project that includes a lot of text as part of the data.

Traditionally computer systems and databases don’t like free text; they prefer values that can be added, evaluated and easily stored. Of course there is much to be said for that; assigning a value enables us to clarify our thoughts and opinions. But we can’t communicate everything with numbers and capturing free text provides a great deal of rich understanding. It also enables us to store information which may not be considered relevant right now, but could be valuable in the future or to other people.

Happily, searching text has become a great deal more sophisticated than when I first started working with business systems. Databases such as Microsoft’s SQL Server now have the ability to search for meaning as well as words, to rank search results in terms of likely relevance, and to filter out the “joining words” that don’t add anything to the search process.

When we search for things on the internet we use the same functionality. We expect to key in a search term and find relevant information from a variety of sources. We rarely stop to consider the software technology that is behind making it happen, even though it is hugely powerful and is the piece of the jigsaw that makes all the internet information useful.

Our electronic world has made it so quick and simple to send an email to anywhere in the world, so a huge amount of information is being conveyed in free text. Documents can easily be created and stored on the billions of PCs in businesses everywhere - the issue now is to make the information accessible to the people who need it.

26 comments:

  1. Access is one thing, but successful navigation is quite another... and this depends on using the appropriate type of filter. And/or in a search reveal very different results.

    ReplyDelete
  2. Bedbugprocpc.com offers Bed Bug Exterminator, Bed Bug Inspections, Bed Bug Elimination, Bed Bug Inspection for Hotels and Residential and Commercial Bed Bug at Palo Alto CA, San Mateo CA, San Jose CA, Belmont CA, San francisco CA, Redwood City CA, Sunnyvale CA

    ReplyDelete
  3. Nyallpurposepaving.com offers Paving Contractor, Parking Lot Repairs, sealing, striping, Oil and Stone Driveways at Riverhead NY, Quogue NY, Hamptons NY, Southampton NY, Sag Harbor NY, Green point NY, Wading River NY, East Moriches NY, Center Moriches NY, Mannorville NY, Miller Place NY , Mt. Sinai NY,Greenport NY

    ReplyDelete
  4. Complete pest control specializing in Rodents & Rodent Proofing, has 40 years of experience in dealing with nuisance pests such as skunks, possums and raccoons. Our business is based on honesty, integrity and reliability, so you can count on us to solve all your wildlife problems. 650-839-9999, 408-246-0492, 415-818-6301

    ReplyDelete
  5. "Davispestmanagement.com offers Pest Control, Exterminator, Bed Bug Removal, Inspections, Rodent, Pest Elimination, Commercial, Residential, Professional, Licensed Exterminator , Scorpion, Bee Hive, Hornet, Fire Ant Removal by Service Area, Las Vegas NV

    ReplyDelete
  6. Davispestmanagement.com offers Pest Control, Exterminator, Bed Bug Removal, Inspections, Rodent, Pest Elimination, Commercial, Residential, Professional, Licensed Exterminator , Scorpion, Bee Hive, Hornet, Fire Ant Removal by Service Area, Las Vegas NV

    ReplyDelete
  7. Atopcommercialpaving.com offers Commercial Paving, Asphalt Contractor, and Parking Lot Resurfacing at Queens NY, Nassau County, Bayside NY, Jamaica NY, Middle Village NY, Ozone Park NY, Howard Beach NY, Little Neck NY

    ReplyDelete
  8. Jettonsgrading.com offers Grading, Excavation and Paving Contractor, Land Clearing Services, Septic Systems, Retaining Walls and Driveways, Drainage Systems, Construction Site Clean-Up, Demolition Contractor at Walhalla SC, Seneca SC"/>

    ReplyDelete
  9. Viceroy Investigations and Consulting LLC is a member of the Chamber of Commerce of the Massapequa's offer security consulting, assessments and training to large and small businesses. Let us help you design and implement policies that aid in Safe hiring, Work Place security and Information Security. Call us: 516-694-0093" />

    ReplyDelete
  10. Diskdatadestruction.net offers Mobile paper shredding, Mobile hard drive destruction at Hauppauge NY, Suffolk County NY, Long Island NY, Ronkonkoma NY, Melville NY, Huntington NY, Garden City NY, Farmingdale NY, Westbury NY, Bohemia NY, Stony Brook NY, Nassau County NY"/>

    ReplyDelete
  11. reliablecommercialpaving.com offers Parking lot paving, walk way construction, Commercial paving, asphalt, Parking Lot Repairs, Parking Lot Striping, Commercial Blacktop, Parking Lot Repairs, Commercial Paving Contractor, Commercial Asphalt Contractor at New Jersey at Hanover NJ, East Orange NJ, Newark NJ, Morristown NJ, Summit NJ , Union NJ, Hackensack NJ, Patterson NJ

    ReplyDelete
  12. Landscape , Outdoor, Landscape Lighting Installation, Lawn Sprinkler Design, Repairs, Installation, Lawn Irrigation Service, Sprinkler System Backflow Testing at Long Island, Nassau County, Suffolk County, Dix Hills NY, Huntington NY, Syosset NY, Smithtown NY and Happauge NY"/>

    ReplyDelete
  13. johnnyontheshop.com offers Supermarket, Food , Costco ,Home depot , Supermarket home , groceries home , home delivery for seniors, shopping for seniors, Elder services, Senior services, BJS Home Delivery, Prescription Drug Delivery, Department Store Delivery, Fry’s Food Delivery, Lowes home Delivery Service at Scottsdale AZ

    ReplyDelete
  14. The Center for Body Wellness offers Massage and CBD Massage at Rochester NY. Call us now: 585-266-6730

    ReplyDelete
  15. Yankeeclippersbarbershop.com offers Barbershop, Men’s Haircuts, Straight razor cuts, Neck shave, Trendy haircuts, Barber, Straight Razor shaves at Augusta GA. Call us now: 706.496.3342

    ReplyDelete
  16. HandRails | Security Cages | Steel Coating | Custom Ironwork | Welding at Tucson AZ

    ReplyDelete
  17. Realestatebydavidschoelles.com offers David Schoelles Real Estate, Cash for Homes at Arizona, Scottsdale AZ, and Phoenix AZ

    ReplyDelete
  18. johnniescarwashonoak.com offer Best Car Wash on Long Island, Detailing Centre, Car Detailing, Brushless Car Wash, Full-Service Car Wash, Car Detailing, SUV Detailing, Best Car Wash, Auto Detailing, SUV Detailing, Lease Return Detailing at Copiague NY, Lindenhurst NY, Amityville NY

    ReplyDelete
  19. David Schoeless Plumbing, David Schoeless at AZ, Scottsdale AZ, Phoenix AZ

    ReplyDelete
  20. davidschoelles.net offersDavid Schoeless Plumbing, David Schoeless at AZ, Scottsdale AZ, Phoenix AZ

    ReplyDelete
  21. Carpet, upholstery cleaning, carpet stain, odor removal, carpet steam, ceramic tile, commercial carpet cleaning at mobile al

    ReplyDelete
  22. jgamblefloors.com offers Wood Floor refinishing, Installation, Oak Floor Refinishing, Staining, Flooring Contractor, Wood Floor Sanding, Residential Wood Flooring in Norwalk CT

    ReplyDelete
  23. norwalkfloorsanding.com offers Wood Floor refinishing, Installation, Oak Floor Refinishing, Staining, Flooring Contractor, Wood Floor Sanding, Residential Wood Flooring in Norwalk CT

    ReplyDelete
  24. Kitchen cabinets and Kitchen cabinet supplier, remodeling, countertops, New Kitchen Cabinets, Wood Kitchen Cabinets

    ReplyDelete
  25. Fleet Tire Repair Service, Mobile Truck Tire repair, Fleet Roadside Assistance and Mobile flat Truck Tire repair at Queens NY

    ReplyDelete