Login ProductsSalesSupportDownloadsAbout |
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 |
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 PM | Permanent Link |
Raul 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 Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Thursday, March 28, 2024 at 08:36 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |