(this is a repost from here)
I'm working on a relational data model in which I'd like to store boolean expressions. I'm a little rusty so I'm humbly asking for a little push.
For example, let's say I have the following boolean expression:
((A = 8 OR A >= 9) AND B < 3) OR NOT (A <> 8 AND B = 0)
What would be a simple, elegant data model to store this kind (or any kind) of expression? Also important, how would you query the database in order to rebuild the logical expression from the stored data?
BTW, any kind of help would be appreciated. Reference to books, papers, web sites are perfectly ok.