Advanced Data Tools Logo
spacer
Consulting Training Tech Info Successes User Groups Our Company spacer
   
IBM Business Partner
 

We build FAST Informix Databases

 

Informix Webcasts from Advanced DataTools

 

New Informix Toys and Tools - NoSQL, Mongodb Support, Data Streams with Node-RED and new useful features and utilities by Tom Beebe

This is a replay of Tom Beebe's Webcast on December 15th, 2015. With the emergence of 'Internet of Things' (IoT) we are all collecting more data than ever. Every company wants to get as much data as possible and have it available for use as even faster. With this new mentality of getting data there quickly, new methods of application development have become common. With the focus squarely on the application it has changed how the database sits in the corporate structure. Informix has grown and changed to meet the changing needs of the data economy. In this talk we will be covering a number of the new features that Informix has introduced in the last several years to meet the era of Big Data. We also are going to talk about several complimentary utilities that work hand in hand with Informix to better manage and make sense of the volumes of new data coming in. We will explain what NoSQL is and why you should care about a new method to store and manage data. Also we will talk about the new REST and Mongo listeners and show how that is changing the face of how we can access our Informix data. Join us for this look over some of the new facets of the changing Informix landscape.

 

Informix Storage and RAID5 - Doing Storage the Right Way! by Art Kagel

This is a replay of Art Kagel's Webcast on October 20, 2015 on Informix Storage and the impact of RAID levels, why not to use RAID 5 and what RAID levels work best with modern databases.

 

Informix 4GL to Genero - Bring your code into the future by Lester Knutsen

Lester takes an Informix 4GL application written in 1993, called DBPrivileges, and guides you through the process of converting it into a modern application that can be run on Windows, Mac, iPad, Mobile or on the Web.

 

The basics of getting up and running with Informix (IoT) by Tom Beebe

This final webcast of the series will focus on installing and setting up Informix. Intended mainly for new adopters of the IBM Informix database product, Tom will demonstrate how this advanced and powerful database engine is simple to install and configure on just about any hardware.

 

Running an Informix Database Server on an ARM Computer by Tom Beebe

This webcast will explore some of the ARM-based computers that are available, and describe why ARM is such a good fit for an IoT solution. Tom will show how simple it is to install a full version of the IBM Informix database server on a low-power, affordable ARM-based Linux computer, and why the power and simplicity of Informix makes it ideal for an embedded IoT gateway.

 

Using Informix TimeSeries and the Internet of Things by Mike Walker

This webcast will describe Informix TimeSeries, why it is such a good fit for an IoT solution, and show how it can be used to efficiently store sensor data. Examples of querying TimeSeries data will be shown and then displayed on a web page served from a Beaglebone ARM computer. The sensor data will be pushed out to a cloud, and an example will be shown using APIs to retrieve the data and display it.

 

Introduction to Informix and the Internet of Things by Mike Walker

This is the first webcast in our series and will introduce Informix and the Internet of Things and give an overview of the different components. It will include a practical demonstration of data from sensors being stored on a Beaglebone Black ARM computer and pushed to the cloud. This webcast will show how simple sensor data can be read using an Arduino-based microcontroller and conclude with the data being received on the Beaglebone gateway.

 

Informix Performance Tuning using the Sysmaster Database (Updated) by Lester Knutsen

This is a replay of Lester Knutsens Webcast on March 24, 2015. Lester presented new scripts to monitor and tune your Informix Database server using the Sysmaster and Sysadmin Databases.  This is major update to Lester's most popular talk at the Informix user conferences over the past several years, "Exploring the Sysmaster Database". 

 

Best Practices for Informix Developers by Art Kagel

This is a replay of Art Kagels Webcast on February 17, 2015. Art Kagel, is an Independent consultant and IIUG Board Member, presented on programming, concurrency, and tuning applications against Informix. This is an update to the presentation Art did at our last Washington Area Informix User Group Meeting. (Note: there are a few problems with the sound, I tried to fix it as best as I could)

 

How to Secure your Data - Informix Column Encryption and Security by Lester Knutsen

Do you have an Informix database and need to encrypt columns with privacy information? Do you have time to change all of your production applications to implement encryption? Have you had a security or FISMA/DISA audit? Lester Knutsen will present how we have converted existing Informix databases to add column level encryption with minimal impact to your existing applications. He will demonstrate how to take an Informix database and change it to use encrypted columns with little impact to your front end applications using triggers, functions and Informix encryption. Lester will also discuss simplifying access using roles to grant and revoke privileges.

 

 

Webcast Tutorial Series: How to use PHP with Informix by Tom Beebe

 

Webcast 4: June 17 - PHP and Informix - Pulling it all together by Tom Beebe

This is the final of a series of four Webcasts, one a month, providing a tutorial on how to use Informix with PHP.

  • Creating a full fledged application using PHP and Informix.

 

 

Webcast 3: May 20 - What is a web form? Creating a form to insert and update data by Tom Beebe

This is the third of a series of four Webcasts, one a month, providing a tutorial on how to use Informix with PHP.

  • Introduction to what writing web based code really is
  • Using PHP to create simple and complex web based forms

 

Webcast 2: April 22 - Creating simple applications to get going with PHP by Tom Beebe

This is the second of a series of four Webcasts, one a month, providing a tutorial on how to use Informix with PHP.

  • Introduction to PHP classes, functions and database access

 

Webcast 1: March 18 - Getting up and running with PHP by Tom Beebe

This is the start of a series of four Webcasts, one a month, providing a tutorial on how to use Informix with PHP.

  • Installing PHP including PDO_Informix
  • Starting basic command line applications

 

Learning about Informix and the Open Admin Tool (OAT) By Thomas Beebe

The Open Admin Tool (OAT) is one of the most exciting and least talked about new features for Informix in the past few years. It is an open platform to manage your Informix instances through a convenient web interface. In this talk we will be breaking down how to get up and running with OAT and covering many of the basic tasks you can perform in it. Since version 11 was released many people have migrated up to it, however most of them have either not gotten OAT up at all or looked at it briefly and put it back down. Listen to the webcast and we will tell you why you want to go to the latest release of OAT and why you should be using it every day. Some of the highlights:

  • Get step by step instructions to getting it running on a variety of operating systems
  • Learn about monitoring replicated environments using your web browser
  • See different ways to get very easy to read visual guides to the health of your database
  • Learn how to safely give your Jr DBA the ability to add new space without having to worry every time he does
  • See how to browse your database without needing to use dbaccess or SQL
  • Find out how to easily get reports that you can give to management showing how much Informix is racing along

 

Informix Performance Tuning by Art Kagel

Art presents UPDATE STATISTICS in depth, dostats, and his other free utilities for monitoring and tuning an Informix database in his utils2_ak package. Topics covered will include:

  • Table Level statistics and data distributions
  • Fragment Level statistics and data distributions
  • Update statistics for procedure/function
  • Providing data distributions for User Defined Types
  • Dostats and the art of balancing distribution quality with runtime performance
  • Other useful utilities in the utils2_ak package

 

Fastest Informix DBA Contest 2013 Winners!

We had a great Webcast to announce the winners and discuss how they did it. We had a great number of entries, most of them international, and from which 4 contestants stand out.

 

New Informix Warehouse Accelerator 12.10 Benchmarks Webcast

This Webcast will demo and benchmark the Informix Warehouse Accelerator 12.10. Last year we showed it running 9 hours of queries in 14 minutes. Mike Walker will demonstrate our current benchmarks with this exciting new database technology. He will demonstrate ad-hoc queries on a bookstore database with 250 million customers and over a billion records in the fact table.

 

Fastest Informix DBA Contest 2013 Status Update Webcast

This is a replay of our Fastest Informix DBA Contest 2013 status update Webcast on August 20, 2013. This year the Fastest Informix DBA Contest will be held over the web so anyone, anywhere in the world can participate from July 9 to 31, 2013. The challenge will be a combination of OLTP and batch. The winner will be the DBA who can get the most transactions per minute in an OLTP benchmark and at the same time run a batch billing job and generate the most bills in a 10 minute run. For more information on the Fastest Informix DBA Contest click here!

 

Fastest Informix DBA Contest 2009 Results Webcast - How did they do it?

This is a replay from our Webcast in 2009 reviewing the results of our Fastest Informix DBA Contest. Congratulations to Tatiana Saltykova, New 1st place finisher in the Fastest Informix DBA contest. The challenge was to take a batch SQL job that took over 40 hours to run and optimize it and the Informix database configuration.

 

Fastest Informix DBA Contest July, 2013 Webcast to kick-off the contest

This year the Fastest Informix DBA Contest will be held over the web so anyone, anywhere in the world can participate from July 9 to 31, 2013. The challenge will be a combination of OLTP and batch. The winner will be the DBA who can get the most transactions per minute in an OLTP benchmark and at the same time run a batch billing job and generate the most bills in a 10 minute run. For more information on the Fastest Informix DBA Contest click here!

 

Informix Performance Tuning using SQLTrace, Remote DBA Monitoring and Yellowfin BI

Webcast Date: Tuesday, July 2nd, 2013 at 2:00 pm, EST

Lester Knutsen and Mike Walker will present a series of tools to monitor and tune your Informix Database Server.

 

 

Informix Performance Tuning using the Sysmaster Database by Lester Knutsen

Webcast Date - Tuesday, April 30, 2013 at 2:00 pm,ESTLester Knutsen

Lester presentednt new scripts to monitor and tune your Informix Database server using the Sysmaster and Sysadmin Database. This is based on Lester's most popular talk at Informix user conferences over the past several years, "Exploring the Sysmaster Database". We will show what is new with Informix 12.10.

 

 

Informix Performance Tuning by Art Kagel, Advanced DataTools Corporation

Webcast Date - Tuesday, March 12, 2013 at 2:00 pm, EST

Art went through the steps one takes to determine the health of the server and start Informix Database Performance Tuning:

  • Overall Performance
  • IO Performance
  • Tablespace Performance
  • Memory Performance
  • Virtual Processor Performance
  • OS Performance
  • Caches

 

 

Database Driven Websites - Using PHP with Informix by Thomas Beebe, Advanced DataTools Corporation

Webcast Date - Tuesday, February 12, 2013 at 2:00 pm, EST

What do Wikipedia, Facebook, Wordpress, and Yahoo all have in common? They all run on PHP. PHP is an open source server-side scripting language designed for Web development to produce dynamic Web pages. And it works great with the fastest database, Informix. In this talk we will be discussing how quick and easy it is get going in PHP and how to set up PHP to talk to Informix using the PDO driver library. You can easily use PHP to select, insert, update and delete data from an Informix database to create a database driven web site.

 

 

Fastest Informix DBA Contest 2012 Webcast - How did they do it?

Webcast Date - June 19th at 2:00pm EST

On Jun 19, 2012, we held a Webcast with the Fastest Informix DBA Winner Andrew Ford, hosted by Lester Knutsen and Art Kagel, to share with other Informix users how the winners achieved their results. Learn about the tips and tricks the real Fastest Informix DBAs used to achieve their remarkable performance.

 

More - Click here for Informix Data Warehouse Webcast Replays

Contact us for more information and to discuss your unique Informix database needs:

Call: 1-800-807-6732 x101
Email: info@advancedatatools.com
Click here to complete our Request for Information Form

 

 

 

   
spacer
spacer