 | An introduction to IBM Data Studio for IDS
IBM Data Studio Developer 2.1 is an integrated database development
environment that speeds application design, development, and
deployment while increasing data access performance and manageability.
It has the following capabilities for use with IDS:
- Increases developer productivity to deliver applications
faster
- Generates a data access layer and unit test
applications using Java objects, JSON, or, XML
- Reduces code to write and maintain to lower complexity
and cost over using straight JDBC, yet provides
visibility to the SQL to enable tuning
- Enables drag and drop creation of Web services for any
SQL statement or stored procedure
- Provides a seamless SQL/Java experience including SQL
assistance, validation, execution, and analysis
- Provides expert-equivalent performance for Java data access
- Facilitates use of JDBC and SQL data access best
practices, including such capabilities as
heterogeneous batch, which can reduce network
operations
More details can be found at:
"Base"
enhancements in Data Studio Developer 2.1 for Informix
With the release of Data Studio Developer 2.1, there are many
enhancements that Informix DBAs can benefit from that are not related
to pureQuery or application development, including:
- Support for UPDATE STATISTICS
- Run update statistics on database, table, and
column
- View statistics on tables, columns, and indexes
- Improved support for triggers
- Create and alter triggers using Data Source
Explorer
- Enhanced General and Details tabs in the Data Object
Explorer
- Support for table fragmentation
- Perform table partitioning in the Data Source Explorer
view
- Choose "Round-Robin" or "Expression" distribution
scheme in the Data Object Editor
- Add, delete, or edit a partition in the Data Object
Editor
- Preview DDL on Table Partitioning and execute
- New features for Tables, Indexes, and Constraints
- Table Management: raw table, first extent size, next
extent size, lock level, DB Space
- Index Management: DB Space for an index to be created
in
- Constraint Management: A new Mode option to specify
"Enabled", "Filtering with error", "Filtering without
error", or "Disable" to manage a Informix constraint
(Unique, Check, or Foreign Key)
- Informix Model Migration for InfoSphere Data Architect 7.5.1
(IDA)
- Automatically migrate model when older physical models
are imported in IDA 7.5.1
For more information about and screenshots of some of these
Informix-specific features, see
Guy Bowerman's
blog entry.
IBM Integrated
Data Management vision
The IBM Data Studio product family and the IBM Optim family are both
part of a larger overall vision to create an integrated data
management environment that supports the entire data lifecycle, from
requirements to retirement. By focusing across the lifecycle and
enabling different roles to collaborate, the goal is to increase
organizational productivity and effectiveness, while improving the
quality of service, cost of ownership, and governance of diverse data,
databases, and data-driven applications.
Many key tools support IDS, including Data Studio Developer, and more
support is planned to roll out over time. For more information about
Data Studio and Integrated Data Management, see the article
"IBM Data
Studio software: The big picture"
(developerWorks, July 2008).
| |
