Abstract

This paper presents a new approach to develop the strategy of Model–View–Controller architecture pattern in Business Intelligence (BI) architecture. The Business Intelligence architecture consists of the ETL tools and processes, the data warehouse, the technical infrastructure, and the user-interface tools. The major issue related to Business Intelligence architecture is to store the data from heterogeneous sources. The heterogeneous sources might lead to inconsistencies in storage and retrieval of data. Another issue related to Business Intelligence architecture is to provide multiple and synchronized views. The Business information must be presentable in various formats with 'look and feel' approach. Model-View-Controller provides independent approach to the components of Business Intelligence architecture. Model provides guideline for storing the heterogeneous data in one format and implements core functionality of the system. View provides multiple and synchronized views so that information can be available in presentable format. Controller handles user's input. All the three independent components are tightly coupled which ensures consistent and flexible Business Intelligence architecture.

References

• The format for defining Business Intelligence Architecture in terms of Model-View-Controller architecture pattern we have reference book : Frank Buschmann, Regine Meunier ,Hans Rohnert ,Peter Sornmerlad , Michael Stal, Pattern Oriented Software architecture, volume 1, February 2001.
• Business Decisions: http://ijircce. com/upload/2013/june/26_BUSINESS. pdf.
• About Model-View-Controller http://en. wikipedia. org/wiki/Model-view-controller
• Concept of Class responsibility collaboration card: http://en. wikipedia. org/wiki/Class-responsibility-collaboration_card
• http://www. b-eye-network. com/view/7105
• Five layered Business Intelligence architecture: http://www. ibimapublishing. com/journals/CIBIMA/2011/695619/695619. pdf.
• concept of structured and unstructured data: http://www. brightplanet. com/2012/06/structured-vs-unstructured-data/
• Concept of internal and external data: http://chdexpert. wordpress. com/2012/03/30/database-fundamentals-internal-and-external-data-sources/.
• Concept of Customer Relationship Management: http://en. wikipedia. org/wiki/Customer_relationship_management
• Concept of Enterprise Resource planning: http://en. wikipedia. org/wiki/Enterprise_resource_planning
• Concept of data noisy data: http://www. mimuw. edu. pl/~son/datamining/DM/4-preprocess. pdf
• http://en. wikipedia. org/wiki/Business_rules_approach
• concept of data staging: http://data-warehouses. net/architecture/staging. html
• for data warehousing fundamentals and characteristics: Data Warehousing 2. 0 by Inmon
• Non-functional properties of software architecture: Software Architecture: Foundations, Theory, and Practice by Richard N. Taylor.
• http://www. garlic. com/~lynn/secure. htm
• concept of stakeholders: http://en. wikipedia. org/wiki/Stakeholder
• operational system in data warehouse : http://data-warehouses. net/architecture/operational. html