aspose file tools
The moose likes JDBC and the fly likes getting a database model Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "getting a database model" Watch "getting a database model" New topic
Author

getting a database model

Amy Phillips
Ranch Hand

Joined: Apr 02, 2003
Posts: 280
hi,
Is there a way I can get a full ERM model of my database when using mysql? I am used to working to access so have always been able to see what my databse looks like and would very much like to be able to continue this. Are there maybe applications which can create the view for me using my database?
Thanks
Laurent Leonard
Ranch Hand

Joined: May 15, 2001
Posts: 35
I don't know if it works with mySql but Visio 2000 has a tool to make reverse engineering on db.
It works with Oracle.


Laurent LEONARD
Lasse Koskela
author
Sheriff

Joined: Jan 23, 2002
Posts: 11962
    
    5
Top-notch commercial products include among others:
*Sybase PowerBuilder
*Computer Associates ERwin

Haven't used them myself but have heard statements such as "why, oh why don't we have something like ERwin instead of sql*plus"...


Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
David Jordan
Author
Ranch Hand

Joined: Jun 14, 2003
Posts: 66
Many of the JDO implementations provide a tool that will read your relational schema and then with some guidance from you generate a complete Java object model that essentially represents your data model as entities (classes) and relationships (using references (1) and collections (many)).
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: getting a database model
 
Similar Threads
Creating a technical discussion forum like Javaranch for my school project
.js file and dynamic array
Stopping embedded sql
Upload file using JSP
ScopedModelDriven Problems