Multidimensional Data Model Research for Data Mart Based Analysis System of Drilling Fluid

For the sake of complex analysis requirements of drilling fluid analysis system, this paper proposes a multidimensional data model and implement the solution of data mart due to the analyzing weaknesses of conventional information system. Since the database system is only applied to undertake the daily manipulating application of raw data, and supports simple works of search and statistic, however, the data mart which is enable users to retrieval and exchange raw business data from homologous source databases, setups multidimensional data model for providing a considerable analysis circumstance to decision-makers that fills users' complex analysis requirements. This paper has taken “drilling fluid efficiency analysis” as a typical case, and illustrated the method of data mart implementation through applying multidimensional data model.