Archiving Database Tables using Java
Posted
by HonorGod
on Stack Overflow
See other posts from Stack Overflow
or by HonorGod
Published on 2010-03-18T19:38:30Z
Indexed on
2010/03/18
19:41 UTC
Read the original article
Hit count: 208
java
My application demands archiving database tables between sybase and db2 and vice-a-versa and within(db2 to db2 and sybase to sybase) using java.
I am trying to understand the best strategies around in terms performance, implementation, ease of use and scalability.
Here is my current process -
- source and destination tables with the acceptable parameters (from java) are defined within xml.
- the application reads the source and destination configurations and execute them sequentially.
- destination is sometime optional when source is just deleting data from a specific table or when the source is just calling a stored procedure.
- dataset between source and destination is extremely large (in millions)
From top of my head, it looks like I can define dependencies between multiple source and destination combination and have them execute in parallel in multiple treads. But will this improve any performance(i hope it will)?
Are there any open-source frameworks for data archiving using java? Any other thoughts on the implements side will be really helpful.
Thanks
© Stack Overflow or respective owner