Welcome to the 2015 Actian Technical User Group Conference


 
Date: Tuesday, 13 October
Location: London, Novotel London West
Time: 8:30 AM - 5:30 PM
Who: Engineers, Developers, Tech Support, QA
Cost: Free!
Where to Register: 2015 Actian Technical User Group Registration

We have a full day scheduled starting with registration at 8:30 and ending at 5:15 PM. The conference will begin with general sessions and then split into specific groups for Ingres, OpenROAD, PSQL and Versant.



Ingres

What's New and What's Next in Ingres and OpenROAD (Session for Ingres and OpenROAD)
This general session will bring you up to speed with recent developments in Ingres and OpenROAD with a focus on development roadmaps and future feature ideas for both products. This session will also cover plans for Enterprise Access and EDBC.
Speakers: Alex Hanshaw, Director of Engineering, Actian and Chris Clark, Manager Engineering, Actian

Streaming Real-time Flight Data Into Ingres from a Raspberry Pi
This session will cover the development of an application that collects and decodes ADS-B flight data using a Raspberry Pi. Apache Kafka provides a message queue, and using Dataflow, loads the data into Ingres 10.2 where it can then be accessed to automatically update (every 20 seconds) an HTML web page with embedded SQL and the Google Maps API. This example will offer a lot of interesting talking points for developers interested in taking advantage of Ingres 10.2's geospatial features.
Speaker: Mark Whalley, Principal Consultant, Actian

Using Ingres Query Recording and Playback Tools
Learn how to utilise the Query Recording and Playback tools to record every transaction in your production system and then play it back in your Dev/Test environments. Playback in an upgrade Dev/Test environment provides a way to greatly reduce the risk of an upgrade by closely replicating your production load against the next release upgrade.
Speaker: Sean Paton, Service Delivery Manager, Actian

HSS Case Study: Benefits of Using HVR
Find out how HSS have used HVR to maximum effect. From reducing upgrade downtime by an order of magnitude to improving performance in their production system by automatically streaming data into a separate reporting system so that production data can be more frequently purged.
Speaker: Jeremy Ruffer, Team Leader, Unix and Database, HSS Hire Service Group Ltd


Ingres Database Backup as a Cloud Based Service
This session explores the benefits of cloud based services: specifically for backing up production databases. We'll start by defining some common cloud terms (PAAS versus SAAS...) and usage scenarios with a focus on database backups. Attention is given to Ingres to start, but the same principles apply to PSQL and Versant. Included are details of a proof of concept project backing up Ingres in the Amazon AWS cloud. If time permits a demo of the cloud backup project will be shown.
Speaker: Jim Falgout, Chief Technologist, Actian

ConnectedIngres
Are you looking for ways to leverage ALL of your mission critical operational data? Do you want to increase productivity by automating manual integration processes - without the use of custom code? Attend this session to learn about ConnectedIngres, a version of Actian DataConnect create especially for Ingres customers that allows you to design, deploy and manage data integration with your Ingres application. We'll discuss common use cases, technical features, and demonstrate built-in Ingres integration samples.
Speaker: Heather Martin, Director, Integration Sales, Actian

Serving Ingres Data to Cloud Applications
Learn how to bring the speed and agility of SaaS applications to your Ingres data, by leveraging the power of Actian's enterprise-grade cloud platform! This session explores real use cases sharing Ingres enterprise data via the Cloud. We'll discuss how to prepare Ingres for this use case as well as how to use DataConnect to create a data hub.
Speaker: Vincent Vinot, Techincal Account Manager, Actian

Ingres Community Award
(Session for Ingres and OpenROAD)
Annual Award to the most respected member of the Ingres community.

OpenROAD

Using Modern HTML5 Web Techniques with OpenROAD as a Backend
Modern techniques are bringing more functionality to all kinds of devices through the browser. Using HTML5 and XML requests it is now possible to build full-blown single-page Web applications (SPA) with responsive design, making one code base usable on all devices, from tablets to computers and mobile phones. This talk shows some responsive SPA's we've designed for our customers using the OpenROAD Server with an Ingres database as a backend - making it possible to use our huge OpenROAD codebase in the most modern web applications.
Speaker: Thomas Christlieb, Software Developer, Cimdata Software AG

Loadnrun Real World Deployment: Fremantle Ports
Fremantle Ports is Western Australia's largest general cargo port and Australia's fourth larges container port. With seven separate applications built on multiple versions of OpenROAD on Ingres, and over 500 clients, Fremantle Ports had software management and deployment challenges. This session reviews how Fremantle Ports used Loadnrun to centrally manage new deployments, updates and version control, greatly reducing the complexity of managing their software with minimal change to their environment.
Speaker: John Tetlow, Technical Services Manager, Actian

Defined Behaviours in OpenROAD 6.2: Putting Them to Use
The ability to extend the set of automatic (defined instead of 4GL-coded-event) behaviours is one of the important new features in OpenROAD 6.2, allowing a much smarter and richer interface, and simplifying and freeing your 4GL code for more business-oriented purposes. This session will show you how to use defined behaviours to set up, using simple 4GL code, scheduled and mouse move/hover/press/drag behaviours that trigger styling, animations, drop downs, popups, and even custom 4GL responses as singleton, cascade and combination effects.
Speaker: Sean Thrower, Senior OpenROAD Software Engineer, Actian

Source Code Control Strategies with OpenROAD
This session will cover source code control strategies and tools in place at Actian for managing OpenROAD 4GL components. From the original Windows4GL Project, all OpenROAD components have been under source code control. Find out the best practices that have evolved over time for OpenROAD projects (large and small) around code management and review, as well as some new strategies being pursued by the OpenROAD Engineering team exploiting technologies such as GIT.
Speakers: Donald Criley, Architect, Actian and Chris Clark, Manager Engineering, Actian

Automating OpenROAD Testing
Regression testing is a key part of any development cycle, and this session will give insight into the automated testing techniques used by the OpenROAD team.
Speaker: Bodo Bergmann, Senior Software Engineer

PSQL


PSQL Product Roadmap: Near and Long Term (Including Btrieve 12)
This session will cover plans for PSQL products. Learn about the schedules and features for service packs and new releases, including Btrieve 12, the newest product in the PSQL family.
Speaker: Desmond Tan, Director of Engineering, Actian

PSQL for Mac OS X
This session will provide an introduction to the PSQL release that enables ISVs and OEMs to expand their customer base into the Apple community. Topics include installation, configuration and use of PSQL for Mac OS X. Porting of PSQL applications and migration of PSQL data from Windows and Linux to Mac OS X will also be discussed.
Speaker:
Tom Bates, Principal Software Development Engineer, Actian

Free Your Btrieve Data
Do you feel like your Btrieve data is inaccessible using modern tools? Is your data stuck behind the Btrieve curtain? We will discuss methods for taking your native Btrieve data files and making the data accessible to anyone (or anything) with a web browser.
Speaker: Jan Daley, Principal Software Development Engineer, Actian

Virtualizing PSQL
PSQL test activities have been more than 90% automated since 2005. Early in 2015, we began virtualizing all PSQL test machines, including every flavor of Windows, Linux and Mac OS X. First, we'll discuss the automation framework and how it enables wholesale virtualization. Then we'll discuss the effort to virtualize all 200+ machines in the Actian PSQL test environment. This session will also cover optimization and troubleshooting lessons learned while virtualizing these boxes and our experiences experimenting with Amazon Web Services and VMware vCloud Air to host test activities. Finally, we'll wrap up with a forward-looking discussion about how virtualization is evolving and how PSQL will play an important role in these new application architectures.
Speaker:
Jeff Chapman, Architect, Actian

Versant


Versant Object Database 9: Today and Tomorrow
This session will highlight the most important changes for existing customers and provide guidance for migrating existing applications to VOD 9. You will also learn how VOD will change in upcoming versions and what to expect from us in the future.
Speaker: Andreas Renner, Vice President of Software Engineering, Actian

Versant JPA 3: Enterprise Ready Java Persistence
In this session we will show the advantages of using Java Persistence API (JPA) mapping-free with an object database. We will also take a look at enterprise level features like runtime schema evolution and HA-support with Veritas Cluster.
Speaker:
Christian von Kutzleben, Chief Software Engineer, Actian

Increasing Query Performance with Polymorphic Indexes
Starting with VOD 9, we provide a new indexing subsystem which allows significantly faster query execution in real use case scenarios. This session will provide you with insights into the implementation, compare it with the existing indexing mechanism and discuss ways to monitor query execution.
Speaker: Andreas Renner, Vice President of Software Engineering, Actian

Optimizing Object Navigation Using Entity Graphs and Burst Fetching
In this session we will give an introduction to JPA's Entity Graphs and Versant JPA's Burst Fetching feature and show how they can be used to reduce the number of client/server round trips.
Speaker:
Christian von Kutzleben, Chief Software Engineer, Actian

Planes, Trains and Automobiles: Rapid Prototyping with Versant JPA
If you expect planes or automobiles, you might be disappointed. However, if you've come for trains, you most certainly won't be! In this session we show how quick and easy it is to get a project started with the power of the Java Persistence API (JPA) together with an object database. During the session, we will create a rapid prototype of a ticket reservation system for a small tourist railroad. Attendees can pick up a free copy of the DVD "The Train to Yesterday" (while supplies last) - a must have for every train buff!
Speaker:
Christian von Kutzleben, Chief Software Engineer, Actian

Questions?  Email alex.sherwood@actian.com