CA ERwin® Data Modeling's Role
in the Application Development
CA ERwin Data Modeling's Role
in the Application Development
Lifecycle
DH010SN
Hybrid Data Protection
Donna Burbank
CA Technologies
Insert
abstract
A data model is a critical part of any application lifecycle, whether
on-premise or in a Cloud environment. Using a model-driven
architecture, core data assets can be reused to ensure
consistency, increase quality and reduce the time and costs
associated with the development and maintenance of
applications. A data model helps:
− Create a visual inventory of source/target systems –
"Know what data you have"
− Communicate key business requirements between business and IT
stakeholders - "Know what your data means"
− Define standards for reuse and consistency –
"Know your data is correct"
4
The Challenge: Data + Application Complexity
The Importance of Data in Application Development
The ITKO and ERwin Solution: Optimizing the Application
Lifecycle
Why Optimize the Application Lifecycle?
What if I could be sure that my customer-facing applications
are delivered faster and perform exactly as expected?
What if I could not only identify and resolve software issues in production up to 70% faster,
but prevent the most costly problems before they get to production?
What if I could automate and virtualize these software processes and labs to
reduce labor and infrastructure costs by up to 30% or more over the next 12 months?
What if I were able to have confidence in my data in order to make strategic decisions?
Would this create a competitive advantage for my business?
The Product is the entire brand and customer experience
Service-oriented products are delivered late, over budget and with
questionable quality…WHY?
New applications are composite
and highly integrated
Most new application
development is self-service and
customer-facing making
complexity exponential
Most of the information
developers need is outside of
their control when they need it
Limited predictability on how it’s
going to perform and where it’s
going to break
RMI Objects Messaging Service BI Tools Business Rules File System ESB Web Interface Content Database Data Warehouse Financials Mainframe Web/WAP Interface EJB Virtual Service Routing Service SOAP CRM App Products Collaboration App Portal Help Engine BPMS Infrastructure Internal External Partners CloudRMI Objects Messaging Service BI Tools Business Rules File System ESB Web Interface Content Database Data Warehouse Financials Mainframe Web/WAP Interface EJB Virtual Service Routing Service SOAP CRM App Products Collaboration App Portal Help Engine BPMS Infrastructure Internal External Partners Cloud
modern application development architecture
Data is at the Core
Data is at the Core of Application
Development
New applications are composite
and highly integrated
Most new application
development is self-service and
customer-facing making
complexity exponential
Most of the information
developers need is outside of
their control when they need it
Limited predictability on how it’s
the challenge: managing data complexity
“Too Much Data, Too Little Time”
More Data & Platforms to Support
Most organizations have more than one database platform—it’s hard to be
an expert in all
The number of databases is growing, with more and more applications to
support
Many organizations are trying to integrate multiple systems
The decision of what data to move to the Cloud is an important
consideration
Fewer Staff and Resources
Organizations are cutting back on IT staff, making it difficult to manage these
growing databases
Oracle
creating a data inventory
Create a visual inventory of source
and target systems
Build consistent database structures
Know what data you have
Ensure that your data is consistent
MySQL
DB2
Teradata
Sybase
SQL
Server
MySQL
DB2
Teradata
SQL
Server
Sybase
Oracle
CA ERwin® Data Modeler
What is a vehicle?
the importance of data definitions
why does a data model matter?
The management of a leading US auto manufacturer wanted to
know how their vehicle sales compared to the competition.
The report showed that they sold 110% more vehicles than their
competitors.
Confident in their success, management decided to increase their
production of their SUV and truck lines.
know what your data means
What is a “Vehicle”?
the results of making business decisions based on bad data
The reports given to the management team did not include Hybrid
Vehicles, sales of which were increasing dramatically among their
competitors.
Why? The data model, and resulting database queries that build
the report, were based on an incorrect business definition.
The Result: The company’s decision to increase Truck and SUV
understanding your data puts power in your hands
Portfolio
Management Requirements Design Dev
System Test
Integration
Test UAT
Performance
Test Deploy Monitor
Planning &
Governance
LISA
Production
& Support
Application Lifecycle ManagementDevTest Cloud Manager
Service Virtualization Test Automation Defect Collaboration Continuous Validation Requirements Management Test Management Defect Management IDE
Source Code Management Build
Static Code Analysis Code Security
optimizing the application lifecycle
Data plays a critical role
Platforms for agile composite app dev Application Lifecycle
CA ERwin Data Modeler
ERwin
Business Requirements
LISA’s “virtual” Test Data Management approach
Service Virtualization methods from data
Automatically Desensitizes live data
for security and compliance
Capture directly or import from
transactions, databases, files
Heal the data model from the live
system when invalid or outdated
Dynamically adjusts data for time
Booking
Engine
SQL
Input Data
GDS
GDS
Ops
SaaS
TDM
Tool
Oracle
SAP
FF
CRS
identify in-scope data with ERwin,
then virtualize test data with LISA
Portfolio
Management Requirements Design Dev
System Test
Integration
Test UAT
Performance
Test Deploy Monitor
Planning &
Governance
LISA
Production
& Support
Application Lifecycle ManagementDevTest Cloud Manager
Service Virtualization Test Automation Defect Collaboration Continuous Validation Requirements Management Test Management Defect Management IDE
Source Code Management Build
Static Code Analysis Code Security
optimizing the application lifecycle
continuous feedback Loop
Platforms for agile composite app dev Application Lifecycle
CA ERwin Data Modeler
ERwin
Business Requirements
20
Optimizing the Application Lifecycle helps:
− Increase Quality
− Reduce Development Time and Costs
Data is a critical part of the Application Lifecycle
Managing Data effectively increases both Technical and
Business outcomes
Combining ITKO and ERwin helps Optimize the Application
Lifecycle, aligning data models with data analyzed in the
virtual environment
summary
Recommended Sessions
SESSION #
TITLE
Date / Time
DH001SN
Data Management Focus Area Opening
Session
11/14/2011 at
4:00pm
AO001SS
ITKO Introduction: Where Agility Takes
Flight
Related Technologies
terms of this presentation
for information purposes only
Copyright © 2011 CA. All rights reserved. All trademarks, trade names, service marks and logos referenced herein belong to their respective companies.
This presentation was based on current information and resource allocations as of November 2011 and is subject to change or withdrawal by CA at any time without notice. Notwithstanding anything in this presentation to the contrary, this presentation shall not serve to (i) affect the rights and/or obligations of CA or its licensees under any existing or future written license agreement or services agreement relating to any CA software product; or (ii) amend any product documentation or
specifications for any CA software product. The development, release and timing of any features or functionality described in this presentation remain at CA’s sole discretion. Notwithstanding anything in this presentation to the contrary, upon the general availability of any future CA product release referenced in this presentation, CA will make such release available (i) for sale to new licensees of such product; and (ii) to existing licensees of such product on a when and if-available basis as part of CA
maintenance and support, and in the form of a regularly scheduled major product release. Such releases may be made available to current licensees of such product who are current subscribers to CA maintenance and support on a when and if-available basis. In the event of a conflict between the terms of this paragraph and any other information contained in this presentation, the terms of this paragraph shall govern.
Certain information in this presentation may outline CA’s general product direction. All information in this presentation is for your informational purposes only and may not be incorporated into any contract. CA assumes no responsibility for the accuracy or completeness of the information. To the extent permitted by applicable law, CA provides this presentation “as is” without warranty of any kind, including without limitation, any implied warranties or merchantability, fitness for a particular purpose, or non-infringement. In no event will CA be liable for any loss or damage, direct or indirect, from the use of this document,
including, without limitation, lost profits, lost investment, business interruption, goodwill, or lost data, even if CA is expressly advised in advance of the possibility of such damages. CA confidential and proprietary. No unauthorized copying or distribution permitted.
