Skip to main content
SpringerLink
Log in

Contextual snowflake modelling for pattern warehouse logical design

  • Published:
Sadhana Aims and scope Submit manuscript

Abstract

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 via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Figure 1
Figure 2
Figure 3
Figure 4

Similar content being viewed by others

References

  • 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

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

    Article  Google Scholar 

  • 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)

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

    Article  Google Scholar 

  • 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

  • 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

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

  • 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, http://www.knom.or.kr/knom-review/v4n2/1.pdf, Accessed on 11/Aug/2014

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

    Article  Google Scholar 

  • 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

  • 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

  • Michael Eldridge 2010 Enterprise Data Warehouse: A Patterns Approach to Data Integration, Microsoft IT showcase, ©2010, Microsoft Corporation. http://www.microsoft.com/technet/itshowcase

  • 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

    Google Scholar 

  • 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

    Article  Google Scholar 

  • 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

  • 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

    Article  Google Scholar 

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

  • 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

  • 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

  • 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

  • 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, http://dke.cti.gr/panda

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

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

Download references

Author information

Authors and Affiliations

  1. Maulana Azad National Institute of Technology (MA-NIT), Bhopal, 462 007, India

    VIVEK TIWARI & RAMJEEVAN SINGH THAKUR

Authors
  1. VIVEK TIWARI
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. RAMJEEVAN SINGH THAKUR
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to VIVEK TIWARI.

Rights and permissions

Reprints and permissions

About this article

Check for updates. 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). https://doi.org/10.1007/s12046-014-0304-z

Download citation

  • Received:

  • Revised:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s12046-014-0304-z

Keywords

Search

Navigation