[jira] Commented: (DERBY-4586) Add compatibility tests to explore behavior differences between Derby and other DBMS implementations

["Isuru Anuranga Wijesinghe (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DERBY-4586?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13003037#comment-13003037 ] 

Isuru Anuranga Wijesinghe commented on DERBY-4586:
--------------------------------------------------

Hi Bryan

I'm a student with a great will to participate GSOC 2011. Your idea seems to be very interesting. I recently did a research project on "improving derby query optimization algorithms". There I got knowledge of comparing Derby with other RDBMS. This is a link I found  http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems 
with huge collection of comparison between existing RDBMS. 

I have gone through links you provided. And did a small background research on H2 database engine (http://h2database.com/html/features.html#compatibility) to understand what exactly mean by compatibility. I found that, database engines behaves bit different from each other, SQL syntax support also can be different. But to some extent they can emulate the behavior of  specific databases. One possible example for compatibility would be - import SQL Server database dump file to derby. To consolidate my idea I would like to have your comment on, to which extent I’m clear about project goal.

Project goal - Bring existing suits for compatibility testing in to derby testing environment and test Derby compatibility with well-known database engines and then extending for further compatibility testing define by us.


> Add compatibility tests to explore behavior differences between Derby and other DBMS implementations
> ----------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4586
>                 URL: https://issues.apache.org/jira/browse/DERBY-4586
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation, JDBC, SQL, Test
>            Reporter: Bryan Pendleton
>              Labels: gsoc, gsoc2010, gsoc2011, mentor
>
> It would be interesting to understand Derby's compatibility with other major DBMS implementations, such as: Oracle, Sybase, SQL Server, DB2, MySQL, etc.
> I believe this would be an excellent project for a motivated Google Summer of Code intern.
> The goal of the project would be to locate various existing compatibility test suites and bring them into the Derby test environment, as well as to augment those test suites with additional tests developed during the project.

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira