aspose file tools*
The moose likes Distributed Java and the fly likes Data synchronization bet practice? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Distributed Java
Bookmark "Data synchronization bet practice?" Watch "Data synchronization bet practice?" New topic
Author

Data synchronization bet practice?

bilal haider
Ranch Hand

Joined: Feb 08, 2011
Posts: 47

Data synchronization on multiple locations:

Application is deployed on different locations, I want to update master database at the end of day such that new sales orders of the day from all locations
should be inserted into master database.

At the time of insertion of a new sales order in the local database at a particular location,
application first ensure that this customer is new customer who is not in the local as well as master database.
If customer data is already present in the master database , then local database must be populated with essential details of a customer available in the master

daabase.



Customer:

CUST_ID sequence (PK)
Name varchar2
DOB DateTime
SSN DateTime

Customer_Detail:

CUST_ID (FK) Refrences Customer,
PhoneNumber
email

Customer_Order:
Order_ID
CUST_ID
Order_Date

Order_Detail:
Order_ID
Product_Id
Quantity

At the end of day I want to update the master database, with all the details of new data that is inserted in the databases on different locations.

The approach which i want to follow is:

searchMasterDatatabse(ssn)
{
//select name, dob,ssn from customer where ssn=:ssn
if(recordFound)
set recordExistInMasterDatabase=true;

}
if (recordExistInMasterDatabase)
{
insert into location.Cutomer(name,dob,ssn) values(master.name,master,dob,master.ssn)
}
else
{
insert into location.Cutomer(name,dob,ssn) values('John','19-MAR-2012','1111-222222-8989888'}
}

Now at the end of day i want to update the master database with the new customers that are registered on different locations.

Please suggest me the articles, techniques, tutorial so that i can achive the above functionality. I want to start my work after deciding a particular technique.
Is there any tool to do this?
What about oracle data integrator?
Should I implement web service to communicate with the master database?


I want to implement this using pure java + oracle sql + jsf for web.
I have eclipse, oracle 11g.

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Data synchronization bet practice?