| CASE STUDY [message #384281] |
Tue, 03 February 2009 02:24  |
mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan
|
Senior Member |
|
|
Dear fellows,
The case study is that one of my customer is a Crourier Service Company. All its Branches are spread over the country. Now they want to develop a Database with Tracking System i.e. whenever a person at any location of the country browse their website and enter Slip Number of the packet dispatched the system will provide him the output of Receiving person of the packet dispatched alongwith date and time.
Now what will be the best solution i.e. Centralized database, Distributed Database or some else. Would you please help me in providing detailed solution for this senario?
Thanks for giving your precious time to read and write.
Muhammad Khalil
|
|
|
|
| Re: CASE STUDY [message #384290 is a reply to message #384281] |
Tue, 03 February 2009 02:59  |
dr.s.raghunathan
Messages: 540
Registered: February 2008
|
Senior Member |
|
|
|
generally centralised database serves lot of plus on achieving your specified goal however, depending on your communication network, service provider, transfer rate between places, vitality of the data submission, cost on failures will shift your need towards distributed database. Further, your application requires various other parameters to decide the database requirement. At one stroke if anybody can able to suggest the type of database you require, then he/she is really a magician from my part.
|
|
|
|
| Re: CASE STUDY [message #384333 is a reply to message #384290] |
Tue, 03 February 2009 06:06 |
mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan
|
Senior Member |
|
|
Thanks a lot dr.s.raghunathan for your so quick, kind and detailed response. No doubt, no one can suggest type of database for my application but we can solve the problem by discussion with experts like you.
Actually, in this case all branches are working indipendently and want to not share the whole data with each other as well as its Head Office except the data pertaining to the consignment dispatched to a location.
In my view, one complete database including all type of data such as income,expense, consignment related data with branch code etc of the branch should be installed on each branch and one database pertaining to only consignment related data with branch code should be installed on a webserver placed on any one location. Each branch should take daily backup of only consignment related data with branch code and send to the webserver then that backup should be restore/append into the webserver on daily basis. The data on webserver should be accessable by each customer to track its consignment through slip Number.
Is it correct and how is it possible please guide and help me.
Muhammad Khalil
|
|
|
|
|
|
| Re: CASE STUDY [message #384509 is a reply to message #384438] |
Wed, 04 February 2009 02:50 |
mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan
|
Senior Member |
|
|
Thanks David. Are you mean Web Application for specially Consignment related data on each Branch level. Whenever the user enter the data it should be saved in private database as well as update the public database installed in the server and when a customer track any slip number the server will response i.e. the sender initiates the request rather than the recipient and the recipient will respond.
Muhammad Khalil
[Updated on: Wed, 04 February 2009 05:02] Report message to a moderator |
|
|
|
|
|
| Re: CASE STUDY [message #384998 is a reply to message #384698] |
Fri, 06 February 2009 00:46 |
mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan
|
Senior Member |
|
|
The reliability of Internet in my region is so so not very stong.
The same people entering the new data will not enquire the 'public' data.
I have looked at the website of TNT Courier Service not DHL.
Yes I want the 'public' to be able to make enquiries of their shipment.
Muhammad Khalil
|
|
|
|
| Re: CASE STUDY [message #385279 is a reply to message #384998] |
Sun, 08 February 2009 22:55 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I would stick with the idea of a central machine (you could use Oracle Replication to keep multiple copies at multiple sites up-to-date) and then at your main site have the materialised view under a different userid and then 'push' this view out to the 'external' site under a further different userid. Remember that it is a 'push'. This means that any changes made to the 'public' database will be over-written the next time an update is pushed out.
It would be this last copy that the 'public' would view. Remember that this view must only contain PUBLIC data. You have to be willing to have a hacker penetrate and steal all this data. Therefore, you need to check your privacy laws and make sure that only data that is permitted by your laws exists in this 'final' version of the data.
David
[EDITED by DJM: Oops! Had "Orale Replication" instead of "Oracle Replication".]
[Updated on: Wed, 25 February 2009 00:20] Report message to a moderator |
|
|
|
| Re: CASE STUDY [message #386537 is a reply to message #385279] |
Mon, 16 February 2009 00:52 |
mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan
|
Senior Member |
|
|
|
Thanks djmartin. Very Good Idea. I got it now but the term Orale Replication is new for me. Would you please give me a little detail about this term or any link from where I could read out the text.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: CASE STUDY [message #388304 is a reply to message #387512] |
Tue, 24 February 2009 03:13 |
mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan
|
Senior Member |
|
|
|
Could you please suggest which one version of Oracle alongwith Developer would be the best one for such case and what would be plus by using that one.
|
|
|
|
| Re: CASE STUDY [message #388342 is a reply to message #388304] |
Tue, 24 February 2009 06:50 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>Could you please suggest which one version of Oracle alongwith Developer
Anything that is latest version.
>>what would be plus by using that one.
Well, you get some support to start with.
More tools and less bugs. The concept you want to implement has matured
a lot in later versions and been stable.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
