Database Answers British University in Egypt (Click for Web Site)
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
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 :-
  • Accounts
  • Customers
  • Deals
  • Members
  • Settlements
  • Staff
  • Data Mart
  • KPI 1 Data Mart
  • Enterprise Data Model for Paragon

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

  • © DataBase Answers Ltd. 2013
    About Us Contact Us