|Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General Discussion » View Thread|
|Messages 11 to 12 of 12 total|
|Work with many databases|
|Thu, Jan 22 2015 11:04 AM||Permanent Link|
Roy Lambert wrote:
> If its a POS system they would, in my opinion, be mad to have all the
> servers in one building. Having a server at each of the 80 branches
> provides a lot of resilience in case there's a power cut or someone
> puts a JCB through the comms line.
> If you were using ElevateDB it would be a prime candidate for
Good point, though I think I'd do it using my own replication, simply
from a being smart point of view. But it also depends on the cost
expected, though with this size of company they should be going for
resiliant. One of the projects I've worked on for the last ten years is
about transferring data from A to B (actually many B's) and back, and
queuing and robustness is not easy to make, but worth it. Isolating the
locations actually fits this system well, thinking about it, and you
might even call it POS. Yep, a very good fit. There is a central office
with a server that gathers all the info using the comms software, and
each remote site has a "head terminal" that has the core databases, and
the "POS terminals" talk to that. Orders etc are thus stored locally,
but it sends a copy back to central office for audit and management.
The comms software I wrote uses DBISAM (EDB didn't exist when I started
it), but the other parts don't as they predate me.
|Thu, Jan 22 2015 1:47 PM||Permanent Link|
On 1/22/2015 5:34 AM, Roy Lambert wrote:
> If its a POS system they would, in my opinion, be mad to have all the servers in one building. Having a server at each of the 80 branches provides a lot of resilience in case there's a power cut or someone puts a JCB through the comms line.
True in general but the remote office concept has come a long in the
last 5 years. Customer of ours did something similar (not POS though)
and their remote office routers all had SIM cards and 3G backup
connection in case the main internet goes down.
The server on each site can get expensive too (hopefully you can use one
of the POS terminals but if not then it's 80 more PCs).
Companies might also want to not keep customer data on remote computers
- just look at recent hacks where customer info and credit cards were
Every company and situation is different oc course but sounds like a
good design challenge for sure.
|« Previous Page||Page 2 of 2|
|Jump to Page: 1 2|