SQL ServerÊý¾Ý²Ö¿âÏà¹Ø¸ÅÄî ά¶È±íºÍÊÂʵ±í¸ÅÊö
SQL ServerÊý¾Ý²Ö¿âÏà¹Ø¸ÅÄî-ά¶È±íºÍÊÂʵ±í¸ÅÊö ÊÕ²Ø
¿ªÊ¼Ñо¿BI£¬³õѧ¡£»á¼Ç¼һЩ¸ÅÄîÐÔµÄÎÄÕ¡£
»ù±¾¸ÅÄ
1.¶àάÊý¾Ý¼¯£º¶àάÊý¾Ý¼¯ÊÇÁª»ú·ÖÎö´¦Àí (OLAP) ÖеÄÖ÷Òª¶ÔÏó£¬ÊÇÒ»Ïî¿É¶ÔÊý¾Ý²Ö¿âÖеÄÊý¾Ý½øÐпìËÙ·ÃÎʵļ¼Êõ¡£¶àάÊý¾Ý¼¯ÊÇÒ»¸öÊý¾Ý¼¯ºÏ£¬Í¨³£´ÓÊý¾Ý²Ö¿âµÄ×Ó¼¯¹¹Ô죬²¢×éÖ¯ºÍ»ã×ܳÉÒ»¸öÓÉÒ»×éά¶ÈºÍ¶ÈÁ¿Öµ¶¨ÒåµÄ¶àά½á¹¹¡£
2.ά¶È£ºÊǶàάÊý¾Ý¼¯µÄ½á¹¹ÐÔÌØÐÔ¡£ËüÃÇÊÇÊÂʵÊý¾Ý±íÖÐÓÃÀ´ÃèÊöÊý¾ÝµÄ·ÖÀàµÄÓÐ×éÖ¯²ã´Î½á¹¹(¼¶±ð)¡£ÕâЩ·ÖÀàºÍ¼¶±ðÃèÊöÁËһЩÏàËƵijÉÔ±¼¯ºÏ£¬Óû§½«»ùÓÚÕâЩ³ÉÔ±¼¯ºÏ½øÐзÖÎö¡£
3.¶ÈÁ¿Öµ£ºÔÚ¶àάÊý¾Ý¼¯ÖУ¬¶ÈÁ¿ÖµÊÇÒ»×éÖµ£¬ÕâЩֵ»ùÓÚ¶àάÊý¾Ý¼¯µÄÊÂʵÊý¾Ý±íÖеÄÒ»ÁУ¬¶øÇÒͨ³£ÎªÊý×Ö¡£´ËÍ⣬¶ÈÁ¿ÖµÊÇËù·ÖÎöµÄ¶àάÊý¾Ý¼¯µÄÖÐÐÄÖµ¡£¼´£¬¶ÈÁ¿ÖµÊÇ×îÖÕÓû§ä¯ÀÀ¶àάÊý¾Ý¼¯Ê±Öصã²é¿´µÄÊý×ÖÊý¾Ý¡£ÄúËùÑ¡ÔñµÄ¶ÈÁ¿ÖµÈ¡¾öÓÚ×îÖÕÓû§ËùÇëÇóµÄÐÅÏ¢ÀàÐÍ¡£Ò»Ð©³£¼ûµÄ¶ÈÁ¿ÖµÓÐ sales¡¢cost¡¢expenditures ºÍ production count µÈ¡£
4.ÔªÊý¾Ý£º²»Í¬ OLAP ×é¼þÖеÄÊý¾ÝºÍÓ¦ÓóÌÐòµÄ½á¹¹Ä£ÐÍ¡£ÔªÊý¾ÝÃèÊö OLTP Êý¾Ý¿âÖÐµÄ±í¡¢Êý¾Ý²Ö¿âºÍÊý¾Ý¼¯ÊÐÖеĶàάÊý¾Ý¼¯ÕâÀà¶ÔÏ󣬻¹¼Ç¼ÄÄЩӦÓóÌÐòÒýÓò»Í¬µÄ¼Ç¼¿é¡£
5.¼¶±ð£º¼¶±ðÊÇά¶È²ã´Î½á¹¹µÄÒ»¸öÔªËØ¡£¼¶±ðÃèÊöÁËÊý¾ÝµÄ²ã´Î½á¹¹£¬´ÓÊý¾ÝµÄ×î¸ß(»ã×̶ܳÈ×î´ó)¼¶±ðÖ±µ½×îµÍ(×îÏêϸ)¼¶±ð¡£
6.Êý¾ÝÍÚ¾ò£ºÊý¾ÝÍÚ¾òʹÄúµÃÒÔ¶¨Òå°üº¬·Ö×éºÍÔ¤²â¹æÔòµÄÄ£ÐÍ£¬ÒÔ±ãÓ¦ÓÃÓÚ¹ØϵÊý¾Ý¿â»ò¶àά OLAP Êý¾Ý¼¯ÖеÄÊý¾Ý¡£Ö®ºó£¬ÕâЩԤ²âÄ£Ðͱã¿ÉÓÃÓÚ×Ô¶¯Ö´Ðи´ÔÓµÄÊý¾Ý·ÖÎö£¬ÒÔÕÒ³ö°ïÖúʶ±ðлú»á²¢Ñ¡ÔñÓлñʤ°ÑÎյĻú»áµÄÇ÷ÊÆ¡£
7.¶àά OLAP (MOLAP)£ºMOLAP ´æ´¢Ä£Ê½Ê¹µÃ·ÖÇøµÄ¾ÛºÏºÍÆäÔ´Êý¾ÝµÄ¸´±¾ÒÔ¶àά½á¹¹´æ´¢ÔÚ·ÖÎö·þÎñÆ÷¼ÆËã»úÉÏ¡£¸ù¾Ý·ÖÇø¾ÛºÏµÄ°Ù·Ö±ÈºÍÉè¼Æ£¬MOLAP ´æ´¢Ä£Ê½Îª´ïµ½×î¿ì²éѯÏìӦʱ¼äÌṩÁËDZÔÚ¿ÉÄÜÐÔ¡£×ܶøÑÔÖ®£¬MOLAP ¸ü¼ÓÊʺÏÓÚƵ·±Ê¹ÓõĶàάÊý¾Ý¼¯ÖеķÖÇøºÍ¶Ô¿ìËÙ²éѯÏìÓ¦µÄÐèÒª¡£
8.¹Øϵ OLAP (ROLAP)£ºROLAP ´æ´¢Ä£Ê½Ê¹µÃ·ÖÇøµÄ¾ÛºÏ´æ´¢ÔÚ¹ØϵÊý¾Ý¿âµÄ±í(ÔÚ·ÖÇøÊý¾ÝÔ´ÖÐÖ¸¶¨)ÖС£µ«ÊÇ£¬¿ÉΪ·ÖÇøÊý¾ÝʹÓà ROLAP ´æ´¢Ä£Ê½£¬¶ø²»ÔÚ¹ØϵÊý¾Ý¿âÖд´½¨¾ÛºÏ¡£
9.»ìºÏ OLAP (HOLAP)£ºHOLAP ´æ´¢Ä£Ê½½áºÏÁË MOLAP ºÍ ROLAP ¶þÕßµÄÌØÐÔ¡£
10.Á£¶È£ºÊý¾Ý»ã×ܵIJã´Î»òÉî¶È¡£
11.¾ÛºÏ|¾Û¼¯£º¾ÛºÏÊÇÔ¤ÏȼÆËãºÃµÄÊý¾Ý»ã×Ü£¬ÓÉÓÚÔÚÎÊÌâÌá³ö֮ǰÒѾ׼±¸Á˴𰸣¬¾ÛºÏ¿ÉÒԸĽø²éѯÏìӦʱ¼ä¡£
12.Çп飺Óɶà¸öάµÄ¶à¸ö³ÉÔ±ÏÞ¶¨µÄ·ÖÇøÊý¾Ý£¬³ÆΪһ¸öÇп顣
13.ÇÐƬ£ºÓÉÒ
Ïà¹ØÎĵµ£º
SQL Server 2005 ¾µÏñ¹¹½¨ÊÖ²á
Ò»¡¢ ¾µÏñ¼ò½é
1¡¢ ¼ò½é
Êý¾Ý¿â¾µÏñÊǽ«Êý¾Ý¿âÊÂÎñ´¦Àí´ÓÒ»¸öSQL ServerÊý¾Ý¿âÒƶ¯µ½²»Í¬SQL Server»·¾³ÖеÄÁíÒ»¸öSQL ServerÊý¾Ý¿âÖС£¾µÏñ²»ÄÜÖ±½Ó·ÃÎÊ;ËüÖ»ÓÃÔÚ´íÎó»Ö¸´µÄÇé¿öϲſÉÒÔ±»·ÃÎÊ¡£
Òª½øÐÐÊý¾Ý¿â¾µÏñËùÐèµÄ×îСÐèÇó°üÀ¨ÁËÁ½¸ö²»Í¬µÄSQL ServerÔËÐл·¾³¡£Ö÷·þÎñÆ÷± ......
SQL Server 2005 ¾µÏñ¹¹½¨ÊÖ²á(2)
3¡¢ ½¨Á¢¾µÏñ
ÓÉÓÚÊÇʵÑ飬ûÓÐΪ·þÎñÆ÷ÅäÖÃË«Íø¿¨£¬IPµØÖ·ÓëͼÓе㲻һÑù£¬µ«ÊÇÔÀíÒ»Ñù¡£
--Ö÷»úÖ´ÐУº
1ALTER DATABASE shishan SET PARTNER = 'TCP://10.168.6.45:5022';
--Èç¹ûÖ÷ÌåÖ´Ðв»³É¹¦£¬³¢ÊÔÔÚ±¸»úÖÐÖ´ÐÐÈçÏÂÓï¾ä£º
1ALTER DATABASE ......
--²âÊÔ±í
create table tb_month
(monthid varchar(2),mongthName varchar(50))
insert into tb_month
select '01','Ò»ÔÂ'
union all select '02','¶þÔÂ'
union all select '03','ÈýÔÂ'
union all select '04','ËÄÔÂ'
union all select '05','ÎåÔÂ'
union all select '06','ÁùÔÂ'
union all select '07','ÆßÔÂ'
......
The following is improved version of the code created by David Mullet, from
http://rubyonwindows.blogspot.com/2007/03/ruby-ado-and-sqlserver.html
require 'win32ole'
class SqlServer
# This class manages database connection and queries
attr_accessor :connection, :data, :fields
attr_wr ......
VS2005+SQL2005 ASP.NET2.0Êý¾Ý¿âÁ¬½Ó×ܽá
ͨ¹ýÉÏƪÎÄÕ£¨http://www.cnblogs.com/user34j/archive/2007/01/23/628426.html£©µÄÉèÖÃÆäʵÒѾ²î²»¶àÍê³ÉÁË£¬Ö»ÊÇ»¹ÓÐһЩϸ½ÚµÄµØ·½Ã»ÓÐ×öºÃ£¬¾¹ýÒ»·¬Ñо¿ÏÖÔÚÖÕÓڸ㶨ÁË¡£¶ÔÓÚÏñÎÒÕâÑùµÄÐÂÊÖÀ´Ëµ£¬Õû¸öÊý¾Ý¿âÁ¬½ÓÕæÊDz»ÈÝÒס£ÏÖ×ܽáÈçÏ£ ......