Provisional Agenda - Subject to change
Opening Remarks (Marty Bowes, CTSU)
Keynote: The Age of Data (Mike Hoskins, CTO,
Product Integration Plans (Mike Hoskins)
If you think you know dashboards, think again!
Data Replication is Hot Again (Henk Snippe,
Ingres and OpenROAD update (Emma McGrattan, SVP
Feedback from Ingres and OpenROAD dev sprints
Customer Support Portal (Pam Fowler, VP
Connect, Analyse, Act
Mark Van de
Exec Q & A
Closing Remarks (Marty Bowes)
Cheese & Wine
Title: If you think
you know dashboards, think again!
MacCormick, Chief Product and Marketing Officer, Antivia
Savvy organizations recognize that
interactive dashboards are almost always the best way of delivering
BI to end users (big-data being no exception) and it is no surprise
to see that dashboards are ranked as the #1 priority for expansion
and innovation in Cindi Howson's 2012 Successful BI Survey. Find out
just what is so special about the new breed of interactive dashboard
and why they offer such a superior way of delivering BI to end-users
over the self-service model.
Replication is Hot Again
Speaker: Henk Snippe,
CEO, HVR Software.
Data replication has
not been a trending topic in the IT in the last decade. Replication
did persist in operations for High Availability (DR) and
some specific cases for real time distribution of data across
applications. But times have changed; The growing need for
real-time Business Intelligence from multiple data sources has put
data replication right back on the agenda. This presentation
tells you why.
3.0 New Features and Roadmap
Speaker: Mark Van de
Wiel, Director Product Management – Vectorwise, Actian Corp.
Vectorwise 3.0 is the
latest release of the world's fastest database.
introduces exciting new capabilities including more Analytical SQL
functions, enhanced monitoring capabilities, better compression, a
high performance connector from data in Hadoop, and much more. Attend
this session to hear first-hand from Vectorwise Product Management
how these capabilities expand the possible use cases for Vectorwise.
Also, learn more about upcoming new capabilities post Vectorwise 3.0.
Going Spatial with Vectorwise - Patterns and
Mitchell, Engineering Director, Actian Corp.
Learn a few patterns
for storing and interacting with basic geospatial data in a
Vectorwise database. Building on the efficiencies of
Vectorwise, you'll be able to take what you learn here and try it
yourself, as no special add-ons are required. These pre-beta
concepts will help developers and integrators get the juices flowing
for what is possible.
Title: A Peek into
the Vectorwise black box
Speaker: Karl Schendel,
and tips to aid administrators in first level debugging of Vectorwise
problems. This session includes an architecture overview, a look at
the new directories in Vectorwise, X100 algebra and how to read it,
and info on query profiling.
replication into Vectorwise
Speaker: Steve Sheil,
CTO, HVR Software.
This session is about
the challenge of doing high performance replication into Vectorwise.
We will highlight techniques for set-wise data loading which leverage
Vectorwise's architectural strengths to boost performance
considerably. These proven techniques have been incorporated in
HVR version 4.5 but will be of broad general interest to all
Don’t call us, we’ll call you: Revealing the mysteries of
the XMLParserCallbacks class
Bodo Bergmann, Senior Software Engineer – OpenROAD Worldwide
Development, Actian Corp.
session provides an in-depth view of the new feature of the upcoming
will answer a series of questions, e.g.:
is a callback?
are XML parser callbacks useful for?
does the XML parser call what?
to define a callback procedure?
does a callback procedure cannot do?
to tell the parser which procedures should be called when?
session will also provide several usage examples, e.g.:
parsing after getting the information required.
memory overflow by discarding parsed elements.
very big XML files into a database.
Sneak Peek at OpenROAD 6.2's Sprites - Can it be that easy?
Joe Kronk, Senior Architect, Actian Corp.
What are they trying to do, make OpenROAD into a game development
platform? The answer to that question is no, but
sprites make it possible to create displays previously considered
impossible with OpenROAD. Join us for an in-depth look at some
new user classes that allow you work with small actionable graphic
elements. See for yourself how this can revolutionize your
existing applications, and imagine the possibilities for new
initiatives. After this sneak peek at OpenROAD
Sprites you will be able to answer for yourself this question: Can it
be that easy?
and Dogs – How to domesticate list-handling to obey your
application’s every whim
Speaker: Sean Thrower,
Senior Software Engineer, Actian Corp.
To handle sets of
business items, OpenROAD provides you with two representations:
customized and type specific Arrays (cats); and dynamic,
optimized, generically structured ChoiceLists (dogs). Cats and dogs
are complementary: cats provide focused browsing and editing via
TableFields; dogs provide at-a-glance selection via five different
types of ChoiceField; between them they cover the range of multi-item
handling that most applications require.
To get the best
results, dogs in particular must be approached in the right
way. This presentation begins with a common requirement – how
to provide row-specific dropdown lists in TableFields – to
illustrate some key techniques; then follows with advanced techniques
for building lists from a range of source types (database, files,
datastrings, arrays, master-lists). The session will also give you
the opportunity to raise and discuss other list-handling issues you
may have, so come prepared!
OpenROAD Status and Roadmap.
Joe Kronk, Senior Architect, Actian Corp.
is an exciting time for OpenROAD developers, with major new features
available in the last two releases; OpenROAD 6.0 is seeing a lot of
uptake due to the single-byte, multi-byte and Unicode support
provided. We are interested in any challenges you may be facing or
have faced with the migration to this release so we can continue to
improve your OpenROAD experience. The next release of OpenROAD
provides graphical features you can use to enhance the appearance of
your applications and improves deployment options. The
feature set of this release is completely defined and nearing
completion, but to polish the features you actually use, OpenROAD
development must now focus on how to make these powerful features
easy to use. This is a perfect time discuss challenges you
face-using OpenROAD, and join us for a lively discussion about
product improvements that could help alleviate some of these
challenges. Come prepared to participate with your challenges,
questions, and OpenROAD needs!
start-to-finish workflow in Ingres 10S
Mitchell, Engineering Director, Actian Corp.
See Ingres 10S
Geospatial capabilities in action: from ETL operations and data
loading to publishing your data as web based maps. Viewing and
editing geospatial data in desktop mapping application is also
covered. This session aims to give a broad idea of what is
possible, out-of-the-box with the latest version of Ingres. The
examples show how to make it as painless as possible to get started
and to also plug Ingres into other products like Tableau or custom
MOHAIR: Why fuzzy strings are 2.7 times more fun than regular
Speaker: Marty Bowes,
DBA, CTSU, Oxford University.
Project Mohair is an
OpenSource project in which extra soundex style functions and string
distance metric functions were created to be included within the
This presentation will
focus on using fuzzy logic for string matching within an Ingres DBMS.
It will start with the standard predicates such as LIKE and SIMILAR,
discussing some of the 'gotchas' which can entertain a programmer. It
will then move into using the SOUNDEX functions available within
Ingres and from here discuss the extra SOUNDEX style functions and
related string distance functions such as LEVENSTEIN developed in
Project Mohair to aid in fuzzy logic pattern matching and ranking.
ETL – FME and Ingres
Speaker: Dean Vernon,
Principal Support Engineer, Actian Corp.
An overview of the ETL
tool FME Desktop and the Ingres 10S spatial database.
Analyse, Act” track abstracts
Title: Action Apps
v2 – Delivering Automated Business Actions from Real-Time
Changes in Your Data
Speaker: Dave Postle,
Vice President of Services, EMEA, Actian Corp.
Action Apps (freely
available on the Apple App Store) allow business users to react in
real time whenever significant business events happen, and to trigger
an automatic action in response, all created and managed from your
smartphone. Dave will demonstrate Action Apps, discuss how the
cloud-based platform works, and how this platform demonstrates the
integration of Ingres, Vectorwise and Data Integrator.
and Analyze at Scale: A Dataflow Architecture for High-Speed
Data Preparation and Analytics
Jeff Gullick, Actian Principal Solutions Engineer
organizations seek the most high-impact ways to drive business
opportunity from their data assets, the ability to conduct data
preparation and analytics at scale, even on the largest datasets, is
imperative. The Actian dataflow architecture behind
RushAnalytics leverages vertical and horizontal partitioning and
pipelining to enable “Connect” and “Analyze”
across large and diverse data to identify formerly undetected
patterns and rapidly iterate through various modeling variables.
Learn about use cases and customers for these capabilities, and take
a dive into the architecture and its support for both scale-up and
scale-out patterns (including Hadoop cluster execution). A
hands-on demo shows Connect and Analyze at scale as we read
data from Ingres, prep the data and then execute analytics before
loading into Vectorwise.
Director 1.1 Release, and preview of data loader wizard for
Chris Hane, Director of Engineering, Actian Corp.
Many changes have been
incorporated into the latest version of the database management tool
“Director”, version 1.1.
This talk presents an
overview of the product, with a live demo of the various utilities
and functions. Also showing the new data loader wizard, which
is functional for Vectorwise currently.
Automated Monitoring and Management of Ingres and
Mark Whalley, Principle Consultant, Actian Services, Actian
has recently released the Enterprise Management Appliance v2.0, which
allows Ingres and Vectorwise users to monitor their installations and
receive alerts when things don't quite go according to plan. Come
along to this session to see a demo of the tool, and hear of the
unique new features that will allow you to increase the reliability
and uptime of your applications and databases.