Research And Application Of Online Query System Based On Multi-Dimensional Data Model

Based on the decision support system of taxis in Beijing, the paper makes a relatively comprehensive and deep analysis and study of the subject of taxis'operation data by using relevant techniques of data warehouse and OLAP muti-dimensional analysis. The paper designs an on-line query system based on the multi-dimensional data model which takes operation data as the subject.The paper first introduces the history of the development of the query system, the relevant techniques, and the status quo of the domestic and overseas development of the system. Then, the paper gives a detailed analysis of the range of the subject, selecting the measure value and the problem analysis angle (dimension) of the multi-dimensional data model. Based on a detailed analysis of the requirements of the users, the paper, by adopting the storage method of MOLAP mode, designs the query system that is based on multi-dimensional data model with simple operation and clear dimensional structure.