Ask HN: What are some examples of good database schema designs?

Re:Ask HN: What are some examples of good database schema de... by Namoshek on Friday February 14, 2020 @03:47AM (#22325001)

I came to the same conclusion when I read that a basic SAP installation comes with over 20k tables. (see: https://retool.com/blog/erp-for-engineers/)

[ Parent | on HN ]

Re:Ask HN: What are some examples of good database schema de... by arethuza on Friday February 14, 2020 @04:58AM (#22325315)

A SAP partner once told me (the company I was working at was considering using SAP) that the deployment would have ~180K tables - I don't know if they got the figure wrong, I have misremembered (I did check when they said it) or maybe that's for a "fully loaded" instance.

Edit: Not SAP, but certain other ERP products have an alarming habit of not using foreign keys - which makes working out the structure of the database quite interesting...

[ Parent | on HN ]

Re:Ask HN: What are some examples of good database schema de... by AdrianB1 on Friday February 14, 2020 @01:47PM (#22329064)

It depends on the version and how many modules you have installed. In my company it was ~ 50k tables for R/3, so the order of magnitude is right.

[ Parent | on HN ]

Re:Ask HN: What are some examples of good database schema de... by gberger on Friday February 14, 2020 @05:13AM (#22325368)

How do you perform joins without foreign keys? Do you just have a column that is effectively a foreign key but is not marked as such?

[ Parent | on HN ]

Re:Ask HN: What are some examples of good database schema de... by dizaime on Friday February 14, 2020 @05:25AM (#22325414)

Sure it is. We can perform DB joins with any column as long as the data type and the data value is matched.

[ Parent | on HN ]