Settlement And Research Of Star Schema On Data Warehouse

Recently now,more and more corporations building OWll 1)BMS(Database Management System)in order to improve their competition in the economic market of the whole world．Use the computer system to collect,management and storage the information data,instead of the human handcraft for lnore efficiency than before．So the data warehouse is the useful and Dowerf_ul technology in the field of information,and this paper should discuss some idea and measure in the foctIS of itStar Schema on Data Warehouse is a new presentation format．And thestar schema on data warehouse is a multidimensional data relation．it isconsist of the fact table and group of the dimension table．In everydimension table,there has a dimension as the primary key,and all ofthese dimension are the component of the fact tables'primary key．Inother word,the every elements in the primary key of the fact table is the foreign key of the dimension table,not primary attribute in the fact table act as the fact,they are value or other data,such character and time．Design the information management system based on the star schema isour goals．It can execute,seek,update and OLAP search all kinds of theoperations．...