course4資訊系統(tǒng)在實(shí)務(wù)上的應(yīng)用(文件)
【正文】 aphics ? There are two approaches to OLAP (Figure ): 1. 關(guān)連式線上分析系統(tǒng) ROLAP (for relational online analytical processing) that utilizes a standard relational DBMS 2. 多維度線上分析系統(tǒng) MOLAP (for multidimensional online analytical processing) that utilizes a special multidimensional DBMS 39 40 ROLAP and MOLAP ? Both OLAP types include a data warehouse server and a second server that houses OLAP software ? A major difference is that the MOLAP workstation includes a downloaded multidimensional database ? The data in this database has already been formatted in various dimensions so that it may be made available quickly rather than go through timeconsuming analyses ? Figure illustrates a report that is the type that ROLAP can easily prepare ? MOLAP can produce information in many dimensions ? Figure illustrates a summary report in four dimensions: store type, product, age, and gender 41 42 43 資料探勘 DATA MINING ? Data mining is the process of finding relationships in data previously unknown to the user ? Data mining helps users discover relationships and present them in an understandable way so the relationships can be used in decision making ? The two basic data mining techniques are: ? Hypothesis Verification where data is used to test theories ? Knowledge Discovery in which users search for mon characteristics within the data 。s daily operations and produce a database used by other firm systems ? A related application is Customer Relationship Management (CRM) ? CRM uses data warehousing, meaning data accumulates over time and can retrieved for use in decision making 3 THE TRANSACTION PROCESSING SYSTEM ? This term TPS is used to describe the IS that gathers data describing the firm’s activities, transforms the data into information, and makes the information available to users both inside and outside the firm ? Figure is a model of a TPS where data is gathered from the firm’s physical system and environment, and entered into
試題試卷相關(guān)推薦
鄂ICP備17016276號(hào)-1