fÆ a4 fÇ databasegearinformatica powercenter, ibm infosphere datastage, oracle data integrator...
TRANSCRIPT
ER/Studio 8.5
A4 DatabaseGear
2
•• ER/Studio
•••
•
•
J-SYS JGC Information Systems Co., Ltd.
• 1983 7 1
• 4 100%
• 83.4 2008
• 395 2009 4
• 3-6-3
MM 15F
•
•
• J-SYS Philippines
2004 7 7
J-SYS
•• ER/Studio 8.5 2009/12
• ER/Studio 7.1 2007/03
• ER/Studio 6.6.1 2005/03
• ER/Studio 5.5 2003/02
• ER/Studio 5.1 2002/07
• ER/Studio 4.3 2001/12
• ER/Studio 4.2 2001/03
• ER/Studio 4.03 2000/08
5
ER/Studio
HTML …
…
/ …
UI …
…
…
/ …
7
•• DB //
•••• MetaWizardMetaWizard
• RepositoryRepository
…
8
• UI
•
•
• /①①①①①①①①
②②②②②②②②
9
• DDL
• Oracle SQL Server DDL
• DB
• DB
10
•• VBA SaxBasic
•
http://www.jsys-products.com/product/erstudio/macro.html
• DB
DDL
•
•
•
11
A dm1A dm1
B dm1B dm1
• RTF
•
• HTML
•
•
12
ER/Studio
Sybase
PowerDesigner,
ERwin,
BI
SAP BusinessObjects,
SAS, CoSORT,
Oracle Hyperion
ETL,EAI,EII
Informatica PowerCenter,
IBM InfoSphere DataStage,
Oracle Data Integrator
Flat File Structures
XSD
RDBMS Schema/DDL
OLAP metadata
Forward
Reverse
Migration
100100
MetaWizard
14
Repository
•/
…
…
…
15
Repository
•/
•
•
•
•
ER/Studio Repository
•• XML
•
• /
••
•
• DDL
• /
/
•
• 2
•
• DBMS OS
• Repository
• Repository
• LDAP Active Directory
Repository
• Repository
••
• /
•
•
•
•
• HTML
• MetaWizard
•
•
•
•
•
•
•
•
•
•
• VDL) …
17
18
•
��
��
�� //
�� //
…
名前付け
��
��
19
XML XSD
P
P
P
VARCHAR(4)
( ) VARCHAR(4)
VARCHAR(40)
( ) VARCHAR(18)
( ) VARCHAR(4)
I INTEGER
VARCHAR(18)
VARCHAR(40)
( ) VARCHAR(18)
( ) VARCHAR(4)
VARCHAR(4)
VARCHAR(20)
VARCHAR(20)
VARCHAR(5)
VARCHAR(25)
I VARCHAR(12)
( ) VARCHAR(4)
( ) VARCHAR(4)
I INTEGER
VARCHAR(1)
MetaWizardMetaWizard
ERER XMLXML
ER/Studio DAER/Studio DA
20
VDL)
••
•
•
DB
DB
DB
VDL
••
•
21
/
DADA DBADBA
22
/
•
DATETIME
SMALLDATETIME
TIMETIME
DATETIME2
��
��
DATETIME
DATE
23
•
AA BB
CC DD
OS
•• Oracle® 7.3/8.0.x/8.1.x/9i/10g/11g
• Sybase® Adaptive Server® Enterprise
11.0/11.5/12.x/12.5/15.0
• Sybase Adaptive Server Anywhere
6/7/8/9/10
• Sybase Adaptive Server IQ 12.5
• Sybase System 10.0
• Sybase SQL Anywhere 5.0
• Sybase Watcom SQL
• Microsoft® SQL Server
7.0/2000/2005/2008
• Microsoft Access 2.0/95/97/2000
• Microsoft Visual FoxPro® 3.x/5.x
• IBM® Informix® OnLine / SE
• Informix Dynamic Server 9.x
• IBM DB2 UDB 5.x/6.x/7.x/8.x/9
• IBM DB2 AS400 4.x/5.x
• MySQL® 3.2/4.x/5.x
• HITACHI® HiRDB® 6.x/7.x/8
• ® HiRDB on XDM (VOS3 XDM/RD E2)
• InterBase® 4/2007/2009
• NCR® Teradata® V2R4/V2R5/V2R6/12.0
• PosrgreSQL 8.x
24
• OS• Windows 2000 Pro Server, Windows XP Professional, Windows 2003,
Windows Vista
26
• ER/Worksheet
• ER/Studio Excel
• Naming Utility
•
• ER/DataGen Enterprise
• ER/Studio
27
ER/Worksheet
• ER/Studio Excel
• ER/Studio Excel
• Excel ER/Studio
• Excel ER/Studio
••
• CRUD
ER/Studio
Excel
ER/WorksheetER/Worksheet
28
ER/Worksheet
••
•
•
• ER/Studio
• ER/Studio
•
•
•
•
29
Naming Utility
••
•
•
• ER/Studio
• /
30
ER/DataGen Enterprise
• ER/Studio
•
•
•
•
•
•• ER/Studio
••
••
DB
•
31
ER/DataGen Enterprise
ER/DataGenDB
33
34
••
220-0012
3-6-3 MM
• TEL 045-345-7027
• E-Mail [email protected]
• Web http://www.jsys-products.com/
• /
•
• http://://://://://://://://download.jsys-soft.jp////////