Bank of Montreal
Systems and methods for data mart rationalization

Abstract:

Disclosed herein are embodiments of systems, methods, and products comprises an analytic server for data rationalization and migration. The server receives data from a plurality of electronic data sources and stores the received data into a database within a central hub. The server demobilizes the data and performs enhancement on the data to prepare the data for complex calculation. The server copies the enhanced data to an operational data store, performs various calculation functions that filer, rationalize the data, and create data linkage. The server copies back the calculation result to the database for further processing and downstream consumption. The calculation results provide a consolidated view of data from different source systems and satisfy the reporting needs for different consumers. The server uses common data model to generate reports for different consumers. After the data migration and consolidation into a central hub, the server decommissions legacy components.