db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Isuru Anuranga Wijesinghe (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4586) Add compatibility tests to explore behavior differences between Derby and other DBMS implementations
Date Sat, 05 Mar 2011 20:19:48 GMT

    [ 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
> ----------------------------------------------------------------------------------------------------
>                 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


View raw message