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

Content Provider	Springer Nature Link
Author	Lo, Anthony Özyer, Tansel Kianmehr, Keivan Alhajj, Reda
Copyright Year	2009
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.
Starting Page	21
Ending Page	49
Page Count	29
File Format	PDF
ISSN	09259902
Journal	Journal of Intelligent Information Systems
Volume Number	35
Issue Number	1
e-ISSN	15737675
Language	English
Publisher	Springer US
Publisher Date	2009-04-17
Publisher Place	Boston
Access Restriction	One Nation One Subscription (ONOS)
Subject Keyword	Data conversion Graphical user interface Relational database Visual query language XML Business Information Systems Document Preparation and Text Processing Artificial Intelligence (incl. Robotics) Data Structures, Cryptology and Information Theory
Content Type	Text
Resource Type	Article
Subject	Artificial Intelligence Computer Networks and Communications Information Systems Software Hardware and Architecture

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in

Querying now-relative data

Querying a summary of database

A coherent query language for XML

Semantic-distance based evaluation of ranking queries over relational databases

Storing and querying fuzzy XML data in relational databases

A Data Model for XML Databases

Fuzzy semantic tagging and flexible querying of XML documents extracted from the Web

Unary and n-ary inclusion dependency discovery in relational databases

Multidimensional Index Structures in Relational Databases

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

Similar Documents

Querying now-relative data

Querying a summary of database

A coherent query language for XML

Semantic-distance based evaluation of ranking queries over relational databases

Storing and querying fuzzy XML data in relational databases

A Data Model for XML Databases

Fuzzy semantic tagging and flexible querying of XML documents extracted from the Web

Unary and n-ary inclusion dependency discovery in relational databases

Multidimensional Index Structures in Relational Databases

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