<HTML><HEAD><TITLE>Framework for Data Management</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="Custom GRC" BORDER=0 HEIiiiGHT=92 WIiiiDTH=248 SRC="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="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>Framework for Data Management&nbsp;&nbsp;&nbsp;</font></td> </tr> </table> </td> </tr> </TABLE> <!--- END OF PAGE NAME ---> <TABLE BORDER=1> <TR> <!------- <TD ROWSPAN=3 VALIGN=top WIDTH=80>&nbsp;</TD> ------> <TD ALIGN=middle><BR> <FONT COLOR=blue FONT=Verdana SIZE=2><B>Layered Data Architecture</B> <BR><BR> <TABLE BORDER=1> <TR> <!--- <TD ALT=middle> ---> <TD VALIGN=top><FONT COLOR=blue FACE="Verdana" SIZE=2>&nbsp;&nbsp; <IMG ALT="Framework for Data Management" BORDER=0 SRC="images/framework_for_data_management.jpg"></TD> <TD ALIGN=middle VALIGN=top><FONT COLOR=blue FACE="Verdana" SIZE=2> &nbsp;&nbsp; <BR>Data Governance ensures compliance with corporate policies and <BR>procedures that effect Enterprise Data Management. <BR><BR> <HR><BR> This is the 'BI Layer' that produces Reports, Mobile KPIs and 'Self-Service BI'. <BR><BR> <HR> <BR>Data Marts are Dimensional Models for specific business areas such as customers or Sales. <BR><BR> <HR> This layer is an Integration Platform that includes a wide range of functionality <BR>- ETL, MDM, a 'Single View of the Truth' <BR><BR> <HR><BR>This is the Staging Areas where data extract files are loaded 'As-Is' directly into temporary tables. <BR><BR> <HR> The Information Catalogue is very important and is often not given the priority that it deserves. <BR>It stores a wide range of Information, including key Roles, such as <bR>Data Stewards, Validation criteria and Transformation procedures for Source Data. </TD> </TR> </TABLE> </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> <BR> <CENTER><FONT SIZE=1><I><FONT COLOR=blue FACE="Verdana" SIZE=1>&#169 DatabaseAnswers.org 2014</I></FONT></CENTER></CENTER> <BR> <!--- 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>