联机分析处理及其在商业自动化中的应用-控制理论及控制工程专业论文.docxVIP

重庆大学硕士学位论文 重庆大学硕士学位论文 Abs乜act Abstract Wnh lhe rapid development and wide application of the Science of Management and Computer Science，people pay great attention to the application of computef in the management field。which reSUIts in lhe concept of Decision Support System(DSS)gets more and more attractions．And nOW it has already become a qu施e pop research topic on System Engineering．the Science of ManagemenL Art隔cial Intelligence and SO on． Dala warehousing and On．Line Aria叭icaI Processing(OLAP)are two of the significant 13ew technologies in the business data processing and DSS arena．A data warehouse can be defined as a“very Iarge” 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 comple姗of queries required to support OL气P apptjc,ations makes it dH§culi幻implement using standard relafionaI database technology．Moreover,there iS currently no standard conce-ptual model for 0LAP．There iS dearly a need for such a modeI 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 ModeI(OMDDM)．is simple and Intuitive，and presents the features of OU驴such as multidimensionality,granularity,hierarchy and etc．1n OMDDM．the algebra provides a means to concisely express complex OUp qunes using Structured Query Language(SQ L)offered by MS SQL Server 6．5． In addRion，0MDDM 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 t0 Liang—Baj Computer Integration Manufacture System fLB CIMS)，OLAP application to LB ClMS iS based on OMDDM． In the end，this paper has detailedly discussed design and implementation of 0U妒application to the business inventory Decision Support Systems． KEY WORDS：