What s new in 9 30
This presentation is the property of its rightful owner.
Sponsored Links
1 / 29

What’s New in 9.30 PowerPoint PPT Presentation


  • 70 Views
  • Uploaded on
  • Presentation posted in: General

What’s New in 9.30. Joe Kennedy & Warren Heising IBM Software Group Data Management Solutions [email protected] [email protected] Overview. Administration and Usability Performance Enterprise Replication Application Development Extensibility. Usability – UNIX Bundle Installer.

Download Presentation

What’s New in 9.30

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


What s new in 9 30

What’s New in 9.30

Joe Kennedy & Warren Heising

IBM Software GroupData Management Solutions

[email protected]

[email protected]


Overview

Overview

  • Administration and Usability

  • Performance

  • Enterprise Replication

  • Application Development

  • Extensibility


Usability unix bundle installer

Usability – UNIX Bundle Installer

  • 0) All Products listed below (except JDBC 1.50)

  • 1) Informix Dynamic Server 9.30

  • 2) Informix IConnect

  • 3) Informix JDBC version 1.50 (should not be installed with JDBC 2.20)

  • 4) Informix JDBC version 2.20

  • 5) Informix System Administrator

  • 6) Configure a Demo IDS Server (requires IDS)

  • Enter the number of the products to install, separated by spaces

  • (i.e. "1 2 4"):

  • Simplifies installation of components

  • Installs components in correct order

  • Creates a demo server if needed

  • Supports role separation

  • Also supports ‘silent’ install


Usability isa 1 40

Usability – ISA 1.40

  • Server Setup

  • Remote monitoring

  • HDR compatibility

  • Connection counts

  • SQLHOSTS edit


Performance

Performance

  • Shared statement cache

  • Fuzzy checkpoints

  • Dynamic Logging

  • Dynamic Lock Management

  • MaxConnect support


Shared statement cache

Shared Statement Cache

  • Query plans shared between connections

  • Big benefits for sites with lots of users and only one or two applications

SELECT F.First,

B.Second

FROM Foo F, Bar B

WHERE F.A = B.A

AND F.C = :C1

AND B.C = :C2;

CPU-VP

IDS

Plan (C1, C2)

{

}

SELECT F.First,

B.Second

FROM Foo F, Bar B

WHERE F.A = B.A

AND F.C = :C1

AND B.C = :C2;


Fuzzy checkpoints

Fuzzy Checkpoints

  • Not all dirty pages are flushed

  • Write-ahead logging ensures consistency in a fast recovery

  • Shortens checkpoint duration

  • Allows larger buffer pools without impacting OLTP performance


Performance dynamic logging

New log

Performance – Dynamic Logging

  • Eliminates server hangs due to long transactions

  • New onconfig parameter DYNAMIC_LOGs

    • Server can automatically insert and use a new log file

    • DBA can also add new logs without quiescing the system

  • New logs are usable immediately

    • No need to archive rootdbs


Dynamic lock management

Dynamic Lock Management

  • IDS will add locks on the fly if lock table overflows

  • Prevents application hangs

  • Message written

    • DBA can adjust lock table size later


Performance maxconnect

SQL Clients

MaxConnect

IDS

Performance - MaxConnect

  • Multiplex database connections

  • NO CHANGE required for existing applications

  • Increase scalability

  • Reduce response times


Enterprise replication

Enterprise Replication

  • Improved Performance

    • DataSync dynamic parallelism

    • Stable queue management improvements

    • Partial update row support

  • Extended Support

    • SBLOB support

    • Opaque data type support

  • Miscellaneous

    • Support for serial primary keys

    • Inplace alter for CRCOLS

    • Replicate Sets


Application development

Explain without Execute

Configurable default log mode

Statement memory usage

REVOKE ..AS USER

DELETE TABLE (no FROM)

Support for MTS/XA

Application Development

  • $ onstat -g stm 8

  • Informix Dynamic Server Version 9.30.xx --On-Line-- 1024 Kbytes

  • session 8 ---------------------------------------------------

  • sdblock heapsz statement ('*' = Open cursor)

  • a97b018 10424 * select * from tb

  • a97b110 8368 insert into tb values (?)

  • a97b208 5120 <SPL statement>


Server studio java edition

Server Studio Java Edition

  • Database Object Explorer

  • SQL Editor

  • Table Editor

  • Other tools are available from AGS, including a stored procedure debugger.


Extensibility

User-defined types (UDT’s)

Distinct, opaque

Table/type inheritance

Functional indexes

R-Tree indexes

Smart large objects

Complex types

Row, set, multiset, list

Polymorphism

User-defined routines (UDR’s)

User-defined aggregates

Primary/secondary access methods

Extensibility

Benefit: The database adapts to suit your business


Udt s and udr s

UDT’s and UDR’s

  • User-Defined Data Types (UDT’s)

    • define your own data structures

    • e.g. a parts explosion stays a parts explosion

    • the database accommodates the “shape” of the data

  • User-Defined Routines (UDR’s)

    • define your own operations

    • a single statement replaces a procedure

    • put business logic in the database


A trivial but powerful example

A Trivial but Powerful Example

Create a user-defined function….

create function area (radius real) returning real;

return radius * radius * 22 /7 ;

end function;

Then you can…

select id, area(radius_col) as the_area from mytable

where area(radius_col) < :QArea ;And also… CREATE INDEX mytable_ndx1 ON mytable (area(radius_col) );

Benefit: Put your business logic in the server!


A more complex example

A More Complex Example

  • Raise the level of abstraction at the database level.

  • Buy components to solve common problems, and build components to achieve a competitive edge

-- Object-Relational System

--

CREATE TABLE e_Yellow_Pages (

Name VARCHAR(128) NOT NULL,

Business Business_Type NOT NULL,

Description Document NOT NULL,

LocationGeoPoint NOT NULL,

Occupied SET(Period NOT NULL )

);

-- “Show me available service stations specializing

-- in Porsche brakes within 30 Km of where I am?”

--

SELECT Y.Name

FROM e_Yellow_Pages Y

WHEREContains ( Y.Location,

Circle(:GPS_Loc, ‘30 Miles’ ) )

AND Y.Business MATCH “Automotive Service”

ANDDocContains(Y.Description,

“Porsche AND brakes”)

AND NOTBooked (Y.Occupied,

Period(TODAY,TODAY+5));

--


Virtual table interface vti

External Data

Excel Worksheet

Client

Browser

Excel

Other...

External Data

Database

Table

IDS

Virtual Table Interface (VTI)

  • Integration of external data

  • A single interface that uses a single access mechanism for ALL data

  • Transparent to users

Benefit: meets the heterogeneous reality that most users confront


Java in the server j foundation

Clients

APPLET

Java DBDK

JavaBean

JavaBean

EJB

JavaBean

RMI / Corba / IIOP

WEB SERVER

APPLET

JavaBean

JavaBean

Java

EJB

EJB

JVM

Java-in-the-Server: J/Foundation

A Java Virtual Machine

  • Java stored procedures

  • Java DataBlades

  • INTEGRATED, not bolted-on!

B


Datablade modules

DataBlade Modules

  • Use where relational doesn’t solve business problem

  • New data types (spatial, text, video, etc.)

  • Plug-ins that function as integral part of server

  • Incorporate new data types to your business without having to start from scratch

    Benefit: the powerful functionality you need, built into the server


Informix datablades

Informix DataBlades

  • TimeSeries, NAG and RealTime Loader

  • Spatial

  • Geodetic

  • Excalibur Text Search

  • Video Foundation

  • Image Foundation

  • C-ISAM

  • Web


Excalibur text datablade

Excalibur Text DataBlade

  • Full text indexing

  • Extremely rapid query results

  • Support for over 200 file formats

  • Highlighting of text "hits" within original documents

  • Automatically indexes text in virtually any format

  • Feature-rich

    • Thesaurus support

    • Multiple stop-word lists

    • Boolean, phrase, proximity searching


Using time series data

Using Time Series Data

Blades:

Shared Memory

TimeSeries

Real-time

Market Feeds

NAG

Traders

Reuters

RTLoader

Bloomberg

IDS

Bridge

Analysts

Disks

B


Spatial datablade 8 11

Spatial DataBlade 8.11

  • Provides

    • R-tree indexing

    • Support for ER

    • Nearest neighbor function

  • Includes

    • A data loader

    • A Java-based visualization tool

    • Worldwide sample spatial data


What ids 9 30 beta customers say

What IDS 9.30 Beta Customers Say...

“What I like most about Informix products and particularly IDS 9.3 is the ease-of-administration, efficiency, and its ability to work well with OLTP... The replication technology in IDS 9.3 improved our transaction processing from 400 to 1200 per second.”

David Link

DBA

West Interactive


What ids 9 30 beta customers say cont d

What IDS 9.30 Beta Customers Say (cont’d)

“Informix has always had a reputation as a heavy lifter in the database world... The performance related features of Informix IDS are a DBA’s dream.”

Jon Lusty

DBA

Berkley Information Systems


Product roadmap

Product Roadmap

  • Remove scalability limits

  • Further simplification of manageability

  • Integrated support for other IBM products

  • Maintain openness

  • Other features still under evaluation


Summary

Summary

Smart optimization

minimizes tuning

overhead

Easy overrides

when necessary

Business logic in the database

Reliable data replication across a global organization

Performance for the Real World


Ibm informix dynamic server 9 30

IBM Informix Dynamic Server 9.30

IBM Software GroupData Management Solutions


  • Login