Implement Schema Editing Based on Delta DDL

Dafan Yang (Sybase), linsong (Sybase)

Data Tooling · Tutorial
Presentation
Monday, 13:30, 2 hours | Room 202 | Download in iCal Format

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

The main target of this tutorial is to guide the audience to build DDL and Delta DDL generators, hence to implement the database schema editors. A basic knowledge of Data Tooling Platform (DTP) and EMF is required. We will have 3 steps: 1.Very quickly go through the architecture of DTP to give the user a basic understanding; 2.An in-depth explanation of DDL and Delta DDL generator framework and show how to build the generators for a specific database; 3.Based on the Delta DDL generators we will show how to build a multi-page editor (Actually, one can also employee GMF to build a visual schema editor) for database object schema. At this point we will take table as an example to do the demo. The schema editors are one type of consumer of delta DDL, there can be a lot of other types of consumers such as database comparison/migration, thus they can serve as a basic library for database tooling. To help the developers to quickly develope an editor for a specific database type, an exemplary implementation demo and source code will be provided.

Dafan Yang is a software engineer at Sybase R&D Center located in Shanghai, China, working nearly three years on Database Development Tooling project, which is a part of Sybase WorkSpace®product-- an Eclipse based SOA IDE. Dafan Yang has near 5 years of software industry experiences using Java and Eclipse and he has given a short tutorial about SQL Development Tooling Frameworks of DTP in EclipseCon 2007

Lin Song is a software engineer at Sybase R&D Center located in Shanghai, China, working two and half years on Database Development Tooling project, which is a part of Sybase WorkSpace®product-- an Eclipse based SOA IDE. Lin Song has near 7 years of software industry experiences using Java and Eclipse.

Floor Plan

Gold sponsors

BEA logo

IBM logo

Wind River logo

Replay Solutions logo

JBoss logo

SOPERA logo

Cloudsmith logo

BIRT Exchange logo

Skyway Software logo

Oracle

BlackBerry logo

AMD logo

Silver sponsors

Sybase

Google

Genuitec

Instantiations

Teamprise

Telelogic

Innoopract

Business Objects

LynuxWorks logo

Hardware sponsor

AMD logo

Media sponsors

Extension Media

Methods and Tools

ACM

Addison-Wesley logo

SD Times logo

Open Systems Publishing

Software Test & Performance logo

SDForum

Be a Sponsor