Data mart - CRPITcrpit.com/confpapers/CRPITV31Zhao.pdf · 5 >.¦ ¨: ^ _ < =?> >?> = `\a ^ 6 : ` +:...

10

Transcript of Data mart - CRPITcrpit.com/confpapers/CRPITV31Zhao.pdf · 5 >.¦ ¨: ^ _ < =?> >?> = `\a ^ 6 : ` +:...

Page 1: Data mart - CRPITcrpit.com/confpapers/CRPITV31Zhao.pdf · 5 >.¦ ¨: ^ _ < =?> >?> = `\a ^ 6 : ` +: ¿ ->

�������������� ������� ��� ��� ���� ������� ���!�#"%$&�(')�*�+ ��,� ��-. ��0/'��� ��21 �����!��$3-����4'��0���*�3�

5�6+798;:!<96�= >@?A6+B9CED FHGA8JIK8MLHN�OP<�8MQ�8

RTS%UVUXW�Y[Z0\^]`_%W�aVUb]dceY%fhgi\hjlkKabm�SncV]dkK\�o^p*]`W \Jp WrqsW�UbW�S%aVput�v9W \wcbaVW%f^xyW zJS%aXcVm{W \wc0k|j�gi\hjlk%aVm�Sncb]`k%\�oPYhUXcbW m�U},aV]d_nS|cbW�~�S|���%���K�%�^fP}�S%�dm{W�aVUXcbkK\��0kKaXcVt�fJ�0W�����W�S|��S|\M�

��m�S|]`���s�e���e�%�J�P��� ���e�9�u�w�E�J�%�h�w�P E¡¢�^�P�n�K£9�X�^���¥¤P�

¦[§�¨ ©�ªE«J¬|©xyS|cVS3­®S%abW�t^k%¯JUbW�U9S|aVW!�^S|cVSn°¥]`\KcVW \JUb]`_%W!UbYhUecVW m�U,cVtJSncsS|aVW¯JUXW��±jlk%a²S|\JS%�dYwcV]`p�S|�³cVSKUX´hU�µ¶yU·cbt^W�UXW¸cuS%Ub´PU·�hk¹\^k%c�hW z¢W \J�¸kK\HcbtJW���SncVW�UXc�¯^z¢�JSncbW�U{ºPY·cbauS|\JUVS%p*cb]`k%\JU�f��^S|cVS��S%abW�t^k%¯JUbW�U9p S%\[ºMW»UbW*c�¯^z�]`\.S&��SEY³cbtMSnc�]d\^zJ¯hc�k%j¼�^S|cVSjlabkKm½kKzMW�aVS|cb]`k%\JS%�K�^S|cVS%ºJS%UbW�U�S%\J��kK¯hcbz^¯^c+cbk��h]�S|�`k%�%¯JW,]d\^°cbW abj¾S%p W�Uyjlk%a»kK\h°A�`]`\^W³S%\JS|�`Ywcb]�p S%��zJabkhp*W�UbUbW�U³¿AÀ�Á¼¶!}�Âyp�S|\ºMW&UbW zMS|auSncbW��õ�gi\�cbtJW�zJS|z¢W a0��Wr�hW�Ubp ab]`ºMW�tJkn�ÄS|ºMUecVaVSKpÅcUecuSncbW®m�S%put^]`\^W�UÆ¿�¶yohRTUuÂ�p S%\Ǻ¢WƯJUbW��;cbkÈ�hW�Ub]`�%\Ä�^]`UX°cbaV]dº^¯^cbW��²�JSncVS���S|aVW tJk%¯JUbW�U�µ[­®W�jlk%aVm�S|�`]`UbW³cbt^W[�KabkK¯^\J�]`�hW�S�k|j��^S|cVS»��S|aVW t^kK¯JUbW�U�ºPY³Sr�%aVk%¯^\J�³m{kh�hW �¢¶yohR(S%\J��h]`UVp*¯MUbU³aVW*ÉJ\^W�m{W \wc³UXcbW�zJU f��st^]`put¸p S%\HºMW�S%z^z^�`]dW��H]`\@SUecVW zh°¥ºPYK°iUXcbW zÄ�hW�Ub]d�K\Çm{W*cVt^kh�hk%�`k%�KY%µÊx!]�UXcbaV]dº^¯^cb]`k%\Ç�s]`�`�S|z^z¢W�S%a0S%UsUb¯Jput�S³aVW*ÉJ\JW m{W \wc!UXcbW z+µ

Ë Ì Í © ªnÎ�Ï�м¬%©�ѾΠÍxyS|cVS3­®S%abW�t^k%¯JUbW�U9S|aVW!�^S|cVSn°¥]`\KcVW \JUb]`_%W!UbYhUecVW m�U,cVtJSncsS|aVW¯JUXW��[jlkKasS|\JS%�dYwcb]�p S%�JcuS%Ub´hU9]`\�º^¯JUb]d\^W�UbUbW�U�Ub¯Jput�S%\JS|�`YhUX]`\^�UbS%�dW�UuÒnz^abk%É^cVUÓUecuSncb]�UXcb]�p U�f�p kKUXcÅÒEº¢W \JW*É^cÓaVW ��SncV]dkK\ÔUecuSncV]`UX°cb]�p U�f�p ¯JUecVk%m{W a{z^aVW*jlW�abW�\Jp*W�U{UecuSncb]�UXcb]�p U�f9W cVp|µÈÕ�t^W�cbW�abm¯JUXW��½jlk%a�cVt^W�UbW·cVSKUX´hU�]�U×Öbk%\h°¥�d]`\^W²S|\MS|�`YKcV]`p�S|�rzJabkhp*W�UbUX°]d\^�wØH¿AÀ�Á¼¶!}�Â�]d\²kKaV�hW�a�cbkÆ�h]`UXcb]`\^�K¯^]`Ubt·cbtJW m�jlabkKm�kKzh°W auSncb]`k%\MS|���^SncuSn°¥]d\wcVW \JUb]d_KW³UbYhUecVW m�U�fÃjlk%a��st^]�putÆcbt^W³cbW�abmÖXk%\^°A�`]d\JW0cbauS|\MUbSKpÅcb]`k%\�z^abkhp W�UVUX]`\^�KØ�¿AÀ�ÁhÕs}9Â�tJSKU�º¢W�p k%m{Wp*k%m{m{k%\+µ{À�Á+¶y};cuS%Ub´hU�S%abW3¯JUb¯JS|�`�dYÙ]d\Jp �d¯M�hW��Æ]d\·RTS%\h°S|�%W�m{W \wcsgi\hjlk%aVm�Sncb]`k%\�S|\M�.xyW�p ]`Ub]dkK\ToP¯^z^z¢k%abcyoPYhUecVW m�U�µ

Õ�t^W[]��hW�S�k|jsST�^S|cVS���S|aVW t^kK¯JUXW�¿�UXW�WÙ¿lgi\^m{kK\×��Ú%ÚKÛKÂS|\J�Ä¿¾Ü»]`m&ºJS%�d�»��ÚKÚ%ÛwÂX»]�U3cbk®W*ÝPcbauS%p*c³�^S|cVSÙjlabkKmÞk%z¢W auSn°cb]`k%\JS%�9�^S|cVS|ºMS%UbW�UrS%\J�·cbkÆUecVk%aVW{cbt^W�m)UbW zMS|auSncbW��dYKµ�Õ�t^Wß ¯JUecV]àÉ¢p SncV]dkK\²jlk%a&cbt^]�U³S|z^z^aVkKSKputÆ]�U�cVtJSnc[À�Á+¶y}��`S%ab�KW �`Y�hW�S%�`U®�s]dcbt±p k%\J�^W \JUbW��±�^SncuS^f3cbtP¯JU·�hkPW�U®\^k%c·�hW�zMW�\J�k%\TcVt^W{�`S|cbW�Uec»¯^z��^SncVW�U»ºPY�cbauS|\JUVS%p*cb]`k%\JU�µ�á^¯^abcbtJW aVm³kKabWKfÀ�Á+¶!}âabW�ãK¯J]daVW�U�kK\^�`YÆaVW�SK�P°¥SKp p W�UVU�cbk�cVt^W.�^S|cVSJf�Ubk�cVt^WUXW�zJS|auSncV]dkK\Tk|j,cVt^W��^SncuS[jlkKa&À�Á+¶!};jlabkKm�À�ÁhÕs}ÄS%�d�`kn�0Ucb]`m³W °¥p k%\JUb¯^m{]`\^�·cbauS|\JUVS%p*cb]`k%\¸m�S|\JS%�%W m{W�\Kc{cVk²ºMWÙ�^]`UX°zMW�\JUXW����s]àcVt�µ

Õ�tP¯JU�fySÓÉJaVUXc�z^abkKº^�`W mä]d\½�^SncuSÓ��S|aVW tJk%¯JUbWÙ�hW�UX]`�%\]`U&cbkÆ]d\wcbW��%auSncVW�_w]`W �0U&jlaVk%m�_ES%ab]`k%¯MU&Ubk%¯^aup*W��JSncVS%ºJS%UbW�U�µÕ�t^]`U,zMkK]d\wc,k|j�_P]dW��@k%j��JSncVS���S|aVW t^kK¯JUbW��hW�UX]`�%\�SKU�Sy_P]`W �]d\wcbW��%auSncV]dkK\@z^aVk%ºJ�dW�m4tJSKU�ºMW�W \×UXcbaVk%\^�K�dYHzJabkKm³k%cbW��@]`\¿l­×]��hk%må��Ú%ÚKæKÂ{S|\J��¿�Ü»W��^SK�;S|\M�×RÄçW*cuS|]�UT��Ú%Ú%ÚwÂŵèÀy\cbt^W[k%cbt^W�a�tJS|\M�·]àcrtJSKU�º¢W W \·kKºJUXW�ab_KW��ÙcbtJS|c�cbt^W.UecVab¯Jp*°cb¯^aVWÙk%jrcbt^W®�^SncuSH\^W�W��hW��Èjlk%aTÀ�Á+¶y}�f9]Aµ W%µâcVt^W·UecVab¯Jp*°cb¯^aVW0k|jÃ�^S|cVS���S|aVW t^kK¯JUbW�UVput^W m�S|cVS^fK]`U�UXkKm³W�t^kn�ÈUX]`m{z^�dW�acbtJS%\{cbt^W!UXcbaV¯Jp*cb¯^aVW�k|jÃk%z¢W auSncV]dkK\JS|�h�^S|cVS|ºMS%UbW�U�µ¼Õ�t^]�U,tJSKU�dW��ÙcVk�cbt^W�\^k|cV]dkK\Æk%j�m3¯^�àcV]à°i�h]`m{W \JUb]dkK\JS|�9�^SncuS|ºJSKUXW�U f�]`\�st^]`putéÖej¾SKpÅcuUbØÆ\^W W��hW��Ójlk%a.À�Á¼¶!}éUX¯Mput¸SKU3\P¯^m3ºMW�a�k|jUbS%�dW�U f�z^aV]`p W�U�f�W*cup|µ;S%abW�UbW zJS%aVS|cbW��HjlabkKmêÖV�h]dm{W�\JUX]`k%\MUbØUX¯JputTSKUscV]dm{W%f¢�`kPp�SncV]dkK\�fMzJabkh�h¯Jp*c�f¢W*cup|µ`fM]Aµ WKµszJS|auS|m{W cbW auUë�ìÅí*î�ï�ðòñÅó ô{õö{÷ÅøÅøuùEú�û�üEý ôAïAþuÿòð þ � ë�ì��sí ü ô��Xï�� ì õ ð��iô î ú � õ�� � óEð ý ínþ��í��eï9þuíEí��bþuï����[þVô��^ðòï ý ô û�ý ð þ����Jþ õ ð � õ ëÃì ��� �eï�� � õ �!ì � ë�ì � õ �eí�ô ü þuÿ� ì���eÿòÿòð � ñ�� û �Ãë�ë � ÷ÅøÅøuù��iú! ¼ü � ���Eð � ú!" ��#%$&�Xþuÿ þ � � � ë�ì �'� �eï��� � õ � ý ð ��( � ý �Xþuï õ ósþ � �)�Mï¥þ õ ô�ð õ ��ð � �'� ìÅï��0þVôAðòì � � � õ ó � ìÅÿòìÅñuî ú�* ìÅÿ �+',�� ��-.� �0/ þuï¾ô��0þ �'� þ � �21ÅìÅó �2( ì��'�Eð õ43 ú65 � � ( �Xí�ïAì�� ü õ ôAðòì �7� ìÅïþ õ þ8����sð õ ú � ìuô�� � ìÅï�íEïAì8��ô¼í ü ïAí|ì ý � ý í��Xï��sð ô�ô����yí�ïAì9-�ð�����yô�óEð ý ô���: ôð ý ð � õ ÿ ü �'�;� �

cVtJSnc�putJS|auS%p*cbW�ab]�UXW»cVt^W³j¾S%p*cVU�µ»áJk%aVm�S|�`�dYKf¢��W{UecV]d�`��k%ºhcuS|]`\aVW ��SncV]dkK\JU f�]`\×�st^]�putÈcbt^W®�h]dm{W�\JUX]`k%\MU�jlk%aVm SH´%W YKfsº^¯hccVt^Wsm&¯^�dcb]d°i�h]dm{W�\JUX]`k%\MS|�¼¿¾abW��`S|cb]`k%\JS%��Â��^S|cVS%ºJS%UbW0UbputJW m�SncuS¯JUb¯JS%�d�`Y�tJSE_%W&cbt^W{jlkKabm(k%j�UXcVS%a�kKa�UX\^kn�)<¢S|´%W³UbputJW m�SncuS¿¾gi\^m{k%\®��Ú%ÚKÛKÂ*µ

Õ�t^WÇ��k%aV´±]`\�¿�=�YhUbUbW \JU¸S|\M�ÔÁ+S%´PUbt^m�S|\MS|\(��ÚKÚ%ÛwÂz^aVW�UbW \wcuU Sêjlk%aVm�S|� m{kP�^W �#jlk%aäm&¯J�àcV]à°i�h]`m³W�\JUb]dkK\JS|��^S|cVS%ºJS%UbW�U�µ?>,S|aV]dkK¯JU�W*Ý^S%m³zJ�dW�U�k|j[UecuS|aTUVput^W m�S|cVS@jlk%a�^S|cVSÇ��S%abW�t^k%¯JUbW�U®p S%\躢W¸jlk%¯^\J�è]d\ ¿¾Ü»]`m&ºMS|�`����Ú%ÚKÛKÂŵÕ�t^W·��k%aV´×]d\ ¿�¶0�%auSE��S|�»W*cÙS%��µ���Ú%ÚA@%Â�S%\J�Ê¿¾Õ�t^kKm�UXkK\��Ú%ÚA@%ÂÃp*kK\Jp*W�\wcbauSncbW�U�cVt^W�p*k%\Mp*W z^cb¯JS%�wm{kh�hW��d�`]d\J�yk%jJm&¯^�dcb]d°�h]`m{W \JUb]`k%\JS%���^S|cVS%ºJS%UbW�U�µ gi\é¿�Õ�tJS|�`t^W�]dm �&B&B&CwÂ�]dc�tJS%Uº¢W W�\&k%ºMUXW�ab_KW���cbtMSnc�UecuS|a�S|\J�3UX\^kn�)<¢S|´%W9Ubput^W�m�SncVSy�hk%m³°]`\JSncVW�m�S ß kKa³p k%m{z¢k%\^W�\KcuU&k%j!�^SncuS|ºJSKUXW�UbputJW m�SncuS^µHÀy\cVt^]`U.ºJSKUX]�U.S@�hW�Ub]`�%\ÇS%z^z^aVkKS%putȺJSKUXW��×k%\;cbt^W®]d\wcVW �%auSn°cV]dkK\�k|j��`kPp�S|�¢Ubput^W�m�SncVS»k%jÃcbt^]�U�UX]`m{z^�dW!jlk%aVm±]�U9z^abkKzMkwUXW��S%\J�[Ub¯^ºJUXcVS|\wcV]`S|cbW��[ºwY[Ubk%m{Wy�dkK�%]�p S|�Jcbt^W�k%aVY%µ�¶Äz^abkKº^�`W mS%ab]�UX]`\^��jlaVk%m cVt^W{UXW�zJS|auSncV]dkK\Tk|j��^S|cVS.��S%abW�t^k%¯MUXW�UsjlaVk%mkKzMW�aVS|cb]`k%\JS%�P�JSncVS%ºJS%UbW�U�]�U�cbtMSnc�cbtJWsW*ÝPcbauS%p*cb]`k%\3jl¯^\JpÅcV]dkK\JUtJSE_KW!cVk�ºMW&m{S%]d\wcuS|]`\^W��õ,Õ�tJ]`UszJabkKº^�dW�m ]�UsS%�^�^abW�UbUbW��.]d\¿��,\^�wUecVa'DkKm W*c!S|�AµJ��B6B&BwÂŵ

Õ�t^W»m{S%]d\�]��hW�S³k%j��^S|cVS³��S|aVW t^kK¯JUXW�U�]`m{z^�`]dW�U0S{UXW�zJSn°auSncV]dkK\�k%jh]d\^zJ¯hc�jlaVk%m½k%z¢W auSncb]`k%\MS|�%�^S|cVS%ºJS%UbW�UÃS%\J�»k%¯hcVz^¯hccVk�_P]`W �0U»cVtJSnc&p k%\wcVS%]d\ÆcbtJW[�^SncuS�jlkKarzJS%aXcV]`p ¯^�`S%a&À�Á+¶!}cuS%Ub´PU�µ�gi\²cVt^W��JSncVST��S%abW�t^k%¯JUbW��`]àcVW auSncb¯JabW�cVt^W�UbW�_P]`W �0US%abW9k|j cbW�\3p�S|�`�dW���Öb�^S|cVS!m{S%aXcuUbØ3¿¾UbW W�W%µ �Jµ�¿lgi\^m{k%\���ÚKÚ%ÛwÂXÂŵÕ�t^W���k%aV´r]`\�¿�Á�W��9W�abW�\FE�W*c�S|�Aµ^��Ú%Ú%ÚwÂ�zJabW�UXW�\KcVW��³S��h]HG¢W�aX°W�\Kcr_P]`W �ék%\²�^S|cVS���S|aVW t^kK¯JUXW��hW�UX]`�%\·W�m³zJtJS%Ub]`Ub]`\^��\^k|cß ¯JUXc�cbt^W·]`\^z^¯hc�f»º^¯hcTS|��UXk@cbtJW®kK¯hcbzJ¯hc�f»]Aµ WKµÔcbtJW·�JSncVSm�S|abcVU»S%\J�HÀ�Á+¶!}�µÃgi\²�hkK]d\J�.cVt^]�U f¼W�S%put·�^S|cVS�m�S|abc�cVk|°�KW*cbtJW a��s]àcVt&cVt^W!À�Á+¶y}Tjl¯^\MpÅcb]`k%\MU��9kKab´P]`\^�!kK\&]dc,�hW*ÉJ\JW�US[Ubk|°ip S%�d�`W��¸ÖV�h]`S%�dkK�%¯^W�kKº ß W�p*cVØJfMS[\Jk|cb]`k%\�]`\wcbaVkh�h¯Jp*W���]d\¿Aohput^W ��W�S|\J��ohputJW ��W���Ú%ÚKÛ^f^ohput^W��9WrS%\J��ohput^W��9Wr��B6B&BwÂSKUÃS�m³W�S|\JUÃjlk%aÃcVt^W,]`\KcVW �KaVS|cb]`k%\�k|jh�^SncuS|ºJSKUXW,UbYhUecVW m�U�S|\M��h]�S|�`k%�K¯^W*°¥ºJSKUXW���¯JUbW ay]d\wcVW abj¾S%p*W�U µ0áJk%�`�dkn�s]`\^��cVt^]�U!]��hW�S[]àc]�UrS%UXcbkK\^]�UXt^]`\^��cVtJSnc{S��dk%c&k|js��k%aV´Ù]�Urz^¯hc3]d\wcbkTcbt^W��hW*°Ub]d�K\�k|j��^S|cVS���S|aVW t^kK¯JUbW�U�f|�st^W aVW�SKU�cVt^W!m�S ß kKa,W m{z^tMS%Ub]`UUbt^k%¯J�`��º¢W³k%\�cVt^W{À�Á¼¶!}×jl¯J\JpÅcV]dkK\JUycbtJS|c�S|aVW&ºMS%UbW���kK\_P]`W �0U»kn_%W�a�cbt^W���S|aVW t^kK¯JUbW%µ�Õ�t^]�U�m{k|cb]`_nSncVW�U�cbk�cuS|´KW{Sp �dkwUXW�a&�`kwkK´²]d\wcVkÙcVt^W�UbYhUecVW m�U{�hYP\JS|m{]�p U�f�\^k|c ß ¯JUXc{cbt^WUXcVS|cb]�p��JSncVS²UXcbaV¯Jp*cb¯^aVW�U�µ;Õ�t^W���k%aV´H]d\�¿Aohput^W ��W²��ÚKÚKæKÂp k%\wcVS%]d\JU&STUXkKz^t^]�UecV]`p�SncVW��®jlk%aVm�S|��S%z^z^aVkKSKputÆcVkÙUbzMW�p*]djlY%fS%\JS|�`YhUXW�S|\M�»_%W aV]djlY��^S|cVS%ºJS%UbW,S|z^zJ�d]�p S|cb]`k%\JUÃ]`\Jp �d¯J�^]d\^�yS|zh°z^�`]�p SncV]dkK\Ùz^aVk%�KaVS%m�U µ&oP¯MputÆ´P]`\J�Ùk%j���k%aV´�]�U»W _KW \Æm³kKabW\^W�W��hW��[jlkKa0�^SncuS³��S%abW�t^k%¯JUbW�U�S%\J��À�Á¼¶!}�µ

á^¯^abcbt^W�abm{kKabWKfESKU¼�^]`S%�dkK�%¯^W9k%º ß W�pÅcVU�kn_KW a¼S��^S|cVS0��S|aVW*°t^kK¯JUbW9�`W�SK��cbk�_P]dW��0U�kn_%W a�Sy_w]`W ��fn]dc�m�SEY�ºMWsãw¯^W�UXcb]`k%\JW��Ãf�st^W cbt^W�a9]dcsm�S|´%W�U9UbW \MUXW!cbk3cVS|´KWyS3t^k%�`]�UecV]`p�S|z^zJabkwS%put{cbk�^S|cVS³��S|aVW t^kK¯JUXW»�hW�UX]`�%\�k%as�st^W cbt^W�a0]dc0m³]`�%twc0º¢W�ºMW cXcVW acVk[abW�z^��S%p*W»cVt^W3�JSncVS[��S%abW�t^k%¯JUbW�ºPY�S�p*k%�`�`W�pÅcV]dkK\�k|j�m�Sn°cVW aV]`S%�d]�UXW��²_P]dW��0U³k%\HcVt^W�k%z¢W auSncV]dkK\JS|���^SncuS|ºJSKUXW�U µ²Õ�t^]�U_P]`W �¸]`U9S|��UXk�¯^\M�hW aV�dYP]`\^��cVt^W0��k%aV´&]`\T¿¾Õ�t^W�kP�^k%auSncbkwU,S|\M�oPW��d�`]�U»��Ú%Ú6IKÂ9S|\J�·¿�Õ�t^W kh�hkKaVS|cbkKU���Ú%Ú%ÚwÂŵ

Õ�t^W.�KkKS%��k|j!cbt^]�U{S|abcb]�p*�`W.]�UrcVkÆzJabW�UXW�\Kc{SÙm{kKabW�S|ºh°UXcbauS%p*c�jlaVS%m³W��9kKab´»jlkKa9�^S|cVS»��S|aVW t^kK¯JUbW��hW�UX]`�%\+fK]`\��st^]�putS�z¢kKUVUX]`º^�`W��^W�p*]�Ub]dkK\&cVk�aVW�S%�d]�UbW�S»�^S|cVS���S|aVW t^kK¯JUXW�ºPYrm�Sn°cVW aV]`S%�d]�UXW���_P]dW��0U�S|z^z¢W�S%aVU�S%U�S3abW ÉJ\^W m{W�\Kc�µ�gi\[cVt^W�UbS%m³W��SEYÆ��W���k%¯J�`�²�`]`´%W[cVkÙW ÝwcVW \J�²cbt^W�_P]dW��ÔS|\J�Hp k%\JUb]��hW a

Page 2: Data mart - CRPITcrpit.com/confpapers/CRPITV31Zhao.pdf · 5 >.¦ ¨: ^ _ < =?> >?> = `\a ^ 6 : ` +: ¿ ->

�h]`UXcbaV]`º^¯hcbW��È�^SncuSÆ��S|aVW tJk%¯JUbW�U�µ@Õ�t^W�\ÓcVt^WT�hW�p*]�UX]`k%\@k%\cbt^W0�h]�UXcbaV]dº^¯^cb]`k%\{UXt^kK¯^���3S%�`Ubk�S%z^z¢W�S|a,SKU�abW ÉJ\^W m{W�\KcuU µ�gi\k%au�hW a!cbk��hk�UXk��9Wr�Kk[ºJSKpu´�cVk�cbt^W3_%W�abY�ºJS%Ub]�p�]`�^W�S�¯^\^°�hW aV�dYP]`\^�r�^S|cVS»��S|aVW t^kK¯JUXW�U f%]�µ W%µ�cbtJW!UXW�zJS|auSncV]dkK\3k%j¢]`\^z^¯^cjlabkKm kKzMW�aVS|cb]`k%\JS%�y�^S|cVS|ºMS%UbW�U[S%\J�Èk%¯hcVz^¯hc.cbkÓ�h]�S|�`k%�K¯^W]d\wcbW�aXj¾SKp*W�U+jlkKa�À�Á+¶!}�µ|Õ�tJW \&��W�¯JUbW�¶!ºJUecVaVSKpÅc�owcuSncbWsRTS|°put^]d\JW�Us¿¾¶�ohRTUuÂ+cbk�m³kh�hW��Pcbt^]�U�]��hW�SJµ�¶�ohRTUs¿¾UbW W»¿¾~ DkKab�KW aS|\J�;owcDS|aV´@��B6B&CwÂXÂ3z^aVkn_w]��hWTS²UXcbaV]`p*cb�`YÓm�SncVt^W m�S|cb]�p S|�`�`Yjlk%¯^\J�^W���m{W*cVt^kh��jlk%a0t^]`�%t^°A�`W _KW ��UbYPUXcbW�m �hW�UX]`�%\+f^_nS|�`]`�^S|°cb]`k%\TS|\M�._KW aV]àÉ¢p SncV]dkK\�µ�­®Wr�s]d�`�+Ubt^kn�;cVtJSncy]àc!]�U0S%�daVW�SK�hYzMkwUbUb]dºJ�dW�cVkH¯JUbWÙ¶yo^RTU ß ¯MUec.cbkHm{kh�hW �!cbt^WƺJS%Ub]�p�]`�^W�Sk|j��^SncuS3��S|aVW tJk%¯JUbW�U�]`\�S³z^aVW�p ]`UbW%f^Ub]`m³zJ�dWKfJS|ºJUXcbauS%p*c�S%\J�p*k%m{z^�`W*cVW���SEYKµ�¶0�`�Ãjl¯^abcbt^W�a!�hW�Ub]`�%\�UecVW zJU�cVt^W \�cV¯^ab\�kK¯hccbk�º¢W�abW ÉJ\^W m{W�\KcuU µ

Õ�t^WrSK�h_nS|\wcVS%�%W�k|j�¯JUX]`\^��¶yo^RTUs]�U�cbtJS|c0�9W»kKºhcVS%]d\�SUXkKm³W�t^kn�;m�SncVt^W m�S|cb]�p S|�Ãm{kh�hW���k|j¼cbt^W��^S|cVS³��S%abW�t^k%¯MUXWS|\J�âÀ�Á+¶y} jlabkKm2cbt^W²_KW aVY׺MW��%]`\^\^]`\^�Jµ Õ�tJW®�KabkK¯^\J�m³kh�hW��¼¶�ohRÞS|�`�dkn�0U�UbYhUecVW m�UsaVW�ãw¯^]`abW�m³W�\wcVUsUb¯Jput�S%U�cVt^W¯JUXW!k|j��h]�S|�`k%�%¯JW0k%º ß W�pÅcuU�jlk%a9m³kh�hW��d�`]`\^��cbtJW�À�Á+¶y}·jl¯^\Jp*°cb]`k%\JUÙcbk;º¢WÓW�S%Ub]d�`Y;jlkKabm�S%�d]�UXW���S%UTUbYhUecVW m ]`\w_nS%ab]�S|\wcVU�µÕ�t^W \{��W�p�S|\³_%W�ab]djlY»cbtJS|c�cbt^W0Ubz¢W�p*]dÉMp�Sncb]`k%\³]�U�p*k%\MUX]�UecVW \wc�s]àcVt�cbt^W�UXWs]`\P_nS|aV]`S%\KcuU µ�Ày\{cbt^W!k|cbtJW a,tJS%\J�ÃfKcbt^W!�%W \JW auS|�¶yohR zJt^]d�`kKUbk%zJtwY»�hkPW�U+\^k|c¼jlk%aup*W,¯MUÃcbk�S|z^zJ�dY»S|\PYyjlk%aVm{S%�_%W aV]dÉMp S|cb]`k%\{Snc9Ub¯Jput{W�S%ab�`Y&UXcVS|�KW�U�µ+­®W!p*kK¯^���³Ub]`m³zJ�dY3jlk%�d°�dkn�ÇS3z^t^]`�`kKUbk%z^tPY{k|j¼ÉJaVUXcs�hW�Ub]d�K\^]`\^�3S%\J��S%\JS|�`YhUX]`\^�3S%\J�_%W aV]djlYw]`\^�{��SncbW�a�µ�Õ�t^]�U�]�Usp S|�`�`W���cbt^W�S|ºMUXW�\Jp*W»k|j�S3jlk%aVm{S%�m³W cbt^kh�^U&UecVaVS%]d�KtKcb° ß SKpu´%W cy]`\¸¿�~ DkKab�KW a�S|\M�®owcDS|aV´Æ��B6B&CwÂŵá^¯^abcbt^W�abm{kKabWKf,�9W��s]`�d�0S%�`Ubk·UXt^kn�ÔcbtJS|c{��W�p S|\¸aVW�S%Ubk%\S|º¢k%¯hc�S|auput^]àcVW�p*cb¯^auS|�^zJab]`\Jp*]`z^�`W�U9k%\{cVt^W!�`W _KW �Jk%j+S|\�¶�ohR�%aVk%¯^\J�.m{kh�hW �Aµ

­®W[tJSE_%W�put^kwUXW�\®¶�ohRTU&ºMW�p S|¯MUXW{k|j�cVt^W�UbW{jlW�S|cb¯^aVW�U�fS|\J�@ºMW�p S%¯JUXW�cVt^W YHtMSE_%W�ºMW�W \×UX¯Mp p*W�UbUXjl¯^�`�dYHS%z^z^�`]dW��HcVk_ES%ab]`k%¯MU�S|zJz^�d]�p S|cb]`k%\JU�]d\Mp*�`¯J�h]`\^�HcVt^W®Ubz¢W�p*]dÉMp�Sncb]`k%\;S%\J�_%W aV]dÉMp S|cb]`k%\ék|j��KSE_nS½S|\J�±cbtJW��KSE_nSÄ_w]`abcb¯JS%�[m�S%put^]`\^W¿¾~ Dk%aV�%W�a�W crS|�Aµ+��B&BJ��Â*f�cbt^W[UbzMW�p*]dÉMp S|cb]`k%\®k|j�k%z¢W auSncb]`k%\MS|�UXW�m{S%\wcb]�p U�k|jMcbauS|\JUVS%p*cb]`k%\JU�¿�},aV]d\FE�S|\M�3Õ�tJS%�dtJW ]`mé��B6B&CwÂÅfS|\J�ÈcVt^WÆUbz¢W�p*]dÉMp�Sncb]`k%\+fs_ES%�d]��^S|cb]`k%\;S|\M�È_%W aV]dÉMp S|cb]`k%\Èk|j�^SncuS|ºJSKUXW»aVW�p*kn_KW aVY�¿�=�¯^aVW _P]�put.W c!S|�AµÃ��Ú%Ú @|Â*µ

gi\�cVt^]`U9S|abcb]�p*�`W0��W0�s]d�`�^ÉMaVUXc�z^aVW�UbW \wc,cVt^W!�KW \^W�aVS%�^]`�^W�Sk|j�cbt^W.¶yohRäm{W*cVt^kh�·]d\HoPW�pÅcV]dkK\Ó�hµ.Õ�tJW \²��W��s]d�`���hW °_%W �`k%z�SÆÖX�%aVk%¯J\J�[m{kh�hW ��س¶yohR²fJ�st^]`put�z^aVkn_P]`�hW�U�S&_KW aVYt^]d�Kth°¥�dW�_%W ��S|ºJUXcbauS%p*c��hW�Ub]`�%\×k|jrSH�JSncVSH��S%abW�t^k%¯JUbW%µ½gi\j¾S%pÅc�f|]dc ß ¯MUec�aVW.<JW�pÅcVU+cbtJW�ºMS%Ub]`p�]`�hW�S!k%jM]`\^z^¯hcb°AkK¯hcbzJ¯hc,UXW�zh°S|auSncb]`k%\+µ¼Õ�t^]�U�]��hW�S��`W�S%�JU�\^k|c ß ¯JUXc�cbk�S»Ub]d\^�K�dWs¶�ohR²f%ºJ¯hccbk·cbtJabW�W�]d\wcbW�aX°¥�`]d\^´KW��ȶyo^RTU f�kK\^W�jlk%a�cVt^WT�^S|cVS·��S|aVW*°t^k%¯JUbWTS%U�UX¯Jput+f9kK\^W�jlk%a�cVt^W�k%z¢W auSncV]dkK\JS|�0�JSncVS%ºJS%UbWK¿�UVÂ*fS|\J�ÊkK\^WÈjlk%a²cVt^W;�h]�S|�`k%�K¯^W×k%º ß W�pÅcuUHS|\J�ÔÀ�Á¼¶!}�µr­®Wz^abW�UXW�\wc�cbt^]�Ur�KabkK¯^\J�Æm³kh�hW��,]`\ÓoPW�p*cb]`k%\ C^f�S|\J�·�h]�UVp*¯JUVUS%�h_nS|\wcuS|�%W�U�k|j�cbt^Wr¶�ohR)S|z^z^aVkKSKput�kK\�cVt^]`U0�dW�_%W �Aµ

á^kK�d�`kn�s]`\^�²cbtJ]`U��9WÙ�^]`UVp*¯JUVU[aVW*ÉM\^W m{W \wcuU[]`\ÇoPW�p*cb]`k%\�Jµ{Õ�t^W�UbW{abW ÉJ\^W m{W�\KcuU�m{SEYÆp*k%m{z^aV]�UXW{UecuS|\J�JS|au�TaVW*ÉJ\^W °m³W�\wc³UXcbW zMU�jlk%a3�^SncuS|ºJSKUXW[S%\J�²�h]�S|�`k%�%¯JW[�hW�Ub]d�K\²S%U&�^]`UX°p*¯JUVUXW��Ù]`\È¿�ohput^W��9W�S%\J�ÙÕ�tJS%�dtJW ]`m���ÚKÚ��wÂyS|\M�@¿Aohput^W ��WS|\J��ohput^W ��W³��Ú%ÚKÛKÂ*f%cVt^W�S|z^z^aVkKSKput{cbk3cbt^W��hW�UX]`�%\.k|j¼UXcVS%aS|\J�ÈUb\^kn�)<MS|´KW�UVput^W�m{S|cVSÙjlabkKm ¿¾Õ�tMS|�`t^W ]`m �&B&B&CwÂ&S%\J�cbt^Wyjlk%aVm�S|�¢abW ÉJ\^W m{W�\Kc�z^aV]dm{]dcb]`_%W�U9jlkKa��^S|cVS%ºJS%UbW!S|\M�[�h]d°S|�`k%�%¯JW��hW�UX]`�%\ÓjlabkKm ¿�ohputJW ��WÆ��Ú%ÚKæKÂŵHgi\ÈS%�J�h]àcV]dkK\�f���W�s]d�`���h]�Ubp ¯JUVUyaVW*ÉM\^W m{W \wcuU�cbtJS|c»�s]`�`���dW�S%�Ùcbk��h]�UecVab]`º^¯hcVW���^SncuS3��S|aVW tJk%¯JUbW�U�µ

� �� ¨�©� �H¨������ �¾Î����� Í ©��{Ѿ©��@¦[§�¨ ©�ªE«J¬|© � ©�«h©�� «^¬��¼Ñ Í P¨

¶0ºJUXcbauS%p*croPcVSncVW[RTS%putJ]d\^W�U�¿¾¶�ohRTU�f9¿¾~ DkKab�KW a�S|\J�·owcDS|aV´��B&B6CKÂbÂ�tJSE_KW�º¢W W \¸�hW _KW �`k%z¢W��HSKU&m{W�S|\JU3jlk%a³t^]`�%th°¥�`W _%W��UXYhUXcbW m �^W�Ub]d�K\±S|\M�èS|\MS|�`YPUb]�U µ2Õ�t^W¸�%W�\^W auS|�³]`�^W�S���st^]`putTS%�`Ubk{¯^\J�hW�ab�`]`W�U0zJabW�_w]`k%¯MU��9kKab´[k%j�cbt^W&UbW�p k%\J��S%¯h°cbt^kKaT]d\Ô¿Aohput^W��9WÈ��ÚKÚKæKÂ.S%\J�Ê¿�ohputJW ��WHS|\J�¹Õ�tJS%�dt^W�]dm��Ú%Ú��wÂ�� ]`U&cbkÆz^aVkn_w]��hW[STcbt^aVk%¯^�Kth°¥�%k%]`\^��¯^\^]djlk%aVm�jlk%ab°m{S%�d]�Ubm2�s]àcVtÄp*�`W�S%a�m�SncVt^W m�S|cb]�p S|�»UbW m�S|\wcb]�p U.�s]dcbt^kK¯hc�habkKz^z^]`\^�é]d\wcbk±cbtJW½zJ]àcbj¾S|�`��k|jTcVt^W Öejlk%aVm�S|��m{W*cbtJkP�JUUecVaVS%]d�KtKcb° ß SKpu´%W cVØ^µÃÕ�tJS|c+]�U fnSnc�S|�`�KUXcVS|�KW�U�k%jhUbYhUecVW m¹�hW _KW �d°k%z^m{W \wc���W0¯JUbWscVt^WyUVS|m{W�jlk%aVm�S|�`]`Ubm�f|cVt^Wy¶�ohRTU�fK�st^]�put]`U!<JW*Ýh]`º^�`W!W \Jk%¯^�Kt{cbk&p�S|zhcV¯^abW!abW�ãK¯J]daVW m{W \wcuU�Snc�S�aVS|cbt^W�a

_nS|�K¯^W��`W _%W��¼S%\J��Snc0cVt^W&UVS|m{W�cV]dm{Wrz¢W aVm{]àcuU!S|�`m{kKUXc!W*ÝP°W�p*¯hcuS|º^�`W3UbYhUecVW m�U»UXz¢W�p ]àÉMp�SncV]dkK\JU µrÕ�tP¯JU�f¢cbt^W�¶�ohRÞjlkKaX°m�S|�`]�UXmé]`U�z^aVW�p*]�UbW%fKp k%\Jp ]`UbW%fwS|ºJUXcbauS%p*c�S|\J��p k%m{z^�`W*cVW%fwY%W*cUb]dm{z^�`W0S|\M�{W�S%UbYrcVk�tJS|\M�h�dWKfKSKU�k%\^�`Y³ºJS%Ub]`p�m�S|cbt^W�m{S|cb]�p U]�U�¯JUbW��õ

Õ�t^W[UXYhUXcbW�m{U&�hW _KW �`k%z^m{W \wcrm{W*cVt^kh�®]àcuUXW��àj ß ¯JUXc&z^aVW*°Ub¯^m{W�U!cbk�UecuS|abcy�s]dcbtTcVt^W3�^W*ÉJ\^]dcb]`k%\Æk|j�S� �!#"�$&%('*)+"�'-,/.02143 ¿¾k%a+UbW _KW auS|�n�`]d\J´%W��»¶�ohRTUuÂÅfE�st^]�put�m{S%]d\J�dY�p S|z^cb¯^aVW�UaVW�ãw¯^]`abW�m{W \wcVU�]`\�S���SEY3Ub]`m³]`��S|a,cVk&UVp*W \MS|aV]dkwU�]d\Æ¿�ohput^W��9W�&B&B^�EÂMk%aïJUbW*°ip SKUXW�U�]d\[¿5�KSKp*k%ºMUXkK\yW c¼S|�Aµ|��ÚKÚK�^f*qs¯^m&ºMS|¯^�KtW cyS|�Aµ¼��Ú%ÚKÚKÂŵs¶!�d�¼jl¯^abcbt^W�a�UbYhUecVW m �hW _KW �`k%z^m{W \wc!]�U��hk%\^WºPYÈabW ÉJ\^]`\^�²cVt^W®¶�ohRTU�¯JUb]d\J�Óãw¯^]àcVW®SÓ�%W�\^W auS|�y\^k|cV]dkK\k%j�aVW*ÉJ\JW m{W \wc�f��st^]�put·]`Urcbt^W.UbS%m³W.S%U»cVt^W[k%\JW�¯JUXW��·]d\¿Aohput^W ��W�S|\J��Õ�tJS%�dt^W�]dm���ÚKÚ��wÂ*µ

oPkyºMS%Ub]`p�S|�`�dY»cVt^W0UXYhUXcbW�m{U��^W _%W��dkKz^m{W \wc�z^abkhp W�UVU¼�s]dcbt¶�ohRTU·]�U²SÄaVW*ÉM\^W m{W \wcb°A_nS|�`]��^SncV]dkK\h°¥p Yhp*�`W%µ Õ�tMSnc²]`U²S�K]d_KW \Ô¶yo^R ]�UÓaVW*ÉM\^W��ÔS%\J� cVt^W½abW�UX¯^�dc@]�U¸_nS|�`]`�^S|cbW��S%�KS|]`\JUXc�cbt^W�aVW�ãw¯^]`abW�m³W�\wcVU�µ�>,S|�`]��^SncV]dkK\[m�SEY3auS|\^�KWsjlaVk%mp ab]dcb]�p S%�w]`\JUbzMW�pÅcV]dkK\JU¼cbk�cbt^W�¯JUVS|�KW9k%jJcVW�UXc�p�S%UbW�U�S|\J�3W _nS%�à°¯JS|cb]`k%\·k|j0W ÝhW�p*¯^cVS|ºJ�dW[¶�ohRTU³S%U�z^aVk|cVk|ceYPz¢W�U�µ�Õ�tJ]`U&ºJSn°Ub]`pÆ�hW _KW �`k%z^m{W�\Kc.z^abkhp W�UVU�m�SEY¸ºMW®W \^aV]�put^W��׺PYÈaV]d�Kk%ab°kK¯JU�m�S|\P¯JS%�0k%a[m{W�putJS|\^]�UbW��@jlk%aVm�S|�0_KW aV]àÉMp�SncV]dkK\ÓcVW�puth°\^]�ãw¯^W�U�µ760kn��W _KW a�fhcbt^W3�%W�\^W auS|�Ãz^tJ]d�`kKUbk%z^tPY�]`U0cbk��^W�Ub]d�K\ÉJauUXcsS%\J�.cbk{z¢kKUXcbz¢k%\^W�aV]d�Kk%aVk%¯JU9_%W�ab]dÉMp�Sncb]`k%\�cbk[S{UXcVS|�KW%f�st^W�\²abW�ãw¯^]daVW m{W�\KcuU»tJSE_%W�º¢W�S%�dm{kKUXc3p k%\JUbk%�`]`�JSncbW��õ�gi\cVt^W�abW�m�S|]`\J�hW a�k%j�cbt^]�UrS|abcb]�p*�`W���W��s]d�`�,W m{z^tMS%Ub]`UbW�k%\^�`YcVt^W�Ubz¢W�p*]dÉMp�Sncb]`k%\.k|j+�KabkK¯^\J��m³kh�hW��öyohRTU�S%\J�.Ub¯^]dcVS%º^�dWaVW*ÉJ\JW m{W \wcVU!¿ jlk%a��hW cVS|]`��U�UbW W&¿�~ DkKab�KW a,S%\J�[owc'DS%ab´���B6B&CwÂXÂŵ

�8¾Ë � Ñ5�9���5.¦ � � ¨¶yU�W*Ýhz^��S|]`\^W��³UXkyj¾S|a�f|��W�W*ÝhzMW�pÅc�cbk��hW ÉJ\^W�jlk%a�W�S%put³UecuS|�%Wk%j�UbYhUecVW m�U��^W _%W��dkKz^m{W \wc.S@p*k%�`�`W�pÅcV]dkK\;:�<�=�>?>�>/=@:9A¸k%j¶�ohRTU�µ ��SKputǶyohRB:9C{p*kK\JUb]`UXcVU.k|j{SED4,@F-'�,?!�S%\J�ÇSG "H'JInµ,Õ�t^W»t^W�S%�hW�a�k%j�S%\�¶�ohR)p*k%\MUX]�UecuU�k|j¼]dcVU�\MS|m{W%f^S%\]`m{zMkKaXcb°�S|\J��W*Ýhz¢k%abcX°¥]d\wcVW abj¾S%p*WKfhS|\J��S{UX]`�%\MSncb¯JabWKµ,Õ�tw¯MU fS³ºJSKUX]�p»¶yohR)p S%\.º¢W��saV]àcbcbW \�]`\�cbt^W»jlkKabm

KML-N :O N P4Q�R�S :T<E¿VUJ<#<�=?>�>?>?=#U�<WA-X*Â/=?>�>?>?=Y:[ZP¿VU�Z?<�=?>�>?>?=#UHZ\A-]|Â^ _ P4Q�R�S+` <�=?>�>?>�= `\aL OJb�c K�S-dMR ^ µ µ µ60W aVW�U Cfe S%abW�cVt^W&\MS|m{W�U!k|j�jl¯^\Jp*cb]`k%\JU�S|\J�Tab¯^�`W�U0]dm³°

z¢k%abcbW��®jlabkKm�cVt^W.¶�ohRg:9Cy�hW*ÉM\^W��²W��`UbW �stJW aVW%µÙÕ�t^W�UXWjl¯^\MpÅcb]`k%\MU�S|\J�Çab¯^�`W�U��s]`�d��º¢W²�hW*ÉM\^W��Ä]d\ÄcbtJW²ºMkh�hY×k%j:9Ch� \Jk|c.]`\×cVt^Wƺ¢kh�hYÈk|ji: � S|\J�;k%\^�`Y@¯MUXW��×]d\:éµ�Õ�t^]�U�]`U�k%\^�`Y&z¢kKUVUb]dº^�`W�jlk%a,cbt^kwUXW�jl¯^\MpÅcb]`k%\MU�S|\M�3aV¯^�`W�UcVtJSnc�tJSE_%WyW*Ýhz^�`]`p ]àcV�dY�º¢W W�\.W ÝhzMkKaXcVW��õ,oPk³k%\^�`Y{cbtJW!jl¯^\MpÅ°cV]dkK\JU&S%\J�®ab¯^�`W�U ` <J=?>?>�>?= `\a p�S|\²º¢W[]dm{z¢k%abcbW��HS|\J�®¯JUbW��ºPYr¶yo^RTU�k|cVt^W a�cVtJS|\+:éµ�¶yU�]d\{UXcVS|\M�^S|au�rm{kh�h¯^��S|a�z^aVk|°�KaVS%m³m{]`\^����S|\J�%¯JS%�%W�UycVt^]`U»m{W�putJS|\^]�Ubm k|j�]dm{z¢k%abcX°!S|\M�W ÝPz¢k%abcX°¥]`\KcVW abj¾S%p W�z¢W aVm{]àcuU+¶�ohRTU+cbk0º¢W��hW�_%W �`k%z¢W��»auSncVt^W a]`\J�hW�zMW�\J�hW \wcV�dY�jlaVk%m W�SKput�k|cbtJW a��dW�SE_w]`\^��cVt^W3�^W*ÉJ\^]dcb]`k%\k%j¼zJS%aXcV]`p ¯^�`S%a�jl¯^\JpÅcV]dkK\JU0S%\J��ab¯^�`W�U�cVk·ÖXW ��UbW �st^W�abW�Ø^µ

Õ�t^W2j\kl �%mFJno$&!#,�k%jÃS%\�¶yohR(]�U,S»ÉM\^]àcVW0�`]`UXc�k|j�jl¯^\MpÅcb]`k%\\JS%m{W�U�p-<�=?>�>?>/=YpJq3f¢W�S%put�k%j��stJ]`putT]�U�S%UVUXkhp*]�SncVW����s]dcbtÙS\^kK\h°¥\^W �wSncb]`_%Wy]d\wcVW �%W�asr�U�Cbfhcbt^WtF�!\kun5I»k|j¼cbt^W»jl¯J\JpÅcV]dkK\�p�Ceµgi\T¶�ohRTUyW�S%putTUb¯Jput�jl¯^\MpÅcb]`k%\Ù]`Uy]d\wcVW aVz^abW cbW���S%U!S�cbk|cuS|�jl¯^\MpÅcb]`k%\�pJC���vhw\xzy|{}v�~t�J���!�s]dcbt�S�\^k|c9jl¯^abcbt^W�a�UbzMW�pÅ°]dÉJW���UXW c�v�p�S|�`�dW���jY$H�4,?!\��$&%4ku�J,/!Yj?,9S|\J�[S3UXz¢W�p ]`S%�¢UbYPm&º¢k%����� v³µ[¶yU»¯JUb¯JS|�Af�p C p�S|\®ºMW�]`\wcbW aVz^aVW*cVW��®S%U»S�zJS|abcb]�S|�jl¯^\MpÅcb]`k%\tvhw\xWy��}vè�s]dcbt��hk%m�S%]d\

����� ¿opJC¥Â|���m�� � v w\x y ��pJCX¿��� Â�������->Õ�t^W�jl¯J\JpÅcV]dkK\JU��hW*ÉM\^W��Ójlk%a{S|\ȶyohR ]`\Jp*�`¯J�h]`\^�Æcbt^W

UXcVS|cb]�p�S|\J�·�hW�ab]`_%W��Ùjl¯J\JpÅcV]dkK\JU f��hW ÉJ\^W{cbtJW�UXW crk|j2j\n�F�n�,/jk%j+cbtJWr¶yohR²µ

gi\rS%�^�h]dcb]`k%\+f jl¯^\MpÅcb]`k%\MU¼p�S|\»ºMW�'JIJ%(F�)ik��¼kKa�\^k|c�µ�Ày\^�`Y�hYP\JS%m{]`p,jl¯^\JpÅcV]dkK\JU�p S%\rºMW�¯^z��^SncVW��Ãf%W ]dcbt^W�a¼ºPY�S|\J�&k%\^�`YºPY�cbt^W³¶yohRHf¢]`\Ù�stJ]`putÙp�S%UbW&��W&�KW*c�S��Y"J%4no!#"�.u.�,Y'�jl¯^\MpÅ°cV]dkK\�fnºPY»cbt^W�W \P_P]`abkK\^m{W \wc�fE]`\3�st^]�put3p�S%UbW���W9�KW*c�S�)+"J%��kun�"J!#,Y'yjl¯^\MpÅcb]`k%\+fJk%a!ºwY�\^k%\^W�k%j�º¢k|cVt�fJ]`\��st^]�putTp S%UbW»�9W�KW*c�S�'-,/!\ku�J,Y'�jl¯^\Jp*cb]`k%\�µ�gi\�zMS|abcb]�p*¯^��S|a�f%Sr�hYP\JS%m{]`p�jl¯^\MpÅ°cV]dkK\�k|j�S|aV]àceY B3]`UsS3_nS|aV]`S%º^�`W%fP�st^W aVW�SKU9S³UXcVSncV]`pyjl¯^\MpÅcb]`k%\k%j�S|aV]dceY B³]`UsS�p k%\JUXcVS%\Kc�µ

Page 3: Data mart - CRPITcrpit.com/confpapers/CRPITV31Zhao.pdf · 5 >.¦ ¨: ^ _ < =?> >?> = `\a ^ 6 : ` +: ¿ ->

� 8u� � ©�«h©HP¨�« Í Ï � ªn« Í ¨�Ѿ©�Ñ¾Î Í ¨g¥j pJC±]`U S4jl¯^\Jp*cb]`k%\ k%j±S|aV]dceY r�UHCéS%\J� ��W�tMSE_%Wp�¿ � < =?>�>?>/= � w\xWy Âh���¢f+��W[p S|�`��cbtJW[zJS|]`a�� � ¿5p(=��� »�s]dcbt�� ��¿ � <�=?>�>?>�= � w/x y ÂrS9. "��YFJnok�"J%®S|\J���Æ]àcuUt�JFJ. $4, µTÕ�tP¯JU�fW�S%put�j\n�F�n�,�k%j9S|\·¶yohR m�SEY�ºMW�p k%\JUb]`�^W aVW��TSKU�S�UbW*c»k|j�dkhp S|cb]`k%\¢Òn_nS|�`¯^W»zJS|]`aVU�µ

g¥j�cbt^W³jl¯^\Jp*cb]`k%\·]�U��^Yw\MS|m{]`p%fÃcbtJW�_ES%�d¯JW�U�k|j�]àcuU»�dkhp S|°cb]`k%\JU!m{SEY�ºMWr¯Jz¢�^S|cbW��õ�Õ�tP¯JU�fMUXcVS|cbW�U0p S%\�º¢Wr¯^z��^S|cbW���f�st^]`put²p�S|\®ºMW��hkK\^W{ºwYÆS|\ $H�M'-FJn�,+j?,?n�f�]Aµ W%µ�S�UXW c�� k|jzJS|]`aVU»¿��=�hÂÅf^�st^W�abW��!]�UsS³�dkhp S|cb]`k%\�S|\J���[]`U�S³_nS|�`¯^W%µ�À!jp*k%¯JaVUbW%fhkK\^�dY��@"�%Mj\k j\n�,?%4nïJz¢�^S|cbW&UbW*cuUsp S%\.º¢W»cVS%´%W \�]`\KcVkS%p p k%¯^\wc�fh]�µ W%µ���W»m&¯JUXc0tJSE_%W

¿ ��=� <  � ���Æ¿ ��=����� � ����� < ������>��SKput�p k%\JUb]�UecVW \wcs¯^z¢�JSncbWrUbW*c�� �hW*ÉJ\JW�U�j\n�F�n�,�no!#FJ%4jYku�

n5k�"�%Mj�]d\³cbtJW0k%ºP_P]dkK¯JU���SEY%µ+g¥jÃ��W�tJSE_%Wsp�¿ � < =�>?>�>?= � w\xzy  ���]d\éSÇ�K]d_KW \±UXcVS|cbW��ÈS|\J� ¿X¿op(=�¿ � <J=�>?>�>?= � w\x y ÂbÂ\=���  ���fâcbt^W�\ ]`\äcbtJW UX¯Jp�p*W�UbUbk%aÔUXcVS|cbW����×��W(�s]d�`�;�%W cp�¿ � <�=?>�>?>/= � w\x y Â|�����Aµgi\Ó¶�ohRTU{p*kK\JUX]�UXcbW \wc&¯Jz¢�^S|cbW�UXW cVU³p S|\²º¢W�kKºhcVS%]d\JW��jlabkKm $H�4'�F�n�,�!\$&. ,\jÅf,�st^]�putÓp�S|\Hº¢W.�hW ÉJ\^W��HºPY®cbt^W.jlk%�d°�dkn�s]`\^�{�`S%\^�%¯MS|�%WK�� cbt^WrUb´P]dz�aV¯^�`W3�n���� []d\M�h]`p�SncVW�U�\^k[putJS%\^�%W"!� cbt^W{¯^z��^S|cbW³ab¯^�`W+p�¿# < =�>?>�>/=# A »� �$#0�s]dcbtÆS%\&%�°iS|aVY

jl¯^\Jp*cb]`k%\Tp@S|\J�®cVW aVm�U'##<�=�>?>?>�=#zAm=�#y]`\J�h]�p S|cbW�UrcbtJS|ccbt^W�_nS%�d¯^W�k%jycVt^W��`kPp�SncV]dkK\¸�hW cbW�abm{]`\^W��¸ºPYTp;S%\J�cbt^W»cVW aVm�U(# < =?>�>?>�=# A �s]`�`�úMW�¯^z��^S|cbW��.cVk3cVt^W»_nS|�`¯^Wk|j�cbW�abm)#*!

� cbt^W¸UXW�ãw¯^W \Jp W²ab¯J�dW[U < �%�,+�>?>?>��%�,+�U A ]`\J�h]�p S|cbW�UcbtJS|c�cVt^W!aV¯^�`W�U UJ<J=�>?>?>�=WUHA3�s]`�`�Mº¢W!W ÝPW�p*¯hcVW���UbW�ãw¯^W�\h°cb]�S|�`�dY�!

� cbt^W³º^�`khpu´.aV¯^�`W�U < J�"- >?>�>. ^�"- U A ]`\J�h]�p SncVW�U!cbtJS|ccbt^W�aV¯^�`W�U UJ<J=�>?>?>�=WUHA��s]`�d�+ºMW�W ÝPW�p*¯hcVW��.]d\�zJS%aVS%�d�`W �/!

� cbt^Wrp k%\J�^]àcV]dkK\JS|�ÃaV¯^�`W�1032|<�4w�^�%¤;UJ<��65^���10�2 � >�>?>(4w�J�|¤ U�A��|¤^�7�10

tJS%U0cbt^W&¯JUX¯MS|��m{W�S%\^]`\^��cbtMSnc UJ<�]`U!W*ÝhW�p ¯hcbW��ÃfJ]dj82|<W _nS|�`¯JS|cbW�Uscbk{cbaV¯^WKf^k|cVt^W aV�s]`UbW2U � ]�UsW ÝPW�p*¯hcVW��ÃfJ]àj92 �W _nS|�`¯JS|cbW�U�cVk{cbaV¯^W%fhW cVp%µ:!

� cbt^W��dW c&ab¯J�dW;5w�"4 � ��#<��¤ U�m{W�S|\MU»cbkTSKUbUb]d�K\ÙcVkcbt^WÙ_ES%ab]�S|ºJ�dW � cbtJW�_ES%�d¯JWT�hW*ÉJ\JW��¸ºPY²cbt^W�cVW aVm=#S|\J�.cVk³¯MUXW»cVt^]`U � ]d\�cbtJW�ab¯^�`W2U�!

� cbt^W&jlk%auS|�`�+aV¯^�`W>0h�?-^�65�5 � �@��4w��2@�h�EU{�%¤^�P�h�{]d\^°�h]�p SncVW�U»cVt^W�zJS%aVS%�d�`W ��W*ÝhW�p*¯hcV]dkK\®k%j U.jlk%arS%�d�,_nS%�d¯^W�Uk|j � UbS|cb]�UejlYP]`\^�A2.!

� cbt^Wsput^kK]`p W9aV¯^�`W!�E�J�P�J�|� � �@�B4w��2Ó�h�EU��%¤^�w�h�!]d\^°�h]�p SncVW�U�cVt^W�W*ÝhW�p*¯hcV]dkK\.k%j�U&jlk%ask%\JW�_ES%�d¯JW�k%j � UVSncb°]`UXjlYP]d\J�C2D!

� cbt^W×p�S|�`�³aV¯^�`WEUP¿E# < =�>?>�>?=# A ÂÆ]`\J�h]�p S|cbW�UÆcVt^WÈW*ÝhW�p ¯h°cb]`k%\�k%j�aV¯^�`W�U3�s]dcbt�zMS|auS|m{W*cVW auU(##<�=?>�>?>/=�#zA·¿¾p S%�d�+ºwY\JS|m{WEÂŵ

Õ�t^Ws]��hW�S�]�U�cbtMSnc�cbtJWsab¯^�`W�U�k%j¢S%\{¶�ohR S|aVW�W _nS|�`¯JSncVW��]d\·zJS%aVS%�d�`W �Aµ�g¥j9cVt^W�aVW�Ub¯^�àcV]d\J��¯Jz¢�^S|cbW[UbW*cr]�Urp*kK\JUb]`UXcbW�\Kc�f�9WrkKºhcVS%]d\TS�UecuSncbWrcbauS|\JUb]àcV]dkK\�µsÕ�t^W \TS !\$&%[k|j,S|\T¶�ohR]`U0S3ÉJ\J]àcVW�k%as]`\hÉJ\^]dcbWrUbW�ãw¯^W�\Jp*W»k|j�UXcVSncVW�U

�GF�{H� < {H����{ >�>?>Ub¯JputrcVtJSnc�W�SKput��HC:I�<,]�U¼cbt^WsUb¯Jp p W�UVUXkKa�UXcVS|cbW�k|j7�HC¢�s]dcbt

abW�UXz¢W�p*c!cbk�cbt^W3¯^z��^SncVW3UbW*c�� C�cbtJS|cy]�Uy�^W*ÉJ\^W���ºPY�W _nS|�d°¯JSncV]d\^�{cVt^W�aV¯^�dW�U�k|j¼cbt^Wr¶�ohR�]d\�UXcVSncVW>� C µ

­®WykKm³]dc�cbt^Wyjlk%aVm�S|�M�^W*cVS%]d��U�k|jÃcVt^W��^W*ÉJ\^]dcb]`k%\.k|j�¯^z^°�^SncVWÙUXW cVU[jlabkKm�cbtJW�UbWTab¯J�dW�U µ¹Õ�t^W�UbWTp S%\׺MWTjlk%¯^\J�È]`\¿¾~ Dk%aV�%W�a�S%\J��owc'DS%ab´.�&B&B6CKÂŵ

Õ�t^W �hW ÉJ\^]dcb]`k%\ k%j aV¯^�`W�U ºPY W ÝPzJabW�UbUb]dkK\JUUP¿ � < =?>�>?>�= � A  � U1�Çm�S|´KW�U ¯^z2cbtJW�º¢kP�^Y k%jâS|\¶yohR²µ�gi\HS%�J�h]àcV]dkK\�f��9W�SKUbUb¯^m{W{cbkÙºMW[�K]d_KW \²S|\ ku%�kun5k�F�.jYn�FJn�,{S|\M�HcVtJSnc�k%\JW.k%j!cbtJW�UbW�aV¯^�`W�U³]�U��hW�p �`S%abW��ÓS%U3cVt^W) F�ku% !\$&.�, µ,Õ�t^]�Usab¯J�dW»m&¯MUec0\^k%c0tJSE_%W�zJS%aVS%m³W cbW�aVU�µ

… Data mart

Dialogue object

Data warehouses

View constructors

Star/snowflake schema

Update/refresh queries

Operational databases

… Data mart

Dialogue object

Data warehouses

View constructors

Star/snowflake schema

Update/refresh queries

Operational databases

á�]`�%¯^aVWÆ�K�TÕ�t^W��%W�\^W auS|�sS|auput^]dcbW�pÅcb¯JabW�k|j»S·�^SncuSÆ��S|aVW*°t^kK¯JUbW»S%\J��À�Á+¶!}

�8KJ L ,M Í �[ Í ©3Î7N0¦ � � ¨Õ�t^W�\^k%cb]`k%\Ók%j�!#,PO|%m,/)+,/%�n9aVW ��SncVW�U3ce��kƶyo^RTUt: S|\M�:RQnµ�gi\³z^aV]d\Mp*]`z^�dWKfKSKU�cbt^W0UbW m�S|\wcV]`p�U¼k%j�¶�ohRTU�]�U��hW ÉJ\^W��ºPY³]àcuU�aV¯^\JU�fK��W!��k%¯J�`�{\^W�W��[S&p*k%aVaVW�UbzMkK\J�hW \Mp*Wsº¢W*ce��W W \Ub¯Jput�ab¯^\MU fh]Aµ WKµ

� S³p*kKabaVW�Ubz¢k%\J�hW�\Jp*W!ºMW ce�9W�W \.cbt^W�UXcVSncVW�US��k|j�: S|\M�cVt^WrUXcVSncVW�UT�1Q�k%j�:RQ|fJS|\J�

� S�p*kKabaVW�Ubz¢k%\J�hW�\Jp*W9ºMW ce�9W�W \3cbt^W�aV¯^\JU�k|j :2S|\M� : Q]`\P_%kK�d_P]`\^�³UXcVS|cbW�UT�rS|\M�U�1Q|f^abW�UXz¢W�p*cb]`_%W��dYKµ60kn��W _%W�a�fK]d\�p*kK\wcbauS%UXc�cbk³m�S|\PY{jlk%aVm�S|�¢m{W*cbtJkP�JU�cbt^W

\^k%cb]`k%\Äk|j3aVW*ÉM\^W m{W \wc�]d\¹¶yo^RTU��hkPW�U�\^k%c�aVW�ãw¯^]`aVW®S%�d�UXcVS|cbW�UycVk�º¢W³cVS%´%W \Æ]d\wcVk�SKp p*kK¯^\wc�µ3­ÆW{k%\J�dY�aVW�ãw¯^W�Uec»cbktJSE_KW�S{p k%aVabW�UXz¢k%\J�^W \Jp Wyº¢W*ce��W W�\@ÖVUecuSncbW�U�k|j�]d\wcVW aVW�UXcVØ^µ

á^k%aVm�S|�`�dYKf0�`W*c&V S|\M��V8QÙº¢WÆcVt^W·UXW cVU�k|j3UXcVS|cbW�U�k%j¶�ohRTU : S|\M� :RQ|fJaVW�Ubz¢W�pÅcV]d_KW �`Y%µ�¶ �Y"J!\!#,/jo�M"�%('�,?%(�Y, "XWj\n�FJn�,\jú¢W*ce��W W \ :2S|\J�i:RQ,]�U�S0k%\JW*°¥k%\^W9º^]d\MS|aVYyaVW ��SncV]dkK\Y�Z V�[DV8Q�Ub¯Jput�cbtMSnc\� F Y �BQF t^k%���^U�jlkKaÃcbtJW,]d\J]àcV]`S%�KUXcVSncVW�U�GF{S|\J�&�1QF k|j : S|\J��:RQnf�aVW�UbzMW�pÅcb]`_%W��dYKµ»gi\ÙzJS%aXcV]`p ¯^�`S%a�f��W»m&¯JUXc0tJSE_%W

� Y � Q< �]� Y � Q� �H� Q< �^� Q�S|\J�

�J< Y � Q �]� � Y � Q �H�J<7��� � >Õ�t^W \Æ�9W³UbSEY�cbtMSnc�S|\ƶ�ohR :RQ&]�UyS !#,PO|%m,/)+,/%�n+k%j

cVt^W�¶yo^Rg: ] G¸jlk%a3W�S%put²aV¯^\_�1QF {`�1Q < { >?>�>rk|j�:RQcVt^W aVW�]�U�S0aV¯^\�� F {H�J<7{ >�>?>�k|j�:2S%\J�»cbtJW aVW�S%abW,]`\J�hW ÝUbW�ãw¯^W�\Jp*W�U B��bacF;dea < d >?>�>�S|\J� B��efGFUd�f < d >?>?>Ub¯Jput.cbtJS|c���Chg Y �1QeXg tJk%���^U�jlk%a!S%�d� � µ

J ¦ Í ¦ � � i ªnÎ¢Ð Í Ï � Î�Ï� ��N¥ÎJª���«h©�«$jè«^ª�"k�¼Î¢Ð�¨�P¨

gi\;kKaV�^W a�cVk@�hW ÉJ\^WÆS%\Ƕyo^Rå�%aVk%¯^\M�Èm³kh�hW���jlk%a.�JSncVS��S|aVW t^kK¯JUbW�U»�`W*c3¯MU&�Kk�ºJS%pu´ÆcbkÙcbt^W.ºJS%Ub]`p[]`�hW�S�k|j!�JSncVS��S|aVW t^kK¯JUbW�UÃS|\M�&À�Á+¶!}�f �st^]`put�]�U�ºMS%Ub]`p�S|�`�dY�S0UXW�zJS|auSncV]dkK\k%j�]d\^zJ¯hc0S|\J��kK¯hcbzJ¯hc�SKU�W Ýhz^�`S%]d\JW��[]`\[cVt^W�]d\wcbaVkh�h¯Jp*cb]`k%\�µÕ�t^W»]��hW�S³]�Us]`�d�`¯JUXcbauSncbW���ºPY�á¼]`�%¯JabW{�%µ

gi\3cVt^]�U�ÉJ�K¯^abW���W0UXW�W0S�p*�`W�S%a�cbt^aVW W °�cV]dW�a�S|auput^]dcbW�p*cb¯^aVW%µÀy\×cVt^W®ºMk%cXcbkKm cb]`W a��9WÆtJSE_%WÙk%z¢W auSncb]`k%\MS|�y�JSncVS%ºJS%UbW�UUbW*c!¯Jz�jlk%a!zJ¯^abz¢kKUbW�UscbtJS|c�S|aVW�k|j�\^k�zJS|abcb]�p*¯^��S|a!]d\wcbW�abW�UecjlkKa�cbt^W®�^SncuS²��S|aVW t^kK¯JUXWKµ�6!kn�9W�_%W�a�f��9WÆS%UVUX¯^m{W�cVtJSnccVt^WT�^SncuS²UecVk%aVW��@]d\ÈcVt^WT�^S|cVS·��S|aVW t^kK¯JUXW�]�U�W*ÝPcbauS%p*cbW��jlaVk%m¹cVt^W�UbW�k%z¢W auSncb]`k%\MS|�P�^SncuS|ºJSKUXW�U µ�gi\³k|cVt^W a���k%au�^U�fEcbt^W]`\^z^¯hc3k|j0�^SncuS�]d\wcVk�cbt^W.�^SncuS���S%abW�t^k%¯JUbW{]`U3�hW*ÉM\^W��·ºPY¯^z��^S|cbW*°0kKa�abW jlabW�UXt®k%z¢W auSncV]dkK\JU�fÃ�st^]`put®cuS|´%W��^S|cVS.jlaVk%mcVt^W�UbW»k%z¢W auSncb]`k%\MS|���^S|cVS|ºMS%UbW�U�S|\J��]`\JUbW abc�cVt^W m#]`\KcVk³cbt^W�^S|cVS³��S|aVW t^kK¯JUXWKµ

gi\��%W \JW auS|�AfJ]dj�cbt^W�abW3]`UyUXkKm³W3p*k%\F<J]`p*cyº¢W*ce��W W�\�cbt^W�UXWkKzMW�aVS|cb]`k%\JS%���JSncVSJf^]Aµ WKµ9�^S|cVS³jlaVk%m �^] G�W aVW \wc0k%z¢W auSncV]dkK\JS|�

Page 4: Data mart - CRPITcrpit.com/confpapers/CRPITV31Zhao.pdf · 5 >.¦ ¨: ^ _ < =?> >?> = `\a ^ 6 : ` +: ¿ ->

�^SncuS|ºJSKUXW�U3tMS%U³cbk·º¢W�]d\wcVW �%auSncVW��ÓºMW jlk%aVW�]dc�p S%\@º¢W�]d\^°UXW�aXcVW��3]d\wcbk»cVt^W0�^S|cVS���S%abW�t^k%¯MUXWKf���W�\^W W��{S|\³]d\wcbW��%auSncVk%ap*k%m{z¢k%\^W�\wc�¿�UXW�W²¿l­×]��hk%m ��Ú%Úwæ%ÂbÂŵT6!kn�9W�_%W�a�f,��W�m�SEYS%UVUX¯^m{W³cbtMSnc»cbt^]�U»]`\KcVW �KaVS|cbk%a�]�U»zJS|abc�k|j�cVt^W{W*ÝPcbauS%p*cb]`k%\jl¯^\JpÅcV]dkK\JU�µ

Õ�t^W�UbW�p*kK\J��cV]dW�a»k|j,cVt^W�S|auput^]àcVW�p*cb¯^aVW&]`\®á�]`�%¯^aVW��³]�Um{SK�hW,¯^z&ºwYycbtJW9�^S|cVSs��S|aVW t^kK¯JUbW�]dcVUbW �djeµ�gi\rz^aV]d\Jp ]dzJ�dWKf���Wß ¯JUec9tJSE_%W0S��^S|cVS%ºJS%UbWsUXYhUXcbW m±t^W aVWs�s]dcbt{cbtJWsk%\^�`Y3�h]HG�W ab°W \Jp W�U�cVtJSnc9�9Wsm�SEY3SKUbUb¯^m{W0Ub]dm{z^�`W a�Ubput^W�m�SncVSJf|]Aµ WKµ�UXcVS%ak%a+Ub\^kn�)<MS%´%W�UbputJW m�SncuS^fES|\J�»��W,�hk0\^k%c+tJSE_KW¼cVk!p*kK\JUb]`�hW�ap*k%m{z^�`W*Ý�cbauS|\MUbSKpÅcb]`k%\MU µsÕ�t^W3k%\^�`Y.�saV]dcbW*°¥k%z¢W auSncV]dkK\JUsS|aVWcbt^W®abW jlabW�UXt×kKzMW�aVS|cb]`k%\JU[cbtJS|c�p k%\^\^W�pÅc.cbt^W®�^SncuSH��S|aVW*°t^k%¯JUbW�cVk�cbt^W&k%z¢W auSncb]`k%\MS|�+�^S|cVS%ºJS%UbW�U�µ�¶!�d�¼k|cVt^W ayk%z¢W auSn°cb]`k%\JU¼k%\^�`Y�abW�S%���^S|cVSsjlaVk%mÄcbtJW9�^S|cVS0��S|aVW tJk%¯JUbW%µÃgi\�j¾SKpÅc�f�9W ß ¯MUec�º^¯^]`�`��_P]`W �0U0jlk%a0cVt^WTÖV�^SncuS�m�S|abcVUVØ{k%a!�h]�S|�`k%�K¯^Wk%º ß W�pÅcVU�cVtJSnc0S%abW�¯JUbW���S%U9cbt^W3À�Á¼¶!}@]d\wcVW abj¾S%p*WKµ,oPkJfPcVt^W_w]`W � p k%\JUXcbaV¯JpÅcV]dkK\·k%z¢W auSncb]`k%\MUrS|aVW{cbt^W.k%\^�`YÙkK\^W�UrcbtJS|c�d]`\^´.cbt^Wrm{]��^�h�`WrcV]dW�ascbk�cVt^W�cVk%z�cb]`W a�fJ�stJ]`putT�hW�S|��Us�s]dcbtÀ�Á+¶!}�µ

Õ�t^W�cVk%z�cb]`W a¼]àcuUXW��àjP]�U+p*kK\JUXcbaV¯JpÅcVW���k%¯hc�k%jPcbt^W,�h]�S|�`k%�K¯^Wk%º ß W�pÅcVUsS%\J�.cbt^W3À�Á¼¶!}¸k%z¢W auSncV]dkK\JU��9kKab´P]`\^�³k%\.cbt^W�m�µ

J8�Ë � �� Ì Ï�P«ÆÎ7Ns©H��T¦ � � i ªnÎMÐ Í Ï � Î�Ï� �gi\3kK¯^a�S%z^z^aVkKSKputr�9W�cVS%´%W9cbt^W��%W�\^W auS|�PS|auput^]dcbW�pÅcb¯JabW�jlabkKmá¼]`�%¯JabW���S%U&S��^]daVW�p*cr�%¯^]��hW �`]`\^W{jlk%a�cVt^W[�hW ÉJ\^]dcb]`k%\²k|jsS�%aVk%¯^\J�·¶�ohR2m{kh�hW �Af��st^]`put²�s]`�`���%]`_%W�¯MU�cbtJabW�W[�d]`\^´KW��¶yohRTU!xy~9°i¶yohR²fMxs­È°¥¶�ohRÞS|\M��À�Á¼¶!}�°i¶yo^R²µ

¶!UVUb¯^m{]d\^�(¿ljlk%a;Ub]dm{z^�`]`p ]àceY^Â@cVtJSncÈcbtJW�k%z¢W auSncb]`k%\MS|��^SncuS|ºJSKUXW�U®S%abWÈS|�`��aVW ��Sncb]`k%\MS|�Af3cVt^W;Ub]d�K\JSncV¯^abW¸]`\éx�~9°¶yohRê�9kK¯^�`� ß ¯MUec��hW�UVp*aV]`ºMWÙcbt^W�UXWÆabW��`S|cb]`k%\JU�µâ¶!U.abW��`S|°cb]`k%\JU{p S%\Hº¢W�UbW W�\ÓS%U3ºMkPkK�dW�S|\h°¥_nS|�`¯^W��®jl¯^\MpÅcb]`k%\MU f,W�S%putabW��`S|cb]`k%\H�s]dcbt %ÇSncbcbaV]dºJ¯hcbW�U3]`\ÓkK\^W�k|j0cVt^W�k%z¢W auSncb]`k%\MS|��^SncuS|ºJSKUXW�U!�s]`�d���hW ÉJ\^W{S|\ %�°iS|aVY�jl¯^\Jp*cb]`k%\Ù]`\TcVt^W�UX]`�%\MSn°cb¯^aVW3k%j�xy~9°i¶yohRHµ�Õ�tJW3aV¯^�`W�Uyk%\Ùx�~9°¥¶�ohR4p k%aVabW�UXz¢k%\J�cbk�cbt^W³W*ÝPcVaVSKpÅcb]`k%\Æk|j9�JSncVS�jlk%a�W�SKputÙk%j,cbt^W{aVW ��SncV]dkK\JU!]`\cbt^W��^SncuS���S|aVW t^kK¯JUXW[UVput^W�m{SJµTg¥j0��W�S%UVUX¯Jm³W�STUb]dm{z^�`WUecuS|aÙUVput^W m�SJf�cbt^W�abWÓ�s]d�`�&º¢WHk%\J�dY½k%\^WHUb¯Jput�aVW ��SncV]dkK\�µÕ�t^W�UbW�W*ÝPcbauS%p*cb]`k%\@ab¯^�`W�U�p�S|\Ⱥ¢WTp*k%m3º^]`\^W��@]d\wcVk·S²Ub]`\h°�%�`W�aVW*jlaVW�UbtHaV¯^�`W%µ@x�~9°¥¶�ohR �s]d�`�sW*Ýhz¢k%abc3cVt^W�UbW�abW jlabW�UXtab¯^�`W�U�µ

À!j�p*k%¯JaVUbW%f9]àc[�s]`�d�!ºMW�z^aVW*jlW�aVS%º^�`W.cVkHUXW�zJS|auSncVW.W�S%putk%z¢W auSncb]`k%\MS|�M�JSncVS%ºJS%UbW0]`\wcbk&S3UX]`\^�%�`Wy¶�ohR²fwº^¯hc��9Wy�dW�SE_%Wcbt^]�U3SKU3STabW ÉJ\^W m{W�\Kc{UecVW z�µ�60kn��W _KW a�f+]`\²cbt^]�U{p SKUXW[��Wm{SEY�tJSE_%W�cbk��hW ÉJ\^WrS%\�SK�^�h]dcb]`k%\JS%�Ã]d\wcbW��%auSncVk%as¶yohRHµ

oP]`m{]d��S|aV�dYKfPcbt^WrUb]`�%\JS|cb¯^aVW!jlkKa0xs­È°i¶yohR��s]d�`�+p k%\wcVS%]d\jl¯^\JpÅcV]dkK\JU�cbtJS|c�p*kKabaVW�Ubz¢k%\J�¸cVk²cbt^WÆabW��`S|cb]`k%\;UVput^W m�S|cVS¯JUXW��T]`\ÙcVt^W{�^SncuS���S|aVW t^kK¯JUbW&UbputJW m�S^µ»g¥j�cVt^]�Uy]�U»S.UXcVS%aUbput^W�m�S^fh��W�m{SEY�tJSE_%W»k%\J�dY[kK\^WrUb¯Jput.aVW ��SncV]dkK\�UVput^W�m{SJµg¥jJ]àc�]`U�S!Ub\^kn�)<MS%´%W,UVput^W m�SJf���W��s]`�`�KtJSE_KW,m{k%aVW�cbtMS|\&kK\^Wp*k%\wcVabkK�d�`W��@jl¯^\Jp*cb]`k%\�µâx0­È°¥¶�ohRå�s]`�d�ytJSE_%W�cVkH]dm{z¢k%abccbt^W[aVW*jlaVW�Ubt®ab¯^�`W�U�jlabkKm�x�~�°i¶yo^R²µ�Ày\®cbtJW[k|cVt^W a�tJS%\J�]àc0�s]`�d�+W*ÝhzMkKaXcs_P]`W �ÇaV¯^�`W�UsUbzMW�p*]djlYP]d\^��_P]`W �½p*k%\MUecVab¯Jp*cb]`k%\k%z¢W auSncb]`k%\MU�jlkKa�¯MUXW�ºPYrÀ�Á¼¶!},°¥¶�ohR²µnÕ�t^W�UbW�ab¯^�`W�U¼�s]`�d�hº¢W�hW*ÉJ\JW��·]`\·cbt^W�UVS|m{W���SEYÙS%U�cbt^W�aV¯^�`W�U»jlkKa�cbt^W�abW jlabW�UXtk%z¢W auSncb]`k%\MU�]d\�xy~9°i¶yohRHµ

Õ�t^WrUb]d�K\JSncV¯^aVW�k%j,À�Á¼¶!},°¥¶�ohR��s]`�`��ºMWrUb]`�%\^]dÉMp S%\wcb�`Ym³kKabW�p k%m{z^�`]`p�SncbW��Ãf�S%U³�9W�tJSE_KW�cbk®cVS%´%W�]d\wcVk·SKp p k%¯^\wccbtJS|c.cVt^W®�JSncVS¸UXcbaV¯JpÅcV¯^abWÆk|j&�h]�S|�`k%�K¯^WÙkKº ß W�p*c�aVW�ãw¯^]`aVW�Up*k%m{z^�`W*Ý�_nS|�`¯^W�k%º ß W�pÅcuU f^\Jk|c ß ¯JUXc0cb¯Jz^�dW�U µ�á^¯^abcbtJW aVm³kKabWKfcbt^W�abWy�s]d�`��ºMW�UX]`�%\^]dÉMp�S|\wcb�`Y{m³kKabW!k%z¢W auSncb]`k%\MU�jlk%a0À�Á+¶y}�fS|\J�ècbt^W <JW ÝP]`º^]`�d]dceYâk%j.�h]�S|�`k%�%¯JW@kKº ß W�p*cVU®�s]d�`�{abW�ãw¯^]daVWº^aVS%\Jput^]`\^�Jf�zJS%aVS%�d�`W �`]`UbmÄS%\J��UbYw\Mput^abkK\^]�UbS|cb]`k%\�µ6!kn�9W�_%W a�fcbt^Wr]`m{zMkKaXcVW���aV¯^�dW�U0S|aVW ß ¯JUXc0cbt^kwUXWrUbz¢W�p*]djlYP]d\J��cbt^W�_P]`W �p*aVW�SncV]dkK\ÓkKzMW�aVS|cb]`k%\JU³k|jycbt^W��^S|cVS®��S|aVW t^kK¯JUXWKf�]�µ W%µ¸cVt^Wk%z¢W auSncb]`k%\MU�W*ÝhzMkKaXcVW��.ºPY�xs­È°i¶yohR²µ

J8u� � ����+� wªE«^©�Ñ¾Î Í «M� ��«h©�«h§�«J¨�Ʀ � �¶!p p k%au�h]`\^��cbkÙk%¯^a3�%W \JW auS|�,]��hW�STcbt^W��hW*ÉM\^]àcV]dkK\Hk|j0x�~9°¶yohR��s]`�d���`kPk%´�SKU�jlk%�`�dkn�0U��

KML�N xy~9°i¶yohR^ _ P4Q�R S W*ÝPcbauS%p*c < f+µ µ µ f^W*ÝPcbauS%p*c AL O�b�c K S-d&R ^

Part Offer Store

Buys Customer

price date

cost

kind description sid address

cid name

address

time quantity

á�]d�K¯^aVW��^� =�abkhp*W�abY�oPcbk%aVW%�9Àyz¢W auSncV]d_KW»o^S|�`W�U0ohput^W�m�S

�2<%¿�r�U�< »¿¾p k%\wcbaVk%�`�dW��JÂÅfµ�µ µ�f

��Zh¿5r�UHZ%»¿�p*kK\KcVabkK�d�`W��MÂ� Q����

m{S%]d\ ��10[UbW �`W�p*cbW��®¿¾k%z cVaVS%\JUVS%pÅcV]dkK\4C¾Â4w�J�%¤[ab¯J\ cbauS|\JUVS%p*cb]`k%\®¿lk%z cbauS|\JUVS%p*cb]`k%\ C Â�%�,+R�10[Ub¯Jp p W�UVUejl¯J�4w�J�|¤�p k%m{m{]àcr¿¾k%z cVaVS%\JUbSKpÅcV]dkK\ C Â�65^�|�{S%ºMkKaXcr¿¾k%z cbauS|\MUbSKpÅcb]`k%\�C�Â�%¤^� �10

�65^�6�10�UXW��dW�pÅcbW��Æ¿¾W*ÝPcbauS%p*c C Â4w�J�%¤[W*ÝPcbauS%p*c@Cb¿ � CiÂ�%¤^�7�10

W*ÝPcbauS%p*c@CX¿ � CiÂs�ʵ�µ µ

�0k|cVWTcVtJSnc.cbt^W·UXz¢W�p ]àÉ¢p SncV]dkK\;k|j�cVt^WÙm�S%]d\Äab¯^�`WÙ]`\h°p �d¯J�^W�U�cbtJWrW*ÝhW�p ¯hcb]`k%\�k|j�k%z¢W auSncV]dkK\JS|��cVaVS%\JUVS%pÅcV]dkK\JU�µ�áJk%akK¯^a¼zJ¯^abz¢kKUbW�U���W�S%abW�\^k%c�aVW�S%�d�`Y»]d\wcVW aVW�UXcbW��3]`\3UbzMW�p*]djlYw]`\^�cVt^W�UbW,W*ÝhW�p*¯hcV]dkK\JU fnSKU���W�m�SEY�SKUbUb¯^m{W�cVtJSnc�Snc¼�`W�SKUec�UXkKm³Wk%j+cbtJW�k%z¢W auSncb]`k%\MS|�Ã�^SncuS|ºJSKUXW�U�S|aVW»S%�daVW�SK�hY�aVW�S|�`]�UXW��õ

Õ�t^]`U�m³W�S|\JU�cbtJS|c�cbtJW,abW ÉJ\^W�m³W�\wc+k|jhxy~9°i¶yohR UXt^kK¯^����`W�SK�rcVkrS�UXz¢W�p ]àÉMp�SncV]dkK\&cVtJSnc�]�U�W�ãK¯J]d_nS|�`W \wc�cbkrS%\�S|�`abW�S%�hYaVW�S%�d]�UXW��y�JSncVS%ºJS%UbW�m�S%put^]`\^W%µ�Ày\�cbt^W,k%cbt^W�a�tJS%\J�ÃfEtJSE_P]d\J�S.abW�S|�`]`UVSncV]dkK\Ùk%j�S.m{SKput^]`\^W�Snc�tJS|\M�Ãf���W³m�SEY�¯JUbW³cbt^]�UcVk³_KW aV]àjlY[cbt^Wrp k%aVabW�pÅcb\JW�UVU9k%j+cVt^Wr¶yohR)UbzMW�p*]dÉMp S|cb]`k%\�µ

Á�W*cé¯JU±\^kn� �dkPkK´�S|céS|\4W*Ý^S|m{z^�`WÔcuS|´%W�\ÞjlaVk%m¿�Á�W ��W aVW \ E�W*cÄS%��µÆ��Ú%ÚKÚ^fÆz�µ Cwæ�IwÂŵ gi\ cbt^]�UÄp�S%UbW��9WtJSE_KW3S.UX]`\^�%�`W³k%z¢W auSncb]`k%\MS|���^SncuS|ºJSKUXW3�s]àcVtÙÉJ_KW&aVW ��SncV]dkK\UVput^W m�S|cVS»S%U�]`�`�d¯JUXcbauSncVW��³]`\3cVt^W 6y��q0R �h]�S|�KaVS%mâ]d\[á�]`�|°¯^aVWy�^µ¼g¥j���W!S%UVUb¯^m{W0SrUX]`m{z^�`WyUXcVS|a9Ubput^W�m�S�jlk%a,cVt^Wy�JSncVS��S|aVW t^kK¯JUbW�SKU[]`�d�`¯JUXcbauSncVW��׺PY@cbt^W�6!��q!R �h]�S|�%auS|m ]d\á�]`�%¯^aVW7C3��W»tJSE_%Wycbk[Ubz¢W�p*]djlY[ÉM_%W�UX]`m{z^�`W�abW jlabW�UXt.ab¯^�`W�U�µ

Õ�t^]`U��`W�SK�^U.cbk@cbt^WÆjlk%�`�dkn�s]`\^�¸UXz¢W�p ]àÉMp�SncV]dkK\Çk|j³xy~9°¶�ohR²fs]`\½�stJ]`put½�9W·kKm³]dc�cbt^W·m�S|]`\½ab¯^�`W%f»�st^]�put½tJS%US%�daVW�SK�hY�ºMW�W \��hW ÉJ\^W���S%ºMkn_KW%µ

K&L-N x�~9°¥¶�ohR^ _ P4Q�R S W*ÝPcVaVSKpÅc z^¯JaVputJSKUXWKfPW*ÝPcbauS%p*c p*¯JUXcbkKm{W a

W ÝPcbauS%pÅc UXt^kKz�f^W ÝwcVaVSKpÅc zJabkh�h¯Jp*cL OJb�c K S-dMR ^

oPcbk%aVWK¿A�%Â�¿¾p k%\wcbaVk%�`�`W��JÂ*f}�S%aXcE¿ CwÂy¿�p*kK\KcVabkK�d�`W��MÂÅfv9¯MUecVk%m{W aE¿ CwÂy¿�p*kK\KcVabkK�d�`W��MÂÅf~�¯^YhU�¿V�P»¿¾p*kK\wcbaVk%�`�dW��JÂÅfÀ G�W aE¿�æKÂ�¿¾p*kK\wcbaVk%�`�dW��JÂ

� Q����m�S%]d\ �ʵ�µ µW ÝPcbauS%pÅc z^¯^auputJS%UbWK¿ � Âs�0h�"-^��5�5�auf+f �Kf #Åf� ��f���@�B4w�� ` > ~�¯^YhU�¿aY=��= ` =�#XÂ���;��� �% =@r�> v9¯JUXcbkKm³W�a�¿EaY=% =#rhÂ��� ��� ��m= � > }�S|abc�¿� =�� = � Â���;��� &r��o> oPcbk%aVW%¿/��=@r���Â������� � >`¿¥À G¢W�an¿� = �-=� �5=���= � Â��� � � � r,#��P¿#X � � Â

Page 5: Data mart - CRPITcrpit.com/confpapers/CRPITV31Zhao.pdf · 5 >.¦ ¨: ^ _ < =?> >?> = `\a ^ 6 : ` +: ¿ ->

PurchaseShopCustomer

Product

Time

money-sale profit

quantity

address

name

description

pid category

name town state

region phone sid

cid

PurchaseShopCustomer

Product

Time

money-sale profit

quantity

address

name

description

pid category

name town state

region phone sid

cid

á�]d�K¯^abW7CJ� =�aVkhp*W�abY.oPcbk%aVW%�,owcuS|a!ohputJW m�S

�h��5w�"4�������� � ¿ ` �n~�¯^YhU�¿EaY=� = ` =#XÂ��� �»ÂÅfV9����� � f� ������¿� � � Â��¤ � ¿aY= = �-=�#\=�� = V�=��rÂ9� ���

�%¤h�P�h�W*ÝPcVaVSKpÅc p ¯JUecVk%m{W a�� µ µ�µ�0k%cbW�cVtJSncÇcbt^WâaV¯^�`WâW*ÝPcVaVSKpÅc z^¯JaVputJSKUXW¹aVW�S%�d]�UXW�U;S

_w]`W ��µ9Z!Ub]d\^�[o �Á®cVt^Wr�hW ÉJ\^]`\^�[ãw¯^W aVY�p*kK¯^����tJSE_KW»ºMW�W \�hW*ÉJ\JW���W�ãw¯^]`_nS|�`W \wcb�`Y.SKU

�%�65K�J�14.vyµ p*]��Ãf^}�µ zJ]`�Ãf¢o�µ Ub]��ÃfJ~�µ cV]dm{WKfoh¯^m�¿AÀ3µ ãK¯MS|\wcb]dceY^Âs�^�³ãK¯MS|\wcb]dceY%foh¯^m�¿AÀ3µ ãK¯MS|\wcb]dceY^Â��³À3µ z^aV]`p Wr�^�3m³kK\^W Y UVS|�`W�U�foP¯Jm�¿¥À3µ ãw¯JS%\wcb]dceYhÂ��yÂ*¿AÀ3µ z^aV]`p W�°¼À3µ p*kwUecÅÂ+�J�sz^abk%É^c

0,-^��¡Tv9¯MUecVk%m{W ayvyfJ}�S%aXcs}�fMowcVk%aVWro�f~�¯^YhUs~�f¢À G�W ayÀ

�P�J�?-^�{~�µ cb]`m³WKµ`¿��^SEY%f m{k%\wcbt+f YKW�S|aÅ �±À3µ �^SncVW� -^���� ��h£�vyµ p*]��ÃfJ}�µ z^]��ÃfJo�µ UX]��ÃfJ~�µ cb]`m{W

J8hJ � �� ��«h©�« jè«^ª� ��ÎMÐ�¨H�¦ � �¶!p p k%au�h]`\^��cVk.kK¯^a»�%W�\^W auS|��]`�^W�S.cbt^W��hW ÉJ\^]dcb]`k%\Æk|j�x0­È°¶yohR��s]`�d���`kPk%´�SKU�jlk%�`�dkn�0U��

KML�N xs­È°¥¶�ohRO N�P4Q�R S xy~9°i¶yohRÓ¿lW*ÝPcVaVSKpÅc\<nfõ µ�µ f^W ÝwcVaVSKpÅcYAPÂ^ _ P4Q�R S p*aVW�S|cbW _P]dW���<Ef�µ�µ µ�fJp*aVW�S|cbW _P]`W �sqL O�b�c K S-d&R ^

�h<n¿5r-UJ< »¿�p*kK\KcVabkK�d�`W��MÂÅfµ µ�µ f

�2Zh¿�r�U�Z|»¿¾p k%\wcbaVk%�`�dW��JÂ� Q ���

m�S|]`\ ��10[UbW �`W�pÅcVW��®¿laVW*jlaVW�Ubt4C�Â4w�J�|¤[W ÝPcbauS%pÅc C ¿ � C Â�65^���10�UbW �`W�p*cbW��®¿l_P]`W �sC¥Â4w�J�|¤�p abW�SncVW _P]dW��sCX¿ � CiÂ�%¤^� �10

p abW�SncbW _w]`W �sCb¿ � C¥Âs� µ µ�µ�0k%cbW�cbtJS|c¼xs­È°i¶yohRÔ�^kwW�UÃ\^k%c+�dkPkK´�Ub]d�K\^]dÉMp S%\KcV�dY��h]dj °

jlW aVW \wc�jlabkKmèxy~9°i¶yohRHµ%Õ�t^W�abW�S%Ubk%\�jlkKa�cbt^]�U�]�U�cbtJS|c,ºMk%cbt¶yohRTU.UXz¢W�p ]àjlYÈUb]dm{z^�`WTaVW ��Sncb]`k%\MS|�0�^S|cVS|ºMS%UbW�U�S|\M�@_P]`W �p*aVW�SncV]dkK\.kKzMW�aVS|cb]`k%\JU�kK\�cVt^W m�µ

g¥jsW*ÝPcbauS%p*c@Cb¿ � C¥Â�]�U»cbt^W�kKzMW�aVS|cb]`k%\Æjlk%a�W ÝwcVaVSKpÅcV]d\^��cVt^W�^SncuSTjlkKa3cVt^WUa�°Acbt@abW��`S|cb]`k%\¸Ubput^W�m�ST]`\ÓcVt^W��JSncVSÆ��S|aVW*°t^k%¯JUbW&UVput^W m�S{�saV]àcV]d\J��cbk[_nS%ab]�S|º^�`W � C fMcbt^W�\�cbt^W3k%z¢W auSn°cb]`k%\�tJS%U�cbk{º¢W�p�S|�`�dW��[�s]dcbt.cbt^W�aA°�cVt�aVW ��SncV]dkK\�UbputJW m�S3SKUcbt^W�S%pÅcV¯JS|�9zJS|auS|m{W cbW a�µ�Õ�t^]`U&�%¯JS%aVS%\wcbW W�U�cbtJS|c&cVt^W��hW °UX]`abW��&�^S|cVS!]`U�W*ÝPcVaVSKpÅcbW��»jlaVk%m½cbt^W�k%z¢W auSncV]dkK\JS|�P�^S|cVS|ºMS%UbW�US|\J��]d\JUbW abcbW���]`\wcbk3cbt^W�aV]d�KtKc��`kPp�SncV]dkK\�]`\[cbtJW»�JSncVS3��S|aVW*°t^k%¯JUbW%µ

á^kKa·]d\JUXcVS%\Jp*WKf3W ÝPcbauS%pÅc z^¯^auputJS%UbWHW*ÝPcVaVSKpÅcVU®S|�`�{z^¯^ab°putJS%UbW�U�k%j!STp*W�aXcuS|]`\²z^aVkP�^¯JpÅc&ºPY·STp*¯MUecVk%m{W a³Snc3STp W ab°cVS|]`\�cV]dm{WrcVk%�KW*cbtJW a0�s]dcbt�cVt^WrcVk|cuS|�¼ãw¯JS%\wcb]dceY%fJzJab]�p*W&S%\J�z^abk%É^c�µ���ÝhW�p*¯hcV]d\^�!cbt^W�aV¯^�dW�aVW*jlaVW�Ubt z^¯^auputJS%UbWK¿�},¯^auputJS%UbW�Â

Sales

money_sales

quantity

Timemonth

year

quarterTimemonth

year

quarter

Shopsid

address

Region

name

state

á¼]`�%¯JabW2�J��o^put^W m�S³¯^\J�hW�ab�`YP]d\J�{S{�^S|cVS³m�S|abc

tJSKU�cVt^W!W�G¢W�pÅc�cVtJSnc�cbtJW�UbW!�^SncuSr�s]`�d�¢º¢WyUXcbk%aVW��{]`\�cVt^W!aVW*°��SncV]dkK\�}�¯^aVputMS%UbW!k|j�cbtJWr�^SncuS3��S|aVW tJk%¯JUbW%µ

À!j�p*k%¯JaVUbW%f¢�9W3�9kK¯^�����d]`´%W&cbk�tJSE_%W&W��[p*]`W \wc»abW jlabW�UXth°kKzMW�aVS|cb]`k%\JU�µrgi\®zJS|abcb]�p*¯^��S|a�fÃ��W3��k%¯^���TaVW��^¯Jp*W³cbtJW{�JSncVS��S|aVW t^kK¯JUbW�¯^z¢�JSncbW�U¼cbk!]`\Jp abW�m³W�\wcVS|�PputJS%\^�%W�U µ+Õ�tJW�UbzMW�pÅ°]dÉMp S|cb]`k%\.k|j�p k%aVabW�UXz¢k%\M�h]d\J�&aV¯^�dW��s]`�d�ú¢W»�dW j c!S%U�S&aVW*ÉM\^W*°m{W \wc�cVSKUX´�µ

Á�W*c�¯JU9\^kn�;p*kK\KcV]d\P¯^W!k%¯^a��%aVkhp*W aVY3UXcbkKabW!W*Ý^S|m{z^�`W%fw]d\�st^]�put�p SKUXW�cbtJWrp*k%\wcVabkK�d�`W���jl¯^\Jp*cb]`k%\JU ��C,p k%aVabW�UXz¢k%\J��cbkcVt^W0aVW ��Sncb]`k%\[UVput^W�m{S|cVSrS%ab]�Ub]d\^�»jlaVk%m±cbtJWyUXcVS|a�UbputJW m�S»]d\á�]`�%¯^aVW0C^µy­ÆW3k%m{]dc!cbtJW&m�S|]`\TaV¯^�dWKf��st^]`putÙtJS%UyS|�`abW�S%�hYº¢W W�\�Ubz¢W�p*]dÉJW��õ

K&L-N xs­È°i¶yo^RO N P4Q�R S x�~9°¥¶�ohRH¿¾W*ÝPcbauS%p*c z^¯^auputJSKUXWKfwW ÝPcbauS%pÅc UXt^kKz

W*ÝPcbauS%p*c p*¯MUecVk%m{W a�fhW*ÝPcbauS%p*c z^aVkh�h¯JpÅcÅÂ^�_ P4Q�R S p abW�SncVW _P]dW�� UVS|�`W�U�fõ µ�µL OJb�c K S�dMR ^

oPt^kKz+¿¾Ûw»¿¾p*kK\wcbaVk%�`�dW��JÂÅf},aVkh�h¯JpÅcE¿ CwÂy¿�p*kK\KcVabkK�d�`W��MÂÅfv9¯JUXcbk%m{W�a�¿�CKÂ�¿¾p k%\wcbaVk%�`�dW��JÂÅfÕ�]dm{Ww¿eµ�µ µbÂ�¿�p*k%\wcVabkK�d�`W��JÂ*f},¯^auputJSKUXWw¿�@|Ây¿¾p k%\wcbaVk%�`�`W��JÂ

� Q����m�S|]`\ � µ µ�µp*aVW�S|cbW _P]`W � UVS|�`W�U�¿ � Âs� µ µ�µ

Õ�t^WyaV¯^�`W�p abW�SncVW _P]dW�� UbS%�dW�U9p abW�SncbW�U9S3_P]dW��;�s]dcbt.cbt^W¯^\M�hW aV�dYP]`\^�3UVput^W�m{SrjlabkKm á¼]`�%¯JabW��Jµ�Z!Ub]d\J�³o �ÁÆ�9W�p S%\�saV]àcVW�cbt^Wr�hW ÉJ\^]`\^�[ãw¯^W aVY[S%U�jlkK�d�`kn�0U��

�|�65w�J�14�oõ Ub]`��fMo�µ abW��%]`k%\�f^o�µ UecuSncVW%fÕ»µ m{k%\wcVt�fJÕ»µ ãK¯MS|abcbW a�f^Õ»µ Y%W�S%a�foP¯^m�¿¾}�µ ãw¯JS|\wcb]dceY^Âs�J�3ãw¯JS|\wcb]dceY%foP¯^m�¿¾}�µ m{k%\^W�Y UVS|�`W�Â��J�&m{k%\JW Y UbS%�dW

0"-^�E¡�oPt^kKz�oÃfJÕ�]dm{WrÕ»fJ}�¯^auputJS%UbWy}� -^���� ��h£.o�µ UX]��ÃfJÕ»µ m{k%\wcbtZ!Ub]d\^�{cVt^W&aV¯^�`W&UbzMW�p*]dÉMp S|cb]`k%\��`S%\^�%¯MS|�%W�k%j�¶�ohRTUy�9W

kKºhcVS%]d\.cbt^W»jlkK�d�`kn�s]`\^�³�^W*ÉJ\^]dcb]`k%\�jlkKa0p*aVW�SncVW _P]dW�� UbS%�dW�U �p*aVW�SncVW _P]dW�� UbS%�dW�U�¿ � Âs�0h�"-^�65,5 �-=WUJ= �G#\= � = ` =���@�B4w�� �% =#\= �� > oht^k%z+¿/�-=% =#\=#UJ= �G#\=���M ������ �>?>�>?> Õ�]dm{WP¿z>�>?>?= � = ` =��m=?>�>?>XÂ��� �

�h� 5K�"4�� ����� � ¿ ` �+� ��J=��=#\= ���5=�7��>},¯^auputJS%UbW|¿���= �-=��=#\= ` ��= ���o=�7�dÂ��� ���m³kK\wcbt+¿E#XÂ|� ���ãK¯MS|abcbW a�¿#XÂ|� `

Page 6: Data mart - CRPITcrpit.com/confpapers/CRPITV31Zhao.pdf · 5 >.¦ ¨: ^ _ < =?> >?> = `\a ^ 6 : ` +: ¿ ->

��Y%W�S|a�¿#X ���hÂ*fV9����� � ¿P������ ��J=��=#\= ` ��=�7��>

},¯JaVputJSKUXW|¿ �J= �-= =#\= ` ��= ����= ��Â���;���m{k%\wcbt�¿#XÂ|� ���ãw¯JS|abcbW�a�¿E#X � `��Y%W�S|a�¿#X ���hÂ

��¤ � ¿/��=#UJ= �G#\= � = ` =��m=�� = V,Â9�f�â�

J8�� � �������¦�� ¦ � �Õ�t^W»cbkKzh°A�`W _KW �öyo^R��^W�S|�`]`\^�{�s]àcVtTÀ�Á¼¶!}¸]�UsS3ºJ]àc0m{k%aVWp*k%m{z^�`]�p SncVW��Ãf�SKU�]àc�aVW�S|�`]�UXW�U0cVt^W{]`�hW�S�k%j�¯JUb]d\J���h]�S|�`k%�K¯^Wk%º ß W�pÅcVUÆjlkKaÆcVt^]�UÆzJ¯^abz¢kKUbW�U�µ Õ�t^W¸�%W�\^W auS|�³]`�^W�SÇjlabkKm¿�ohput^W��9W®S|\J�Äohput^W ��WÆ�&B&B&Bw³]`U�cbtMSnc.W�S%putׯJUbW a.tJS%U�Sp*k%�`�`W�pÅcV]dkK\Ók%j!k%z¢W \¸�h]`S%�dkK�%¯^W.k%º ß W�pÅcuU f,]Aµ W%µH�^S|cVSÆm{S%aXcuUjlk%a�k%¯^a�z^¯^aVzMkwUXW�U!tJW aVW%µ�¶�c»S%\PY�cV]dm{W{�9W3m�SEY��KW*c�\^W �¯JUXW�aVU�fPS|\J��W�S%put�¯MUXW�a9m�SEY�p*aVW�S|cbW0\^W��;�h]�S|�`k%�%¯JW!k%º ß W�pÅcuU�s]àcVt^k%¯hc0p �dkwUX]`\^�3cbt^W�W*Ýh]�UecV]d\^�³k%\JW�U�µ�Õ�tP¯JU�fh��Wym�S|]`\wcVS%]d\S!p*kK\wcbaVk%�`�dW��»jl¯^\Jp*cb]`k%\&¯MUXW�a¼�s]dcbt3¯JUXW�a�¿ ��Â�����@] G �³]`U¼cVt^W]`�{k%jÃS»¯MUXW�a,]d\{cVt^W!UbYhUecVW m�µ�¶!\JS|�`k%�Kk%¯JUb�`Y%f|��Ws¯JUbW!S�p*kK\h°cbaVk%�`�dW��³jl¯^\JpÅcV]dkK\��^S|cVS|m�S%aXc,�s]dcbt��JSncVS%m�S|abc�¿ �-� Â2�� �Ç]HG��� ]�U�cbt^W{]��Ùk%j�S��^SncuS�m{S%aXc»]`\ÙcVt^W�UXYhUXcbW m�µ³gi\®SK�^�h]d°cb]`k%\�fh��W!\^W�W���S|\^k%cbt^W�a�p k%\wcbaVk%�`�`W��³jl¯^\Jp*cb]`k%\�kn�s\^W a��s]dcbtkn�s\^W a�¿ �-�  ���Ù]d\J�^]`p�Sncb]`\^�{cVtJSnc!¯MUXW�a���kn�s\JU�cVt^W&�^S|cVSm{S%aXc ��� µ�Õ�tJW \·zJS|abc&k%j9cVt^W�jl¯^\Jp*cb]`k%\JS%�d]dceY®k|j!À�Á+¶!},°¶yohR��hW�S%�`U9�s]àcVt.SK�^�h]`\^�3S%\J�[aVW m{kn_P]d\J�r¯JUbW auU�S|\M���^S|cVSm{S%aXcuU µ³gi\®zJS|abcb]�p*¯^��S|a�fÃ]dj�S.¯JUbW a��`W�SE_%W�U0cVt^W[UbYPUXcbW�m�f�S|�`��^SncuS3m�S%aXcuU�kn�s\^W��.ºPY�t^]`m m3¯JUecsº¢W�abW�m{kn_%W��.S%U���W �`��µ

Õ�t^W�m�S ß kKa�jl¯^\JpÅcV]dkK\JS|�`]dceY%f^t^kn��W _KW a�fw�^W�S|��U��s]dcbt�ab¯J\h°\^]d\J�@kKzMW�aVS|cb]`k%\JU�k%\;W ÝP]�UXcb]`\^�Ó�^S|cVSHm�S%aXcuU�kKa.p*aVW�S|cb]`\^�\^W �;�^S|cVS�m�S%aXcuU µ�gi\�cbtJW0�`S|cXcVW a9p�S%UbW0��W0tJSE_%W�cVk&¯JUbWscVt^W_w]`W � p abW�SncV]dkK\¸aV¯^�`W�U�cbtJS|c.tJSE_KW�cbk@ºMWÆ]dm{z¢k%abcbW��×jlabkKmxs­È°¥¶�ohR²µ^gi\.cbtJ]`Usp�S%UbWy��W�put^kPkKUbW�S3\^W �Ä]`�^W \wcb]dÉJW a�jlkKacbt^]�U��^SncuS!m�S%aXc�Òy�h]`S%�dkK�%¯^W9k%º ß W�pÅc�f%S|\J�&]d\J]àcV]`S%�d]�UXWsS!jl¯^\Jp*°cb]`k%\�aVW z^aVW�UbW \wcb]`\^��]dcVU9�^SncuSrp*kK\KcVW \wc�µ�Õ�t^W�abW jlk%aVW%f|cVt^W!Ub]d�%°\JSncV¯^abW�U�abW�z^aVW�UbW \wcb]`\^�0cVt^Wsk%¯^cbz^¯hc�k%jJcbtJWs_w]`W �0U��s]`�d�htMSE_%Wcbk�cVS%´%W3cbt^W�]��hW�\KcV]àÉMW ark%j�cbtJW[�^SncuS.m�S%aXcrS%U�S�zJS%aVS%m{W*°cbW a�f|S|\M�»cbt^W�Y��s]d�`�wtJSE_%W�cbkyp k%\JUb]��hW a�S0t^]��^�hW�\&zJS%aXc�fEjlabkKm�st^]`put²S%�d��z¢kKUVUX]`º^�`W³zJabW�UXW�\KcuSncV]dkK\JU»p S|\®º¢W[�hW aV]d_KW��Ãf�S%\J�S{_w]�Ub]dº^�`W»zJS|abc�cbtJS|c0�s]d�`��º¢Wr�h]�UXz^��SEY%W��õ

g¥j�cVt^W!¯JUbW a�UXW��dW�pÅcuU9Ubk%m{W0k%jÃcbt^W��^SncuS�k|jÃcVt^Wy�h]�S|�`k%�K¯^Wk%º ß W�pÅc�S%\J�[S%\�k%z¢W auSncb]`k%\�k%cbt^W�a,cVtJS|\�ãw¯^]dc�fP]Aµ WKµ�cbt^Wy¯JUXW�a�hkPW�U»\^k%c���S|\wc�cbk��dW�SE_%W&cbt^W�UbYPUXcbW�m�fÃk%a�p*�`kKUbW%fÃ]Aµ WKµrcVt^W¯JUXW�a9�hkPW�U,\^k%c9��S|\wc,cbkrÉJ\^]�UXt[��k%aV´&kK\{cbt^W�p*¯^aVaVW \wc9�^S|cVSm{S%aXc�f%kKa,k%z¢W \�fw]Aµ WKµ¼\^k&\^W �È�^SncuS�m�S|abc,]`U�cbkrº¢W!p*aVW�S|cbW��Ãfcbt^W�\Ù��WrabW�ãw¯^W�UXc!cVk[abW�p*W�]d_KW&S%�^�^]àcV]dkK\JS|��]d\Jz^¯hc!jlaVk%m#cVt^W¯JUXW�a�fhº¢W*jlkKabW»cVt^WrUbW �`W�pÅcVW��.k%z¢W auSncV]dkK\.�s]`�d�ú¢W�W*ÝhW�p*¯hcVW��õ

gi\�k%au�hW�a�cbkÇp k%\wcbaVk%��]`\^z^¯hcÙjlabkKm ¯JUbW auU�f»S%\J���^S|cVSS|\J��kKzMW�aVS|cb]`k%\JUsUbW �`W�p*cbW���ºPY�S{¯JUXW�a0k%\TS��JSncVS{m�S%aXc!��W¯JUXW³cVt^abW�W�m{k%aVW3m{k%\J]àcVk%aVW��Ùjl¯^\JpÅcV]dkK\JU»]`\�f¼�^S|cVS UbW �,S%\J�k%z UbW �Aµ

á�]d�K¯^aVWÓæ¸]d�`�d¯MUecVaVS|cbW�U�cbt^]�UTz^aVkhp*W�UbUb]d\J�¸k%j3cVt^WHm�S|]`\ab¯^�`W0k%j�À�Á+¶!},°¥¶�ohR²µwZ!Ub]d\^�rcbt^Wy�`S%\^�%¯JS%�%W�jlaVk%m oPW�p*cb]`k%\�³�9W»k%º^cVS|]`\.cbt^W»jlkK�d�`kn�s]d\J�{Ubz¢W�p*]dÉMp�Sncb]`k%\+�KML-N À�Á+¶y}�°i¶yohR

O N P4Q�R Sxs­È°i¶yohRÓ¿¾p*aVW�S|cbW _w]`W ��<nf�µ*µ�µ fJp abW�SncbW _w]`W �sq»Â

L OJb�c K S�dMR ^�m<|¿5r-UJ< Â*f�µ µ µ f���q{¿�r�U�q»ÂÅf+¿�p*kK\KcVabkK�d�`W��M¯JUbW aE¿e�EÂÅf�¿¾p k%\wcbaVk%�`�`W��JÂkn�s\^W�a�¿X��ÂÅf�¿�p*kK\KcVabkK�d�`W��MÂ�^S|cVS|m�S%aXcE¿e��Â*f�¿¾p k%\wcbaVk%�`�dW��JÂ]`\+¿e�EÂÅf+¿¾m³kK\^]dcbk%aVW��MÂ�^S|cVS UbW �¥¿��KÂÅf+¿¾m³kK\^]dcbk%aVW��MÂk%z UXW��A¿A�%Â�¿lm{k%\J]àcVk%aVW��JÂ

� Q����m�S|]`\ �0h�?-^�65�5 ����UPf �-��@��4w���^S|cVS%m{S%aXc�¿ �-� Â��� ��h�e�10�¯JUbW a�¿ �@�?U| � �4w�J�%¤$�10�]`\+¿ �@��Un �×\^W��4w�J�|¤[¯MUXW�a�¿ ����U|Â��f�â��%¤^� �10

�65h�6�10��^S|cVS UbW �¥¿ �@��UJ= �-� Â|� ���k%z UbW �¥¿ �@�?UJ= ��� Â|� �

4w�^�%¤$�10 � *�Çãw¯^]dc4K�J�%¤[¯JUbW a�¿ �@�?U|Â�� �;�

�%�,+^0h�"-h�65�5 ��� ��@��4w���^S|cVS%m{S%aXc�¿ �-� ��Â���;���kn�s\JW a�¿ ��� � Â|���@��U

�h���^SncuS|m�S|abc�¿ ��� �`Âs�f� ��%¤h�P�h�

��5^�6�10 � *�;p �dkwUXW4K�J�%¤��^S|cVS|m�S%aXc�¿ ��� Â�� � ���5^�6�10 #�U � �4K�J�%¤[aVW�ãw¯^W�UXc ]`\^z^¯hcE¿ � �= � ac%+Â

�%�,+ � ¼¿ ����UJ= �-� = � = � a/%+Â�|¤^�7�10

�%¤h�7�10�%¤^�P�P�À!j9p*kK¯^aVUbW%f¼À�Á¼¶!},°¥¶�ohR�tJSKU�cbk�z^aVkn_w]��hW{S%�^�^]àcV]dkK\JS|�

aV¯^�`W�U�jlk%a0S%�d�ÃkKzMW�aVS|cb]`k%\JU�kK\��JSncVS{m�S%aXcuU�]d\Jp �d¯M�h]d\J�3cVt^W ]`a]`\^]dcb]�S|�`]`UVSncV]dkK\�µ0oP¯JputÙS%\�]d\^]dcb]�S|�`]�UbS|cb]`k%\��hkPW�U!\^k|c»�hW z¢W \J�kK\@cVt^WÙSKpÅcb¯MS|�!�^S|cVS%m{S%aXc �-� \^kKa��hkPW�U[]àc�aVW�ãw¯^W�Uec[]`\h°z^¯^c��JSncVSJµH~�S%Ub]`p�S|�`�dYKf,]àc{tJSKU&cVk®p abW�SncVW�SÆ_P]dW��Ôk%\Ócbt^W�^S|cVS3��S%abW�t^k%¯MUXW�¯JUb]d\^�³k%\JW�k%j+cVt^W�ab¯J�dW�U�]dm{z¢k%abcbW���jlaVk%mxs­È°i¶yo^R²µ�6!kn�9W�_%W�a�f¼]d\HkKaV�^W a�cVkÙUX¯Jz^zMkKaXc&cbt^W�À�Á+¶!}kKzMW�aVS|cb]`k%\JU�k%\³cVt^W0�^SncuS»m�S|abc�cVt^W0_P]`W �¸tJS%U�cVk�ºMW0�h¯Jz^�d]d°p�SncbW��TaVW�Ub¯^�dcb]`\^��]`\®S�t^]��^�hW \·S|\M�ÙS._w]�Ub]dº^�`W³zJS|abc�µ3Ày\^�`YcVt^W�t^]��^�hW \�zMS|abc!p*k%\wcuS|]`\JU�cbt^Wrjl¯^�d�¼]d\^jlk%aVm{S|cb]`k%\�µ9gi\�S%�P°�h]dcb]`k%\+fK��W!tJSE_KWscbk³p*aVW�S|cbW!S&\^W �×]��hW \wcV]àÉJW�a�jlkKa,cVt^W��JSncVSm�S|abc0S|\J��S%UVUbkPp ]`S|cbW»S%��kn�s\^W�a9cVk{]àc�µ

Õ�tw¯MU fÃS�ceYPz^]�p S%��]d\^]dcb]�S|�`]�UbS|cb]`k%\TkKzMW�aVS|cb]`k%\�]`\·À�Á+¶y}�°¶�ohR��s]d�`��tJSE_KW!cVt^W»jlk%�`�dkn�s]`\^�3jlk%aVm��

k%z¢W \ C ¿ �@�?UJ= ��� = � = � ac%+Âs��E�^�P�J�%� ��� ��@��4w���^S|cVS%m{S%aXc�¿ �-� � Â|����h��p*aVW�S|cbW _P]`W � C ¿ � C Â�|�,+ 5K�"4�>�>?>?=���Cfe��;p�eK¿ � CAÂ/=���C e �^��C e-=?>�>?>��¤�� C ¿ ���]� =� Cu< =�>?>�>?=� C Z y =�� �C < =?>�>?>/=�� �C Z y Â��f�â�

�|�,+[�JSncVS%m�S|abc�¿ �-� ��Â�� ����|�,+�kn�s\JW a�¿ ���]� Â��f������U

�%¤h�P�h��0kn���`kwkK´�S|�KS%]d\ÆSnc»k%¯^a��%aVkhp*W aVY�UecVk%aVW&W*Ý^S%m³zJ�dWKµ�gi\

cVt^]`U[W*Ý^S|m{z^�`W��9W�]`m³z¢k%abc�cbtJW�_w]`W �#p*aVW�S|cb]`k%\¸ab¯^�`W�p*aVW*°S|cbW _P]`W � UVS|�`W�U�f^�st^]�put�p�S|\�º¢Wr¯JUbW��.cbk�]d\^]dcb]�S|�`]�UXW&S��JSncVSm�S|abc��hW�S%�d]`\^�®�s]àcVt¸UVS|�`W�U³UecuSncV]`UXcb]�p U�µÈÀyºP_P]dkK¯JUb�dYKf�cbt^W�abWm�SEY³ºMW�m{k%aVW0cbtMS|\�kK\^W!¯MUXW�a9��k%aV´P]d\^�&k%\�S3UbS%�dW�U9UXcVS|cb]�Ue°cV]`p�U!Snc!cbt^W³UbS%m³Wrcb]`m³WKµ!á�]d�K¯^aVW&Û[Ubt^kn�0U0�h]HG¢W�abW�\wcy��SEYPUk%jMz^aVW�UbW \wcVS|cb]`k%\&cbt^Ws�^S|cVS�]d\P_Kk%�`_%W��&]d\{Ub¯Jput³S»�^S|cVS�m�S|abc�µ

gi\.j¾SKpÅc�f^�9W�p k%\JUb]`�^W a ß ¯JUXc0ce��k{�^]dm{W \MUX]`k%\JU����`kPp�SncV]dkK\S%\J�[cV]dm{WKµ9¶��`khp SncV]dkK\.m�SEY.ºMW�W�]àcVt^W a!S�Ubt^kKz.]`\J�h]�p S|cbW��ºPY¸]àcuU[]��hW \wcb]dÉJW�a.Ub]`�;S%\J��¿lkKzhcb]`k%\MS|�`�dY^Â{]dcVU.abW��%]`k%\×S|\M�UXcVS|cbW%f¼k%arS�aVW �%]`k%\®]`\J�h]�p SncVW��®ºPY�cbtJW�abW��%]`k%\®\JS|m{W[S|\M�¿¾k%zhcV]dkK\JS|�`�dY^Â[]àcuU�UecuSncbWKf!kKa�S¸UecuSncVW%µÔ¶0\MS|�`k%�%kK¯JUb�dYKfsjlk%acV]dm{W»�9W»m�SEY�tJSE_KW�S3m{k%\wcbt�f^S{ãw¯JS%aXcVW a�k%asS3Y%W�S%a�µ�Õ�t^Wj¾SKpÅcVUsS%abW�ãw¯JS%\KcV]àceYKfh]�µ W%µ,cbt^W»cVk|cVS%��\P¯^m&º¢W ask%j�UVS|�`W�U�f^S|\M�m{k%\JW Y UbS%�dW�U f¢]�µ W%µycbtJW³Ub¯^m k|j9UVS|�`W�U!_nS|�`¯^W�U�µ�Õ�tJW aVW*jlk%aVW%f��W³putJkwkwUXW&cbk�aVW z^aVW�UbW \wc!cVt^W��^SncuS�m{S%aXc»ºPYTS�Ún°iS|aVY.aVW*°��SncV]dkK\�µTÕ�tJSnc³]`U�f�]d\Hcbt^W�UX]`�%\JS|cb¯^aVW�k|j�À�Á¼¶!},°¥¶�ohRä�9Wm3¯JUecstJSE_KW

���� �� ¿�ÚKÂ�¿¾p k%\wcbaVk%�`�`W��JÂY>Õ�tw¯MU fP��W!k%º^cVS|]`\[cVt^Wyjlk%�`�dkn�s]`\^�raV¯^�`Wy]`\�À�Á¼¶!}�°i¶yo^R

jlkKaÆcVt^WÈ]d\J]àcV]`S%�d]�UbS|cb]`k%\ék|j�SÄ�^S|cVS½m�S|abc·jlk%a®cbt^W×UVS|�`W�UUXcVS|cb]�UecV]`p�U �

k%z¢W \ ��� �� ¿ �@��UJ= �-� = � = � ac%+Â7��E�J�P�J�|� �-� ��@�B4w���^SncuS|m�S|abc�¿ ��� � Â|� ��h��p abW�SncVW _P]dW�� UbS%�dW�U ¿ � Â�%�,+30h�"-^��5�5 �-=WUJ= � #\= � = ` =��m=��+= V

�@�B4K� � ¿P�-=WUJ= �G#\= � = ` =��m= � = V,Â��� ��h��5w�"4A�7�è¿P�-=#UJ= �G#XÂÅf6� �(�â¿/��=#UJ= �G#XÂÅf

Page 7: Data mart - CRPITcrpit.com/confpapers/CRPITV31Zhao.pdf · 5 >.¦ ¨: ^ _ < =?> >?> = `\a ^ 6 : ` +: ¿ ->

usr in USER

data_sel = d op_sel = op

forall usr, forall dm in DATAMART

Op=quit remove usr from

USER

usr not in USER

in=new

Op=close remove dm from

DATAMART

d-in ok?

request = input (d-in)

add usr to USER

run (op[d](d-in))

forall dm’ in DATAMART

USER(dm’)

= usr

Remove dm’ from DATAMART

yes

no

yes

no

yes

yes

no

no

á�]d�K¯^aVW�æ^��Õ�t^W�m�S|]`\.aV¯^�`W�]d\ÙÀ�Á+¶y}�°i¶yohR

#|�â¿ � = ` =��^ÂÅf #X�(�â¿ � = ` =��^ÂÅf�'�����{f V �(�3V

��¤ � ��� �� ¿ �-� ��=��=#\=��+= V�=� �V=#X�5=�� ��= V �`Â�� �â��%¤^�w�h�À!cbtJW a²ceYPz^]�p S%�.À�Á+¶!}�kKzMW�aVS|cb]`k%\JU®]`\Jp*�`¯J�hW×aVk%�`�à°¥¯^z

S|\J�Æ�hab]`�`�à°i�hkn�s\�µrÕ�t^W�UXW³k%z¢W auSncV]dkK\JUyabW�S|aVaVS%\^�%W»cVt^W{z^abW °UXW�\KcVW��H�JSncVSTºwY·m{kn_P]d\J�T¯^zÓS%\J�H�hkn�s\·cVt^W.�h]`m{W \JUb]`k%\t^]dW�aVS%aVputJ]dW�U µ�á^kKa»]d\JUXcVS%\Jp*WKfÃ]d\Ùcbt^W�UVS|�`W�U�UecuSncV]`UXcb]�p U»�^S|cVSm{S%aXc{k|j�k%¯^a{�Kabkhp*W�abY·UXcbk%aVW�W*Ý^S|m{z^�`W.��W�tJSE_%W.ce�9k®�h]d°m³W�\JUb]dkK\JU��dkhp S|cb]`k%\®S|\J�Tcb]`m³WKµ&á�]d�K¯^aVW3Û.]d�`�d¯MUecVaVS|cbW�UycVt^WW.G�W�pÅcuU³k|j!aVk%�`�à°¥¯^zÓS%\J�H�haV]`�d�d°¥�^kn�s\²jlk%a3cbt^W��`kPp�SncV]dkK\Ó�h]d°m³W�\JUb]dkK\��,UXtJk%z � aVW �%]`k%\ � UXcVS|cbWKµ

Õ�t^W@jlk%�`�dkn�s]`\^�Äab¯^�`W¸]d\ À�Á+¶!},°¥¶�ohR UbzMW�p*]dÉJW�UÆcVt^WabkK�d�d°A¯Jz�jlaVk%m Ubt^kKz.cVk{abW��%]`k%\��

aVk%�`�à°¥¯^z ������ ¿ ���  �0h�"-h�65�5�U�@�B4K�� ��H<�=##<J=���<J= V <J=X� � =# � = � � = V � >

���� �� ¿ �-� =X� < =�# < = � < = V < =� ��=#X��=��'��= V@�EÂ��� ��� ��= �G#\> �H<7�è¿P�-=WUJ= �G#XÂ

�h��5w�"4 �� �� ��¿�UJ= �G#XÂ� � �� �^��� � ¿ � < � ��H<�=##<J=���<J= V <J=X� � =# � = � � = V � = �-= �G#\>� ��� �� ¿ �-� =� < =�# < =�� < = V < =X� ��=#X��=��'��= V@��Â��� �� �H<7�è¿P�-=#UJ= �G#XÂXÂ*fV�� �� �^��� � ¿/V <»� �� < =# < =�� < = V < =X� ��=#X��= �'��= V@��= �-= �G#\>� ��� �� ¿ �-� =�H<�=�##<�=��i<�= V�<�=X� � =# � =�� � = V � Â��� �� � < �è¿P�-=#UJ= �G#XÂXÂ

��¤ � ��� �� ¿ ��� =X�H<J=##<�= ��<�= V <�=

� � ��|=#X��=�� � �� = V � ��¼Â��f�â��%¤^�P�h�

J 8� L P«^¨�Î Í Ñ Í�� «h§9ÎMм© ©H�� ¦ � � i ªnÎ¢Ð Í Ï� Î�Ï���

Õ�t^W9¶yohR �KabkK¯^\J��m{kh�hW �P�hW _KW �`k%z¢W��»Ubksj¾S|a¼]`U¼UecV]d�`�KauSncVt^W a_nS|�K¯^W�]`\×cbt^W®UXW�\JUbW�cbtJS|c.�`k|cuU[k|jr�hW cVS%]d��U�S%abWTm{]�UbUb]`\^�JµÕ�t^W�UXW��s]`�`�9º¢W�S%�J�hW��·��SncVW a&_P]�S�abW ÉJ\^W�m³W�\wcVU�µ�áJ¯^abcbt^W�aX°m{k%aVW%fnS%\&S%�h_nS%\KcuS|�KW,k|jJ¶�ohRTU��h]�Ubp ¯JUbUbW��r]d\�¿¾~ Dk%aV�%W�a¼S|\M�owcDS|aV´��&B&B&CwÂ9]`U�cVtJSnc��hW�Ub]d�K\^W auU0S%abW�\^k%csjlk%aup*W���cbk�_%W�ab]djlYcVt^W ]`a�UbzMW�p*]dÉMp S|cb]`k%\×Snc�]`m{m�Sncb¯JabWÙUXcVS%�%W�U µÇÕ�tJ]`U��dW�SE_%W�UcVt^W3�hW�UX]`�%\JW a0cVt^W3jlabW�W��hkKm cVk.�hW�UX]`�%\�ÉMaVUXc�S%\J��cbk.S|\JS%�à°YhUbW»S%\J�._%W aV]djlY[�`S|cbW�a�µ

60kn��W _%W�a�f!cbt^WH¶�ohR �%aVk%¯J\J�;�`W _KW ��jlkKaT�^SncuS@��S|aVW*°t^kK¯JUbW�U�S|\J�ÆÀ�Á¼¶!}ÇcbtJS|c���W&tMSE_%W3�^W _%W��dkKzMW��ÙUbk[j¾S%a�S%�à°aVW�SK�hY&S|�`�`kn�0U¼¯MU�cbkrUXcVS%aXc,Ubk%m{W�ÉJauUec�ãw¯JS%�d]dceY&put^W�pu´PU��s]dcbtaVW�UbzMW�pÅc.cbkHcVt^WÆUVSncV]`UXj¾S%p*cb]`k%\;k%jrabW�ãw¯^]daVW m{W�\KcuU µé¶!U.�9WSK�hk%zhcVW��Ùcbt^W��h]�S|�`k%�K¯^W{k%º ß W�pÅcrS|zJz^abkwS%put�cVk��^SncuS.��S|aVW*°t^kK¯JUbW�U�S|\J��À�Á+¶y}�fw��W��s]d�`��tJSE_%Wycbt^Wyjlk%�`�`kn�s]d\^�³�%W�\^W auS|�aVW�ãw¯^]`abW�m{W \wcVU���Kµ�¶�c�W�SKput�cb]`m{W�S!¯JUXW�a¼]�U�W ]dcbt^W�a¼�`k%�K�%W��»]d\�f%]�µ W%µ¼´w\Jkn�s\

cVk³cbt^WrUbYhUecVW m�f^k%as\Jk|c�µ�­×]dcbt�aVW�Ubz¢W�pÅc�cVk{cbt^W»jl¯^\MpÅ°cV]dkK\JU¼�9W,¯MUXW��r]`\�cbt^W�m�S|]`\raV¯^�dW9]d\{À�Á+¶!},°¥¶�ohR²f��9Wp�S|\.jlk%aVm�S|�`]`UbW!cVt^]�UsabW�ãw¯^]daVW m{W�\KcsºPY�cVt^W�]d\P_nS|aV]�S|\wc

� �@��UJ> ¯MUXW�a ¿ �@��Un � ���[¯MUXW�a�¿ ����U| �¹�h>

�^µ�g¥j�S[¯JUbW a�]`U�\^k%c��`k%�K�%W���]d\�f�cVt^W³k%\^�`YTSE_nS|]`�`S%º^�dW&k%zh°

Page 8: Data mart - CRPITcrpit.com/confpapers/CRPITV31Zhao.pdf · 5 >.¦ ¨: ^ _ < =?> >?> = `\a ^ 6 : ` +: ¿ ->

sid 1 region 1 (state 1 ) month 1

Shop Region (state) Month Quantity Money_sale

qnty 1 m_s 1

month 2

sid 2 region 2 (state 2 ) month 1

Region (State) Month Quantity Money_sale

region 1 (state 1 ) month 1 qnty 1 m_s 1

month 2

region 2 (state 2 ) month 1

State Month Quantity Money_sale

state 1 month 1 qnty 1 m_s 1

month 2

state 2 month 1

drill - down (location)

roll - up (location)

drill - down (location)

roll - up (location)

sid 1 region 1 (state 1 ) month 1

Shop Region (state) Month Quantity Money_sale

qnty 1 m_s 1

month 2

sid 2 region 2 (state 2 ) month 1

sid 1 region 1 (state 1 ) month 1

Shop Region (state) Month Quantity Money_sale

qnty 1 m_s 1

month 2

sid 2 region 2 (state 2 ) month 1

Region (State) Month Quantity Money_sale

region 1 (state 1 ) month 1 qnty 1 m_s 1

month 2

region 2 (state 2 ) month 1

Region (State) Month Quantity Money_sale

region 1 (state 1 ) month 1 qnty 1 m_s 1

month 2

region 2 (state 2 ) month 1

State Month Quantity Money_sale

state 1 month 1 qnty 1 m_s 1

month 2

state 2 month 1

State Month Quantity Money_sale

state 1 month 1 qnty 1 m_s 1

month 2

state 2 month 1

drill - down (location)

roll - up (location)

drill - down (location)

roll - up (location)

á¼]`�%¯JabW&ÛJ�sÕ�t^WrW.G�W�p*cyk%j,abkK�d�d°A¯JzTS|\J���haV]`�d�d°¥�^kn�s\�k%z¢W auSn°cb]`k%\JUskK\�UVS|�`W�UsUXcVS|cb]�UecV]`p�U

W auSncV]dkK\.]�U�� \JW ���`f^�st^]�put�]�U�jlk%aVm�S|�`]`UbW��.ºPY� �@��UJ> ¯JUbW a�¿ �@�?U| � � �[]`\+¿ �@��U|Â��� �

�)]d\�¿ �@�?U|Â|�;\^W ��>

­×]dcbt^kK¯hc��%kK]d\J�®]`\wcbk²�hW cVS|]`��U�k|j�jlk%aVm�S|�s_%W�ab]dÉMp�Sncb]`k%\cbW�putJ\^]`ãw¯^W�U � �9WÙS%abWTp k%\hÉ¢�hW \wc[cVtJSnc.cbt^W�cVW�put^\J]`ãw¯^W�U¯JUXW��H]`\Ä¿Aohput^W ��W®��Ú%Úwæ%Â�p�S|\Hº¢W�S%�^S%zhcbW��·cbk·¶yo^RTU��]àc!]�UsW�S%UbY[cbk[UbW W»cVtJSnc!cbt^W�m�S|]`\�aV¯^�dW�]`\ÙÀ�Á+¶y}�°i¶yohR�]�Up*k%\MUX]�UecVW \wcs�s]àcVt�cbt^W�UXW»ce��k{]d\P_nS|aV]`S%\wcVU�µ

á^¯JaXcVt^W aVm{k%aVW%f��9WÄk%ºhcuS|]`\ aVW�ãw¯^]`abW�m{W \wcVU@k%\ �JSncVS|°m{S%aXcuU�cbtJS|c!S|aVW»abW�S|�`]`UbW���ºwY��h]�S|�`k%�%¯JWykKº ß W�p*cVU��C^µs��SKputâ�^SncuS|m�S|abcÆS|�`��SEYPUÙºMW��dkK\^�KUTcbk½S;¯JUbW a®�st^k

m&¯JUXc�ºMW��`k%�K�%W��H]`\ÓcVkÆcVt^W�UXYhUXcbW�m�f9�st^]�put@]�U³jlk%ab°m�S|�`�dY.W*Ýhz^aVW�UVUXW��[ºPY�cbtJW�]d\P_nS|aV]`S%\wc

�m�-� > �^SncuS|m�S|abc ¿ �-� Â��� ��� ����UJ> ¯JUXW�a�¿ ����U| �¹�8�.kn�s\^W�a�¿ ���  ���@��U

á^kKa9cVt^]�U�]d\P_nS|aV]`S%\wc�]dcs]`UsS%�KS|]`\[W�S%UbY{cbk�UXW�W!cVt^W�p*kK\h°UX]�UXcbW \Mp*Y�k%j+cVt^W�m�S|]`\�aV¯^�`W»]d\ÙÀ�Á+¶y}�°i¶yohRHµ

�Mµ�áJ¯^abcbt^W�abm{k%aVW%f���WÇtJSE_KW;abW�ãw¯^]daVW m{W�\KcuUÓaVW �wS|au�h]`\^�cVt^W!W�G¢W�pÅc�k|j�kKzMW�aVS|cb]`k%\JU9UX¯Jput.S%U��òãw¯^]dc��hS|\J��� p �dkwUXW��dµÕ�tJWTjlk%aVm{W a.k%\^WÆ�dkK�KU[k&GâS²¯JUbW a�fscbt^W®��SncXcVW a�k%\^W�^W �`W*cbW�U{S|\¸k%z¢W \È�^SncuS|m�S|abc�µÓRTk%aVW kn_%W�a�f�]dj»SƯJUbW aãw¯^]dcVU�f�S|�`��t^]�U²�^SncuS|m�S|abcVUÆ�s]d�`��º¢WÈ�^W �`W*cbW��õ­ÆW�^]`UbzMW�\JUbWÄjlkKabm�S%�d]�UX]`\^�ècbt^W�UXW¹aVW�ãw¯^]`abW�m³W�\wcVU¸¯JUb]d\^�cVaVS%\JUb]àcV]dkK\Ôp*k%\MUecVaVS%]d\wcVU�µ ¶!�KS|]`\�f.cbt^W½m�S|]`\ÔaV¯^�dW]`\HÀ�Á+¶!},°¥¶�ohR ]`Urp k%\JUb]�UecVW \wc��s]dcbt®cVt^W�UbW�abW�ãw¯^]daVW*°m{W�\KcuU fPcVkPkJµ

æ^µ�á�]`\JS|�`�`Y%fwk%z¢W auSncb]`k%\MU�k%\�S&�^SncuS|m�S|abc9�hW�zMW�\J�[kK\{cbt^W�JSncVSyUXW��dW�pÅcVW��rkK\rcVt^W�_w]�Ub¯JS|�Pz^aVW�UbW \wcVS|cb]`k%\rk%j^cbtJW��^]à°S%�dkK�%¯^W9k%º ß W�pÅc,p*kK\wcbW \wc�fEcbt^WsUbW �`W�pÅcVW��3k%z¢W auSncV]dkK\3S|\M�jl¯JaXcVt^W a�]d\Jz^¯hc»cbtJS|c�tMS%U!cbk�º¢W{abW�ãw¯^W�UXcbW���jlabkKm#cbt^W¯MUXW�a�µ�Õ�t^]�Us]�Us�stJSncscVt^W�m�S|]`\.aV¯^�`W�]d\ÙÀ�Á¼¶!}�°i¶yo^RW Ýhz^abW�UbUbW�U�µ 60kn��W _%W�a�f¼cbtJW�m�S ß kKarzJS|abc3p k%\Jp W aV\^]d\J�cVt^W�W*ÝhW�p ¯hcb]`k%\�k|j�cVt^W�UXW��dW�pÅcVW��[kKzMW�aVS|cb]`k%\.]`U��`W*j c�jlk%aaVW*ÉM\^W m{W \wc�µ

~9W�UX]��hW�U.p k%\JUb]`�^W aV]d\^�Hcbt^W²p*kK\JUb]`UXcbW�\Jp*YÈk|j�cVt^W®m{S%]d\aV¯^�`W³]`\ÓÀ�Á+¶y}�°i¶yohR �9W{tJSE_KW3aVW�ãw¯^]`aVW m{W \wcVU»aVW �wS|au�h]`\^�cVt^W,�^SncuSsp*kK\KcVW \wc�k|jPcVt^W��^S|cVS|m�S%aXcuU f cbt^W,�^S|cVS���S|aVW t^kK¯JUbWSKUTUX¯MputâS|\J�½cVt^WÓ¯^\M�hW aV�dYP]`\^�;kKzMW�aVS|cb]`k%\JS%�&�^SncuS|ºJSKUXW�U µÕ�t^WrputJkKUbW \�ab¯^�`W�Usjlk%a0º^¯J]d���h]`\^���^S|cVS|m�S%aXcuU�abW�\J�hW a�cVt^W ]`aaVW�S%�d]�UbS|cb]`k%\[SKU9_P]`W �0U�kn_%W�a�cVt^W��^SncuS&��S|aVW tJk%¯JUbW0W*Ýhz^�`]�p*]dc�µgi\3j¾S%p*c�f%��W�tJSE_%WsS�k%\JW*°Acbk|°¥k%\JW�p k%aVabW�UXz¢k%\J�^W \Jp W�º¢W*ce��W W \_P]`W �;p*aVW�S|cb]`k%\�aV¯^�`W�U9]d\�xs­È°¥¶�ohR�S%\J��kKzMW�\h°AkKzMW�aVS|cb]`k%\JU]`\.À�Á+¶y}�°i¶yohR²µwoP]dm{]`�`S%ab�`Y%f%cbt^W�abW!]`U9S»k%\^W °�cVk|°¥k%\^Wsp*kKabaVW*°UbzMkK\J�hW�\Jp*W�º¢W*ce��W W�\.cVt^WrW ÝwcVaVSKpÅcV]dkK\�aV¯^�`W�Us]`\Txs­È°i¶yohRS%\J�[cVt^W�W*ÝPcVaVSKpÅcb]`k%\�aV¯^�dW�U�]d\�x�~�°i¶yo^R²µ

60kn��W _%W�a�f�]dj&�h¯^aV]d\^�²aVW*ÉM\^W m{W \wc[cVt^WÆ�JSncVS%ºJS%UbW�m�Sn°put^]`\^W��s]`�d�9ºMW.abW�z^��S%p*W��ÙºPY·UXW�_%W�aVS%��t^W*cVW aVk%�%W�\^W kK¯JU»m�Sn°put^]`\^W�UrcVt^W.W ÝPcbauS%pÅcV]dkK\HaV¯^�dW.]d\¸xs­È°i¶yohR �s]d�`��ºMW�p*kKm³Wm{k%aVWrp*kKm{z^�d]�p S|cbW��õ�gi\�zJS|abcb]�p*¯^��S|a�f^]dcy�s]`�d�¼ºMW&\^W�p W�UVUbS%abYcVk[p S|�`��m{k%aVW»cbtMS|\�k%\JW�W*ÝPcbauS%p*cb]`k%\�ab¯J�dW�]`\�cbt^W3�h] G�W aVW \wcm{kh�h¯^�`W�U�k%j�x�~9°¥¶�ohR²µ

� L ,M Í �[ Í ©�¨Õ�t^W&�%W \JW auS|�+�hW�_%W��dkKz^m{W \wc0m{W*cbtJkP�T�s]àcVtÙ¶yohRÙU!]�U!p W \h°cVW aVW��ÙS%abkK¯^\J�Tcbt^W{]��hW�S�k|j�UecVW zP�s]�UXW³abW ÉJ\^W�m³W�\wc�µ{Õ�tw¯MU fcVt^W!UbzMW�p*]dÉMp S|cb]`k%\�k|j¢cbtJWy�^S|cVS»��S|aVW t^kK¯JUXW��KabkK¯^\J�³m{kP�^W �]`\écbt^W×z^aVW _P]`k%¯JU²UbW�p*cb]`k%\é]`UHk%\^�`YâcVt^W;UecuS|abcb]`\^�¹zMkK]d\wcjlkKa²cbt^]�UHzJabkhp*W�UbU�µ Ày¯^aH�KkKS|��]`UHcbkâz^aVkn_P]`�^WÈSèp*k%m³°z^�`W*cVW³UbW*c�k|j9UXcVS%\J�^S%aV��aVW*ÉJ\JW m{W \wc»ab¯^�`W�U!jlk%a»�^S|cVS[��S|aVW*°t^kK¯JUbW·S%\J�èÀ�Á+¶y} �hW�Ub]d�K\�UX]`m{]d��S|a�cVkÈcbt^WÓabW ÉJ\^W m{W�\KcaV¯^�`W�U0]`\@¿Aohput^W��9W.��Ú%Úwæ%ÂsS%\J��cVt^W3aV¯^�`W�Uy]d\¸¿�ohputJW ��W3S|\M�Õ�tJS%�dtJW ]`m ��ÚKÚ��wÂ*µ

qsk%¯^�Kt^�`Y�Ubz¢W�S|´P]`\^��UX¯JputÙabW ÉJ\^W m{W�\KcuU»p S|\ƺMW�p �`SKUbUb]à°ÉJW���]`\wcbk{cVt^abW�W�p*��S%UVUXW�U �

� Õ�tJW»ÉJaVUXcyp �`SKUbU�k%j�aVW*ÉM\^W m{W \wc0aV¯^�`W�U0�hW�S|��Us�s]dcbt�W*ÝP°cVW \JUb]`k%\JU!k|j�S�Ubz¢W�p*]dÉMp�Sncb]`k%\+fM]Aµ WKµ0jl¯^abcbtJW ayjl¯^\JpÅcV]dkK\JUS%\J�½ab¯J�dW�UTS|aVWHS%�^�^W��¹]`\�k%au�hW a�cVkÇS%put^]`W _KW²p*k%m³°zJ�dW cbW \JW�UVUy]`\Æcbt^W�UbW \JUbW&cVtJSncrS%�d��aVW�ãw¯^]`abW�m{W \wcVUy�s]d�`�º¢W{p S|z^cb¯^aVW��õ»gi\Ùcbt^W�p*kK\wcbW*ÝPc�k|j9�^S|cVS.��S%abW�t^k%¯MUXW�US%\J�HÀ�Á+¶y}½cbt^]�U&m�S%]d\^�`YÙm{W�S|\JUrcbkTS%�J�®jl¯^\JpÅcV]dkK\JUcVk.À�Á+¶y}�°i¶yohR²fh�stJ]`put�aVW z^aVW�UbW \wc0S%�^�^]àcV]dkK\JS|�+�JSncVSm�S%aXcuU f,S%\J�²cVkÆS%�J�HaV¯^�dW�UrcVk²À�Á¼¶!},°¥¶�ohR²f��st^]�putaVW zJabW�UXW�\Kc!SK�^�h]dcb]`k%\JS%��À�Á¼¶!}Èjl¯J\JpÅcV]dkK\JS|�`]àceYKµyÕ�t^W�UXWaVW*ÉM\^W m{W \wcuUsS|aVW�S%�dm{kKUXc0UecVaVS%]d�KtwcXjlk%aV��S|au�õ

� Õ�tJW�UXW�p*kK\J�²p*��S%UVU�k|jsaVW*ÉJ\JW m{W \wc&aV¯^�`W�U&�^W�S|��Ur�s]dcbt�^W*cVS%]d�`]�UbS|cb]`k%\�µ�Õ�tJSncy]`U�fJ��Wr�s]`�d��S%�^���hW cVS%]d��U�cbk[cbt^WaV¯^�`W�U�S%U�Ub¯Jput�µ Õ�tJ]`U�m�SEY×]`\w_Kk%�`_%W®�hW*ÉJ\J]d\^�¸\^W��aV¯^�`W�U,cbtJS|c�S|aVW!p�S|�`�dW���]d\[cbt^W�W*Ýh]�UecV]d\^�&ab¯^�`W�U�µ�g¥c9m�SEYS%�`UbkH�`W�SK�¸cbk@SÓ�dW�UbU��hW�p*��S|auSncb]`_%WTUXcbaV¯Jp*cb¯^aVWÙk%j�cbt^WUbz¢W�p*]dÉMp�Sncb]`k%\+µ

� Õ�tJW�cbt^]`aV��S%\J�{z^aVk%ºJS%º^�`Y&m{kKUXc��h] ��p ¯^�dc�p*��S%UVU�k%j¢aVW*°ÉM\^W m{W \wcuU��^W�S|��U¼�s]àcVt&aVW�UXcbaV¯JpÅcV¯^ab]`\^�Mµ¼Õ�t^]�U+]`\Jp �d¯J�^W�UcVt^W»abW�UecVab¯MpÅcb¯Jab]`\^�³k|j�p k%\wcbaVk%�`�`W���jl¯J\JpÅcV]dkK\JU fPcVt^W�W*ÝP°cVW \JUb]`k%\Tk%j�m{kP�^¯^�`S%ab]dceY�ºwY×Öbk%¯hcuUXkK¯^aup*]`\^�KØ{zJS%aXcuU0k%jS%\[¶yohR�]d\wcVk&Sr\^W��;¶yohRHf%cVt^Wy�h]�UXcbaV]dº^¯^cb]`k%\[k%jÃcbt^W�JSncVS���S|aVW t^kK¯JUbW%f|S|\M�&cVt^W!UbW�ãw¯^W�\KcV]`S%�d]�UVSncb]`k%\³k|j�aV¯^�dW

Page 9: Data mart - CRPITcrpit.com/confpapers/CRPITV31Zhao.pdf · 5 >.¦ ¨: ^ _ < =?> >?> = `\a ^ 6 : ` +: ¿ ->

�hW*ÉM\^]àcV]dkK\JU�µÄgi\ÈcVt^WÙp*kK\wcbW*ÝPc[k%j»�^S|cVS·��S|aVW t^kK¯JUbW�US|\J��À�Á+¶y}#�9W®m�SEY;abW�z^��S%p*W·xs­È°i¶yohR ºPYÇUbW _w°W auS|��¶yohRÙU�]d\.k%au�hW a9cbk{S%put^]`W _KWy�h]�UXcbaV]dº^¯^cb]`k%\�µ,oP]`m³°]d��S|aV�`Y%f��9W³m�SEY�z^abkn_P]��hW3S�zJS|abcb]�p*¯J�`S%a»À�Á+¶y}Ķ�ohRjlk%a�W�SKput�¯JUXW�a!kKa!UXW�zJS|auSncVW&¶yo^RTU0jlkKa0cVt^W3�h]HG�W aVW \wc�^SncuS³m{S%aXcuU µ

á^kKa9]`\JUXcVS%\Jp*WKfK]`\[k%¯Ja��%aVkhp*W�abY³UecVk%aVW0W*Ý^S|m{z^�`WySKUbUb¯^m{WcbtJS|c!S|\JS%�dYwcb]�p S%�+À�Á+¶!}Ójl¯^\Jp*cb]`k%\JU�kK\�cVt^W»�dW�_%W��Ãk|j�Ubt^kKzJUS|aVW�kK\^�`Y[W*ÝhW�p ¯hcbW����`khp S%�d�`Y%fh�st^W�abW�S%U�S|\MS|�`YPUb]�U9k%j�aVW �K]dkK\JU]`U��hkK\^W9]`\&aVW �K]dkK\JS|�wt^W�S%�P°iãw¯JS|abcbW�aVU�µÃgi\rcVt^]`U�p�S%UbW,cVt^W�UXcVS%aUbput^W�m�S�]d\®á�]d�K¯^abW C[��k%¯^����ºMW³aVW z^��S%p W���ºPY�S�\^W �âUXcVS%aUbput^W�m�S.�s]dcbtJk%¯hc³oht^k%z � S%\J�ÙaVW��^¯Jp*W��®S%ab]dceY�jlkKar},¯^ab°putJS%UbWh� aVW.<JW�pÅcb]`\^��S[t^kKab] E kK\wcVS|�¼jlauS|�%m{W�\KcuSncV]dkK\Ó¿ DÀ E�UX¯S|\J� >,S|���h¯^aV]`W�E{��ÚKÚ%ÚKÂ9S|�`k%\J�&cVt^Wr�h]HG¢W�abW�\Kc0_nS%�d¯^W�U�k|j�UX]��õ

Õ�t^W�p*k%aVaVW�UbzMkK\J�h]`\^��ab¯J�dW�U&]`\Óp*kKabaVW�Ubz¢k%\J�h]`\^�ÆÀ�Á¼¶!}¶yohRTU9��k%¯^����p*kK\JUXW�ãw¯^W \wcb�`Y&º¢W0aVW�UXcbaV]`p*cbW��³cbk�cVt^kKUbW0�s]dcbtSÓÉJÝPW��;�`khp SncV]dkK\Ä�h]`m{W \JUb]`k%\�µ#á^k%a�]`\JUXcVS|\Mp*W%fycbtJW²ab¯^�`WW*ÝPcbauS%p*c z^¯^auputJS%UbW»]d\�x�~9°¥¶�ohR��9kK¯^�`��putJS%\^�%WycbkM�

W ÝPcbauS%pÅc z^¯^auputJS%UbWK¿/��= � Â7�0h�"-^��5�5>auf +f6#Åf� ��f���@�B4w�� ` > ~�¯^YhU�¿aY=��= ` =�#XÂ���;��� �% =@r�> v9¯JUXcbkKm³W�a�¿EaY=% =#rh ������ ��m= � > }�S|abc�¿� =�� = � Â��� ��� � >`¿¥À G¢W�an¿� = �-=� � =���= � Â���;� � � r,#��P¿#X � � Â

�h��5w�"4�� �3��� � ¿ ` �%~9¯JYPU�¿aY=��= ` =�#XÂ���;�»ÂÅfV9� ��� ��f��������¿�7� � Â��¤ � ¿EaY=� =�#\=�� = V�=��rÂ�� �¹�

�%¤^�P�P�v9k%\MUXW�ãK¯JW \wcb�`Y%f®cbtJW±aV¯^�`Wèp*aVW�S|cbW _P]`W � UVS|�`W�U;��k%¯J�`�

putJS|\^�KW�cbkJ�p*aVW�S|cbW _P]`W � UVS|�`W�U�¿ � Âs�0h�"-^�65,5 � = ` =��

�@�B4w�� �>?>�>?> Õ�]dm{WK¿W>?>�>?= � = ` =��m=?>?>�>bÂ������h� 5K�"4�� ����� � ¿ ` �+� ��J=��=#\= ����=� �5>

}�¯^auputJS%UbW|¿��J= =�#\= ` �5= ���o=� �`Â���;���m{kK\KcVt¼¿E#XÂ|� ���ãw¯JS%aXcVW a�¿#X � `��YKW�S%a�¿#X ���^ÂÅf

V9�3��� � ¿/�G�¼� �J= =#\= ` ��= ��>}�¯^auputJS%UbW|¿��J= =�#\= ` �5= ���o=� �`Â���;���m{kK\KcVt¼¿E#XÂ|� ���ãw¯JS%aXcVW a�¿#X � `��YKW�S%a�¿#X ���^Â

��¤ � ¿ � = ` =��m= � = V,Â�� �¹�á^¯JaXcVt^W aVm{k%aVW%f+��W{�9kK¯^���ÙkKºhcVS%]d\²S|\Jk|cbtJW a»jlauS|�%m{W�\Kc�f

]d\��st^]�putToPt^k%z�]`\�á�]`�%¯^aVW7C³�9kK¯^�`�.tJSE_KWycVk{ºMW�aVW z^��S%p W��ºwY·qsW��%]`k%\²�s]dcbtÓS|cXcbaV]`º^¯hcbW�UraVW �K]dkK\·S%\J�²UXcVSncVW%µÆv9kK\JUXW °ãK¯JW \wcb�`Y%fhS|�`�¢_w]`W �×p abW�Sncb]`k%\[S%\J�.À�Á¼¶!}²aV¯^�`W�U9]d\�cVt^W»p*k%ab°abW�UXz¢k%\J�^]d\^�»xs­È°i¶yohR#S|\M�{À�Á¼¶!}�°i¶yo^RÔ��k%¯^���rº¢WsUX]`m³°z^�d]dÉJW���ºwY�]d�K\^k%aV]d\J�3cVt^W&oPt^kKz��h]dm{W�\JUX]`k%\+µ,­ÆW�kKm{]àcscVt^W�hW*cuS|]`�`UstJW aVW%µ

� Î Í ¬-�¾Ð�¨�Ñ�Î Ígi\·cbt^]�UrzJS%zMW�ar��W�z^abW�UXW�\wcbW��ÆÉJauUXcrº^]àcuU�k|jskK¯^a��9kKab´Ùk%\cbt^W{¯JUbW3k%j9¶0ºMUecVaVSKpÅc»oPcVSncVW�RTS%put^]`\^W�U3¿�¶yohRTUuÂ!jlk%a»x!]�UX°cbaV]dº^¯^cbW��×x�SncuS®­®S%abW�t^k%¯JUbW�x!W�UX]`�%\+µ;­ÆWTUbt^kn��W��ÓcbtJS|ccbt^W��KW \^W�aVS%�¢]��hW�S3k%j��JSncVS³��S|aVW t^kK¯JUbW�U9]`Us]`\.j¾S%pÅc!S{UbW zJS|°aVS|cb]`k%\�k|j�]d\^zJ¯hc0jlaVk%mÔkKzMW�aVS|cb]`k%\JS%���^SncuS|ºJSKUXW�U�jlaVk%m k%¯hcb°z^¯hcÙcVk;�h]�S|�`k%�%¯JW*°¥ºJS%UbW��Äk%\h°¥�`]d\^WHS%\JS|�`Ywcb]�p S%�rz^aVkPp W�UVUX]`\^�¿AÀ�Á+¶y}9Â*µ,Õ�t^]`U�UbW zMS|auSncb]`k%\@S|�`�dkn�0U&cbt^W�ºJSKUX]�p.m³kh�hW��sk|jS3�^S|cVS3��S%abW�t^k%¯MUXW!cbk³ºMW�UbzMW�p*]dÉJW��.ºPY{cbt^aVW W�]d\wcVW aV�dW�SE_%W��t^]d�Kth°¥�dW�_%W �y¶yohRTU�µÇáJ¯^aXcVt^W a.�hW _KW �`k%z^m{W \wc[k%jycVt^WÙ�^S|cVS��S%abW�t^k%¯JUbW»S|\J��cbt^W&À�Á¼¶!}¸]d\wcVW abj¾S%p*W�U�p S|\�º¢W�ºJS%UbW���k%\UecVW zh°¥�s]`UbW!aVW*ÉM\^W m{W \wc�k|j+Ub¯Jput�STÖb�%aVk%¯^\M�{m³kh�hW��`Ø3¶yohRHµ

Õ�t^W�S|zJz^abkwS%putTp kn_%W auU0aVW�ãw¯^]`aVW m{W \wcVU�Snc�S._%W aVY�t^]`�%t�dW�_%W �hk%j�S%ºJUXcbauS%pÅcV]dkK\�fnº^¯hc9\^W _KW abcbt^W��dW�UbU�z^aVkn_P]`�hW�U¼cbt^WsaV]d�%°k%aVk%¯JU�m�SncVt^W m�SncV]`p�S|�^UbW m�S|\wcV]`p�U�k|jöyohRTU�jlaVk%mècbt^W�_KW aVY

º¢W �K]d\^\J]d\^��k%j�UXYhUXcbW m�U,�^W _%W��dkKz^m{W \wc�µ�­®W!�hW m{kK\JUecVaVS|cbW��cVtJSnc0S|�`aVW�S%�^Y³kK\[cVt^W��dW�_%W��¢k%j�S%\.¶yo^R��KabkK¯^\J�[m{kh�hW��Ã]àc]�U�zMkwUbUb]`º^�dWycbk�aVW�SKUXkK\�S|º¢k%¯^c�aVW�ãw¯^]`aVW m{W \wcVU�UVSncV]`UXj¾S%p*cb]`k%\�fcVt^k%¯^�Kt·cbt^W.�%W�\^W auS|��¶�ohR2z^tJ]d�`kKUbk%z^tPY � ÉJauUXc3�hW�Ub]`�%\�fcVt^W \×S|\MS|�`YPUbW�S|\J�¸_KW aV]àjlY[� �hkPW�U�\Jk|c[aVW�ãw¯^]`abW�jlk%aVm�S|�_KW aV]àÉMp�SncV]dkK\�S|cscbt^]�UyUXcVS%�%WKµ�­®W&S|aV�%¯^W��[cVtJSncy]àc�]`Usz¢kKUVUb]à°º^�`Wycbk³_%W aV]djlY{Ubk%m{W�ãK¯MS|�`]àceY[p ab]dcbW�ab]�S&S%�daVW�SK�hY³S|c9cVt^W»_%W�abYº¢W �K]d\^\J]d\^�{k%j�UbYhUecVW m �hW�_%W��dkKz^m{W \wc�µ

á^¯^abcbt^W�abm{kKabWKf0cbtJW aVW®]�U�\^k×UX�s]dcVput½]`\ÇcVW aVm³]`\^kK�dkK�%Y%µÕ�t^]�U9�s]d�`��W�S%UbWscVt^Wy_nS%�d]��^SncV]dkK\[k|j¼abW�ãK¯J]daVW m{W \wcuU fwS|\J��W \h°S%º^�dW�W _KW \�jlk%aVm{S%��_%W aV]dÉMp S|cb]`k%\[�st^W�\[cVt^]`U�º¢W�p k%m{W�U�Ub¯^]dcX°S%º^�dWKµrgi\Æcbt^]�U»zJS|z¢W a»��W�p*k%¯J�`�Ùk%\^�`YTUX´KW*cuputTcbtJW³]��hW�S�k%j¶�ohR abW ÉJ\^W�m³W�\wc[]d\;�^S|cVS·��S|aVW t^kK¯JUbW�S%\J�ÇÀ�Á+¶y} �hW*°Ub]d�K\�µ0á^kKayS{jl¯J�d���hW�_%W �`k%zJm³W�\wc!m{W*cbtJkP�T�9Wr�s]`�`�¼tJSE_KW�cbkSK�^�.S³Ubk%z^t^]�UXcb]�p SncVW���p*kK�d�`W�p*cb]`k%\�k%j�UXcVS%\J�^S|au�.abW ÉJ\^W m{W�\KcaV¯^�`W�U�¿¾SKU{]d\�¿�o^put^W ��W·��Ú%Úwæ%Ârjlk%a[�^S|cVS%ºJS%UbW�S%z^z^�`]`p�SncV]dkK\UbYhUecVW m�UVÂ*µ�áJ¯^abcbt^W�abm{k%aVW%fw��W!�s]`�d��W*Ýhz^�`k%aVWscVt^W!jl¯J�d��auS|\^�KWk%j�À�Á¼¶!}Èjl¯J\JpÅcV]dkK\JU0cVtJSnc»m�SEY.º¢W&zJabW�UXW�\Kcy]d\ÙUb¯JputTUbYhUe°cVW m�U µ

¶0\^k%cbt^W�a;z^aVk%º^�`W m �`W*j cÄk%z¢W \#jlk%aÈjl¯hcV¯^aVWâ�9kKab´ ]`USK�^�h]`\^�HS%�P°¥t^khp�p*aVW�S|cb]`k%\Èk|j��^SncuS·m�S|abcVU{cVk²cbt^WÆUXz¢W�p ]à°ÉMp�SncV]dkK\�µ®Õ�tJ]`U3�9kK¯^���²m{W�S|\Hcbk®]d\Jp �d¯M�hW�Ubk%m{W�jlkKabm)k%j�`]d\J�%¯^]�UecV]`p0abW�<JW�p*cb]`k%\[S|�`�`kn�s]d\^�»cVW*ÝPcb¯MS|�J]`\^z^¯^c�cbk3ºMWyS|\JS%�à°YhUbW���S|\J��cVaVS%\JUXjlW aVabW���]`\wcbk[m�S%p abkwU�cbtMSnc!aVW�S%�d]�UXW»jl¯JaXcVt^W aÀ�Á¼¶!}Æjl¯^\Jp*cb]`k%\JS%�d]dceY%µ�g¥c,m�SEYr�9W��d�hº¢W�cbtJW0p S%UbW�cbtJS|c�cbt^]�US%m&º^]dcb]`k%¯JU+W*ÝPcbW�\JUb]dkK\r�s]d�`�PabW�ãw¯^]daVW9S%�`Ubk0W ÝwcVW \JUb]`k%\JU+cbk!cbt^W¶�ohR�m³W cbt^kh��]dcVUbW �djeµ

L ,N�wªJ Í ¬-w¨������������ ����� ����������� ����� ��!#" $��������#��%& $'� RTkP�^W �`]d\^��m3¯^�dcb]��h]dm{W�\JUX]`k%\MS|�.�JSncVS%ºJS%UbW%µågi\( !@"��*),+iF�n�F.- %� �ku%(,Y,?!\ku%� 0/ "�%GW/,?!#,?%(�Y,2143sku!\) ku%� ��D4FJ))¿e��ÚKÚA@%ÂÅfPz^z�µM�&CK�65h�J�AC^µ

798: ����;<�= ?>@�� ��!#"A$B� 8���DCE F����0 G jYno!#F-�/n 1 n�F�n�, 3 F���YD ku%m,\jŵ�oPz^aV]d\^�KW ab°�>�W�ab��S|�MfÃ~9W�ab�`]`\ 60W�]`�^W �`ºMW�ab���0W��G,kKab´�fJ��B6B&CJµ

7 8: ����;<�= �>@�� ,$B� 8���DCE ����� @��!#"H$DIBJ�KL%M"N �O��QP F���FF�%('�nVDM, P FJ�JFSR ku!\no$4FJ. 3 F��YD ku%(,*TU+ ,EO %4kunok�"J%<1VR�,?!\�k O �@F�n5k�"�% F�%('WR�FJ. k�'-FJnok�"J%Mµ9oPz^aV]d\J�%W ab°4>�W aV�`S%�JfP~9W�ab�`]`\6!W ]��hW �`ºMW�ab�[�!W �XG,k%aV´¢fJ�&B&BJ�%µ

>?!���YZ�D� 8: K@ \[��� ^]J�����C����_�����DJ�`� ^$'�� '��!�"baN%M!��'Yc 7 � ¶Ät^k%�`]�UecV]`p�S|z^zJabkwS%put{cbk3cbtJW�W�_nS|�`¯JSncV]dkK\[k|j¼�JSncVS��S|aVW t^kK¯JUbW0m�S|]`\KcVW \JS%\Jp*W!zMkK�d]�p*]`W�U�µ+Õ¼W�put�µhqsW�z�µ�6�ow°gex0¶0°¥Õsqs°4B6Bn° B&B^�Kf�Z!\^]`_%W auUb]àceY®k|j�oh´ DkK_h�hW%f,oP��W��hW�\�f�&B&B&BJµ

�����D;d_�%eI�J^ UO��� �$ : � : C����= Uf9�� ?��!#"hgi������DI�;# @]@�áJk%aVm{S%�d] E ]`\^���^SncuS|ºJSKUXW3abW�p*kn_KW aVY%µ P "J$&!\%(F�. "XWkj�%�ku��J,/!Yj?F�.N/|"J) �($&n�,/! 1 �/k�,?%(�Y,@l|fM�T¿X��ÚKÚA@|Â*f CK��Bm5 C��6B^µ

��`\YnYn;<!�Y� �op�� @��!#"0aN��C'YnJ#KL��!D��!^ Va� ¶�jlk%¯^\M�^Sn°cV]dkK\ÇjlkKa�m3¯^�dcb]��h]dm{W�\JUX]`k%\MS|���^SncuS|ºJSKUXW�U µ gi\q( !#"H�n)r�r %('4RDs#+F3h/|"J%GW/,?!#,?%(�Y,t1 3 $&) G FJk�ue3�"J) G FJIwv61�x\%��'�k�FÙ¿X��Ú%ÚKÛKÂ*µ

y !#K : !^ 'gH� 3s$&ku.�'Jku% nVDM,U+ FJn�FWz�FJ!#,YDM"�$ j?,*µ0­×]`�`W Y|{oPkK\JU�f^�0W �.G,k%aV´�fÃ��ÚKÚ%Û^µ

O}�DI :�~ Y : !^ y �� �]J#�D%eYt�D;<�#Y : !^ �op�� �O : !�YnY : !^ ��@�� ��!�" 8� _�;<���#�#���D"N E�9��� Ge� ,Y�?n5�W"�!\k�,/%�n�,Y' 1 "WYn�� F�!#,- % �ku%m,Y,/!\ku% �T 0 j�j/,?�2/|F�j?,�+�!\ku��,?% 0 ���m!#"�F-�@Dhµ¶y�^�h]�UXkK\h°A­®W�Ub�`W Y%f+��Ú%Úw�hµ

� ;<"���"N ��E�� ���!#"�o��;����%eY� �>�� xyW�S%�d]`\^���s]dcbtUbW m�S|\wcV]`p�t^W cbW aVk%�KW \^W�]àceY �^¯^ab]`\^�2�^S|cVS ]d\wcVW �%auSn°cV]dkK\�µ²gi\h/|"�%(�Y,��mn5$4F�. 3 "H'�,?. ku% ��k-=�|� ���â¿e��Ú%ÚKÚKÂÅf�Mµs¶0´%kK´nS^f!R²µs~�k%¯ E W �Kt^k%¯Jº�f0gŵ!v9k%m3Yw\^°A­·Sncbcb]�S|¯�fS%\J� �!µÈR½çW*cuS|]�U fé���^U�µdfé_%kK��µ½�@%��I4k|j�s#��/ 1 foPzJab]`\^�%W�aX°4>�W aV��S|�Jfwz^z�µ CK�%æ65 C6C%Ú^µ

� %MK ~ ����� ������ DM,�+ FJn�F�z F�!#,YDM"J$ j?, � "H"J. �JkunAµ��Kk%tJ\­×]`�dW�Y�{éoPk%\JU�f���Ú%Ú%ÛJµ

Page 10: Data mart - CRPITcrpit.com/confpapers/CRPITV31Zhao.pdf · 5 >.¦ ¨: ^ _ < =?> >?> = `\a ^ 6 : ` +: ¿ ->

aN;d��;<�D;<!��< O��� $DIBJ�;d��;# � �������� ��!#"��UJD�����J#;<%MK@ 7 � RTkP�^W �`�d]`\^���^S|cVS���S%abW�t^k%¯JUbW�U�S%\J�À�Á+¶y} S%z^z^�`]`p�Sncb]`k%\MUä¯JUX]`\^� �h]�S|�`k%�K¯^W kKº ß W�p*cVU�µgi\ /|"J%(�Y,��(no$4FJ. 3 "�'-,/.lku%� � -=�|� ��� ¿X��ÚKÚ%ÚKÂ*f�Jµs¶!´%k%´nSJf!R²µs~�k%¯FE�W �%tJk%¯^º�f!gŵ0v9kKm&YP\h°¥­®S|cXcV]`S%¯�fS|\J� �0µÈR½çW cVS|]�U�fé�9�^U µ`fé_%k%�Aµ½�@|�&IÞk|j�s#�,/ 1 foPz^aV]d\J�%W ab°4>�W aV�`S%�Jfwz^z�µ CwæJ�m5 C%Û6I^µ

8� �cYn�^ �,�� ?��!#"�����"����D%M;��< �@� ( !\ku%(�?k �(. ,\j "XWV+�k j\�n5!\k G $&n�,@'�+iF�n�F G FJj?, 1 I�j\n�,?)�jŵ�},aVW \wcV]`p W*°�6!S|�`�Af¢��Ú%ÚKÚ^µ

��D%M! �} ��9�� ���!#"��UJD���J#;<%MK� 7 � ÀyzMW�aVS|cb]`k%\JS%��UbW m�S%\h°cb]�p U�k|j&cbauS|\JUVS%p*cb]`k%\JU�µ±gi\�+iF�n�F G F�j?, � ,Y�YD %m"J.�"@ �k�,/jr���� l�T���"J$&!\n�,@,?%4nVD 0 $ jYno!#F�.�F�j\k�FJ%,+ FJn�F G F�j?,@/|"J%GW/,?!\�,/%m�Y,²¿��&B&B&CwÂÅf�Ü{µ °ix&µ,ohput^W��9W�S|\M���3µ9�¢t^k%¯+f9���JU µ`f_%kK��µ��@³k%j�/|"J%�W/,/!#,?%(�Y,/jiku%���,\j?,YFJ!#�YD�FJ%m'�( !#F��?nok��@,"XWLx/%GW/"�!\) F�n5k�"�% � ,@�YD %m"J.�"@ �InfMz^z+µ���ÛKÚ65¢� @nÚJµ

�?��K ~ ������J^ |O��� �O<�#I :�~ Y : !N y �� ���!#" 7 :�: I�J^ ��9�� DM,�j�%�k O ,Y' 3 "�'-,/.lku%� ,s F�%� �$4F? �,��,EW/,?!#,?%(�Y, 3 F�%4�$4FJ. µ,¶y�^�h]�UXkK\h°¥­ÆW�UX�`W YKfÃ��Ú%ÚKÚ^µ

$�I�J#;d��;# � �����9� ohzMW�p*]dÉMp S|cb]`k%\ÇS%\J�;�hW�_%W �`k%zJm³W�\wc�k|jp*kKabaVW�p*c�aVW ��SncV]dkK\JS|�h�^S|cVS%ºJS%UbW�z^abkK�%auS|m�U�µ^Õ+W�put�µnabW�z�µ`fv9�`S%¯JUXcbtJS%��Õ+W�put^\^]�p S|��Z!\^]`_%W auUb]àceYKf =�W aVm{S%\PY%fÃ��ÚKÚKæ^µ

$�I�J#;d��;# � ������� Z!RTÁ��0¶�m³kh�hW�ab\½�h]`\^kKUVS|¯^a���5ÇSp*aV]àcV]`p�S|��S|\JS%�dYhUb]`U·k%j�cVt^WǯJ\^]àÉMW�� m{kh�hW �`�`]d\^�è�`S%\h°�%¯JS%�%WKµ gi\ x\%�W/"J!\)+FJnok�"J% 3 "H'�,?.u. ku%� F�%('���%m"m� . �,Y'? �, 3�F�j?,/j��Lx xÅf�6rµ-�KSKS|´P´%kK�`SJfH6&µ%Ü�S|\^�wS%UVUbS%�dkMf�S%\J��0µ Ü�SE��S|�K¯Jput^]Af ���JU µ`f�áJabkK\wcb]`W auUÃ]d\r¶!aXcV]àÉ¢p*]�S|�|gi\wcbW��d�`]d°�%W�\Jp*W�S|\M�.¶!z^z^�`]`p�Sncb]`k%\MU µhgbÀ»o.},aVW�UVU fP¶0m�UXcbW�aV�^S%m�f��B6B^�%fPz^z+µ���Iwæ*5h�&BK�^µ

$�I�J#;d��;# � �������� ��!�"�$�I�J#;d��;# 7 � >!]`W � p*W�\h°cbW�abW���p*k%\Mp*W z^cb¯JS%�+m{kh�hW �`�d]`\^�V5�S|\�k%º ß W�pÅcyk%aV]dW�\KcVW��S|z^zJabkwS%put�µ gi\ /|"J%m�Y,��mn5$4F�. 3 "H'�,?. ku%� q�p-^� � ���¿e��Ú%Ú%ÛwÂÅfP~�µPÕ�tMS|�`t^W ]`m�fP�9�õ`fPÁ¼��v�oT�%��æA@PfPoPz^aV]d\^�KW a�fz^z�µ Cwæ6@*5 CA@h�%µ

$�I�J#;d��;# � �������� W��!#"�$�I�J#;d��;# 7 � gi\wcbW��%auSncb]`\^��^SncuS|ºJSKUXWTS%\J�È�h]�S|�`k%�%¯JWT�hW�Ub]d�K\�µ ��%m"m� .�,Y'? �,9FJ%m'x\%�W/"J!\)+FJnok�"J% 1 I�j\n�,?)ij r f���¿���B6B&BwÂÅfÃ�25 CK�^µ

$�I�J#;d��;# � �������� ��!#"!�UJ#����J�;<%MK� 7 � },aV]d\Mp*]`z^�dW�Uk|j¸k%º ß W�pÅc�k%aV]dW�\wcbW����^SncuS|ºJSKUXWÊ�hW�UX]`�%\�µ gi\ x\%4�W/"J!\)+FJnok�"J% 3 "H'�,?.u. ku%� F�%('"�i%(" � . ,@'� -, 3 FJj/,/j R¼f6rµ��KSKS|´P´%kK�`SJf�6&µ�Ü�S%\^�KSKUbUVS|�`kJf¼Õ»µ�Ü»]dcVS%tJS%Ubt^]Af�S%\J�¶rµ�RâçS|aV´w¯MU f����^U�µdf�á^aVk%\wcV]dW�aVU{]`\׶0abcb]dÉMp*]�S|�sgi\wcbW��d�`]d°�%W�\Jp*W�S|\M�.¶!z^z^�`]`p�Sncb]`k%\MU µhgbÀ»o.},aVW�UVU fP¶0m�UXcbW�aV�^S%m�f��ÚKÚ��JfPz^z+µM�%�A@n5h���w�^µ

�UJD���J#;<%MK� 7 � x�SncuS|ºJSKUXWèp k%m{z¢k%\^W�\KcÄ��S%abWKµ gi\+iF�n�F G F�j?, � ,Y�@D&%("J. "# �k�,\j r���� l�T#� "�$&!\n�,Y,?%4nVD 0 $ jY�n5!@FJ.�FJjYk�F�% + FJn�F G FJj/, /|"J%�W/,/!#,?%(�Y,Þ¿A��B6B&CKÂ*f;Ü{µ °ix3µohput^W��9WÙS%\J�$�3µs�¢tJk%¯�f0�9�^U µ`f0_Kk%�Aµ!�@·k|j|/|"J%GW/,?!\�,/%m�Y,\j�ku%b� ,/j/,YF�!#�@D;FJ%m'4( !@F��?n5k��Y, "XW�x/%GW/"�!\) F�n5k�"�%� ,Y�YD %m"J.�"@ �InfMz^z�µ��'C65^�|Û^µ

�UJ#; : " : ����� : Y� %��� xyW*cbW�pÅcV]d\^�@abW��h¯^\J�JS|\Jp Y@]`\Ç�^S|cVS��S%abW�t^k%¯MUXW·W _Kk%�`¯hcb]`k%\+µ�gi\�/|"�%(�Y,��mn5$4F�. 3 "H'�,?. ku%� ��-=�|� ��� ¿X��ÚKÚ%ÚKÂ*f �Mµ.¶0´Kk%´nS^f®R²µ�~�k%¯ E W �Kt^k%¯Jº�fgŵ�v9k%m&YP\h°¥­·SncXcV]`S%¯�f S%\J� �0µ R½çW cVS%]`U�f ���JU µ`f_%kK��µw�@%��Isk%j�s#��/ 1 f|oPz^aV]d\^�KW ab°�>�W�ab��S|�Mf z^z+µC��6Bm5 CKæ&C^µ

�UJ#; : " : ����� : Y� &���� ���!#" $�;<���%eY� '�,� xyS|cVS¸��S|aVW*°t^k%¯MUXW�Ubput^W�m�S!S|\M��]d\MUecuS|\Jp W��hW�UX]`�%\+µ%gi\�/|"�%(�Y,��mn5$4F�.3 "�'-,/. ku% �W-=�|� ��(Ê¿X��Ú%Ú6IKÂ*f�_Kk%�Aµ!�Eæ�BA@Æk%j@s#�,/ 1 foPz^aV]d\J�%W ab°4>�W aV�`S%�Jfwz^z�µ CKÛ&C65 CA@|Û^µ

�UJ : K?Y : !^ U>�� � s 0 ( 1 "�. $&nok�"J%MjZT 37$&ku. 'Jku%� 3 $&. nok�'Jku�) ,?%Mj\k�"�%(FJ.'x\%GW/"�!\) F�n5k�"�% 1 I�jYn�,?)�jŵ �%kKt^\Æ­×]`�`W Yk{oPk%\MU f^�!W �.G,k%aV´¢fÃ��Ú%Ú @Pµ

gh%M" : K� ,O�� qsW�UbW�S%aVput×z^aVk%ºJ�dW�m{U�]`\Ä�^S|cVSÓ��S%abW�t^k%¯JUX°]d\J�Jµ¢gi\�( !#"��Y,Y,Y'Jku% Jj�"W7nVDM,*)MnVD�x\%4n�,?!\%(FJnok�"J%mFJ.�/ "�%4�W/,/!@,/%m�@,i"J%�x/%GW/"�!\) F�n5k�"�% FJ%m'+�i%("m� .�,Y'� -, 3 FJ%(F� -,?�) ,?%4n»¿e��Ú%Úwæ%ÂÅfh¶!v�R²µ