IoT
Software // Information Management
Commentary
6/4/2009
10:55 AM
Rajan Chandras
Rajan Chandras
Commentary
50%
50%
RELATED EVENTS
IoT & Insurance: How Big Data May Affect Your Privacy & Premiums
May 06, 2016
Gwenn Bezard is co-founder and research director at Aite Group, where he leads the insurance pract ...Read More>>

The Resurgence of Data Modeling: Part I

CA, Embarcadero and Sybase have all recently released significant upgrades of their data modeling tools. The good news is that all three products surpass previous limitations and step up to the challenges of enterprise architecture and information governance. The question is: which tool works best for you?

CA, Embarcadero and Sybase have all recently released significant upgrades of their data modeling tools. The good news is that all three products surpass previous limitations and step up to the challenges of enterprise architecture and information governance. For IT shops, the question is: which tool works best for you?

Data modeling is a niche discipline and a small software market with consistent if unspectacular growth -- Forrester Research puts the current market (including sales and support) at about $165 million, growing to about $290 million over the next four years. But what this market lacks in terms of size it more than makes up in terms of business impact; data modeling is at the heart of every custom application development, data integration and data warehousing effort.In a recent study, Forrester identifies six data modeling tools that it finds noteworthy. In alphabetical order, these are:

  • CA ERwin (formerly AllFusion ERwin)
  • Embarcadero Technologies' ER/Studio
  • IBM InfoSphere Data Architect (formerly Rational Data Architect)
  • Microsoft Visual Studio (which includes Entity Data Model Designer)
  • Quest Software Toad Data Modeler and
  • Sybase PowerDesigner.

But the options don't stop there: for example, there's the erstwhile popular Popkin System Architect (now part of the IBM Telelogic line of products, overshadowed by IBM InfoSphere Data Architect); two products from Oracle: Oracle Designer (long on existence but short on adoption) and the forthcoming Oracle SQL Developer Data Modeling; Sparx Enterprise Architect (a dark horse that seems to be picking up speed); FabForce DBDesigner (for open source fans) and, to a very limited extent, Microsoft Visio (useful for beginners).

Historically, data modeling tools have evolved in two ways. Tools such as CA ERwin -- a 20-year stalwart and arguably the most popular data modeling tool of all time -- have evolved from Computer Aided Software Engineering (CASE) concepts and have focused primarily on data modeling, whereas tools like Sybase PowerDesigner and Sparx EA offer data modeling capabilities as part of a wider information modeling/design or Application Lifecycle Management (ALM) toolset, which might include process modeling, object modeling, development/testing etc.

The question is, how does this impact you, and how do you choose the best data modeling tool for your organization? I'll provide some guidance in my next post.CA, Embarcadero and Sybase have all recently released significant upgrades of their data modeling tools. The good news is that all three products surpass previous limitations and step up to the challenges of enterprise architecture and information governance. The question is: which tool works best for you?

Comment  | 
Print  | 
More Insights
Comments
Threaded  |  Newest First  |  Oldest First
The Agile Archive
The Agile Archive
When it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
Register for InformationWeek Newsletters
White Papers
Current Issue
4 Trends Shaping Digital Transformation in Insurance
Insurers no longer have a choice about digital adoption if they want to remain relevant. A comprehensive enterprise-wide digital strategy is fundamental to doing business today.
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on InformationWeek.com for the week of April 24, 2016. We'll be talking with the InformationWeek.com editors and correspondents who brought you the top stories of the week!
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.