Thursday 11.11.2010

RoomTimeDescription
A09:00-09:15Opening session
A09:15-11:00Vlad Khorsun: New features in SQL language
-11:00-11:30Coffee break
A11:30-12:30Holger Klemt: Database conversions: UTF8 and other character set targets
B11:30-12:30Roman Rokytskyy: (moved to A15)
-12:30-14:00lunch break
A14:00-15:00Frank Ingermann: Managing recursive, tree-like data structures with Firebird I
B14:00-15:00Jiri Cincura: New features in .NET provider for Firebird
-15:00-15:30Coffee break
A15:30-16:30Frank Ingermann: Managing recursive, tree-like data structures with Firebird II
B15:30-16:30better office: How to replace InterBase® with Firebird?
-16:30-17:00Coffee break
A17:00-18:00Holger Klemt: Writing 32 + 64-bit UDFs for Firebird using Pascal language with Lazarus and Freepascal, native multi-platform development for Windows, Linux, Mac, 32 and 64 bit
-19:00-23:00Evening event



Friday 12.11.2010

RoomTimeDescription
A09:00-09:15Day 2 overview
A09:15-11:00Vlad Khorsun: ODS related optimizations in Firebird 3
Holger Klemt: IBExpert licensing & integration
-11:00-11:30''Coffee break' '
A11:30-12:30Holger Klemt: Turbo Firebird: A Firebird performance comparison: 32/64 bit, virtual machines, multicore, ramdisk, harddisk, Linux, Windows, monitoring, etc.
B11:30-12:30Roman Rokytskyy: Transparent JDBC replication with Firebird
-12:30-14:00lunch break
A14:00-15:00Thomas Steinmaurer: Open Source OLAP Environment with Firebird
B14:00-15:00NN:...
-15:00-15:30Coffee break
A15:30-16:30Roman Rokytskyy: Using Open-Source BI Tools with Firebird
B15:30-16:30Jiri Cincura: Connecting to Firebird using .NET provider from various devices - iPad, iPhone, Android, Windows Phone,...
-16:30-17:00Coffee break
A17:00-18:00Thomas Steinmaurer: Firebird 2.5 architectures comparison
-19:00-23:00Evening event



Saturday 13.11.2010

RoomTimeDescription
A09:00-09:15Welcome and Day 3 overview
A09:15-10:15Vlad Khorsun: Firebird 3. Initial review By Dmitry Yemanov
A10:15-11:00Thomas Steinmaurer: Trace API technology and tools
-11:00-11:30''Coffee break' '
A11:30-12:30Roman Rokytskyy:Developing modern Rich Internet Applications with Java and Firebird
B11:30-12:30Holger Klemt: Part-time foreign keys: using flexible triggers to replace declarative foreign keys
-12:30-14:00Lunch
A14:00-15:00IBExpert: IBEBlock scripting Language
B14:00-15:00Thomas Steinmaurer: Server-side programming techniques
-15:00-15:30Coffee break
A15:30-16:30Firebird, Apache and PHP-based web application: basic technology for mobile browser access, including iPad, iPhone and Android
B15:30-16:30Jiri Cincura: Creating services for rich internet applications using Firebird and the OData protocol
A16:30-17:30All Speakers: Round Table
A17:30-18:00Closing Session


Overview

A01 - Opening
A02 - Vlad Khorsun: New features in SQL language?
This year is Firebird's 10th anniversary, so we will look at past, present and future releases of Firebird. We will recollect most important features introduced in Firebird in version 2.1, take more detailed look at current version 2.5 and look forward at new features already implemented and planned for v.3
A03 - Holger Klemt: Database conversions: UTF8 and other character set targets
Is the owner of your database still SYSDBA? Do you want to change the owner? Have you started your development before you knew the advantages of character sets? Are you still working with character set NONE? Or do you want to transfer your existing database to UTF8? We will show you the solutions to convert your databases.
B03 - Roman Rokytskyy:Using Open-Source BI Tools with Firebird
A04 - Frank Ingermann: Managing recursive, tree-like data structures with Firebird I

approach to recursive data storage and retrieval.

B04 - Jiri Cincura: New features in .NET provider for Firebird
New protocol features implementation. More support for tools around ADO.NET world. And some sneak peek previews of upcomming features.
A05 - Frank Ingermann: Managing recursive, tree-like data structures with Firebird II
B05 - better office: How to replace InterBase® with Firebird?
Do you still pay for InterBase® licenses, even if you would prefer to switch to Firebird? And all your customer databases should also be changed automatically! This session provides an overview of the conversion process and the steps required to replace InterBase® with Firebird, followed by a brief overview of Delphi usable components to automatically replace the BDE and IBX data access components. This session is held by our sponsor better office.
A06 - Holger Klemt: Writing 32 + 64-bit UDFs for Firebird using Pascal language with Lazarus and Freepascal, native multi-platform development for Windows, Linux, Mac, 32 and 64 bit.
A lot of Firebird users still work with Delphi, but Delphi still has no support for 64-bit software and other operating systems such as Linux. In this session you will see how easy it is to write a 64-bit UDF using the open source development software Lazarus and other useful software running natively on the most important operating systems.
A11 - Good Morning
A12 - Vlad Khorsun: ODS related optimizations in Firebird 3

major change. ODS12 contains few important features to make some IO-hungry operations such as sweep and natural scan more efficient. I'll show in details what was changed and how this changes will affect performance.

A12A - IBExpert: IBExpert Licensing and integration
A13 - Holger Klemt: Turbo Firebird: A Firebird performance comparison: 32/64 bit, virtual machines, multicore, ramdisk, harddisk, Linux, Windows, monitoring, etc.
You need more speed in your database? In this session you will learn many tricks to detect performance leaks. We will also show a comparison between 32- and 64-bit operating systems and basic configuration improvements.
B13 - Roman Rokytskyy: Transparent JDBC replication with Firebird.
A14 - Thomas Steinmaurer: Open Source OLAP Environment with Firebird
Answering analytical and/or business questions based on existing business data becomes more and more important for management, key users etc. Established data warehousing (DWH) and OLAP techniques allow just-in-time multi-dimensional ad-hoc queries on a set of stored data.
This session discusses an open source OLAP environment using Firebird as the relational backend.
B14 - NN:...
B15 Jiri Cincura: Connecting to Firebird using .NET provider from various devices - iPad, iPhone, Android, Windows Phone,...
In this session we'll explore opportunities to use .NET provider, thanks to its nativeness, to connect to a server from non-classic-PC devices like iPad, iPhone, Android or Windows Phone.
A16 - Thomas Steinmaurer: Firebird 2.5 architectures comparison
Firebird 2.5 introduces a new architecture called SuperClassic, which is a mix of SuperServer and Classic Server. Hereby Firebird 2.5 now offers four architectures to choose from: SuperServer, Classic Server, SuperClassic and Embedded.
This session compares these architectures from a high-level technical point of view with their advantages and disadvantages.
A21 - Welcome

By Dmitry Yemanov ||

unified server architecture, shared page cache implementation, ODS changes, new SQL features and more. Also we will speak about development goals for this release and release schedule. I'll present just planned for development and\or research features and already implemented ones also

A22a - Thomas Steinmaurer: Trace API technology and tools
A23 - Roman Rokytskyy: Developing modern Rich Internet Applications with Java and Firebird
B23 - Holger Klemt: Part-time foreign keys: using flexible triggers to replace declarative foreign keys
One of the strong features in Firebird is the flexible declaration of foreign keys to maintain referential integrity. But there are sometimes reasons where it is preferable to work without foreign keys, for example, mass operations can be done much faster without foreign keys. But if you still need the data integrity, you should not delete foreign keys. We show a simple way to replace the declarative foreign key with simple trigger constructions and how they are simply ignored for mass operating users.
A24 - IBExpert: IBEBlock scripting Language
B24 - Thomas Steinmaurer: Server-side programming techniques
One of the most important features of a full-featured RDBMS like Firebird compared to a file-based database is its ability to compile and run embedded procedural code on the server as stored procedures and triggers.
Triggers are executed in response to a data manipulation language (DML) operation, whereas stored procedures are invoked from the client application, from another stored procedure or a trigger.
This talk provides an introduction to PSQL and its usage in stored procedures and triggers with the help of accompanying examples, targeted at people who are new to server-side programming in Firebird.
A25 - Holger Klemt: Firebird, Apache and PHP-based web application: basic technology for mobile browser access, including iPad, iPhone and Android
Your customers require mobile support? Will an app for Apple's iPhone, iPad or iPod be the right choice? Or will the end user prefer Windows mobile? Or are Android devices already the best choice for the future? Writing native apps for these platforms typically means rewriting everything for each platform. In most cases, a browser-based application is a much more flexible way, since it can be used on all platforms and all data can be immediately stored inside your Firebird database. You will receive a basic introduction and see how easy you can display data on a web-enabled mobile device.
B25 - Jiri Cincura: Creating services for rich internet applications using Firebird and the OData protocol.
Creating web services with results in JSON and AtomPub formats using REST to easily support all new rich internet applications ("web 2.0" buzzword) while using Firebird as storage.
A26 - Vlad Khorsun:
A27 - Closing