113 reputation
3
bio website cat5.com
location St Louis, MO
age 35
visits member for 1 year, 10 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
Feb
27
awarded  Scholar
Feb
27
accepted What's the best practice for representing set operations in a relational database?
Dec
22
awarded  Student
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!
Dec
21
asked What's the best practice for representing set operations in a relational database?
Dec
21
awarded  Autobiographer