Search by Algolia
Introducing new developer-friendly pricing
algolia

Introducing new developer-friendly pricing

Hey there, developers! At Algolia, we believe everyone should have the opportunity to bring a best-in-class search experience ...

Nick Vlku

VP of Product Growth

What is online visual merchandising?
e-commerce

What is online visual merchandising?

Eye-catching mannequins. Bright, colorful signage. Soothing interior design. Exquisite product displays. In short, amazing store merchandising. For shoppers in ...

Catherine Dee

Search and Discovery writer

Introducing the new Algolia no-code data connector platform
engineering

Introducing the new Algolia no-code data connector platform

Ingesting data should be easy, but all too often, it can be anything but. Data can come in many different ...

Keshia Rose

Staff Product Manager, Data Connectivity

Customer-centric site search trends
e-commerce

Customer-centric site search trends

Everyday there are new messages in the market about what technology to buy, how to position your company against the ...

Piyush Patel

Chief Strategic Business Development Officer

What is online retail merchandising? An introduction
e-commerce

What is online retail merchandising? An introduction

Done any shopping on an ecommerce website lately? If so, you know a smooth online shopper experience is not optional ...

Vincent Caruana

Sr. SEO Web Digital Marketing Manager

5 considerations for Black Friday 2023 readiness
e-commerce

5 considerations for Black Friday 2023 readiness

It’s hard to imagine having to think about Black Friday less than 4 months out from the previous one ...

Piyush Patel

Chief Strategic Business Development Officer

How to increase your sales and ROI with optimized ecommerce merchandising
e-commerce

How to increase your sales and ROI with optimized ecommerce merchandising

What happens if an online shopper arrives on your ecommerce site and: Your navigation provides no obvious or helpful direction ...

Catherine Dee

Search and Discovery writer

Mobile search UX best practices, part 3: Optimizing display of search results
ux

Mobile search UX best practices, part 3: Optimizing display of search results

In part 1 of this blog-post series, we looked at app interface design obstacles in the mobile search experience ...

Vincent Caruana

Sr. SEO Web Digital Marketing Manager

Mobile search UX best practices, part 2: Streamlining search functionality
ux

Mobile search UX best practices, part 2: Streamlining search functionality

In part 1 of this series on mobile UX design, we talked about how designing a successful search user experience ...

Vincent Caruana

Sr. SEO Web Digital Marketing Manager

Mobile search UX best practices, part 1: Understanding the challenges
ux

Mobile search UX best practices, part 1: Understanding the challenges

Welcome to our three-part series on creating winning search UX design for your mobile app! This post identifies developer ...

Vincent Caruana

Sr. SEO Web Digital Marketing Manager

Teaching English with Zapier and Algolia
engineering

Teaching English with Zapier and Algolia

National No Code Day falls on March 11th in the United States to encourage more people to build things online ...

Alita Leite da Silva

How AI search enables ecommerce companies to boost revenue and cut costs
ai

How AI search enables ecommerce companies to boost revenue and cut costs

Consulting powerhouse McKinsey is bullish on AI. Their forecasting estimates that AI could add around 16 percent to global GDP ...

Michelle Adams

Chief Revenue Officer at Algolia

What is digital product merchandising?
e-commerce

What is digital product merchandising?

How do you sell a product when your customers can’t assess it in person: pick it up, feel what ...

Catherine Dee

Search and Discovery writer

Scaling marketplace search with AI
ai

Scaling marketplace search with AI

It is clear that for online businesses and especially for Marketplaces, content discovery can be especially challenging due to the ...

Bharat Guruprakash

Chief Product Officer

The changing face of digital merchandising
e-commerce

The changing face of digital merchandising

This 2-part feature dives into the transformational journey made by digital merchandising to drive positive ecommerce experiences. Part 1 ...

Reshma Iyer

Director of Product Marketing, Ecommerce

What’s a convolutional neural network and how is it used for image recognition in search?
ai

What’s a convolutional neural network and how is it used for image recognition in search?

A social media user is shown snapshots of people he may know based on face-recognition technology and asked if ...

Catherine Dee

Search and Discovery writer

What’s organizational knowledge and how can you make it accessible to the right people?
product

What’s organizational knowledge and how can you make it accessible to the right people?

How’s your company’s organizational knowledge holding up? In other words, if an employee were to leave, would they ...

Catherine Dee

Search and Discovery writer

Adding trending recommendations to your existing e-commerce store
engineering

Adding trending recommendations to your existing e-commerce store

Recommendations can make or break an online shopping experience. In a world full of endless choices and infinite scrolling, recommendations ...

Ashley Huynh

Looking for something?

What is an entity relationship model/diagram and how can it strengthen your recommendations?

Sep 1st 2022 product

What is an entity relationship model/diagram and how can it strengthen your recommendations?
facebookfacebooklinkedinlinkedintwittertwittermailmail

Who’s buying which of your products? Which items are being combined in people’s shopping carts most often? How can you utilize recommendations — one of the main tools now being deployed to create the high-quality online experiences customers expect — to improve your sales?

Those are all great business-process questions. Fortunately, the answers to the first two can be wrangled with the help of entity relationship models (ERMs), also known as ER models, entity relationship diagrams (ERDs), and ER diagrams. These pictures, which look like flowcharts of different-shaped symbols connected by different styles of connecting lines, let you grasp the relationship types between your various data items, such as products, customers, and orders.

When you can do that effectively in database tables, you’re halfway there. Then you can then use an algorithm to provide accurate recommendations by predicting your customer preferences.

What is an entity relationship model?

In software engineering terms (thank you, Techopedia), an ERM is a “theoretical and conceptual way of showing data relationships in software development…a database modeling technique that generates an abstract diagram or visual representation of a system’s data that can be helpful in designing a relational database.”

An entity is a noun, a thing; for instance, a product. An entity-relationship diagram features category-associated symbols — rectangles, diamond shapes, and ovals, among others, plus lines that connect them (for example, indicating a many-to-many relationship), to illustrate the connections.

An ER diagram tool also often shows attributes for the entities, for example, age or ID number.

Identifying entities and their relationships, and knowing how and why they relate, is important for a variety of applications. For instance, if you have a retail website, you want to figure out how to show product recommendations that will help your shoppers get what they came for and turn into repeat customers.

The origin of the ERD diagram

Here’s a quick look at how entity relationship diagrams made their debut:

In the 1960s, American computer scientist and industrial researcher Charles Bachman came up with data-structure diagrams.

In the early 1970s, three types of data models for databases were being used, called network, relational, and entity set. The problem: none of them offered a complete view of a database. 

So in 1976, a computer scientist interested in improving existing database design, Peter Chen, came up with the concept of an ERD. He wanted to add clarity for the database terms being used to describe the entity relationships. His new model eliminated ambiguity and  unified the database modeling framework.

Chen’s model served as the foundation for Unified Modeling Language (UML).

In the 1980s, James Martin, also a computer scientist, refined Chen’s work and introduced IE notation, which uses crow’s-foot notation to show one-to-many relationships (cardinality).

More recently, entity relationship models have been utilized by AI pioneers. By mapping the relational data of entities, analysts and marketers can begin to see patterns and trends in user behavior that facilitate the prediction of user preferences and help produce the right recommendations.

Types of ERD models

There are three types of diagram when it comes to entity relationship models: conceptual, logical, and physical. Here’s how to tell the difference between these styles of data-flow diagrams:

  • A conceptual data model is the most abstract; it’s a generalization of what’s going on. 
  • A logical data model portrays data elements in detail and, through visuals, facilitates understanding of data relationships, entities, attributes, and keys.
  • A physical data model is detailed, identifying the primary keys and foreign keys of entities. This style is used as a blueprint or working design.

How does an entity relationship model help power recommendations?

So now you know the basics of entity relationship models. What’s probably more important to you, though, is knowing that when you can collect enough customer data and put together an effective relational model, you can generate nuggets of highly useful information. You can clearly see patterns documented in black-and-white diagrams, and you don’t have to guess at things like which items, such as potential add-ons at checkout or also-interesting news stories, your customers might love to know about.

The first step, gathering all that detailed data, should be relatively straightforward. Why? According to Accenture, the majority of customers are willing to give you their data, including their online activity, purchase history, likes, and dislikes, if it leads to better experiences for them. Of course it’s all about them. But who cares? When you get your hands on this invaluable information, you can then get ready to build yourself one powerful recommendation engine

So how do you transform people’s online meanderings and website-poking-around preferences into intelligent, intuitive recommendations that will delight and entice them? In other words, how can you unleash spot-on suggestions to improve your customers’ online experiences, increase your conversion and average cart value, and yata yata?

How AI recommendations work

Want to know how artificial-intelligence-based recommendations work so your organization can figure out how to effectively deploy the right setup?

OK, let’s say you have a movie-subscription website. That means your recommendation engine must decide which flicks your viewers could most enthusiastically want to devour next on their watch list. There are two ways for a recommendations engine to discern this kind of information: 

Content-based filtering: just movies

This approach takes a customer’s preferences (likes, dislikes, user activity) and, based on their movies, endeavors to make helpful recommendations.

Well, not any kind of recommendations, needed though they might be. If one of your customers is watching The Emoji Movie five or six times a week, for instance, you might think the recommendation engine would go out on a limb and suggest a therapist. No such personal advice functionality exists there (yet), but based on tags such as genre, subgenre, director, actor, and movie length, the software would at least be able to recommend other animated family movies, which could potentially break the addictive viewing streak and restore some couch-potato normalization.

Collaborative filtering: movies plus other people

This second type of smart recommendation takes into account the preferences not just of the viewer in question but of other users on your site. By making intelligent connections between what different people rate highly, the engine can offer up accurate recommendations to seemingly similar movie buffs. The movies’ content is still key in driving this method, but there’s a lot more going on behind the (movie) scenes, joining up the dots between what similar users in the community choose to watch next, what they like, and what they dislike. So based on various data points, someone who’s been engrossed in The Emoji Movie might next be nudged toward Despicable Me or Toy Story 4. 

For either of these methods to work, someone or something needs to make some pretty sophisticated connections between the data points being captured in large databases. Fortunately, our AI robot friends can do this in their sleep (or at least while we sleep), that is, if they have the requisite data.

So here we are back at good old entity relationship models — those information-systems tools whose comprehensive views of data make educated-guess recommendations possible. Whether the content-based or collaborative-filtering approach is best for your business, ERD can help you map out relationships between entities and alight on just the right recommendations. All it takes is the right tools.

How to provide A-rated recommendations

Because websites like Amazon are continually upping the ante, a stellar customer experience matters now more than ever. That means adding highly personalized, hit-the-mark recommendations to your website or app would likely be a win.

For this reason, Algolia Recommend enables fast, scalable product discovery through an enterprise-grade engine. You can use our proven API to unlock the full potential of user recommendations, including for:

  • Related products, which could be even better suited to what your customers wanted when they first landed on a page
  • Frequently bought together items: learning that real-world shoppers have shelled out for an item can make people feel justified in adding it to their carts, too
  • Related content they may find worth reading or engaging with, which keeps them on the site longer (always a good thing)

Want your programmers to provide the recommendation experiences your users would love? Learn more now about handling your data relationships and how our popular solution can deliver outstanding recommendations that drive higher conversion and revenue!

About the author
Catherine Dee

Search and Discovery writer

linkedin

Recommended Articles

Powered byAlgolia Algolia Recommend

What is a product recommender (or product recommendation engine)?
product

Catherine Dee

Search and Discovery writer

What are personalized recommendations and how can they boost engagement and conversion?
ux

Catherine Dee

Search and Discovery writer

Building recommendations for ecommerce & media, with & without AI
ai

Julia Seidman

Developer Educator