tomtees — 2010-04-09T22:05:10-04:00 — #1
Can someone recommend a good CASE Tool for MySQL?
I would like to be able to create "logical" and "physical" designs (i.e. ERD's) of my tables before writing the SQL to create tables and relationships.
I do much better designing databases visually!!
Open-source would be preferred.
jake_arkinstall — 2010-04-09T22:12:49-04:00 — #2
This probably sounds patronising, but it really isn't meant that way.
Have you tried the good old pencil + paper approach?
I find any kinds of software designed to help get a visual mental picture of something aren't as good as pencil and paper. That might be just me, but its worth a shot!
r937 — 2010-04-09T22:19:29-04:00 — #3
another vote for paper and pencil -- and an eraser
you could also try one of these tools -- http://databaseanswers.org/modelling_tools.htm
tomtees — 2010-04-09T22:25:55-04:00 — #4
Yes, I am a big fan of "pencil + paper", HOWEVER, it is much easier to use a CASE tool because you can...
- Store ERDs
- Easily modify ERD's
- Relate ERD's to your Data Dictionary
- Convert "logical" ERD's to "physical" ERD's and relate each in a "library"
** Perform Table Generation from ERDs (i.e. "Forward Engineering")
** Perform ERD Generation from Tables (i.e. "Reverse Engineering")
- and lots more...
Many years ago I used Popkin's System Architect, but it cost thousands of $$$.
There are also some IBM tools, TOAD, etc, but I was hoping maybe there was a fully-functional, open-source ERD.
Maybe something from the MySQL or phpMyAdmin teams?!
r937 — 2010-04-09T22:32:30-04:00 — #5
tried that once, didn't like it
preferred ERWin, but it too cost thousands of $$$
i think the mysql team have something, not sure if it supports ER diagrams, though
some of the tools in the site i linked to are pretty decent, and a lot of them are free
tomtees — 2010-04-11T11:51:38-04:00 — #6
So which tools on that page have you used and like?
(You certainly can't be doing complex systems entirely on paper?!)
I have tried MySQL Workbench, but am not crazy that...
The Reverse Engineering didn't insert relationship lines for me
That the relationship lines do not appear next to the relevant field. (You have to hover over the line which is in the middle of the table to figure out where it goes to?!)
I don't mind experimenting, but it also helps to have someone who is more experienced point a newbie in the right direction and save me the struggle!
What does everyone else use?
r937 — 2010-04-11T14:56:02-04:00 — #7
tomtees — 2010-04-11T15:20:59-04:00 — #8
Can you elaborate?
Are you averse to automating things or software?!
(You have a fancy badge by your name, so you must be important. Certainly a more "sophisticated" database person like yourself would feel CASE tools are an improvement over paper for serious projects?!)
What does everyone else think/do?
jake_arkinstall — 2010-04-11T15:30:57-04:00 — #9
I don't think he even needs paper. Databases is what Rudy is proficient at, he breathes SQL and eats datatypes. To help forum members solve problems he doesn't ask for a table diagram, but the MySQL code describing it.
Something makes me think he just knows what's going on. I don't work with advanced tables by any means, just the usual stuff. The most joins I've had in a single query is about 3, so the way I do things may not be the same as an expert who's used to large database structures - however, my method is simple; Memory.
tomtees — 2010-04-11T15:47:01-04:00 — #10
Well, I can't think of any times where I needed to do more than 3 joins either. However, I find it helps me enormously when I can look at all of my tables and the joins between them. (I have had databases with 20-30 tables, and that is too unwieldy to memorize.)
And back to an earlier point...
I am working with someone else's database design, and so for me, the quickest way to get up to speed is to see an ERD. (If I had created things from scratch, I could likely do things - more easily - in my head as well.)
Hoping someone out there has used an open-source tool, that is a stable project, that does ERD's (including Reverse Engineering), and was happy with the tool.
(I hate to admit it, but MS Access's "Relationship Window" does a great job considering how basic it is.)
alud — 2010-04-29T23:12:59-04:00 — #11
try using some data modeler case tools or something like that: http://case-tools.org/data_modeling.html
tomtees — 2010-05-09T17:14:53-04:00 — #12
I went here and was checking out:
but they all require installation via command line in Linux. (I am on a Mac.)
I don't really know anything about command line adn am afraid I'll break my Mac.
Isn't there an easier way to install and use one of the above mentioned apps?