Erwin Data Modeler

Last updated
erwin Data Modeler
Developer(s)
Stable release
2020 R2 SP2 / February 8, 2021;2 years ago (2021-02-08) [1]
Operating system Microsoft Windows
Type CASE tool
License Proprietary, Trialware, EULA
Website erwin.com/products/erwin-data-modeler/
As ofApril 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 incorporated it as a separate entity, erwin, Inc., managed by CEO Adam Famularo.

Contents

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

ERwin was created by Logic Works, which was based in Princeton, New Jersey. [2] 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). [3] In May 1995, Logic Works ERwin was expanded to include several other IDEs, adding SQLWindows from Gupta Technologies and Visual Basic from Microsoft. [4] 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. [5]

In 1998, Logic Works was acquired by Platinum Technology which was later acquired, in May 1999, by Computer Associates (CA). [6] ERwin was initially made part of CA’s Jasmine suite but it was later added to their new AllFusion suite [7] under the name AllFusion ERwin Data Modeler. [8] [9] The tool was later renamed to CA ERwin Data Modeler. [10]

In 2014 Embarcadero Technologies sought to acquire the product from CA, Inc. [2] This acquisition was blocked by the Department of Justice over anti-competitive concerns. [11] [12]

In April 2016, Parallax Capital Partners, a private equity firm, acquired the software from CA Technologies [13] and appointed Adam Famularo as CEO. [14] The company now operates under a new name stylized as erwin, Inc. [15] In September 2016, erwin announced that it had acquired Corso, a British enterprise architecture service provider. [16] In December of the same year, erwin acquired the business process modeling software Casewise, with a plan to integrate the two. [17] In 2017, erwin released its Data Modeler NoSQL, an enterprise-class data modeling solution for MongoDB. In April 2018, NoSQL data modeling support for Couchbase was added. [18] Also that year, erwin launched a data governance solution with impact analysis and integrations to its business process, enterprise architecture and data modeling suites. [19] [20] In January 2018, the company acquired data harvesting technology and data governance consulting services company A&P Consulting. [21]

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. [22] [23] In February 2018 erwin released its first State of Data Governance Report with UBM. [24] [25] In August 2018, erwin acquired metadata management and data governance company AnalytiX DS. [26]

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). [27] Users can utilize erwin Data Modeler as a way to take conceptual data model and create a logical data model that is not dependent on a specific database technology. [28] 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 systems. [29] The software includes features to graphically modify the model, including dialog boxes for specifying the number of entity–relationships, database constraints, indexes, and data uniqueness. [27] erwin supports three data modeling languages: IDEF1X, [30] a variant of information technology engineering [31] developed by James Martin, [32] and a form of dimensional modeling notation. [33]

The software also allows users to generate data models by reverse-engineering pre-existing databases that are based on several different formats. [34] 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. [35]

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. [36] As of March 2016, the software bundle also includes its own Report Designer. [12] 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. [37]

Notable users

Beginning in 1992, the United Nations Development Programme (UNDP) was one of the larger organizations to utilize ERwin to integrate its many independent databases located at its 120 field offices. UNDP used ERwin to develop a “corporate data model”, with the goal of “reducing redundant data entry” and create a single database framework based on which “all future systems can be designed”. ERwin was used to both reverse-engineer existing data at field offices and also move data from Computer Associates’ IDMS to Sybase’s UnixRDBMS. [38]

As of 2001, the insurance company Aetna used Erwin Data Modeler to automate maintenance of its database table definitions. Aetna’s database consisted of 15,000 table definitions which became difficult to maintain manually. [39]

As of 2002, ERwin was among the products used by the New York Power Authority. [40] The software was also in use by Utah State Office of Education as of 2006. [8]

Related Research Articles

<span class="mw-page-title-main">Object database</span> Type of database management system

An object database or object-oriented database is a database management system in which information is represented in the form of objects as used in object-oriented programming. Object databases are different from relational databases which are table-oriented. A third type, object–relational databases, is a hybrid of both approaches.

Quest Software, also known as Quest, is a privately held software company headquartered in Aliso Viejo, California, United States. Quest provides cloud management, software as a service, security, workforce mobility, and backup & recovery. The company was founded in 1987 and has 53 offices in 24 countries.

InterBase is a relational database management system (RDBMS) currently developed and marketed by Embarcadero Technologies. InterBase is distinguished from other RDBMSs by its small footprint, close to zero administration requirements, and multi-generational architecture. InterBase runs on the Microsoft Windows, macOS, Linux, Solaris operating systems as well as iOS and Android.

C++Builder is a rapid application development (RAD) environment, originally developed by Borland and as of 2009 owned by Embarcadero Technologies, for writing programs in the C++ programming language currently targeting Windows, iOS and for several releases, macOS and Android C++Builder combines the Visual Component Library and IDE written in Object Pascal with multiple C++ compilers. Most components developed in Delphi can be used in C++Builder with no or little modification, although the reverse is not true, but this constraint is valid only for source code. Binary code generated by Delphi can easily be linked to binary code generated by C++Builder and vice versa to generate an executable written in both Object Pascal and C++. With this approach, C++ can be called from Object Pascal and vice versa. Since both Delphi and C++ use the same back end linker, the debugger can single step from Delphi code into C++ transparently.

<span class="mw-page-title-main">BEA Systems</span> Defunct American software corporation

BEA Systems, Inc. was a company that specialized in enterprise infrastructure software products, which was wholly acquired by Oracle Corporation on April 29, 2008.

<span class="mw-page-title-main">International Data Group</span> Publishing company

International Data Group is a market intelligence and demand generation company focused on the technology industry. IDG, Inc.’s mission is centered around supporting the technology industry through research, data, marketing technology, and insights that help create and sustain relationships between businesses.

Progress Software Corporation (Progress) is an American public company that offers software for creating and deploying business applications. Headquartered in Burlington, Massachusetts with offices in 16 countries, the company posted revenues of $531.3 million (USD) in 2021 and employs approximately 2100 people.

Cincom Systems, Inc., is a privately held multinational computer technology corporation founded in 1968 by Tom Nies, Tom Richley, and Claude Bogardus.

MarkLogic Corporation is an American software business that develops and provides an enterprise NoSQL database, also named MarkLogic. The company was founded in 2001 and is based in San Carlos, California. MarkLogic is a privately held company with over 500 employees and was acquired by Vector Capital in October 2020. It has offices in the United States, Europe, Asia, and Australia.

Platinum Technology Inc. was founded by Andrew Filipowski in 1987 to market and support deployment of database management software products and the applications enabled by database management technology and to render related services. Over its 12-year history, it was known for its acquisition of other companies, having bought more than 50 companies between 1994 and 1999 and growing to become the eighth largest global software company with revenue of a billion dollars per year. Acquisitions included Altai, Inc. (1995), AutoSystems Corporation, Brownstone Solutions, ICON Computing, Intervista Software, Software Interfaces, Locus Computing Corporation, LBMS (1998), Logic Works (1998), Protosoft, RELTECH Group, Memco Software, Softool, SQL TOOLS, Inc., Trinzic, Viatech and VREAM (1996). The company was a member of the UML Partners consortium.

ER/Studio is data architecture and database design software developed by IDERA, Inc. ER/Studio is compatible with multiple database platforms and is used to create and manage database designs, as well as to document and reuse data assets. In 2015, Embarcadero Technologies was acquired by database and infrastructure management software company IDERA, Inc. Since the acquisition by IDERA, Inc., ER/Studio has been renamed to ER/Studio Data Architect with updated features.

Database administration is the function of managing and maintaining database management systems (DBMS) software. Mainstream DBMS software such as Oracle, IBM Db2 and Microsoft SQL Server need ongoing management. As such, corporations that use DBMS software often hire specialized information technology personnel called database administrators or DBAs.

Logic Works Inc. was a software company created by CEO Benjamin C. Cohen based in Princeton, New Jersey. Their flagship product was an IDEF1X modeling and database design tool called ERwin (ERwin) whose name is formed from an initialism of ER for Entity Relationship and "win", short for windows. The company also produced BPwin, ModelMart and TestBytes.

Embarcadero Technologies, Inc. is an American computer software company that develops, manufactures, licenses, and supports products and services related to software through several product divisions. It was founded in 1993, went public in 2000, and private in 2007, and became a division of Idera, Inc. in 2015.

<span class="mw-page-title-main">Toad Data Modeler</span> Database design tool

Toad Data Modeler is a database design tool allowing users to visually create, maintain, and document new or existing database systems, and to deploy changes to data structures across different platforms. It is used to construct logical and physical data models, compare and synchronize models, generate complex SQL/DDL, create and modify scripts, and reverse and forward engineer databases and data warehouse systems. Toad's data modelling software is used for database design, maintenance and documentation.

<span class="mw-page-title-main">WaveMaker</span> Low-code programming platform

WaveMaker is an enterprise grade Java low code platform for building software applications and platforms. WaveMaker Inc. is headquartered in Mountain View, California. For enterprises, WaveMaker is a low code platform that aims to accelerate their app development and IT modernization efforts. For ISVs, it is a consumable low code component that can sit inside their product and offer customizations.

<span class="mw-page-title-main">Redgate</span> British software company

Redgate Software is a software company based in Cambridge, England. It develops tools for developers and data professionals and maintains community websites such as SQL Server Central and Simple Talk.

<span class="mw-page-title-main">Britton Lee, Inc.</span>

Britton Lee Inc. was a pioneering relational database company. Renamed ShareBase, it was acquired by Teradata in June, 1990.

A cloud database is a database that typically runs on a cloud computing platform and access to the database is provided as-a-service. There are two common deployment models: users can run databases on the cloud independently, using a virtual machine image, or they can purchase access to a database service, maintained by a cloud database provider. Of the databases available on the cloud, some are SQL-based and some use a NoSQL data model.

Idera, Inc. is the parent company of a portfolio of brands that offer B2B software including database tools, application development tools, test management tools, and DevOps tools. It is headquartered in Houston, Texas and has offices in Australia, Austria, and the United Kingdom. It is owned by the private equity firms HGGC, Partners Group and TA Associates.

References

  1. ↑ "erwin DM Product Release and Support Announcements – erwin". support.erwin.com. Retrieved 2021-04-05.
  2. 1 2 Jackson, Joab (2014-03-14). "Embarcadero moves into data modeling with CA ERwin buy". PCWorld. Retrieved 2017-10-02.
  3. ↑ PC Client/server. Computerworld. 1993-05-17. pp. 71, 75.
  4. ↑ Nash, Kim S. (1995-05-08). "Database utility choices highlighted". Computerworld. IDG Enterprise. p. 127.
  5. ↑ Richman, Dan (1996-07-29). "CASE reincarnation". Computerworld. pp. 45, 49. Retrieved 2017-09-02.
  6. ↑ "Computer Associates' Jasmine goes Platinum". KMWorld Magazine. 1999-03-30. Retrieved 2017-10-02.
  7. ↑ Songini, Marc L. (2001-11-26). "CA product lines get second overhaul". Computerworld. Retrieved 2017-10-02.
  8. 1 2 Hamblen, Matt. "Brief: CA to release new modeling tool". Computerworld. Retrieved 2017-10-02.
  9. ↑ Bergeron, Bryan (2013). Developing a Data Warehouse for the Healthcare Enterprise: Lessons from the Trenches. HIMSS. ISBN   9781938904332.
  10. ↑ Burbank, Donna; Hoberman, Steve (2011-08-01). Data Modeling Made Simple with CA ERwin Data Modeler r8. Technics Publications. ISBN   9781634620697.
  11. ↑ "Embarcadero Technologies and CA Inc. Terminate Proposed Transfer of CA Inc.'s ERwin Data Modeler". OPA. Department of Justice. 2014-11-05. Retrieved 2016-05-13.
  12. 1 2 Zaino, Jennifer (2016-06-09). "ERwin Looks to the Future of Data Modeling". Dataversity. Retrieved 2017-10-02.
  13. ↑ Wells, Joyce (2016-04-06). "Parallax Acquires ERwin from CA Technologies as Part of Big Data Strategy". Database Trends and Applications. Retrieved 2017-10-02.
  14. ↑ Cardoza, Christina (2016-04-07). "ERwin becomes a standalone company". SD Times. Retrieved 2017-10-02.
  15. ↑ Zaino, Jennifer (2017-02-23). "Erwin's End Game: Holistic Data Management". Dataversity. Retrieved 2017-10-02.
  16. ↑ Guess, A.R. (2016-09-14). "erwin Acquires SaaS Enterprise Architecture Provider, Corso". Dataversity. Retrieved 2017-10-02.
  17. ↑ Woodie, Alex (2016-12-13). "Business Process Mining Promises Big Data Payoff". Datanami. Retrieved 2017-10-02.
  18. ↑ "erwin DM NoSQL Strengthens Data Governance Across More Database Platforms". Database Trends and Applications. 30 April 2018.
  19. ↑ "Another Serious Player Is Entering The Data Governance 2.0 Market". 20 November 2017.
  20. ↑ Zaino, Jennifer (15 November 2017). "It's Time for Data Governance 2.0 with erwin DG".
  21. ↑ "Erwin Inc. acquires AnalytiX DS, grows to 240 workers". Newsday.
  22. ↑ "LI software maker buys Italian company". Newsday.
  23. ↑ "Doubling Down on Data Governance: Q&A with Adam Famularo, CEO, erwin, Inc". Database Trends and Applications. 28 February 2018.
  24. ↑ "Data Governance: How prepared are enterprises for the impending GDPR?". 12 February 2018.
  25. ↑ "Preparing for the GDPR in the eleventh hour". 5 March 2018.
  26. ↑ "erwin acquisition of AnalytiX DS rounds out its data governance platform". 4 September 2018.
  27. 1 2 Teorey, Toby J.; Lightstone, Sam S.; Nadeau, Tom; Jagadish, H. V. (2011-02-10). Database Modeling and Design: Logical Design. Elsevier. p. 234. ISBN   9780123820211.
  28. ↑ Fernandez, Iggy (2009-02-18). Beginning Oracle Database 11g Administration: From Novice to Professional. Apress. p. 131. ISBN   9781590599686.
  29. ↑ Burbank & Hoberman 2011, p. 481.
  30. ↑ Burbank & Hoberman 2011, p. 47.
  31. ↑ Burbank & Hoberman 2011, p. 328.
  32. ↑ Vogel, Peter (2010-12-09). "Starting a Data Model in CA's ERwin". Visual Studio Magazine. Retrieved 2017-10-02.
  33. ↑ Burbank & Hoberman 2011, p. 496.
  34. ↑ Vogel, Peter (2010-12-01). "Designing Databases with ERwin Data Modeler 7.3". Visual Studio Magazine. Retrieved 2017-10-02.
  35. ↑ Burbank & Hoberman 2011, p. 38-39.
  36. ↑ Burbank & Hoberman 2011, p. 38.
  37. ↑ "10 Best Data Modeling Tools To Manage Complex Designs". www.softwaretestinghelp.com.
  38. ↑ Hoffman, Thomas (1993-08-09). "U.N. group globalizes data modeling". Computerworld. pp. 69, 74. Retrieved 2017-09-02.
  39. ↑ Nance, Barry (2001-04-23). "Managing Tons Of Data". Computerworld. Retrieved 2017-10-02.
  40. ↑ Songini, Marc L. (2002-03-04). "CA Customers Hang Tough". Computerworld. Retrieved 2017-10-02.

Further reading

This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.