CN103399925A - Rainfall multidimensional analysis system based on hydrologic data and implementation method of rainfall multidimensional analysis system - Google Patents

Rainfall multidimensional analysis system based on hydrologic data and implementation method of rainfall multidimensional analysis system Download PDF

Info

Publication number
CN103399925A
CN103399925A CN 201310337191 CN201310337191A CN103399925A CN 103399925 A CN103399925 A CN 103399925A CN 201310337191 CN201310337191 CN 201310337191 CN 201310337191 A CN201310337191 A CN 201310337191A CN 103399925 A CN103399925 A CN 103399925A
Authority
CN
Grant status
Application
Patent type
Prior art keywords
analysis
data
rainfall
module
multidimensional
Prior art date
Application number
CN 201310337191
Other languages
Chinese (zh)
Inventor
万定生
尹涛
余宇峰
伏潜
Original Assignee
河海大学
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date

Links

Abstract

The invention discloses a rainfall multidimensional analysis system based on hydrologic data and an implementation method of the rainfall multidimensional analysis system. According to the system, a hydrologic data warehouse module organizes and integrates preprocessed hydrologic data, an analysis model building module is responsible for whole design and building of a rainfall multidimensional analysis model, a data service module responds to data requests of an analytical graph development module, the analytical graph development module enables a user to choose visual display and data presentation modes of analysis reports and graphs, and an application integration module provides the user drill-through, slicing and rotary multidimensional analysis functions. According to the method, the rainfall multidimensional analysis model is built, various analytical graphs are developed, integrated definition and release of the developed analytical graphs are carried out, an operation request of the user is submitted to the data service module, a specific database inquiry request is generated, corresponding aggregation calculation is carried out on data obtained through inquiry, and the analytical graph development module carries out formatting processing and visual presentation on the result data.

Description

一种基于水文数据的降雨多维分析系统及其实现方法 One kind of multidimensional analysis system based on hydrological data of rainfall and its implementation

[0001] [0001]

技术领域 FIELD

[0002] 本发明涉及一种基于水文数据的降雨多维分析系统及其实现方法。 [0002] The present invention relates to a multi-dimensional data based on precipitation hydrological analysis system and its implementation method.

背景技术 Background technique

[0003] 降雨作为水循环的一个重要环节,降雨分析对区域水文研究、水资源管理、灾害预警和可持续发展研究具有十分重要的意义。 [0003] As an important part of the water cycle of rainfall, the rainfall analysis is of great significance for the study of hydrology, water resources management, disaster warning and Regional Sustainable Development. 随着我国水利信息化建设的发展,目前已积累了大量有价值的水文要素数据资料,这些历史资料数据量大、关系复杂且存在噪声,需要经过合理的清洗处理和良好的组织设计。 With the development of China's water conservancy construction, has accumulated a wealth of valuable data on hydrological factors, these historical data large amount of data, complex relationships and the presence of noise, need cleaning after a reasonable and well-organized design.

[0004] 当前,信息技术的发展正沿着从在线事务处理向在线分析处理、从数据服务向信息和知识服务的方向发展。 [0004] At present, the development of information technology being along the process from online transaction processing to on-line analysis, development of data services from the direction of information and knowledge services. 研究如何从大量的、类型复杂的历史降雨数据中分析获取有利于管理决策的信息已成为水文科学发展的新热点。 How to get information research and analysis in favor of management decision-making has become a new hot spot for the scientific development of hydrology from a large, complex type of historical rainfall data.

[0005] 因此研究如何对积累的大量降雨数据进行高效的存储组织和快速检索,为用户提供在不同角度和层面进行分析和统计的多维分析能力,并提供报表、图形等多样化的数据展现方式,能为区域的降雨分析提供一种新的思路和方法,能够为地区的决策管理提供支持。 [0005] Therefore, to study how to organize efficient storage and rapid retrieval of heavy rainfall accumulated data, to provide users with the ability to perform multi-dimensional analysis and statistical analysis at different angles and levels, and provide reports, graphics and other diverse data show the way It can provide a new way of thinking and methods for the analysis of rainfall areas, to provide support for decision management area.

发明内容 SUMMARY

·[0006] 发明目的:针对现有技术中存在的问题,本发明提供一种基于水文数据的降雨多维分析系统及其实现方法,基于经过预处理的原始水文数据,将海量降雨历史数据的进行统一、有效的组织存储,便于对大量数据进行快速检索和分析;同时,为用户提供降雨数据的钻取、切块、旋转等多维分析功能以及分析结果的多样化展现。 * [0006] The object of the invention is: for the problems in the prior art, the present invention provides a multi-dimensional analysis of rainfall hydrological data and implementation method based on the original after pretreatment hydrological data, the historical data is massive precipitation unified and effective organization storage, ease of large amounts of data for quick retrieval and analysis; at the same time, to provide users with diverse features and to analyze the results of the analysis show the drill, cut, rotate, etc. multidimensional rainfall data.

[0007] 技术方案:一种基于水文数据的降雨多维分析系统,包括水文数据仓库模块、分析模型构建模块、数据服务模块、分析图表开发模块和应用集成模块,其中: [0007] The technical solutions: A rain multidimensional analysis based on hydrological data, including hydrological data warehouse module, model building blocks, a data service module, the analysis module develop charts and application integration module, wherein:

所述水文数据仓库模块基于Oracle数据库平台,以面向主题的方式组织集成经过预处理的水文数据,数据以多维数据立方体的形式组织存储,为多维分析提供可靠、高效的数据支持; The hydrological data warehouse platform module based on an Oracle database, organized theme-oriented integrated preprocessed hydrological data, multidimensional data cube is stored in the form of tissue, multidimensional providing reliable and efficient data analysis support;

所述分析模型构建模块通过获取水文数据仓库的元数据,提供降雨多维分析模型的完整设计、构建功能,即提供降雨多维分析模型的物理层、逻辑层以及展现层三部分的定义和构建功能; The building block model by obtaining metadata hydrological data warehouse, multi-dimensional analysis provides a complete precipitation of design models, building capabilities, i.e., the physical layer provides rainfall multidimensional analysis model, and the logical layer defines the presentation layer and build functional three parts;

所述数据服务模块响应前端分析图表开发模块的数据请求,通过处理降雨多维分析模型元数据,从水文数据仓库读取数据,并按分析的维度和层次级别对降雨数据进行相应的求和或最大值的聚合计算,最后将聚合计算后的结果数据反馈至前端分析图表开发模块;所述分析图表开发模块基于数据服务模块的支持,通过对数据进行格式化处理,为用户提供分析报表和图形的可视化显示和数据展现方式的选择。 The data in response to a data request service module front-end analysis chart module development, by processing a multi-dimensional model rainfall metadata read data from hydrologic data warehouse, in accordance hierarchical level analysis and dimensions corresponding rainfall data summation or maximum Calcd of the polymerization, the final result after the polymerization calculates a feedback data to the front end module analysis charts development; development module based on the analysis of the chart data service support module, by the data formatting, to provide users with graphical analysis reports and visual display and selection of data representations. 分析图表开发模块提供丰富的数据展现方式,有数据透视图表、表格、图形三种展现方式,其中图形展现包括条形图、线形图、饼图、条线图、散点图、气泡图、雷达图。 Analysis Chart development module provides a rich data show the way, there are pivot charts, tables, three kinds of graphic representations, wherein the graphical presentation comprises a bar, line, pie, line, scatter, bubble, radar Fig.

[0008] 所述应用集成模块通过集成发布分析图表开发模块的分析图表,将多个分析报表进行自由组合和集中发布,为用户提供钻取、切块、旋转等多维分析功能。 [0008] The published application integration module by integrating analysis chart graph of the development module, a plurality of analysis reports published be freely combined and concentrated, to provide users with a drill, cut, rotation of multidimensional analysis. 此外模块还提供全局过滤器的设置,可实现应用页面多个报表的统一请求过滤。 Further modules also provide a global filter is provided, a requesting application can be unified report page plurality of filters.

[0009] 所述多维数据立方体的物理模型按星型模式进行组织实现,物理模型具有时间维度、空间维度、行政区划维度以及总降雨量和最大单日降雨量两个度量指标,其中: [0009] The multidimensional data cube physical model implemented in a star pattern tissue, having a time dimension physical model, spatial dimension, dimensions, and the administrative divisions and the maximum daily total rainfall precipitation two metrics, wherein:

所述时间维度具有四个聚合级别,从高到低分别为年、月、旬、日; The polymerization time dimension has four levels, from high to low for the year, month, ten-day, day;

所述空间维度具有四个聚合级别,从高到低分别为流域、水系、河流、测站; The spatial dimension has four levels of polymerization, basin descending order, water, rivers, station, respectively;

所述行政区划维度具有三个聚合级别,从高到低分别为省级、市级、县级; The administrative division has three dimensions aggregation level, from high to low as provincial, municipal, county;

所述总降雨量度量在不同维度层次的聚集计算方式是求和(SUM)计算; The total rainfall in different dimensions measure levels of aggregation is calculated sum (SUM) is calculated;

所述最大单日降雨量度量在不同维度层次的聚集方式是求最大值(MAX)计算。 The maximum daily rainfall in different dimensions measure levels of aggregation method is selecting the maximum value (MAX) is calculated.

[0010] 降雨多维分析模型,可划分为物理层、逻辑层以及展现层三部分,其中: [0010] rainfall multidimensional model, the physical layer can be divided into three parts, and the presentation layer logical layer, wherein:

所述物理层包含降雨分析数据源的连接定义以及分析所需相关物理表的元数据信 And analyzing the physical connection definition layer comprises a precipitation source required analytical data related to the physical channel metadata table

息; interest;

所述逻辑层在物理层的基础上定义多维分析的逻辑模型,包含维度、级别等的设计以及降雨度量的聚合方式定义;逻辑层的定义基于多维数据立方体模型,包括时间维度、空间维度、行政区划维度三个逻辑维度及其级别的定义以及总降雨量和最大单日降雨量两个度量指标的聚合计算定义。 The logical layer defines the physical layer on the basis of the logical model of multidimensional analysis, comprising dimensions, design and other levels of aggregation precipitation metric defined; defining a logical layer model based on multidimensional data cube, comprising a time dimension, spatial dimension, ADMINISTRATION dimension three logical division and dimensions and the total level is defined and the maximum daily rainfall precipitation polymerization define two metrics is calculated.

[0011] 所述展现层提供面向用户的降雨分析简化视图,隐藏与分析无关的信息,仅保留关心的字段信息并以直观的术语进行描述。 [0011] The presentation layer provides a user-oriented analysis rainfall simplified view, hidden information unrelated to the analysis, retaining only the information field of interest and will be described in an intuitive terms.

[0012] 一种基于水文数据的降雨多维分析系统的实现方法,包括如下步骤: [0012] A Method of multidimensional analysis system based on rainfall hydrological data, comprising the steps of:

步骤S200,利用分析模型构建模块设计构建降雨多维分析模型; Step S200, the building blocks designed and constructed analysis model using multidimensional rainfall analysis model;

步骤S205,基于降雨多维分析模型,利用分析图表开发模块设计开发多样的分析图 Step S205, the multi-dimensional model based on rainfall, using analysis charts development module design and development of a variety of Analysis FIG.

表; table;

步骤S210,系统管理员在应用集成模块中对开发的分析图表进行集成至同一个分析页面,并设置所需的同步和触发,以实现一个页面上的多对象、多角度分析,为用户提供全面、灵活的分析功能;最后将定义的集成页面进行发布,提供面向用户的降雨多维分析服务;步骤S215,用户在发布的分析页面提交交互式分析请求,对应的分析图表获取用户的操作请求; Step S210, the system administrators to integrate into a single analysis page, and set the desired synchronization and triggering, to enable multi objects on a page, multi-angle analysis, to provide users with comprehensive analysis charts in the development of application integration module and flexible analysis capabilities; and finally publish the page definition of integration, to provide user-oriented services rainfall multidimensional analysis; step S215, the user submits a request for interactive analysis published in the pages of analysis, corresponding analysis charts to obtain the operation of the requesting user;

步骤S220,分析图表将用户操作请求提交至数据服务模块,数据服务模块根据请求解析降雨多维分析模型的元数据,生成具体的数据库查询请求; Step S220, the user operation analysis charts will submit the request to the data service module, the service module parses rainfall multidimensional data analysis metadata model to generate specific database query request according to the request;

步骤S225,水文数据仓库响应数据查询请求,数据服务模块将查询获得的基础降雨量数据根据请求分析的度量,按分析的维度和级别进行相应的求和或最大值的聚合计算,并将结果反馈至前端分析图表开发模块; Step S225, the hydrological data warehouse query request response data, precipitation data base query service module request metrics obtained according to the analysis, analysis by dimension and level calculated by polymerizing the corresponding sum or maximum value, and the results fed analysis chart development module to the front;

步骤S230,分析图表开发模对结果数据进行格式化处理和可视化展现。 Step S230, the analysis result graph of modulus development formats the data and visual display.

[0013] 所述降雨多维分析模型的构建步骤如下: [0013] The multi-dimensional analysis model construction step precipitation as follows:

步骤S100,利用常用的均值和相邻值平滑的方法,将从多种异构数据源获取的流域水文降雨数据进行空值处理和异常值处理等预处理操作,得到统一的,高质量的降雨分析相关数据集; Step S100, the use of conventional mean value of the smoothing process and the adjacent, acquired from a plurality of heterogeneous data sources hydrological data of rainfall null handling and exception handling pretreatment value was obtained a uniform, high rainfall Related data set;

步骤S105,将经过预处理后的数据集按设计的降雨主题数据立方体的组织结构进行相应的转换处理,并将转换后生成的维度数据、降雨事实数据加载至水文数据仓库; Step S105, the data set according to the rainfall through the theme data cube designed organizational structure corresponding preprocessed conversion processing, and the dimension data generated after the conversion, the data is loaded to the fact that precipitation hydrological data warehouse;

步骤S110,利用分析模型构建模块定义数据仓库的连接,导入降雨分析相关物理表的元数据信息; Step S110, the model constructed using the connection module definition data warehouse introduced precipitation analyzes metadata associated physical information table;

步骤SI 15,利用分析模型构建模块,定义与各个物理表相对应的逻辑表,逻辑表保持物理表原有的结构和关系,但屏蔽了与具体存储平台相关的信息; Step SI 15, using the model building blocks, each physical appearances defined corresponding logical table, a logical table holding the original table structure and the physical relationship, but the information associated with the particular mask storage platform;

步骤S120,在逻辑维表的基础上,建立与逻辑维表相对应的逻辑维度及其层次级别,定义各个级别与逻辑表字段间的映射关系; Step S120, the dimension on the basis of the logic on the table, and establishing a logical dimension hierarchy level correspond to tables and logical dimension, define the mapping between the logical levels of the respective table fields;

步骤S125,在构建的逻辑维表的基础上,定义总降雨量度量在各个逻辑维度上的求和聚合计算规则以及最大单日降雨量度量在各个维度上的求最大值聚合计算规则。 Step S125, the dimension on the basis of the logic table built on the definition of total rainfall metric dimensions in the respective logical sum calculation rule the polymerization and the maximum daily precipitation polymerization metric calculation rules in selecting the maximum value on each dimension.

[0014] 步骤S130,定义与各个逻辑表相对应的表示表,表示表面向分析人员,通过隐藏主外键等字段,只保留与分析相关的信息并以直观易懂的方式命名;最终的分析图表将基于表示表的内容进行设计和展现。 [0014] In step S130, the logical definition of the respective appearances corresponding to a table, showing the surface of the analysts, by hiding the primary field of keys, etc., leaving only the information related to the analysis and intuitive way to name; final analysis the chart will show the design and content-based representation of the table.

[0015] 有益效果:与现有技术相比,本发明所提供的基于水文数据的降雨多维分析系统及其实现方法,具有如下优点: [0015] The beneficial effects: Compared with the prior art, the present invention provides a multidimensional data analysis systems based on precipitation hydrology and implementation method, has the following advantages:

降雨多维分析模型提供了海量降雨数据的一种统一、高效的组织存储方式,保证了数据的质量以及检索和分析的高效性,模型通用性强,能适应除降雨数据外的多种水文数据;基于降雨多维分析模型的数据分析系统,提供了强大的分析图表设计能力,能为用户提供灵活多变和高度可定制化的降雨多维分析能力;数据透视图表、表格、条形图、线形图、饼图等丰富多样的数据展现方式,能为用户提供多层次、多角度的数据展现能力。 Rainfall multidimensional analysis model provides a unified mass of rainfall data, efficient organization and storage methods to ensure the quality and efficiency of data retrieval and analysis, model versatility, can adapt to a variety of hydrological data in addition to rainfall data; rainfall multidimensional analysis model based on the data analysis system, provides a powerful analysis chart design capabilities, can provide flexible and highly customizable multidimensional analysis capabilities rainfall users; pivot charts, tables, bar charts, line charts, pie charts and other data to show a variety of ways to provide users with multi-level, multi-angle data show ability.

附图说明 BRIEF DESCRIPTION

[0016] 图1为本发明实施例的系统结构框图; [0016] The system diagram of FIG 1 according to an embodiment of the present invention;

图2为本发明实施例的多维数据立方体的物理模型维度示意图; FIG 2 is a schematic model of the physical dimensions of multidimensional data cube embodiment of the embodiment of the invention;

图3为本发明实施例的降雨多维分析模型的逻辑模型结构图; Rainfall embodiment of the present invention. FIG. 3 is a configuration diagram of a multi-dimensional model analysis logic model;

图4为本发明实施例的实现方法流程图; 4 a flowchart of a method implemented embodiment of the present invention;

图5为本发明实施例的降雨多维分析模型的构建流程图。 Construction flowchart of FIG. 5 rain model embodiment of the present invention, multidimensional analysis.

具体实施方式 detailed description

[0017] 下面结合具体实施例,进一步阐明本发明,应理解这些实施例仅用于说明本发明而不用于限制本发明的范围,在阅读了本发明之后,本领域技术人员对本发明的各种等价形式的修改均落于本申请所附权利要求所限定的范围。 [0017] The following embodiments with reference to specific embodiments, further illustrate the present invention, it should be understood that these embodiments are illustrative only and the present invention is not intended to limit the scope of the present invention, after reading this disclosure, those skilled in the art of the various invention the modifications are equivalents fall within the present application as defined by the appended claims scope.

[0018] 如图1所示,基于水文数据的降雨多维分析系统,包括水文数据仓库模块100、分析模型构建模块200、数据服务模块300、分析图表开发模块400和应用集成模块500,其中: [0018] 1, multi-dimensional analysis based on rainfall hydrological data, comprising 100, model construction module hydrological data warehouse module 200, a data services module 300, analysis module 400, and the development of the chart application integration module 500, wherein:

水文数据仓库模块100基于Oracle数据库平台,以面向主题的方式组织集成经过空值处理、异常值的水文数据,数据以多维数据立方体的形式组织存储,为多维分析提供可靠、高效的数据支持;分析模型构建模块200通过获取水文数据仓库元数据,提供降雨多维分析模型的完整设计、构建功能; Hydrological data warehouse module 100 based on Oracle database platform to subject-oriented way to organize integrated through a null value processing, hydrological data outliers, data is stored in the form of organization of multidimensional data cubes for multidimensional providing reliable and efficient data to support analysis; analysis model building block 200 by obtaining hydrological data warehouse metadata, to provide a complete design rainfall multidimensional analysis model, building capabilities;

数据服务模块300响应前端分析图表开发模块400的数据请求,通过处理降雨多维分析模型元数据,从水文数据仓库(水文数据仓库模块100中的水文数据仓库)读取数据,并按分析的维度和层次级别对降雨数据进行相应的求和或最大值的聚合计算,最后将结果数据反馈至前端分析图表开发模块400 ; The front end module 300 in response to data service development module data request analysis charts 400, the multidimensional model rainfall by treating metadata, the data warehouse to read data from hydrologic (hydrological data warehouse module hydrological data warehouse 100), according to the dimensions and analysis rainfall hierarchical level corresponding aggregate data summation or maximum value, the final result is fed back to the data front end module 400 to develop the analysis chart;

分析图表开发模块400基于数据服务模块300的支持,通过对数据进行格式化处理,为用户提供分析报表和图形的可视化设计、开发功能。 Development module 400 based on analysis of the chart data service support module 300, by the data formatting, to provide users with analysis reports and graphical visual design, development function. 分析图表开发模块400提供丰富的数据展现方式,有数据透视图表、表格、图形三种展现方式,其中图形展现包括条形图、线形图、饼图、条线图、散点图、气泡图、雷达图; Analysis Chart development module 400 provides a wealth of data show the way, there are pivot charts, tables, three kinds of graphic representations, wherein the graphical presentation comprises a bar, line, pie, line, scatter, bubble, FIG radar;

应用集成模块500通过集成发布设计开发的分析图表,将开发的多个分析报表进行自由组合和集中发布的功能,为用户提供钻取、切块、旋转等多维分析功能。 Application integration module 500, the analysis report developed more freely assemble and focus on publishing functionality by analyzing the chart design and development of integrated release, to provide users drill, cut, rotate, etc. multi-dimensional analysis capabilities. 此外应用集成模块500还提供全局过滤器的设置,可实现应用页面多个报表的统一请求过滤。 Further application integration module 500 also provides a set of global filter can be unified application requests a page multiple reports filtered.

[0019] 多维数据立方体的物理模型结构按星型模式进行组织实现,其概念模型结构如图2所示,具有时间维度101、空间维度102、行政区划维度103以及总降雨量104和最大单日降雨量105两个度量指标,其中: [0019] The physical model multidimensional data cube structure in a star pattern to realize tissue, which conceptual model structure shown in Figure 2, having a time dimension 101, spaces 102 dimensions, the dimensions of administrative divisions 103 and 104, and the maximum total daily rainfall 105 rainfall two metrics, wherein:

时间维度101具有四个聚合级别,从高到低分别为年、月、旬、日; Time dimension 101 has four aggregation levels, from high to low for the year, month, ten-day, day;

空间维度102具有四个聚合级别,从高到低分别为流域、水系、河流、测站; 102 has four spatial dimensions aggregation level, descending order basin, water, rivers, station, respectively;

行政区划维度103具有三个聚合级别,从高到低分别为省级、地市级、县级; Administrative divisions 103 having three dimensions aggregation level, from high to low as provincial, municipal, county;

降雨多维分析模型,其逻辑模型结构如图3所示,具体包括降雨量事实表FACT_HY111、时间维表DM_TM 112、空间维表DM_RV 113以及行政区划维表DM_ADDV 114,其中: Rainfall multidimensional model, logical model structure shown in FIG. 3, comprises rainfall fact table FACT_HY111, time dimension table DM_TM 112, the space dimension tables DM_RV 113 and the administrative division dimensional table DM_ADDV 114, wherein:

降雨量事实表FACT_HY 111具体表结构为: Rainfall fact table to table structure specifically FACT_HY 111:

Figure CN103399925AD00071

时间维表DIM_TM 112具体表结构为: Table DIM_TM 112 time dimension table structure specifically:

Figure CN103399925AD00072
Figure CN103399925AD00081

行政区划维表DIM_ADDV 114具体表结构为: Table administrative division dimensional table structure is particularly DIM_ADDV 114:

表名称:行政区划维表(114) Table Name: administrative division dimensional table (114)

Figure CN103399925AD00082

基于水文数据的降雨多维分析系统的实现方法,如图4所示,包括如下步骤: Rainfall implementation multidimensional analysis system based on hydrological data, shown in Figure 4, comprising the steps of:

步骤S200,模型开发者利用分析模型构建模块200设计构建降雨多维分析模型。 Step S200, the model design module developers to build 200 to build a multi-dimensional analysis model using the rainfall analysis model.

[0020] 步骤S205,分析报表开发者基于降雨多维分析模型,利用分析图表开发模块400设计开发多样的分析图表。 [0020] step S205, the analysis report based developer rainfall multidimensional analysis model, developed using the analysis of the chart module 400 is designed to develop a variety of chart analysis.

[0021] 步骤S210,系统管理员在应用集成模块500中对开发的分析图表进行集成至同一个分析页面,并设置所需的同步和触发,以实现一个页面上的多对象、多角度分析,为用户提供全面、灵活的分析功能;最后将定义的集成页面进行发布,提供面向用户的降雨多维分析服务。 [0021] In step S210, the system administrator integrated into a single page analysis chart of analysis developed in the application integration module 500, and set the synchronization and triggering to achieve multiple objects on a page, multi-angle analysis, to provide users with comprehensive and flexible analysis capabilities; and finally publish the page definition of integration, to provide user-oriented rain multidimensional analysis services.

[0022] 步骤S215,用户在发布的分析页面提交交互式分析请求,对应的分析图表开发模块400获取用户的操作请求。 [0022] In step S215, the user submits a request for interactive analysis of the published analysis of the page, the corresponding analysis charts development module 400 acquires a user operation request.

[0023] 步骤S220,分析图表开发模块400将用户请求提交至数据服务模块300,数据服务模块300根据请求解析降雨多维分析模型的元数据,生成具体的数据库查询请求。 [0023] In step S220, the analysis charts development module 400 requests the user to submit the data service module 300, the multidimensional data service metadata analysis module 300 according to the request parsing model rainfall generated specific database query request.

[0024] 步骤S225,水文数据仓库模块100响应数据查询请求,数据服务模块300将查询获得的数据进行相应的聚合计算,并将结果反馈至前端分析图表开发模块400。 [0024] In step S225, the hydrographic data warehouse query request response module 100, data query service module 300 obtained by polymerization of the corresponding calculation, and the result is fed back to the front end module 400 to develop analysis charts.

[0025] 步骤S230,图表开发模块400对结果数据进行格式化处理和可视化展现。 [0025] step S230, the graph results development module 400 formats the data and visual display.

[0026] 如图5所示,降雨多维分析模型的构建步骤如下: [0026] 5, multidimensional analysis model construction step Rainfall follows:

步骤S100,将从多种异构数据源获取的流域水文降雨数据进行异常值处理等预处理操作,得到统一的,高质量的降雨分析相关数据集。 Step S100, the data from the precipitation basin hydrological plurality of heterogeneous data sources acquired abnormal value processing pretreatment operations, to give a uniform, high rainfall Related data set.

[0027] 步骤S105,将预处理后的数据集按设计的降雨主题数据立方体的组织结构进行相应的转换处理,并将转换后生成的维度数据、降雨事实数据加载至水文数据仓库模块100中的水文数据仓库。 [0027] step S105, the pre-set data relating to the design according to the rainfall data cube corresponding organizational structure conversion processing, and the dimension data generated after the conversion, the data is loaded to the fact rainfall hydrological data warehouse module 100 hydrological data warehouse.

[0028] 步骤S110,利用分析模型构建模块200定义水文数据仓库的连接,导入降雨分析相关物理表的元数据信息。 [0028] step S110, the model constructed using the connection module 200 defines hydrological data warehouse introduced precipitation analyzes metadata associated physical table information.

[0029] 步骤S115,利用分析模型构建模块200,定义与各个物理表相对应的逻辑表,逻辑表保持物理表原有的结构和关系,但屏蔽了与具体存储平台相关的信息。 [0029] step S115, the analysis model using building blocks 200, each physical appearances defined corresponding logical table, a logical table holding the original table structure and the physical relationship, but the mask information associated with the particular storage platform.

[0030] 步骤S120,在逻辑维表的基础上,建立与维表相对应的逻辑维度及其层次级别,定义各个级别与逻辑表字段间的映射关系。 [0030] step S120, the dimension on the basis of the logic table, the logic to establish the dimensions and dimensional hierarchical level correspond to the table, define mapping between the logical levels of the respective table fields.

[0031] 步骤S125,在构建的逻辑维表的基础上,定义总降雨量度量在各个逻辑维度上的求和聚合计算规则以及最大单日降雨量度量在各个维度上的求最大值聚合计算规则。 [0031] step S125, the dimension on the basis of the logic table constructed on the defined metric sum total rainfall in the polymerization respective logical calculation rules and selecting the maximum value polymerization dimension calculation rule biggest daily rainfall in each dimension metric .

[0032] 步骤S130,定义与各个逻辑表相对应的表示表,表示表面向分析人员,通过隐藏主外键等字段,只保留与分析相关的降雨度量信息和时间、流域水系等分析维度信息,并以业务分析人员所熟知和直观易懂的方式命名这些保留的信息。 [0032] Step S130, the respective logical definition appearances corresponding to a table, showing the surface of the analysts, by hiding the primary field of keys, etc., and keep only the relevant dimensions rainfall measurement and analysis information and analysis time, river basin and other information, and it is well known to business analysts and intuitive manner information designated reserved. 最终的分析图表将基于表示表的内容进行设计和展现。 The final analysis of the chart will be designed based on the content and presentation of a table.

[0033] 本发明中涉及的未说明部分与现有技术相同。 [0033] The present invention relates to a section not illustrated is the same as the prior art.

Claims (7)

  1. 1.一种基于水文数据的降雨多维分析系统,其特征在于:包括水文数据仓库模块、分析模型构建模块、数据服务模块、分析图表开发模块和应用集成模块,其中: 所述水文数据仓库模块基于Oracle数据库平台,以面向主题的方式组织集成经过预处理的水文数据,数据以多维数据立方体的形式组织存储; 所述分析模型构建模块通过获取水文数据仓库的元数据,提供降雨多维分析模型的完整设计、构建功能; 所述数据服务模块响应前端分析图表开发模块的数据请求,通过处理降雨多维分析模型元数据,从水文数据仓库读取数据,并进行相应的聚合计算,最后将结果数据反馈至前端分析图表开发模块; 所述分析图表开发模块基于数据服务模块的支持,通过对数据进行格式化处理,为用户提供分析报表和图形的可视化显示和数据展现方式的选择;分析图表开 A multidimensional analysis based on precipitation hydrological data, characterized by: a hydrographic data warehouse module, model building blocks, a data service module, the analysis module develop charts and application integration module, wherein: the module is based on Data Warehouse hydrological Oracle database platform, theme-oriented manner through tissue integration hydrological data pre-organization of data stored in the form of multidimensional data cube; metadata model constructing module by acquiring the data warehouse hydrological analysis provides a complete analysis of multidimensional model rainfall design, build function; data service module, in response to the data request analysis charts front end module development, by processing a multi-dimensional model of metadata rainfall, hydrological data read from the data warehouse, and the corresponding calculation polymerization, the resultant data is fed back to the final analysis chart distal development module; module based on the analysis of the chart developed to support data service module, by the data formatting, to provide users with a visual display of graphics and selection analysis report and data presentation mode; analysis charts open 模块的数据展现方式有数据透视图表、表格、图形三种展现方式; 所述应用集成模块通过集成发布设计开发的分析图表,为用户提供钻取、切块和旋转多维分析功能。 Data representations pivot module are charts, tables, graphs, three kinds of representations; the integrated application module integrated analysis charts published by design and development, to provide users with drill, cut, and rotating the multidimensional analysis.
  2. 2.如权利要求1所述的基于水文数据的降雨多维分析系统,其特征在于:所述多维数据立方体的物理模型按星型模式进行组织实现,物理模型具有时间维度、空间维度、行政区划维度以及总降雨量和最大单日降雨量两个度量指标,其中: 所述时间维度具有四个聚合级别,从高到低分别为年、月、旬、日; 所述空间维度具有四个聚合级别,从高到低分别为流域、水系、河流、测站; 所述行政区划维度具有三个聚合级别,从高到低分别为省级、市级、县级; 所述总降雨量度量在不同维度层次的聚集计算方式是求和计算; 所述最大单日降雨量度量在不同维度层次的聚集方式是求最大值计算。 2. The multi-dimensional analysis based on precipitation system as recited in claim 1 hydrological data, wherein: the multi-dimensional data cube physical model implemented organized in a star pattern, physical model having a time dimension, spatial dimension, the dimension of administrative divisions and the biggest daily total rainfall and rain two metrics, wherein: said time dimension has four aggregation level, from high to low for the year, month, late, Japan; the spatial dimension has four levels of polymerization , respectively, from high to low basin, water, river station; having three dimensions of the administrative divisions aggregation level, from high to low as provincial, municipal, county; the total rainfall in different metrics the dimension hierarchy is calculated aggregate sum calculation; the maximum daily rainfall in different dimensions measure levels of aggregation method is selecting the maximum value calculation.
  3. 3.如权利要求1所述的基于水文数据的降雨多维分析系统,其特征在于:降雨多维分析模型,划分为物理层、逻辑层以及展现层三部分,其中: 所述物理层包含降雨分析数据源的连接定义以及分析所需相关物理表的元数据信息; 所述逻辑层在物理层的基础上定义多维分析的逻辑模型,包含维度、级别等的设计以及降雨度量的聚合方式定义; 所述展现层提供面向用户的降雨分析简化视图,隐藏与分析无关的信息,仅保留关心的字段信息并以直观的术语进行描述。 3. The rain multidimensional data analysis system hydrological according to claim 1, wherein: Rainfall multidimensional model, the physical layer is divided into three parts, and the logical layer, presentation layer, wherein: the physical layer data comprises rainfall analysis defining a source and connected to analyze the required physical table associated metadata information; and the logical layer defines a logical model of multidimensional analysis based on the physical layer, which dimensions, design and other levels of aggregation precipitation metric defined; the user-oriented presentation layer provides a simplified view of rainfall analysis, hidden information unrelated to the analysis, only a reserved field information of interest and will be described in an intuitive terms.
  4. 4.如权利要求1所述的基于水文数据的降雨多维分析系统,其特征在于:所述分析图表开发模块的图形展现包括条形图、线形图、饼图、条线图、散点图、气泡图和雷达图;用户可选择包含表格、图形以及图表结合的多种分析报表。 4. The multidimensional analysis system, characterized in that the rain hydrological data according to claim 1: the development of the graphical plot analysis module exhibits comprises a bar, line, pie, line, scatter, bubble and radar charts; user selectable form comprises a plurality of analysis reports, graphs and charts in combination.
  5. 5.如权利要求1所述的基于水文数据的降雨多维分析系统,其特征在于:将多个分析报表进行自由组合和集中发布,为用户提供钻取、切块、旋转多维分析功能;此外应用集成模块还提供全局过滤器的设置,实现应用页面多个报表的统一请求过滤。 5. The multi-dimensional analysis based on precipitation system as recited in claim 1 hydrological data, wherein: a plurality of analysis reports published be freely combined and concentrated, to provide users with a drill, cut, rotation of multidimensional analysis; Further applications the module also provides integrated set global filters, to achieve uniform application page request multiple reports filtering.
  6. 6.一种基于水文数据的降雨多维分析系统的实现方法,其特征在于,包括如下步骤: 步骤S200,利用分析模型构建模块设计构建降雨多维分析模型; 步骤S205,基于降雨多维分析模型,利用分析图表开发模块设计开发多样的分析图表; 步骤S210,系统管理员在应用集成模块中对开发的分析图表进行集成定义和发布,为用户提供降雨多维分析服务; 步骤S215,用户在发布的分析页面提交交互式分析请求,对应的分析图表获取用户的操作请求; 步骤S220,分析图表将用户操作请求提交至数据服务模块,数据服务模块根据请求解析降雨多维分析模型的元数据,生成具体的数据库查询请求; 步骤S225,水文数据仓库响应数据查询请求,数据服务模块将查询获得的数据进行相应的聚合计算,并将结果反馈至前端分析图表开发模; 步骤S230,分析图表开发模对结果数据 A multidimensional analysis system implementation rainfall hydrological data based, characterized in that it comprises the following steps: step S200, the building blocks designed and constructed analysis model using multidimensional rainfall analysis model; step S205, the multi-dimensional model based on precipitation using Analysis chart development module design and development of various analysis charts; step S210, the system administrator on the development of integrated analysis charts to define and publish the application integration module, to provide users with multi-dimensional analysis of rainfall services; step S215, the user submits the page analysis released interactive analysis request, the analysis of the chart corresponding to the operation acquisition request user; step S220, the user operation analysis charts submit a request to the data service module, the module parses the data service metadata rainfall multidimensional analytical model according to the request, generating a specific database query request ; step S225, the hydrological data warehouse query request response data, the data query service module obtained by polymerization of the corresponding calculation, and the result is fed back to development of analog front-end analysis chart; step S230, the analysis result data on the graph to develop mold 行格式化处理和可视化展现。 Row formatting and visual presentation.
  7. 7.如权利要求6所述的基于水文数据的降雨多维分析系统的实现方法,其特征在于,所述降雨多维分析模型的构建步骤如下: 步骤S100,将从多种异构数据源获取的流域水文降雨数据进行异常值处理等预处理操作,得到统一的降雨分析相关数据集; 步骤S105,将预处理后的数据集进行相应的转换处理,按设计的降雨主题数据立方体的组织结构加载至水文数据仓库; 步骤S110,利用分析模型构建模块定义数据仓库的连接,导入降雨分析相关物理表的元数据信息;· 步骤S115,利用分析模型构建模块,定义与各个物理表相对应的逻辑表; 步骤S120,在逻辑维表的基础上,建立与逻辑维表相对应的逻辑维度及其层次级别,定义各个级别与逻辑表字段间的映射关系; 步骤S125,在构建的逻辑维表的基础上,定义度量指标在不同逻辑维度上的聚合计算规则; 步骤S130 7. The multi-dimensional analysis based on precipitation of hydrological data system implemented method recited in claim 6, wherein said step of constructing a multidimensional model of rainfall as follows: step S100, a variety of heterogeneous data sources from the acquired Basin rainfall hydrological data processing outliers pretreatment operation, resulting uniform rainfall Related data set; step S105, the data set corresponding pre-conversion process, according to the theme of rainfall data cube designed to load the organizational structure of hydrology data warehouse; step S110, the model constructed using the connection module definition data warehouse introduced precipitation analyzes metadata associated physical information table; * step S115, the building blocks, each physical appearances defined corresponding logical table using the analysis model; step S120, on the basis of the logic table dimension, and the dimension hierarchy to establish a logical level corresponding to the logical-dimensional appearances, define the mapping between the logical levels of the respective field; step S125, the logic on the basis of the dimension tables constructed, polymerization calculation rules defined metrics on different logical dimensions; step S130 定义与各个逻辑表相对应的表示表,表示表面向分析人员,通过隐藏主外键等字段,只保留与分析相关的信息并以直观易懂的方式命名;最终的分析图表将基于表示表的内容进行设计和展现。 Define respective logic table indicates that correspond to tables showing the surface analysts, foreign keys, by hiding the primary field, and to keep only intuitive way analysis of information related to names; the final analysis will be based on a table of graphs content design and presentation.
CN 201310337191 2013-08-05 2013-08-05 Rainfall multidimensional analysis system based on hydrologic data and implementation method of rainfall multidimensional analysis system CN103399925A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN 201310337191 CN103399925A (en) 2013-08-05 2013-08-05 Rainfall multidimensional analysis system based on hydrologic data and implementation method of rainfall multidimensional analysis system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN 201310337191 CN103399925A (en) 2013-08-05 2013-08-05 Rainfall multidimensional analysis system based on hydrologic data and implementation method of rainfall multidimensional analysis system

Publications (1)

Publication Number Publication Date
CN103399925A true true CN103399925A (en) 2013-11-20

Family

ID=49563553

Family Applications (1)

Application Number Title Priority Date Filing Date
CN 201310337191 CN103399925A (en) 2013-08-05 2013-08-05 Rainfall multidimensional analysis system based on hydrologic data and implementation method of rainfall multidimensional analysis system

Country Status (1)

Country Link
CN (1) CN103399925A (en)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104007975A (en) * 2014-06-04 2014-08-27 厦门舜亚科技有限公司 Broadband indicator collecting, monitoring and displaying method and system
CN104657475A (en) * 2015-02-16 2015-05-27 百度在线网络技术(北京)有限公司 Method and system for data analysis
CN104820715A (en) * 2015-05-19 2015-08-05 杭州迅涵科技有限公司 Method and system for sharing and analyzing data based on multidimensional correlation
CN104142827B (en) * 2014-07-29 2017-12-19 上海自仪泰雷兹交通自动化系统有限公司 Rapid analysis of a rail transportation system performance data communication

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7324992B2 (en) * 1997-02-26 2008-01-29 Hitachi, Ltd. Database processing method and system
CN102521246A (en) * 2011-11-11 2012-06-27 北京国电通网络技术有限公司 Cloud data warehouse system

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7324992B2 (en) * 1997-02-26 2008-01-29 Hitachi, Ltd. Database processing method and system
CN102521246A (en) * 2011-11-11 2012-06-27 北京国电通网络技术有限公司 Cloud data warehouse system

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
占军 等: "基于Oracle BIEE水利普查数据展现系统研究", 《舰船电子工程》, vol. 32, no. 4, 30 April 2012 (2012-04-30), pages 104 - 109 *
李宇 等: "基于 Oracle 的水利普查数据分析系统应用研究", 《信息技术》, no. 8, 31 August 2012 (2012-08-31), pages 9 - 12 *

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104007975A (en) * 2014-06-04 2014-08-27 厦门舜亚科技有限公司 Broadband indicator collecting, monitoring and displaying method and system
CN104142827B (en) * 2014-07-29 2017-12-19 上海自仪泰雷兹交通自动化系统有限公司 Rapid analysis of a rail transportation system performance data communication
CN104657475A (en) * 2015-02-16 2015-05-27 百度在线网络技术(北京)有限公司 Method and system for data analysis
CN104820715A (en) * 2015-05-19 2015-08-05 杭州迅涵科技有限公司 Method and system for sharing and analyzing data based on multidimensional correlation

Similar Documents

Publication Publication Date Title
Malinowski et al. Hierarchies in a multidimensional model: From conceptual modeling to logical representation
Moniruzzaman et al. Nosql database: New era of databases for big data analytics-classification, characteristics and comparison
Lightstone et al. Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more
US20080294596A1 (en) System and method for processing queries for combined hierarchical dimensions
Li et al. Geospatial big data handling theory and methods: A review and research challenges
Bogorny et al. ST‐DMQL: a semantic trajectory data mining query language
US20130013552A1 (en) Interest-Driven Business Intelligence Systems and Methods of Data Analysis Using Interest-Driven Data Pipelines
US20040139102A1 (en) Parameterized database drill-through
Snodgrass et al. Spatiotemporal aggregate computation: A survey
Ballatore et al. Geographic knowledge extraction and semantic similarity in OpenStreetMap
Mingers et al. A review of theory and practice in scientometrics
Gupta et al. Cloud computing and big data analytics: what is new from databases perspective?
Rafanelli Multidimensional Databases: Problems and Solutions: Problems and Solutions
Nandi et al. Distributed cube materialization on holistic measures
Marchand et al. Implementation and evaluation of a hypercube-based method for spatiotemporal exploration and analysis
Alvares et al. Dynamic modeling of trajectory patterns using data mining and reverse engineering
Mohania et al. Advances and research directions in data-warehousing technology
CN103136337A (en) Distributed knowledge data mining device and mining method used for complex network
Chen et al. Regression cubes with lossless compression and aggregation
Samtani et al. Recent advances and research problems in data warehousing
Agarwal et al. Architecting object applications for high performance with relational databases
Yan et al. Topics in dynamic research communities: An exploratory study for the field of information retrieval
Fonseca Geospatial semantic web
Rivest et al. SOLAP: a new type of user interface to support spatio-temporal multidimensional data exploration and analysis
Shin et al. Denormalization strategies for data retrieval from data warehouses

Legal Events

Date Code Title Description
C06 Publication
C10 Entry into substantive examination
RJ01