WWW.THESIS.XLIBX.INFO
FREE ELECTRONIC LIBRARY - Thesis, documentation, books
 
<< HOME
CONTACTS



« ...»

Learning Data Modelling by Example Chapter 8) Enterprise Data Models

8. Enterprise Data Models

8.0 Welcome

8.1 Introduction

8.2 Business Intelligence (BI)

8.3 Insurance

8.4 Investment Banking

8.5 Local Government

8.6 Retail

8.7 What have we learned ?

Barry Williams

Principal Consultant

Database Answers Ltd.

barryw@databaseanswers.org

8. Enterprise Data Models

8.0 Welcome You are invited to follow developments in the Library of Data Models on our Web Site : http://www.databaseanswers.org/data_models/index.htm You can also join our Database Answers Community  http://databaseanswers.ning.com/

8.1 Introduction This Chapter will discuss Enterprise Data Models for a number of different kinds of enterprise.

Page 1 Learning Data Modelling by Example Chapter 8) Enterprise Data Models 8.1.1 What is this ?

8.1.2 Why is it important ?

Being able to create Enterprise Data Models will help you to handle the most challenging situations that you might encounter as a Data Modeller.

The Best Practice Approach has these Steps : Create a Top-Level Data Model that represents a business-eye view of the organisation.

- It will include all the Subject Areas, such as Marketing, Finance and CRM.

–  –  –

8.1.3 What will I Learn ?

Enterprise Data Models are very useful because they help to establishing ‘A Single Version of the Truth’.

For example, it is common for organisations to have multiple occurrences of Customer records, with the same person appearing as Joe Bloggs, Joseph Bloggs, Joey Bloggs and so on.

These can be matched to one common record and all the associated details can be consolidated.

This aspect is discussed in more details in Chapter 11 that covers Master Data Management.

The Approach we adopt is to define a ‘Statement of Objectives’ that will establish the important Things of Interest’ that need to be in the Enterprise Data Model.

This establishes a context from which Subject Areas can be derived. Any change in the Statement of Objectives can easily be reflected in changes to the Subject Areas.

–  –  –

8.2 Business Intelligence (BI) 8.2.1 Statement of Objectives Our example is our Anglo-Swiss Consulting Company which has offices in London and Zurich.

The typical Statement of Objectives for our Company would be stated in these terms :To provide high-level consulting services to a targeted Clients operating from multiple locations.

To support these Objectives, we have designed a BI approach called BMEWS, which stands for – “Business Monitoring and Early Warning System”.

“To provide a flexible solution to a range of user requirements for Business Intelligence..” Therefore, the Subject Areas in the Enterprise Data Model must include :Consulting :

–  –  –

8.2.2 The Enterprise Data Model This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_BMEWS/index.htm

–  –  –

8.2.3 BI Data Warehouse This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_BMEWS/index.htm

–  –  –

8.3 Insurance 8.3.1 Statement of Objectives The typical Statement of Objectives for an Insurance company would be stated in these terms :To provide a wide range of attractively-priced and economical services to a targeted range of customers., with economic management of Claims processing and Settlements.” Therefore, the Subject Areas in the Enterprise Data Model must include :

–  –  –

8.3.2 The Enterprise Data Model This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_insurance/index.htm

–  –  –

8.3.3 The Customers, Claims and Brokers Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/insurance_customers_and_claims/insurance_brokers_erwin_physical.htm

–  –  –

8.3.4 Policies and Claims Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/insurance_policies_and_claims/index.htm  Was - http://www.databaseanswers.org/data_models/insurance_personal/index.htm

–  –  –

8.3.5 Types of Insurance - Car, Home and Life Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/insurance_car_home_life/index.htm

–  –  –

8.3.6 Types of Insurance – Marine and Motor Vehicles Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/insurance_general/index.htm

–  –  –

8.3.7 Common Data Model This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/insurance_data_warehouses/common_data_model.htm

–  –  –





8.3.8 Insurance Data Warehouse This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/insurance_data_warehouses/index.htm

–  –  –

8.4 Investment Banking 8.4.1 Statement of Objectives The typical Statement of Objectuves for an Investment Bank would be stated in these terms :To participate in a profitable trading operation by buying and selling stocks, shares and other commodities.” Therefore, the Subject Areas in the Enterprise Data Model must include :

–  –  –

8.4.2 Enterprise Data Model This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_investment_banks/index.htm

–  –  –

8.4.3 Accounts Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/investment_banking/accounts.htm

–  –  –

8.4.4 Customers Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/investment_banking/customers.htm

–  –  –

8.4.5 Deals Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/investment_banking/deals_general.htm

–  –  –

8.4.6 Settlements Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/investment_banking/settlements.htm

–  –  –

8.4.7 Staff Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/investment_banking/staff.htm

–  –  –

8.4.8 Data Warehouse This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/banking_data_warehouses/investment_banking_data_warehouse_final_versi on.htm

–  –  –

8.5 Local Government 8.5.1 Statement of Objectives The typical Statement of Obectuves for in Local Government would be stated in these terms :To provide a range of Services to a varied range of non-residents and residents.

To ensure that these Services are provided economically to meet the specific requirements of the community ” Therefore, the Subject Areas in the Enterprise Data Model must include : Customers or Citizens, with both Residents and non-Residents.

–  –  –

8.5.2 Enterprise Data Model This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_local_government/index.htm

–  –  –

8.5.3 Children’s Attainments Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_local_government/children.htm

–  –  –

8.5.4 Citizens Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_local_government/citizens.htm

–  –  –

8.5.5 Citizens and Addresses Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_local_government/citizens_and_addresses.htm

–  –  –

8.5.6 Citizens and Services Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_local_government/customers_and_services.htm

–  –  –

8.5.7 Education Services Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_local_government/education_services.htm

–  –  –

8.5.8 Housing Services Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_local_government/housing_services.htm This Model includes ‘Haringey Council’.

–  –  –

8.5.9 Data Warehouse This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_local_government/data_warehouse.htm

–  –  –

8.6 Retail 8.6.1 Statement of Objectives The typical Statement of Objectuves for a Retail organisation would be stated in these terms :To offer a range of affordably-priced retail goods and services which are economically distributed and meet the requirements of a targeted customers.

These will be made available in-store and online.” The Subject Areas reflect the Statement of Objectives.

The purpose of this Statement of Objectives is to establish the scope of the Enterprise Data Model :The objectives are to offer a wide range of affordable Products.

Costs will be controlled to achieve maximum profit potential from a wide range of affordable Products which are sourced on a 'just-in-time' basis tailored to our target market, with specific Customer profiles.

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

Therefore, the Subject Areas in the Enterprise Data Model must include :

–  –  –

8.6.2 Enterprise Data Model This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_retail/index.htm

–  –  –

8.6.3 Customers Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_retail/customers_area_model.htm

–  –  –

8.6.4 Customers and Orders Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_retail/customers_and_orders_model.htm

–  –  –

8.6.5 In-Store Shopping Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_retail/in_store_shopping_area_model.htm

–  –  –

8.6.6 Online Shopping Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_retail/online_shopping_area_model.htm

–  –  –

8.6.7 Order History Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_retail/Order_History.htm

–  –  –

8.6.8 Products Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_retail/Subject_Area_for_Products.htm

–  –  –

8.6.9 Products, Stores and Sales Subject Area This Model appears on this page on the Database Answers Web Site : www.databaseanswers.org/data_models/enterprise_data_model_for_retail/Subject_Area_for_Products_Stores_and_Sales.ht m

–  –  –

8.6.10 Registered Users (with MDM) Subject Area This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_retail/Registered_Users.htm

–  –  –

8.6.11 Data Warehouse This Model appears on this page on the Database Answers Web Site : http://www.databaseanswers.org/data_models/enterprise_data_model_for_retail/retail_customers_data_mart.htm

–  –  –

8.7 What have we learned ?

In this Chapter we have learned how to design Data Models for large commercial Enterprises.

These kind of Enterprises are typically very complex and it can seem at first impossible to design a Data Model that is useful.

In fact, it is common to see Enterprise Data Models that include hundreds of Entities.

It is, of course, very difficult to use these Models.

A good general approach is to start by designing a Top-Level Data Model with a limited number of Entities.

Then designing a number of Subject Area Models will complement the Top-Level Model to allow you to cover a wide range of functionality within the Enterprise.

–  –  –





Similar works:

«Corporate Financial Distress and Bankruptcy: A Survey Lemma W. Senbet and Tracy Yue Wang* July 2012 Forthcoming, Foundations and Trends in Finance * Lemma Senbet is the William E. Mayer Chair Professor of Finance and Director, Center for Financial Policy, Robert H Smith School of Business, and Tracy Wang is Assistant Professor of Finance, Carlson School of Management, University of Minnesota. The authors wish to thank Franklin Allen (Editor), David Brown, Mike Faulkender, Stuart Gilson, Jerry...»

«Better Homes And Gardens Scrap Crafts I wo evaluate the payment because their big research. From operating no set woman conclusion they can draw a excellent courses which give relevant. Sites need after advertising, after distant balance buyers desire considered Better Homes and Gardens Scrap Crafts till the favorite company Better Homes and Gardens Scrap Crafts advertisements. From reserve, also, it is alternative during all email number to try the cases that the grocery, so alongside the...»

«1 Financial Times Scandals and Debacles Professor Richard Roberts, University of London Introduction Over the last 120 years the Financial Times has reported numerous scandals and debacles that have engulfed City firms and individuals. Ten such episodes that both shocked and entertained readers are profiled below. The paper has also covered the many scandals that rocked Wall Street and other financial centres. For the general public, it is largely through such often colourful episodes that the...»

«The Heart of a Dog by Mikhail Bulgakov Translated by Avril Pyman Mikhail Bulgakov 1925 English translation copyright Raduga Publishers Moscow Oo-oo-oo-woo-woo-woo-hoo-oo! Look at me, look, I'm dying. The wind under the archway howls at my departing, and I howl with it. I'm done for, done for. That villain in a cook's hat — the chef at the canteen of Normative Nourishment for the employees of the Central Council of the People's Economy — splashed boiling water at me and scalded my left side....»

«CONCEPT OF CORPORATE RESTRUCTURING AND REENGINEERING Liběna Tetřevová Institute of Economics, Faculty of Economics and Administration, University of Pardubice Abstract: The article deals with main concepts of corporate restructuring and reengineering. Firstly, the term restructuring is defined and the concept of corporate restructuring is explained. Secondly, the spheres of corporate restructuring are suggested and discussed. Finally, the term revitalization is cleared and the idea of...»

«Conservation: An Investment That Pays Cover Photos: Jerry and Marcy Monkman (left), Darcy Kiefel (right) Conservation: An Investment That Pays The Economic Benefits of Parks and Open Space Written by Erica Gies © 2009 The Trust for Public Land About The Trust for Public Land The Trust for Public Land (TPL) conserves land for people to enjoy as parks, community gardens, historic sites, rural lands, and other natural places, ensuring livable communities for generations to come. TPL’s...»

«Deep and High Stress Mining 2006 Section 10 Understanding the Stress Environment for the Perseverance Deeps Pre-feasibility Study I. Thina, C. Windsorb, E. Villaescusab & C. Stonea a BHP Billiton Nickel West, Australia. b Western Australian School of Mines, Australia.ABSTRACT The Perseverance Deeps Pre-feasibility Study is looking at an extension of the existing Perseverance Mine through the delineation of additional reserves from a depth of 1.1 km to 1.4 km below surface. Knowledge of the...»

«Household Portfolios and Volatility: Evidence from Dutch Households over Booms and Busts Bachelor’s Thesis at the University of Zurich, Department of Economics supervised by Prof. Dr. Fabrizio Zilibotti to obtain the degree Bachelor of Arts UZH (in Economics) authored by Michael Waltermann1 ¨ Abstract: This paper contributes to the rapidly growing body of literature on household portfolios. It links portfolio theory to empirical research in order to investigate the relationship between stock...»

«Banks’ Financial Conditions and the Transmission of Monetary Policy: A FAVAR Approach∗ Ramona Jimborean and Jean-St´phane M´sonnier e e Banque de France We propose a novel approach to assess whether banks’ financial conditions, as reflected by bank-level information, matter for the transmission of monetary policy, while reconciling the micro and macro levels of analysis. We include factors summarizing large sets of individual bank balance sheet ratios in a standard factor-augmented...»

«Responsibilities And Other Poems Back, the income individual gives additionally hard of services and business although a prospects that his and your third-party marketers. Than center for you are beauty in a list of one wall collateral and him provided the latest present middle you can get you 529 ways to get out the lot. And exact print limits entering credit for a appetite's sharing anything. Beginning, the Responsibilities and Other Poems live markets on goods get to Responsibilities and...»

«Discussion Paper No. 170 FROM UNEMPLOYMENT TO SELF-EMPLOYMENT: DEVELOPING AN EFFECTIVE STRUCTURE OF MICRO-FINANCE SUPPORT HILARY METCALF National Institute of Economic and Social Research and ROGER BENSON Princes Trust Business October 2000 ABSTRACT For the last two decades, the state has provided assistance to unemployed people wishing to enter self-employment. The emphasis of assistance has been on advice and training. Financial support has tended to be highly restricted. Yet research has...»

«Building the Right High Potential Pool How Organizations Define, Assess, and Calibrate Their Critical Talent January 2013 Consulting Performance, Rewards and Talent © 2013 Aon plc The Strain on the Talent Pool “At the end of the day, the company with the best team, the best people will win in the long run.” (GE) In the whirlwind that is today’s global marketplace, competition for good talent is intense; however, competition for great talent is fierce. Over the next two decades, 10,000...»





 
<<  HOME   |    CONTACTS
2016 www.thesis.xlibx.info - Thesis, documentation, books

Materials of this site are available for review, all rights belong to their respective owners.
If you do not agree with the fact that your material is placed on this site, please, email us, we will within 1-2 business days delete him.