SitePoint Sponsor

User Tag List

Results 1 to 12 of 12
  1. #1
    SitePoint Evangelist TomTees's Avatar
    Join Date
    Apr 2010
    Location
    Iowa
    Posts
    553
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    CASE Tool for MySQL?

    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.

    Sincerely,



    TomTees

  2. #2
    Theoretical Physics Student bronze trophy Jake Arkinstall's Avatar
    Join Date
    May 2006
    Location
    Lancaster University, UK
    Posts
    7,062
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    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!
    Jake Arkinstall
    "Sometimes you don't need to reinvent the wheel;
    Sometimes its enough to make that wheel more rounded"-Molona

  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,215
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    another vote for paper and pencil -- and an eraser

    you could also try one of these tools -- http://databaseanswers.org/modelling_tools.htm
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  4. #4
    SitePoint Evangelist TomTees's Avatar
    Join Date
    Apr 2010
    Location
    Iowa
    Posts
    553
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Jake Arkinstall View Post
    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!
    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?!

    Sincerely,



    TomTees

  5. #5
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,215
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by TomTees View Post
    Many years ago I used Popkin's System Architect, but it cost thousands of $$$.
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  6. #6
    SitePoint Evangelist TomTees's Avatar
    Join Date
    Apr 2010
    Location
    Iowa
    Posts
    553
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    some of the tools in the site i linked to are pretty decent, and a lot of them are free
    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?

    Sincerely,



    TomTees

  7. #7
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,215
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by TomTees View Post
    So which tools on that page have you used and like?
    used: several

    liked: 0

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  8. #8
    SitePoint Evangelist TomTees's Avatar
    Join Date
    Apr 2010
    Location
    Iowa
    Posts
    553
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    used: several

    liked: 0

    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?



    TomTees

  9. #9
    Theoretical Physics Student bronze trophy Jake Arkinstall's Avatar
    Join Date
    May 2006
    Location
    Lancaster University, UK
    Posts
    7,062
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by TomTees View Post
    (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?!)
    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.
    Jake Arkinstall
    "Sometimes you don't need to reinvent the wheel;
    Sometimes its enough to make that wheel more rounded"-Molona

  10. #10
    SitePoint Evangelist TomTees's Avatar
    Join Date
    Apr 2010
    Location
    Iowa
    Posts
    553
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Jake Arkinstall View Post
    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.
    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.)



    TomTees

  11. #11
    SitePoint Member
    Join Date
    Sep 2009
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    try using some data modeler case tools or something like that: http://case-tools.org/data_modeling.html

  12. #12
    SitePoint Evangelist TomTees's Avatar
    Join Date
    Apr 2010
    Location
    Iowa
    Posts
    553
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Alud,

    I went here and was checking out:

    - ArgoUML
    - Umbrello
    - Dia

    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?


    TomTees


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •