Tool for DATA MODELLING

  • halil.lacevic

    SSC Enthusiast

    Points: 159

    A good database design starts with a list of the data that you want to include in your database and what you want to be able to do with the database later on. This can all be written in your own language, without any SQL. In this stage you must try not to think in tables or columns, but just think: "What do I need to know?" Don't take this too lightly, because if you find out later that you forgot something, usually you need to start all over. Adding things to your database is mostly a lot of work.

    There are a lot of tools that can help you:

    Archi 
    A free and open source visual modelling and design tool, Archi is used to create models and modelling sketches. By providing an open source reference implementation of ArchiMate, Archi is presently one of the tools used to implement the Open Group ArchiMate Model Exchange File Format.
    Price: Free

    PowerDesigner

    PowerDesigner is arguably the industry’s leading data modelling tool. Its features include: fully integrated models, different modelling techniques that cater to both an IT-centric audience and non IT-centric. It also supports a powerful metadata repository and various output formats. It has a nice and polished user interface with easily readable help documentation aiding the user to quickly solve ad hoc problems.

    Price: $2,000

    SQLDbm

    • Pricing: Free
    • Forward engineering: Use SQLDBM to create a physical model or ERD of your database
    • Reverse engineering: Use the reverse engineering feature to export your database schema as a SQL script

    Features:

    • Create database objects like tables, objects, relationships, indexes, quickly and intuitively
    • Alter and edit database objects inline in your diagram
    • Copy or Move columns across tables
    • Zoom in and out of diagrams
    • On-the- spot design anywhere on any browser

    Price: Free

  • halil.lacevic

    SSC Enthusiast

    Points: 159

    So far, I have tried many online tools. However, I will list you some of the tools that helped me a lot.

    SQLDbm


    SQLDBM offers you an easy, convenient way to design your database absolutely anywhere on any browser, working away without need for any extra database engine or database modelling tools or apps. Use SQLDBM to design and manage both large and small databases and data models on the fly. All while incorporating any needed database rules and objects such as database keys, schemas, indexes, column constraints and relationships.

    Price: Free

    AquaData Studio ER Modeler

    A free 14-day evaluation copy can be downloaded. The purchase price includes 12-month support. After the first year, support can purchased for 35% of the original license price.

    "Discounted licences are available for qualified Academic users and free licenses are available for qualified Open Source Software (OSS) Developers."

    Price: $400

    Dezign

    A recent upgrade offers significantly improved features. Supports Forward and Reverse Engineering for about 20 different Databases.

    Price: Offers a Free download or starts at $259 to buy

Viewing 2 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply