Data Ring - A Structure for Data Cube Operations

• Main Authors: Ming-Cheng Chiu, 邱明政
• Other Authors: Chin-Yun Hsieh
• Format: Others
• Language: zh-TW
• Published: 1999
• Online Access: http://ndltd.ncl.edu.tw/handle/89282248514693619123

碩士 === 國立臺北科技大學 === 電腦通訊與控制研究所 === 87 === OLAP (On-Line Analytical Processing) is an important tool for data analysis. The data structure used by OLAP is called data cube. The data cube is constructed from multidimensional data structures and is used to support data manipulations such as pivoting, slicing & dicing, drill down and roll up, etc. In this thesis, a data ring model is proposed as a metaphor for the user to directly manipulate and visualize the data cube. The key feature of the data ring model is that it overcomes the problem of displaying multidimensional chart on OLAP system. In addition, by using charts as the primary tool instead of tables, the data analysis process can be conducted in a more intuitive way. Operations of the data ring are translated to SQL statements, which allows the data ring to operate directly on relational databases. Essential, the proposed data ring provides a consistent environment for data navigation, manipulation and visualization for online analysis.