No-SQL Standardization

Holdings Microservice is enhanced to include the functionality of Arrangements Microservice as-part of Merger Activity. Holdings is a No-SQL based microservice and Arrangements is SQL based microservice. In Arrangements Microservice entity model has been normalized to break down the data model to simplify the queries and reduce redundant data. When we merge the functionality of Arrangements to holdings which follows No-SQL data model. The biggest advantage of the No-SQL model is the flexible schema, so that we can store an entire entity as child entity within an entity. This helps in reducing the number of database queries to get the data. As part of No-SQL standardization many tables in Arrangements MS has been de-normalized and reduced as child entity. It has been helpful in enhancing the performance of Holdings MS.

• Data Model changes are available in Entity Data Model.
• Account Services API changes are available in Account Services.
• API Changes - HMS and AMS Merger APIs.