%0 Journal Article
%T Design and Application of Enterprise Data Warehouse Based on SQL Server 2000<br>基于SQL Server2000的企业数据仓库设计与应用
%A ZHONG Yuan-Chang LI Gang WANG Yue YANG Wu
%A <br>仲元昌
%A 李刚
%A 王越
%A 杨武
%J 计算机科学
%D 2003
%I 
%X To make up the shortage of current database in information distilling, we need to integrate mass data indata warehouse so that it can offer better reference to business manage and decision-making for enterprise. By using relational database SQL Server 2000 of Microsoft as resolution scheme of data warehouse, an enterprise datawarehouse with star schema is established. Data cubes are constructed and measures are calculated by Analysis Services tools in SQL Server ,and these cubes are online analyzed through OLAP, then user can easily get relationship of data or attributes which can provide reference to their business, and utilize data in existence fully and effectively.
%K Data warehouse
%K Star schema
%K Cube
%K OLAP<br>SQLServer2000
%K 企业数据仓库
%K 设计
%K 数据集合
%K 数据分析
%K 企业数据库
%U http://www.alljournals.cn/get_abstract_url.aspx?pcid=5B3AB970F71A803DEACDC0559115BFCF0A068CD97DD29835&cid=8240383F08CE46C8B05036380D75B607&jid=64A12D73428C8B8DBFB978D04DFEB3C1&aid=0F35390C8C697D35&yid=D43C4A19B2EE3C0A&vid=340AC2BF8E7AB4FD&iid=59906B3B2830C2C5&sid=08805F9252973BA4&eid=BB0EA31DB1B01173&journal_id=1002-137X&journal_name=计算机科学&referenced_num=8&reference_num=6