ÿþ<html> <head><script type="text/javascript" src="/_static/js/bundle-playback.js?v=1WaXNDFE" charset="utf-8"></script> <script type="text/javascript" src="/_static/js/wombat.js?v=txqj7nKC" charset="utf-8"></script> <script type="text/javascript"> __wm.init("https://web.archive.org/web"); __wm.wombat("http://databaseanswers.org:80/types_of_data_models.htm","20200221213421","https://web.archive.org/","web","/_static/", "1582320861"); </script> <link rel="stylesheet" type="text/css" href="/_static/css/banner-styles.css?v=S1zqJCYt" /> <link rel="stylesheet" type="text/css" href="/_static/css/iconochive.css?v=qtvMKcIJ" /> <!-- End Wayback Rewrite JS Include --> <title>Types of Data Models</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link rel="stylesheet" href="/web/20200221213421cs_/http://databaseanswers.org/styles/style.css"> </head> <body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <table name="CHANGE MY WIDTH" width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td> <!-- CHANGING THE WIDTH ABOVE WILL CHANGE ALL PAGE WIDTH --> <table name="HEADER" width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF"> <tr> <td height="100" valign="middle"><img src="/web/20200221213421im_/http://databaseanswers.org/images/dba_400_home.jpg" width="400" height="58" alt="Database Answers"></td> <td align="right" rowspan="2" width="100%"> <img src="/web/20200221213421im_/http://databaseanswers.org/images/spacer.gif" height="100"> </td> </tr> </table> <!--- START OF MAY 21ST. TOP MENU BAR ---> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="32" background="/web/20200221213421im_/http://databaseanswers.org/images/nav_bg.jpg" align="left" valign="middle"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="1%"><img src="/web/20200221213421im_/http://databaseanswers.org/images/spacer.gif" width="15" height="15"></td> <td width="5%" wiiiidth="6%"><a style="text-decoration:none" href="index.htm"><font color="white" face="Verdana" size="2">Home</font></td> <td align="LEFT" width="5%" wiiiidth="10%"><a style="text-decoration:none" href="first_timers.htm"><font color="white" face="Verdana" size="2">First Timers</font></a> </td> <!--- <td align=LEFT WIDTH=5% wiIIIdth="10%"><A STYLE="text-decoration:none" HREF="about_us.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>About Us</font></A> </td> ---> <td width="8%" wiiiidth="10%"><a style="text-decoration:none" href="pi_ask_a_question/index.asp"><font color="#FFFFFF" face="Verdana" size="2"> Ask a Question</font></a></td> <td width="7%"> <a style="text-decoration:none" href="careers.htm"><font color="white" face="Verdana" size="2">Careers</font></a> </td> <td width="7%"><a style="text-decoration:none" href="clients.htm"><font color="#FFFFFF" face="Verdana" size="2">Clients</font></a> </td> <!--- <td align=LEFT WIDTH=8% wiIIIdth="18%"><A STYLE="text-decoration:none" HREF="contact_us.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Contact Us</font></A> </td> ---> <td width="10%"><a style="text-decoration:none" href="data_models/index.htm"><font color="yellow" face="Verdana" size="2">Data Models</font></a></td> <td width="10%"><a style="text-decoration:none" href="tutorials.htm"><font color="#FFFFFF" face="Verdana" size="2">Tutorials</font></a></td> <td width="10%"><a style="text-decoration:none" href="site_map.htm"><font color="#FFFFFF" face="Verdana" size="2">Site Map</font></a></td> </tr> </table> </td> </tr> </table> <!--- END OF MAY 21ST. TOP MENU BAR ---> <table name="MAIN CONTENT" width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="90" background="/web/20200221213421im_/http://databaseanswers.org/images/px-left.gif" valign="top" align="center" bgcolor="#3399CC"> <img src="/web/20200221213421im_/http://databaseanswers.org/images/boschendal_vertical_sml.jpg" width="81" height="122" vspace="5"> <p><img src="/web/20200221213421im_/http://databaseanswers.org/images/spacer.gif" width="90"></p></td> <td valign="top"><img src="/web/20200221213421im_/http://databaseanswers.org/images/spacer.gif" width="3" height="239"></td> <td width="100%" bgcolor="#B0D8FF" valign="top"> <img src="/web/20200221213421im_/http://databaseanswers.org/images/spacer.gif" height="20"> <table width="90%" wiiiidth="590" border="0" cellspacing="0" cellpadding="0"> <tr> <td rowspan="4" valign="top" width="30"><img src="/web/20200221213421im_/http://databaseanswers.org/images/spacer.gif" width="21" height="1"></td> <td width="61">&nbsp;</td> <td rowspan="4" width="6"><img src="/web/20200221213421im_/http://databaseanswers.org/images/spacer.gif" width="6" height="1"></td> <td colspan="3" width="100%" align="right" class="header1">Types of Data Models<img src="/web/20200221213421im_/http://databaseanswers.org/images/spacer.gif" width="5" height="1"> </td> <td width="3" bgcolor="#FF9900"><img src="/web/20200221213421im_/http://databaseanswers.org/images/px-orange.gif" width="3" height="20"></td> </tr> <tr> <td rowspan="3" valign="top" width="1">&nbsp;</td> <td colspan="4" height="3" rowspan="3" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0" height="3"> <tr bgcolor="#FF9900"> <td><img src="/web/20200221213421im_/http://databaseanswers.org/images/px-orange.gif" width="1" height="3"></td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td bgcolor="#FF9900"><img src="/web/20200221213421im_/http://databaseanswers.org/images/px-orange.gif" width="3" height="1"></td> <td><img src="/web/20200221213421im_/http://databaseanswers.org/images/spacer.gif" width="8" height="1"></td> <td width="100%"><font color="blue" face="Verdana" size="2"> Discussion about the full range of the types of Data Models that we need occurs from time to time. <br><br>This is our contribution to the debate, along with <a href="data_models/types_of_data_models/index.htm"> <b>this Page</b></a>. <br>Please feel free to <a href="https://web.archive.org/web/20200221213421/mailto:barryw@databaseanswers.org?subject=Comments on Types of Data Models"><b>Email</a> us and let us know what you think.</b>. <br><br>This table shows a list, with the BI layer at the top, and then going down to the Operational Data Sources. </td> </tr> </table> </td> </tr> <tr> </tr> <tr> </tr> </table> <br> <table width="90%" wiiiidth="590" border="0" cellspacing="0" cellpadding="0"> <tr> <td rowspan="4" valign="top" width="30"><img src="/web/20200221213421im_/http://databaseanswers.org/images/spacer.gif" width="21" height="1"></td> <td width="61">&nbsp;</td> <td rowspan="4" width="6"><img src="/web/20200221213421im_/http://databaseanswers.org/images/spacer.gif" width="6" height="1"></td> <td colspan="3" width="100%" align="right" class="header1">Here is our current draft list of the different Types of Data Models<img src="/web/20200221213421im_/http://databaseanswers.org/images/spacer.gif" width="5" height="1"> </td> <td width="3" bgcolor="#FF9900"><img src="/web/20200221213421im_/http://databaseanswers.org/images/px-orange.gif" width="3" height="20"></td> </tr> <tr> <td rowspan="3" valign="top" width="1">&nbsp;</td> <td colspan="4" height="3" rowspan="3" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0" height="3"> <tr bgcolor="#FF9900"> <td><img src="/web/20200221213421im_/http://databaseanswers.org/images/px-orange.gif" width="1" height="3"></td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td bgcolor="#FF9900"><img src="/web/20200221213421im_/http://databaseanswers.org/images/px-orange.gif" width="3" height="1"></td> <td><img src="/web/20200221213421im_/http://databaseanswers.org/images/spacer.gif" width="8" height="1"></td> <td width="100%" valign="top"> <img src="/web/20200221213421im_/http://databaseanswers.org/images/spacer.gif" height="1" width="1"> <br> <table wiiiidth="590" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="25"><img src="/web/20200221213421im_/http://databaseanswers.org/images/spacer.gif" width="25" height="1"></td> <td bgcolor="#3399CC" width="20"><img src="/web/20200221213421im_/http://databaseanswers.org/images/circle1.gif" width="20" height="20"> </td> <td bgcolor="#3399CC" class="header2" width="100%"> <div align="center"><!--- PUT TEXT HERE FOR TOP OF TABLE --->&nbsp;</div> </td> <td bgcolor="#3399CC" width="20" valign="top" align="right"><img src="/web/20200221213421im_/http://databaseanswers.org/images/circle2.gif" width="20" height="20"></td> </tr> <tr> <td width="25">&nbsp;</td> <td colspan="3"> <table width="100%" border="0" cellspacing="3" cellpadding="3" bgcolor="#3399CC"> <tr bgcolor="#B0D8FF"> <td class="cell" width="50%"><img src="/web/20200221213421im_/http://databaseanswers.org/images/white-point.gif" width="17" height="8"><a class="cell" hreeeef="what_is_a_dba.htm">BI Layer</a></td> <td class="cell" width="50%"> Presents the data required for BI Analysis and Reports.The Model generally looks like the Semantic Data Mode, in the next level.</td> </tr> <tr bgcolor="#B0D8FF"> <td class="cell" valign="top" width="50%"><img src="/web/20200221213421im_/http://databaseanswers.org/images/white-point.gif" width="17" height="8"><a class="cell" hreeeef="http://www.jobstats.co.uk" target="_NEW">Semantic Data Model</a></td> <td class="cell" width="50%">This combines presentation of the data with an indication of the meaning of the data. <br>Here is <a href="https://web.archive.org/web/20200221213421/https://en.wikipedia.org/wiki/Semantic_data_model" target="_NEW">Wikipedia's view</a> and their example <br><center> <img src="/web/20200221213421im_/http://databaseanswers.org/images/Wikipedias_Semantic_Data_Model_med.jpg"> </td> </tr> <tr bgcolor="#B0D8FF"> <td class="cell" width="50%"><img src="/web/20200221213421im_/http://databaseanswers.org/images/white-point.gif" width="17" height="8"><a class="cell" hreeeef="http://www.jobstats.co.uk" target="_NEW">Conceptual Data Model</a></td> <td class="cell" width="50%">A business user view of the data.</td> </tr> <tr bgcolor="#B0D8FF"> <td class="cell" width="50%"><img src="/web/20200221213421im_/http://databaseanswers.org/images/white-point.gif" width="17" height="7"> <a class="cell" hreeeef="http://www.sqlservercentral.com/articles/Administration/61680/" target="_NEW">Data Marts</td> <td class="cell" width="50%">Presents the restricted sets of data required for specific Report families. They usually have the same Dimensions and Facts structure that we find in Dimensional Models. </td> </tr> <tr bgcolor="#B0D8FF"> <td class="cell" valign="top" width="50%"><img src="/web/20200221213421im_/http://databaseanswers.org/images/white-point.gif" width="17" height="7"> <a class="cell" hreeeef="http://www.sqlservercentral.com/articles/Administration/61680/" target="_NEW">Dimensional Models</td> <td class="cell" width="50%">Characterised by Dimensions and Facts. <br>Here is an example of a Generic Data Mart :- <br><img alt="Generic Data Mart" src="/web/20200221213421im_/http://databaseanswers.org/images/generic_data_mart.gif"> </td> </tr> <tr bgcolor="#B0D8FF"> <td class="cell" valign="top" width="50%"><img src="/web/20200221213421im_/http://databaseanswers.org/images/white-point.gif" width="17" height="7"><a class="cell" hreeeef="dba_as_a_career.htm"> Third Normal Form Data Warehouse</a></td> <td class="cell" width="50%">The Third Normal Form helps ensure a Single View of the Truth. <br>It is usually a subset of the more comprehensive Enterprise Data Model. <br>This is an example of a 3NF Data Warehouse for Hotel Check-In :- <br><img alt="Third Normal Form Data Warehouse for Hotel Check-In" src="/web/20200221213421im_/http://databaseanswers.org/images/DWH_for_Hotel_Check_in.gif"> </td> </tr> <tr bgcolor="#B0D8FF"> <td class="cell" valign="top" width="50%"><img src="/web/20200221213421im_/http://databaseanswers.org/images/white-point.gif" width="17" height="7"><a class="cell" hreeeef="careers_in_data_migration.htm"> Enterprise Data Model </a></td> <td class="cell" width="50%" bgcolor="#B0D8FF">Partial or Complete</td> </tr> <tr bgcolor="#B0D8FF"> <td class="cell" valign="top" width="50%"><img src="/web/20200221213421im_/http://databaseanswers.org/images/white-point.gif" width="17" height="7"> <a class="cell" hreeeef="careers_in_data_warehousing.htm"> Subject Area Data Models</a></td> <td class="cell" width="50%">Pretty much essential - in other words, if you don't find one, then there is something wrong.</td> </tr> <tr bgcolor="#B0D8FF"> <td class="cell" valign="top" width="50%"><img src="/web/20200221213421im_/http://databaseanswers.org/images/white-point.gif" width="17" height="7"> Canonical Data Model</a></td> <td class="cell" width="50%">Very valuable, check out <a class="cell" href="data_models/canonical_data_models/index.htm"> <b>our current thinking</b></a>. <br>Here is the current incarnation of the Canonical Data Model :- <br><img alt="Canonical Data Model" src="/web/20200221213421im_/http://databaseanswers.org/images/canonical_data_model.gif"> </td> </tr> <tr bgcolor="#B0D8FF"> <td class="cell" valign="top" width="50%"><img src="/web/20200221213421im_/http://databaseanswers.org/images/white-point.gif" width="17" height="7"> Operational Data Stores</td> <td class="cell" wiiiidth="70%">Can be in a range of formats - from a simple CSV file, to an ODBC connection, to a bespoke SAP or Salesforce interface. <br>Here are my wife and myself on a recent holiday in Malaysia riding on an Elephant, with the "ticket to ride" (ie the ODS) and the ODS Entity :- <br><img alt="Elephant Ride" src="/web/20200221213421im_/http://databaseanswers.org/images/Elephant_Ride_sml.jpg"> <img alt="Ticket for the Elephant Ride" src="/web/20200221213421im_/http://databaseanswers.org/images/Elephant_Ride_ticket_sml.jpg"> <img alt="Generic Sales Receipt for Malaysia" src="/web/20200221213421im_/http://databaseanswers.org/images/generic_sales_receipt_for_malaysia_sml.gif"> </td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#3399CC"> <tr> <td><img src="/web/20200221213421im_/http://databaseanswers.org/images/circle4.gif" width="20" height="20"></td> <td width="100%">&nbsp;</td> <td align="right"><img src="/web/20200221213421im_/http://databaseanswers.org/images/circle3.gif" width="20" height="20"></td> </tr> </table> </td> </tr> </table> </td> </tr> <tr> </tr> <tr> </tr> </table> <br> </td> </tr> </table> </td> </tr></table> <!--- START OF MAY 21ST. BOTTOM MENU BAR ---> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="32" background="/web/20200221213421im_/http://databaseanswers.org/images/nav_bg.jpg" align="left" valign="middle"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="80%"><img src="/web/20200221213421im_/http://databaseanswers.org/images/spacer.gif" width="80" height="15"></td> <td align="LEFT" width="10%"><a style="text-decoration:none" href="about_us.htm"><font color="#FFFFFF" face="Verdana" size="2">About Us</font></a> </td> <td align="LEFT" width="15%"><a style="text-decoration:none" href="contact_us.htm"><font color="#FFFFFF" face="Verdana" size="2">Contact Us</font></a> </td> </tr> </table> </td> </tr> </table> <!--- END OF may 21st. BOTTOM MENU BAR ---> <!-- HERE BASE TABLE CLOSES, INSIDE WHICH ALL PAGE IS PLACED, AND WHICH WIDTH IS 90 PERCENTS --> </td> </tr> </table> </body> </html> <!-- FILE ARCHIVED ON 21:34:21 Feb 21, 2020 AND RETRIEVED FROM THE INTERNET ARCHIVE ON 17:51:40 Jun 27, 2023. JAVASCRIPT APPENDED BY WAYBACK MACHINE, COPYRIGHT INTERNET ARCHIVE. ALL OTHER CONTENT MAY ALSO BE PROTECTED BY COPYRIGHT (17 U.S.C. SECTION 108(a)(3)). --> <!-- playback timings (ms): captures_list: 221.728 exclusion.robots: 0.071 exclusion.robots.policy: 0.06 RedisCDXSource: 11.045 esindex: 0.01 LoadShardBlock: 192.222 (3) PetaboxLoader3.datanode: 223.759 (4) load_resource: 140.792 PetaboxLoader3.resolve: 35.306 -->