different people have different...
TRANSCRIPT
1
Data architectDatabase administrator
Data modelsER diagrams
Metadata …
Java objectsWeb Services
Eclipse …
Table Spaces
Indexes
Static SQL …
Application developer
SQLStored Procedures
Triggers … Database developer
Authorization
Data privacy
Auditing …
Data steward
Different people have different responsibilities
2
Automation & Simplification
Common interfaces
Holistic problem determination
Table Spaces, JDBC, Indexes, Static SQL,
Data models, Collections, ER diagrams,
Hibernate, Metadata, SQL, Stress tests, Stored
Procedures, Packages, JPA, Triggers, XML, Java objects, Web Services, SOA, Eclipse,
Persistence frameworks, EJB 3, Authorization,
SQLJ, Data privacy, Connection pooling, J2EE,
Debugging, Auditing, iBATIS,
…
Something needs to be done to facilitate collaboration
3
Browse database
objects
Work
with XML files
Browse data
Create SQL
queries
Currently based on Eclipse 3.4.2 and the Data Tools Platform (DTP) framework
Eclipse lays the foundation for easier collaboration
4
What is Eclipse
�Open Source (07.Nov 2001)
� Framework, plugin based
�Often used as free Java IDE
� Perspectives and views concept
�Highly expandable
5
Optim Development Studio
� Is an integrated database
development environment.
� Speeds application design,
development and deployment.
� Increases data access
performance and manageability.
� Supports DB2 for z/OS, DB2 for
LUW & iSeries, IDS and Oracle.
Data Studio (IDE package)
� Includes a subset of important Optim Development Studio features (e.g. Database Browsing, SQL Editor, Stored Procedure Development, Visual Explain ...).
� Is available for free (via download or accessories).
Data Studio (stand-alone package)
� Lightweight version of Data Studio intended especially for DBAs.
� Is also available for free (via download or accessories).
New DB2 Tools especially for application developers
6
Why using Data Studio/Optim Development Studio?
� Intuitive interface for non-typical 3270 DB2 users
� Easy handling of DB2 DDL and DML for DBAs
and Sysprogs
�Common interface for DB2 family
� Easily start implementing of new DB2 features
7
Rational Developer for System z
Rational Application Developer
Rational Software Architect
...
Optim Query Tuner for DB2 for z/OSOptim Development Studio
...
DB2 for z/OSDB2 for LUW
Informix
(Oracle)
Data Studio IDE
Eclipse acts as a common integration platform
8
2004
2007
20XX
DB2 for z/OS V8
DB2 for z/OS 9
DB2 for z/OS X
Visual Explain
DB2 DevelopmentCenter
OptimizationService Center
DB2 DeveloperWorkbench
Data Studio
Data Studio
Revising the complimentary DB2 for z/OS tools
10
pureXML support
Oracle Support
Config. Repository
JPA Tooling
pureQuery Tools
And much more....
Data Web Services
SQL Editor
SQL Builder
Visual Explain
Stored Procedures
Data Source Expl.
User Def. Functions
SQLJ deployment
SQLJ development
Combination of useful features in one powerful solution
12
Developing with Optim Development Studio & pureQuery
� Optim Development Studio
� Extend Rational Application Developer
� Unleash SQL from Java
� SQL content assist
� SQL validation
� SQL execution
� SQL analysis (Explain)
� Improve Developer Productivity
� Decrease mapping maintenance
13
xOracle Support
xxEclipse Shell-Sharing
xxxGenerate DDL
xxxManage DB2 objects
xStatic execution of JDBC
xSQL support in Java editor
xDB2 & Java correlation
xxXML Editor
xxData Web Services
xxSQLJ Development
xxJava Stored Procedures
xxxSQL Stored Procedures
xxxAccess Plan Diagram
xxxSQL Editor & Builder
OptimDevelopment
Studio
Data Studio
IDE
Data Studio
Stand-alone
Detailed comparison of different versions
14
http://www.ibm.com/developerworks/spaces/optim?pageid=649
Where to find full and trial versions of the new tools?
15
Performance
Resource consumption
Holistic problem determination
PerformanceDatabase object tracking
Access path reliability
Authorization
Capacity planning
Static SQL
Resource consumption
Static SQL offers lots of benefits for DB2 applications