Content deleted Content added
Filled in 11 bare reference(s) with reFill () |
No edit summary Tags: Mobile edit Mobile web edit |
||
| (15 intermediate revisions by 13 users not shown) | |||
Line 1:
{{short description|Data modeling software}}
{{Lowercase title}}
{{Infobox
| name = erwin Data Modeler
| logo =Erwin logo.png
| developer = {{Unbulleted list
|[[Logic Works]] (Through 1998) |[[Platinum Technology]] (1998–1999) |[[CA Technologies]] (1999–2016) |[[erwin, Inc.]] (2016 to present) }} | latest_release_version =
| latest_release_date = {{Start date and age|
| url = https://support.erwin.com/hc/en-us/articles/230037407-erwin-DM-Product-Release-and-Support-Announcements
| operating_system = [[Microsoft Windows]]▼
| title = erwin DM Product Release and Support Announcements – erwin
| website = support.erwin.com
| access-date = 2021-04-05
}}</ref>
▲| operating_system = [[Microsoft Windows]] and [[iOS]]
| genre = [[CASE tool]]
| license = [[Proprietary software|Proprietary]], [[Trialware]], [[EULA]]
| website = {{URL|
| screenshot = ErwinDM.png
| AsOf = April 2021
'''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.
Line 16 ⟶ 29:
== History ==
ERwin was created by [[Logic Works]], which was based in [[Princeton, New Jersey]].<ref name=":0">{{Cite news|url=http://www.pcworld.com/article/2108620/embarcadero-moves-into-data-modeling-with-ca-erwin-buy.html|title=Embarcadero moves into data modeling with CA ERwin buy|last=Jackson|first=Joab|date=2014-03-14|work=PCWorld|access-date=2017-10-02
In 1998, Logic Works was acquired by [[Platinum Technology]] which was later acquired, in May 1999, by [[Computer Associates]] (CA).<ref>{{Cite news|url=http://www.kmworld.com/Articles/News/News/Computer-Associates-Jasmine-goes-Platinum-12030.aspx|title=Computer Associates' Jasmine goes Platinum|date=1999-03-30|work=KMWorld Magazine|access-date=2017-10-02|language=en-US}}</ref> ERwin was initially made part of CA’s Jasmine suite but it was later added to their new AllFusion suite<ref>{{Cite news|url=http://www.computerworld.com/article/2584857/networking/ca-product-lines-get-second-overhaul.html|title=CA product lines get second overhaul|last=Songini|first=Marc L.|date=2001-11-26|work=Computerworld|access-date=2017-10-02
In 2014 [[Embarcadero Technologies]] sought to acquire the product from [[CA, Inc.]]<ref name=":0" /> This acquisition was blocked by the [[United States Department of Justice|Department of Justice]] over anti-competitive concerns.<ref>{{cite web|url=
In April 2016, Parallax Capital Partners, a [[private equity firm]], acquired the software from CA Technologies<ref>{{Cite news|url=http://www.dbta.com/Editorial/News-Flashes/Parallax-Acquires-ERwin-from-CA-Technologies-as-Part-of-Big-Data-Strategy-110276.aspx|title=Parallax Acquires ERwin from CA Technologies as Part of Big Data Strategy|last=Wells|first=Joyce|date=2016-04-06|work=Database Trends and Applications|access-date=2017-10-02|language=en-US}}</ref> and appointed Adam Famularo as CEO.<ref>{{Cite news|url=http://sdtimes.com/erwin-becomes-a-standalone-company/|title=ERwin becomes a standalone company|last=Cardoza|first=Christina|date=2016-04-07|work=SD Times|access-date=2017-10-02|language=en-US}}</ref> The company now operates under a new name stylized as erwin, Inc.<ref>{{Cite news|url=http://www.dataversity.net/erwins-end-game-holistic-data-management/|title=Erwin’s End Game: Holistic Data Management|last=Zaino|first=Jennifer|date=2017-02-23|work=Dataversity|access-date=2017-10-02|language=en-US}}</ref> In September 2016, erwin announced that it had acquired Corso, a British [[enterprise architecture]] service provider.<ref>{{Cite news|url=http://www.dataversity.net/erwin-acquires-saas-enterprise-architecture-provider-corso/|title=erwin Acquires SaaS Enterprise Architecture Provider, Corso|last=Guess|first=A.R.|date=2016-09-14|work=Dataversity|access-date=2017-10-02|language=en-US}}</ref> In December of the same year, erwin acquired the [[business process modeling]] software
They also developed the erwin EDGE software platform, with EDGE as an acronym for “enterprise data governance experience”, intending to use data governance for data-driven insights to help accomplish organizational objectives.
On December 31, 2020 erwin, Inc. was acquired by [[Quest Software]]. The business unit is headed by Prashant Parikh.
== 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 [[information technology engineering]] {{Sfn|Burbank|2011|p=328}} developed by [[James Martin (author)|James Martin]],<ref>{{Cite web|url=https://visualstudiomagazine.com/Blogs/Tool-Tracker/2010/12/Starting-CA-ERwin-Data-Model.aspx|title=Starting a Data Model in CA's ERwin|last=Vogel|first=Peter|date=2010-12-09|website=Visual Studio Magazine|language=en|access-date=2017-10-02}}</ref> and a form of [[dimensional modeling]] notation.{{Sfn|Burbank|2011|p=496}}▼
▲== Overview ==
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}}▼
▲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|Hoberman|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|Hoberman|2011|p=47}} a variant of [[information technology engineering]] {{Sfn|Burbank|Hoberman|2011|p=328}} developed by [[James Martin (author)|James Martin]],<ref>{{Cite web|url=https://visualstudiomagazine.com/Blogs/Tool-Tracker/2010/12/Starting-CA-ERwin-Data-Model.aspx|title=Starting a Data Model in CA's ERwin|last=Vogel|first=Peter|date=2010-12-09|website=Visual Studio Magazine|language=en|access-date=2017-10-02}}</ref> and a form of [[dimensional modeling]] notation.{{Sfn|Burbank|Hoberman|2011|p=496}}
▲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|Hoberman|2011|p=38-39}}
erwin’s Complete Compare feature allows the user to compare two versions of a model, displays differences, and allows for merging and updates in either direction.{{Sfn|Burbank|2011|p=38}} As of March 2016, the software bundle also includes its own Report Designer.<ref name=":3" /> The erwin DM 2018 update included Netezza, MySQL 8.x, PostgreSQL 10.4, and Hive; model counts reports; and PII support. The 2019 update included DB2 z/OS v12, SQL Server 2017, Teradata v16.20, and PostgreSQL 11.2, in addition to reporting enhancements like user-defined properties and filters.<ref>{{cite web|url=https://www.softwaretestinghelp.com/data-modeling-tools/|title=10 Best Data Modeling Tools To Manage Complex Designs|website=www.softwaretestinghelp.com}}</ref>▼
▲erwin’s Complete Compare feature allows the user to compare two versions of a model, displays differences, and allows for merging and updates in either direction.{{Sfn|Burbank|Hoberman|2011|p=38}} As of March 2016, the software bundle also includes its own Report Designer.<ref name=":3" /> The erwin DM 2018 update included Netezza, MySQL 8.x, [[PostgreSQL]] 10.4, and Hive; model counts reports; and PII support. The 2019 update included DB2 z/OS v12, SQL Server 2017, Teradata v16.20, and PostgreSQL 11.2, in addition to reporting enhancements like user-defined properties and filters.<ref>{{cite web|url=https://www.softwaretestinghelp.com/data-modeling-tools/|title=10 Best Data Modeling Tools To Manage Complex Designs|website=www.softwaretestinghelp.com}}</ref>
▲|}
== Notable users ==
| |||