SQL Server BI Step by Step SSIS 1 ×¼±¸
SQL Server 2005 ºÍ2008ÌṩÁ˺ܶàеĺÍÔöÇ¿µÄÉÌÎñÖÇÄܹ¦ÄÜ,°üÀ¨ÀûÓü¯³É·þÎñ(SSIS)ÕûºÏ¶àÖÖÊý¾ÝÔ´;ÀûÓ÷ÖÎö·þÎñ(SSAS)ʹÊý¾ÝÄÚÈݸü·á¸»²¢ÇÒ½¨Á¢¸´ÔÓµÄÉÌÒµ·ÖÎö; ÒÔ¼°ÀûÓñ¨±í·þÎñ(SSRS)±à¼,¹ÜÀí,ºÍÌá½»·á¸»µÄ±¨±í. Èç¹ûÄãÏÖÔÚ»¹²»Çå³þÕâЩ¹¦ÄÜ,ÄÇô½ÓÏÂÀ´Ò»ÏµÁеĽéÉÜ»áÈÃÄã¶ÔSQL ServerÏÖÔÚµÄÉÌÎñÖÇÄÜÖ§³Ö´ó³ÔÒ»¾ª.²»¹ýÏÖÔÚ¹ØÓÚSQL ServerÉÌÎñÖÇÄÜ(SQL Server Business Intelligence - BI)µÄÖÐÎÄ×ÊÁÏÏà¶Ô½ÏÉÙ,ºÜ¶àʱ¼ä¶ÔÓÚһЩ¸´ÔÓÎÊÌâµÄÑо¿,¶¼ÐèÒªÖ±½ÓËÑË÷Ó¢ÎÄ×ÊÁÏ»òÕßÊÇÖ±½ÓÈ¥¹úÍâµÄÉçÇøÇó½Ì.´Ó±¾ÎÄ¿ªÊ¼,ÎÒ½«ÒÔÏÖÔÚÕÆÎÕµÄÏà¹Ø֪ʶΪ»ù´¡,½éÉÜSQL Server BI,Ï£ÍûºÍÕâ·½ÃæµÄÅóÓÑÒ»¹ýÑо¿ºÍÌá¸ß.
¡¡¡¡ÈÃÎÒÃÇÏÈ×öÒ»ÏÂÇ°ÆÚµÄ×¼±¸¹¤×÷,Õû¸ö°¸Àý¶¼»áÒÔAdventureWorksÊý¾Ý¿âΪ»ù´¡,Èç¹ûÄãÔÚ°²×°SQL ServerʱûÓÐÑ¡Ôñ°²×°,Ò²¿ÉÒÔµ¥¶ÀÏÂÔØ,http://www.codeplex.com/SqlServerSamples,¶øÇÒÕâÀï°üÀ¨SQL ServerµÄºÜ¶àÀý×Ó,¹¤¾ßºÍ×ÊÔ´,Èç¹ûÄãÓÐBI·½ÃæµÄ»ù´¡,½¨ÒéÖ±½Ó´ÓÉÏÃæÏÂÔØÀý×Ó½øÐÐÑо¿.
¡¡¡¡AdventureWorksÊý¾Ý¿â¼°Ê¾ÀýµÄ°²×°¿ÉÒÔ²ÎÕÕhttp://www.cnblogs.com/luman/archive/2008/08/28/1278447.html
¡¡¡¡Èç¹ûÄã¶ÔAdventureWorksÊý¾Ý¿â²¢²»ÊìϤ,ÇëÏÈͨ¹ýÒÔÏÂ×ÊÔ´½øÐÐÁ˽â:
¡¡¡¡http://technet.microsoft.com/zh-cn/library/ms124438(SQL.90).aspx¡¡¡¡SQL Server 2005¡¡AdventureWorks¡¡Êý¾Ý×Öµä
¡¡¡¡http://technet.microsoft.com/zh-cn/library/ms124438.aspx¡¡ SQL Server 2008¡¡AdventureWorks¡¡Êý¾Ý×Öµä
¡¡¡¡https://msevents.microsoft.com/CUI/Register.aspx?culture=zh-CN&EventID=1032321320&CountryCode=CN&IsRedirect=false¡¡ ½éÉÜAdventureWorks Êý¾Ý¿âµÄwebcast
¡¡¡¡ÔÚ°²×°SQL Serverʱ,ÇëÑ¡Ôñ°²×°Integration Service,Reporting Service,Analysis ServiceµÈ·þÎñ,²¢ÇÒÑ¡Öпª·¢¹¤¾ß.°²×°Íê³Éºó,¾Í¿ÉÒÔÓÃvs .net´ò¿ªBIÏîÄ¿:
¡¡¡¡SSISÏîÄ¿:
¡¡¡¡
¡¡¡¡SSASÏîÄ¿:
¡¡¡¡SSRSÏîÄ¿:
¡¡¡¡¿ÉÒÔ¿´µ½,΢ÈíÒѾ¸ø³öBIµÄÒ»ÕûÌ×½â¾ö·½°¸,¶øÇÒËûÃÇÖ®¼ä¿ÉÒÔ»¥²Ù×÷,Reporting Service¿ÉÒÔ¸ù¾ÝSSASÉú³ÉµÄ¶àάÊý¾Ý¼¯Éú³É¸´ÔÓµÄKPI±¨±í,Integration ServiceÒ²¿ÉÒÔÔÚ¿ØÖÆÁ÷Öе÷ÓÃSSAS½øÐÐÊý¾Ý·ÖÎö,ÁíÍâSql Server BI»¹Äܹ»ºÍ΢ÈíµÄÆäËü²úÆ·ÕûºÏ,±ÈÈçReporting ServiceÖ±½ÓÕûºÏµ½MOSSÖÐ,¿ÉÒÔ°²×°²å¼þ,ÔÚExcelÖÐÖ±½Ó²Ù×÷SSAS·ÖÎö³öÀ´µÄÊý¾Ý,ʹ¿Í»§¶Ë¸ü¼Ó·½±ãµÄ²Ù×÷.ÕâЩÎÒÃÇÔÚºóÃ涼»áÒ»Ò»½éÉÜ.
Ïà¹ØÎĵµ£º
´´½¨ºÍÅäÖÃASP.NET Session״̬Êý¾Ý¿â
ÔÚ»ùÓÚNLB£¨ÍøÂ縺ÔØƽºâ£©»·¾³ÏµÄASP.NET WebÓ¦ÓóÌÐò¿ª·¢£¬ÎÒÃÇÐèÒª½«Session´æ´¢ÔÚÊý¾Ý¿âÖ驶à¸öWebÓ¦ÓóÌÐòµ÷Óã¬ÒÔÏÂΪÅäÖ÷½·¨¼°×¢ÒâÊÂÏî¡£
1.´´½¨ÓÃÓÚ´æ´¢ASP.NET SessionµÄÊý¾Ý¿â£¨Ô¶³Ì¡¢±¾µØ½Ô¿É£¬Ê¹ÓÃÊý¾Ý¿âÓû§Éí·ÝÈÏÖ¤£©
ÔÚWindows\Microsoft.NET\Framework/V2.0.507 ......
¹¤¾ß£º
Sybase PowerDesigner 12.5
Microsoft SQL Server 2005
µÚÒ»²½£º¸ÅÒªÉè¼Æ
´ò¿ªPowerDesignerÈí¼þ£¬Éè¼Æ“¸ÅÄîÊý¾ÝÄ£ÐÍ”(Conceptual Data Model)£º
ͼ1
Éè¼Æ±í½á¹¹£º
ͼ2
ÔÚÉè¼ÆÊôÐÔ(×Ö¶Î)µÄʱºò£¬Èý¸ö×Öĸ(M¡¢P¡¢D)·Ö±ð±íʾ£º
M£ºÊÇ·ñΪ¿Õ;(√±íʾ²»ÔÊÐíΪ¿Õ)
P£ºÊÇ·ñ뻅 ......
#ÐÂÔöÒ»¸ö×ֶΣ¬Ä¬ÈÏֵΪ0£¬·Ç¿Õ£¬×Ô¶¯Ôö³¤£¬Ö÷¼ü
alter table tabelname add new_field_name field_type default 0 not null auto_increment ,add primary key (new_field_name);
#Ôö¼ÓÒ»¸öÐÂ×Ö¶Î
alter table tableName add new_field_name field_type;
alter table tableNam ......
×òÍí£¬µ½Î¢Èí¹Ù·½ÏÂÁËÒ»¸ö32°æ±¾µÄTrial°æ±¾¡£ÎļþÃûΪSQLFULL_x86_ENU.exe¡£Îļþ´óСΪ1.30G×óÓÒ¡£ÒòΪֻÓÐ32λһ¸ö°æ
±¾£¬±ÈSQL Server 2008ÄǸö3GµÄҪС¶àÁË¡£ºÇºÇ¡£
http://www.microsoft.com/sqlserver/2008/en/us/R2Downloads.aspx
ÏÂ
ÔØÍê³Éºó£¬ÏÈжÔØÔÀ´µÄSQL Server 2008¡¡sp2,½á¹ûÕûÕûÔËÐÐÁËÁ½¸ ......