<HTML><HEAD><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="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="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="images/nav_bg.jpg" align="left" valign="middle"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="1%"><img src="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="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="images/nav_bg.jUg" align="left" valign=top> <table width="10%" border="0" cellspacing="0" cellpadding="0"> <tr> <td background="images/nav_bg.jpg" valign=top width="1%"><img src="images/spacer.gif" width="15" height="15"></td> <td ALIGN=left background="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="http://www.amazon.com/Mashup-Patterns-Designs-Examples-Enterprise-ebook/dp/B0027976O0/ref=sr_1_1?s=books&ie=UTF8&qid=1387281103&sr=1-1&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="images/bi_layer.jpg"> <BR><BR> <IMG ALT="Four Layer Data Architecture" BORDER=0 SRC="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="images/nav_bg.jpg" align="left" valign="middle"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="80%"><img src="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>