liveBook · Manning

Join

As explained in Machine Learning System Design

Data joining is the technique of combining records or collections from multiple data sources into a connected dataset.

Data joining combines records or collections from multiple sources into a connected dataset. It can enrich a raw or proprietary dataset with labels, public information, behavioral profiles, or another modality. section 6.1

Choose the joining pattern according to the data and the business goal:

  • Use a straightforward connection when datasets share comparable records, such as a SQL join between tables. section 6.1
  • Use multimodal joining when different kinds of information describe the same problem, such as product images combined with text descriptions. section 6.1
  • Check access and legality before combining data, especially when exchanges cross organizations or regions. section 6.1

Game publisher and ad network

A game publisher keeps its paying-customer list private, while a partner ad network holds detailed behavioral profiles. Joining the datasets can help target advertising toward users resembling paying players, creating value for both businesses. section 6.1

Figure 6.1 Combining data sources of two completely different businesses can eventually benefit both.
figure

Trace how two businesses combine distinct data sources to create a shared marketing opportunity. section 6.1

How Machine Learning System Design covers it

How deep it goes
Defines SQL-style, cross-business, and multimodal joining but stops short of implementation details.
Examples
Uses game-payer and ad-profile matching plus product images paired with text descriptions.
What you can do after
Apply it to enrich datasets and identify marketing opportunities from complementary information.
How it connects
Connects joining with annotation, SQL joins, multimodal datasets, data sources, and data exchanges.

Also explained in

Compare how 16 books explain join →

Related concepts

This explainer was generated by Manning's knowledge graph from the text of Machine Learning System Design. The section links point to the parts of the book it draws on.