ÿþ<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/reference_data_architecture_with_mashups.htm","20210508104557","https://web.archive.org/","web","/_static/", "1620470757"); </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 Architectures with Mashups</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/20210508104557im_/http://databaseanswers.org/images/dba_400_home.jpg"> </td> <td align="right" height="95" rowspan="2" valign="middle"> <img align="right" alt="Map of Fiji (where I met my Wife) and the South Pacific" border="1" height="92" width="248" src="/web/20210508104557im_/http://databaseanswers.org/images/site_map_vsml.gif"> </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/20210508104557im_/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/20210508104557im_/http://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 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="#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 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="https://web.archive.org/web/20210508104557/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/20210508104557im_/http://databaseanswers.org/images/nav_bg.jUg" align="left" valign="top"> <table width="10%" border="0" cellspacing="0" cellpadding="0"> <tr> <td background="/web/20210508104557im_/http://databaseanswers.org/images/nav_bg.jpg" valign="top" width="1%"><img src="/web/20210508104557im_/http://databaseanswers.org/images/spacer.gif" width="15" height="15"></td> <td align="left" background="/web/20210508104557im_/http://databaseanswers.org/images/nav_bg.jpg" height="32" width="10%"><pre><font color="yellow" colouuur="#FFFFFF" face="Verdana" size="2">Reference Data Architecture with Mashups&nbsp;&nbsp;&nbsp;</font></td> </tr> </table> </td> </tr> </table> <!--- END OF PAGE NAME ---> <table> <tr> <td rowspan="3" valign="top" width="80">&nbsp; </td> <td><br> <font color="blue" font="Verdana" size="2"><b>This shows how the Mashups Patterns in <a href="https://web.archive.org/web/20210508104557/http://www.amazon.com/Mashup-Patterns-Designs-Examples-Enterprise-ebook/dp/B0027976O0/ref=sr_1_1?s=books&amp;ie=UTF8&amp;qid=1387281103&amp;sr=1-1&amp;keywords=ogrinz" target="_NEW"> Mike Ogrinz's Book</a> could be used to implement our Reference Data Architecture</b> <br><br> <table border="1"> <tr> <!--- <TD ALT=middle> ---> <td valign="top"><font color="blue" face="Verdana" size="2">&nbsp;&nbsp; <b>Layers in our Data Architecture</b> <hr> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img alt="BI Layer" border="0" src="/web/20210508104557im_/http://databaseanswers.org/images/bi_layer.jpg"> <br><br> <img alt="Four Layer Data Architecture" border="0" src="/web/20210508104557im_/http://databaseanswers.org/images/4_layer_data_architecture.jpg"></td> <td valign="top"><font color="blue" face="Verdana" size="2"> &nbsp;&nbsp; <b>Mashup Patterns from Mike's Book&nbsp;&nbsp;</b> <hr> Alerter (Pub/Sub) <br> Portal Enabler <br>Dashboard Pattern <br>Distributed Drill-Down <hr> <br>Content Integration <br><br> <hr><br> <br>Content Integration (DWH) <br>Location Mapping <br><br><br><br><br> <hr>Splinter (P.239) - Data extraction, transformation <hr><br><br><br> Feed Factory </td> </tr> </table> <!--- <HR> <A HREF="http://www.compositesw.com/" TAREGT=_NEW>Composite Software</A> offers a <A HREF="http://www.compositesw.com/solutions/cloud-data-integration/" TARGET=_NEW>Cloud Data Integration Solution</A> which is a commercial implementation of our Integrated Data Layer. <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 2014</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/20210508104557im_/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/20210508104557im_/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 ---> </td></tr> </table> </td> </tr> </table> </body> </html> <!-- FILE ARCHIVED ON 10:45:57 May 08, 2021 AND RETRIEVED FROM THE INTERNET ARCHIVE ON 17:15:33 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: 71.509 exclusion.robots: 0.07 exclusion.robots.policy: 0.061 RedisCDXSource: 0.666 esindex: 0.009 LoadShardBlock: 51.83 (3) PetaboxLoader3.datanode: 51.687 (4) load_resource: 764.258 PetaboxLoader3.resolve: 144.449 -->