network profile
|
Feb 27 |
comment |
What's the best practice for representing set operations in a relational database? The approach we ended up trying was a more complicated version of this that allowed us to represent nested (parenthetical) expressions using table relationships. In the end though, it was too slow and we resorted to programmatically creating a new view for every set which gave us the desired performance and kept everything simple |
|
Dec 21 |
comment |
What's the best practice for representing set operations in a relational database? To be clear, I know how to perform all of the necessary set operations using SQL, what I need is a way to store these operations as metadata related to each set and then use that metadata to perform the correct set operations at runtime. Each set will be constructed using a different set of operators, so I need something akin to an expression tree or little languge in SQL. Thanks! |
