Abstract
Companies today have several major issues while managing information. Many subsidiaries and departments have developed their own Data Management which has led to a multitude of Operational Databases and sometimes a multitude of Data Marts, policies and processes. Thus, these systems lack sustainability because they are not dynamic and not self-organizing, and so they do not adapt to the continuous needs arising from evolution that the companies experience. The Dynamic Data Mart architecture is built around 6 main functions, namely the 3Ms (Data Mining, Data Marshalling and Data Meshing) and the 3Rs (Recommendation, Reconciliation and Representation), which will address the aforementioned problems. Once the totality of the data have been loaded into a single Data Warehouse, the Dynamics Data Marts address these problems by mining the user’s behavior and the user’s decision making processes and continuously and automatically adapting the Data Mart to the needs of the users. Dynamic Data Marts create adapted dimensions, facts, data associations and views and then automatically find the ones that are not used anymore. These latter are then automatically dropped by the system, or can be presented to the IT manager if needed for validation of their removal.
Chapter PDF
Similar content being viewed by others
References
Rahayu, J.W., Chang, E., Dillon, T.S., Taniar, D.: Performance Evaluation of The Object-Relational transformation methodology. Data Knowledge Engineering 38(3), 265–300 (2001)
Rahayu, J.W., Chang, E., Dillon, T.S., Taniar, D.: A methodology for transforming inheritance relationships in an object-oriented conceptual model to relational tables. Information & Software Technology 42(8), 571–592 (2000)
Chan, H., Lee, R., Dillon, T., Chang, E.: E-commerce Principles and Practice. John Wiley and Sons, November 2001
The Microsoft Modern Data Warehouse, Microsoft Corporation (2013/2014)
Data Integration Architectures for Operational Data Warehousing. Oracle (2012)
Data Virtualisation, Denodo Technologies (2014). http://www.denodo.com/en/system/files/document-attachments/data_virtualization_goes_mainstream.pdf
Data Virtualisation, Data Source (2013). http://datasourceconsulting.com/8-steps-data-virtualization/
Integrating Data Warehouse with Data Virtualisation. Intel (2013). http://www.intel.com.au/content/dam/www/public/us/en/documents/white-papers/virtualization-integrating-data-warehouses-for-bi-agility-paper.pdf
SAP HANA and Data Virtualisation. SAP Technology (2012). http://stats.manticoretechnology.com/ImgHost/582/12917/2012/Resources/HANA-DV.pdf
Malinowski, E., Zimányi, E.: Logical Representation of a Conceptual Model for Spatial Data Warehouses. GeoInformatica 11(4), 431–457 (2007). Springer
Fidalgo, R.N., Times, V.C., da Silva, J., Souza, F.F.: GeoDWFrame: a framework for guiding the design of geographical dimensional schemas. In: Kambayashi, Y., Mohania, M., Wöß, W. (eds.) DaWaK 2004. LNCS, vol. 3181, pp. 26–37. Springer, Heidelberg (2004)
Glorio, O., Mazón, J.-N., Garrigós, I., Trujillo, J.: A personalization process for spatial data warehouse development. Decision Support Systems (2012)
Stefanovic, N., Han, J., Koperski, K.: Object-Based Selective Materialization for Efficient Implementation of Spatial Data Cubes. IEEE Transactions on Knowledge and Data Engineering (2000)
Kern, R., Stolarczyk, T., Nguyen, N.T.: A formal framework for query decomposition and knowledge integration in data warehouse federations. Expert Systems Applications 40 (2013)
Jarke, M., List, T., Koller, J.: The Challenge of Process Data Warehousing. VLDB conference (2000)
Gartner, Magic Quadrant Data Warehouse Data Management Solutions for Analytics (2015)
Gartner, Magic Quadrant for Data Quality Tools (2014)
ThoughtWeb, Logical Data Warehousing for Big Data (2013)
Data Integration Architectures for Operational Data Warehousing. Oracle (2012)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 IFIP International Federation for Information Processing
About this paper
Cite this paper
Chang, E., Rahayu, W., Diallo, M., Machizaud, M. (2015). Dynamic Data Mart for Business Intelligence. In: Dillon, T. (eds) Artificial Intelligence in Theory and Practice IV. IFIP AI 2015. IFIP Advances in Information and Communication Technology, vol 465. Springer, Cham. https://doi.org/10.1007/978-3-319-25261-2_5
Download citation
DOI: https://doi.org/10.1007/978-3-319-25261-2_5
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-25260-5
Online ISBN: 978-3-319-25261-2
eBook Packages: Computer ScienceComputer Science (R0)