course4資訊系統(tǒng)在實(shí)務(wù)上的應(yīng)用-文庫吧資料
2025-05-19 01:38本頁面
【正文】 information, detailed information, and detailed data ? Figure shows the results of a drillacross navigation, producing outputs in different hierarchies 36 37 38 線上分析系統(tǒng) (ONLINE ANALYTCAL PROCESSING) ? OLAP is a type of software especially developed for data warehouses ? Using OLAP, users can municate with the data warehouse either through a GUI or Web interface, and quickly produce information in a variety of forms, including graphics ? 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, meanin
試題試卷相關(guān)推薦
鄂ICP備17016276號(hào)-1