[
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
