Metadata Based Visualization System for Multidimensional Data

Abstract

Abstract-With the ability to measure and simulate more processes at finer scales, the number of data dimensions and data objects has grown significantly in today's datasets. Much existing research has focused on different visualizations for different data exploration tasks. In this paper, based on the financial management data of MAIN company, a financial management system is analyzed and designed, meanwhile, MAIN's important financial data are extracted, classified, and sorted out. with the analysis of financial data, a multidimensional (MD) data model based on the metadata was implemented; the system architecture and visualization exhibition pattern are designed based on BI(Business Intelligence) technology and an existing metadata management system; The Visualization Exhibition System was implemented by ASP.NET and Silverlight Technology. This system provides multiple perspectives and comprehensive query analysis functions for corporate decision makers and managers. It also provides a feasible solution of BI front-end display system for small and medium-sized enterprise.

Development of Star-Schema Model for Lecturer Performance in Research Activities

“…In the star-schema model, the fact table and dimension table are connected by a key known as a surrogate key which acts as the primary key of the dimension table and becomes a foreign key in the fact table [18]. This relation occurs logically and can be used to perform the JOIN process in the Query command.…”