DocumentCode :
548433
Title :
Methods and tools of on-line analytical data processing for Siberian region government
Author :
Nozhenkova, L.F. ; Korobko, A.V. ; Penkova, T.G.
Author_Institution :
Appl. Inf. Dept., Siberian Branch of Russian Acad. of Sci., Krasnoyarsk, Russia
fYear :
2011
fDate :
23-27 May 2011
Firstpage :
1571
Lastpage :
1575
Abstract :
The authoring OLAP-system “Analytic” based on integration of DOLAP architecture and MOLAP functionality is represented. The original embodiments of the OLAP rules realization are described. Functional modules of the “Analytic” are described. The data access tools for constructing cube based on data from different local sources (e.g. Excel, Access, InterBase, MySQL, Oracle) and data warehouse are developed. The data mart manage tools are developed. The dimensional cubes are processed by original OLAP tools: statistical table, cross-table, diagram and map for geographic data. The original high-level programming language to create scenario of the fact calculation in to a cube is realized. The cubes sharing method to store a cube as the materialized view and semantic metadata in the data warehouse is suggested. The method of creating and committing step-by-step calculating algorithm using pre-aggregated cubes is considered. Tools for forming operative and statistical reports based on results of OLAP are described. The complex of proposed methods and tools enables Siberian region government to improve effectiveness of decision making support based on OLAP. The “Analytic” usage for control medical care, governing in the field of social support and planning the social economic development of territories is represented by using the examples.
Keywords :
data mining; data warehouses; decision making; information retrieval; DOLAP architecture; MOLAP functionality; OLAP system; Siberian region government; data access tool; data mart manage tool; data warehouse; decision making; high level programming language; online analytical data processing; semantic metadata; social economic development; Data processing; Data warehouses; Decision making; Government; Semantics; Software;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
MIPRO, 2011 Proceedings of the 34th International Convention
Conference_Location :
Opatija
Print_ISBN :
978-1-4577-0996-8
Type :
conf
Filename :
5967311
Link To Document :
بازگشت