An Improved Multidimensional Query Language for Oil and Gas Development Data Warehouse

Multidimensional data analysis is the most central technique for processing data in data warehouse and On-Line Analysis Processing (OLAP). In order to solve the problem of multi-dimensional analysis expression and query processing in oil and gas development data warehouse, this paper proposes an improved multi-dimensional query language application method to realize effective interaction between query terminal and OLAP server. This formal language has the following advantages, such as simplicity, flexibility and easy to use. It also meets the needs of multi-dimensional query for oil and gas data analysis, and has various display modes. The results can be displayed in two-dimensional space. And it provides an extended function beyond the standard MDX, simple grammar format, concise and clear semantic expression, and is conducive to query processing conversion.