| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mssql >> shen ru tan tao SQL Server 2008 shang wu zhi neng (BI)
 

shen ru tan tao SQL Server 2008 shang wu zhi neng (BI)

2008-07-08 07:36:07 编辑來源:互联网 评论
 
本文为【深入探讨SQL Server 2008商务智能(BI)】的拼音翻译版
  Microsoft SQL Server 2008 tong guo yu Microsoft Office de shen du ji cheng , wei suo you ren ti gong le ke yong de shang ye zhi neng , yi he shi de jia ge ti gong gei zheng que de yong hu yi he shi de gong ju 。 ta de jie guo jiu shi gong si li suo you ceng ji de gu yuan dou ke yi tong guo shi yong yi yu shi yong he gong neng qiang da de gong ju kan dao he bang zhu gai bian shang ye zhi xing 。 yu 2007 Microsoft Office xi tong de ji cheng shi de yong hu ke yi yi ta men ke yi li jie he jiao de shu fu de fang shi lai cha kan shang ye xing neng ; er PerformancePoint Server 2007 de tui chu bang zhu ke hu huo de dui zheng ge gong si de quan mian de dong cha li , yi zhi yu ta men ke yi jian kong 、 fen xi he ji hua ta men de ye wu , huan ke yi jia qiang tuan jie 、 zeng qiang ze ren gan he dui zheng ge qi ye de quan mian dong cha li 。
  dao yan
  zai jing zheng ri yi ji lie de shi chang zhong , shang ye ren shi zhu jian ren shi dao ta men zhi you yu xian kan chu shi chang de qu shi he ji yu , bing kuai su de dui xin de ke hu xu qiu zuo chu xiang ying cai neng huo de cheng gong 。 ci wai , gu yuan xu yao dui shang ye huo dong he hua fei jin xing pai lie you xian ci xu , yi ci lai que bao da dao zui you xiao de shi yong ke yong de zi yuan he zuo chu you xiao de shang ye jue ce 。
  wei le man zu zhe xie tiao zhan , gu yuan xu yao huo de dui shang ye de quan mian de dong cha li , yi bian ta men ke yi zuo chu rui zhi de jue ce , bing wei cu jin shang ye cheng gong zuo chu gong xian 。 gong si xiang jiang zhe ge dong cha qian ru mei tian de shang ye huo dong zhong , yi bian suo you gu yuan ke yi ming que de huo shi an han de shi yong dui suo you de qi ye shu ju de wan zheng he wen ding de ban ben suo zuo chu de fen xi jie guo 。
  yi 、Microsoft shang ye zhi neng ji shu
  Microsoft ti gong le yi ge quan mian de shang ye zhi neng (BI), ta wei shu ju cang chu 、 fen xi he sheng cheng bao biao ti gong le yi ge kuo zhan de shu ju ping tai , bing ti gong le zhong duan yong hu ke yi yong lai fang wen he fen xi shang ye xin xi de qiang da de he zhi jiao gong ju 。Microsoft shang ye zhi neng “ ti gong gei zhong duan ” de gai xin shi Microsoft SQL Server 2008, ta shi yi ge quan mian de shu ju fu wu ping tai , shi ni neng gou :
  · tong yi qi ye zhong suo you shu ju de cun chu he fang wen 。
  · jian li he guan li fu duo de shang ye zhi neng jie jue fang an 。
  ·SQL Server 2008 xing cheng le suo ti gong de zhe ge qiang da de shang ye zhi neng de ji chu , ta de te you ji shu ru xia mian suo shi :
深入探讨SQL Server 2008商务智能(BI)

  er 、2007 Microsoft Office xi tong ji cheng
  SQL Server 2008 shang ye zhi neng ping tai tong guo xia mian de 2007 Office xi tong zu jian ti gong gei xin xi gong zuo ren yuan :
  1.Microsoft Office Excel。 zhe shi yi ge qiang da de dian zi biao ge ying yong , ni ke yi jiang ta zuo wei yi ge yong yu lian ji fen xi chu li fen xi 、 shu ju wa jue he bao biao xuan ran de jie kou 。 tong guo SQL Server 2008 he Excel 2007 de shen du ji cheng , ni ke yi :
  jia qiang le zhong duan yong hu fang wen he fen xi cong SQL Server 2005 fen xi fu wu huo de de shu ju de neng li 。 you le Excel 2007, zhong duan yong hu ke yi liu lan cun chu yu fen xi fu wu zhong de duo wei lian ji fen xi chu li li fang ti zhong de shu ju 。Excel 2007 shi yong hu neng gou tong guo shi yong yi jing an zhuang zai da duo shu zhuo shang ji suan ji li de gong ju yi ta men xiang yao de ren he fang shi lai qing song de jian li “ qie pian he qie kuai ” shu ju de Microsoft PivotTable dong tai shi tu 。
  Excel yu fen xi fu wu de jin mi ji cheng shi zhong duan yong hu ke yi qing song de shi yong fen xi fu wu de te xing , li ru zhuan huan 、 guan jian ji xiao zhi biao (KPI)、 ji suan cheng yuan 、 ming ming ji 、 he Excel zhong de jiang Excel zhuan hua wei yi ge fen xi ke hu duan de fu wu qi huo dong , tong guo shi yong zhe ge ji cheng shi ni ke yi cong Excel zhi xing zhong shou huo geng duo 。
  wei mei ge ren zuo you yong de yu ce fen xi , shi fei ji shu yong hu ke yi zai shu xi de Office huan jing zhong li yong SQL Server 2005 fen xi fu wu de fei chang fu duo de shu ju wa jue suan fa 。 she ji shi jiu wei zhong duan yong hu zuo le kao lv , yong zai Office 2007 zhong de shu ju wa jue cha jian shi zhong duan yong hu ke yi zhi jie zai Excel he Microsoft Office Visio zhong zhi xing fu duo de fen xi 。
  zeng jia le zi dong hua fen xi te xing , li ru qiang tiao le shu ju yu biao de qi ta bu fen huo shu ju fan wei de ge shi kan qi lai bu tong de yi chang , ji yu xian zai de qu shi yu ce wei lai de shu zhi , fen xi ge zhong chang jing xia de qing kuang , jue ding xu yao gai bian shen me lai da dao kuan yi ge te ding de mu biao 。
  yi da duo shu zhong duan yong hu suo xi huan de ge shi , tong guo shi yong xin de zeng qiang de bao biao fu wu Excel xuan ran neng li lai fa song bao biao , zhe ge neng li shi de zhong duan yong hu ke yi zhi jie zai Excel zhong jie shou dao bao biao 。
  2.Microsoft Office Word。 ta shi yi ge word chu li ying yong cheng xu , ni ke yi shi yong ta zuo wei bao biao de yi zhong ge shi 。 shi yong zhe ge hen duo ren suo qi dai de xin de yong yu Microsoft Word de bao biao xuan ran qi , ta shi de ni ke yi yong Word ge shi lai xuan ran SQL Server 2008 bao biao fu wu de bao biao 。
  3.Microsoft Office Visio。 yi ge hua tu ying yong , ni ke yi shi yong ta lai zuo zhu shi 、 zeng qiang he zhan shi ni de tu xing hua de shu ju wa jue shi tu 。 you le SQL Server 2008 he Visio 2007, ni ke yi :
  xuan ran jue ce shu 、 hui gui shu 、 ji qun tu 、 he yi lai wang luo 。
  jiang shu ju wa jue mo xing bao cun wei nei qian dao qi ta Office wen dang zhong de Visio wen dang , huo zhe bao cun cheng yi ge wang ye 。
  4.Microsoft Office SharePoint Server。 zhe shi yi ge quan mian de xie zuo 、 fa bu 、 he yi biao pan jie jue fang an , ni ke yi shi yong ta zuo wei yi ge yong yu ti gong yi ge fang zhi ni suo you de qi ye ji shang ye zhi neng de nei rong he gong ju de zhong yang wei zhi de zhong yang zu jian , zhe yang ni gong si de suo you ren dou ke yi cha kan xiang ying de he ji shi de fen xi shi tu 、 bao biao he guan jian ji xiao zhi biao , bing yu ta men jin xing jiao hu 。SQL Server 2008 bao biao fu wu he Office SharePoint Server 2007 de ji cheng shi ni ke yi :
  shi yong yi ge yi zhi de yong hu jie kou lai guan li he cha kan bao biao 。
  dang ban ben he bao biao de gong zuo liu cun chu dao Office SharePoint Server 2007 wen dang ku zhong shi gen zong ta men 。
  tong guo SharePoint wen dang ku guan li yi ge dan du de yong yu bao biao de an quan mo xing 。
  shi yong Office SharePoint Server 2007 ji kai ji yong bao biao zhong xin mo ban qing song de jian li yi ge zhan dian yong yi cun chu bao biao 。
  5.Microsoft Office PerformancePoint Server。 yi ge ji cheng de xing neng guan li ying yong , gu yuan ke yi shi yong ta lai jian kong 、 fen xi he ji hua ji yu SQL Server 2008 ti gong de fen xi shu ju de shang ye huo dong 。
  tong guo zhe pian wen zhang de qi ta bu fen , ni jiang xue xi dao SQL Server 2008 he ta yu 2007 Office xi tong de ji cheng jiang zen yang bang zhu ni tong yi shang ye zhi neng shu ju cun chu he fang wen , jian li he guan li fu duo de shang ye zhi neng jie jue fang an , bing jiang zhe xie jie jue fang an fu gai de fan wei kuo da dao ni de suo you de gu yuan 。
  tong yi shu ju cun chu he fang wen
  da duo shu gong si yong you duo ge shang ye xi tong , mei yi ge dou you ta zi ji zhuan yong de shu ju cun chu 。 jin guan ni ke yi jing chang cong dan du de ying yong zhong sheng cheng bao biao , bing dui ta men bao han de shu ju jin xing fen xi , dan shi ni zhi neng tong guo he bing qi ye nei de yi gou shu ju lai chuang jian yi ge ji zhong de yong yu sheng cheng bao biao he fen xi de shang ye shu ju yuan 。
  yi . he bing suo you de shu ju , yong yu fen xi he sheng cheng bao biao
  SQL Server 2008 zhi chi liang ge chang jian de fang fa lai tong yi shang ye shu ju yong yu fen xi he sheng cheng bao biao :
  shu ju cang ku 。 yi ge zhi zhen dui qi ye ji shu ju de cun chu , ta de shu ju cong qi ye zhong de bu tong shu ju yuan de shang ye shu ju er lai , bing yu qi tong bu 。 zhe ge fang fa de zhu yao you dian shi ni ke yi she ji shu ju cang ku yong yu zui jia de fen xi he bao biao xing neng , er dui zuo wei shu ju lai yuan de shang ye ying yong de xing neng mei you ying xiang 。 zhe ge fang fa de ling wai yi ge you dian shi ni ke yi qing li he he bing duo ge shu ju yuan er lai de shu ju dao yi ge dan du de yu zhen shi shu ju bao chi yi zhi de ban ben zhong 。
  shu ju yuan chou xiang 。SQL Server 2008 fen xi fu wu shi de ke yi chuang jian shu ju yuan shi tu yi ti gong yi ge zhen dui yi ge huo duo ge shu ju yuan de chou xiang ceng 。 ran hou ni ke yi jiang zhe ge shu ju yuan shi tu zuo wei fen xi fu wu 、 ji cheng fu wu he bao biao fu wu de dan du de shu ju yuan 。 you le zhe ge shu ju yuan shi tu , dang jin xing fen xi he sheng cheng yi ge bao biao de shi hou , hui cong hou tai de shu ju yuan xi tong huo qu shu ju 。 zhe ge fang fa de zhu yao you dian shi ta shi de ke yi dui ni de shang ye ying yong zhong de shu ju zuo shi shi fen xi 。 ci wai , shu ju yuan shi tu tong guo ta zeng jia de chou xiang ceng ke yi yong lai chuang jian he shi de ming cheng lai ti dai jiao chang de huo han yi mo hu de biao ming 。
  tu 1 xian shi le zhe xie fang fa 。 you le SQL Server 2008, ni ke yi huo zhe shi yong zhe xie fang fa , huo zhe liang zhe jie he shi yong 。
深入探讨SQL Server 2008商务智能(BI)

  tu 11. yi ni xiang yao de fang shi lai shi yong ni suo you de shu ju
  wu lun ni cai qu na ge fang fa lai tong yi ni de shang ye shu ju ,SQL Server 2008 jian li zai guo qu dui guan xi shu ju he fei guan xi shu ju de qiang da de zhi chi , ti gong le shi kai fa ren yuan he guan li yuan ke yi you xiao de cun chu he guan li fei jie gou hua shu ju de shu ju lei xing , li ru wen dang he tu pian , suo yi ni ke yi yi zui shi he ni de ye wu de ge shi lai cun chu 、 guan li he fen xi shu ju 。
  SQL Server 2008 zeng qiang le dui xml shu ju cun chu he yi ge FILESTREAM shu ju lei xing de zhi chi ,FILESTREAM shu ju lei xing shi da xing de er jin zhi shu ju ke yi cun chu zai wen jian xi tong zhong , bing qie bao chi shi wu yi zhi xing reng zuo wei shu ju ku wan zheng de yi bu fen 。 ci wai , shan chu le dui yong hu ding yi de shu ju lei xing gui mo de xian zhi , shi de ke yi chao guo zai zhi qian de SQL Server ban ben zhong de 8 KB de xian zhi 。 dui kong jian he wei zhi shu ju lei xing de zhi chi shi de ke yi cun chu he fen xi fu he xing ye biao zhun de di li shu ju 。
  2. ji cheng suo you de qi ye shu ju yuan
  SQL Server 2008 shu ju yuan shi tu shi de ke yi ji cheng shu ju he dui cong yi gou de qi ye ji shu ju cun chu huo de de shu ju jin xing fang wen , li ru SQL Server、Oracle、DB2 he Teradata。 zhe xie shi tu huan ti gong le yi ge qi ye fan wei de lian ji fen xi chu li cun chu , er qie zai SQL Server ji cheng fu wu zhong dui bu tong shu ju yuan de zhi chi guang du yi wei zhe ni ke yi cong xian you de suo you zhong lei de shang ye ying yong zhong ti qu shu ju 。 yin ci , tong yi ni suo you de qi ye shu ju yuan de shu ju shi hen rong yi shi xian de , bu lun ni shi fou xiang jian li yi ge chou xiang ceng lai tong guo shu ju yuan cha kan huo shi yong ETL chu li lai yu yi ge zhi yong yu fen xi he bao biao de shu ju cang ku tong bu 。
  ci wai , tong guo dui Web services he Microsoft .NET kuang jia de zhi chi ,SQL Server 2008 zhi chi yu duo ge ping tai 、 ying yong he bian cheng yu yan de xie tong gong zuo neng li , suo yi ni ke yi tong guo ji cheng he lian jie dao ni de yi gou de shu ju yuan lai zui da hua ni dui xin de he xian you de xi tong de tou zi hui bao 。 zhi chi yi you de he xin chu xian de kai fang biao zhun , li ru HTTP、XML、SOAP、XQuery he XSD, jin yi bu tui dong le ni de kuo zhan le de qi ye xi tong de tong xin 。
  er 、 shu ju cang ku xing neng
  SQL Server 2008 ti gong le yi ge quan mian de he ke kuo zhan de shu ju cang ku ping tai , shi de ni de qi ye ke yi geng kuai de jiang shu ju zheng he dao shu ju cang ku zhong , zhe yang ni jiu ke yi kuo zhan he guan li bu duan zeng chang de shu ju liang he yong hu shu liang 。
  1. you hua ETL guo cheng
  shu ju cang ku yi ban tong guo ETL guo cheng cong shu ju yuan xi tong huo de de shu ju jin xing zu zhuang he geng xin 。 zai shu ju zui chu jia zai dao shu ju cang ku zhong zhi hou , hui ding qi de shua xin yuan xi tong de xin de he geng gai de shu ju , yi que bao shu ju cang ku de shu ju shi zui xin de 。
  SQL Server ji cheng fu wu ti gong le yi ge quan mian de ping tai , ni ke yi shi yong ta cong bu tong de shu ju yuan xi tong ti qu shu ju , zuo suo yao qiu de ren he dui shu ju huo ta de jie gou he ge shi de zhuan huan , ran hou jia zai zhuan huan de shu ju dao shu ju cang ku zhong 。 zhi xing cha zhao lai pi pei cong shu ju yuan xi tong huo de de ji lu dao zai shu ju cang ku zhong de yi you de ji lu shi ETL guo cheng zhong de yi ge chang jian cao zuo , zai SQL Server 2008 zhong cha zhao de xing neng bei xian zhu de ti gao le , yi zhi yu zhe xie cao zuo kuo zhan dao da xing biao 。
  wei le bang zhu gen zong shu ju bian hua he que bao shu ju cang ku yi zhi xing ,SQL Server 2008 tui chu le bian hua shu ju bu huo (Change Data Capture,CDC) gong neng , jiang geng xin ji lu zai bian geng biao zhong , zhe shi de hen rong yi biao shi bei geng gai de xing he que ding geng gai de xi jie yi ji geng gai de yuan yin 。
  2. you xiao de guan li ying jian zi yuan
  tong guo dui shu ju ya suo de zhi chi ,SQL Server 2008 shi ni ke yi geng you xiao di cun chu ni de shu ju he jiang di cun chu cheng ben 。 ling wai , ya suo ming xian de ti gao le da xing de ju you shu ru / shu chu xian zhi de gong zuo fu zai de xing neng 。SQL Server 2008 huan wei bei fen ya suo ti gong le ben di zhi chi ji kai ji yong 。 ci wai ,VARDECIMAL shu ju lei xing he SQL Server 2008 zhong de xin de xi shu lie tong guo jiang di da xing biao ( zhe xie biao ru zai shu ju cang ku suo chang jian de , zhu yao wei shu zi huo kong zhi ) suo xu yao de kong jian shu liang lai bang zhu ni cong ni de ci pan cun chu zi yuan huo de zui hao de xiao lv 。
  chu le zai shu ju cun chu fang mian de xiao lv ,SQL Server 2008 huan zhi chi yang she nei cun de di zhi chuang kou kuo zhan (Address Windowing Extensions,AWE) de dong tai fen pei , ta zhi chi Windows Server 2003、 shu ju zhong xin ban (Datacenter Edition) de 64GB nei cun 、 he 64 wei ban ben de 2TB nei cun , lai zhi chi da xing shu ju cang ku huan jing 。
  SQL Server 200 huan tui chu le zi yuan jian kong qi , ta shi de guan li yuan ke yi wei bu tong de gong zuo fu zai ding yi zi yuan xian zhi he you xian quan , yi bian shi bing fa gong zuo fu zai ke yi ti gong wen ding de zhi xing , bing shi de ke yi yu xian de guan li zi yuan jing zheng wen ti 。
  3. you hua shu ju ku xing neng
  SQL Server 2008 bao kuo gao xing neng de guan xi shu ju ku yin qing , ta shi de ni ke yi jian li gao xiao de shu ju cang ku jie jue fang an 。 chuang xin ( li ru yong yu star schema( xing xing mo shi ) he gong ju de cha xun you hua bang zhu ni tiao zheng suo yin he shu ju jie gou ) shi de SQL Server wei jing chang cha xun de shu ju cang ku zi dong xuan ze , tong shi zai SQL Server 2008 zhong tui chu le MERGE Transact-SQL yu ju , kai fa ren yuan ke yi geng you xiao di chu li pu tong de shu ju cang ku chang jing , li ru jian cha yi xing shi fou cun zai ran hou zhi xing cha ru huo geng xin 。 ci wai , dui GROUP BY tiao jian yu ju jin xing le kuo zhan , shi de yong hu ke yi zai yi ge cha xun zhong ding yi duo ge zu 。Grouping Set sheng cheng le yi ge dan du de jie guo ji , zhe yu dui bu tong fen zu de xing zhi xing UNION ALL cao zuo shi deng jia de , ta shi de ju he cha xun he sheng cheng bao biao geng jia rong yi he kuai su 。
  SQL Server 2008 zhi chi fen qu biao , bang zhu ni you hua da xing biao de xing neng he guan li , you le dui fen qu biao bing xing de xin de zhi chi , ni ke yi tong guo shi yong fen qu biao xian zhu de you hua yi ge shu ju cang ku 。
  guan li fu duo de shang ye zhi neng jie jue fang an
  sui zhe gong si dui fu duo fen xi ri yi zeng chang de xu qiu , dui neng gou kuai su de jian li he ti jiao you xiao de shang ye zhi neng jie jue fang an , bing neng jiang di ni de shang ye zhi neng ji chu she shi de guan li fei yong de yao qiu , cheng wei le yi ge zhu yao yao kao lv de shi xiang 。SQL Server 2008 bao han chuang xin de gong ju , zhe xie gong ju ti gao le kai fa ren yuan de xiao lv he guan li neng li , ta shi de ke yi geng kuai de cong xin de fen xi he sheng cheng bao biao neng li huo de shou yi , tong shi shi de guan li fei yong jiang di le 。
  yi 、 kai fa ren yuan sheng chan li
  SQL Server 2008 jian hua le shang ye zhi neng jie jue fang an de kai fa guo cheng 。 shang ye zhi neng kai fa ren yuan shou yi yu yi shi yong de gong neng he gong ju , zhe xie gong neng he gong ju zeng jia le kong zhi he zi dong jin xing li xing cao zuo 、 hao shi de ren wu , bing ke yi shi yong SQL Server 2008 de gao xiao de te xing geng kuai su de chuang jian gao xiao de fen xi he bao biao jie jue fang an ; zhe yang ni de gong si hen kuai jiu ke yi li yong ta men 。
  1. shi yong yi ge feng fu de 、 xian dai de bian cheng huan jing
  tong guo yu Microsoft Visual Studio de jin mi xie tong gong zuo , kai fa ren yuan ke yi qing song di jian li he wei hu qiang da de 、 an quan de 、 ke kuo zhan de shang ye zhi neng jie jue fang an 。SQL Server shang ye zhi neng kai fa tao jian ti gong le yi ge dan du de gong ju , ta han gai le duo ge shang ye zhi neng jie jue fang an lei xing , bing wei kai fa ETL、 fen xi he bao biao jie jue fang an ti gong le yi ge dan du de 、 wen ding de huan jing 。 zuo wei shang ye zhi neng kai fa tao jian de yi bu fen tui chu de zhi jie de shang ye zhi neng xiang dao , shi de shen zhi chu ji kai fa ren yuan ye neng hen rong yi de jian li gao ji de shang ye zhi neng mo xing he xiang mu 。
  
  tong guo zai shu ju ku yin qing zhong qian ru gong gong yu yan yun xing shi ,SQL Server 2008 shi kai fa ren yuan ke yi cong xu duo yu yan zhong xuan ze yong yi kai fa ying yong cheng xu , bao kuo Transact-SQL、Visual Basic he C#。 zhe ge ling huo de huan jing shi de kai fa ren yuan ke yi shi yong ta men xian you de ji neng you xiao de kai fa shu ju ku ying yong cheng xu 。
  dang yu Visual Studio ji cheng shi , zai suo you de SQL Server 2008 shang ye zhi neng ji shu de kai fa ti yan zai ti gong yi ge zhen shi de ying yong cheng xu kai fa huan jing yong yi zhi chi zheng ge kai fa sheng ming zhou qi ( kai fa 、 ce shi 、 bu shu he ce shi ) fang mian shi zui jia de 。
  2. shi xian zui jia fang fa jie jue fang an
  ran er , zhi you you hua she ji le zhe xie jie jue fang an cai neng shi kai fa ren yuan neng gou geng kuai di jian li jie jue fang an 。 wei le bang zhu que bao zui jia de xing neng he zheng que de gong neng ,SQL Server 2008 bao han le xia mian de kai fa huan jing te xing , ta men cu jin wan cheng zui hao de shi jian he bang zhu kai fa ren yuan chuang jian you xiao de fen xi jie jue fang an :
  yi ge yong yu suo you de shang ye zhi neng jie jue fang an de wen ding de kai fa huan jing , bao kuo fen xi fu wu 、OLAP、 he shu ju wa jue ying yong 。
  nei zhi de dui zheng ge kai fa sheng ming zhou qi de zhi chi , bao kuo she ji 、 jian li 、 tiao shi 、 he bu shu cao zuo ; bing tong guo ji cheng de dui yuan kong zhi de zhi chi lai zhi chi tuan dui kai fa 。
  yi xie zhi jie de she ji qi he xiang dao , shi de hen rong yi kuai su de chuang jian fen xi fu wu jie jue fang an 。
  yi ge shu xing guan xi she ji qi , ta bao kuo nei zhi de yan zheng yong yi bang zhu chuang jian zui jia de wei du she ji 。
  yi ge wei du bian ji qi , ta bei jing jian yi ti gong geng hao de xiao lv , bing qie hui zi dong jian ce dao shi fou cun zai fu zi guan xi 。
  yi ge li fang ti she ji qi ye bei liu xian hua he jin xing le gai jin , yi ti gong geng hao de jian ce xing he shu xing de fen lei , huan you bian bie cheng yuan shu xing 。
  dan du fen qu de ju he , ta shi de ni ke yi you hua bu tong jie duan huo bu fen de ce liang 。
  ju he she ji qi you yi ge xin de suan fa , ta bang zhu chuang jian zui chu de ju he 。 zhe ge ju he she ji qi zai shi yong yong fa qu dong ju he fang mian shi zui jia de 。 ni xian zai ke yi cha kan chuang jian de ju he he tian jia huo shan chu ju he 。 ti gong le zhi neng zhi chi yi bang zhu he bing xian you de he xin de ju he she ji 。
  ci wai ,SQL Server 2008 ti gong le AMO jing gao lai ti xing kai fa ren yuan dang ta men de she ji po huai le 40 duo ge zui jia fang fa li de yi ge de shi hou 。 zhe xie jing gao ji cheng dao le shi shi she ji qi jian cha zhong , bing wei kai fa ren yuan jian ce ta men de she ji de qian zai wen ti ti gong le yi ge fei qin ru shi de fang fa 。
  3. ti gao bao biao ling huo xing
  bao biao shi ren he shang ye zhi neng jie jue fang an zhong de yi ge chong yao de zu cheng bu fen , er shang ye yong hu zheng zai bu duan de yao qiu geng fu duo de bao biao 。SQL Server bao biao fu wu ti gong le yi xia gong neng shi de hen rong yi jian li bao biao jie jue fang an :
  yi ge zai shang ye zhi neng kai fa tao jian zhong de ji yu Visual Studio de bao biao kai fa jie kou , kai fa ren yuan ke yi yong ta jian li 、 tiao shi he bu shu bao biao 。
  yi ge jiao zuo Report Builder de zhuan zhu yu shang ye de bao biao kai fa gong ju , shang ye yong hu ke yi yong ta lai chuang jian he bu shu bao biao 。
  shu ju xian shi jie gou fan wei kuan guang , bao kuo biao 、 ju zhen 、 lie biao he tu biao 。
  ci wai ,SQL Server 2008 bao kuo le dui bao biao fu wu de ji da zeng qiang , ta gai jin le bao biao xing neng he ti gao le ge shi hua he fa bu bao biao de ling huo xing 。 zai SQL Server 2008 zhong dui bao biao fu wu zuo de gai jin zhi yi shi zhi chi yi ge xin de xian shi jie gou , zhe ge xin de xian shi jie gou jie he le biao he ju zhen shu ju dao yi ge xin de Tablix shu ju qu yu li 。Tablix shi kai fa ren yuan ke yi sheng cheng jie he le gu ding de xing he dong tai de xing de bao biao 。 yi qian , zhe zhong lei xing de xian shi xu yao tong guo duo ge ju zhen shu ju he suo duan shu ju xing de tou cai neng xian shi chu lai 。 dui Tablix shu ju lei xing de zhi chi jian hua le bao biao bao han jing tai he dong tai shu ju de jie he , bing qie xian zhu de kuo zhan le bao biao fu wu ge shi hua he xian shi neng li 。
  er 、 yi guan li
  tong guo chuang xin ( li ru tong yi de guan li gong ju ) jia qiang le zi wo tiao zheng de neng li , er yi ge qiang da de guan li bian cheng mo xing ,SQL Server 2008 kuo zhan le SQL Server yi shi yong de ling xian di wei he ti gao le shu ju ku guan li yuan men (DBA) de xiao lv 。 zhe xie zeng qiang shi de shu ju ku guan li yuan men zhuan zhu yu gao jia zhi de ren wu , xiang shu ju ku jia gou , tong shi hua fei jiao shao de shi jian zuo li xing wei hu 、 pei zhi he tiao zheng 。
  1. shi yong yi ge dan du de 、 tong yi de gong ju
  SQL Server 2008 ti gong gei shu ju ku guan li yuan SQL Server guan li tao jian ; yi ge dan du de 、 tong yi de guan li gong ju , ta tong guo yong yu zai kuo zhan de SQL Server gong ju zhong zeng qiang le de shu ju ku guan li yuan xiao lv 、 ling huo xing he guan li neng li de xiang tong de jie kou , wei ti gong le fen xi fu wu 、 bao biao fu wu he duo ge SQL Server de ban ben de ji cheng guan li 。
  2. jian kong shu ju cang ku zi yuan
  SQL Server 2008 huan bao kuo xing neng tao jian , ta ti gong le yi ge ji zhong de yong yu jian kong he bao gao ni de shu ju fu wu jie jue fang an zhong de zi yuan shi yong qing kuang de guan li gong ju 。
  san 、 qi ye ke kuo zhan xing
  ling yi ge yu cheng gong de sheng cheng fu duo de shang ye zhi neng jie jue fang an xiang guan de guan jian yin su yao qiu shen zhi zai zui da kuo zhan xia de chi xu xing de kai fa ren yuan xiao lv he guan li neng li 。 er qie , ji chu she shi bi xu ti gong yu xing neng xiang guan de ke kuo zhan neng li , zhe zai SQL Server 2008 zhong zuo le da liang de tou ru , zhe xie tou ru guan zhu yu que bao shen zhi zai shang ye zhi neng zhi xing de zui da kuo zhan xia de zhe ge qi ye ji de chi xu xing 。
  1. ke kuo zhan de fen xi
  lian ji fen xi chu li (OLAP) de qian ti shi dui zhun que de xin xi de ji shi fang wen , zhe shi de zhong duan yong hu ke yi xun su di hui da zui fu duo de wen ti 。 yin ci , yao zuo dao hen hao de ti gong geng kuai de cha xun shi jian he shu ju shua xin su du shi ren he Microsoft SQL Server fen xi fu wu ban ben de kai fa guo cheng zhong suo you xian kao lv de , ta ye cu shi chan sheng le SQL Server 2008 fen xi fu wu ban ben 。
  SQL Server 2008 bao kuo shi ni neng gou cai yong zeng qiang de neng li zuo geng guang de fen xi de fen xi fu wu , bao kuo fu duo de ji suan he ju he 。 fen xi fu wu tong guo yi xia fang mian ti gong le qi ye ji de xing neng :
  yi ge ling huo de huan cun mo xing 。 you le fen xi fu wu , ni ke yi kong zhi shu ju he ju he zen yang huan cun lai you hua cha xun xing neng , tong shi jiang huan cun he ta de lai yuan de shu ju cun chu zhi jian de fan ying shi jian wei chi zai yi ge ke jie shou de ji bie 。
  sheng ming shu xing guan xi 。 zai yi ge fen xi fu wu wei du zhong , ni ke yi ming que de sheng ming zai yi ge ceng ji zhong de shu xing de guan xi 。 zhe shi de dang chu li yi ge li fang ti huo wei du shi , fen xi fu wu neng gou yu xian sheng cheng ju he , zhe gai jin le yun xing shi cha xun xing neng 。
  kuai ji suan 。 kuai ji suan shan chu le bu bi yao de ju he ji suan ( li ru , dang yao ju he de zhi wei NULL de shi hou ), bing ti gong le yi ge zai fen xi li fang ti xing neng fang mian de xian zhu ti gao , zhe shi de yong hu ke yi zeng jia ta men de ceng ji shen du he ji suan de fu duo du 。
  hui xie dao MOLAP。 fen xi fu wu 2008 shan chu le dang zhi xing hui xie shi dui cha xun ROLAP fen qu de yao qiu , zhe shi de qi ji da de ti gao le xing neng 。
  kuo zhan fen xi fu wu 。 fen xi fu wu shu ju ku de yi ge dan du de zhi du kao bei tong guo yi ge xu ni de ip di zhi ke yi zai duo ge fen xi fu wu qi jian gong xiang 。 zhe wei fen xi fu wu jie jue fang an ti gong le yi ge gao du ke kuo zhan de kai fa xuan xiang 。
  zhi xing ji hua chi jiu xing 。SQL Server 2008 ti gong le zhi ding cha xun ji hua de gong neng , yi bian zui da cheng du de kuo zhan zheng que xing de ke neng , cha xun ji hua bu hui shou fu wu qi chong qi 、 fu wu qi geng xin he chan pin bu shu ying xiang 。 zhe que bao le dui SQL Server shu ju cha xun de wen ding de zui jia xing neng 。
  2. ke kuo zhan de sheng cheng bao biao
  dui yu da duo shu gong si lai shuo , zai zheng que de shi jian gei zheng que de yong hu yi zheng que de xin xi shi yi ge hen da de tiao zhan 。SQL Server 2008 ti gong le yi ge gao xing neng de bao biao yin qing yong yu chu li he ge shi hua bao biao , tong shi huan ti gong le yi tao gong ju yong yu chuang jian 、 guan li he cha kan bao biao 。 yi ge ke kuo zhan de jia gou he kai fang de jie kou shi de ke yi hen rong yi de zai bu tong de IT huan jing zhong ji cheng bao biao jie jue fang an 。
  ni ke yi cong duo ge bu tong de shu ju yuan sheng cheng bao biao , bao kuo SQL Server、DB2 he Oracle, er bu xu yao xian jian li yi ge ji zhong de shu ju cang ku 。 ni ke yi tong guo bao biao fu wu ti gong de jian dan de bu shu he pei zhi neng li zai gong si nei wai fa song bao biao 。 zhe shi de yong hu ke yi qing song de chuang jian he fen xiang ren he gui mo huo fu duo du de bao biao 。 ni huan ke yi tong guo wang luo lai bu shu bao biao , jiang qi qing song de fa song gei ke hu he gong ying shang 。
  bao biao fu wu ti gong le dui kong zhi fu wu qi huo dong de zhi chi he neng li , zhe xie huo dong bao kuo nei cun guan li 、 ji chu she shi he bing he tong guo yi ge ji zhong de cun chu he yi ge yong yu suo you de pei zhi she zhi de API de jian dan de pei zhi 。
  kuo zhan ni de shang ye zhi neng jie jue fang an de fan wei
  guo qu , shang ye zhi neng jie jue fang an zhi bei shao shu shang ye fen xi shi shi yong 。 xian zai , yue lai yue duo de gong si ren shi dao ta men ke yi cong kuo zhan ti gong gei suo you gu yuan shang ye zhi neng shi fei chang you yong de dong cha li he jiang zhe xie dong cha li nei zhi dao ri chang de ye wu cao zuo zhong huo de shou yi 。
  SQL Server 2008 shi ni ke yi tong guo yi ge ke kuo zhan de 、 kai fang de he ke nei zhi de jia gou , chuang jian yi ge ke yi kuo zhan dao shu qian ming yong hu , bing qie gei suo you ren yi ge feng fu de yong hu ti yan de shang ye zhi neng jie jue fang an , zhe ge jia gou yu Microsoft Office xie zuo shi yong shi zui jia de 。
  yi 、 tong guo shu xi de gong ju kuo zhan shang ye dong cha li
  Microsoft Office Microsoft Office cheng wei le pu bian shi yong de gao xiao de tao jian , quan qiu fan wei de gong si li de da duo shu xin xi gong zuo ren yuan shi yong ta lai zhi xing ta men ri chang de gong zuo 。 tong guo yu Office de jin mi ji cheng ,SQL Server 2008 shi ni neng gou ti gong gei ni de gu yuan yi ta men suo xu yao de guan jian de shang ye xin xi 。
  2007 Microsoft Office he Microsoft Office PerformancePoint Server 2007 de jin mi ji cheng shi de gong si ke yi tong guo shi yong jie he shi yong hen hao de ji shu lai jie sheng shi jian he jin qian 。 tong guo cai yong shu xi de yi jing an zhuang zai mei ge zhuo shang ji suan ji de gong ju gei suo you ren ti gong shang ye dong cha li , zhe ge ji cheng huan shi de ke yi geng kuai de huo de kuo da zhong duan yong hu fang mian de tou zi hui bao 。
  1. shi yong Microsoft Office kuo zhan ni de bao biao jie jue fang an
  bao biao fu wu 2008 zhi chi dui Microsoft Excel he Microsoft Word ge shi de xuan ran 。 xuan ran de bao biao zai yi yu shi yong de Microsoft Office ying yong zhong shi wan quan ke yi bian ji de , zhe kuo zhan le ni de bao biao jie jue fang an , yi bian yong hu ke yi chuang jian ding zhi de ji yu shang ye bao biao de wen dang 。
  2. jiang Excel yong yu fen xi
  Excel shi xu duo jin rong he shang ye fen xi gong zuo ke yi xuan ze de gong ju 。 tong guo jiang Excel tong SQL Server fen xi fu wu xiang jie he , ni ke yi tong guo zai Excel dian zi biao ge zhong de PivotTable dong tai shi tu he Microsoft PivotChart dong tai shi tu ti gong gei shang ye yong hu qiang da de OLAP jie jue fang an 。
  ni huan ke yi shi yong yong yu Excel 2007 de SQL Server shu ju wa jue cha jian , shi shang ye fen xi shi he zhu guan ke yi liu lan shu ju wa jue xiang mu de zheng ge sheng ming zhou qi , bao kuo zhun bei shu ju 、 jian li 、 ping gu , he guan li wa jue mo xing , bing tong guo shi yong dian zi biao ge shu ju huo tong guo ni de fen xi fu wu shu ju ku ke yi fang wen dao de wai bu de shu ju lai yu ce jie guo 。
  3. gei zheng ge qi ye fa bu shang ye dong cha
  SQL Server 2008 yu SharePoint Services jin mi ji cheng , shi de hen rong yi zai yi ge SharePoint zhan dian zhong ji zhong di fa bu he guan li bao biao , bing jian li yong hu zhi ding de yi biao pan , zhe ge yi biao pan ti gong le xiang guan bao biao de ke ding zhi shi tu 。
  ci wai ,Microsoft Office PerformancePoint Server ti gong le yi ge ji zhong de jie kou , zhe ge jie kou yong yu jian li zai SQL Server fen xi fu wu ji chu shang de shu ju fen xi , ta shi de ke hu ke yi jian kong 、 fen xi 、 he ji hua ta men de ye wu , huan ke yi cu jin xie zuo he ti gong dui zheng ge gong si de quan mian de dong cha 。
  er 、 shi zhong duan yong hu ke yi ling huo de zhi zuo bao biao
  SQL Server 2008 ti gong le yi xie bao biao gai jin , shi ni ke yi kuai su qie qing song de sheng cheng ni gong si xu yao de bao biao , bing qie shi yi ni xiang yao de ge shi he neng chong fen xian shi ta men suo bao han de shu ju de xian shi xing shi 。
  1. shi yong Report Builder chuang jian ji xi bao biao
  zai SQL Server 2008 zhong Report Builder bei ji da de zeng qiang le , shi de yong hu ke yi qing song de jian li ren he jie gou de ji xi bao biao 。 zhe ge zhi jiao she ji jie kou shi de fei kai fa ren yuan ke yi qing song de chuang jian shang ye wen dang , li ru ji yu bao biao shu ju de ding dan 、 fa huo he he tong 。
  2. bao kuo feng fu de ge shi hua shu ju
  feng fu de ge shi hua ke yi geng zhi jiao de zhi zuo shang ye wen dang he bao biao , bing shi ta men fei chang yi dong 。SQL Server 2008 de zhe ge feng fu de wen ben zu jian shi de ke yi shi yong hun he ge shi de wen ben kuang he dao ru biao ji de wen ben zi fu chuan , bing zhi chi xin de tu biao ge shi he Tablix shu ju , yi bian yong hu ke yi sheng cheng ju you gao du ke shi hua she ji de bao biao , shi de ke yi chuan da qing xi de he luo ji jiao qiang de shang ye xin xi 。
  3. shou yi yu geng kuai de xiang ying
  sui zhe gong si geng duo de cai yong bao biao lai chuan di shang ye xin xi , que bao ni de bao biao jie jue fang an de xing neng he ke kuo zhan xing da dao zui gao jiu bian de geng wei chong yao le 。SQL Server 2008 zhong de bao biao fu wu yin qing bei chong xin she ji , yong lai jie jue mu qian de ju xian xing , xian zai ta bao kuo an xu chu li he ji yu shi li de xuan ran , yong yi ti gong zui hao de bao biao xing neng 。
  4. zai wang luo shang an quan de bu shu bao biao
  SQL Server 2008 tong guo zai wang luo shang an quan di fa bu bao biao shi ni ke yi kuo zhan ni de bao biao fu wu jie jue fang an de fan wei , jiang qi chuan di gei wai bu de yong hu , li ru ke hu he gong ying shang 。
  zong jie
  SQL Server 2008 jian li zai shang ye zhi neng shi chang zhong de qiang da yao su ji chu zhi shang , ti gong yi ge ke kuo zhan de ji chu she shi , shi de xin xi ji shu ke yi zai ni de gong si zhong shi shi shang ye zhi neng , bing zai yong hu xu yao de shi hou wei qi ti gong shang ye zhi neng 。SQL Server 2008 zai shu ju cang ku fang mian ju you hen da de jin bu , ta ti gong le yi ge quan mian de he ke kuo zhan de ping tai , shi de gong si ke yi geng kuai de jiang shu ju zheng he dao shu ju cang ku zhong , bing kuo zhan he guan li shu ju , tong shi wei suo you yong hu ti gong dong cha li 。 you le SQL Server 2008 suo ti gong de geng ke kuo zhan de shang ye zhi neng ji chu she shi , jiu ke yi qing song de guan li ren he gui mo he fu duo du de bao biao he fen xi , tong shi shi yong hu ke yi yu Microsoft Office zuo geng shen de ji cheng 。SQL Server 2008 huan gai jin le xu duo fang mian de xing neng , bao kuo shu ju cang chu 、 sheng cheng bao biao he fen xi 。【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
Microsoft SQL Server 2008 tong guo yu Microsoft Office de shen du ji cheng , wei suo you ren ti gong le ke yong de shang ye zhi neng , yi he shi de jia ge ti gong gei zheng que de yong hu yi he shi de gong ju 。 ta de jie guo jiu shi gong si li suo you ceng ji de gu yuan dou ke yi tong guo shi yong yi yu shi yong he gong neng qiang da de gong ju kan dao he bang zhu gai bian shang ye zhi xing 。 yu 2007 Microsoft Office xi tong de ji cheng shi de yong hu ke yi yi ta men ke yi li jie he jiao de shu fu de fang shi lai cha kan shang ye xing neng ; er PerformancePoint Server 2007 de tui chu bang zhu ke hu huo de dui zheng ge gong si de quan mian de dong cha li , yi zhi yu ta men ke yi jian kong 、 fen xi he ji hua ta men de ye wu , huan ke yi jia qiang tuan jie 、 zeng qiang ze ren gan he dui zheng ge qi ye de quan mian dong cha li 。 dao yan zai jing zheng ri yi ji lie de shi chang zhong , shang ye ren shi zhu jian ren shi dao ta men zhi you yu xian kan chu shi chang de qu shi he ji yu , bing kuai su de dui xin de ke hu xu qiu zuo chu xiang ying cai neng huo de cheng gong 。 ci wai , gu yuan xu yao dui shang ye huo dong he hua fei jin xing pai lie you xian ci xu , yi ci lai que bao da dao zui you xiao de shi yong ke yong de zi yuan he zuo chu you xiao de shang ye jue ce 。 wei le man zu zhe xie tiao zhan , gu yuan xu yao huo de dui shang ye de quan mian de dong cha li , yi bian ta men ke yi zuo chu rui zhi de jue ce , bing wei cu jin shang ye cheng gong zuo chu gong xian 。 gong si xiang jiang zhe ge dong cha qian ru mei tian de shang ye huo dong zhong , yi bian suo you gu yuan ke yi ming que de huo shi an han de shi yong dui suo you de qi ye shu ju de wan zheng he wen ding de ban ben suo zuo chu de fen xi jie guo 。 yi 、Microsoft shang ye zhi neng ji shu Microsoft ti gong le yi ge quan mian de shang ye zhi neng (BI), ta wei shu ju cang chu 、 fen xi he sheng cheng bao biao ti gong le yi ge kuo zhan de shu ju ping tai , bing ti gong le zhong duan yong hu ke yi yong lai fang wen he fen xi shang ye xin xi de qiang da de he zhi jiao gong ju 。Microsoft shang ye zhi neng “ ti gong gei zhong duan ” de gai xin shi Microsoft SQL Server 2008, ta shi yi ge quan mian de shu ju fu wu ping tai , shi ni neng gou : · tong yi qi ye zhong suo you shu ju de cun chu he fang wen 。 · jian li he guan li fu duo de shang ye zhi neng jie jue fang an 。 ·SQL Server 2008 xing cheng le suo ti gong de zhe ge qiang da de shang ye zhi neng de ji chu , ta de te you ji shu ru xia mian suo shi : [url=http://www.wangchao.net.cn/bbs/pydetail_1796795.html][img]http://image.wangchao.net.cn/it/1323409283879.jpg[/img][/url] er 、2007 Microsoft Office xi tong ji cheng SQL Server 2008 shang ye zhi neng ping tai tong guo xia mian de 2007 Office xi tong zu jian ti gong gei xin xi gong zuo ren yuan : 1.Microsoft Office Excel。 zhe shi yi ge qiang da de dian zi biao ge ying yong , ni ke yi jiang ta zuo wei yi ge yong yu lian ji fen xi chu li fen xi 、 shu ju wa jue he bao biao xuan ran de jie kou 。 tong guo SQL Server 2008 he Excel 2007 de shen du ji cheng , ni ke yi : jia qiang le zhong duan yong hu fang wen he fen xi cong SQL Server 2005 fen xi fu wu huo de de shu ju de neng li 。 you le Excel 2007, zhong duan yong hu ke yi liu lan cun chu yu fen xi fu wu zhong de duo wei lian ji fen xi chu li li fang ti zhong de shu ju 。Excel 2007 shi yong hu neng gou tong guo shi yong yi jing an zhuang zai da duo shu zhuo shang ji suan ji li de gong ju yi ta men xiang yao de ren he fang shi lai qing song de jian li “ qie pian he qie kuai ” shu ju de Microsoft PivotTable dong tai shi tu 。 Excel yu fen xi fu wu de jin mi ji cheng shi zhong duan yong hu ke yi qing song de shi yong fen xi fu wu de te xing , li ru zhuan huan 、 guan jian ji xiao zhi biao (KPI)、 ji suan cheng yuan 、 ming ming ji 、 he Excel zhong de jiang Excel zhuan hua wei yi ge fen xi ke hu duan de fu wu qi huo dong , tong guo shi yong zhe ge ji cheng shi ni ke yi cong Excel zhi xing zhong shou huo geng duo 。 wei mei ge ren zuo you yong de yu ce fen xi , shi fei ji shu yong hu ke yi zai shu xi de Office huan jing zhong li yong SQL Server 2005 fen xi fu wu de fei chang fu duo de shu ju wa jue suan fa 。 she ji shi jiu wei zhong duan yong hu zuo le kao lv , yong zai Office 2007 zhong de shu ju wa jue cha jian shi zhong duan yong hu ke yi zhi jie zai Excel he Microsoft Office Visio zhong zhi xing fu duo de fen xi 。 zeng jia le zi dong hua fen xi te xing , li ru qiang tiao le shu ju yu biao de qi ta bu fen huo shu ju fan wei de ge shi kan qi lai bu tong de yi chang , ji yu xian zai de qu shi yu ce wei lai de shu zhi , fen xi ge zhong chang jing xia de qing kuang , jue ding xu yao gai bian shen me lai da dao kuan yi ge te ding de mu biao 。 yi da duo shu zhong duan yong hu suo xi huan de ge shi , tong guo shi yong xin de zeng qiang de bao biao fu wu Excel xuan ran neng li lai fa song bao biao , zhe ge neng li shi de zhong duan yong hu ke yi zhi jie zai Excel zhong jie shou dao bao biao 。 2.Microsoft Office Word。 ta shi yi ge word chu li ying yong cheng xu , ni ke yi shi yong ta zuo wei bao biao de yi zhong ge shi 。 shi yong zhe ge hen duo ren suo qi dai de xin de yong yu Microsoft Word de bao biao xuan ran qi , ta shi de ni ke yi yong Word ge shi lai xuan ran SQL Server 2008 bao biao fu wu de bao biao 。 3.Microsoft Office Visio。 yi ge hua tu ying yong , ni ke yi shi yong ta lai zuo zhu shi 、 zeng qiang he zhan shi ni de tu xing hua de shu ju wa jue shi tu 。 you le SQL Server 2008 he Visio 2007, ni ke yi : xuan ran jue ce shu 、 hui gui shu 、 ji qun tu 、 he yi lai wang luo 。 jiang shu ju wa jue mo xing bao cun wei nei qian dao qi ta Office wen dang zhong de Visio wen dang , huo zhe bao cun cheng yi ge wang ye 。 4.Microsoft Office SharePoint Server。 zhe shi yi ge quan mian de xie zuo 、 fa bu 、 he yi biao pan jie jue fang an , ni ke yi shi yong ta zuo wei yi ge yong yu ti gong yi ge fang zhi ni suo you de qi ye ji shang ye zhi neng de nei rong he gong ju de zhong yang wei zhi de zhong yang zu jian , zhe yang ni gong si de suo you ren dou ke yi cha kan xiang ying de he ji shi de fen xi shi tu 、 bao biao he guan jian ji xiao zhi biao , bing yu ta men jin xing jiao hu 。SQL Server 2008 bao biao fu wu he Office SharePoint Server 2007 de ji cheng shi ni ke yi : shi yong yi ge yi zhi de yong hu jie kou lai guan li he cha kan bao biao 。 dang ban ben he bao biao de gong zuo liu cun chu dao Office SharePoint Server 2007 wen dang ku zhong shi gen zong ta men 。 tong guo SharePoint wen dang ku guan li yi ge dan du de yong yu bao biao de an quan mo xing 。 shi yong Office SharePoint Server 2007 ji kai ji yong bao biao zhong xin mo ban qing song de jian li yi ge zhan dian yong yi cun chu bao biao 。 5.Microsoft Office PerformancePoint Server。 yi ge ji cheng de xing neng guan li ying yong , gu yuan ke yi shi yong ta lai jian kong 、 fen xi he ji hua ji yu SQL Server 2008 ti gong de fen xi shu ju de shang ye huo dong 。 tong guo zhe pian wen zhang de qi ta bu fen , ni jiang xue xi dao SQL Server 2008 he ta yu 2007 Office xi tong de ji cheng jiang zen yang bang zhu ni tong yi shang ye zhi neng shu ju cun chu he fang wen , jian li he guan li fu duo de shang ye zhi neng jie jue fang an , bing jiang zhe xie jie jue fang an fu gai de fan wei kuo da dao ni de suo you de gu yuan 。 tong yi shu ju cun chu he fang wen da duo shu gong si yong you duo ge shang ye xi tong , mei yi ge dou you ta zi ji zhuan yong de shu ju cun chu 。 jin guan ni ke yi jing chang cong dan du de ying yong zhong sheng cheng bao biao , bing dui ta men bao han de shu ju jin xing fen xi , dan shi ni zhi neng tong guo he bing qi ye nei de yi gou shu ju lai chuang jian yi ge ji zhong de yong yu sheng cheng bao biao he fen xi de shang ye shu ju yuan 。 yi . he bing suo you de shu ju , yong yu fen xi he sheng cheng bao biao SQL Server 2008 zhi chi liang ge chang jian de fang fa lai tong yi shang ye shu ju yong yu fen xi he sheng cheng bao biao : shu ju cang ku 。 yi ge zhi zhen dui qi ye ji shu ju de cun chu , ta de shu ju cong qi ye zhong de bu tong shu ju yuan de shang ye shu ju er lai , bing yu qi tong bu 。 zhe ge fang fa de zhu yao you dian shi ni ke yi she ji shu ju cang ku yong yu zui jia de fen xi he bao biao xing neng , er dui zuo wei shu ju lai yuan de shang ye ying yong de xing neng mei you ying xiang 。 zhe ge fang fa de ling wai yi ge you dian shi ni ke yi qing li he he bing duo ge shu ju yuan er lai de shu ju dao yi ge dan du de yu zhen shi shu ju bao chi yi zhi de ban ben zhong 。 shu ju yuan chou xiang 。SQL Server 2008 fen xi fu wu shi de ke yi chuang jian shu ju yuan shi tu yi ti gong yi ge zhen dui yi ge huo duo ge shu ju yuan de chou xiang ceng 。 ran hou ni ke yi jiang zhe ge shu ju yuan shi tu zuo wei fen xi fu wu 、 ji cheng fu wu he bao biao fu wu de dan du de shu ju yuan 。 you le zhe ge shu ju yuan shi tu , dang jin xing fen xi he sheng cheng yi ge bao biao de shi hou , hui cong hou tai de shu ju yuan xi tong huo qu shu ju 。 zhe ge fang fa de zhu yao you dian shi ta shi de ke yi dui ni de shang ye ying yong zhong de shu ju zuo shi shi fen xi 。 ci wai , shu ju yuan shi tu tong guo ta zeng jia de chou xiang ceng ke yi yong lai chuang jian he shi de ming cheng lai ti dai jiao chang de huo han yi mo hu de biao ming 。 tu 1 xian shi le zhe xie fang fa 。 you le SQL Server 2008, ni ke yi huo zhe shi yong zhe xie fang fa , huo zhe liang zhe jie he shi yong 。 [url=http://www.wangchao.net.cn/bbs/pydetail_1796795.html][img]http://image.wangchao.net.cn/it/1323409314375.jpg[/img][/url] tu 11.   yi ni xiang yao de fang shi lai shi yong ni suo you de shu ju wu lun ni cai qu na ge fang fa lai tong yi ni de shang ye shu ju ,SQL Server 2008 jian li zai guo qu dui guan xi shu ju he fei guan xi shu ju de qiang da de zhi chi , ti gong le shi kai fa ren yuan he guan li yuan ke yi you xiao de cun chu he guan li fei jie gou hua shu ju de shu ju lei xing , li ru wen dang he tu pian , suo yi ni ke yi yi zui shi he ni de ye wu de ge shi lai cun chu 、 guan li he fen xi shu ju 。 SQL Server 2008 zeng qiang le dui xml shu ju cun chu he yi ge FILESTREAM shu ju lei xing de zhi chi ,FILESTREAM shu ju lei xing shi da xing de er jin zhi shu ju ke yi cun chu zai wen jian xi tong zhong , bing qie bao chi shi wu yi zhi xing reng zuo wei shu ju ku wan zheng de yi bu fen 。 ci wai , shan chu le dui yong hu ding yi de shu ju lei xing gui mo de xian zhi , shi de ke yi chao guo zai zhi qian de SQL Server ban ben zhong de 8 KB de xian zhi 。 dui kong jian he wei zhi shu ju lei xing de zhi chi shi de ke yi cun chu he fen xi fu he xing ye biao zhun de di li shu ju 。 2. ji cheng suo you de qi ye shu ju yuan SQL Server 2008 shu ju yuan shi tu shi de ke yi ji cheng shu ju he dui cong yi gou de qi ye ji shu ju cun chu huo de de shu ju jin xing fang wen , li ru SQL Server、Oracle、DB2 he Teradata。 zhe xie shi tu huan ti gong le yi ge qi ye fan wei de lian ji fen xi chu li cun chu , er qie zai SQL Server ji cheng fu wu zhong dui bu tong shu ju yuan de zhi chi guang du yi wei zhe ni ke yi cong xian you de suo you zhong lei de shang ye ying yong zhong ti qu shu ju 。 yin ci , tong yi ni suo you de qi ye shu ju yuan de shu ju shi hen rong yi shi xian de , bu lun ni shi fou xiang jian li yi ge chou xiang ceng lai tong guo shu ju yuan cha kan huo shi yong ETL chu li lai yu yi ge zhi yong yu fen xi he bao biao de shu ju cang ku tong bu 。 ci wai , tong guo dui Web services he Microsoft .NET kuang jia de zhi chi ,SQL Server 2008 zhi chi yu duo ge ping tai 、 ying yong he bian cheng yu yan de xie tong gong zuo neng li , suo yi ni ke yi tong guo ji cheng he lian jie dao ni de yi gou de shu ju yuan lai zui da hua ni dui xin de he xian you de xi tong de tou zi hui bao 。 zhi chi yi you de he xin chu xian de kai fang biao zhun , li ru HTTP、XML、SOAP、XQuery he XSD, jin yi bu tui dong le ni de kuo zhan le de qi ye xi tong de tong xin 。 er 、 shu ju cang ku xing neng SQL Server 2008 ti gong le yi ge quan mian de he ke kuo zhan de shu ju cang ku ping tai , shi de ni de qi ye ke yi geng kuai de jiang shu ju zheng he dao shu ju cang ku zhong , zhe yang ni jiu ke yi kuo zhan he guan li bu duan zeng chang de shu ju liang he yong hu shu liang 。 1. you hua ETL guo cheng shu ju cang ku yi ban tong guo ETL guo cheng cong shu ju yuan xi tong huo de de shu ju jin xing zu zhuang he geng xin 。 zai shu ju zui chu jia zai dao shu ju cang ku zhong zhi hou , hui ding qi de shua xin yuan xi tong de xin de he geng gai de shu ju , yi que bao shu ju cang ku de shu ju shi zui xin de 。 SQL Server ji cheng fu wu ti gong le yi ge quan mian de ping tai , ni ke yi shi yong ta cong bu tong de shu ju yuan xi tong ti qu shu ju , zuo suo yao qiu de ren he dui shu ju huo ta de jie gou he ge shi de zhuan huan , ran hou jia zai zhuan huan de shu ju dao shu ju cang ku zhong 。 zhi xing cha zhao lai pi pei cong shu ju yuan xi tong huo de de ji lu dao zai shu ju cang ku zhong de yi you de ji lu shi ETL guo cheng zhong de yi ge chang jian cao zuo , zai SQL Server 2008 zhong cha zhao de xing neng bei xian zhu de ti gao le , yi zhi yu zhe xie cao zuo kuo zhan dao da xing biao 。 wei le bang zhu gen zong shu ju bian hua he que bao shu ju cang ku yi zhi xing ,SQL Server 2008 tui chu le bian hua shu ju bu huo (Change Data Capture,CDC) gong neng , jiang geng xin ji lu zai bian geng biao zhong , zhe shi de hen rong yi biao shi bei geng gai de xing he que ding geng gai de xi jie yi ji geng gai de yuan yin 。 2. you xiao de guan li ying jian zi yuan tong guo dui shu ju ya suo de zhi chi ,SQL Server 2008 shi ni ke yi geng you xiao di cun chu ni de shu ju he jiang di cun chu cheng ben 。 ling wai , ya suo ming xian de ti gao le da xing de ju you shu ru / shu chu xian zhi de gong zuo fu zai de xing neng 。SQL Server 2008 huan wei bei fen ya suo ti gong le ben di zhi chi ji kai ji yong 。 ci wai ,VARDECIMAL shu ju lei xing he SQL Server 2008 zhong de xin de xi shu lie tong guo jiang di da xing biao ( zhe xie biao ru zai shu ju cang ku suo chang jian de , zhu yao wei shu zi huo kong zhi ) suo xu yao de kong jian shu liang lai bang zhu ni cong ni de ci pan cun chu zi yuan huo de zui hao de xiao lv 。 chu le zai shu ju cun chu fang mian de xiao lv ,SQL Server 2008 huan zhi chi yang she nei cun de di zhi chuang kou kuo zhan (Address Windowing Extensions,AWE) de dong tai fen pei , ta zhi chi Windows Server 2003、 shu ju zhong xin ban (Datacenter Edition) de 64GB nei cun 、 he 64 wei ban ben de 2TB nei cun , lai zhi chi da xing shu ju cang ku huan jing 。 SQL Server 200 huan tui chu le zi yuan jian kong qi , ta shi de guan li yuan ke yi wei bu tong de gong zuo fu zai ding yi zi yuan xian zhi he you xian quan , yi bian shi bing fa gong zuo fu zai ke yi ti gong wen ding de zhi xing , bing shi de ke yi yu xian de guan li zi yuan jing zheng wen ti 。 3. you hua shu ju ku xing neng SQL Server 2008 bao kuo gao xing neng de guan xi shu ju ku yin qing , ta shi de ni ke yi jian li gao xiao de shu ju cang ku jie jue fang an 。 chuang xin ( li ru yong yu star schema( xing xing mo shi ) he gong ju de cha xun you hua bang zhu ni tiao zheng suo yin he shu ju jie gou ) shi de SQL Server wei jing chang cha xun de shu ju cang ku zi dong xuan ze , tong shi zai SQL Server 2008 zhong tui chu le MERGE Transact-SQL yu ju , kai fa ren yuan ke yi geng you xiao di chu li pu tong de shu ju cang ku chang jing , li ru jian cha yi xing shi fou cun zai ran hou zhi xing cha ru huo geng xin 。 ci wai , dui GROUP BY tiao jian yu ju jin xing le kuo zhan , shi de yong hu ke yi zai yi ge cha xun zhong ding yi duo ge zu 。Grouping Set sheng cheng le yi ge dan du de jie guo ji , zhe yu dui bu tong fen zu de xing zhi xing UNION ALL cao zuo shi deng jia de , ta shi de ju he cha xun he sheng cheng bao biao geng jia rong yi he kuai su 。 SQL Server 2008 zhi chi fen qu biao , bang zhu ni you hua da xing biao de xing neng he guan li , you le dui fen qu biao bing xing de xin de zhi chi , ni ke yi tong guo shi yong fen qu biao xian zhu de you hua yi ge shu ju cang ku 。 guan li fu duo de shang ye zhi neng jie jue fang an sui zhe gong si dui fu duo fen xi ri yi zeng chang de xu qiu , dui neng gou kuai su de jian li he ti jiao you xiao de shang ye zhi neng jie jue fang an , bing neng jiang di ni de shang ye zhi neng ji chu she shi de guan li fei yong de yao qiu , cheng wei le yi ge zhu yao yao kao lv de shi xiang 。SQL Server 2008 bao han chuang xin de gong ju , zhe xie gong ju ti gao le kai fa ren yuan de xiao lv he guan li neng li , ta shi de ke yi geng kuai de cong xin de fen xi he sheng cheng bao biao neng li huo de shou yi , tong shi shi de guan li fei yong jiang di le 。 yi 、 kai fa ren yuan sheng chan li SQL Server 2008 jian hua le shang ye zhi neng jie jue fang an de kai fa guo cheng 。 shang ye zhi neng kai fa ren yuan shou yi yu yi shi yong de gong neng he gong ju , zhe xie gong neng he gong ju zeng jia le kong zhi he zi dong jin xing li xing cao zuo 、 hao shi de ren wu , bing ke yi shi yong SQL Server 2008 de gao xiao de te xing geng kuai su de chuang jian gao xiao de fen xi he bao biao jie jue fang an ; zhe yang ni de gong si hen kuai jiu ke yi li yong ta men 。 1. shi yong yi ge feng fu de 、 xian dai de bian cheng huan jing tong guo yu Microsoft Visual Studio de jin mi xie tong gong zuo , kai fa ren yuan ke yi qing song di jian li he wei hu qiang da de 、 an quan de 、 ke kuo zhan de shang ye zhi neng jie jue fang an 。SQL Server shang ye zhi neng kai fa tao jian ti gong le yi ge dan du de gong ju , ta han gai le duo ge shang ye zhi neng jie jue fang an lei xing , bing wei kai fa ETL、 fen xi he bao biao jie jue fang an ti gong le yi ge dan du de 、 wen ding de huan jing 。 zuo wei shang ye zhi neng kai fa tao jian de yi bu fen tui chu de zhi jie de shang ye zhi neng xiang dao , shi de shen zhi chu ji kai fa ren yuan ye neng hen rong yi de jian li gao ji de shang ye zhi neng mo xing he xiang mu 。 tong guo zai shu ju ku yin qing zhong qian ru gong gong yu yan yun xing shi ,SQL Server 2008 shi kai fa ren yuan ke yi cong xu duo yu yan zhong xuan ze yong yi kai fa ying yong cheng xu , bao kuo Transact-SQL、Visual Basic he C#。 zhe ge ling huo de huan jing shi de kai fa ren yuan ke yi shi yong ta men xian you de ji neng you xiao de kai fa shu ju ku ying yong cheng xu 。 dang yu Visual Studio ji cheng shi , zai suo you de SQL Server 2008 shang ye zhi neng ji shu de kai fa ti yan zai ti gong yi ge zhen shi de ying yong cheng xu kai fa huan jing yong yi zhi chi zheng ge kai fa sheng ming zhou qi ( kai fa 、 ce shi 、 bu shu he ce shi ) fang mian shi zui jia de 。 2. shi xian zui jia fang fa jie jue fang an ran er , zhi you you hua she ji le zhe xie jie jue fang an cai neng shi kai fa ren yuan neng gou geng kuai di jian li jie jue fang an 。 wei le bang zhu que bao zui jia de xing neng he zheng que de gong neng ,SQL Server 2008 bao han le xia mian de kai fa huan jing te xing , ta men cu jin wan cheng zui hao de shi jian he bang zhu kai fa ren yuan chuang jian you xiao de fen xi jie jue fang an : yi ge yong yu suo you de shang ye zhi neng jie jue fang an de wen ding de kai fa huan jing , bao kuo fen xi fu wu 、OLAP、 he shu ju wa jue ying yong 。 nei zhi de dui zheng ge kai fa sheng ming zhou qi de zhi chi , bao kuo she ji 、 jian li 、 tiao shi 、 he bu shu cao zuo ; bing tong guo ji cheng de dui yuan kong zhi de zhi chi lai zhi chi tuan dui kai fa 。 yi xie zhi jie de she ji qi he xiang dao , shi de hen rong yi kuai su de chuang jian fen xi fu wu jie jue fang an 。 yi ge shu xing guan xi she ji qi , ta bao kuo nei zhi de yan zheng yong yi bang zhu chuang jian zui jia de wei du she ji 。 yi ge wei du bian ji qi , ta bei jing jian yi ti gong geng hao de xiao lv , bing qie hui zi dong jian ce dao shi fou cun zai fu zi guan xi 。 yi ge li fang ti she ji qi ye bei liu xian hua he jin xing le gai jin , yi ti gong geng hao de jian ce xing he shu xing de fen lei , huan you bian bie cheng yuan shu xing 。 dan du fen qu de ju he , ta shi de ni ke yi you hua bu tong jie duan huo bu fen de ce liang 。 ju he she ji qi you yi ge xin de suan fa , ta bang zhu chuang jian zui chu de ju he 。 zhe ge ju he she ji qi zai shi yong yong fa qu dong ju he fang mian shi zui jia de 。 ni xian zai ke yi cha kan chuang jian de ju he he tian jia huo shan chu ju he 。 ti gong le zhi neng zhi chi yi bang zhu he bing xian you de he xin de ju he she ji 。 ci wai ,SQL Server 2008 ti gong le AMO jing gao lai ti xing kai fa ren yuan dang ta men de she ji po huai le 40 duo ge zui jia fang fa li de yi ge de shi hou 。 zhe xie jing gao ji cheng dao le shi shi she ji qi jian cha zhong , bing wei kai fa ren yuan jian ce ta men de she ji de qian zai wen ti ti gong le yi ge fei qin ru shi de fang fa 。 3. ti gao bao biao ling huo xing bao biao shi ren he shang ye zhi neng jie jue fang an zhong de yi ge chong yao de zu cheng bu fen , er shang ye yong hu zheng zai bu duan de yao qiu geng fu duo de bao biao 。SQL Server bao biao fu wu ti gong le yi xia gong neng shi de hen rong yi jian li bao biao jie jue fang an : yi ge zai shang ye zhi neng kai fa tao jian zhong de ji yu Visual Studio de bao biao kai fa jie kou , kai fa ren yuan ke yi yong ta jian li 、 tiao shi he bu shu bao biao 。 yi ge jiao zuo Report Builder de zhuan zhu yu shang ye de bao biao kai fa gong ju , shang ye yong hu ke yi yong ta lai chuang jian he bu shu bao biao 。 shu ju xian shi jie gou fan wei kuan guang , bao kuo biao 、 ju zhen 、 lie biao he tu biao 。 ci wai ,SQL Server 2008 bao kuo le dui bao biao fu wu de ji da zeng qiang , ta gai jin le bao biao xing neng he ti gao le ge shi hua he fa bu bao biao de ling huo xing 。 zai SQL Server 2008 zhong dui bao biao fu wu zuo de gai jin zhi yi shi zhi chi yi ge xin de xian shi jie gou , zhe ge xin de xian shi jie gou jie he le biao he ju zhen shu ju dao yi ge xin de Tablix shu ju qu yu li 。Tablix shi kai fa ren yuan ke yi sheng cheng jie he le gu ding de xing he dong tai de xing de bao biao 。 yi qian , zhe zhong lei xing de xian shi xu yao tong guo duo ge ju zhen shu ju he suo duan shu ju xing de tou cai neng xian shi chu lai 。 dui Tablix shu ju lei xing de zhi chi jian hua le bao biao bao han jing tai he dong tai shu ju de jie he , bing qie xian zhu de kuo zhan le bao biao fu wu ge shi hua he xian shi neng li 。 er 、 yi guan li tong guo chuang xin ( li ru tong yi de guan li gong ju ) jia qiang le zi wo tiao zheng de neng li , er yi ge qiang da de guan li bian cheng mo xing ,SQL Server 2008 kuo zhan le SQL Server yi shi yong de ling xian di wei he ti gao le shu ju ku guan li yuan men (DBA) de xiao lv 。 zhe xie zeng qiang shi de shu ju ku guan li yuan men zhuan zhu yu gao jia zhi de ren wu , xiang shu ju ku jia gou , tong shi hua fei jiao shao de shi jian zuo li xing wei hu 、 pei zhi he tiao zheng 。 1. shi yong yi ge dan du de 、 tong yi de gong ju SQL Server 2008 ti gong gei shu ju ku guan li yuan SQL Server guan li tao jian ; yi ge dan du de 、 tong yi de guan li gong ju , ta tong guo yong yu zai kuo zhan de SQL Server gong ju zhong zeng qiang le de shu ju ku guan li yuan xiao lv 、 ling huo xing he guan li neng li de xiang tong de jie kou , wei ti gong le fen xi fu wu 、 bao biao fu wu he duo ge SQL Server de ban ben de ji cheng guan li 。 2. jian kong shu ju cang ku zi yuan SQL Server 2008 huan bao kuo xing neng tao jian , ta ti gong le yi ge ji zhong de yong yu jian kong he bao gao ni de shu ju fu wu jie jue fang an zhong de zi yuan shi yong qing kuang de guan li gong ju 。 san 、 qi ye ke kuo zhan xing ling yi ge yu cheng gong de sheng cheng fu duo de shang ye zhi neng jie jue fang an xiang guan de guan jian yin su yao qiu shen zhi zai zui da kuo zhan xia de chi xu xing de kai fa ren yuan xiao lv he guan li neng li 。 er qie , ji chu she shi bi xu ti gong yu xing neng xiang guan de ke kuo zhan neng li , zhe zai SQL Server 2008 zhong zuo le da liang de tou ru , zhe xie tou ru guan zhu yu que bao shen zhi zai shang ye zhi neng zhi xing de zui da kuo zhan xia de zhe ge qi ye ji de chi xu xing 。 1. ke kuo zhan de fen xi lian ji fen xi chu li (OLAP) de qian ti shi dui zhun que de xin xi de ji shi fang wen , zhe shi de zhong duan yong hu ke yi xun su di hui da zui fu duo de wen ti 。 yin ci , yao zuo dao hen hao de ti gong geng kuai de cha xun shi jian he shu ju shua xin su du shi ren he Microsoft SQL Server fen xi fu wu ban ben de kai fa guo cheng zhong suo you xian kao lv de , ta ye cu shi chan sheng le SQL Server 2008 fen xi fu wu ban ben 。 SQL Server 2008 bao kuo shi ni neng gou cai yong zeng qiang de neng li zuo geng guang de fen xi de fen xi fu wu , bao kuo fu duo de ji suan he ju he 。 fen xi fu wu tong guo yi xia fang mian ti gong le qi ye ji de xing neng : yi ge ling huo de huan cun mo xing 。 you le fen xi fu wu , ni ke yi kong zhi shu ju he ju he zen yang huan cun lai you hua cha xun xing neng , tong shi jiang huan cun he ta de lai yuan de shu ju cun chu zhi jian de fan ying shi jian wei chi zai yi ge ke jie shou de ji bie 。 sheng ming shu xing guan xi 。 zai yi ge fen xi fu wu wei du zhong , ni ke yi ming que de sheng ming zai yi ge ceng ji zhong de shu xing de guan xi 。 zhe shi de dang chu li yi ge li fang ti huo wei du shi , fen xi fu wu neng gou yu xian sheng cheng ju he , zhe gai jin le yun xing shi cha xun xing neng 。 kuai ji suan 。 kuai ji suan shan chu le bu bi yao de ju he ji suan ( li ru , dang yao ju he de zhi wei NULL de shi hou ), bing ti gong le yi ge zai fen xi li fang ti xing neng fang mian de xian zhu ti gao , zhe shi de yong hu ke yi zeng jia ta men de ceng ji shen du he ji suan de fu duo du 。 hui xie dao MOLAP。 fen xi fu wu 2008 shan chu le dang zhi xing hui xie shi dui cha xun ROLAP fen qu de yao qiu , zhe shi de qi ji da de ti gao le xing neng 。 kuo zhan fen xi fu wu 。 fen xi fu wu shu ju ku de yi ge dan du de zhi du kao bei tong guo yi ge xu ni de ip di zhi ke yi zai duo ge fen xi fu wu qi jian gong xiang 。 zhe wei fen xi fu wu jie jue fang an ti gong le yi ge gao du ke kuo zhan de kai fa xuan xiang 。 zhi xing ji hua chi jiu xing 。SQL Server 2008 ti gong le zhi ding cha xun ji hua de gong neng , yi bian zui da cheng du de kuo zhan zheng que xing de ke neng , cha xun ji hua bu hui shou fu wu qi chong qi 、 fu wu qi geng xin he chan pin bu shu ying xiang 。 zhe que bao le dui SQL Server shu ju cha xun de wen ding de zui jia xing neng 。 2. ke kuo zhan de sheng cheng bao biao dui yu da duo shu gong si lai shuo , zai zheng que de shi jian gei zheng que de yong hu yi zheng que de xin xi shi yi ge hen da de tiao zhan 。SQL Server 2008 ti gong le yi ge gao xing neng de bao biao yin qing yong yu chu li he ge shi hua bao biao , tong shi huan ti gong le yi tao gong ju yong yu chuang jian 、 guan li he cha kan bao biao 。 yi ge ke kuo zhan de jia gou he kai fang de jie kou shi de ke yi hen rong yi de zai bu tong de IT huan jing zhong ji cheng bao biao jie jue fang an 。 ni ke yi cong duo ge bu tong de shu ju yuan sheng cheng bao biao , bao kuo SQL Server、DB2 he Oracle, er bu xu yao xian jian li yi ge ji zhong de shu ju cang ku 。 ni ke yi tong guo bao biao fu wu ti gong de jian dan de bu shu he pei zhi neng li zai gong si nei wai fa song bao biao 。 zhe shi de yong hu ke yi qing song de chuang jian he fen xiang ren he gui mo huo fu duo du de bao biao 。 ni huan ke yi tong guo wang luo lai bu shu bao biao , jiang qi qing song de fa song gei ke hu he gong ying shang 。 bao biao fu wu ti gong le dui kong zhi fu wu qi huo dong de zhi chi he neng li , zhe xie huo dong bao kuo nei cun guan li 、 ji chu she shi he bing he tong guo yi ge ji zhong de cun chu he yi ge yong yu suo you de pei zhi she zhi de API de jian dan de pei zhi 。 kuo zhan ni de shang ye zhi neng jie jue fang an de fan wei guo qu , shang ye zhi neng jie jue fang an zhi bei shao shu shang ye fen xi shi shi yong 。 xian zai , yue lai yue duo de gong si ren shi dao ta men ke yi cong kuo zhan ti gong gei suo you gu yuan shang ye zhi neng shi fei chang you yong de dong cha li he jiang zhe xie dong cha li nei zhi dao ri chang de ye wu cao zuo zhong huo de shou yi 。 SQL Server 2008 shi ni ke yi tong guo yi ge ke kuo zhan de 、 kai fang de he ke nei zhi de jia gou , chuang jian yi ge ke yi kuo zhan dao shu qian ming yong hu , bing qie gei suo you ren yi ge feng fu de yong hu ti yan de shang ye zhi neng jie jue fang an , zhe ge jia gou yu Microsoft Office xie zuo shi yong shi zui jia de 。 yi 、 tong guo shu xi de gong ju kuo zhan shang ye dong cha li Microsoft Office Microsoft Office cheng wei le pu bian shi yong de gao xiao de tao jian , quan qiu fan wei de gong si li de da duo shu xin xi gong zuo ren yuan shi yong ta lai zhi xing ta men ri chang de gong zuo 。 tong guo yu Office de jin mi ji cheng ,SQL Server 2008 shi ni neng gou ti gong gei ni de gu yuan yi ta men suo xu yao de guan jian de shang ye xin xi 。 2007 Microsoft Office he Microsoft Office PerformancePoint Server 2007 de jin mi ji cheng shi de gong si ke yi tong guo shi yong jie he shi yong hen hao de ji shu lai jie sheng shi jian he jin qian 。 tong guo cai yong shu xi de yi jing an zhuang zai mei ge zhuo shang ji suan ji de gong ju gei suo you ren ti gong shang ye dong cha li , zhe ge ji cheng huan shi de ke yi geng kuai de huo de kuo da zhong duan yong hu fang mian de tou zi hui bao 。 1. shi yong Microsoft Office kuo zhan ni de bao biao jie jue fang an bao biao fu wu 2008 zhi chi dui Microsoft Excel he Microsoft Word ge shi de xuan ran 。 xuan ran de bao biao zai yi yu shi yong de Microsoft Office ying yong zhong shi wan quan ke yi bian ji de , zhe kuo zhan le ni de bao biao jie jue fang an , yi bian yong hu ke yi chuang jian ding zhi de ji yu shang ye bao biao de wen dang 。 2. jiang Excel yong yu fen xi Excel shi xu duo jin rong he shang ye fen xi gong zuo ke yi xuan ze de gong ju 。 tong guo jiang Excel tong SQL Server fen xi fu wu xiang jie he , ni ke yi tong guo zai Excel dian zi biao ge zhong de PivotTable dong tai shi tu he Microsoft PivotChart dong tai shi tu ti gong gei shang ye yong hu qiang da de OLAP jie jue fang an 。 ni huan ke yi shi yong yong yu Excel 2007 de SQL Server shu ju wa jue cha jian , shi shang ye fen xi shi he zhu guan ke yi liu lan shu ju wa jue xiang mu de zheng ge sheng ming zhou qi , bao kuo zhun bei shu ju 、 jian li 、 ping gu , he guan li wa jue mo xing , bing tong guo shi yong dian zi biao ge shu ju huo tong guo ni de fen xi fu wu shu ju ku ke yi fang wen dao de wai bu de shu ju lai yu ce jie guo 。 3. gei zheng ge qi ye fa bu shang ye dong cha SQL Server 2008 yu SharePoint Services jin mi ji cheng , shi de hen rong yi zai yi ge SharePoint zhan dian zhong ji zhong di fa bu he guan li bao biao , bing jian li yong hu zhi ding de yi biao pan , zhe ge yi biao pan ti gong le xiang guan bao biao de ke ding zhi shi tu 。 ci wai ,Microsoft Office PerformancePoint Server ti gong le yi ge ji zhong de jie kou , zhe ge jie kou yong yu jian li zai SQL Server fen xi fu wu ji chu shang de shu ju fen xi , ta shi de ke hu ke yi jian kong 、 fen xi 、 he ji hua ta men de ye wu , huan ke yi cu jin xie zuo he ti gong dui zheng ge gong si de quan mian de dong cha 。 er 、 shi zhong duan yong hu ke yi ling huo de zhi zuo bao biao SQL Server 2008 ti gong le yi xie bao biao gai jin , shi ni ke yi kuai su qie qing song de sheng cheng ni gong si xu yao de bao biao , bing qie shi yi ni xiang yao de ge shi he neng chong fen xian shi ta men suo bao han de shu ju de xian shi xing shi 。 1. shi yong Report Builder chuang jian ji xi bao biao zai SQL Server 2008 zhong Report Builder bei ji da de zeng qiang le , shi de yong hu ke yi qing song de jian li ren he jie gou de ji xi bao biao 。 zhe ge zhi jiao she ji jie kou shi de fei kai fa ren yuan ke yi qing song de chuang jian shang ye wen dang , li ru ji yu bao biao shu ju de ding dan 、 fa huo he he tong 。 2. bao kuo feng fu de ge shi hua shu ju feng fu de ge shi hua ke yi geng zhi jiao de zhi zuo shang ye wen dang he bao biao , bing shi ta men fei chang yi dong 。SQL Server 2008 de zhe ge feng fu de wen ben zu jian shi de ke yi shi yong hun he ge shi de wen ben kuang he dao ru biao ji de wen ben zi fu chuan , bing zhi chi xin de tu biao ge shi he Tablix shu ju , yi bian yong hu ke yi sheng cheng ju you gao du ke shi hua she ji de bao biao , shi de ke yi chuan da qing xi de he luo ji jiao qiang de shang ye xin xi 。 3. shou yi yu geng kuai de xiang ying sui zhe gong si geng duo de cai yong bao biao lai chuan di shang ye xin xi , que bao ni de bao biao jie jue fang an de xing neng he ke kuo zhan xing da dao zui gao jiu bian de geng wei chong yao le 。SQL Server 2008 zhong de bao biao fu wu yin qing bei chong xin she ji , yong lai jie jue mu qian de ju xian xing , xian zai ta bao kuo an xu chu li he ji yu shi li de xuan ran , yong yi ti gong zui hao de bao biao xing neng 。 4. zai wang luo shang an quan de bu shu bao biao SQL Server 2008 tong guo zai wang luo shang an quan di fa bu bao biao shi ni ke yi kuo zhan ni de bao biao fu wu jie jue fang an de fan wei , jiang qi chuan di gei wai bu de yong hu , li ru ke hu he gong ying shang 。 zong jie SQL Server 2008 jian li zai shang ye zhi neng shi chang zhong de qiang da yao su ji chu zhi shang , ti gong yi ge ke kuo zhan de ji chu she shi , shi de xin xi ji shu ke yi zai ni de gong si zhong shi shi shang ye zhi neng , bing zai yong hu xu yao de shi hou wei qi ti gong shang ye zhi neng 。SQL Server 2008 zai shu ju cang ku fang mian ju you hen da de jin bu , ta ti gong le yi ge quan mian de he ke kuo zhan de ping tai , shi de gong si ke yi geng kuai de jiang shu ju zheng he dao shu ju cang ku zhong , bing kuo zhan he guan li shu ju , tong shi wei suo you yong hu ti gong dong cha li 。 you le SQL Server 2008 suo ti gong de geng ke kuo zhan de shang ye zhi neng ji chu she shi , jiu ke yi qing song de guan li ren he gui mo he fu duo du de bao biao he fen xi , tong shi shi yong hu ke yi yu Microsoft Office zuo geng shen de ji cheng 。SQL Server 2008 huan gai jin le xu duo fang mian de xing neng , bao kuo shu ju cang chu 、 sheng cheng bao biao he fen xi 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
我们约会吧
漂亮白皙的模特
好纯好美的女生
靓丽的网络美女
痞子的甘南日记
疑是银河落九天
雪域坝上四——纯美色
冬日恋歌——西城杨柳弄轻柔
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有