Book a Demo

Author Topic: Creating views in a data diagram  (Read 3103 times)

ajaxx

  • EA User
  • **
  • Posts: 32
  • Karma: +0/-0
    • View Profile
Creating views in a data diagram
« on: January 26, 2005, 11:13:03 am »
I realize that UML diagraming for data models is pretty young, but have any of you actually managed to construct views in the tool.  I've been thinking about adding a stereotype to table that would generate a simple joined view.  Its simplistic though and I havent been able to give much thought to how I might expand that.

Have any of you done this?

thomaskilian

  • Guest
Re: Creating views in a data diagram
« Reply #1 on: January 27, 2005, 12:50:23 am »
There have been discussions about views. Try to search the forum for "view".

karakas

  • EA Novice
  • *
  • Posts: 13
  • Karma: +0/-0
    • View Profile
Re: Creating views in a data diagram
« Reply #2 on: January 27, 2005, 09:43:33 am »
Quote
There have been discussions about views. Try to search the forum for "view".


To save others the 1+ hour it took me to "search the forum for 'view'" ('view' is not as uncommon a word as one might think), here are the relevant discussions that have taken place here so far:

Is it possible to create SQL views with EA ? (Don't even click - no answers here)

Database Views with Data Modeling and SQL DDL (No need to click here either, here is the essense of it: Q: "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?"  A (from an EA Administrator): " Yes - but I don't have an ETA.".

Reverse Engineering Database Views (There is a discussion here indeed, but of no help - only this info, as of Nov. 2004,  is interesting: " We are in the process of adding support for modelling stored procedures and views."

View (create or replace view as select....)  (peter offers an interesting method here - but is all manual and thus error prone and time consuming)

To summarize: At present, it is not possible to deal with views just as we do with tables in EA. There are plans for it, in fact there is already a process for it - but no "ETA".
Regards

Chris Karakas
http://www.karakas-online.de

thomaskilian

  • Guest
Re: Creating views in a data diagram
« Reply #3 on: January 29, 2005, 05:43:21 am »
 ;D probably I had the right feeling not to start the search by myself.
Thank Chris