24 Hits in 10.1 sec

DB2 goes hybrid: Integrating native XML and XQuery with relational data and SQL

K. Beyer, R. Cochrane, M. Hvizdos, V. Josifovski, J. Kleewein, G. Lapis, G. Lohman, R. Lyle, M. Nicola, F. Ozcan, H. Pirahesh, N. Seemann (+6 others)
2006 IBM Systems Journal  
This paper presents the overall architecture and design aspects of native XML support in DB2 UDB and its integration with the relational data-flow engine.  ...  This makes DB2t a truly hybrid database management system with first-class support for both XML and relational data processing as well as the integration of the two.  ...  Watson Research Center for their contributions to integrating native XML support into DB2.  ... 
doi:10.1147/sj.452.0271 fatcat:wppk2sdeq5d2rhbwfwc6lf4niu

Technical context and cultural consequences of XML

S. Adler, R. Cochrane, J. F. Morar, A. Spector
2006 IBM Systems Journal  
In ''DB2 goes hybrid: Integrating native XML and XQuery with relational data and SQL,'' Beyer et al. describe an architecture for fully integrating native XML support in an industrial-strength database  ...  ''Integration of SQL and XQuery in DB2 XML'' by Ö zcan et al. is a recommended starting point, as its focus is primarily on the externals for defining and querying XML data in DB2.  ... 
doi:10.1147/sj.452.0207 fatcat:vxq4hgtcmbeufovuntrn2rluym

MeMo: a hybrid SQL/XML approach to metabolomic data management for functional genomics

Irena Spasić, Warwick B Dunn, Giles Velarde, Andy Tseng, Helen Jenkins, Nigel Hardy, Stephen G Oliver, Douglas B Kell
2006 BMC Bioinformatics  
MeMo is a formal model for representing metabolomic data and the associated metadata. Two predominant platforms (SQL and XML) are used to encode the model.  ...  Special consideration is given to data integration issues as part of the systems biology agenda. MeMo has been physically integrated and cross-linked to related metabolomic and genomic databases.  ...  We are grateful for very useful and stimulating discussions with our colleagues: Juan Castrillo (user requirements), Chris and Kevin Garwood (data entry issues), David Hancock (interface issues), Andy  ... 
doi:10.1186/1471-2105-7-281 pmid:16753052 pmcid:PMC1522028 fatcat:ebvoob2pjbbttp24othvumtqum

Implementing filesystems by tree-aware DBMSs

Alexander Holupirek, Marc H. Scholl
2008 Proceedings of the VLDB Endowment  
We implement a filesystem in userspace backed by the MonetDB/XQuery system, a well-known relational database system, which integrates the Pathfinder XQuery compiler [5] and the Mon-etDB kernel [4] .  ...  With the rise of XML, the database community has been challenged by semi-structured data processing.  ...  We like to especially thank Christian Grün for lively discussions, assistance & comments and also the anonymous reviewers for providing valuable feedback.  ... 
doi:10.14778/1454159.1454237 fatcat:gf5fljjmuzfyrkzo64w3yoefqe

Determined: a system with novel techniques for XML query optimization and evaluation

Dunren Che, Wen‐Chi Hou
2008 International Journal of Web Information Systems  
Compared with relational data, XML data has higher complexity because of the extra structural facet of XML data.  ...  Purpose -Efficient processing of XML queries is critical for XML data management and related applications. Previously proposed techniques are unsatisfactory.  ...  This approach renders a tight integration between XQuery and SQL/XML support within an ORDBMS kernel.  ... 
doi:10.1108/17440080810865620 fatcat:6ligmazipzbfrcuzaa3ioz63cm

From XML view updates to relational view updates [chapter]

Vanessa P. Braganholo, Susan B. Davidson, Carlos A. Heuser
2004 Proceedings 2004 VLDB Conference  
Existing work on updating relational views can then be leveraged to determine whether or not the relational views are updatable with respect to the relational updates, and if so, to translate the updates  ...  Using a notion of query trees to capture the notions of selection, projection, nesting, grouping, and heterogeneous sets found throughout most XML query languages, we show how XML views expressed using  ...  An XML view over this database is then provided. These applications highlight several characteristics of real XML views: They are large and complex, typically involving several relational tables.  ... 
doi:10.1016/b978-012088469-8.50027-9 dblp:conf/vldb/BraganholoDH04 fatcat:nuh2x35abncr7kdzwvoselhc5a

A Practitioner's Guide to Data Management and Data Integration in Bioinformatics [chapter]

Barbara A. Eckman
2003 Bioinformatics  
the schema management section; and Bill Swope for help on data warehousing.  ...  Finally, I thank the editors and reviewers for their patience and helpful suggestions.  ...  The transformations generated would be specified in the XML query language (XQuery) or Extensible Stylesheet Language Transformations (XSLT) for XML data, and SQL for relational data.  ... 
doi:10.1016/b978-155860829-0/50005-x fatcat:isuajgde6bhohiwt2a43zphv2q

Technologies for integrating biological data

L. Wong
2002 Briefings in Bioinformatics  
We also survey alternative representative technologies and approaches to data integration in biomedicine.  ...  The process of building a new database relevant to some field of study in biomedicine involves transforming, integrating, and cleansing multiple data sources, as well as adding new material and annotations  ...  XML and Kleisli have all the qualities required for a good general data integration.  ... 
doi:10.1093/bib/3.4.389 pmid:12511067 fatcat:dwjbtbyytvc53oxhe5qn5rqolq

Storing and querying XML data using denormalized relational databases

Andrey Balmin, Yannis Papakonstantinou
2005 The VLDB journal  
(ii) How should the XML query be translated into an efficient plan that sends one or more SQL queries to the underlying RDBMS and combines the data into the XML result?  ...  We provide corresponding query processing algorithms that translate the XML query conditions into conditions on the relational tables and assemble the decomposed data into the XML query result.  ...  Oracle 8i/9i, IBM DB2, and Microsoft SQL Server provide some basic XML support [BKKM00, Rys01, JMC00] . None of these products support XQuery or any other full-featured XML query language.  ... 
doi:10.1007/s00778-003-0113-1 fatcat:xty262ydpva2dp2vutykp5a56i

Page 214 of IBM Systems Journal Vol. 45, Issue 2 [page]

IBM Systems Journal  
The paper concludes with a discussion of the syntactic and semantic challenges of integrating SQL and XQuery. n “DB2 goes hybrid: Integrating native XML and XQuery with relational data and SQL,” Beyer  ...  “Integration of SQL and XQuery in DB2 XML” by Ozcan et al. is a recommended starting point, as its focus is primarily on the externals for defining and querying XML data in DB2.  ... 


Limsoon Wong
2004 The Practical Bioinformatician  
Secondly, not only are the SQL queries more powerful and expressive than those of SRS, the SQL queries are also automatically optimized by DB2.  ...  Research and development works are also in progress on XML query optimization ¾ and on XML data stores. ¾ ¾ A robust and stable XML-based general data integrating and warehousing system does not yet exist  ... 
doi:10.1142/9789812562340_0017 fatcat:24zwwoahhfffzd2dbyovjzzeqi

Relational universal index structure for evaluating XML twig queries

Samir Mohammad, Patrick Martin, Wendy Powley
2011 2011 International Conference on Communications and Information Technology (ICCIT)  
We use a light-weight native XML engine on top of an SQL engine to perform the optimization related to the structure of the XML data prior to shredding.  ...  Based on our findings, we propose two novel XML index structures to overcome most of these limitations: a native index structure called Level-based Tree Index for XML databases (LTIX) and a relational  ...  We use a light-weight native XML engine on top of an SQL engine to perform the optimization related to the structure of the XML data prior to shredding.  ... 
doi:10.1109/iccitechnol.2011.5762659 fatcat:t44shh63rbdybeudfkjkbbwwd4

Architecture of a Database System

Joseph M. Hellerstein, Michael Stonebraker, James Hamilton
2007 Foundations and Trends in Databases  
or a middleware server), to respond to SQL commands from the caller, and to return both data and control messages (result codes, errors, etc.) as appropriate.  ...  Relational Systems: The Life of a Query 145 is established between the client and the database server directly, e.g., via the ODBC or JDBC connectivity protocol.  ...  Muralidhar, Pat Selinger, Mehul Shah, and Matt Welsh for background information and comments on early drafts of this paper.  ... 
doi:10.1561/1900000002 fatcat:ve6wkgbgrngppk3cjcbfsevuye

The Family of MapReduce and Large Scale Data Processing Systems [article]

Sherif Sakr, Anna Liu, Ayman G. Fayoumi
2013 arXiv   pre-print
In the last two decades, the continuous increase of computational power has produced an overwhelming flow of data which has called for a paradigm shift in the computing architecture and large scale data  ...  It isolates the application from the details of running a distributed program such as issues on data distribution, scheduling and fault tolerance.  ...  DryadLINQ 23 exploits LINQ (Language INtegrated Query 24 , a set of .NET constructs for programming with datasets) to provide a powerful hybrid of declarative and imperative programming.  ... 
arXiv:1302.2966v1 fatcat:ttpqmigyurhepfa2wi2slicelm

Program book

2010 2010 IEEE 26th International Conference on Data Engineering Workshops (ICDEW 2010)  
execution order of XPath steps and relational joins in an XQuery.  ...  updates expressed in the XQuery update facility to embedded SQL updates.  ...  Streaming Data Integration: Challenges and Opportunities The amount of attention the research community has devoted to social networks has so far not kept up with their growth in popularity and overall  ... 
doi:10.1109/icdew.2010.5452773 fatcat:oyq2tujbvjfpxjlyixux5q57vu
« Previous Showing results 1 — 15 out of 24 results