Content deleted Content added
ArguMentor (talk | contribs) Clarify ITE vs IE |
|||
Line 13:
'''erwin Data Modeler''' (stylized as '''erwin''' but formerly as '''ERwin''') is computer software for [[data modeling]]. Originally developed by [[Logic Works]], erwin has since been acquired by a series of companies, before being spun-off by the [[private equity firm]] Parallax Capital Partners, which acquired and [[Incorporation (business)|incorporated]] it as a separate entity, erwin, Inc., managed by CEO Adam Famularo.
The software’s engine is based on the [[IDEF1X]] method, although it now also supports diagrams displayed with a variant [[information technology engineering]] notation, as well as a dimensional modeling notation.
== History ==
Line 25:
== Overview ==
At its core, erwin has a [[computer-aided software engineering]] tool (or CASE tool).<ref name=":2">{{Cite book|url=https://books.google.com/books?id=9x2LawVL_UsC|title=Database Modeling and Design: Logical Design|last=Teorey|first=Toby J.|last2=Lightstone|first2=Sam S.|last3=Nadeau|first3=Tom|last4=Jagadish|first4=H. V.|date=2011-02-10|publisher=Elsevier|isbn=9780123820211|pages=234|language=en}}</ref> Users can utilize erwin Data Modeler as a way to take [[Conceptual schema|conceptual data model]] and create a [[Database design#Logically structuring data|logical data model]] that is not dependent on a specific database technology.<ref>{{Cite book|url=https://books.google.com/books?id=ufDibgxnCdUC|title=Beginning Oracle Database 11g Administration: From Novice to Professional|last=Fernandez|first=Iggy|date=2009-02-18|publisher=Apress|isbn=9781590599686|pages=131|language=en}}</ref> This schematic model can be used to create the [[physical data model]]. Users can then forward engineer the [[data definition language]] required to instantiate the schema for a range of [[Database Management System|database-management systems]].{{Sfn|Burbank|2011|p=481}} The software includes features to graphically modify the model, including dialog boxes for specifying the number of [[Entity–relationship model|entity–relationships]], [[Relational database#Constraints|database constraints]], [[Database index|indexes]], and data uniqueness.<ref name=":2" /> erwin supports three data modeling languages: [[IDEF1X]],{{Sfn|Burbank|2011|p=47}} a variant of [[
The software also allows users to generate data models by reverse-engineering pre-existing databases that are based on several different formats.<ref>{{Cite web|url=https://visualstudiomagazine.com/articles/2010/12/01/designing-databases-with-erwin-data-modeler-7.3.aspx|title=Designing Databases with ERwin Data Modeler 7.3|last=Vogel|first=Peter|date=2010-12-01|website=Visual Studio Magazine|language=en|access-date=2017-10-02}}</ref> Another included feature is erwin’s ability to create reusable design standards: “including naming standards, data type standards, model templates and more.” The software includes several features for modifying how the data model is displayed, including options for several colors, fonts, diagrams, subject areas and layouts.{{Sfn|Burbank|2011|p=38-39}}
| |||