Integrating Databases, Search Engines and Web Applications: A Model-Driven Approach

  • Alessandro Bozzon
  • Tereza Iofciu
  • Wolfgang Nejdl
  • Sascha Tönnies
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4607)


This paper addresses conceptual modeling and automatic code generation for search engine integration with data intensive Web applications. We have analyzed the similarities (and differences) between IR and database systems to extend an existing domain specific language for data-driven Web applications. The extended Web modeling language specifies the search engine’s index schemas based on the data schema of the Web application and uniquely designs the interaction between the database, the Web application, the search engine and users. We also provide an implementation of a CASE tool extension for visual modeling and code generation. Experimentation of the proposed approach has been successfully applied in the context of the COOPER project.


Web Engineering Web Site Design Search Engine Design Index Modeling 


  1. 1.
    Raghavan, S., Garcia-molina, H.: Integrating diverse information management systems: A brief survey. IEEE Data Engineering Bulletin (2001)Google Scholar
  2. 2.
    Gu, A., Henderson-Sellers, B., Lowe, D.: Web modelling languages: the gap between requirements and current exemplars. In: AUSWEB (2002)Google Scholar
  3. 3.
    Bongio, A., van Bruggen, J., Ceri, S., Matera, M., Taddeo, A., Zhou, X., et al.: COPPER: Towards A Collaborative Open Environment of Project-centred Learning. In: Nejdl, W., Tochtermann, K. (eds.) EC-TEL 2006. LNCS, vol. 4227, pp. 1–4. Springer, Heidelberg (2006)CrossRefGoogle Scholar
  4. 4.
    Baeza-Yates, R., Ribeiro-Neto, B.: Modern Information Retrieval. Addison-Wesley, London, UK (1999)Google Scholar
  5. 5.
    Navarro, G., Baeza-Yates, R.: Proximal nodes: A model to query document databases by content and structure. ACM TOIS 15, 401–435 (1997)CrossRefGoogle Scholar
  6. 6.
    Carmel, D., Maarek, Y., Mandelbrod, M., Mass, Y., Soffer, A.: Searching xml documents via xml fragments. In: SIGIR (2003)Google Scholar
  7. 7.
    Oren, E., Delbru, R., Decker, S.: Extending faceted navigation for rdf data. In: ISWC (2006)Google Scholar
  8. 8.
    Ceri, S., Fraternali, P., Brambilla, M., Bongio, A., Comai, S., Matera, M.: Designing Data-Intensive Web Applications. Morgan Kaufmann, Seattle, Washington (2002)Google Scholar
  9. 9.
  10. 10.
  11. 11.
    Crawford, R.: The relational model in information retrieval. JASIST, pp. 51–64 (1981)Google Scholar
  12. 12.
    Vasanthakumar, S.R., Callan, J.P., Bruce Croft, W.: Integrating inquery with an rdbms to support text retrieval. Data Engineering Bulletin (1996)Google Scholar
  13. 13.
    Ozkarahan, E.: Multimedia document retrieval. Information Processing and Management 31(1), 113–131 (1995)CrossRefGoogle Scholar
  14. 14.
    Oracle: Oracle technical white paper (May 2001)Google Scholar
  15. 15.
    Hristidis, V., Papakonstantinou, Y.: DISCOVER: Keyword search in relational databases. In: Procs. VLDB, August 2002 (2002)Google Scholar
  16. 16.
    Weigel, F., Meuss, H., Bry, F., Schulz, K.U.: Content-Aware DataGuides: Interleaving IR and DB Indexing Techniques for Efficient Retrieval of Textual XML Data. In: McDonald, S., Tait, J. (eds.) ECIR 2004. LNCS, vol. 2997, pp. 378–393. Springer, Heidelberg (2004)Google Scholar
  17. 17.
    Grabs, T., Bm, K., Schek, H.J.: PowerDB-IR: information retrieval on top of a database cluster. In: IKE’01. Atlanta, Georgia (2001)Google Scholar
  18. 18.
    Iofciu, T., Kohlschtter, C., Nejdl, W., Paiu, R.: Keywords and rdf fragments: Integrating metadata and full-text search in beagle++. In: Gil, Y., Motta, E., Benjamins, V.R., Musen, M.A. (eds.) ISWC 2005. LNCS, vol. 3729, Springer, Heidelberg (2005)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2007

Authors and Affiliations

  • Alessandro Bozzon
    • 1
  • Tereza Iofciu
    • 2
  • Wolfgang Nejdl
    • 2
  • Sascha Tönnies
    • 2
  1. 1.Politecnico di Milano , P.zza L. da Vinci 32, I-20133 MilanoItaly
  2. 2.Forschungszentrum L3S, Appelstr. 9a, 30167 HannoverGermany

Personalised recommendations