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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Author information
Authors and Affiliations
Corresponding author
Rights 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
Received:
Revised:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s10844-009-0087-6