Understands & Translates multiple database “languages”Ī must-have for any modern technical professionalCA ERwin® Data ModelerDatabaseDefinition LanguageXML,HTML, PDF or RTFDatabaseCatalogs
Why Do You Need a Data Model?Would you navigate a strange city without a map?Maybe…you could always read the road signsWhy Do You Need a Data Model?But what if you were traveling in several foreign cities, and couldn’t possibly learn every language for your trip?CA ERwin is your GPS for databasesERwin provides a Roadmap for multiple Database Platforms Why Do You Need a Data Model?With a single graphical model, you can manage multiple databases on diverse platforms.OracleOracleDB2DB2IDMSSQL ServerSAP Model 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) ) “A picture is worth a thousand words” A blueprintA DATABASE MODEL is a graphical representation of a database which is depicted by using an Entity Relationship Diagram (ERD)DatabaseData Model (ERD) What is Database Modeling?A MODEL is a graphical representation of a complex object, system or concept clarified through textual explanationE.g. of North Carolina Kenan-Flagler School of Business partnered with 4 others international universities ĪgendaTo understand what Data Modeling is.To understand why a company needs to Data Model.To understand why the ERwin suite of product is the right solution.What’s in R7.3? of Maryland, Executive Certificate in Business Administration from Georgetown University, Master of Science in Information Systems, and is currently completing his global MBA from the Univ. He holds various degrees: Bachelor of Science in Management Information Systems from Univ. He has a strong technical background combined with strong business acumen. Osman has been invited to speak at various events and technology forums, including CA World on various topics related to best practices in data modeling. He develops and executes the strategy needed to make ERwin successful to customers, partners, and to CA, Inc.
Osman is an expert in the ERwin Data Modeler family of products and comes with over 8 years of experience working with ERwin. for over 5 years working in various capacities such as senior presales consultant, SWAT, engineering services architect, and senior technology strategist. Introductions Osman Haque Global Strategy & Partner Enablement Lead GSAT Data Modeling Osman leads the global sales acceleration of the ERwin product line. November 2009Presented by: Osman Haque, Global Strategy & Partner Enablement Lead, Data ModelingBe a Hero with CA ERwin Modeling CA ERwin Data Modeler End User Presentation
0 kommentar(er)
