HN Explorer

Ask HN: Database Design Templates (or Best Practice Examples)

19 points by jmakaa ↗ HN
Is there any resource on the internet that shows templates or example of how to design database's for common business functions:

Such as: approvals, billing, user management, double-entry accounting, etc etc.

I realize that businesses and business processes are unique to individual businesses. But there are certain operations or functions that are done basically the same no matter what type of business you are running.

Thanks in advance.

10 comments

[ 4.5 ms ] story [ 32.6 ms ] thread
ddgflorida
Have a look at this one: http://www.databaseanswers.org/data_models/
twunde
That's quite a nifty resource
avitzurel
This is gold. Thanks for sharing
jmakaa
Looks like a really good resource. Thanks, I'll start with this. I wish there were more resources like this.
subrat_rout
Great info. This site has compiled a quite good numbers of database designs. Thank you.
brwr
I spend my time working on the client side of the browser. Can someone with more knowledge tell me how good these data models are? Are they good quality and worth studying?
LarryMade2
I think those are a nice start for some MVP system but any one probably would need more fleshing out, especially if you want to make a competitive product.

i.e. in a few of the library datanases, book identifcation using ISBN, ISBNs can change by revision also does not adequately handle tracking multiple copies. But I can see these can give you a glimpse of what datasets you will be concerning yourself with.

brudgers
What kind of database? Flat file, column store, graph, relational, document? Will it need to provide realtime information? Will it need to be distributed? Which is more important: consistency or availability?

My point being that "database design" is non-trivial to the point that "cut and paste" is at the application level not the schema level.

Good luck.

thorin
In terms of data warehousing-the data warehouse toolkit (kimball) book is an excellent resource. It covers models for many business areas and also talks about the transactional models the are coming from.