Chapter 2 An Integrated Business Intelligence Framework Closing the Gap Between IT Support for Management and for Production
H.-G. Kemper,H. Baars,H. Lasi
Abstract:Information Technology (IT) support in the manufacturing sector has reached a watershed with digital components beginning to permeate all products and processes. The classical divide between “technical” IT and “business” IT begins to blend more and more. Data from design, manufacturing, product use, service, and support is made available across the complete product lifecycle and supply chain. This goes hand in hand with the diffusion of sensor and identification technology and the availability of relevant information streams on the customer side—leading to unprecedented amounts of data. The challenge is to purposefully apply emerging BI concepts for a comprehensive decision support that integrates product and shop floor design phases, the steering and design of operational industrial processes, as well as big and unstructured data sources. This chapter brings those pieces together in order to derive an integrated framework for management and decision support in the manufacturing sector. 2.1 A New Role for Business Intelligence in the Manufacturing Sector Globalization, scarcity of natural resources, complexity, and the powerful rise of the BRICS economies are the biggest challenges for the leading industrialized countries. For these nations, the major tasks for the next 20 years will be securing versatile production capabilities, resource efficient engineering environments, and a consequent time-to-market delivery of highly sophisticated industrial products [1]. In order to cope with these challenges, engineers are concentrating their research activities on complex concepts like the “Digital Factory” or “Intelligent Production Systems” as well as on introducing a variety of systems for steering and controlling their specific, production oriented operational processes. The main objective of these measures is to fully digitalize and integrate all processes of the product lifecycle and across supply chains [1]. In these contexts, large volumes of data are H.-G. Kemper (B) · H. Baars · H. Lasi Chair of Information Systems I, University of Stuttgart, Stuttgart, Germany e-mail: kemper@wi.uni-stuttgart.de P. Rausch et al. (eds.), Business Intelligence and Performance Management, Advanced Information and Knowledge Processing, DOI 10.1007/978-1-4471-4866-1_2, © Springer-Verlag London 2013 13 14 H.-G. Kemper et al. generated and stored within the IT infrastructures that support engineering, production, and logistics. The integration of this technical-oriented data with management support information, however, is still unsatisfactory. An integrated strategic, administrative, and operational control and a comprehensive managerial decision support still promises relevant untapped business potential. This article focuses on this topic. It extends and adapts the BI framework by [28] that has been introduced in Chap. 1 and derives an integrated framework for closing the gap between managementand production-oriented IT support. 2.2 Reshaping the BI Toolset The more comprehensive the BI-based decision support becomes and the closer it is linked to the actual (and in the realm of manufacturing: physical) business processes, the more questions arise regarding requirements for an augmentation of classical BIsystems. Required are pertinent components and concepts for defining the interplay between the evolving BI landscape and existing operational application systems. Additionally, striving for a detailed understanding of processes leads not only to an ever increasing volume of data of both structured and unstructured nature but also to volatile use profiles and workloads. In the following, existing concepts dealing with these developments are introduced. These are later contrasted with available systems for the support of the product lifecycle in the manufacturing sector. 2.2.1 Operational BI and BI and Business Process Management The diffusion of BI into operational and tactical management layers has been discussed under the label “Operational BI” (OpBI) [17, 38]. The term OpBI is problematic because it does not clearly distinguish between the realm of BI and that of operational systems. In fact, some examples given by vendors appear to be rather manifestations of an insufficient operational support than of an innate need for new BI applications. If there already is a mature IT landscape in place—as in the manufacturing industry—the claim of a better operational decision support needs to be thoroughly substantiated [32]. This does not mean that OpBI is without merits. BItechnologies come into play when they can exert their strengths: Integrating large volumes of data from various sources, refining them for the purposes of decision support, and presenting the results in a comprehensive fashion. This is also why OpBI is so closely related to the connection between business process management and BI—an area where the aspect of integration clearly comes into focus. There are various facets of this, which are covered in different, partly overlapping concepts [27]. A widespread example for viable OpBI is the area of Business Application Monitoring (BAM). In this case, data from various sources is combined in near-real-time 2 An Integrated Business Intelligence Framework 15 to process-level key performance indicators (KPIs) and visualized via operational dashboards (e.g. on the status of open orders, delivery processes etc.). BAM applications are often embedded in broader concepts for Business Process and Business Performance Management, which aim at providing a consistent base of indicators across process steps and managerial levels [22, 42]. An approach that goes beyond the mere presentation of refined data is “Processcentric BI”. Here, next to data, analytic functionality is embedded into operational systems in order to enable operational staff to conduct analysis on operational data [11]. The term “Embedded BI” goes even further. It denotes the application of BI functionality to process data from local repositories [30]. In this case, however, the specific contribution of a BI system is not obvious. While the discussed OpBI concepts are directed towards an inclusion into running processes, Business Process Intelligence (BPI) has a more strategic momentum. BPI is concerned with the analysis of data on process instances for purposes of uncovering and optimizing the underlying process structures and models [16, 23, 38]. An example for a BPI application is process mining where operational log files are used for the extraction, enrichment, and evaluation of as-is-processstructures [44]. Another option for BPI is tailoring existing BI analysis tools (OLAP, reporting) [9, 14]. This, however, makes it necessary to extract, store, and handle data on the process logic rather than just on the process results, i.e. the order of activities and the related constrains need to be traceable. The concepts developed for this include the introduction of a respective “Process DWH” that is designed for such an analysis [47, 50]. Examples for relevant sources of process data in the realm of manufacturing are the Manufacturing Execution Systems (MES) or systems which allow an automatic tracing of objects, e.g. based on RFID technology (cf. Sect. 2.3). 2.2.2 Big Data, Cloud BI, and In-Memory BI Collecting relevant data for the in-depth analysis of processes and activities on the operational layer leads to data repositories with sizes beyond those of ordinary DWHs. The relevant data can come in various forms—structured machine and sensor data, semi-structured reports form quality testing, feedback e-mails from customers, product evaluations on web pages, discussions in social networks, etc. Performance bottlenecks have always been an issue in BI that required an arsenal of strategies on multiple levels [10]. Nowadays, however, data volumes reach a level that classical relational technologies cannot efficiently handle anymore. This topic is currently summarized under the rather unspecific term Big Data [26, 37]. It can be dealt with in various ways, which can in parts also be applied in combination. One approach, particularly suited for conglomerates of semi-, and unstructured data (“polystructured data”), is to apply database technologies that relax the strict scheme requirements of relational data bases as a trade-off for a better distribution of the data processing tasks and a higher query performance (“NoSQL”—not only 16 H.-G. Kemper et al. SQL). Examples include key-value stores, document stores, and extensible record stores [12, 45]. Contemporary NoSQL BigData repositories are particularly suited for parallelizing data aggregation and analysis task and for utilizing large clusters of computing infrastructure. While their eventual role in the domain of BI remains yet unclear, Big Data stores seem to be particularly interesting as data sources and as components for pre-processing the semior unstructured contents residing within those sources. Their applicability as full-scale replacements for a business-oriented DWH is limited however, as they are by design not meant to guarantee full consistency at all points of time (“BASE” model—Basically Available, Soft state, Eventual consistency). A second strategy for dealing with large data sets that is intensively discussed is to apply “In-Memory data base” solutions. In-Memory solutions are tailored for handling larger volumes of data in the higher layers of the memory hierarchy, i.e. Random Access Memory (RAM), processor cache, and processor registers. Combined with pertinent data structures (e.g. a column-based instead of row-based storage of data base tables) this can lead to significant gains in query performance, e.g. in OLAP solutions [40, 41]. Implementations can particularly be found in specific DWH and/or OLAP appliances. The suitability for OpBI solutions is palpable— which leads some authors to the conclusion that in the future managerial and operational enterprise systems will rest upon a (re)unifie