ÿþ<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://www.databaseanswers.org/reference_data_architecture.htm","20211205052236","https://web.archive.org/","web","/_static/", "1638681756"); </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>Reference Data Architecture</title></head> <body text="#202020"> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> <td align="left" height="100" valign="middle"> <img alt="Database Answers Header" height="58" width="400" src="/web/20211205052236im_/http://www.databaseanswers.org/images/dba_400_home.jpg"> </td> <td align="right" rowspan="2" valign="middle"> <img align="right" alt="Custom GRC" border="0" src="/web/20211205052236im_/http://www.databaseanswers.org/images/info_architecture_sml.jpg"> </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/20211205052236im_/http://www.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/20211205052236im_/http://www.databaseanswers.org/images/spacer.gif" width="15" height="15"></td> <td width="4%"><a style="text-decoration:none" href="index.htm"><font color="white" face="Verdana" size="2">Home</font></td> <td align="LEFT" width="5%"><a style="text-decoration:none" href="first_timers.htm"><font color="white" face="Verdana" size="2">First Timers</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="#FFFFFF" 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 width="10%"><a style="text-decoration:none" href="https://web.archive.org/web/20211205052236/http://databaseanswers.ning.com/" target="_NEW"><font color="#FFFFFF" face="Verdana" size="2">Community</font></a></td> <td width="10%"><a style="text-decoration:none" href="data_models/index.htm"><font color="#FFFFFF" 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 ---> <font color="blue" face="Verdana" size="2"> <!--- START OF PAGE NAME ---> <font color="blue" face="Verdana" size="2"> <table bgcolor="#B0D8FF" bgcolouuur="#98CEFD" border="0" cellpadding="5" cellspacing="5" width="100%"> <tr> <td height="32" background="/web/20211205052236im_/http://www.databaseanswers.org/images/nav_bg.jUg" align="left" valign="top"> <table width="10%" border="0" cellspacing="0" cellpadding="0"> <tr> <td background="/web/20211205052236im_/http://www.databaseanswers.org/images/nav_bg.jpg" valign="top" width="1%"><img src="/web/20211205052236im_/http://www.databaseanswers.org/images/spacer.gif" width="15" height="15"></td> <td align="left" background="/web/20211205052236im_/http://www.databaseanswers.org/images/nav_bg.jpg" height="32" width="10%"><pre><font color="yellow" colouuur="#FFFFFF" face="Verdana" size="2">Our Reference Data Architecture&nbsp;&nbsp;&nbsp;</font></td> </tr> </table> </td> </tr> </table> <!--- END OF PAGE NAME ---> <!--- END OF MAY 21ST. TOP MENU BAR ---> <font color="blue" face="Verdana" size="2"> <tr> <td rowspan="3" valign="top" width="80">&nbsp; </td> <td> <font color="blue" font="Verdana" size="2"><b>On the left, we show our Reference Data Architecture</b> and on the right, we show how this compares to <b>the ZAP Data Hub</b>. <!---- Architecture is extended to integrate Big Data. -----------> <br><br>&nbsp;&nbsp;We also show the <a href="data_models/big_data/Teradata_Unified_Data_Architecture.htm">Teradata Unified Data Architecture</a>. <br><br>&nbsp;&nbsp;Here is a <a href="framework_for_data_mgt.htm">Framework for Data Management</a> that provides a short description of each Layer. and an <a href="data_models/event_driven_platform/index.htm">Event Driven Platform</a> based on our <a href="data_models/canonical_data_models/index.htm">Canonical Data Model</a>. <br>&nbsp;&nbsp;Each Layer has its own Data Models <br><br> <table border="1"> <td align="middle" valign="top"> <font color="red" font="Verdana" size="2"><b> 1) Our Reference Data Architecture <!------------- <BR>updated after checking out <A HREF="oracle_reference_data_architecture.htm"></A> -----------> <!---------- <BR><BR> <IMG ALT="Reference Data Architecture" BORDER=0 SRC="images/data_governance_logo.jpg"> ------------> <br> <img alt="Reference Data Architecture" border="0" src="/web/20211205052236im_/http://www.databaseanswers.org/images/reference_data_architecture_v1.gif"> </td> <!--------------- <TD ALIGN=middle VALIGN=top> <FONT COLOR=red FONT=Verdana SIZE=2><B> 2) A Simple Enterprise Data Pipeline <BR><BR> <IMG ALT="Reference Data Architecture" BORDER=0 SRC="images/MLV2.jpg"> </TD> -----------> <td align="middle" valign="top"> <font color="red" font="Verdana" size="2"><b> 2) How the ZAP Data Hub compares <br><br> <img alt="ZAP Data Hub" border="0" src="/web/20211205052236im_/http://www.databaseanswers.org/images/zap_data_hub.jpg"> </td> </tr> </table> <hr> <a href="https://web.archive.org/web/20211205052236/http://www.compositesw.com/" target="_NEW">Composite Software</a> offers a <a href="https://web.archive.org/web/20211205052236/http://www.compositesw.com/solutions/cloud-data-integration/" target="_NEW">Cloud Data Integration Solution</a> which is a commercial implementation of our Integration Platform. <br><br> In many organisations, Salesforce.com and SAP are common Data Sources, along with an Oracle presence, such as Business Process Management. <br>Therefore, we would always look for <b>off-the-shelf 'Adaptors'</b> for these Sources. </td> </tr> <tr> <td> <br> <center><font size="1"><i><font color="blue" face="Verdana" size="1">&#169; DatabaseAnswers.org 2018</i></font></center></center> <br> </td> </tr> </table> </table> <!--- START OF MAY 21ST. BOTTOM MENU BAR ---> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="32" background="/web/20211205052236im_/http://www.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/20211205052236im_/http://www.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 ---> </td></tr> </table> </td> </tr> </table> </body> </html> <!-- FILE ARCHIVED ON 05:22:36 Dec 05, 2021 AND RETRIEVED FROM THE INTERNET ARCHIVE ON 17:15:29 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: 88.169 exclusion.robots: 0.068 exclusion.robots.policy: 0.059 RedisCDXSource: 7.075 esindex: 0.008 LoadShardBlock: 62.715 (3) PetaboxLoader3.datanode: 99.153 (5) load_resource: 720.188 (2) PetaboxLoader3.resolve: 658.102 (2) -->