topic management reporting analysis & design constructiontesting process & project...
Post on 05-Jan-2016
215 Views
Preview:
TRANSCRIPT
Topic
Management Reporting
Analysis & Design Construction Testing
Process & Project Management
Change & Configuration Management
ERwin
Database Design Made Easy
Challenges Facing It Organizations
Leaner, less skilled staff High turnover rates Rapidly changing requirements Shortened development cycles Demand for higher quality software
Complex Environment
RDBMS
ERwin Positioning
ERwin is a powerful, easy-to-use database design tool. It delivers extraordinary productivity in the design, generation, and maintenance of high-quality database applications.
Benefits of ERwin
Visualization
Communication
Generation/maintenance
Visualize Your Database
CREATE TABLE PRODUCT ( product_id INTEGER NOT NULL, product_name VARCHAR(50) NULL, product_price NUMBER NULL);
ALTER TABLE PRODUCT ADD ( PRIMARY KEY (product_id) ) ;
CREATE TABLE DEPARTMENT ( department_id INTEGER NOT NULL, department_name VARCHAR(50) NULL);
ALTER TABLE DEPARTMENT ADD ( PRIMARY KEY (department_id) ) ;
CREATE TABLE EMPLOYEE ( employee_id INTEGER NOT NULL, department_id INTEGER NOT NULL, employee_fname VARCHAR(50) NULL, employee_lname VARCHAR(50) NULL, employee_ssn CHAR(9) NULL);
ALTER TABLE EMPLOYEE ADD ( PRIMARY KEY (employee_id) ) ;
CREATE TABLE CUSTOMER ( customer_id INTEGER NOT NULL, customer_name VARCHAR(50) NULL, customer_address VARCHAR(150) NULL, customer_city VARCHAR(50) NULL, customer_state CHAR(2) NULL, customer_zip CHAR(9) NULL);
ALTER TABLE CUSTOMER ADD ( PRIMARY KEY (customer_id) ) ;
CREATE TABLE ZORDER ( zorder_id INTEGER NOT NULL, employee_id INTEGER NOT NULL, customer_id INTEGER NOT NULL, zorder_date DATE NULL);
ALTER TABLE ZORDER ADD ( PRIMARY KEY (zorder_id) ) ;
Visualize Your Database
Annotate Your Model
Communicate Your Designs
Highly customizable reports Model Navigator
Real-time access to modelsRead-only
Model Web PublisherPublish models on the Web to a large audienceStatic models
Generate/Maintain Your Database
Most extensive database supportDB2OracleSQL ServerSybase IngresODBC
Tables, columns, views, RI, custom triggers, stored procedures, and physical objects
Model-database synchronization via Complete Compare
Who Buys ERwin ?
Fortune 1000
Small to mid-size enterprises
Service Providers
Vendors
Who Uses ERwin ?
DBADBA
Data Data AdministratorAdministrator
ApplicationApplicationDeveloperDeveloper
Sales Differentiators
Market leadership
Scaleability via ModelMart
Aggressive partnership strategy
ERwin Market Presence
1998 Results: 60+ Mil Revenue 60,000 users, 7,000 companies worldwide 18%+ growth year over year ERwin continues to sweep industry awards
Intelligent Enterprise Readers Choice - Seventh time!
DM Review Data Warehousing awardDBPD Database Dozen awardVB Programmer’s Journal
Gartner Group Assessment
CA data modeling tool ERwin maintains its leadership position.
Strong model management, integration with other leading tools, and a rich set of data warehousing features are added to good
basic functionality.
ADMODEL50828
Data Warehouse Design Tool Market Share
Source: 1998 Meta Group
0.0% 10.0% 20.0% 30.0% 40.0% 50.0%
Popkin SystemArchitect
SilverRun
Cayenne Terrain
SybasePowerDesign
Oracle Designer2000
Other
CA ERwin
1997
1996
Scaleability via ModelMart
Workgroup modeling servicesSecurity Impact analysis
Model managementSub-modelingVersioning
Partnerships
Microsoft Repository
IBM VisualAge
Informatica
Competitors
Enterprise modeling solutionsOracle-Designer 2000Sybase-PowerDesignerSterling-COOL suiteSelect-SEPopkin-System Architect 2001
Desktop modeling solutionsEmbarcadero-ER/StudioVisio-Visio Enterprise
Qualifying Questions
Is data quality a concern in your organization? Are any of your database applications a mystery? Are you engaged in any data warehousing
activities? Are you planning on implementing a packaged
application? Do you currently support any packaged
applications? If so,Do you need to integrate them with existing
systems?Do you know where to find data in these
package applications?
Jasmine Integration
ERwin will participate in the Jasmine ii infrastructure as a data consumer and data
provider, enabling it to share metadata with the rest of the ADvantage suite.
top related