Menu
Before anyone votes to close this as a dupe, know that every question I found so far was a question about specific programs that are good for database modeling. My question is what is the industry standard language (if there is one) for modeling a relational database?
I know UML is very popular in general, especially for OOP modeling, and the author of the book I am currently reading ("Pro SQL Server 2005 Database Design and Optimization" by Davidson) uses IDEF1X. MS Visio, though it supports IDEF1X, defaults to what seems like a generic modeling language without many specific symbols (refered to as the "relational" symbol set), but I know Visio is pretty standard because it's a part of the Office suite.
So, as a summer intern trying to build my résumé, which modeling language will prove the most useful in the industry for the future?
264
A standard data model or industry standard model (ISDM) is a data model that is widely applied in some industry, and shared amongst competitors to some degree. They are often defined by standard bodies, database vendors or operating system vendors.
YANG is a data modeling language for the NETCONF configuration management protocol. Together, NETCONF and YANG provide the tools that network administrators need to automate configuration tasks across heterogeneous devices in a software-defined network (SDN).
One of the most widely used modeling languages is the Unified Modeling Language commonly known as UML.
Oracle SQL Developer Data Modeler is a free graphical tool for Oracle databases that enhances productivity and simplifies data modeling tasks. For SQL Server databases, Database Diagrams is a great feature of the SQL Server Management Studio that offers data modeling capabilities and simplifies data modeling tasks.
That would be Entity RelationShip Diagrams, in short ERD.
107
ERD is probably the most widely used. I've also seen ORM used, though it is not database specific- it is about building a universe of facts.
38
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
