ER Diagrams

How To Draw ER Diagram Using ChatGPT

Level Up Coding

In this story, you’ll be learning all about entity relationship diagrams or ERDs. we are going to start off by discussing a high-level overview. and then together we’ll dive in and build an example to...

Step-by-Step Design of Enhanced Entity-Relationship (EER) in MySQL

Towards AI

This article will give a clear understanding of the visual representation of tables that are related to each other. EER is a modeling interface in MySQL workbench. In this example, we will make three…...

Entity-Resolved Knowledge Graphs

Towards Data Science

New words. Old concepts. In the end, it’s about data fusion. Entity resolution is a process. A knowledge graph is a technical artifact. And the combination of the two yields one of the most powerful ...

ERD — how to save up to 80% of database refactoring and ERD for Medium

Python in Plain English

ERD — how to save up to 80% of database refactoring and practical example of ERD for Medium Changes in a database very often are painful. It can be just a small change of one field type or major data...

Practical Guide to Entity Resolution — part 1

Towards Data Science

Entity resolution (ER) is the process of creating systematic linkage between disparate data records that represent the same thing in reality, in the absence of a join key. For example, say you have a…...

Constructing the Hertzsprung-Russell Diagram

R-bloggers

Recreating the Hertzsprung-Russell Diagram in R For a few Fridays each year, I teach a course in the American Museum of Natural History’s Masters of Arts in Teaching program to apply and continue thin...

Diagram as Code

ByteByteGo Newsletter

1. Diagrams Turn python code into cloud system architecture diagrams Link: https://github.com/mingrammer/diagramsThanks for reading ByteByteGo Newsletter! Subscribe for free to receive new posts and s...

Exploring Electronic Health Records with MedCAT and Neo4j

Towards Data Science

Biomedical NER+L is concerned with extracting concepts from free text found in Electronic Health Records (EHRs) and linking them to large biomedical databases like SNOMED-CT and UMLS. In this post…

Practical Guide to Entity Resolution — part 3

Towards Data Science

In the context of ER, featurization means transforming existing columns into derived features that can inform whether disparate records refer to the same thing. Blocking means selecting a targeted…

What is an Entity-Relationship Diagram?

Better Programming

Programmers often have to deal with big databases. It doesn’t matter what kind of coding language we’re using, there will always be information that we need to store in the backend of our…

Integrating 🤗 Transformers with MedCAT for biomedical NER+L

Towards Data Science

Biomedical NER+L is concerned with extracting concepts from free text found in Electronic Health Records (EHRs) and linking them to large biomedical databases like SNOMED-CT and UMLS. The Medical…

MedCAT | Introduction — Analyzing Electronic Health Records

Towards Data Science

EHRs are a treasure trove of medical information; there is an unbelievable amount of knowledge contained in them. To mention a few data points usually available for each patient: (1) Diseases with…