Database views

[dlucas8]

I am having trouble understanding how to model a database view?  Do they need to be part of the logical model, since they are part of a dynamic call.  I noticed that they are not part of the base stereotypes so I added the term view to my stereotypes list. How does EA deal with database views?  Will EA understand how to export the DDL (ie CREATE VIEW ...)?  I understand that EA first must hope that I understand the concept but any help would be great..

thanks

[«Midnight»]

In EA, views can only be defined for certain DBMS targets, check the release notes or documentation, since the list was expanded in version 7.0.

Open help in version 7.0, buikd 814 (current at this time). Click the Index tab and enter View. Click the Class entry immediately under View in the list, and you'll be on your way.

David

[dlucas8]

Thanks Midnight, I have noted since my post that my edition is a bit outdated and doesn't support views at all, so I guess I will need to upgrade.

[«Midnight»]

Views showed up around 6.1, or perhaps as late as 6.5. They were only supported for SQL Server and Oracle until 7.0.

There's been ongoing (relatively minor, but still usefule) work done to extend DBMS models. If you use this feature a lot this might be enough reason to update - the low cost is enough in my book though.

Meanwhile, we can only hope that OGM gets busy and finalizes the IMM standard. I'm hoping Sparx will support this if an when...

David