Abstract

In tandem with the growth of the Internet and e-business, the number of digital data sources has increased immensely. These data sources contain important transactional data and are generally interconnected via a network. This has created a pressing need for a suitable executive information system (EIS) that is capable of extracting data from internal and external data sources and providing data analysis on demand for business executives. On-demand data analysis requires an information integration approach that can manage rapid changes in data sources. Existing EISs commonly adopt data warehousing technology to consolidate data from multiple sources in a tailor-made fashion, and support predefined multidimensional data analysis. However, this architecture is neither adaptable to changes in local sources nor flexible enough for ad hoc analyses. This paper develops methods and algorithms for a new EIS architecture that takes advantage of a metadatabase to achieve adaptability and flexibility. A PC-based prototype is built to prove the concept.

Keywords: Executive information systems; Systems integration; Metadatabase management system; Data warehouse; On-line analytical processing

Article Outline

1. Introduction

2. A metadata-based EIS architecture

2.1. The metadatabase system

2.2. The ROLAP/MDB Analyzer

2.3. The ROLAP/MDB Interface

3. An illustrative scenario

4. The ROLAP/MDB Analyzer

4.1. MAU generation and dimension determination

4.1.1. Saving the MAU

4.1.2. Creating the MAU

4.1.3. Ordering indicators or dimensions for selection

4.2. MAU sub-view retrieval and materialization

5. The ROLAP/MDB Interface

5.1. Indicator browsing

5.2. Dimension selection

5.3. Multidimensional data analysis

6. Evaluation of the new EIS architecture

7. Conclusion

Appendix A. Metric for classifying indicators and dimensions

References

Vitae