An Integrated Model of Information Sources for Statistical Analysis in an Organization

• Main Authors: Chih-Chin Su, 蘇志青
• Other Authors: Tain-Sue Jan
• Format: Others
• Language: zh-TW
• Published: 2000
• Online Access: http://ndltd.ncl.edu.tw/handle/82750427782312182671

博士 === 國立交通大學 === 經營管理研究所 === 88 === Statistical information is vital for business analysis, and information sources which form the basis of such analysis may be obtained from daily operational databases, statistical databases, and multidimensional databases. However, extraction of the information separately from those databases, is limited by many problems such as access inefficiency, historical databases as a whole, and security of confidential data, etc. This paper proposes an architecture to integrate the three kinds of databases by developing a statistical data store for statistical analysis according to the features of the statistical database, object-oriented viewpoint, and data warehouse method. The architecture includes three processes. The first collects and analyzes statistical information requirements in terms of statistical objects, which are further organized into higher survey objects. The next process is the back-end process of developing statistical databases from the existing operational systems according to the objects. The multidimensional databases can then be established from the statistical databases. The final process is the front-end process of using various methods to extract the statistical information from the databases. An example is presented to illustrate the process. If the statistical data store can be developed in such a way, the commercial database systems, OLAP, powerful statistical packages, and self-developed methods, may all be used to extract statistical information, and the capacity to provide such information will be significantly improved.