| With the rapid development and wide application of the Science of Management and Computer Science, people pay great attention to the application of computer in the management field, which results in the concept of Decision Support System (DSS) gets more and more attractions. And now it has already become a quite pop research topic on System Engineering, the Science of Management, Artificial Intelligence and so on.Data warehousing and On-Line Analytical Processing (OLAP) are two of the significant new technologies in the business data processing and DSS arena. A data warehouse can be defined as a "very large" repository of historical data pertaining to an organization. OLAP refers to the technique of performing complex analysis over the information stored in a data warehouse. The complexity of queries required to support OLAP applications makes it difficult to implement using standard relational database technology. Moreover, there is currently no standard conceptual model for OLAP. There is clearly a need for such a model and an algebra for OLAP application.In this paper, we address this issue by proposing a model of a data cube and an algebra to support OLAP operations on this cube. The model we present OLAP Multidimensional Data Model (OMDDM), is simple and intuitive, and presents the features of OLAP such as multidimensionality, granularity, hierarchy and etc. In OMDDM, the algebra provides a means to concisely express complex OLAP quries using Structured Query Language (SQL) offered by MS SQL Server 6.5. in addition, OMDDM provides some algorithms for OLAP query processing such as Multi-Table Hash Join Algorithm. We introduce and study Data warehousing and build a data warehousing for OLAP application to Liang-Bai Computer Integration Manufacture System (LB C1MS). OLAP application to LB CIMS is based on OMDDM.In the end, this paper has detailedly discussed design and implementation of OLAP application to the business inventory Decision Support Systems.
|
PDF Full Text Request