Project Detail

Description

We need someone who can add few features to open source project, Sequoia

Sequoia is a clustering middleware for database such as oracle, mysql.

(to get more information about the sequoia, please visit www.sequoia.org)

Anyway, after sequoia evaluation, we found that few features which are important to our IT environments few sequoia are missing.

Here are features we want to add

[Features we want to add]

1. Adding Semantic query cache

Cache in sequoia works when it finds same sql query in memory, we think this is not the best way to maximize cache hit ratio.

To increase hit ratio, we want to apply semantic query cache to sequoia.

let me explain what Semantic query cache is.

here is a cached query result by sql query a)

a) select * from table where fieldA>10

and new sql query b) arrived,

b) select * from table where fieldA>20

then semantic query cache mechanism is supposed to extract cache result from the result set of query a).


2. Adding some kinds of data partitioning

Sequoia uses a big table called virtualdatabase, since our database server receives many update,insert and delete query.

so performance of Sequoia is not acceptable mainly caused by locks to keep data consistency.

and we believe that data partitioning mechanism in database may save us.

basic idea is 1) to seperate data into many tables, 2) to spawn many threads which access predefined table.

in the above idea, we do not need to lock entire system but a table which is going to be updated.


[Notes]

There is a possibility that we may want to change specification of the new features because we do not test our idea so we can not ensure the idea will bring us what we want.

After implmentation, we will enter testing phase, if the test results does not show acceptable, we may change the specification.


[Selection Criteria]

We want ,

1. Who can work ( since work volume is relatively small, individual can apply for this project)
Company which can assign a dedicated engineer.

2. Individual or company who is willing to do intensive communication with us through internet messanger like ICQ.

3. High Java skill


Thanks...