SOA
In Service Oriented Architecture or SOA, a layer of services (API) were created to front the database CRUD operations.
- Changes to DB become more manageable
- Hides the structure of DB i.e., no more SQL statements in apps
- Services were designed to be re-usable e.g., centralized code for CRUD operations & validation logic
There is a common misconception that a SOA service = Microservice. That is 100% Incorrect !!!
Though some of the Shared database challenges were addressed by SOA but many challenges still need to be addressed !!!