Reputation
1,461
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
9 21
Newest
 Excavator
Impact
~94k people reached

Dec
10
awarded  Excavator
Sep
9
awarded  Yearling
Jan
9
awarded  Nice Answer
Nov
29
comment Why don't relational databases support returning information in a nested format?
@EamonNerbonne, yes, Date also says that it's more tolerable to support RVA's in result sets, and less tolerable in the relvars (i.e. persistent tables defined in your schema). FoundationDB is another vendor that provides an extension to SQL that expresses RVA's. They use it to combine multiple rows from a joined table into one RVA in a row of the result set. See foundationdb.com/layers/sql/SQL/dml/…
Nov
29
awarded  Good Answer
Nov
28
comment Why don't relational databases support returning information in a nested format?
@EamonNerbonne, symmetry of relational operations. For example, projection. If I SELECT some sub-attributes out of an RVA, how can I apply a reverse operation against the result set to reproduce the original hierarchy? I found page page 293 of Date's book is on Google Books, so you can see what he wrote: books.google.com/…
Sep
9
awarded  Yearling
May
19
comment Why don't relational databases support returning information in a nested format?
@EamonNerbonne, this is the only way relational operations can be symmetric.
Feb
26
awarded  Caucus
Feb
18
comment What are non-programming mistakes that a programmer should avoid?
@StephaneRolland, yes, I'm wearing the Smartglove right now.
Feb
18
awarded  Nice Answer
Sep
9
awarded  Yearling
Sep
10
awarded  Yearling
Aug
30
revised What is the (craziest, stupidest, silliest) thing a client/boss asked you to do?
added 9 characters in body
Aug
30
comment What is the (craziest, stupidest, silliest) thing a client/boss asked you to do?
And development of the module will complete 2012-12-31.
Aug
29
answered Multiple Joins or Simple Readable Database Calls
Aug
19
awarded  Nice Answer
Aug
4
comment What is the (craziest, stupidest, silliest) thing a client/boss asked you to do?
@NimChimpsky: Some of the client's "issues" were cases where they wanted the software to do something it was not designed to do, or when they made fat-finger mistakes (like misspelling SQL keywords). They reported these cases as "bugs".
Jul
17
awarded  Nice Answer
Jul
10
comment Completing a project successfully despite hostile management?
I didn't get that from the OP's description. "Heading toward a death march" could mean the project is just beginning, or that the project has been going on for a while but the pace is changing. But I agree with you that adding people to a new project is just fine. :-)