Minimal Modeling
Subscribe
Sign in
Home
Archive
About
Currencies, countries, and languages: the well-known anchors
I’d like to talk a little bit about how currencies, countries and languages are treated in databases, and also show how they could be represented in…
Sep 21
•
Alexey Makhotkin
Share this post
Currencies, countries, and languages: the well-known anchors
minimalmodeling.substack.com
Copy link
Facebook
Email
Notes
Other
New
Top
Community
The scope of the data modeling book
Here is the outline I have so far: basic logical model; either/or/or data; polymorphic data; template repetitions; basic physical model; secondary data.
Sep 7
•
Alexey Makhotkin
1
Share this post
The scope of the data modeling book
minimalmodeling.substack.com
Copy link
Facebook
Email
Notes
Other
Links and composite keys
Composite primary key is one concept from the relational model that could confuse during modeling. We discuss why primary keys should be handled…
Aug 9
•
Alexey Makhotkin
Share this post
Links and composite keys
minimalmodeling.substack.com
Copy link
Facebook
Email
Notes
Other
Database Modeling book — beta readers wanted
I'm looking for some early beta readers of my book on database modeling for beginners. The goal of this book is to take you from a vague idea of what…
Jul 31
•
Alexey Makhotkin
Share this post
Database Modeling book — beta readers wanted
minimalmodeling.substack.com
Copy link
Facebook
Email
Notes
Other
More on false links
We describe a confusing pattern in that is often encountered: a) three anchors linked to the fourth anchor as ⪫, together with the false link that…
Jul 24
•
Alexey Makhotkin
Share this post
More on false links
minimalmodeling.substack.com
Copy link
Facebook
Email
Notes
Other
Why Minimal Modeling has no 3-way links
We discuss the minimal model of “User buys an Item as a gift to another User” scenario; point out false links; try to make another step towards…
Jul 11
•
Alexey Makhotkin
Share this post
Why Minimal Modeling has no 3-way links
minimalmodeling.substack.com
Copy link
Facebook
Email
Notes
Other
How to discover all the data sources, low-fuss way
Sometimes you need to understand the databases and data sources that your company uses. You can use a small spreadsheet for that, with just half a dozen…
May 23
•
Alexey Makhotkin
Share this post
How to discover all the data sources, low-fuss way
minimalmodeling.substack.com
Copy link
Facebook
Email
Notes
Other
(3/3) "Relational Database Management: A Status Report" [Chris Date, 1983]
Rewatching Chris Date's talk from 1983 today. Pt. III. Possible future developments.
May 12
•
Alexey Makhotkin
1
Share this post
(3/3) "Relational Database Management: A Status Report" [Chris Date, 1983]
minimalmodeling.substack.com
Copy link
Facebook
Email
Notes
Other
See all
Minimal Modeling
Making sense of your database.
Subscribe
Recommendations
zverok on lucid code and open data
Victor Shepelev aka zverok
Minimal Modeling
Subscribe
About
Archive
Recommendations
Sitemap
Share this publication
Minimal Modeling
minimalmodeling.substack.com
Copy link
Facebook
Email
Notes
Other
Minimal Modeling
Making sense of your database.
By Alexey Makhotkin
· Launched 3 years ago
Subscribe
No thanks
By registering you agree to Substack's
Terms of Service
, our
Privacy Policy
, and our
Information Collection Notice
This site requires JavaScript to run correctly. Please
turn on JavaScript
or unblock scripts