Menu

Post image 1
Post image 2
1 / 2
0

Practicing “Database Insights”: where to find real schemas?

DEV Community·Karlis·28 days ago
#LGZDpDP7
#ai#database#data#discuss#schemas#constraints
Reading 0:00
15s threshold

We talk a lot about “data-driven decisions”, but that usually hides three separate layers: Data itself (events, transactions, logs, etc.). Database structure (schemas, constraints, relationships). Insights on top (from SQL, AI copilots, BI tools, notebooks). My current interest is in that middle layer: using real-world database structures as a playground to practice database insights : Understanding and improving data quality (missing constraints, odd cardinalities, misuse of types). Suggesting schema improvements for future analytics (indexes, normalization vs denormalization, slowly changing dimensions, etc.). Making access easier via views, semantic layers, or documentation (ERDs, db docs, column descriptions). I’m looking for good open source repositories that contain: Non-trivial database schemas (preferably SQL migrations or DBML, not just ORM models). Some realistic sample data if possible (to check cardinalities, null patterns, etc.).…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.

Read More