EDBT '94 Proceedings of the 4th international conference on extending database technology: Advances in database technology
On-line warehouse view maintenance
SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Incremental materialization of object-oriented views
Data & Knowledge Engineering
Clio: a semi-automatic tool for schema mapping
SIGMOD '01 Proceedings of the 2001 ACM SIGMOD international conference on Management of data
Storing and querying ordered XML using a relational database system
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
Schema Mapping as Query Discovery
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Deferred Incremental Refresh of XML Materialized Views
CAiSE '02 Proceedings of the 14th International Conference on Advanced Information Systems Engineering
Adaptive XML Shredding: Architecture, Implementation, and Challenges
Proceedings of the VLDB 2002 Workshop EEXTT and CAiSE 2002 Workshop DTWeb on Efficiency and Effectiveness of XML Tools and Techniques and Data Integration over the Web-Revised Papers
ER '02 Proceedings of the 21st International Conference on Conceptual Modeling
XViews: XML Views of Relational Schemas
DEXA '99 Proceedings of the 10th International Workshop on Database & Expert Systems Applications
Deferred incremental refresh of XML materialized views: algorithms and performance evaluation
ADC '03 Proceedings of the 14th Australasian database conference - Volume 17
Mapping XML and Relational Schemas with Clio
ICDE '02 Proceedings of the 18th International Conference on Data Engineering
Views as first-class citizens in object-oriented databases
The VLDB Journal — The International Journal on Very Large Data Bases
Clio grows up: from research prototype to industrial tool
Proceedings of the 2005 ACM SIGMOD international conference on Management of data
XQBE (XQuery By Example): A visual interface to the standard XML query language
ACM Transactions on Database Systems (TODS)
Novel Approach for Reengineering Relational Databases into XML
ICDEW '05 Proceedings of the 21st International Conference on Data Engineering Workshops
PATAXÓ: A framework to allow updates through XML views
ACM Transactions on Database Systems (TODS)
Efficient approaches for materialized views selection in a data warehouse
Information Sciences: an International Journal
XFlat: Query-friendly encrypted XML view publishing
Information Sciences: an International Journal
A framework for using materialized XPath views in XML query processing
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Efficient keyword search over virtual XML views
VLDB '07 Proceedings of the 33rd international conference on Very large data bases
Semi-automatic schema integration in Clio
VLDB '07 Proceedings of the 33rd international conference on Very large data bases
Information Sciences: an International Journal
Clip: a Visual Language for Explicit Schema Mappings
ICDE '08 Proceedings of the 2008 IEEE 24th International Conference on Data Engineering
CSF '09 Proceedings of the 2009 22nd IEEE Computer Security Foundations Symposium
Schema-based independence analysis for XML updates
Proceedings of the VLDB Endowment
An efficient method for maintaining data cubes incrementally
Information Sciences: an International Journal
A Z Approach in Validating ORA-SS Data Models
Electronic Notes in Theoretical Computer Science (ENTCS)
VIREX: visual relational to XML conversion tool
Journal of Visual Languages and Computing
Regular tree patterns: a uniform formalism for update queries and functional dependencies in XML
Proceedings of the 2010 EDBT/ICDT Workshops
The view update problem for XML
Proceedings of the 2010 EDBT/ICDT Workshops
EXup: an engine for the evolution of XML schemas and associated documents
Proceedings of the 2010 EDBT/ICDT Workshops
Desirable properties for XML update mechanisms
Proceedings of the 2010 EDBT/ICDT Workshops
Fundamentals of Database Systems
Fundamentals of Database Systems
TempoXML: Nested bitemporal relationship modeling and conversion tool for fuzzy XML
Information Sciences: an International Journal
Minimizing user effort in XML grammar matching
Information Sciences: an International Journal
Efficient labeling scheme for dynamic XML trees
Information Sciences: an International Journal
Leveraging spatial join for robust tuple extraction from web pages
Information Sciences: an International Journal
Hi-index | 0.07 |
Web-based databases are gaining increased popularity. This has positively influenced the availability of structured and semi-structured databases for access by a variety of users ranging from professionals to naive users. The number of users accessing online databases will continue to increase if the visual tools connected to web-based databases are flexible and user-friendly enough to meet the expectations of naive users and professionals. Further, XML is accepted as the standard for platform independent data exchange. This motivated for the development of the conversion tools between structured databases and XML. Realizing that such a need has not been well handled by the available tools, including Clio from IBM, we developed VIREX as a visual tool for converting relational databases into XML, and since then has been empowered with further capabilities to manipulate the produced XML schema including the maintenance of materialized views and schema evolution functions. VIREX provides an interactive approach for querying and integrating relational databases to produce XML documents and the corresponding XML schema(s). VIREX supports VRXQuery as 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. As the query result, VIREX displays on the screen the XML schema that satisfies the specified characteristics and generates colored (easy to read) XML document(s). The main contribution described in this paper is the novel approach for turning query results into materialized views which are maintained to remain consistent with the underlying database. VIREX supports deferred update of XML views by keeping an ordered summary of the necessary and sufficient information required for the process. Each view has a corresponding marker in the ordered summary to indicate the start of the information to be reflected onto the view when it is accessed. When a view is accessed, its marker moves to the head of the list to mark for the next update. In addition, VIREX supports some basic schema evolution functions include renaming, adding and dropping of elements and attributes, among others. The supported schema evolution functions add flexibility to the view maintenance and materialization process.