Abstract
Association rules (AR) are one of the most popular data mining techniques in searching databases for frequently occurring patterns. In this paper, we present a novel approach to accomplish the conceptual design of data warehouses together with data mining association rules, allowing us to implement the association rules defined in the conceptual modeling phase. The great advantage of our approach is that the association rules are specified from the early stages of a data warehouse project and based on the main final user requirements and data warehouse goals, instead of specifying them on the final database implementation structures such as tables, rows or columns. Finally, to show the benefit of our approach we implement the specified association rules on a commercial data warehouse management server.
Access provided by Autonomous University of Puebla. Download to read the full chapter text
Chapter PDF
Similar content being viewed by others
Keywords
References
Luján-Mora, S., Trujillo, J., Song, I.: Extending the UML for Multidimensional Modeling. In: Jézéquel, J.-M., Hussmann, H., Cook, S. (eds.) UML 2002. LNCS, vol. 2460, pp. 290–304. Springer, Heidelberg (2002)
Agrawal, R., Imielinski, T., Swami, A.: Mining Asociation Rules between Sets of Items in Large Databases. In: Proc. ACM SIGMOD 1993, Washington, DC, pp. 207–216 (1993)
Botta, M., Boulicaut, J., Masson, C., Meo, R.: A Comparison between Query Languages for the Extraction of Association Rules. In: Kambayashi, Y., Winiwarter, W., Arikawa, M. (eds.) DaWaK 2002. LNCS, vol. 2454, pp. 1–10. Springer, Heidelberg (2002)
Ng, E., Fu, A., Wang, K.: Mining Association Rules from Stars. In: ICDM (IEEE) Maebashi TERRSA, Maebashi City, Japan, December 9 - 12, pp. 322–329 (2002)
Dehaspe, L., Raedt, L.: Mining association rules in multiple relations. In: Džeroski, S., Lavrač, N. (eds.) ILP 1997. LNCS, vol. 1297, pp. 125–132. Springer, Heidelberg (1997)
Nestorov, S., Jukić, N.: Ad-Hoc Association-Rule Mining within the Data Warehouse. In: Proceedings of the 36th Hawaii International Conference on System Sciences (HICSS 2003) (2003)
OMG: CWM Common Warehouse Metamodel Specification, http://www.omg.org
OMG: UML Unified Modeling Language Specification 1.5 (2004)
Rizzi, S., et al.: Toward a logical model for patterns. In: Proc. ER Conference, Chicago, pp. 77–90 (2003)
Rizzi, S.: UML-Based Conceptual Modeling of Pattern-Bases. In: Proc. 1st Int. Workshop on Pattern Representation and Management (PaRMa 2004), Crete, Greece (March 2004)
Imielinski, T., Virmani, A.: MSQL: A Query Language for Database Mining. Data Mining and Knowledge Discovery 3, 373–408 (1999)
Han, J., Fu, J., Wang, W., Koperski, K., Zaiane, O.: DMQL: A Data Mining Query Language for Relational Databases. In: SIGMOD 1996 Workshop on Research Issues in Data Mining and Knowledge Discovery (DMKD 1996), Montreal, Canada (1996)
Meo, R., Psaila, G., Geri, S.: A new SQL-like operator for mining association rules. In: Proceedings of the 2nd Int’l Conference on Very Large Databases, India, September 1998 (1998)
Trujillo, J., et al.: Designing Data Warehouses with OO Conceptual Models. IEEE Computer, special issue on Data Warehouses (34), 66–75 (2001)
Gogolla, M., Henderson, B.: Analysis of UML Stereotypes within the UML Metamodel. In: 5th Int. Conf. on the UML- The Language and its Applications, Dresden. Springer, Heidelberg (2002)
Warmer, J., Kleppe, A.: The Object Constraint Language. In: Getting Your Models Ready for MDA, 2nd edn. Addison Wesley, Reading (2003)
Günzel, H., Albrecht, J., Lehner, W.: Data Mining in a Multidimensional Environment. In: Eder, J., Rozman, I., Welzer, T. (eds.) ADBIS 1999. LNCS, vol. 1691, pp. 191–204. Springer, Heidelberg (1999)
Cokrowijoyo, H., Taniar, D.: A framework for mining association rules in Data Warehouses. In: Yang, Z.R., Yin, H., Everson, R.M. (eds.) IDEAL 2004. LNCS, vol. 3177, pp. 159–165. Springer, Heidelberg (2004)
Luján-Mora, S., Trujillo, J., Song, I.: Multidimensional modeling with UML package diagrams. In: Spaccapietra, S., March, S.T., Kambayashi, Y. (eds.) ER 2002. LNCS, vol. 2503, pp. 199–213. Springer, Heidelberg (2002)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Zubcoff, J.J., Trujillo, J. (2005). Extending the UML for Designing Association Rule Mining Models for Data Warehouses. In: Tjoa, A.M., Trujillo, J. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2005. Lecture Notes in Computer Science, vol 3589. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11546849_2
Download citation
DOI: https://doi.org/10.1007/11546849_2
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-28558-8
Online ISBN: 978-3-540-31732-6
eBook Packages: Computer ScienceComputer Science (R0)