One of the best systems is to use one database. This is one of the huge advantages of WordPress. There's only one database that all of your plugins use. That means that everything is always up to date. As soon as you have multiple databases, it's possible to have inconsistent data, and using just one database prevents that.
If you're worried about having a perfectly updated database, use a native WordPress solution such as WooCommerce POS.