4 ms·
I'm working on a project where we're in the process of storing de-normalized links for a recursive table relationship, so we can query from the top-level table
by Flemlord 19y ago
I'm working on a project where we're in the process of storing de-normalized links for a recursive table relationship, so we can query from the top-level table directly to the bottom-level table without worrying about the messy inbetween. One of the few non-speed reasons I've ever come across where denormzalization seems jutified.
- brlewis 19y agoMight want to check Joe Celko's Trees and Hierarchies in SQL to see if there's a normalized way to do what you want.
- Flemlord 19y agoThanks. I just overnighted it from Amazon. My coding partner wants to use recursive database queries to do this--I want to avoid it because it's slower, breaks our object model, and makes the application non-database-agnostic. (Currently, we're using NHibernate and can run on most major databases.)