Springer Nature is making SARS-CoV-2 and COVID-19 research free. View research | View latest news | Sign up for updates

Contextual snowflake modelling for pattern warehouse logical design


Pattern warehouse provides the infrastructure for knowledge representation and mining by allowing the patterns to be stored permanently. The goal of this paper is to discuss the pattern warehouse design and related quality issues. In the present work, we focus on conceptual and logical design of pattern warehouse, by introducing a context and ‘kind of knowledge’ hierarchy to this end. For the simplicity, association kinds of patterns are considered for running examples. We have extended well-known ‘snowflake’ schema for pattern warehouse logical design. We have introduced a new concept hierarchy ‘kind of knowledge’ which helps to arrange patterns, the four quality forms (QF) are also discussed which will work as guidelines for pattern warehouse conceptual and logical design to minimize the evaluation and maintenance cost. In particular, we address the three main issues: (i) conceptual design, (ii) snowflake schema and (iii) pattern refreshment.

This is a preview of subscription content, log in to check access.

Figure 1
Figure 2
Figure 3
Figure 4


  1. Barbara C and Anna M 2005 PSYCHO: A prototype system for pattern management. In: Proceeding of the 31st International Conference on Very Large Data Bases (VLDB), (pp)1346–1349, Trondheim, Norway, ACM

  2. Batra D 2005 Conceptual data modelling patterns: Representation and validation. J. Database Management (JDM), 16(2) 84–106 IGI Global

  3. Bouzeghoub M, Fabret F, and Matulovic-Broqué M 1999 Modelling the data warehouse refreshment process as a Workflow Application. In: Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW), 19(6)

  4. Bartolini I, Ciaccia P, Ntoutsi I, Patella M, and Theodoridiss Y 2004 A unified and flexible framework for comparing simple and complex patterns. In: Proceedings of ECML-PKDD’04, LNAI 3202, 496–499: Springer Berlin Heidelberg

  5. Catania B, Maddalena A, Maurizio M, Bertino E, and Rizzi S 2004 A framework for data mining pattern management. In: Proceeding of 8th European Conference Knowledge Discovery in Databases: PKDD, Pisa, Italy, 87–98, Springer, Berlin Heidelberg

  6. Evangelos K and Irene N 2005 Database support for data mining patterns. In Proceedings of the 10th Panhellenic conference on Advances in Informatics, 14–24, Springer, Berlin Heidelberg

  7. Giorgini P, Rizzi S, and Garzetti M 2005 Goal-oriented requirement analysis for data warehouse design. In: Proceedings of the 8th ACM International Workshop on Data warehousing and OLAP (pp). 47–56 ACM

  8. Golfarelli M, Rizzi S, and Cella I 2004 Beyond data warehousing: What’s next in business intelligence? In: Proceedings of the 7th ACM International Workshop on Data warehousing and OLAP (pp). 1–6, Washington, DC, USA, ACM

  9. Hurtado C A, Gutiérrez C, and Mendelzon A O 2005 Capturing summarizability with integrity constraints in OLAP. ACM Trans. Database Syst., 30(3) 854–886

  10. Hüsemann B, Lechtenbörger J, and Vossen G 2000 Conceptual data warehouse design. In: Proceedings of the International Workshop on Design and Management of DataWarehouses (DMDW), (pp) 3–9, Stockholm, Sweden

  11. Ilaria B, Elisa B, Barbara C, Paolo C, Matteo G, Marco P, and Rizzi S 2003 Patterns for Next-generation Database systems: preliminary results of the PANDA project. In: Proceeding the Eleventh Italian Symposium on Advanced Database Systems, SEBD 2003, Cetraro (CS), Italy

  12. Inmon W H 2005 Building the Data Warehouse, 4th edition, John Wiley and Sons, Inc., New York

  13. Jaesoon P, Youngwok K, and Youngmin C 2002 The concept of pattern warehouse and contemplate an application in integrated network data ware. Telecommunication Network Lab., Korea Telecom,, Accessed on 11/Aug/2014

  14. Levene M and Loizou G 2003 Why is the snowflake schema a good data warehouse design? Information Systems, 28(3) 225–240

  15. Lenz H J and Shoshani A 1997 Summarizability in OLAP and statistical data bases. In: Proceedings of Ninth International Conference on Scientific and Statistical Database Management. (pp) 132–143). IEEE

  16. Mazón J N, Lechtenbörger J, and Trujillo J 2008 Solving summarizability problems in fact-dimension relationships for multidimensional models. In: ACM 11th International Workshop on Data Warehousing and OLAP (DOLAP 08), Napa Valley, USA, (pp) 57–64

  17. Michael Eldridge 2010 Enterprise Data Warehouse: A Patterns Approach to Data Integration, Microsoft IT showcase, ©2010, Microsoft Corporation.

  18. Mohammad R, Keivan K, Reda A, and Mick J R 2009 Data modeling for effective data warehouse architecture and design. Int. J. Inf. Decision Sci., 1(3) 282–300 Inderscience

  19. Manolis T, Vassiliadis P, and Spiros S 2007 Modelling and language support for the management of pattern-bases. Data & Knowledge Eng., 62(2) 368–397

  20. Manolis T and Vassiliadis P 2003 Architecture for pattern base management systems. Department of Electrical and Computer Engineering. PANDA workshop, National Technical University of Athens

  21. Riccardo A, Elena C, Monica D M, Franca G, and Marina M 2011 Context dependent semantic granularity. Int. J. Data Mining, Modeling and Management (IJDMMM), 3(2) 189–215 InderScience

  22. Rizzi S 2004 UML-Based conceptual modeling of pattern-bases. In: Proceedings of the International Workshop on Pattern Representation and Management (PaRMa), Heraklion, Hellas

  23. Rizzi S, Bertino E, Catania B, Golfarelli M, Halkidi M, Terrovitis M, Vassiliadis P, Vazirgiannis M, and Vrahnos E 2003 Towards a logical model for patterns. In: Proceeding of ER Conference, Chicago, IL, USA, (pp) 77–90, Springer, Berlin Heidelberg

  24. Tiwari V, Gupta S, and Tiwari R 2010 Association rule mining: A graph based approach for mining frequent itemsets. In: Networking and Information Technology (ICNIT), 2010 International Conference, (pp) 309–313, IEEE

  25. Tiwari V and Thakur R S 2014 P2ms: A Phase-Wise Pattern Management System for Pattern Warehouse. Int. J. Data Mining, Modeling and Management (IJDMMM), Inderscience

  26. Vazirgiannis M, Halkidi M, Tsatsaronis G, and Vrachnos E 2003 A Survey on Pattern Application Domains and Pattern Management Approaches. PANDA Technical Report TR- 2003-01, Available at,

  27. Vassiliadis P 2000 Data warehouse modeling and quality issues. National Technical University of Athens Zographou, Athens, GREECE

  28. Zdenka T 2012 Data modeling and ontological semantics. Int. J. Data Analysis Techniques and Strategies 4(3): 237–255 Inderscience

Download references

Author information

Correspondence to VIVEK TIWARI.

Rights and permissions

Reprints and Permissions

About this article

Verify currency and authenticity via CrossMark

Cite this article

TIWARI, V., THAKUR, R.S. Contextual snowflake modelling for pattern warehouse logical design. Sadhana 40, 15–33 (2015).

Download citation


  • Pattern warehouse
  • pattern warehouse management systems (PWMS)
  • data models
  • knowledge warehousing
  • conceptual modelling
  • context modelling
  • quality forms