Informix Training in Pune

Features Of Informix

Informix HQ is a new web-based tool which replaces Informix Open Admin Tool (OAT) and provides many requested features:

• Modernized web console for monitoring, alerting, and administering Informix database servers.
• Provides critical performance management capabilities, monitoring how key performance metrics are changing over time and tracking how efficiently Informix is running your workload even when you’ve stepped away from your screen.
• Customizable alerting system so you can be immediately alerted through modern IT infrastructures like Pager Duty, Twilio, and email.
• Purpose built for scaling out and optimizing DevOps needs.
• Accessible from any desktop, laptop, or mobile device.

Integrated Encryption

The Informix Backup and Restore utilities (On-Bar, ontape, archecker, onlog) now have the capability to internally encrypt and decrypt dbspace, blobspace, smart blobspace and logical log backup data, using Remote Key Store servers that provide access to state of the art resources (entropy sources, key generators, centralized key management and rotation, etc. ) which are difficult to simulate in a stand-alone machine.

The same utilities also offer a simple way to encrypt and decrypt data using a locally provided static encryption key.

Remote Key Store for EAR

The encryption-at-rest (EAR) feature now supports the storage of encryption keys in an Amazon Web Services (AWS) account.

TSTAMP data type for TimeSeries

A new TSTAMP distinct type can be used when defining fields or parameters in TimeSeries.

Spatio-temporal Enhancements

• Support for projection systems other than World Geodetic System (WGS) 84.
• Support for new ESRI Shape and Projection Engine (PE) libraries.
• Added a “count” operation to return the number of times a moving object has passed a given location.

Backup to S3 cloud servers using V4 authentication

• The onpsm utility has been updated to support V4 authentication for the S3 protocol.
• We achieve this by allowing the utility to create devices with a new parameter ("–region") which will automatically enable V4 authentication in that device.

Common Table Expression

• A Common Table Expression (CTE) is a named temporary result set derived from a simple query and defined within the execution scope of a SELECT, INSERT, UPDATE, or DELETE statement.
• The CTE can be referred to later within that same statement, possibly multiple times. CTEs can be used recursively to simplify complex queries.

Atomic replacement of stored procedure

New SQL functionality provides “atomic” replacement of stored procedures (only). CREATE OR REPLACE PROCEDURE works differently than CREATE PROCEDURE IF NOT EXISTS, as CREATE OR REPLACE PROCEDURE will replace an existing function with the newer version of the procedure. CREATE OR REPLACE preserves existing schema dependencies.

Replication to SPL routine

Replication to SPL enables to apply data to a stored procedure instead of to a target table. SPL routine can be written using Informix stored procedure language, C or JAVA UDR.

The feature include:

• Realtime streaming analytics on OLTP data. Examples include:Asynchronously calculate per store sales report and Realtime leaderboard calculation for an online game.
• Data transformations. Example: While replicating data from retail stores to central home office, dynamically include data for store id column at home office server.
• Asynchronously update external systems like message queues, graph databases, and Hadoop file systems.
• Replicate data for tables that do not have primary key, ER key or unique index.

Asynchronous post commit triggers can be created using combination of “replication to SPL” and “loopback replication” functionality.

ODBC Smart Trigger

• A smart trigger is a set of commands issued to the database, that sets up a push notification when certain changes happen to data in a table.
• These changes are detected by a SQL query, that is run after INSERT, UPDATE, or DELETE commands are executed. ODBC's APIs can be used to get the real time Push Data notification from Informix server in ODBC applications. It is available across all ODBC supported platforms.