Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 12 of 12 total
Thread Work with many databases
Thu, Jan 22 2015 11:04 AMPermanent Link

Matthew Jones

Roy Lambert wrote:

> Jose
>
>
> 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
> replication.

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.


--

Matthew Jones
Thu, Jan 22 2015 1:47 PMPermanent Link

Raul

Team Elevate Team Elevate

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
stolen.

Every company and situation is different oc course but sounds like a
good design challenge for sure.

Raul


« Previous PagePage 2 of 2
Jump to Page:  1 2
Image