Database Answers TM Information Framework (Click for large image)
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Telecomms   
An Access Database is available on demand.

The Specifications have been provided in a question to Database Answers.

We would be glad to have your comments.

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

This is a Business-oriented Conceptual Model

Conceptual Model for Telecomms
A Semantic Layer is a business translation layer that sits between the database and the end user. 

This means that Users can define their Reporting requirements using familiar business terminology instead of Data Modeller terms. For example, 'Customer' instead of 'Party'. We have also designed :-
  • Compoments in a Semantic Layer
  • Data Mart for Markets and Brands
  • Data Mart with Conformed Dimensions
  • a Dimensional Model / Data Mart which is very useful for providng data for Reports and Business Intelligence. An interesting perspective is shown in the Information Framework from the TM Forum, and here is Wikipedia's entry for the Telecomm Consortium's Frameworx Shared Information/ Data Model.

  • This shows the ERD for the Conceptual Model shown above

    Data Model for Telecomms


    Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England
    June 1st. 2014


    © DataBase Answers Ltd. 2014

    About Us Contact Us