å¯ä»¥ç
çæ§SQL Server PDW
PDWå
·å¤ä¸ä¸ªå
¨é¢çWebçæ§å·¥å
·ï¼ç®¡çæ§å¶å°(Admin Console)ã管çæ§å¶å°çé¢å
å«ä»¥ä¸é项å¡ï¼
ä¼è¯ï¼å½åæ¿æ´»çç¨æ·ä¼è¯ã
æ¥è¯¢ï¼å½åæ§è¡çæ¥è¯¢ï¼ææ°å®æçæ¥è¯¢ä¸ç¸å
³é误信æ¯ï¼ä»¥åæ§è¡è®¡ååèç¹æ§è¡ä¿¡æ¯ã
è´è½½ï¼è´è½½è®¡åï¼å½åè´è½½ç¶æä¸ç¸å
³é误信æ¯ã
å¤ä»½/æ¢å¤ï¼å¤ä»½ä¸æ¢å¤æä½ã
设å¤ç¶æï¼æ¯ä¸ªèç¹ç硬件å软件ç¶æä¿¡æ¯ã
è¦æ¥ï¼ç³»ç»èç¹çè¦æ¥åè¦åä¿¡æ¯ã
仪表æ¿ï¼å®æ¶ç¶ææç»ï¼å
æ¬ç¡¬ä»¶ä½¿ç¨ææ ã
管çæ§å¶å°æ¯ä¸ä¸ªäºèç½ä¿¡æ¯æå¡åºç¨ç¨åºï¼å®è¿è¡å¨æ§å¶æºæ¶çæ§å¶èç¹ä¸ãæ¨å¯ä»¥éè¿Windows Internet Explorer访é®è¿ä¸ªå·¥å
·ã
ç®åï¼SQL Server Management Studio (SSMS)ä¸å
¼å®¹SQL Server PDWãç¶èï¼ä¸ºäºæ¯æ交äºå¼æ°æ®æ¥è¯¢ï¼PDWæä¾äºNexus Query Chameleon GUIå·¥å
·ââå®æ¯ä¹åDATAllegro产åçä¸ä¸ªéçå·¥å
·ãè¿ä¸ªå·¥å
·ä¸SSMS类似ï¼æ¯ææ°æ®åºå¯¹è±¡æµè§åTransact-SQLæ¥è¯¢ã
PDWè¿æä¾äºdwsqlå½ä»¤è¡å·¥å
·ï¼æ¨å¯ä»¥ä½¿ç¨è¿ä¸ªå·¥å
·åæ°æ®åºåéTransact-SQLè¯å¥ãè¿ä¸ªå·¥å
·ä¹æºäºDATAllegroï¼ä¸å
¶ä»çæ¬SQL Serveræä¾çsqlcmdå·¥å
·ç±»ä¼¼ã
å¦ä¸ä¸ªå½ä»¤è¡å·¥å
·æ¯dwloaderãè¿ä¸ªå·¥å
·æ¯æå°å è½½åºèç¹ç大éå段æ°æ®å è½½å°åå¸å¼è®¡ç®èç¹ç¯å¢ä¸ã
PDWè¿å
å«ä¸ä¸ªPDWé
置管çå¨ãè¿ä¸ªå·¥å
·æ¯æè¿è¡è®¾å¤çº§é
ç½®ï¼ä»¥å设置IPå°åææ¶åºçé项ãæ¨è¿å¯ä»¥ä½¿ç¨è¿ä¸ªå·¥å
·æ¥å¯å¨ååæ¢æå¡ã
å¨BIç³»ç»ä¸æ´åSQL Server PDW
SQL Server 2008 R2 åä¸æºè½(BI)å·¥å
·å®å
¨æ´åäºPDWãä¾å¦ï¼PDWå
·å¤ä¸äºéé
å¨ï¼æ¨å¯ä»¥å°å®ä»¬å®è£
å°SQL Server Integration Servicesï¼è¿æ¥PDWæ°æ®åºååæ°æ®åºå è½½æ°æ®ãæ¤å¤ï¼SQL Server Reporting ServicesãSQL Server Analysis ServicesåExcel PowerPivotå
许æ¨æå®ä¸ä¸ªPDWæ°æ®åºä½ä¸ºæ°æ®æºï¼è¿æ ·æ¨å°±è½å¤æ§è¡åæï¼ä»¥åæ ¹æ®PDWæ°æ®çææ¥è¡¨ã
æ¥æ±SQL Server PDW
éè¿å¹¶è¡æ°æ®ä»åºï¼æ¨å¯ä»¥éç¨ä¸ç§å
¨æ°æ¹æ³å®ç°æ°æ®åºæ©å±ãç¶èï¼å¹¶éææçSQL Serverå·¥å
·(ç¹å«æ¯SSMS)é½å
¼å®¹è¿ä¸ªæ°æ¶æãä½æ¯ï¼å¯ä»¥è¯å®çæ¯ï¼PDWçåç»çæ¬å°ä¼æ¯æè¿äºSQL Serverå·¥å
·ãå°é£æ¶ï¼PDWä¼å å
¥æ´å¤åè½å¼ºå¤§ç客æ·ç«¯åºç¨ç¨åºã
温馨提示:答案为网友推荐,仅供参考