VEA-2003_2005

P08 VEA 2003 Microsoft's ORM tool

admin — Fri, 23 Nov 2007 11:48:03 GMT

This is the eighth in a series of articles introducing the database modeling component of Microsoft Visual Studio .NET Enterprise Architect. Part 1 showed how to create a basic ORM source model, map it to a logical database model, and generate a DDL script for the database schema. Part 2 discussed the verbalizer, independent object types, objectified associations, and some other ORM constraints. Part 3 showed how to add set-comparison constraints (subset, equality and exclusion) and how exclusive-or constraints combine exclusion and disjunctive mandatory constraints. Part 4 discussed the basics of modeling and mapping subtypes. Part 5 discussed mapping subtypes to separate tables, and occurrence frequency constraints. Part 6 discussed ring constraints. Part 7 discussed indexes, constraint layers, and data types. Part 8 examines options for controlling how table, column, and other model element names are generated when mapping an ORM model to a relational model.

P07 VEA 2003 Microsoft's ORM tool

admin — Fri, 23 Nov 2007 11:46:03 GMT

This is the seventh in a series of articles introducing the Visio-based database modeling component of Microsoft Visual Studio .NET Enterprise Architect. Part 1 showed how to create a basic ORM source model, map it to a logical database model, and generate a DDL script for the physical database schema. Part 2 discussed how to use the verbalizer, make an object type independent, objectify an association, and add some other ORM constraints to an ORM model. Part 3 showed how to add setcomparison constraints (subset, equality and exclusion) and how exclusive-or constraints combine exclusion and disjunctive mandatory constraints. Part 4 discussed the basics of modeling and mapping subtypes. Part 5 discussed mapping subtypes to separate tables, and occurrence frequency constraints. Part 6 discussed ring constraints. Part 7 discusses index constraints, constraint layers, and data types.

P06 VEA 2003 Microsoft's ORM tool

admin — Fri, 23 Nov 2007 11:44:51 GMT

This is the sixth in a series of articles introducing the Visio-based database modeling component of Microsoft Visual Studio .NET Enterprise Architect. Part 1 showed how to create a basic ORM source model, map it to a logical database model, and generate a DDL script for the physical database schema. Part 2 discussed how to use the verbalizer, make an object type independent, objectify an association, and add some other ORM constraints to an ORM model. Part 3 showed how to add setcomparison constraints (subset, equality and exclusion) and how exclusive-or constraints combine exclusion and disjunctive mandatory constraints. Part 4 discussed the basics of modeling and mapping subtypes. Part 5 discussed mapping subtypes to separate tables, and occurrence frequency constraints. Part 6 discusses ring constraints.

P05 VEA 2003 Microsoft's ORM tool

admin — Fri, 23 Nov 2007 11:43:39 GMT

This is the fifth in a series of articles introducing the Visio-based database modeling component of Microsoft Visual Studio .NET Enterprise Architect. Part 1 discussed how to create a basic ORM source model, map it to a logical database model, and generate a DDL script for the physical database schema. Part 2 discussed how to use the verbalizer, mark an object type as independent, objectify an association, and add some other ORM constraints to an ORM source model. Part 3 showed how to add set-comparison constraints (subset, equality and exclusion) and how exclusive-or constraints are obtained by combining exclusion and disjunctive mandatory constraints. Part 4 discussed how to add basic subtyping details to an ORM model and map them to a database schema. Part 5 discusses mapping subtypes to separate tables, and occurrence frequency constraints

P04 VEA 2003 Microsoft's ORM tool

admin — Fri, 23 Nov 2007 11:33:20 GMT

This is the fourth in a series of articles introducing the Visio-based database modeling component of Microsoft Visual Studio .NET Enterprise Architect.

Part 1 discussed how to create a basic ORM source model, map it to a logical database model, and generate a DDL script for the physical database schema.

Part 2 discussed how to use the verbalizer, mark an object type as independent, objectify an association, and add some other ORM constraints to an ORM source model.

Part 3 showed how to add set-comparison constraints (subset, equality and exclusion) and how exclusive-or constraints are obtained by combining exclusion and disjunctive mandatory constraints.

Part 4 discusses how to add basic subtyping details to an ORM model and map them to a database schema.

P03 VEA 2003 Microsoft's ORM tool

admin — Fri, 23 Nov 2007 11:31:41 GMT

This is the third in a series of articles introducing the Visio-based database modeling component of Microsoft Visual Studio .NET Enterprise Architect.

Part 1 discussed how to create a basic ORM source model, map it to a logical database model, and generate a DDL script for the physical database schema.

Part 2 discussed how to use the verbalizer, mark an object type as independent, objectify an association, and add some other ORM constraints to an ORM source model.

Part 3 shows how to add set-comparison constraints (subset, equality and exclusion) and how exclusiveor constraints are obtained by combining exclusion and disjunctive mandatory constraints.

P02 VEA 2003 - Microsoft's ORM tool

admin — Fri, 23 Nov 2007 11:28:41 GMT

This is the second in a series of articles introducing the database modeling component of Microsoft Visual Studio Enterprise Architect.

Part 2 discusses how to use the verbalizer, mark an object type as independent, objectify an association, and add some other ORM constraints to an ORM source model.

Part 1 discussed how to create a new ORM source model, add sentence types, basic internal constraints and examples in the fact editor, drag fact types onto the drawing window from the business rules editor, and save the model. It also explained how to map an ORM model to a logical database model by creating a database model project, adding the ORM source model, and then building the logical model. Finally it showed how to generate the physical database model from the logical model by selecting the target DBMS and generating a DDL script.

P01 VEA 2003 Microsoft's ORM tool

admin — Fri, 23 Nov 2007 11:26:21 GMT

This is the first in a series of articles introducing the database modeling component of Microsoft Visual Studio for Enterprise Architects.

The initial emphasis is on the Object-Role Modeling (ORM) support provided by this tool.

Notes on VEA 2005

admin — Fri, 23 Nov 2007 11:22:24 GMT

VEA is Microsoft's ORM tool

This file contains notes on the availability of VEA 2005 and differences between VEA 2005 and VEA 2003