EclipseCon 2007 March 5-8, Santa Clara California





Do you speak my dialect? Editing, parsing, and building SQL with the DTP SQL Development Tools

Brian Payton (IBM)

· Long Talk

Tuesday, 13:30, 50 minutes | Room 203-204

7
·
8
·
9
·
10
·
11
·
12
·
13
·
14
·
15
·
16
·
17
·
18
·
19

poses a challenge for database tools such as SQL editors and query builders. When faced with multiple databases, data tool developers typically either take a "least common denominator" approach and give minimal support for all databases, or "hard code" deep support for one SQL dialect. The SQL Development Tools project within the Eclipse Data Tools Platform project provides a new approach. The SQL Development Tools project includes a framework and components that can provide deep support in data tools for any number of databases and SQL dialects. This talk will give an overview of the SQL parsers, models, and editor components, and how to use and extend them to create more sophisticated SQL-aware data tools. Also included will be an introduction to the new Query Builder tool being added to the SQL Development Tools project, which makes use of these components.

Brian Payton, a software developer in IBM Information Management Software, has been developing database tools, particularly query builders, throughout his 20-plus years at IBM. He co-leads the SQL Development Tools project within the Eclipse Data Tools Platform project. Mr. Payton has a B.S. in Computer Science from California Polytechnic University, San Luis Obispo, and works at IBM’s Silicon Valley Laboratory.

Floor Plan

Gold sponsors

Ingres logo

BEA logo

IBM logo

Business Objects logo

Klocwork logo

Windriver logo

Red Hat logo

Actuate logo

Silver sponsors

Compuware logo

Sybase logo

Google logo

Nexaweb

Activegrid

Genuitec

Instantiations

Cloudsmith

Code Gear

ACCESS

Oracle

Telelogic

Innoopract logo

Lynux Works

Media sponsors

Eclipse Magazine logo

GoingtoMeet.com logo

Methods and Tools logo

Eclipsezone logo

Addison-Wesley logo

Eclipse Magazin logo

Embedded Computing logo

SD Times logo

Enterprise Open Source logo

ACM Queue logo

TheServerSide Java Symposium

Eclipse Review logo

Software Test & Performance logo

Eclipse Developers Journal logo

Eclipse Source logo