|
SQL Hack or SQL Trick? |
|
SQL Tips
|
By Scot Becker on
12/3/2003
|
|
|
|
A while ago, I needed a function that returned a concatenated string of the values found in multiple rows of a SQL table.
|
 |
|
|
More...
|
|
|
|
|
|
|
|
|
|
|
More Nesting Schema Transformations |
|
ORM Primers
|
By Scot Becker on
10/20/2003
|
|
|
|
Sometimes you may not always spot a fact type that is a candidate for nesting/co-referencing and will instead model it as a ternary or higher arity fact type (the relationship between these schema patterns is covered here). As you add facts, you may notice that some groupings of facts have similar patterns with their related object types.
|
|
|
|
|
More...
|
|
|
|
Adding Temporal Facts to an ORM Schema |
|
ORM Primers
|
By Scot Becker on
10/11/2003
|
|
|
|
It is occasionally a system requirement to allow for the recording of history about a particular fact. Borrowing a bit from a newsgroup post I recently answered, I'd like to talk a bit about adding temporal facts to an ORM schema.
|
|
|
|
|
More...
|
|
|
|
|
Adjusting predicate text in VEA |
|
Visio Tool Tips
|
By Scot Becker on
9/30/2003
|
|
|
|
In Visio for Enterprise Architects, predicate orientation (e.g. reverse roles, flip orientation) is controlled by the Visio shape rotation options found in the "Shape | Rotate or Flip" menu options; you merely highlight the predicate shape as select the desired option.
|
|
|
|
|
More...
|
|
|
|
|