Database Views with Data Modeling and SQL DDL

[JLove]

Support for the UML Data Modeling Profile is excellent!

I need to model a View (synchronized to linked Tables / Fields) and be able to generate SQL DDL for the View.  Currently, it's possible to create a View (virtual Table) manually with a stereotyped class for the View and dependencies to linked Tables.  However, this requires manually creating the View and fields (which are usually the same as the fields from the dependency Tables), manually creating the SQL DDL and manually synchronizing the View with the dependency Tables and the SQL DDL if any changes are made.

It sure would be nice if the Data Modeling in EA supported Views natively with SQL DLL generation, etc.  Are there any plans for this feature?

[hd]

 

It sure would be nice if the Data Modeling in EA supported Views natively with SQL DLL generation, etc.  Are there any plans for this feature?

Yes - but I don't have an ETA.

[JLove]

It's been six months, any ETA on support for Database Views yet?

[hd]

No ETA yet  

[terje]

Hi !  What's happening with sql views now ?  Will it come in EA at all ?

[markuskhouri]

This forum

http://www.sparxsystems.com.au/cgi-bin/yabb/YaBB.pl?board=general;action=display;num=1139611113;start=0#0

with subject "database engineering -- views" has a comment dated "Feb 12th, 2006, 1:22pm" that indicates views should be added in 6 months.

[hd]

Datamodelling view support for SQL Server, Oracle and Sybase ASE will be available in version 6.5.

[dserodio]

Datamodelling view support for SQL Server, Oracle and Sybase ASE will be available in version 6.5.

What about PostgreSQL? Would it be too difficult to sneak PostgreSQL support in?