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.
And here is our Tutorial on How to build a Telecomms Data Warehouse and an Anonymous Model.

This is a Business-oriented Conceptual Model

Conceptual Model for Telecomms
This is a Business-oriented Conceptual Customer Centric Model

Conceptual Customer Centric Model for Telecomms
This shows the ERD for the Conceptual Model shown above on the left

ERD Data 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 to provide data for Reports and Business Intelligence.
  • Self-Service BI POC Proof-of-Concept
    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.

  • Barry Williams
    Principal Consultant
    Database Answers Ltd.
    London, England
    August 5th. 2014

    © DataBase Answers Ltd. 2014

    About Us Contact Us