MATHIS: a New Approach for Creating Views to Materialize in a Hybrid Integration System

(*) Corresponding author

Authors' affiliations

DOI's assignment:
the author of the article can submit here a request for assignment of a DOI number to this resource!
Cost of the service: euros 10,00 (for a DOI)


The vulgarization of information and telecommunications technologies has made the integration systems an immediate necessity. Among the latter, there are the hybrid integration systems. These offer a local database where it stores a part of data while integrating the other part virtually. This in the objective to increases system performance while ensuring a tradeoff between query response time and data freshness. The approach that has proposed a complete solution is one that creates the candidate views for materialization before selecting among them those that will be materialized. To do this, it selects the attributes most requested by users. Calling the algorithm k-schema, these attributes are organized in schemas, on which we based to build the candidate views for materialization. This approach suffers from a defect. It is because in the phase of the extraction of attributes of interest, we based only on their frequencies of appearance in the user queries. This will select some attributes, even if they do not respond to any selection criterion. Thus, they cause the elimination, in the selection phase, of views to which they were assigned. In this paper, we propose a new approach, which eliminates all attributes that do not respond to the selection criteria prior to the creation of views to materialize. We also propose a new solution to calculate the values of attributes relative to different criteria.
Copyright © 2013 Praise Worthy Prize - All rights reserved.


Views Creation; Attributes Selection; Hybrid Integration Systems; Information Integration; Materialization

Full Text:



Laura Haas, " Beauty and the beast: The theory and practice of information integration ". ICDT, 2007.

Elmagarmid A., M. Rusinkiewicz et A. Sheth. " Management of Heterogeneous and Autonomous Database Systems ". Morgan Kaufmann, San Francisco, 1999.

Wiederhold, G.: “Mediators in the architecture of future information systems”. IEEE Computer, Vol. 25(3):38-49, 1992.

J. Widom., Integrating Heterogeneous Databases: Lazy or Eager?, ACM Computing Surveys 28A(4), Décembre 1996.

Voisard, A. and Jürgens, M. “Geospatial Information Extraction: Querying or Quarrying?”. In Goodchild M, Egenhofer M, Fegeas R, Kottman C, eds. Interoperating Geographic Information Systems. 1sted. Dordrecht: Kluwer Academic. 165–79, 1999.

A. Zellou. “Contribution à la réécriture LAV dans le contexte de WASSIT, vers un Framework d’intégration de ressources ”. Thèse de Doctorat. Rabat. Maroc. Avril 2008.

R. Hull, G. Zhou, University of Colorado. " A Framework for Supporting Data Integration Using the Materialized and Virtual Approaches". SIGMOD’96 6/96 Montreal, Canada.1996.

N. Ashish, C. A. Knoblock and C. Shahabi, “selectively materializing data in mediators by analyzing user queries”, in Fourth IFCIS Conference on Cooperative Information Systems, pages, 1999.

N. Ashish, “optimizing information mediators by selectively meterializing data”, Ph.D dissertation, Departement of computer Science. faculty of the graduate school, university of southern california, 2000.

N. Ashish, “selectively materializing data in mediators by analyzing user queries”, in International Journal of Cooperative Information Systems Vol. 11, Nos. 1 & 2, 2002.

V. Y. Bichutskiy, R. Colman, R. K.. Barchmann and R. H. Lathrop, “Heterogeneous Biomedical Database Integration Using a Hybrid Strategy: A p53 Cancer Research Database”. Cancer Informatics 2006.

W. Hadi., A. Zellou, B. Bounabat, “Hybrid information integration: fuzzy controller for selecting views to materialize”, in 7th international conference on intelligent systems: theories and applications, mohmmedia, morocco, 2012.

S. Anter, A. Zellou and A. Idri, “vers une architecture d’un système d’intégration hybride ”, in 7th international conference on intelligent systems: theories and applications, mohmmedia, morocco, 2012.

S. Anter, A. Zellou and A. Idri, “personalization of a hybrid integration system: Creation of views to materialize based on the distribution of user queries”, IEEE international Conference on Complex Systems (ICCS'12), Agadir, Morocco, 2012.

S. Anter, A. Zellou and A. Idri, “K-Schema: A new approach, based on the distribution of user queries, to create views to materialize in a hybrid integration system”, Journal of Theoretical and Applied Information Technology, Volume 47, Issue 1, Pages 158-170, 2013.

Xinyu Geng, Li Yang, and Xiaoyan Huang, A Distributed Data Access Model based on Multi-task Cooperative Agent, (2012) International Review on Computers and Software (IRECOS), 7 (7), pp. 3770-3775.


  • There are currently no refbacks.

Please send any question about this web site to
Copyright © 2005-2024 Praise Worthy Prize