-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: Hibernate for vertically partioned database?
PostPosted: Tue May 10, 2011 9:27 pm 
Newbie

Joined: Sat Mar 22, 2008 5:11 pm
Posts: 6
Hello, folks:

I am currently leading the development of an important web application at a Federal agency in Washington, DC. I have had a long, good experience with Hibernate and will use it on this application too. However, I am facing a rather odd situation:

1. We have a legacy desktop application written in VB that uses a MS Access database.

2. The client (another group within my organization) wants a particular new feature but they want it web-based (and so a new web application) so that other Fed agencies can use the new feature in real time.

3. The client wants the new web application to store all new data in a relational database (we have Oracle here) but retrieve all legacy data from Access. The new web application is supposed to display the mix of data (from both databases) in the same table where users will be sorting the columns and navigating through next/previous stuff.

4. And that's where I am facing the problem. Sorting the table and navigating through it works like a charm (after writing some code for Hibernate layer) when all data comes from the same DB. How can I do it when the data comes from two entirely different types of databases? I know I will have to retrieve data from both DB and manipulate it before passing it to the presentation tier - that sounds like a lot of work that will impact the server response time.

I know Hibernate Shards works for horizontal partitions. Is there any tested and popular strategy or solution available for the vertical partition problem I am facing? Also, is not it better to retire the legacy application and write a new web application that will replace it instead of poking its nose in the legacy DB? I would appreciate any feedback. Thanks.

Asif


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.