RETURN TO BLOGS

Semantic Search: A Smarter Way to Explore Data

by Charlie Bailey - Technical Lead

Semantic searches understand context, not just keywords, so users find relevant info faster. Discover how this tool in Claris FileMaker boosts productivity, streamlines workflows, and enhances decision-making.

If you use any type of database to help run your business, you already know about a traditional database search; you type in a few keywords, hit enter, and get some results. Your results will typically include records that match the keywords or word fragments that you entered. This works great if (for example) you’re looking for a person named Charlie; you’d likely enter ‘charlie’ into a search field and get a set of records where the person’s name includes Charlie. You might get fancy and use some type of wildcard search like ‘charl*’ if you wanted to get all the Charlie, Charles, (and Charlene) records.

With a traditional search like this, you get what you ask for, and this can be an appropriate and powerful way to mine your database for information. With FileMaker, we get a great “Find Mode”, and even beginner users can perform powerful searches with this simple tool. And users that have truly mastered Find Mode can do seemingly magical things with their database.

Whether or not you’re already a wizard with Find Mode, semantic search gives you a whole new way to get meaningful information out of your database.

Ready to harness the full power of your data? Let’s dive in and discover how semantic search can reveal insights you didn’t even know were there.

What is Semantic Search?

Semantic search is an advanced search method that goes beyond matching exact keywords. It uses artificial intelligence and natural language processing to understand the context and intent behind a user’s search query, rather than just focusing on literal keywords.

This type of search delivers more accurate and relevant results by understanding the relationships between different words and phrases, relating query terms to concepts, and even considering user behaviors and trends. Essentially, semantic search understands what the user is really looking for, almost as if you were having a conversation with the search engine itself.

To bring this concept to life, here’s some practical semantic search examples and how they work compared to traditional search.

A Semantic Search Example

If this sounds a little abstract, let’s look at a specific example. Let’s say you’ve got a database of Airbnb reviews and you’re interested in finding a positively reviewed place in the Boston area that’s pet friendly. With a traditional search, you’d likely use structured fields like the city and state of the listing, the average customer rating, and perhaps a checkbox for “pet friendly”. You’d probably be able to get what you’re looking for pretty quickly, but it would be hard to go beyond the search options that the database already has in place.

Imagine you have severe allergies and were looking for a place where fellow allergy sufferers had a great experience? If you were able to talk to your database, you might say something like ”dog fur makes me sneeze and get watery eyes. Is there a place in the Boston area where I’d be comfortable?” This is where semantic search shines – you want listings that match the intent of your query, not necessarily the specific words used. We’ll be doing what’s called a vector search to find records where our query’s semantic meaning matches the semantic meaning of the content in the customer review. Wow!

Take this example database of ~10k hotel reviews. These reviews include structured data like the hotel name and address, the review’s numeric rating, as well as unstructured data, like the review itself. With structured data, like city and state, a FileMaker find is the way to go; we can search on `San Francisco` in the city field and `CA` in the state field and get a found set of records that’s predictably accurate. It’s trivial to perform a Find on these fields using Find Mode or a Quick Find, and that can be quick and efficient (truly, it’s one of FileMaker’s best features!). 

A Database of Hotel Reviews

But with unstructured text like the narrative comments we have for these reviews, that type of find may not get us what we need. Sure, we can probably find places that have a swimming pool by performing a find for ‘pool’ in the review field; but what we really want are places that have awesome water attractions for the kids. That’s where a semantic search is really what we’re looking for.

Now look at this next example where we’re searching in plain english and getting a set of records that match the intent of what we’re looking for. Note that the prompt is just written in natural language, not a set of key words or a bunch of complicated find requests. FileMaker’s new features make it just as easy to perform this kind of natural language search on the unstructured Review text as it is to find a city or state in their structured fields.

Semantic Search

So, what makes semantic search such a game-changer? Here’s why it stands out in the world of data retrieval

Why is this so Cool?

It’s no surprise that we are collecting data faster than we can get meaning from it. Much of this data is unstructured and often requires human intervention to pluck out the important bits. Think about our Airbnb review database; you have all these customer reviews with all sorts of great information locked away in this unstructured data, and that data is getting generated at an increasingly faster pace. We can certainly hire an army of workers (Amazon Mechanical Turk ?) to parse through these reviews and (for example) tag the reviews with a set of pre-defined key words or concepts to facilitate more accurate traditional searches. But that can be an overwhelming, time consuming, (and perhaps expensive) task that’s getting harder and harder to accomplish given the rate of new reviews arriving every day. You’ve probably got a similar situation with your CRM; maybe you’re logging all your email communication with customers (and if you’re not, you should be – hit me up, I have ideas!) and generating wonderful and lengthy narratives with your customers and potential customers. But what do you do with all this information?

Semantic search just might be the hook that you need to extract insight from this type of unstructured data. And with FileMaker’s new semantic search tools, it’s easy to find the right information using just a natural language prompt.

Now, let’s look at how Claris FileMaker leverages semantic search technology to make data management even more powerful.

How Does Semantic Search Work in FileMaker?

Claris FileMaker’s semantic search streamlines data searches, allowing for natural data interaction, faster insights, and optimized workflows. It uses beyond traditional keyword searches, interpreting the meaning and intent behind user queries.

Here’s how it works:

  1. Data Embeddings: Claris FileMaker uses data embeddings to capture meaning. This process converts information into “vectors” or numerical patterns, enabling it to recognize relationships between terms. As a result, even if you use varied wording, the search results remain relevant, making it quicker and easier to find critical information.
  2. Retrieval-Augmented Generation (RAG): for deeper insights, Claris FileMaker employs Retrieval-Augmented Generation (RAG), which merges semantic search with AI-driven technology to create summaries or generate insights from your data. It efficiently transforms raw information into actionable insights, making data interaction more intuitive.

Beyond Database Fields

With a little work, you can go beyond the unstructured data that’s just in your database’s text fields. This technique can be adapted to search content from a library of PDF manuals, conversations from video or phone calls, or any other kind of unstructured data that your business generates every day. Using AI tools like ChatGPT can help you open up brand new ways to explore and leverage your existing data.

Benefits of Semantic Search for Businesses

To sum up, for businesses that want to enhance decision-making and unlock new insights from their data, semantic search is crucial, because it:

  1. Reduces the time spent sifting through large datasets.
  2. Delivers more precise results, eliminating irrelevant data.
  3. Explores information in other unstructured content, like PDFs, audio transcriptions, or emails.
  4. Processes and analyzes unstructured data, revealing insights that traditional searches might overlook.
  5. Reduces the need for manual data tagging or hiring additional resources to analyze vast datasets.

Start Using Semantic Search and Improve Processes Right Now

Semantic search offers businesses a smarter way to access and interpret their data. By understanding search context and intent, it reduces time spent hunting for information, boosting efficiency and decision-making across departments.

As one of the best semantic search software options for businesses, Claris FileMaker, makes finding data insights fast and intuitive.

Ready to see how semantic search and Claris FileMaker can transform your workflows?

Reach out to Codence’s specialists to learn more about how these tools can support your business. Discover new ways to manage your data.

What ideas do you have? Give us a shout and let us know!

Susbcribe to get the latest in your inbox.

This field is for validation purposes and should be left unchanged.

Comments

  1. Robert Jackson
    2 months ago

    No link for download on any of the templates?

    Reply
    • Danielle Borges
      4 weeks ago

      Sorry Robert. Not for this one yet.

      Reply

Leave a comment

Your email address will not be published. Required fields are marked *

Your email address will not be published. Required fields are marked *

Built with you in mind

Speak to one of our expert consultants about making sense of your data today. During
this free consultation, we'll address your questions, learn more about your business, and
make some immediate recommendations.

REQUEST A TOUR GET A FREE CONSULTATION

Stay in touch!

This field is for validation purposes and should be left unchanged.