on 01-15-2016 12:12 PM
Why does hybris have data of all specialized types of users into user table only? What are the advantages of such a schema ?
Read up on Table per hierarchy vs Table per class e.g. http://blog.devart.com/table-per-type-vs-table-per-hierarchy-inheritance.html
BasicallyTPH = better performance but more redundant columns and no chance of data integrity rules in the db
TPC = worse performance (more joins) especially with large hierarchies but no redundant columns and possibility of enforcing data integrity in database
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.