Data Model for Stock Exchanges


Printer-friendly version

Careers

Data Model for Stock Exchanges

An Access Database is available.

The Requirements were derived from a review of the Web Site for the NASDAQ OMX (Swedish Stock Exchange) and the Wikipedia entry for the Stockholm Stock Exchange

We would be glad to have your comments.

Here is the Presentation / Marketing Pack.

If you are new to Data Models, this page of one of this Tutorial will help you understand the Data Model.

There is also a design for a Data Mart, which is very useful for providng data for Reports and Business Intelligence.

Teradata offers a Financial Services Logical Model, and IBM offers a Data Warehouse for Banking and FInancial Markets.

Data Model for Stock Exchanges

We start by agreeing a Statement of Business Objectives to establish the scope of the Enterprise Data Model.

Once we have agreed the Statement of Business Objectives we can create a draft Top-Level Model with associated Subject Areas, each of which is shown in its own Model.

This is an example of a Statement of Business Objectives for an Investment Bank :-
"Our Business objectives are to offer a range of Services to Clients, which can be either organizations or High-Net-Worth Individuals.
These Services will involve completing Deals for our Clients in which our Staff will participate with the purpose of achieving acceptable returns on investment.
Brokers may participate in these Deals, which will all be completed by Settlements.
Deals may involve multiple Currencies and incur subsequent Transactions, such as adjustments.

The Enterprise Data Model will establish the data available for a Data Warehouse to meet Business Intelligence requirements."

We have also created Data Models for these Subject Areas :-

Enterprise Data Model for Paragon

Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
January 25th. 2013

About Us