1、附录 1 外文原文 Data warehouse technique The data warehouse says all The data warehouse is an environment, not a product. It provides the decision that customer used for current history data supports, these data is very difficult in traditional operation type database or cant get, say more tangibly, the d
2、ata warehouse is a kind of system construction. Data warehouse than it customer relation the management is a concept that is been familiar with by person, it is 1991 the United States an information engineering learns what house W.H. Inmon Doctor put forward, its definition is the data warehouse is
3、a support decision the process faces to the topic of, gather of, at any time but change of, the last long data gathers. The technique system construction of the data warehouse The data of obtains mold piece: Used for obtaining the data from the source document with the source database, combine the p
4、roceeding sweep, delivering, adding it to data warehouse database inside. Data management mold piece: Used for the movement of the management data warehouse. Delivers mold piece: Used for the other warehouse in direction with assign the data warehouse data in the exterior system. The data is in the
5、center a mold piece: The end customer in direction tool that used for the method provides the interview data warehouse database. Data interview mold piece: Used for providing the interview for the end customer of the business enterprise with the tool of the analysis data warehouse data. Design mold
6、piece: Used for the design data warehouse database. Information catalogue mold piece: Used for governor to provide with the customer relevant saving contents in data warehouse data in the database with meaning information. How to establish the data warehouse Current, the internal calculator in busin
7、ess enterprise system is mutually independent, the data rule( legitimacy) demand of the system that have is affirmed from the other system, various data lacks to gather sex, conduct and actions trend, the data warehouse technique is an one of the most emollient way to makes these data gathered get u
8、ps, the data warehouse establishes can at logical realize various system interaction operation, this lay the foundation for the modern college in developments, also leads for the college layer science decision offering guarantees powerfully. The process that establish in the data warehouse needs bel
9、ow step: 1. Establish the data model to the end business need. The design of the data model not only consider only to the first topic, but also looks after both sides the need of the other management in college decision topic to searches the need of the topic with every kind of data, statement. 2. T
10、he certain topic proceeding data sets up the mold. According to the decision need certain topic, choice data source, proceed logic construction design. 3. The database of the design data warehouse. Put great emphasis on the saving construction in physics that apply in the topic development data ware
11、house inside data. 4. Definition data source. According to the topic data model, choose different operation type database as the data source. 5. Establish the model for a data. The model made sure into the data scope of the data warehouse, and with provision of relevant data. Complete a data, can le
12、t customer known, the data warehouse inside has actually what data, the data gathers the level of structure with how detailed degree is, can provide what information, how these information are carried calculates with organizes etc. 6. Take( Extract), convert( Transmit), add from the operation type d
13、atabase inside take out the data that carry( Load) the database inside arrive the data warehouse. 7. Choice data interview analysis tool, the customer will use the saving information within these toolses interview data warehouse, realizing decision support need. The data scoops out the technique Alo
14、ng with the database technical develop continuously and extensive application in each profession in system in management in database, the backlog enlarges in the nasty play in amount of data in the database, but among them can use directly however opposite less in amount of information. People have
15、been hoping can to conceal in the superficial information in these data, proceed many level of structures analyze, for the purpose of better land utilization acquire the benefit to operate in the business with these data, increase the information of the social competition ability. Current every kind
16、 of database management system although can realizes efficiently the data record into and search, statistics to wait the function, cant discover relation existed in the data with regulation, resulted in like this and then a kind of data Bang and knowledge needy keep both of phenomenon. According to
17、the inquisition, the data collections increase with saving with every year 130% speed, but in the data only have 2% data to is analyzed availably. This exploitation that scoop out provided the vast space for the data .To the 2004, apply to attain USD 1,000,000,000 in the data of the electronic commerce market of scooping out the tool.
