there are two independent systems. System An is the class information management system and system B is the book management system.
the current design idea is that system An and system B are divided into two independent business projects, and their databases are also independent, divided into A database and B database.
the only connection between system An and system B is the user information table, that is, the user information in system An also exists in system B.
how can the design of the database be reasonable for the system with this requirement?
scenario 1
since both database An and database B have user tables, but their contents are the same, I can develop a separate C system dedicated to the basic information of these Synchronize users.
difficulty: user information Synchronize is too troublesome, always think it is not very good to do so.
scenario 2
separate the user information table into a third database, and check directly across databases when system An or system B needs to access user information.
difficulty: cross-database joint search feels more troublesome--;
I am not very clear about the specific design ideas, or do I already have a mature solution for this requirement? Ask for advice.