Abstract
In business contexts, data from several sources are usually collected, integrated, stored and analyzed to support decision-making at the operational, tactical or strategic organizational levels. For these several levels, with different data needs, this paper proposes a Common Data Framework for identifying and modeling the different data repositories that support those data needs. The proposed approach considers all the business needs expressed in business processes models and that were useful in the identification of the operational data model, for on-line transaction processing, the analytical data model, for a data warehousing system, and on-line analytical processing cubes for a traditional Business Intelligence environment. Besides providing an integrated framework in which the data models complement each other, this approach also allows checking the conformity of the data stored in the different repositories, being possible to identify business requirements that were not properly modeled.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Cunningham, D.: Aligning business intelligence with business processes. In: TDWI Research, vol. 20 (2005)
Marjanovic, O.: Business value creation through business processes management and operational business intelligence integration. In: Proceedings of the 43rd Hawaii International Conference on System Sciences (2010)
Cruz, E., Machado, R.J., Santos, M.Y.: Deriving a data model from a set of interrelated business process models. In: ICEIS 2015 - 17th International Conference on Enterprise Information Systems, vol. I, pp. 49–59 (2015)
Cruz, E., Machado, R.J., Santos, M.Y.: From business process modeling to data model: a systematic approach. In: 2012 Eighth International Conference on the Quality of Information and Communications Technology, pp. 205–210 (2012)
Santos, M.Y., Oliveira e Sá, J.: A data warehouse model for business processes data analytics. In: Proceedings of the 16th International Conference on Computational Science and Its Applications (ICCSA 2016), China, July 2016
Hann, K., Sapia, C., Balaschka, M.: Automatically generating OLAP schemata from conceptual graphical models. In: Proceedings of the 3rd ACM International Workshop on Data Warehousing and OLAP (DOLAP), pp. 9–16. ACM, New York (2000)
Peralta, V., Marotta, A., Ruggia, R.: Towards the automation of data warehouse design. Technical report TR-03-09, Universidad de la República, Montevideo, Uruguay (2003)
Tryfona, N., Busborg, F., Christiansen, J.G.B.: StarER: a conceptual model for data warehouse design. In: Proceedings of the 2nd ACM International Workshop on Data Warehousing and OLAP (DOLAP), pp. 3–8. ACM, New York (1999)
Song, I.-Y., Khare, R., An, Y., Lee, S., Kim, S.-P., Kim, J.-H., Moon, Y.-S.: SAMSTAR: an automatic tool for generating star schemas from an entity-relationship diagram. In: Li, Q., Spaccapietra, S., Yu, E., Olivé, A. (eds.) ER 2008. LNCS, vol. 5231, pp. 522–523. Springer, Heidelberg (2008)
Usman, M., Asghar, S., Fong, S.: Data mining and automatic OLAP schema generation. In: Fifth International Conference on Digital Information Management, pp. 35–43 (2010)
Pardillo, J., Mazón, J.-N., Trujillo, J.: Model-driven metadata for OLAP cubes from the conceptual modelling of data warehouses. In: Song, I.-Y., Eder, J., Nguyen, T.M. (eds.) DaWaK 2008. LNCS, vol. 5182, pp. 13–22. Springer, Heidelberg (2008)
OMG: Business process model and notation (BPMN), version 2.0. Technical report, Object Management Group (2011)
Bulos, D., Forsman, S.: Getting started with ADAPT™ - OLAP database design, symmetry corporation (2002)
Aalst, W.M.P., Medeiros, A.K.A., Weijters, A.J.M.M.: Genetic process mining. In: 26th International Conference Applications and Theory of Petri Nets, ICATPN 2005, Miami, USA, pp. 48–69, June 20–25 2005
Acknowledgments
This work has been supported by COMPETE: POCI-01-0145-FEDER-007043 and FCT (Fundação para a Ciência e Tecnologia) within the Project Scope: UID/CEC/00319/2013, and by Portugal Incentive System for Research and Technological Development, Project in co-promotion nº 002814/2015 (iFACTORY 2015–2018). Some of the figures in this paper use icons made by Freepik, from www.flaticon.com.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2016 Springer International Publishing Switzerland
About this paper
Cite this paper
Santos, M.Y., Oliveira e Sá, J., Andrade, C. (2016). Towards a Common Data Framework for Analytical Environments. In: Gervasi, O., et al. Computational Science and Its Applications – ICCSA 2016. ICCSA 2016. Lecture Notes in Computer Science(), vol 9790. Springer, Cham. https://doi.org/10.1007/978-3-319-42092-9_21
Download citation
DOI: https://doi.org/10.1007/978-3-319-42092-9_21
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-42091-2
Online ISBN: 978-3-319-42092-9
eBook Packages: Computer ScienceComputer Science (R0)