Implement Schema Editing Based on Delta DDL
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.