ER/Studio 8.5の機能概要と 便利機能・ユーティリティーツール

A4 DatabaseGear
ER/Studio 8.5
•
•
•
•
•
•
ER/Studio
2
•
•
•
•
•
•
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
•
ER/Studio 8.5
ER/Studio 7.1
ER/Studio 6.6.1
ER/Studio 5.5
ER/Studio 5.1
ER/Studio 4.3
ER/Studio 4.2
ER/Studio 4.03
2009/12
2007/03
2005/03
2003/02
2002/07
2001/12
2001/03
2000/08
…
•
•
•
•
•
•
•
•
…
UI
…
/
…
…
/
HTML
…
…
5
•
•
•
•
•
•
•
DB
/
MetaWizard
Repository
…
7
•
UI
•
•
①
•
/
②
8
•
DDL
•
•
Oracle SQL Server
DDL
DB
•
DB
9
•
• VBA
•
SaxBasic
http://www.jsys-products.com/product/erstudio/macro.html
10
•
DB
DDL
•
•
•
A dm1
B dm1
11
•
RTF
•
•
HTML
•
•
12
MetaWizard
BI
ER/Studio
Sybase
PowerDesigner,
ERwin,
Forward
Reverse
Migration
ETL,EAI,EII
Informatica PowerCenter,
IBM InfoSphere DataStage,
Oracle Data Integrator
Flat File Structures
XSD
SAP BusinessObjects,
SAS, CoSORT,
Oracle Hyperion
RDBMS Schema/DDL
OLAP metadata
100
100
Repository
•
/
…
…
…
14
Repository
•
/
•
•
•
•
ER/Studio Repository
15
•
•
•
•
•
XML
•
•
•
/
•
/
•
•
•
•
•
•
DDL
• HTML
•
/
•
/
•
MetaWizard
•
•
•
2
•
•
•
•
DBMS
•
•
•
OS
Repository
•
•
•
Repository
LDAP
Active Directory
Repository
Repository
•
•
•
•
•
VDL)
…
17
•
名前付け
…
/
/
18
XML
XSD
VARCHAR(4)
(
ER
XML
(
) VARCHAR(4)
VARCHAR(40)
(
)
I
) VARCHAR(18)
VARCHAR(4)
INTEGER
VARCHAR(18)
P
VARCHAR(40)
P
VARCHAR(4)
(
)
(
I
VARCHAR(4)
) VARCHAR(4)
INTEGER
VARCHAR(1)
P
I
ER/Studio
ER/Studio DA
DA
VARCHAR(20)
VARCHAR(20)
VARCHAR(5)
VARCHAR(25)
VARCHAR(12)
(
(
)
) VARCHAR(18)
VARCHAR(4)
MetaWizard
MetaWizard
19
VDL)
•
•
•
•
DB
VDL
DB
DB
20
/
•
•
•
DA
DA
DBA
DBA
21
/
•
DATE
DATETIME
DATETIME
DATETIME2
TIME
SMALLDATETIME
22
•
A
B
C
D
23
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
OS
• Windows 2000 Pro Server, Windows XP Professional, Windows 2003,
Windows Vista
24
•
ER/Worksheet
• ER/Studio Excel
•
Naming Utility
•
•
ER/DataGen Enterprise
• ER/Studio
26
ER/Worksheet
•
ER/Studio Excel
• ER/Studio
Excel
• Excel
ER/Studio
• Excel
ER/Studio
•
•
• CRUD
Excel
ER/Studio
ER/Worksheet
27
ER/Worksheet
•
•
•
•
• ER/Studio
• ER/Studio
•
•
•
•
28
Naming Utility
•
•
•
•
• ER/Studio
•
/
29
ER/DataGen Enterprise
•
ER/Studio
•
•
•
•
•
30
ER/DataGen Enterprise
•
• ER/Studio
•
•
•
•
DB
•
ER/DataGen
DB
31
33
•
•
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
/
://
34