Design better databases

Post by zo1 » Thu, Apr 07, 2016, 6:03 PM UTC

astazangasta wrote: post #5

koolba wrote: post #3

More of an ER modeler than a database designer. The interface is pretty slick/simple. Here's a sample I just cooked up: http://dbpatterns.com/documents/570699101514b428de8893a1 I can't imagine using it for anything real but it was fun to play with. If the creator is reading this, here's a bug report: If the user hasn't hit "Save" when they export the schema, they get an empty text file and they'll think the app is br…

I found the interface very off-putting. If this is a site about exploring data models, a "public feed" and "search" is not a great way to interact with those. In fact, a timeline chronology of when these things were made seems a great way to expose mostly irrelevant information to a large number of users. How do I browse these models? Is there a taxonomy of organization? How many models are in the system? Are there m…

Post by sakopov » Thu, Apr 07, 2016, 6:12 PM UTC

clay_to_n wrote: post #6

It's an old-looking website, but I've found this site has some really cool data models: http://www.databaseanswers.org/data_models/index.htm As someone in the healthcare space, looking at some of these models gives me a better idea of how various aspects of the healthcare industry work, and the things they interact with. Ex) http://www.databaseanswers.org/data_models/patient_data_ware...

Post by r0m4n0 » Thu, Apr 07, 2016, 6:13 PM UTC

klodolph wrote: post #12

I just clicked on the second "featured" pattern and found this hot mess: http://dbpatterns.com/documents/5091f74289cbad03bc958bc0/ It has the "let's put a UUID on every row" disease common to designers who have never really learned anything other than object oriented design. Price is a string (I guess so you can put "market price" on the fish?), and there's a currency symbol on every "delivery". The whole thing just…

Post by skrebbel » Thu, Apr 07, 2016, 6:29 PM UTC

klodolph wrote: post #12

I just clicked on the second "featured" pattern and found this hot mess: http://dbpatterns.com/documents/5091f74289cbad03bc958bc0/ It has the "let's put a UUID on every row" disease common to designers who have never really learned anything other than object oriented design. Price is a string (I guess so you can put "market price" on the fish?), and there's a currency symbol on every "delivery". The whole thing just…

Post by jdc0589 » Thu, Apr 07, 2016, 6:42 PM UTC