113 reputation
3
bio website cat5.com
location St Louis, MO
age 34
visits member for 1 year, 3 months
seen Feb 28 '13 at 17:25

Senior Software Engineer, Cat5 Commerce St. Louis, MO


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!