Architecture

RefDb is a joint development with Mynon and SMR to create an investment banking / management reference and broking (routing) database which can be used to feed Corporate reference applications and or to link applications within an organisation. See architecture.

Features

• All the reference entities required to support investment banking, brokerage, and asset management industry
• A configurable routing broker / hub to support transaction flow between all inter-office applications
• A relational database of your choice to store the data.
• Publish and subscribe XML messages to push the data out to applications.
• A Web enabled user interface to maintain the data.
• Interfaces to get data from external feeds.
• Historical and current data.
• Application gateways for rapid integration into your applications.
• Written in Java and SQL for portability.

Application Scenario

An application will subscribe to a particular set or sets of data using a persistent publish and subscribe topic. This means messages will be queued for the application even it goes off-line. As data is changed in the server it is published to the topic and the application receives the change and uses the data as it sees fit. Typically the application will store the data in its own database.

Advantages

• Allows an organisation's data to be stored in one place significantly reducing maintenance costs and ensuring reliable data is found throughout the organisation.
• The publish and subscribe architecture means that applications do not need to change to take advantage of reliable data, only a simple gateway is required.
• Web based front end allows for the maintenance to be deployed on a regional or global scale.
• Publish and subscribe decouples applications and makes them easier to develop because they have independent database structures.
• Can be configured to route and or add / supplement (in-rich) messages with additional static data to relevant destination/s.

Benefits

• Data syncronisation across front, middle and back office applications.
• Reliable and timely data.
• Data is published hence no need for applications to request data.
• Central (corporate) data store in one place means lower maintenance costs.
• Possible to outsource data maintenance to lower cost centres.
• Provides the foundation for the deployment of regional or global systems.
• Aids management information reporting on a regional and or global basis.
• Web based maintenance screens are easy to upgrade and maintain.
• Industry standard technology is inexpensive and reliable

For more information contact us.

© 2003-2007 Systematic Methods Research Ltd.
All rights reserved.