erwin insider2.PDF

Size: px

Start display at page:

Download "erwin insider2.PDF"

なつきいそみ
4 years ago
Views:

1 The ERwin 2 & BPwin ERwin & BPwin Contributions by ERwin & BPwin Users from Around the World Edited and Complied by Ben Ettlinger Volume 1 Number 2 September

2 ERwin & BPwin 1 ERwin ERwin ERwin ERwin ERwin 4.0 ERwin4.0 ERwin4.0 ERwin ERwin 1 CA ERwin ERwin OR ERwin 4 Ben Ettlinger Editor Data Administrator New York Power Authority President, NYEMUG New York Enterprise Modeling User Group JNT ( ) President, JEMUG ben.ettlinger@nypa.gov Japan Enterprise Modeling User Group 1

3 Table of Contents Table of Contents...2 Erwin Tips & Tricks Oracle 8i SQL*Net DB2 Index Defaults SQL Server Magnificent Macros Modeling Issues OR...24 Vendors Be Normal

4 Erwin Tips & Tricks Michael Levine Guelph, Ontario Canada ERwin SP2 SQL Server 7.0, SQL sp_bindefault :ERwin, ERwin / sp_bindefault 3

5 Terence J. Fitzpatrick, CA 1.),, ( ),, 2.),, (, ),, (, ERwin ), ER1,, ERwin 75, ERwin 4

6 Ben Ettlinger, New York Power Authority ERwin,? ERwin Windows,, cntl L Cntl M, dictionary.com, thesaurus.com, Web, amazon.com(100% ) Whit Owens, CA ERwin ERwin ' / ' 'Class Words',,,,,,, ' ERwin Macros, Macro<%Lower(%OwnerEntity %AttDomain)>,,,, 5

7 Linda Jeney ERwin pbcattbl' ' ' PowerBuilder ( -- PB ) 6

8 ERD ERD ERwin ERwin - [ERwin ] - [ERwin ] ERwin Excel DDE ASCII Create Table,Column - SQL 7

9 - SQL excel UDB CONCATENATE ("COMMENT ON COLUMN ",B1,"."C1," IS ",D1, "';") B1 excel C1 excel) D1 excel) - ASCII - ERwin SQL SQL CUT&PASTE ERwin Movies.ER1 CUSTOMER CREATE TABLE CUSTOMER ( customer_number INTEGER NOT NULL, customer_first_nam CHAR(15) NOT NULL, customer_last_name CHAR(15) NOT NULL, customer_address_1 VARCHAR(180) NOT NULL, customer_address_2 VARCHAR(180), customer_city CHAR(18), customer_state CHAR(2), customer_zip CHAR(10), customer_phone INTEGER, customer_credit_ca INTEGER, customer_credit_ca TIMESTAMP, customer_status_co CHAR(1) ); COMMENT ON COLUMN CUSTOMER.customer_number IS 'An identifier for a customer assigned at the first time a person rents a video.'; CREATE TABLE EMPLOYEE ( 8

10 employee_number INTEGER NOT NULL, store_number INTEGER NOT NULL, employee_first_nam INTEGER NOT NULL, employee_last_name CHAR(15) NOT NULL, employee_address_1 VARCHAR(20), employee_address_2 CHAR(20), employee_city VARCHAR(20), employee_state CHAR(2) NOT NULL, employee_zip INTEGER, employee_phone INTEGER, employee_ssn INTEGER, hire_date TIMESTAMP, salary NUMERIC NOT NULL, supervisor INTEGER NOT NULL ); [ERwin ]Main subject - ER

12 ERwin ERX Export ERX Workpad text Domain Properties /*,,,,,,,,,, CREATE TABLE DOMAIN_PROP_VALUE,,,,,,,,,, Workpad Attributes.txt Excel Attributes.txt Excel CD_ANM "_" space" " SUBSTITUTE Excel text text Workpad ERX Entity ERX ERwin import DECIMAL(9,9) Excel 30 ERX EXCEL text 11

13 EXCEL CSV (")?? Entity /* CREATE TABLE ERWIN_ENTITY (ENTITY_ID INTEGER NOT NULL, ENTITY_TYPE CHAR(6) NOT NULL, DIAG_ID INTEGER NOT NULL, ENTITY_NAME VARCHAR(254), TABLE_NAME VARCHAR(254), ENTITY_NOTE INTEGER, ENTITY_DEFINITION INTEGER VIEW_WITH_CHECK INTEGER ENTITY_FLAGS INTEGER ); */ 12

14 Domain Properties /* CREATE TABLE DOMAIN_PROP_VALUE (DOMAIN_ID INTEGER NOT NULL, DOMAIN_TYPE CHAR(6) NOT NULL, DIAG_ID INTEGER NOT NULL, TARGET_SYSTEM CHAR(6) NOT NULL, DOMAINPV_SEQ INTEGER NOT NULL, DOMAINPV_TYPE CHAR(6) NOT NULL, DOMAINPV_TEXT_VAL INTEGER, DOMAINPV_INT_VAL INTEGER, DOMAINPV_ID_VAL INTEGER, DOMAINPV_STR_VAL VARCHAR(254), DOMAINPV_INHERIT INTEGER NOT NULL ); */ 7,"DOMAIN",0,"TD_SS",0,"CD_TYP",0,0,0,"char(18)",0 7,"DOMAIN",0,"TD_SS",0,"CD_NUL",0,0,0,"",0 7,"DOMAIN",0,"TD_SS",0,"CD_NAM",0,0,0,"%AttName",0 7,"DOMAIN",0,"TD_SS",0,"CD_PLB",0,0,0,"%AttName:",0 7,"DOMAIN",0,"TD_SS",0,"CD_PHD",0,0,0,"%AttName",0 7,"DOMAIN",0,"TD_SS",0,"CD_CMT", ,0,0,"",0 7,"DOMAIN",0,"TD_SS",0,"CD_DMC", ,0,0,"",0 7,"DOMAIN",0,"TD_SS",0,"CD_DMN",0,0,0,"%DomainName",0 7,"DOMAIN",0,"TD_SS",0,"CD_ANM",0,0,0,"%AttDomain",0 7,"DOMAIN",0,"TD_SS",0,"CD_PCM", ,0,0,"",0 7,"DOMAIN",0,"TD_SS",0,"CD_PLP",0,23,0,"",0 7,"DOMAIN",0,"TD_SS",0,"CD_PHP",0,25,0,"",0 7,"DOMAIN",0,"TD_SS",0,"CD_PJT",0,23,0,"",0 7,"DOMAIN",0,"TD_SS",0,"CD_PCS",0,26,0,"",0 7,"DOMAIN",0,"TD_SS",0,"CD_PBM",0,110,0,"",0 7,"DOMAIN",0,"TD_SS",0,"CD_VSB",0,121,0,"",0 8,"DOMAIN",0,"TD_SS",0,"CD_DLN",0,0,0,"< >",0 8,"DOMAIN",0,"TD_SS",0,"CD_DIC",0,0,2,"",0 12,"DOMAIN",0,"TD_SS",0,"CD_DLN",0,0,0,"BLOB",0 12,"DOMAIN",0,"TD_SS",0,"CD_DIC",0,0,6,"",0 12,"DOMAIN",0,"TD_SS",0,"CD_TYP",0,0,0,"binary",0 10,"DOMAIN",0,"TD_SS",0,"CD_DLN",0,0,0," ",0 10,"DOMAIN",0,"TD_SS",0,"CD_DIC",0,0,4,"",0 10,"DOMAIN",0,"TD_SS",0,"CD_TYP",0,0,0,"int",0 11,"DOMAIN",0,"TD_SS",0,"CD_DLN",0,0,0," / ",0 11,"DOMAIN",0,"TD_SS",0,"CD_DIC",0,0,5,"",0 11,"DOMAIN",0,"TD_SS",0,"CD_TYP",0,0,0,"datetime",0 9,"DOMAIN",0,"TD_SS",0,"CD_DLN",0,0,0," ",0 9,"DOMAIN",0,"TD_SS",0,"CD_DIC",0,0,3,"",0 9,"DOMAIN",0,"TD_SS",0,"CD_TYP",0,0,0,"varchar(20)",0 13,"DOMAIN",0,"TD_SS",0,"CD_NUL",0,1,0,"",0 13,"DOMAIN",0,"TD_SS",0,"CD_ANM",0,0,0," ",0 13,"DOMAIN",0,"TD_SS",0,"CD_NAM",0,0,0,"syozoku_code",0 17,"DOMAIN",0,"TD_SS",0,"CD_ANM",0,0,0," ",0 17,"DOMAIN",0,"TD_SS",0,"CD_NAM",0,0,0,"syozoku_nm",0 14,"DOMAIN",0,"TD_SS",0,"CD_NUL",0,1,0,"",0 14,"DOMAIN",0,"TD_SS",0,"CD_ANM",0,0,0," ",0 14,"DOMAIN",0,"TD_SS",0,"CD_NAM",0,0,0,"syozoku_cd",0 20,"DOMAIN",0,"TD_SS",0,"CD_ANM",0,0,0," ",0 20,"DOMAIN",0,"TD_SS",0,"CD_NAM",0,0,0,"shimei",0 21,"DOMAIN",0,"TD_SS",0,"CD_ANM",0,0,0," ",0 21,"DOMAIN",0,"TD_SS",0,"CD_NAM",0,0,0,"nyuusya_NGP",0 13

15 Submitted by Karen Lopez, List Mistress for the Erwin Web Board WebPublisher* * WebPublisher %File% -- %Display% / %SubjectArea% 14

17 Submitted by: Ann Peoples, Wachovia, Inc REF_ID 16

18 Submitted by: Ann Peoples, Wachovia, Inc ( ) STAT_REF_ID DT_TYP_REF_ID ERwin ERwin 17

19 Seen on the Erwin WebBoard Oracle8.1.5 ERwin Server (Oracle Connection) Oracle user/pw/connect string connect Oracle8i SQL*Net 8i Net8 ERwin Erwin Oracle 8i SQL*Net config 18

20 Submitted by: Theo van Westrienen, Martinair Holland, DB2 DB2 ERwin DB2 DB2 ERwin DB2 USING DB2 Erwin 12 12(OS/390 DB2 v5 ) DB2 DB2 (Target Server Settings) UDP (Table Name Macro) UDP (Table Editor) UDP (Table Editor) UDP UDP (Volumetric Editor) (Physical Object) 18 DDL ERwin DB2 DBsync 19

21 A question from the Erwin WebBoard SQL Server Sybase 2 sp-addtype ERwin SQL Server IAB sql varchar(20) Spatial Sybase Spatial ddl Polygon Sybase Spatial Spatial 20

22 Entities -> Tables 18 Attributes -> Columns " " Macro for Domains Tips&Tricks Domain 21

23 (State) (City) (Street) (Address) etc Information Engineering. 3 (1) PK ID ID (bill-to, ship-to, etc.) (2) PK PK Text PK (3) PK ID description 2 (1) (Containing) (2) (Defines) street, PO Box, City, State, Province, Region, Country, Attention, Department, Floor, Mailstop, 22

24 (bill-to, ship-to, , IP, intra-company, mailstop, etc) 23

25 OR Ben Ettlinger Data Administrator New York Power Authority President New York Enterprise Modeling User Group JNT ( ) IRM President Japan Enterprise Modeling User Group 1 C. J. Date 3 ( ) Joe Di Santis ( ) Date 3 Object Relational Oracle DB2 SQL Server ORDMS ORDBMS SQL SQL3 4 ORDBMS IDC Bulletin #14821E - August 1997 Steve McClure SQL3 ORDBMS OO ( ) ADT 24

26 1 UML SQL3 UML 1 Webopedia

27 1 GUI UML UML UML 1 ER UML ERwin OODB UML ERwin ERwin Geographical Information Systems GIS Oracle 8i DB2 7.0 Sybase 12.0 SQL Serever

28 ? Distinct ROW TYPE? ISO ANSI SQL3 IDEF1X 1993 IDEF1X ORDBMS UML UML UML UML Dave Hay Data Model Patterns- Conventions of Thought (Dorset House) ER UML 2 Dave Hay UML Terry Halpin Object Role Modeling Visio ER UML ER 3 OR ER? Logic Works OR-Compass O R 1.01 IDEF1X ERwin 3 OR-Compass ERwin OR-Compass Logic Works CA 2 Entity Relationship Modeling from an ORM Perspective, Dr. Terry Halpin, 12/99, The Journal of Conceptual Modeling 3 ibid 27

29 2 - OR-Compass ERwin ERwin 8i Object Types : Collection Types : Oracle 8i 2 VARRAY VARRAY Pointers : (REF OID) (Join ) Object Views : Methods : objectese ( ) Large Objects (LOBs): BLOB CLOB NCLOB BFILE OR-Compass 28

30 / ( ) / / NULL 3 - ERwin ERwin

31 4 - ERwin Java C PL/SQL ERwin 5 30

32 4.0 Power Point 1 ERwin DLL REF OID ERwin DDL ) IDEF1X 1 N IDEF1X FIPS , DELETE (Oracle 8i Web Design, Oracle Press/Osborn/Mcgraw Hill, 2000) VARRAY 4 Federal Information Processing Standards Publication 184, 1993 December 21. FIPS 184 is the Federal standards document which defines IDEF1X. 5 pps. 102, 119, 135 Designing Quality Databases with IDEF1X Information Models by Thomas Bruce 1992 Dorset House ISBN ibid

33 (Oracle 8 Design Using UML Object Modeling, Oracle Press/Osborn/Mcgraw Hill, 1999) / A_ N_ V_ IDEF1X 6-32

34 7 - Collapsed Busy collapsed collapsed 33

35 8 - / DBMS 9 34

36 10 Collapsed ERwin 35

37 13 Collapsed 4 Zip code 2 14 ERwin collapsed 36

38 15 Collapsed LOB (LOB) ERwin 37

39 3.5.2 LOB 17 IT déjà vu ORDBMS Oracle 2 REF IOD REF Blob REF Blob 18 REF OID ID Number ORDBMS OID 38

40 19 OID OID OID 7 ERwin ERwin4.5 IDEF1X IE CA UML Paradigm Plus IDEF1X-ity UML IDEF1X IDEFML UMDEF1X? ERwin Parawin Erwindigm? OO IDEF1X ER ERwin Getting to Know Oracle 8I (Document #A ), 1999 Oracle Corporation 39

41 Vendors Be Normal Ben Ettlinger Data Administrator New York Power Authority President New York Enterprise Modeling User Group 8 IT ERP DATAMART DWH ER CA-ERWin Oracle This article appeared in the Aug. 4, 2000 edition of the DM Magazine Weekly on-line newsletter. 40

42 4 1 2 Codd DBMS integrity array nest DHW Ralph Kimball 9 ERP 9 Data Webhouse in Intelligent Enterprise June 26,

43 Kimball ERP ERP Kimball ERP Microsoft Ben Japan Enterprise Modeling User Group Erwin 42

44 2 JNT ( ) IRM President Japan Enterprise Modeling User Group 1 2 ERwin!! Ben Vender be Normal ERP OR-Compass Ben OR Informix Informix SQL 3,4 OR ERwin 43

ERwin Insider (TM) 日本語版

ERwin Insider (TM) 日本語版 ERwin & BPwin ERwin & BPwin ERwin & BPwin Ben Ettlinger Ben Ettlinger Data Administrator New York Power Authority, White Plains, NY President New York Enterprise Modeling User Group Gary Gramm Consultant,