|
NORMA CTP version 4 released |
|
ORM2
|
By Scot Becker on
4/14/2006
|
|
|
|
Neumont ORM Architect (NORMA) for Visual Studio is a free, open source ORM tool now released as a "community technology preview". This release has a diagram editor that supports the new ORM2 notation to include mapping of the ORM schema to 4 RDBMSs (MS SQL Server 2005, DB2, Oracle, and PostgresSQL).
|
 |
|
|
More...
|
|
|
NORMA CTP version released |
|
ORM2
|
By Scot Becker on
2/26/2006
|
|
|
|
Neumont ORM Architect (NORMA) for Visual Studio is a free, open source ORM tool now released as a "community technology preview".
|
|
|
|
|
More...
|
|
|
|
|
Tree Implementations in SQL Server 2005 |
|
SQL Tips
|
By Scot Becker on
2/16/2006
|
|
|
|
Anthony Bloesch has an interesting post about the performance of 3 tree implementations in SQL Server 2005. I know this isn't ORM content per se, but trees come up so often in the real world that I thought I would post it.
|
|
|
|
|
More...
|
|
|
ORM2 Syntax Primer: Introduction |
|
ORM2
|
By Scot Becker on
2/15/2006
|
|
|
|
I've alluded to in the past that a new ORM notation is forthcoming called ORM2. The new ORM2 dialect is the subject of this post (as well as a few to come).
|
|
|
|
|
More...
|
|
|
Site Changes |
|
Site Announcements
|
By Scot Becker on
1/25/2006
|
|
|
|
In case you hadn’t noticed, I've made some changes. Cosmetically, it now has a spiffy (albeit derivative) new skin. Behind the scenes, there have been some code version changes. One result of this is a change to the RSS feed.
|
|
|
|
|
More...
|
|
|
|
|
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...
|
|
|