SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Modeling relational databases


Modeling relational databases

Author
Message
mark.goldstein2
mark.goldstein2
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 7
I have used a free ERD diagramming tool recommended by my professor in grad school, called DIA.
Good for conceptual model. (and free) and UML
https://live.gnome.org/Dia/Download
Joie Andrew
Joie Andrew
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13864 Visits: 2077
I have not used it but did see a short demo of ERStudio from Embarcadero when looking for tools for a migration project. It could do what I needed at the time, but for pure modelling it looks VERY compelling and easy enough to generate the ERDs.

Joie Andrew
"Since 1982"
shrekito
shrekito
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 15
+1
Scott Meddows
Scott Meddows
SSC-Enthusiastic
SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)SSC-Enthusiastic (173 reputation)

Group: General Forum Members
Points: 173 Visits: 99
Visual Studio now has some great tools where you can build a database. It will treat it more like "code" and also you can run the project through an MSBuild process and it will deploy difs for you automatically.
halil.lacevic
halil.lacevic
Valued Member
Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)

Group: General Forum Members
Points: 51 Visits: 10
In software engineering, data modeling is the process of creating a data model for an information system. This is done by applying formal data modeling techniques.
There are many tools which can help you with modeling. Some of them are free, some of them aren't. I will list you few of them which I've found most useful.

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

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

ER/Studio

ER/Studio is an intuitive data modelling tool that supports single and multi-platform environments, with native integration for big data platforms such as – MongoDB and Hadoop Hive. It can forward and reverse engineer models, includes a compare and merge function and is able to create reports in various formats (XML, PNG, JPEG). Built-in features automate routine tasks and supports the popular database platforms. ER/Studio is a great tool that that is easy to start working with due to its intuitive design and good user support.

Price: $1,500 up to $7,500

It truly depends on you. To design, or redesign, a database of any complexity, the Entity-Relationship modelling tool becomes essential. The specialized tools that have dominated the industry for a long while are expensive and are installed on a workstation.


Arsh
Arsh
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1883 Visits: 694
Always best to have an ERD first , before proceeding to the physical design at relational level.
You can try 'Open ModelSphere' , has a free version I suppose .
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (433K reputation)SSC Guru (433K reputation)SSC Guru (433K reputation)SSC Guru (433K reputation)SSC Guru (433K reputation)SSC Guru (433K reputation)SSC Guru (433K reputation)SSC Guru (433K reputation)

Group: General Forum Members
Points: 433355 Visits: 43494
To be honest, I usually tell auditors "NO" when it comes to producing a full system ERD. They usually don't have the need to know and it is a proprietary system. I tell them to ask specific questions and then we'll be happy to give the table layout for that particular question including the first level of tables that any FKs may reveal. They do not need to know the design of the entire database unless they auditing under a court order and search warrant looking for criminal activity or criminal neglect.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
ajaydeep
ajaydeep
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 6
halil.lacevic - Saturday, August 26, 2017 3:27 AM
In software engineering, data modeling is the process of creating a data model for an information system. This is done by applying formal data modeling techniques.
There are many tools which can help you with modeling. Some of them are free, some of them aren't. I will list you few of them which I've found most useful.

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

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

ER/Studio

ER/Studio is an intuitive data modelling tool that supports single and multi-platform environments, with native integration for big data platforms such as – MongoDB and Hadoop Hive. It can forward and reverse engineer models, includes a compare and merge function and is able to create reports in various formats (XML, PNG, JPEG). Built-in features automate routine tasks and supports the popular database platforms. ER/Studio is a great tool that that is easy to start working with due to its intuitive design and good user support.

Price: $1,500 up to $7,500

It truly depends on you. To design, or redesign, a database of any complexity, the Entity-Relationship modelling tool becomes essential. The specialized tools that have dominated the industry for a long while are expensive and are installed on a workstation.


Thank you Halil, for sharing Data Modeling tools, I tried SqlDBM and really liked it....

Trevor Jobling
Trevor Jobling
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 13
I can recommend another free modelling tool: QuickDatabaseDiagrams.com https://www.quickdatabasediagrams.com/
It lets you create database diagrams really quickly just by typing, rather than doing lots of clicking with the mouse. Suitable for very rapid prototyping and diagramming. It also generates SQL. [disclaimer: my company made it!]


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search