UKUUG

(the UK's Unix & Open Systems User Group)

Home

Events

Databases and the Web

Tuesday 16th October 2007. 9:30 — 5pm
Imperial Hotel, London WC1B 5JS

Provisional Schedule

MySQL Database for High Availability Web Applications - Tushar Joshi
PostgreSQL Web Projects: From Start to Finish - Simon Riggs
Tuning Tips for Linux and AIX to run a Database - Nigel Griffiths
Introducing Oracle Application Express: Database application development for the web in no time flat - Julian Lane
DB2 on Linux for Web Development - John Pickford
iPlayer Server-Side: The Evolution of an XML Tool-Chain - Matthew Browning

The Seminar finishes at approximately 17:00 when delegates will be invited to join UKUUG Council members and speakers for a free drink in the hotel bar.

Costs:
UKUUG members: £99.87 inc. VAT
Non-members: £146.87 inc. VAT
-->

Booking: online or PDF for printing.

Location: Imperial Hotel, Russell Square, London WC1B 5JS

Talk Details:

MySQL Database for High Availability Web Applications

MySQL has built strength in the commercial world as a serious database for web applications beating others in benchmark tests. This talk will focus on the features MySQL 5/5.1, deployment, high availability and tools, along with methods of connection to MySQL for web applications and comparing benchmarks for certain web applications with other database, operating system and hardware architectures. (Slides).

Tushar Joshi founded and runs the London Linux User Group as well as running a software company in London that writes C and C++ applications.

PostgreSQL Web Projects: From Start to Finish

Making best use of PostgreSQL database technology in your web projects requires understanding, clear thinking and planning. The speaker will explain some key features and capabilities from a technical perspective, as well as how these can influence project planning and evolution following the initial phases. Various case studies will be referenced. (Slides).

Simon Riggs
Major Developer, PostgreSQL Global Development Group and Database Architect, 2ndQuadrant
Simon Riggs is a Database Architect with 20 years professional experience with performance-critical database design for OLTP, Data Warehouse and Web databases. Working with startups and multinationals he has driven changes across many technology waves. As a Major Developer for the PostgreSQL project Simon has personally contributed the following features: Point in Time Recovery (8.0), Partitioning (8.1), Sort improvements and Warm Standby replication (8.2). As a PostgreSQL consultant he has assisted numerous projects across the UK and Europe.

Tuning Tips for Linux and AIX to run a Database

Sitting behind any reasonable size website is some sort of database to hold the data involved. This can be used to control the web output, user records or profiles or regular database contents which are made available or manipulated via web applications. It is key then for the database to perform well in its support of the user experience. This session looks at the common causes of database performance problems with the aim to make sure you don't fall into these common traps. This is practical advice from the presenter's wide experience of Linux and UNIX support and tuning, and not database vendor specific." (Slides).

Nigel Griffiths
IBM Technical Support, Europe - Linux On Power Technical Advocate Europe & Virtualisation Technical Focus Group Leader

Introducing Oracle Application Express: Database application development for the web in no time flat

Oracle Application Express (APEX) was released in 2004 as a standard feature of all editions of Oracle 10g. Since then it has become very widely adopted by companies of all sizes on a range of UNIX, and especially Linux, platforms. APEX enables both technical and business users to build tactical HTML applications that are scalable, secure and flexible on top of Oracle tables in as little as five minutes. It includes simple and easy ways with which to create tables from external files. It requires no programming skill but can deliver very sophisticated and attractive web pages that can be tailored using a combination of PL/SQL and standard CSS, and HTML techniques. The presentation will explain what APEX is, how it works and why it has been called MS Access on steroids. Demonstrations will be included. It will also introduce the related topic of migrating other databases to Oracle, as this is often prompted by the use of APEX. (Slides, datasheet, case study).

Jules Lane.
Principal Sales Consultant, Oracle New Business Technology Sales Consulting, Manchester, UK

DB2 on Linux for Web Development

How to develop both relational and XML-based applications for free with DB2 will be presented. It will be explained how XML is changing the database requirements for new and existing systems, how DB2 addresses this with its unique PureXML support and how both SQL and XML applications can be developed and run in production on Linux and other Unix platforms. The session will cover a brief level-set on DB2, how both SQL and XML are supported natively, the development environment and where and how to get support. (Slides).
John Pickford
IBM Consultant IT Specialist

John Pickford has worked in a variety of Technical roles in Informix and then IBM. He has been particularly concerned with database extensibility (analytics, time series, spatial) and more recently with XML related database functions.

iPlayer Server-Side: The Evolution of an XML Tool-Chain - Matthew Browning

details coming soon