Erwin Data Modeler: Difference between revisions

Revision as of 13:55, 2 October 2017

Revision as of 14:33, 2 October 2017

Line 1:

{{Lowercase title}}

{{third-party|date=May 2014}}

{{advert|date=October 2016}}

{{Infobox Software

| name = erwin Data Modeler

Line 13 ⟶ 11:

| website = {{URL|http://www.erwin.com}}

|screenshot=ErwinDM.png|status=Active|AsOf=October 2017}}

'''erwin Data Modeler''' (stylized as '''erwin''' but formerly as '''ERwin''') is a [[computer software|software]] tool for [[data modeling]]. (dataOriginally [[requirementsdeveloped analysis]],by [[databaseLogic designWorks]], etc.)erwin ofhas customsince developedbeen [[informationacquired systems]],by includinga databasesseries of transactionalcompanies, systemsbefore and [[data mart]]s. erwin's data modeling engine isbeing basedspun-off uponby the [[IDEF1Xprivate equity firm]] method,Parallax althoughCapital itPartners, nowwhich supportsacquired diagrams displayed withand [[informationIncorporation engineering(business)|incorporated]] notationit as well.a Logicseparate Works stylisedentity, "erwin", fromInc., anmanaged abbreviationby ofCEO "Entity Relationships" and Microsoft'sAdam "Windows"Famularo.

The software’s engine is based on the [[IDEF1X]] method, although it now also supports diagrams displayed with a variant [[information engineering]] notation, as well as a dimensional modeling notation.

==History==

== 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|archive-url=|archive-date=|dead-url=|language=en}}</ref> In May 1993, Logic Works released ERwin/ERX, a version of the tool designed to work in conjunction with [[PowerBuilder]]. The database models created using ERwin could be translated into software built through the PowerBuilder [[integrated development environment]] (IDE).<ref>{{Cite book|url=https://books.google.com/books?id=0Uw3oTahRcwC|title=PC Client/server|date=1993-05-17|publisher=Computerworld|pages=71, 75|language=en}}</ref> In May 1995, Logic Works ERwin was expanded to include several other IDEs, adding SQLWindows from [[Gupta Technologies]] and [[Visual Basic]] from Microsoft.<ref>{{Cite news|url=https://books.google.com/books?id=pQpRMj6jSFYC|title=Database utility choices highlighted|last=Nash|first=Kim S.|date=1995-05-08|work=Computerworld|publisher=IDG Enterprise|pages=127|language=en}}</ref> As of 1996, ERwin was among several data modeling software solutions being used to facilitate a wide move to the [[client–server model]] in database management.<ref>{{Cite news|url=https://books.google.com/books?id=rrz6PIR7f0oC|title=CASE reincarnation|last=Richman|first=Dan|date=1996-07-29|work=Computerworld|access-date=2017-09-02|pages=45, 49}}</ref>

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|archive-url=|archive-date=|dead-url=|language=en}}</ref> under the name AllFusion ERwin Data Modeler.<ref name=":1">{{Cite news|url=http://itreports.computerworld.com/article/2554997/enterprise-applications/brief--ca-to-release-new-modeling-tool.html|title=Brief: CA to release new modeling tool|last=Hamblen|first=Matt|work=Computerworld|access-date=2017-10-02|language=en}}</ref><ref>{{Cite book|url=https://books.google.com/books?id=pTcwBQAAQBAJ|title=Developing a Data Warehouse for the Healthcare Enterprise: Lessons from the Trenches|last=Bergeron|first=Bryan|date=2013|publisher=HIMSS|isbn=9781938904332|language=en}}</ref> The tool was later renamed to CA ERwin Data Modeler.<ref>{{Cite book|url=https://books.google.com/books?id=P4_XBgAAQBAJ|title=Data Modeling Made Simple with CA ERwin Data Modeler r8|last=Burbank|first=Donna|last2=Hoberman|first2=Steve|date=2011-08-01|publisher=Technics Publications|isbn=9781634620697|language=en}}</ref>

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=http://www.justice.gov/opa/pr/embarcadero-technologies-and-ca-inc-terminate-proposed-transfer-ca-incs-erwin-data-modeler |title=Embarcadero Technologies and CA Inc. Terminate Proposed Transfer of CA Inc.'s ERwin Data Modeler &#124; |date=2014-11-05|website=OPA &#124; |publisher=Department of Justice |publisheraccessdate=2016-05-13}}</ref><ref>{{Cite news|dateurl=2014http://www.dataversity.net/erwin-11looks-05future-data-modeling/|title=ERwin Looks to the Future of Data Modeling|accessdatelast=Zaino|first=Jennifer|date=2016-0506-1309|work=Dataversity|access-date=2017-10-02|language=en-US}}</ref>

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 [[Casewise]], with a plan to integrate the two.<ref>{{Cite news|url=https://www.datanami.com/2016/12/13/business-process-mining-promises-big-data-payoff/|title=Business Process Mining Promises Big Data Payoff|last=Woodie|first=Alex|date=2016-12-13|work=Datanami|access-date=2017-10-02|language=en-US}}</ref>

== Overview ==

As of April 5, 2016, Private equity firm Parallax Capital Partners completed the acquisition of data modeling software erwin from CA Technologies. It now operates as erwin, Inc., and is led by IT industry veteran Adam Famularo, who is now CEO of erwin, Inc.<ref>{{cite web|url=http://erwin.com/resources/news/parallax-acquires-data-modeling-solution-erwin-from-ca-technologies#sthash.WgbBCsr0.dpuf |title=Parallax Acquires Data Modeling Solution ERwin from CA Technologies |publisher=ERwin |date= |accessdate=2016-05-13}}</ref>

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 engineering|Information 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> [[James Martin (author)|and]] a form of [[dimensional modeling]] [[James Martin (author)|n]]<nowiki/>o[[James Martin (author)|t]]<nowiki/>a[[James Martin (author)|t]]<nowiki/>i[[James Martin (author)|o]]<nowiki/>n.{{Sfn|Burbank|2011|p=496}}

== Notable users ==