Skip to main content
SpringerLink
Log in

VIREX and VRXQuery: interactive approach for visual querying of relational databases to produce XML

  • Published:
Journal of Intelligent Information Systems Aims and scope Submit manuscript

Abstract

VIREX provides an interactive approach for querying and integrating relational databases to produce XML documents and the corresponding schemas. VIREX connects to each database specified by the user; analyzes the catalogue to derive an interactive diagram equivalent to the extended entity-relationship diagram; allows the user to display sample records from the tables in the database; allows the user to rename columns and relations by modifying directly the interactive diagram; facilitates the conversion of the relational database into XML; and derives the XML schema. VIREX works even when the catalogue of the relational database is missing; it extracts the required catalogue information by analyzing the database content. Further, VIREX supports VRXQuery, which is a visual naive-users-oriented query language that allows users to specify queries and define views directly on the interactive diagram as a sequence of mouse clicks with minimum keyboard input. The user is expected to interactively decide on certain factors to be considered in producing the XML result. Such factors include: 1) selecting the relations/attributes to be converted into XML; 2) specifying a predicate to be satisfied by the information to be converted into XML; 3) deciding on the order of nesting between the relations to be converted into XML; 4) ordering for the result. VRXQuery supports selection, projection, nesting/join, union, difference, and order-by. As the result of a query, VIREX displays on the screen the XML schema that satisfies the specified characteristics and generates colored (easy to read) XML document(s). Further, VIREX allows the user to display and review the SQL and XQuery equivalent to each query expressed in VRXQuery.

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

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9
Fig. 10
Fig. 11
Fig. 12
Fig. 13
Fig. 14

Similar content being viewed by others

References

  • Abraham, R. (2003). Foxq—xquery by forms.

  • Alhajj, R. (2003). Extracting the extended entity-relationship model from a legacy relational database. Information Systems, 28(6), 597–618.

    Article  MATH  Google Scholar 

  • Baru, C., Gupta, A., Ludäscher, B., Marciano, R., Papakonstantinou, Y., Velikhov, P., et al. (1999). Xml-based information mediation with mix. In Proceedings of ACM SIGMOD international conference on management of data (pp. 597–599). New York: ACM.

    Google Scholar 

  • Baru, C. K., Ludäscher, B., Papakonstantinou, Y., Velikhov, P., & Vianu, V. (1998). Features and requirements for an xml view definition language: Lessons from xml information mediation. In Proceedings of the query languages workshop (W3C Workshops).

  • Beyer, K., et al. (2005). Extending xquery for analytics. In Proceedings of ACM SIGMOD (pp. 503–514). Baltimore, Maryland.

    Chapter  Google Scholar 

  • Blanken, H. M., Grabs, T., Schek, H.-J., Schenkel, R., & Weikum, G. (2003). Intelligent search on XML data. applications, languages, models, implementations, and benchmarks (pp. 59–75). New York: Springer.

    MATH  Google Scholar 

  • Braga, D., Campi, A., & Ceri, S. (2005). Xqbe (xquery by example): A visual interface to the standard xml query language. ACM Transactions on Database Systems, 30(2), 398–443.

    Article  Google Scholar 

  • Catarci, T., Costabile, M. F., Levialdi, S., & Batini, C. (1997). Visual query systems for databases: A survey. Journal of Visual Languages and Computing, 8(2), 215–260.

    Article  Google Scholar 

  • Chiticariu, L., Hernandez, M., Kolaitis, P. G., & Popa, L. (2007). Semiautomatic schema integration in clio. In Proceedings of VLDB (demo paper).

  • Comai, S., Damiani, E., & Fraternali, P. (2001). Computing graphical queries over xml data. ACM Transactions on Information Systems, 19(4), 371–430.

    Article  Google Scholar 

  • Doan, D. K., Paton, N. W., & Kilgour, A. (1995). Design and user testing of a multi-paradigm query interface to an object-oriented database. SIGMOD Records, 24(3), 12–17.

    Article  Google Scholar 

  • Duta, A., Alhajj, R., & Barker, K. (2004). Converting relationships to xml nested structures. Journal of Information and Organizational Sciences, 28(1–2).

  • Elmasri, R. A., & Navathe, S. B. (1998). Fundamentals of database systems. Boston: Addison-Wesley Longman.

    Google Scholar 

  • Fuhr, N., & Grosjohann, K. (2001). XIRQL: A query language for information retrieval in XML documents. In Research and development in information retrieval (pp. 172–180).

  • Haas, L. M., Hernandez, M., Ho, H., Popa, L., & Roth, M. (2005). Clio grows up: From research prototype to industrial tool. In Proceedings of ACM SIGMOD (demo paper).

  • Hernandez, M. A., Miller, R. J., Haas, L. M., Yan, L., Ho, C. T. H., & Tian, X. (2001). Clio: A semi-automatic tool for schema mapping. In SIGMOD record.

  • Kirkpatrick, S., Gelatt, C. D., & Vecchi, M. P. (1983). Optimization by simulated annealing. Science, 220(4598), 671–680.

    Article  MathSciNet  Google Scholar 

  • Lee, D., Mani, M., Chiu, F., & Chu, W. W. (2002). Net & cot: translating relational schemas to xml schemas using semantic constraints. In Proceedings of ACM international conference on information and knowledge management (pp. 282–291). New York: ACM.

    Google Scholar 

  • Ling, T., Lee, M., & Dobbie, G. (2001). Applications of ora-ss: An object-relationship-attribute data model for semistructured data. In Proceedings of the international conference on information integration and web-based applications and services.

  • Hua Liu, Z., Krishnaprasad, M., & Arora, V. (2005). Native xquery processing in oracle xmldb. In Proceedings of ACM SIGMOD (pp. 828–833). New York: ACM.

    Chapter  Google Scholar 

  • Lo, A., Alhajj, R., & Barker, K. (2004). Flexible user interface for converting relational data into xml. In Proceedings of flexible query answering systems (pp. 418–431).

  • Lo, A., Alhajj, R., & Barker, K. (2006). Virex: Visual relational to xml conversion tool. Journal of Visual Languages and Computing, 17(1), 25–45.

    Article  Google Scholar 

  • McHugh, J., Abiteboul, S., Goldman, R., Quass, D., & Widom, J. (1997). Lore: A database management system for semistructured data. SIGMOD Records, 26(3), 54–66.

    Article  Google Scholar 

  • Miller, R. J., Haas, L. M., & Hernández, M. A. (2000). Schema mapping as query discovery. In Proceedings of the international conference on very large data bases (pp. 77–88). San Francisco: Morgan Kaufmann.

    Google Scholar 

  • Mohan, L., & Kashyap, R. L. (1993). A visual query language for graphical interaction with schema-intensive databases. IEEE Transactions on Knowledge and Data Engineering, 5(5), 843–858.

    Article  Google Scholar 

  • Munroe, K., Ludascher, B., & Papakonstantinou, Y. (2000). Blended browsing and querying of xml in a lazy mediator system. In Proceedings of the international conference on extending database technology.

  • Munroe, K. D., & Papakonstantinou, Y. (2000). BBQ: A visual interface for integrated browsing and querying of XML. In Proceedings of visual database systems.

  • Ni, W., & Ling, T. W. (2003). Glass: A graphical query language for semi-structured data. In Proceedings of the international conference on database systems for advanced applications. Kyoto, Japan.

  • Orsini, R., & Pagotto, M. (2001). Visual sql-x: A graphical tool for producing xml documents from relational databases. In Poster proceedings of the international world wide web conference. Hong Kong.

  • Petropoulos, M., Vassalos, V., & Papakonstantinou, Y. (2001). Xml query forms(xqforms): Declarative specification of xml query interfaces. In Proceedings of the international world wide web conference. Hong Kong.

  • Popa, L., Hernandez, M., Velegrakis, Y., Miller, R., Naumann, F., & Ho, H. (2002). Mapping xml and relational schemas with clio. In Proceedings of IEEE ICDE (demo paper).

  • Raffio, A., Braga, D., Ceri, S., Papotti, P., & Hernández, M. A. (2008). Clip: A visual language for explicit schema mappings. In Proceedings of the international conference on IEEE ICDE. Cancun, Mexico.

  • Shanmugasundaram, J., Shekita, E., Barr, R., Carey, M., Lindsay, B., Pirahesh, H., et al. (2001). Efficiently publishing relational data as XML documents. The VLDB Journal, 10(2–3), 133–154.

    MATH  Google Scholar 

  • Wang, C., Lo, A., Alhajj, R., & Barker, K. (2004). Reverse engineering based approach for transferring legacy relational databases into xml. Journal of Information and Organizational Sciences, 28(1–2).

  • Wang, C., Lo, A., Alhajj, R., & Barker, K. (2005). Novel approach for reengineering relational databases into xml. In Proceedings of the international workshop on XML schema and data management, (in conjunction with ICDE 2005).

  • Zloof, M. M. (1977). Query-by-example: A data base language. IBM Systems Journal, 16(4), 324–343.

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Computer Science, University of Calgary, Calgary, Alberta, Canada

    Anthony Lo, Keivan Kianmehr & Reda Alhajj

  2. Department of Computer Engineering, TOBB Economics and Technology University, Ankara, Turkey

    Tansel Özyer

  3. Department of Computer Science, Global University, Beirut, Lebanon

    Reda Alhajj

Authors
  1. Anthony Lo
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Tansel Özyer
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Keivan Kianmehr
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Reda Alhajj
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Reda Alhajj.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Lo, A., Özyer, T., Kianmehr, K. et al. VIREX and VRXQuery: interactive approach for visual querying of relational databases to produce XML. J Intell Inf Syst 35, 21–49 (2010). https://doi.org/10.1007/s10844-009-0087-6

Download citation

  • Received:

  • Revised:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s10844-009-0087-6

Keywords

Search

Navigation