49,716 Hits in 5.1 sec

Querying XML Views of Relational Data

Jayavel Shanmugasundaram, Jerry Kiernan, Eugene J. Shekita, Catalina Fan, John E. Funderburk
2001 Very Large Data Bases Conference  
In this paper, we address the problem of evaluating XML queries over XML views of relational data. This paper makes two main contributions.  ...  A general way to publish relational data as XML is to provide XML views over relational data, and allow business partners to query these views using an XML query language.  ...  We would also like to acknowledge the contributions of past members of the XPERANTO project, including Rimon Barr, Mike Carey, Dana Florescu, Zack Ives, Ying Lu, and Subbu Subramanian.  ... 
dblp:conf/vldb/ShanmugasundaramKSFF01 fatcat:5x2kewlfl5b2jp2rmgmksn54gi

XTABLES: Bridging relational technology and XML

J. E. Funderburk, G. Kiernan, J. Shanmugasundaram, E. Shekita, C. Wei
2002 IBM Systems Journal  
and XML views of relational data.  ...  In particular, XTABLES provides a general framework to create XML views of relational data, query XML views, and store and query XML documents using a relational database system.  ...  Acknowledgments The authors would like to thank Rajasekar Krishnamurthy, Jeffrey Naughton, Efstratios Viglas, and Igor Tatarinov for their valuable contributions to the design and implementation of XTABLES  ... 
doi:10.1147/sj.414.0616 fatcat:yeafcyv6u5futeoecgbkae7ysm

XPERANTO: Middleware for Publishing Object-Relational Data as XML Documents

Michael J. Carey, Jerry Kiernan, Jayavel Shanmugasundaram, Eugene J. Shekita, Subbu N. Subramanian
2000 Very Large Data Bases Conference  
As a result, data sources, including object-relational databases, are now faced with a new class of users and applications; customers and programs that would like to deal directly with XML data rather  ...  XPERANTO does this by providing query-able "XML Views" over the underlying objectrelational database.  ...  Finally, XPERANTO enables the seamless querying of relational data (such as column values) and meta-data (such as column names).  ... 
dblp:conf/vldb/CareyKSSS00 fatcat:3tbznpuf2zdc5ogrzumgjn7o4u

Improving Query Performance Using Materialized XML Views: A Learning-Based Approach [chapter]

Ashish Shah, Rada Chirkova
2003 Lecture Notes in Computer Science  
The main contribution of this paper is to show that selective materialization of data as XML views reduces query-execution costs in relatively static databases.  ...  We consider the problem of improving the efficiency of query processing on an XML interface of a relational database, for predefined query workloads.  ...  Conclusions and Future Work We have described a view-and learning-based solution to the problem of reducing total query-execution times in relational data sources with XML interfaces.  ... 
doi:10.1007/978-3-540-39597-3_30 fatcat:vy364fmuanhstnsxffqnrmfu64

Xml Data Mediation and Collaboration: A Proposed Comprehensive Architecture and Query Requirements for Using Xml to Mediate Heterogeneous Data Sources and Targets

Paul Benjamin Lowry
2005 Social Science Research Network  
This paper discusses the potential of using XML technologies as mediators for accessing and processing structured, relational data and semi-structured data over the Internet.  ...  uses one standard query language for all XML data queries; thus, optimizes and simplifying query writing; can be implemented in phases; consistent query language regardless of data source; returns all  ...  A view of semi-structured, heterogeneous web data follows the same concept of relational views except that the underlying data is not relational; instead, it is comprised of integrated heterogeneous data  ... 
doi:10.2139/ssrn.666172 fatcat:sl63whmxrbgdxgyzw3n4hohrpa

A general technique for querying XML documents using a relational database system

Jayavel Shanmugasundaram, Eugene Shekita, Jerry Kiernan, Rajasekar Krishnamurthy, Efstratios Viglas, Jeffrey Naughton, Igor Tatarinov
2001 SIGMOD record  
In addition, our proposed technique enables users to query seamlessly across relational data and XML documents.  ...  Since relational schema generation is a physical database design issue -dependent on factors such as the nature of the data, the query workload and availability of schemas -there have been many techniques  ...  Further, this queryprocessor can process queries over XML documents and XML views of existing relational data, because they are all just XML views of relational data.  ... 
doi:10.1145/603867.603871 fatcat:tz3tibu2lzaknamunilv63qpfm

XML-to-SQL Query Translation Literature: The State of the Art and Open Problems [chapter]

Rajasekar Krishnamurthy, Raghav Kaushik, Jeffrey F. Naughton
2003 Lecture Notes in Computer Science  
In particular, for the XML publishing of relational data and for "schema-based" shredding of XML documents into relations, there is no published algorithm for translating even simple path expression queries  ...  Recently, the database research literature has seen an explosion of publications with the goal of using an RDBMS to store and/or query XML data.  ...  In other words, an XML view of the relational data set is defined and XML queries are posed over this view. 2.  ... 
doi:10.1007/978-3-540-39429-7_1 fatcat:4tyqj4mp3neohe4hxr4cnuwj7q

Recommending XMLTable Views for XQuery Workloads [chapter]

Iman Elghandour, Ashraf Aboulnaga, Daniel C. Zilio, Calisto Zuzarte
2009 Lecture Notes in Computer Science  
We have implemented our XMLTable View Advisor in a prototype version based on IBM R DB2 R V9.7, which supports both relational and XML data, and we experimentally demonstrate the effectiveness of our advisor's  ...  We then focus on XMLTable materialized views and present a procedure to recommend them given an XML database and a workload of XQuery queries.  ...  In MARS [9] , the data is originally stored in relational and XML format, in addition to partial views of the data that are of relational and XML types.  ... 
doi:10.1007/978-3-642-03555-5_11 fatcat:ignxlcylbbdinhsaa4gsj3ehqa

Updating XQuery Views Published over Relational Data: A Round-Trip Case Study [chapter]

Ling Wang, Mukesh Mulchandani, Elke A. Rundensteiner
2003 Lecture Notes in Computer Science  
Managing XML data using relational database systems, including query processing over virtual XML views that wrap relational sources, has been heavily studied in the last few years.  ...  XML view update is a challenging problem because of having to address the mismatch between the two rather different data models and distinct query paradigms.  ...  Examples of such XML management systems include EXPERANTO [6] , SilkRoute [10] and Rainbow [22] , which typically offer support for XML view creation over relational data and for querying against such  ... 
doi:10.1007/978-3-540-39429-7_15 fatcat:wts7oskrx5hjbkypkzyuoztrui

Current approaches to XML management

U. Nambiar, Z. Lacroix, S. Bressan, Mong Li Lee, Yingguang Li
2002 IEEE Internet Computing  
XML management systems vary widely in their expressive power and query-processing efficiency, and users should choose the XMLMS that best meets their needs.  ...  SQLXML (, which is bundled with SQL Server 2000, lets developers map XML files into relational tables, create XML views of existing relational data, query relational data with XPath, and  ...  This polarized view of XML generates issues regarding the functionality or expressive power of existing XML query languages.  ... 
doi:10.1109/mic.2002.1020325 fatcat:qkkntfeso5bkxa45ru6emhaasq

Unraveling the duplicate-elimination problem in XML-to-SQL query translation

Rajasekar Krishnamurthy, Raghav Kaushik, Jeffrey F Naughton
2004 Proceedings of the 7th International Workshop on the Web and Databases colocated with ACM SIGMOD/PODS 2004 - WebDB '04  
We consider the scenario where existing relational data is exported as XML. In this context, we look at the problem of translating XML queries into SQL.  ...  XML query languages have two different notions of duplicates: node-identity based and value-based. Path expression queries have an implicit node-identity based duplicate elimination built into them.  ...  What happens in this case is that some parts of the relational data may appear in the XML view multiple times. For example, part of an instance of the relational data is shown in Figure 3 .  ... 
doi:10.1145/1017074.1017088 dblp:conf/webdb/KrishnamurthyKN04 fatcat:5mjehdom35bita3ftbowyjlpru

Models XP for Rewriting XPath Queries

Nicoleta Liviana TUDOR
2011 Studies in Informatics and Control  
Composition of queries using a semantic cache of XP views, assumes the existence of a query which, by composition with a view from cache, will return the result of query.  ...  After declaration of issue of the correspondence between the tree models used for classes of XPath queries stored in cache and the set of trees associated to a XML document, it follows the solutions for  ...  Relational systems convert XML data into a relational format which may be effectively memorized and queried as a set of relations.  ... 
doi:10.24846/v20i2y201104 fatcat:7otipfla2vgydgnsv4sfoio7sm

Query Optimization against XML Data

Liviana TUDOR
2016 Studies in Informatics and Control  
Web services allow middleware access to a relational database and require data representation in XML format. The XML views obtained from relational databases can be accessed by using XPath queries.  ...  For each view selected from cache, a compensation query can be found and composed with in order to solve an XML data query.  ...  The XML views obtained from the relational data use XDR (XML Data Reduced) schemes and can be accessed using XPath queries.  ... 
doi:10.24846/v25i2y201604 fatcat:k5aarwromzgybc6w7ocpzv7if4

XML Views [chapter]

Murali Mani
2016 Encyclopedia of Database Systems  
DEFINITION Database applications provide an XML view of their data so that the data is available to other applications, especially web applications.  ...  Views provide data independence as well as the ability to control access of portions of data to different classes of users.  ...  User Queries over XML Views The systems that support XML views need to provide the capability for users to query the data.  ... 
doi:10.1007/978-1-4899-7993-3_781-2 fatcat:23de4cnl3zhilnv452ojmowttm

Query Rewrite for XML in Oracle XML DB [chapter]

Muralidhar Krishnaprasad, Zhen Hua Liu, Anand Manikutty, James W. Warner, Vikas Arora, Susan Kotsovolos
2004 Proceedings 2004 VLDB Conference  
This enables a large class of XML queries over XML type tables and views to be transformed into their semantically equivalent relational or object relational queries.  ...  A common set of algebraic rules is used to reduce both XML and object queries into their relational equivalent.  ...  Acknowledements We gratefully acknowledge the contributions of all the members of the Oracle XML DB development and product management teams.  ... 
doi:10.1016/b978-012088469-8.50098-x dblp:conf/vldb/KrishnaprasadLMWAK04 fatcat:icxkgdbd35fcfglxrddah4f6ii
« Previous Showing results 1 — 15 out of 49,716 results