| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> |
| <HTML> |
| <HEAD> |
| <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252"> |
| <TITLE></TITLE> |
| <META NAME="GENERATOR" CONTENT="OpenOffice.org 2.0 (Win32)"> |
| <META NAME="CREATED" CONTENT="20051027;10375000"> |
| <META NAME="CHANGED" CONTENT="20051122;18284925"> |
| <STYLE> |
| <!-- |
| @page { size: 11in 8.5in; margin: 0.79in } |
| P { margin-bottom: 0.08in } |
| TD P { margin-bottom: 0in } |
| TH P { margin-bottom: 0in } |
| --> |
| </STYLE> |
| </HEAD> |
| <BODY LANG="en-US" DIR="LTR"> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=CENTER STYLE="margin-bottom: 0in; font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=4>Data |
| Tools Platform (DTP) Project 1.0</FONT></FONT></P> |
| <P ALIGN=CENTER STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 16pt"><B>SQL |
| Development Tools Plan</B></FONT></FONT></P> |
| <P ALIGN=CENTER STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif">Last |
| Updated: <SDFIELD TYPE=DATETIME SDNUM="1033;1033;MM/DD/YY">11/22/05</SDFIELD></FONT></P> |
| <P ALIGN=CENTER STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif">This |
| document contains plans for the components of the SQL Development |
| Tools for DTP 1.0. Currently, it only reflects plans through M4 (DTP |
| 0.N).</FONT></P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>The |
| table below lists the deliverables planned for each milestone by |
| component. Each component feature specifies a priority. Direct |
| dependencies are also indicated either next to the component or |
| feature. Click on the component to see a description of its scope |
| and design goals. </FONT></FONT> |
| </P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><B>Feature |
| Priority:</B></FONT></P> |
| <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><B> </B>(C |
| ) Critical: feature is required in order to declare subcomponent |
| completion for milestone</FONT></P> |
| <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"> (H) High: |
| very important feature, but could move out to next milestone if |
| necessary</FONT></P> |
| <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"> (M) Medium: |
| good feature, but not necessary</FONT></P> |
| <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"> (L) Low: |
| nice to have feature, but could defer if necessary</FONT></P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><B>Feature |
| Dependencies:</B> shown next to each feature in square brackets [ ]</FONT></P> |
| <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"> [Conn] Connectivity</FONT></P> |
| <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"> [DDM] Database |
| Definition Model</FONT></P> |
| <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"> [LPG] LALR |
| Parser Generator (non-Eclipse component)</FONT></P> |
| <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"> [SM] SQL |
| Model</FONT></P> |
| <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"> [SQM] SQL |
| Query Model</FONT></P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <TABLE WIDTH=905 BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0> |
| <COL WIDTH=122> |
| <COL WIDTH=154> |
| <COL WIDTH=172> |
| <COL WIDTH=245> |
| <COL WIDTH=170> |
| <THEAD> |
| <TR VALIGN=TOP> |
| <TH WIDTH=122 BGCOLOR="#c0c0c0"> |
| <P><BR> |
| </P> |
| </TH> |
| <TH COLSPAN=4 WIDTH=765 BGCOLOR="#c0c0c0"> |
| <P><FONT FACE="Arial, sans-serif">MILESTONE 2: 12/22/05</FONT></P> |
| </TH> |
| </TR> |
| </THEAD> |
| <TBODY> |
| <TR VALIGN=TOP> |
| <TH WIDTH=122 BGCOLOR="#c0c0c0"> |
| <P><A HREF="#Subcomponents|region"><FONT FACE="Arial, sans-serif">Component</FONT></A></P> |
| </TH> |
| <TH WIDTH=154 BGCOLOR="#c0c0c0"> |
| <P><FONT FACE="Arial, sans-serif">Iteration 1</FONT></P> |
| <P><FONT FACE="Arial, sans-serif">11/21 – 12/02 (8)</FONT></P> |
| </TH> |
| <TH WIDTH=172 BGCOLOR="#c0c0c0"> |
| <P><FONT FACE="Arial, sans-serif">Iteration 2</FONT></P> |
| <P><FONT FACE="Arial, sans-serif">12/05 – 12/09 (5)</FONT></P> |
| </TH> |
| <TH WIDTH=245 BGCOLOR="#c0c0c0"> |
| <P><FONT FACE="Arial, sans-serif">Iteration 3</FONT></P> |
| <P><FONT FACE="Arial, sans-serif">12/12 – 12/15 (4)</FONT></P> |
| </TH> |
| <TH WIDTH=170 BGCOLOR="#c0c0c0"> |
| <P><FONT FACE="Arial, sans-serif">Iteration 4</FONT></P> |
| <P><FONT FACE="Arial, sans-serif">12/16 – 12/21 (6)</FONT></P> |
| </TH> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#SQL Query Parser|region">SQL |
| Query Parser</A></FONT></FONT></P> |
| <P><BR> |
| </P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>[SQM, SM, LPG]</FONT></FONT></P> |
| </TD> |
| <TD WIDTH=154> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=172> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=245> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Initial code |
| drop:</B></FONT></FONT></P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>- Parses multiple |
| statements (C)<BR>- Table reference resolving (C)</FONT></FONT></P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>- Optional quick |
| parse mode (H)</FONT></FONT></P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>- Configurable |
| source format options: e.g. statement terminator, host variable |
| prefix, parameter marker, delimited identifier quote, omit schema |
| (H)</FONT></FONT></P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>- Soft keyword |
| support (“SELECT select FROM from;”) (H)</FONT></FONT></P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>- Simple data type |
| resolving (H)</FONT></FONT></P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>- Test-driven |
| development (junit testcases) (H)</FONT></FONT></P> |
| </TD> |
| <TD WIDTH=170> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>Testing with |
| Eclipse 3.2 M4</FONT></FONT></P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#SQL Results View|region">SQL |
| Results View</A></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=154> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Low Level |
| Design<BR></B>- Internal Review </FONT></FONT> |
| </P> |
| <P><BR> |
| </P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Initial source |
| code drop (for review only)<BR></B>-Model and API code<BR>-Core |
| classes</FONT></FONT></P> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=172> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Feature code |
| drop <BR></B>- Display execution status, summary and details, |
| messages and result sets in different layout and modes ( C)</FONT></FONT></P> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=245> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Low Level |
| Design<BR></B>- External Review</FONT></FONT></P> |
| <P><BR> |
| </P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Feature code |
| drop <BR></B>- Save/export/print results in various file formats |
| with user defined column delimiters and encoding (H)</FONT></FONT></P> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=170> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>Testing with |
| Eclipse 3.2 M4</FONT></FONT></P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#SQL/Routines Editor|region">SQL/Routines |
| Editor</A></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=154> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Low Level |
| Design<BR></B>- Internal Review</FONT></FONT></P> |
| <P><BR> |
| </P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>API tutorial</B></FONT></FONT></P> |
| <P><BR> |
| </P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Initial code |
| drop:</B><BR>-extension point<BR>-SQL Editor Framework API</FONT></FONT></P> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=172> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Feature code |
| drop</B></FONT></FONT></P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>Merge with RDB SQL |
| Editor</FONT></FONT></P> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=245> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Feature code |
| drop</B></FONT></FONT></P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>Initial SQL Editor |
| Framework and Generic SQL Editor implementation build available |
| for download</FONT></FONT></P> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=170> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Low Level |
| Design</B></FONT></FONT></P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>- External Review</FONT></FONT></P> |
| <P><BR> |
| </P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>Testing with |
| Eclipse 3.2 M4</FONT></FONT></P> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#Routines Debugger|region">Routines |
| Debugger</A></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=154> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=172> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><B>Low |
| Level Design<BR></B>- Internal Review</SPAN></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=245> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><B>Initial |
| code drop:<BR></B>-extension point<BR>-Routine Debugger Framework |
| API<BR>- Debug Model classes</SPAN></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=170> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B><SPAN LANG="en-US">Low |
| Level Design<BR></SPAN></B>-External Review</FONT></FONT></P> |
| <P><BR> |
| </P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><FONT COLOR="#000000">Testing |
| with Eclipse 3.2 M4</FONT></SPAN></FONT></FONT></P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#SQL Execution Plan|region">SQL |
| Execution Plan</A></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=154> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=172> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=245> |
| <P><FONT FACE="Arial"><FONT SIZE=2><SPAN LANG="en-US"><B>Low |
| Level Design<BR></B>- Internal Review</SPAN></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=170> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#SQL Query Builder|region">SQL |
| Query Builder</A></FONT></FONT></P> |
| <P><FONT COLOR="#000000"><FONT FACE="Arial, sans-serif"><FONT SIZE=2>Note: |
| Not targeted for delivery in DTP 1.0</FONT></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=154> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=172> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=245> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=170> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| </TBODY> |
| </TABLE> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <TABLE WIDTH=905 BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0> |
| <COL WIDTH=122> |
| <COL WIDTH=244> |
| <COL WIDTH=266> |
| <COL WIDTH=239> |
| <THEAD> |
| <TR VALIGN=TOP> |
| <TH WIDTH=122 BGCOLOR="#c0c0c0"> |
| <P ALIGN=CENTER><BR> |
| </P> |
| </TH> |
| <TH COLSPAN=3 WIDTH=765 BGCOLOR="#c0c0c0"> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>MILESTONE |
| 3: 01/20/06</B></FONT></FONT></P> |
| </TH> |
| </TR> |
| </THEAD> |
| <TBODY> |
| <TR VALIGN=TOP> |
| <TH WIDTH=122 BGCOLOR="#c0c0c0"> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B><A HREF="#Subcomponents|region">Component</A></B></FONT></FONT></P> |
| </TH> |
| <TH WIDTH=244 BGCOLOR="#c0c0c0"> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>Iteration |
| 1</B></FONT></FONT></P> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>01/03 |
| – 01/06 (4)</B></FONT></FONT></P> |
| </TH> |
| <TH WIDTH=266 BGCOLOR="#c0c0c0"> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>Iteration |
| 2</B></FONT></FONT></P> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>01/09 |
| – 01/13 (5)</B></FONT></FONT></P> |
| </TH> |
| <TH WIDTH=239 BGCOLOR="#c0c0c0"> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>Iteration |
| 3</B></FONT></FONT></P> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>01/16 |
| – 01/19 (4)</B></FONT></FONT></P> |
| </TH> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#SQL Query Parser|region">SQL |
| Query Parser</A></FONT></FONT></P> |
| <P><BR> |
| </P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>[SQM, SM, LPG]</FONT></FONT></P> |
| </TD> |
| <TD WIDTH=244> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=266> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=239> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Doc Drop</B></FONT></FONT></P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>- Internal API |
| Documentation (H)</FONT></FONT></P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#SQL Results View|region">SQL |
| Results View</A></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=244> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Feature code |
| drop<BR></B>- Execution history filters, e.g., to display |
| execution history by connection profile, status, etc. (H)</FONT></FONT></P> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=266> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><B>Feature |
| code drop<BR></B>- Execution history sorting based on |
| weight/execution frequency (H)</SPAN> </FONT></FONT> |
| </P> |
| </TD> |
| <TD WIDTH=239> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Feature code |
| drop<BR></B>- Re-execution of selected history script (H)</FONT></FONT></P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>- Persistence of |
| execution history (M)</FONT></FONT></P> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#SQL/Routines Editor|region">SQL/Routines |
| Editor</A></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=244> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><B>Feature |
| code drop<BR></B>- content assist (C ) [SM, Conn]<BR>- syntax |
| highlighting(C )<BR>- code template (H)<BR>- syntax validation |
| (H)<BR>- Outline view (H)<BR>- statement execution ( C) [Conn, |
| Results View]</SPAN></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=266> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><B>Feature |
| code drop<BR></B><SPAN STYLE="font-weight: medium">- Integration |
| w/ Model Base and Connectivity:<BR></SPAN>- Life cycle management |
| (C ) [SM, Conn]<BR>- Routine launch configuration - run mode ( C) |
| [SM, Conn, DDM]<BR>- generic and extensible SQL editor preference |
| pages (H)</SPAN></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=239> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><B>Feature |
| code drop<BR></B>- Generic SQL editor implementation (Derby) ( C) |
| [SM, Conn, DDM]<BR>- Portability check (L)</SPAN></FONT></FONT></P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#Routines Debugger|region">Routines |
| Debugger</A></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=244> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Feature code |
| drop<BR></B>- Routine launch configuration - debug mode (C) [SM, |
| Conn, DDM]<BR>- Line breakpoint management (C ) [DDM, Conn]</FONT></FONT></P> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=266> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><B>Feature |
| code drop<BR>- </B>Integration w/ Model Base and Connectivity</SPAN> |
| </FONT></FONT> |
| </P> |
| </TD> |
| <TD WIDTH=239> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><B>Feature |
| code drop<BR></B>- Table view (M) [SM, Conn]</SPAN></FONT></FONT></P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>- External |
| client's view (M) [DDM, Conn]</FONT></FONT></P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#SQL Execution Plan|region">SQL |
| Execution Plan</A></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=244> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><B>Initial |
| build<BR></B>- Tree-structure GUI execution plan<SPAN LANG="en-US"> |
| (C)</SPAN><BR>- Generic and extensible Preference pages (C)</SPAN></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=266> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><B>Feature |
| code drop<BR></B>- Integration w/ Model Base and Connectivity:<BR>- |
| Execution plan history<SPAN LANG="en-US"> (C)</SPAN><BR>- |
| Save/load/print plans (C)</SPAN></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=239> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><B>Feature |
| code drop<BR></B>- Import and export (M)</SPAN> </FONT></FONT> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#SQL Query Builder|region">SQL |
| Query Builder</A></FONT></FONT></P> |
| <P><FONT COLOR="#000000"><FONT FACE="Arial, sans-serif"><FONT SIZE=2>Note: |
| Not targeted for delivery in DTP 1.0</FONT></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=244> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>tbd</FONT></FONT></P> |
| </TD> |
| <TD WIDTH=266> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>tbd</FONT></FONT></P> |
| </TD> |
| <TD WIDTH=239> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>tbd</FONT></FONT></P> |
| </TD> |
| </TR> |
| </TBODY> |
| </TABLE> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <TABLE WIDTH=905 BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0> |
| <COL WIDTH=122> |
| <COL WIDTH=175> |
| <COL WIDTH=205> |
| <COL WIDTH=188> |
| <COL WIDTH=173> |
| <THEAD> |
| <TR VALIGN=TOP> |
| <TH WIDTH=122 BGCOLOR="#c0c0c0"> |
| <P ALIGN=CENTER><BR> |
| </P> |
| </TH> |
| <TH COLSPAN=4 WIDTH=765 BGCOLOR="#c0c0c0"> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>MILESTONE |
| 4/DTP 0.N: 03/17/06</B></FONT></FONT></P> |
| </TH> |
| </TR> |
| </THEAD> |
| <TBODY> |
| <TR VALIGN=TOP> |
| <TH WIDTH=122 BGCOLOR="#c0c0c0"> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B><A HREF="#Subcomponents|region">Component</A></B></FONT></FONT></P> |
| </TH> |
| <TH WIDTH=175 BGCOLOR="#c0c0c0"> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>RC1</B></FONT></FONT></P> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>01/23 |
| – 02/24 (25)</B></FONT></FONT></P> |
| </TH> |
| <TH WIDTH=205 BGCOLOR="#c0c0c0"> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>RC2</B></FONT></FONT></P> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>02/27 |
| – 03/03 (5)</B></FONT></FONT></P> |
| </TH> |
| <TH WIDTH=188 BGCOLOR="#c0c0c0"> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>RC3</B></FONT></FONT></P> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>03/06 |
| – 03/10 (5)</B></FONT></FONT></P> |
| </TH> |
| <TH WIDTH=173 BGCOLOR="#c0c0c0"> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>0.N/M4</B></FONT></FONT></P> |
| <P ALIGN=CENTER><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>03/13 |
| – 03/16 (4)</B></FONT></FONT></P> |
| </TH> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#SQL Query Parser|region">SQL |
| Query Parser</A></FONT></FONT></P> |
| <P><BR> |
| </P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>[SQM, SM, LPG]</FONT></FONT></P> |
| </TD> |
| <TD WIDTH=175> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Plugin |
| restructuring</B></FONT></FONT></P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN STYLE="font-weight: medium">- |
| S</SPAN>eparate out lexer</FONT></FONT></P> |
| <P><BR> |
| </P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><FONT COLOR="#000000">Testing |
| with Eclipse 3.2 M5</FONT></SPAN></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=205> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><B>Doc Drop</B></FONT></FONT></P> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>- Complete |
| Internal API Documentation (H)</FONT></FONT></P> |
| </TD> |
| <TD WIDTH=188> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=173> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#SQL Results View|region">SQL |
| Results View</A></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=175> |
| <P STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><FONT COLOR="#000000">Testing |
| with Eclipse 3.2 M5</FONT></SPAN></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=205> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=188> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=173> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#SQL/Routines Editor|region">SQL/Routines |
| Editor</A></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=175> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><FONT COLOR="#000000">Testing |
| with Eclipse 3.2 M5</FONT></SPAN></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=205> |
| <P STYLE="font-weight: medium"><BR> |
| </P> |
| </TD> |
| <TD WIDTH=188> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=173> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#Routines Debugger|region">Routines |
| Debugger</A></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=175> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><FONT COLOR="#000000">Testing |
| with Eclipse 3.2 M5</FONT></SPAN></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=205> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=188> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=173> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#SQL Execution Plan|region">SQL |
| Execution Plan</A></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=175> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><SPAN LANG="en-US"><FONT COLOR="#000000">Testing |
| with Eclipse 3.2 M5</FONT></SPAN></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=205> |
| <P><BR> |
| </P> |
| </TD> |
| <TD WIDTH=188> |
| <P STYLE="font-weight: medium"><BR> |
| </P> |
| </TD> |
| <TD WIDTH=173> |
| <P><BR> |
| </P> |
| </TD> |
| </TR> |
| <TR VALIGN=TOP> |
| <TD WIDTH=122> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2><A HREF="#SQL Query Builder|region">SQL |
| Query Builder</A></FONT></FONT></P> |
| <P><FONT COLOR="#000000"><FONT FACE="Arial, sans-serif"><FONT SIZE=2>Note: |
| Not targeted for delivery in DTP 1.0</FONT></FONT></FONT></P> |
| </TD> |
| <TD WIDTH=175> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>tbd</FONT></FONT></P> |
| </TD> |
| <TD WIDTH=205> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>tbd</FONT></FONT></P> |
| </TD> |
| <TD WIDTH=188> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>tbd</FONT></FONT></P> |
| </TD> |
| <TD WIDTH=173> |
| <P><FONT FACE="Arial, sans-serif"><FONT SIZE=2>tbd</FONT></FONT></P> |
| </TD> |
| </TR> |
| </TBODY> |
| </TABLE> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <DIV ID="Components" DIR="LTR"> |
| <P ALIGN=CENTER STYLE="page-break-before: always"><FONT COLOR="#000000"><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>Components</B></FONT></FONT></FONT></P> |
| </DIV> |
| <P ALIGN=CENTER><BR><BR> |
| </P> |
| <P ALIGN=LEFT><FONT COLOR="#000000"><FONT FACE="Arial, sans-serif"><FONT SIZE=2><FONT SIZE=3>Each |
| component will have a focal point representative who will be |
| responsible for driving the communications, design and development |
| for that component. The focal point will interact with the other |
| members of that team involved in the design and/or implementation and |
| with other components as needed. Information coming from each |
| component will be reviewed and shared with the overall project to |
| ensure good communication, coherency and consistency.</FONT><BR></FONT></FONT></FONT><BR><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <DIV ID="SQL Query Parser" DIR="LTR" STYLE="background: transparent"><A NAME="SQL Query Parser|region"></A> |
| <P ALIGN=CENTER STYLE="margin-bottom: 0in; page-break-before: always"> |
| <FONT FACE="Arial, sans-serif"><B>SQL Query Parser</B></FONT></P> |
| <P ALIGN=CENTER STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=CENTER STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><B>Scope:</B></FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif">The |
| scope of the SQL Query Parser is syntactic and semantic validation |
| of SQL statements. Initially, it will handle SQL Data Manipulation |
| Language (DML) constructs: SELECT, INSERT, UPDATE and DELETE |
| statements. Data Definition Language (DDL) constructs are outside |
| the initial scope of the parser. The output of the parser is an |
| instance of the SQL Query Model.</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><B>Design |
| Goals:</B></FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif">- |
| Based on LPG parser generator</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif">- |
| Quick parse feature without constructing model object to determine |
| statement type</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif">- |
| Focus on test-driven development </FONT> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif">- |
| Target SQL Query Model directly as parse result</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif">- |
| Pluggable semantic action productions</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif">- |
| Generic, ISO SQL-based source generation, based on SQL-99/2003</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif">- |
| Architected support for multiple SQL dialects (inheritance)</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"> <FONT FACE="Arial, sans-serif">- |
| Use Eclipse extension-point mechanism</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"> <FONT FACE="Arial, sans-serif">- |
| Multiple parser plug-ins extend common base parser plug-in with |
| separate LPG generated parser</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"> <FONT FACE="Arial, sans-serif">- |
| Reuse of grammar: overwrite, drop and add rules</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif">- |
| Along with the SQL Query Model, provide strong base for query |
| tooling</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"> <FONT FACE="Arial, sans-serif">- |
| Enable “round-trip” editing for query builder tools</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"> <FONT FACE="Arial, sans-serif">- |
| Enable smart editing features for SQL text editors</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"> <FONT FACE="Arial, sans-serif">- |
| Provide rich information for query analysis</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif">- |
| Parser not dependent on a live database connection </FONT> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif">- |
| Two phase parsing: </FONT> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"> <FONT FACE="Arial, sans-serif">- |
| A purely syntactic parsing phase. Generate the Query model instance |
| that represents the query. Completely independent of the database. </FONT> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"> <FONT FACE="Arial, sans-serif">- |
| A "semantic resolution" phase. Use information contained |
| in an instance of the base SQL model (mainly table and column |
| information) to associate the tables, columns, etc. contained in the |
| query with the corresponding objects in a database. It doesn't |
| matter to the parser how the catalog information in the base SQL |
| model instance was populated (through a live database connection, |
| cached catalog information, or in some other way).</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><B>Dependencies</B></FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif">LPG |
| - used to generate SQL parser from SQL grammar; runtime jar also |
| required</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif">SQL |
| Query Model - parser produces SQM objects, also used for semantic |
| validation </FONT> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif">SQL |
| Model - used for semantic validation; create data type objects and |
| hook into SQM objects</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><B>Consumers</B></FONT></P> |
| <UL> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT FACE="Arial, sans-serif">The |
| Eclipse BIRT project plans to be an early adopter of the parser. |
| Refer to Bugzilla requirement 112689.</FONT></P> |
| </UL> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in; page-break-before: always"><BR> |
| </P> |
| </DIV> |
| <P ALIGN=CENTER STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><B>SQL |
| Results View</B></FONT></P> |
| <DIV ID="SQL Results View" DIR="LTR"><A NAME="SQL Results View|region"></A> |
| <P ALIGN=CENTER STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><B>Scope</B></FONT></P> |
| <UL> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT FACE="Arial, sans-serif">Display |
| SQL execution results which may have two types of input: tabular |
| result item and message item</FONT></P> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT FACE="Arial, sans-serif">Execution |
| of SQL statements is the responsibility of the SQL Results View API |
| consumer, thus is outside this component's scope</FONT></P> |
| </UL> |
| <UL> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT FACE="Arial, sans-serif">Will |
| consider SDO(Service Data Object) in the next DTP release</FONT></P> |
| </UL> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><B>Design |
| Goals</B></FONT></P> |
| <UL> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT FACE="Arial, sans-serif">Combined |
| script history and SQL result view</FONT></P> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT FACE="Arial, sans-serif">Support |
| flexible output format (xml,cvs,html,etc.), support user-defined |
| column delimiters</FONT></P> |
| </UL> |
| <UL> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT FACE="Arial, sans-serif">No |
| coupling between SQL Results View and SQL Editor Framework/SQL |
| Editor implementation</FONT></P> |
| </UL> |
| <UL> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT FACE="Arial, sans-serif">Provide |
| a smooth transition path for the existing DB Output view consumer, |
| to lessen the refactoring effort as much as possible</FONT></P> |
| </UL> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><B>Dependencies</B></FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT FACE="Arial, sans-serif">- |
| Connection Profile: There is no strong dependency between |
| connectivity layer and SQL Results View, other than the connection |
| profile name, which is used for history filter and re-execution |
| purposes only.</FONT></P> |
| <P ALIGN=CENTER STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=CENTER STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=CENTER STYLE="margin-bottom: 0in; page-break-before: always"> |
| <FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>SQL/Routines Editor</B></FONT></FONT></P> |
| <DIV ID="SQL/Routines Editor" DIR="LTR"><A NAME="SQL/Routines Editor|region"></A> |
| <P ALIGN=CENTER><BR> |
| </P> |
| <P ALIGN=LEFT><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>Scope</B></FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>The |
| scope of the SQL Editor Framework is to:</FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>- |
| Provide the Data Development Perspective to support SQL application |
| development lifecycle</FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>- |
| Help the user to develop SQL scripts by making most of eclipse IDE |
| features and to allow vendor-specific features to be easily |
| integrated in</FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>- |
| Allow the user to manipulate and run routine objects.</FONT></FONT></P> |
| <P ALIGN=LEFT><BR> |
| </P> |
| <P ALIGN=LEFT><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>Design |
| Goals</B></FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>- |
| Built using DTP infrastructure components: models--SM, DDM, |
| connectivity layer.</FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>- |
| Provide generic SQL Editor support, but extendable for |
| vendor-specific features, e.g., context menu/action, wizard |
| invocation, etc.</FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>- |
| Reduce coupling between components, for example, avoid tightly |
| coupled with SQL Results View and SQL Execution Plan View.</FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>- |
| Can be coupled with SQL Routine Debugger Framework and Debugger |
| implementation.</FONT></FONT></P> |
| <P ALIGN=CENTER><BR> |
| </P> |
| <P ALIGN=CENTER STYLE="page-break-before: always"><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>Routines |
| Debugger</B></FONT></FONT></P> |
| <DIV ID="Routines Debugger" DIR="LTR"><A NAME="Routines Debugger|region"></A> |
| <P ALIGN=CENTER STYLE="font-weight: medium"><BR> |
| </P> |
| <P ALIGN=LEFT><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>Scope</B></FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>- |
| Allow the user to debug routine objects. </FONT></FONT> |
| </P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>- |
| The debug mechanism of each data server may vary, therefore the |
| implementation is vendor specific and beyond the scope.</FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><BR> |
| </P> |
| <P ALIGN=LEFT><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>Design |
| Goals</B></FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>- |
| Built using DTP infrastructure components: models--SM, DDM, |
| connectivity layer, SQL Editor Framework, and SQL Editor |
| implementation</FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>- |
| Flexible Debugger framework allows extendable vendor-specific |
| implementations</FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>- |
| Reduce the coupling between SQL Editor framework and Routine |
| Debugger framework'</FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><BR> |
| </P> |
| <P ALIGN=LEFT><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>Pending</B></FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>- |
| Exemplary debugger (M)</FONT></FONT></P> |
| <DIV ID="SQL Execution Plan" DIR="LTR"><A NAME="SQL Execution Plan|region"></A> |
| <P ALIGN=CENTER STYLE="page-break-before: always"><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>SQL |
| Execution Plan</B></FONT></FONT></P> |
| <P ALIGN=CENTER><BR> |
| </P> |
| <P ALIGN=LEFT><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>Scope</B></FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>The |
| scope of the Execution Plan View is to display SQL query |
| execution plans. The execution plan retrieval mechanism is </FONT></FONT> |
| </P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>outside |
| the framework's scope and should be implemented by |
| vendor-specific plug-ins.</FONT></FONT></P> |
| <P ALIGN=LEFT><BR> |
| </P> |
| <P ALIGN=LEFT><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>Design |
| Goals</B></FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>- |
| Flexible model to accommodate various execution plan formats </FONT></FONT> |
| </P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>- |
| Reusable UI components</FONT></FONT></P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>- |
| Reduce coupling between SQL Execution Plan View and SQL Editor |
| framework and implementation.</FONT></FONT></P> |
| <DIV ID="SQL Query Builder" DIR="LTR"><A NAME="SQL Query Builder|region"></A> |
| <P ALIGN=CENTER STYLE="page-break-before: always"><FONT FACE="Arial, sans-serif"><FONT SIZE=3><B>SQL |
| Query Builder</B></FONT></FONT></P> |
| <P ALIGN=CENTER><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="font-weight: medium"><FONT FACE="Arial, sans-serif"><FONT SIZE=3>The |
| SQL Query Builder will not be included in DTP 1.0. However, |
| design and development work will go on in the 1.0 time frame, |
| with an initial delivery targeted for the release after DTP 1.0. |
| More details are forthcoming.</FONT></FONT></P> |
| </DIV> |
| </DIV> |
| </DIV> |
| </DIV> |
| </DIV> |
| </BODY> |
| </HTML> |