topic management reporting analysis & design constructiontesting process & project...
TRANSCRIPT
![Page 1: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/1.jpg)
Topic
Management Reporting
Analysis & Design Construction Testing
Process & Project Management
Change & Configuration Management
![Page 2: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/2.jpg)
ERwin
Database Design Made Easy
![Page 3: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/3.jpg)
Challenges Facing It Organizations
Leaner, less skilled staff High turnover rates Rapidly changing requirements Shortened development cycles Demand for higher quality software
![Page 4: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/4.jpg)
Complex Environment
RDBMS
![Page 5: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/5.jpg)
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.
![Page 6: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/6.jpg)
Benefits of ERwin
Visualization
Communication
Generation/maintenance
![Page 7: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/7.jpg)
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) ) ;
![Page 8: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/8.jpg)
Visualize Your Database
![Page 9: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/9.jpg)
Annotate Your Model
![Page 10: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/10.jpg)
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
![Page 11: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/11.jpg)
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
![Page 12: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/12.jpg)
Who Buys ERwin ?
Fortune 1000
Small to mid-size enterprises
Service Providers
Vendors
![Page 13: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/13.jpg)
Who Uses ERwin ?
DBADBA
Data Data AdministratorAdministrator
ApplicationApplicationDeveloperDeveloper
![Page 14: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/14.jpg)
Sales Differentiators
Market leadership
Scaleability via ModelMart
Aggressive partnership strategy
![Page 15: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/15.jpg)
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
![Page 16: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/16.jpg)
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
![Page 17: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/17.jpg)
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
![Page 18: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/18.jpg)
Scaleability via ModelMart
Workgroup modeling servicesSecurity Impact analysis
Model managementSub-modelingVersioning
![Page 19: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/19.jpg)
Partnerships
Microsoft Repository
IBM VisualAge
Informatica
![Page 20: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/20.jpg)
Competitors
Enterprise modeling solutionsOracle-Designer 2000Sybase-PowerDesignerSterling-COOL suiteSelect-SEPopkin-System Architect 2001
Desktop modeling solutionsEmbarcadero-ER/StudioVisio-Visio Enterprise
![Page 21: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/21.jpg)
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?
![Page 22: Topic Management Reporting Analysis & Design ConstructionTesting Process & Project Management Change & Configuration Management](https://reader036.vdocuments.us/reader036/viewer/2022081603/56649f335503460f94c50942/html5/thumbnails/22.jpg)
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.