|
|
Layers in VEA |
|
Visio Tool Tips
|
By Scot Becker on
5/4/2005
|
|
|
|
Visio has a generic layer facility that allows you to place shapes on one or more layers. A user can then specify settings for a given layer that dictate some behavior for all shapes on that layer.
|
 |
|
|
More...
|
|
|
|
|
New Site Coming Soon! |
|
Site Announcements
|
By Scot Becker on
3/23/2005
|
|
|
|
Just a quick note to let everyone know that I am in the process of re-vamping objectrolemodeling.com to include more (interactive) content, a different underlying framework, and switching ISPs.
|
|
|
|
|
More...
|
|
|
ORM Webcast |
|
News
|
By Scot Becker on
12/29/2004
|
|
|
|
SearchDatabase.com has a webcast featuring Terry Halpin titled "Fact-based Database Design".
|
|
|
|
|
More...
|
|
|
|
|
Nested Role Readings |
|
Visio Tool Tips
|
By Scot Becker on
11/3/2004
|
|
|
|
You may have noticed than when an object type is the result of a nested predicate, you can specify extra information on the "Nested Roles" tab of the "Database Properties" window. This is provided in case you wish to add extra semantics between the relationship of the nested object type and the object types that make up the fact type that was nested.
|
|
|
|
|
More...
|
|
|
User Defined Types and ORM |
|
Visio Tool Tips
|
By Scot Becker on
11/2/2004
|
|
|
|
User defined types are typically used to express semantic domains that cross multiple attributes. For example, one could create a type named "Phone Number" as some sort of length-limited character type and then use that type as the basis for several attributes such as fax number, mobile number, office number, home number, and so on.
|
|
|
|
|
More...
|
|
|
Visio FAQ: Ordering columns in index creation |
|
Visio FAQ
|
By Scot Becker on
10/22/2004
|
|
|
|
In some DBMS’s, the order in which columns appear in the creation/definition of an index (which spans multiple columns) can have performance impacts. Should you be saddled with such a silly restriction, you might be wondering how to specify the column order within Visio.
|
|
|
|
|
More...
|
|
|
|
N-ary fact verbalizations |
|
Visio Tool Tips
|
By Scot Becker on
10/20/2004
|
|
|
|
For any given fact type, there are n! (read: n factorial) readings of that fact type (where n is the number of roles in the fact type). In a unary fact type, there is exactly one reading, in a binary there are two readings, in a ternary there are six readings (3 x 2 x 1), in a quaternary there are 24 readings (4 x 3 x 2 x 1), and so on.
|
|
|
|
|
More...
|
|
|
|
|
Using Namespaces in ORM Source Models |
|
Visio Tool Tips
|
By Scot Becker on
10/14/2004
|
|
|
|
Many object types have similar (usually, descriptive) properties. For example, People, Animals, Products, and so on, all have names. This poses a choice for the ORM Modeler: do you create one "Name" object type or multiple?
|
|
|
|
|
More...
|
|
|
|
|
|