ÿþ<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/data_models/citizen_developer_stuff/index.htm","20180916130501","https://web.archive.org/","web","/_static/", "1537103101"); </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>Data Models for Citizen Developer's Stuff</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link rel="stylesheet" href="/web/20180916130501cs_/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/20180916130501im_/http://databaseanswers.org/images/dba_400_home.jpg" width="400" height="58" alt="Database Answers"></td> <td align="right" height="95" rowspan="2" width="100%" valign="middle"> <a href="https://web.archive.org/web/20180916130501/https://devops.com/successful-technology-leaders-will-embrace-the-citizen-developer/" target="_NEW"> <img alt="Click to go to the Wb Site" border="0" src="/web/20180916130501im_/http://databaseanswers.org/data_models/citizen_developer_stuff/images/logo_sml.jpg"> </td> </tr> <tr> <td width="100%" align="LEFT"> <!--- <p class="time"><nobr><SCRIPT LANGUAGE="JavaScript">theDate();</SCRIPT> ---> <img alt="Printer" src="/web/20180916130501im_/http://databaseanswers.org/images/printer_icon.gif"> <a href="print_version.htm"><font color="blue" face="Verdana" size="1">Printer-friendly version</font></a> <nobr></p> </td> </tr> </table> <!--- START OF DEC 5th. Menu Bar ---> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="32" background="/web/20180916130501im_/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/20180916130501im_/http://databaseanswers.org/images/spacer.gif" width="15" height="15"></td> <td width="6%"><a style="text-decoration:none" href="/web/20180916130501/http://databaseanswers.org/index.htm"><font color="#FFFFFF" face="Verdana" size="2">Home</font></a></td> <td width="11%"><a style="text-decoration:none" href="/web/20180916130501/http://databaseanswers.org/pi_ask_a_question/index.asp"><font color="#FFFFFF" face="Verdana" size="2"> Ask a Question</font></a></td> <td width="10%"> <a style="text-decoration:none" href="/web/20180916130501/http://databaseanswers.org/pi_best_practice_display/index.asp"><font color="#FFFFFF" face="Verdana" size="2">Best Practice</font></a></td> <td width="9%"> <!--- <A STYLE="text-decoration:none" HREF="../../pi_communities/boards.asp"><font color="#FFFFFF" FACE=Verdana SIZE=2>Communities</font></A> ---> <a style="text-decoration:none" href="/web/20180916130501/http://databaseanswers.org/careers.htm"><font color="#FFFFFF" face="Verdana" size="2">Careers</font></a> </td> <td width="9%"><a style="text-decoration:none" href="/web/20180916130501/http://databaseanswers.org/contact_us.htm"><font color="#FFFFFF" face="Verdana" size="2">Contact Us</font></a> </td> <td width="10%"><a style="text-decoration:none" href="/web/20180916130501/http://databaseanswers.org/data_models/index.htm"><font color="yellow" face="Verdana" size="2">Data Models</font></a></td> <td width="7%"><a style="text-decoration:none" href="/web/20180916130501/http://databaseanswers.org/search.htm"><font color="#FFFFFF" face="Verdana" size="2">Search</font></td> <td width="20%" wiiiidth="10%" wiiiidth="30%"><a style="text-decoration:none" href="/web/20180916130501/http://databaseanswers.org/site_map.htm"><font color="#FFFFFF" face="Verdana" size="2">Site Map</font></a></td> </tr> </table> </td> </tr> </table> <!--- END OF DEC 5th. Menu Bar ---> <!--- 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/20180916130501im_/http://databaseanswers.org/images/nav_bg.jUg" align="left" valign="top"> <table width="10%" border="0" cellspacing="0" cellpadding="0"> <tr> <td background="/web/20180916130501im_/http://databaseanswers.org/images/nav_bg.jpg" valign="top" width="1%"><img src="/web/20180916130501im_/http://databaseanswers.org/images/spacer.gif" width="15" height="15"></td> <td align="left" background="/web/20180916130501im_/http://databaseanswers.org/images/nav_bg.jpg" height="32" width="7%"><pre><font color="yellow" face="Verdana" size="2">Data Models for Citizen Developer's Stuff &nbsp;&nbsp;&nbsp;</font></td> </tr> </table> </td> </tr> </table> <!--- END OF PAGE NAME ---> <table name="MAIN CONTENT" width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100%" bgcolor="#B0D8FF" valign="top"> <table width="90%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="21"><img src="/web/20180916130501im_/http://databaseanswers.org/images/spacer.gif" width="31" height="1"></td> <td width="100%"> <font color="blue" face="Verdana" size="2"> If you have any comments or suggestions <a href="https://web.archive.org/web/20180916130501/mailto:dba_requests@barryw.org?subject=Comments on the Data Model for Citizen Developer" s stuff'> we would be glad to hear them</a>. <br>If you are new to Data Models, this page of my new Tutorial will help you <a href="/web/20180916130501/http://databaseanswers.org/tutorial4_db_schema/tutorial_slide_5.htm"><b>understand the Data Model</b></a>. <br>There might also be a design for a <a hreeeef="data_mart.htm"><b>Data Mart</b></a>, which is very useful for providing data for Reports and Business Intelligence. <!--------- <BR><BR><A HREF="facts.htm">The Specifications</A> have been defined in a question to the Database Answers Web Site. -------> <br>We hope to identify an appropriate Partner by the end of Monday, October 30th such as <a href="https://web.archive.org/web/20180916130501/https://www.turvo.com/platform/" target="NEW">Turvo</a>, <a href="https://web.archive.org/web/20180916130501/https://developer.salesforce.com/docs/atlas.en-us.platform_events.meta/platform_events/platform_events_intro.htm" targest="_NEW">Salesforce</a> or <a href="https://web.archive.org/web/20180916130501/http://www.wisetechglobal.com/product/overview" target="_NEW">Wisetech</a>. <br><br> <table border="1"> <tr> <td> <br><img alt="Print version of the Data Model for Membership Organistions" border="0" src="/web/20180916130501im_/http://databaseanswers.org/data_models/citizen_developer_stuff/images/two_architectures.jpg"> </td> </tr> </table> <!--------------------- <BR><BR> <TABLE BORDER=1> <TR> <TD ALIGN=middle VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <B>Citizen Developer's Stuff Data Architecture (1)</B> <BR>Target Date is October 15th. <BR><BR> <IMG WIiiiDTH=500 SRC="images/mendix_data_architecture_1.gif"><BR> <br><br<br> <HR><B>Citizen Developer's Stuff Data Architecture (2)</B>(Core Tables) <BR>Core Functionality is simply "INSERT INTO Events(...)" <BR>Target Date for 3 Apps is October 30th. <BR><BR><IMG SRC="images/mendix_data_architecture_2.jpg"> <BR><BR> </TD><FONT COLOR=blue FACE=Verdana SIZE=2> <TD ALIGN=middle VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <B>Citizen Developer's Stuff Data Architecture (3)</B> <BR>Target Date is November 30th. <BR> <BR><IMG ALT="Print version of the Data Model for Membership Organistions" BORDER=0 SRC="images/mendix_data_architecture_3.jpg"> </TD> </TR> </TABLE> <BR><BR> <HR> <BR><BR> <TABL -------------------------- <BR><BR> <TABLE BORDER=1> <BR> <TR> <TD ALIGN=middle VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <B>Draft Citizen Developer's Stuff Data Architecture</B> <BR> <BR><IMG ALT="Print version of the Data Model for Membership Organistions" BORDER=0 SRC="images/dmt_and_dwh.jpg"> </TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2> This is an extract from page 28 of the <A HREF="https://cxo-transform.com/download/Citizen Developer's Stuff-Digital-Execution-Starter-Guide.pdf" TARGET=_NEW>Citizen Developer's Stuff</A> Execution Starter Guide <BR>from Rob LLewellyn of Citizen Developer's Stuff that mentions KPIs. <BR><BR> <IMG WIDTH=500 SRC="images/llewellyn_sml.jpg"> <BR> <IMG WIDTH=500 SRC="images/mendix_kpis.jpg"> </TD> </TR> <TR> <TD ALIGN=middle VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <B>Conceptual KPI Model<B> <BR><IMG ALT="Print version of the Data Model for Membership Organistions" BORDER=0 WIiiiDTH=500 SRC="../retail_sales/images/c1.jpg"> </TD> <TD ALIGN=middle VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <B>Logical KPI Model</B> (plus Reference Data Tables) <BR> <BR><IMG ALT="Print version of the Data Model for Membership Organistions" BORDER=0 SRC="images/l_1.gif"> </TD> </TR> <TR> <TD ALIGN=middle VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <B>Conceptual Retail Dimensional Model<B> <BR> <BR><IMG ALT="Print version of the Data Model for Membership Organistions" BORDER=0 WIiiiDTH=500 SRC="images/c_2.jpg"> </TD> <TD ALIGN=middle VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <B>Logical Retail Dimensional Model<B> <BR> <BR><IMG ALT="Print version of the Data Model for Membership Organistions" BORDER=0 WIDTH=500 SRC="../retail_sales/images/l2.gif"> </TD> </TR> <TR> <TD ALIGN=middle VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <B>Conceptual Retail Conceptual Model<B> <BR><IMG ALT="Print version of the Data Model for Membership Organistions" BORDER=0 WIiiiDTH=500 SRC="../retail_sales/images/c3.jpg"> </TD> <TD ALIGN=middle VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <B>Logical Retail Dimensional Model<B> <BR> <BR><IMG ALT="Print version of the Data Model for Membership Organistions" BORDER=0 SRC="../retail_sales/images/l3.gif"> </TD> </TR> </TABLE> <BR> <BR>Barry Williams <BR>Principal Consultant <BR>Database Answers Ltd. <BR>London, England <BR>October 6th. 2017 <!-------- <BR>September 30th. 2017 ---------> <br> </td> </tr> </table> <center><font color="blue" face="Verdana" size="1"> <br><br><i> &#169; Database Answers Ltd. 2017</i></font> </center> </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/20180916130501im_/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/20180916130501im_/http://databaseanswers.org/images/spacer.gif" width="80" height="15"></td> <td align="LEFT" width="10%"><a style="text-decoration:none" href="/web/20180916130501/http://databaseanswers.org/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="/web/20180916130501/http://databaseanswers.org/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 13:05:01 Sep 16, 2018 AND RETRIEVED FROM THE INTERNET ARCHIVE ON 17:24:03 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: 70.031 exclusion.robots: 0.085 exclusion.robots.policy: 0.075 RedisCDXSource: 0.915 esindex: 0.011 LoadShardBlock: 49.202 (3) PetaboxLoader3.datanode: 57.864 (4) load_resource: 81.568 PetaboxLoader3.resolve: 46.302 -->