Architectural support for business intelligence: a push-pull mechanism

作者：Hua Jing Shiuan; Huang Shi Ming; Yen David C^*

来源：Online Information Review, 2012, 36(1): 52-71.

DOI：10.1108/14684521211206962

• Data warehouse
• Data cube
• Extensible Markup Language (XML)
• Business intelligence
• Push and pull mechanism
• Star schema
• Data handling
• Database management systems

Purpose - As business globalisation and internet usage continue to grow, the internet-based version of data warehouse systems (DWS) is expected to improve traditional DWS. However applying the web-based interfaces to client-server-based DWS structures may cause problems such as inflexibility, inefficiency, loss of scalability, and threats to security. These arise due to the complexity of manipulation and management of heterogeneous data with various categories of decisional tasks. This paper seeks to develop a flexible mechanism by applying Extensible Markup Language as a foundation for an internet-based DWS and to overcome the weaknesses of solely client-server-based DWS architecture. %26lt;br%26gt;Design/methodology/approach - For better control and security the proposed architecture utilises an embedded pull-push mechanism to propagate the distributed decision information. This research also justifies the feasibility of the proposed mechanism by implementing a prototype, evaluating its performance, and conducting a real business case study. %26lt;br%26gt;Findings - The results indicate that the mechanism can not only improve DWS scalability and efficiency, but also enhance security. %26lt;br%26gt;Originality/value - The proposed architecture provides a support mechanism for business intelligence to efficiently and flexibly help companies make the right decisions in real time, grasp business opportunities and gain competitive advantage.

• 出版日期2012