Data Cardinality Is Ambiguous: a Primer on the Meaning of Information

Data Modeling and Data Cardinality

An example of one-to-one data cardinality, where each individual letter in column I corresponds to a unique number in column II. In this kind of relationship, it can be said that the data cardinality is high on either column.
An example of one-to-many data cardinality, where a single letter in column I corresponds to multiple numbers in column II. This data model is normally used for elements such as product categories, where one category is reused for multiple products (e.g. headphones, speaker, laptop).
An example of many-to-one data cardinality, where different letters in column I correspond to the same number in column II. While one-to-many can be used to assign a product category, many-to-one can be used to assign multiple invoices to products, as in many invoices may refer to the same product.

Data in Databases

In this example, the count of data cardinality is five, since there are five unique entries. If we add another E to the data set though, the number of items grows to six, while the data cardinality stays at five.

Data and Application Monitoring

High Cardinality Data

Medium Cardinality Data

Low Cardinality Data

--

--

--

This site contains both personal blogs as well as technical professional blogs that are copy/pasted from other sites in order to maintain a portfolio

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

How to measure success in data journalism and other tips from experts at the Data Journalism…

Extensive Developer Road Maps for All

Case Study on Big Data Architecture Design Using Spark, Hadoop, NoSQL

Assessment of Impact: Introduction

Product Analytics Data Scientist Interview Questions

Product Analytics Interview Questions

The Last Mile

Data Science Techniques: How extreme is your data point?

Are you AI ready? — Learn how to manage the End-to-End Life-cycle for your AI

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Christopher Lentricchia

Christopher Lentricchia

This site contains both personal blogs as well as technical professional blogs that are copy/pasted from other sites in order to maintain a portfolio

More from Medium

Project Sage 4.0: Alternative Finance Trends in Gender Lens Funds and Why They Matter

How Tech Regulation Bills in Congress Could Negatively Impact Communities of Color

Machine Shop and Modern Machine Shop — How is it different?

Modern Machine Shop

How gambling sweepstakes helped a company retain audience engagement and increase ad revenue