Filters








109 Hits in 2.9 sec

An xml index advisor for DB2

Iman Elghandour, Ashraf Aboulnaga, Daniel C. Zilio, Fei Chiang, Andrey Balmin, Kevin Beyer, Calisto Zuzarte
2008 Proceedings of the 2008 ACM SIGMOD international conference on Management of data - SIGMOD '08  
We have implemented our XML Index Advisor for DB2.  ...  We have developed an XML Index Advisor that solves this XML index recommendation problem and is tightly coupled with the query optimizer of the database system.  ...  In this demonstration, we present an XML Index Advisor for DB2 that automatically recommends the best set of XML indexes and index patterns for a given database and query workload, while taking into account  ... 
doi:10.1145/1376616.1376752 dblp:conf/sigmod/ElghandourAZCBBZ08 fatcat:ycp66wu3q5hivobm77lxmyd6y4

XML Index Recommendation with Tight Optimizer Coupling

Iman Elghandour, Ashraf Aboulnaga, Daniel C. Zilio, Fei Chiang, Andrey Balmin, Kevin Beyer, Calisto Zuzarte
2008 2008 IEEE 24th International Conference on Data Engineering  
We have implemented our XML Index Advisor in a prototype version of IBM R DB2 R 9, which supports both relational and XML data, and we experimentally demonstrate the effectiveness of our advisor using  ...  In this paper, we present an XML Index Advisor that solves this XML index recommendation problem and has the key characteristic of being tightly coupled with the query optimizer.  ...  For example, our XML Index Advisor implementation in DB2 supports both XQuery and SQL/XML simply by virtue of the fact that the DB2 query optimizer supports both of these languages.  ... 
doi:10.1109/icde.2008.4497492 dblp:conf/icde/ElghandourAZCBBZ08 fatcat:k3douf77mfchdj5idnlhcim64a

Recommending XMLTable Views for XQuery Workloads [chapter]

Iman Elghandour, Ashraf Aboulnaga, Daniel C. Zilio, Calisto Zuzarte
2009 Lecture Notes in Computer Science  
In this paper, we discuss the types of materialized views that are suitable for an XML database.  ...  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  ...  Unfortunately, none of these works extend directly to XML databases. The XML Index Advisor proposed in [10] recommends XML indexes for an XML database given a workload of XML queries.  ... 
doi:10.1007/978-3-642-03555-5_11 fatcat:ignxlcylbbdinhsaa4gsj3ehqa

Recommending XML physical designs for XML databases

Iman Elghandour, Ashraf Aboulnaga, Daniel C. Zilio, Calisto Zuzarte
2012 The VLDB journal  
We present a design advisor for recommending XML indexes, one for recommending materialized views, and an integrated design advisor that recommends both indexes and materialized views.  ...  We focus on recommending two types of physical structures: XML indexes and relational materialized views of XML data.  ...  This work was supported by the IBM Center for Advanced Studies.  ... 
doi:10.1007/s00778-012-0298-2 fatcat:xzb42hqyfvallauh5fdwlfu2n4

Cost-based optimization in DB2 XML

A. Balmin, T. Eliaz, J. Hornibrook, L. Lim, G. M. Lohman, D. Simmen, M. Wang, C. Zhang
2006 IBM Systems Journal  
DB2 XML augments DB2t UDB with a native XML store, XML indexes, and query processing capabilities for both XQuery and SQL/XML that are integrated with those of SQL.  ...  DB2 XML is a hybrid database system that combines the relational capabilities of DB2 Universal Databasee (UDB) with comprehensive native XML support.  ...  ACKNOWLEDGMENT We would like to thank the entire DB2 XML team for their support of this work.  ... 
doi:10.1147/sj.452.0299 fatcat:ac232lw4z5bnjibsqfjua55xv4

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  
We describe the new XML components in DB2 UDB and show how XML processing leverages much of the infrastructure which is used for relational data. Ó  ...  Comprehensive and efficient support for XML data management is a rapidly increasing requirement for database systems.  ...  Watson Research Center for their contributions to integrating native XML support into DB2.  ... 
doi:10.1147/sj.452.0271 fatcat:wppk2sdeq5d2rhbwfwc6lf4niu

XQuery Join Graph Isolation [article]

T. Grust, M. Mayr, J. Rittinger
2008 arXiv   pre-print
A purely relational account of the true XQuery semantics can turn any relational database system into an XQuery processor.  ...  of "reinventing" advanced processing strategies that have originally been devised specifically for the XQuery domain, e.g., XPath step reordering, axis reversal, and path stitching.  ...  For Q 2 as an representative of the prototypical expected query workload, the DB2 design advisor suggests the B-tree index set of Table VI .  ... 
arXiv:0810.4809v1 fatcat:cjtubdhuhrdthgi2twh6cayz2u

Pathfinder meets DB2®

Manuel Mayr
2008 Proceedings of the 2008 EDBT Ph.D. workshop on - Ph.D. '08  
Our approach neither depends on modifications of the database kernel, nor do we rely on built-in XML-specific functionality (SQL/XML, for instance).  ...  columns and materialized query tables to precompute aspects of XPath step evaluation, (3) how the system's index design wizard can automatically advise on the creation of indexes that, for example, enable  ...  I would like to thank my Ph.D. advisor Torsten Grust and Jan Rittinger for their insightful feedback.  ... 
doi:10.1145/1387150.1387160 fatcat:gemixmeuofecpgqan4r64loimy

Why off-the-shelf RDBMSs are better at XPath than you might expect

Torsten Grust, Jan Rittinger, Jens Teubner
2007 Proceedings of the 2007 ACM SIGMOD international conference on Management of data - SIGMOD '07  
However, the addition of these algorithms to existing systems depends on a significant invasion of the underlying database kernel, an option intolerable for most database vendors.  ...  To compensate for the inherent impedance mismatch between the relational data model (tables of tuples) and XML (ordered, unranked trees), tree join algorithms have become the prevalent means to process  ...  In fact, we found the DB2 index advisor db2advis to seize this chance and suggest appropriate indexes for workloads that made use of XPath name and/or kind tests.  ... 
doi:10.1145/1247480.1247591 dblp:conf/sigmod/GrustRT07 fatcat:ljkbsvbtxjeunpucyz7cmaxklq

Let SQL drive the XQuery workhorse (XQuery join graph isolation)

Torsten Grust, Manuel Mayr, Jan Rittinger
2010 Proceedings of the 13th International Conference on Extending Database Technology - EDBT '10  
A purely relational account of the true XQuery semantics can turn any relational database system into an XQuery processor.  ...  of "reinventing" advanced processing strategies that have originally been devised specifically for the XQuery domain, e.g., XPath step reordering, axis reversal, and path stitching.  ...  For Q2 as an representative of the prototypical expected query workload, the DB2 automatic design advisor, db2advis [1] , suggests the B-tree index set of Table 6 (with a total size of 300 MB for a  ... 
doi:10.1145/1739041.1739062 dblp:conf/edbt/GrustMR10 fatcat:xqarv7jdonegvkieerl26p7soa

Toward autonomic computing with DB2 universal database

Sam S. Lightstone, Guy Lohman, Danny Zilio
2002 SIGMOD record  
This paper describes the self-managing or autonomic technology in IBM's DB2 Universal Database ® for UNIX and Windows to illustrate how self-managing technology can reduce complexity, helping to reduce  ...  As the cost of both hardware and software falls due to technological advancements and economies of scale, the cost of ownership for database applications is increasingly dominated by the cost of people  ...  Advances for the Configuration Advisor Research and development continues on the Configuration Advisor, enhancing its modeling for a future release of DB2 UDB.  ... 
doi:10.1145/601858.601873 fatcat:3ptnwhni2bepnf7ebhxgc5z3na

Holistic Schema Mappings for XML-on-RDBMS [chapter]

Priti Patil, Jayant R. Haritsa
2006 Lecture Notes in Computer Science  
Specifically, it produces an information-preserving holistic mapping that transforms the complete XML world-view (XML schema with constraints, XML documents XQuery queries including triggers and views)  ...  In this paper, we present the Elixir system for designing "industrialstrength" mappings for real-world applications.  ...  Specifically, we compare Elixir, with its path-index-based selection, against two alternatives: BasicDB2, where the system has only its default primary key indices, and DB2Advisor, where DB2's Index Advisor  ... 
doi:10.1007/11733836_52 fatcat:r56ha5u7brfyrb2mfpwaebjszq

Schema advisor for hybrid relational-XML DBMS

Mirella M. Moro, Lipyeow Lim, Yuan-Chi Chang
2007 Proceedings of the 2007 ACM SIGMOD international conference on Management of data - SIGMOD '07  
Therefore, this paper describes ReXSA, a schema advisor tool that is being prototyped for IBM DB2 9. ReXSA proposes candidate database schemas given an information model of the enterprise data.  ...  In response to the widespread use of the XML format for document representation and message exchange, major database vendors have started supporting XML in terms of persistance, querying and indexing.  ...  Adler and Anders Berglund for their insightful discussions on the XML design process.  ... 
doi:10.1145/1247480.1247592 dblp:conf/sigmod/MoroLC07 fatcat:z7odhfq2ercyxbe5sma7vfwzim

ROX [chapter]

Alan Halverson, Vanja Josifovski, Guy Lohman, Hamid Pirahesh, Mathias Mörschel
2004 Proceedings 2004 VLDB Conference  
We have developed an experimental framework using DB2 8.1 for Linux, Unix and Windows, and have gathered initial performance results that validate this approach.  ...  An increasing percentage of the data needed by business applications is being generated in XML format.  ...  We would also like to thank Kevin Beyer and Matthias Nicola for useful discussions and  ... 
doi:10.1016/b978-012088469-8.50026-7 dblp:conf/vldb/HalversonJLPM04 fatcat:gn6lrkd6bnh3vlci6cb6ineqme

Ausführungspläne und -planoperatoren relationaler Datenbankmanagementsysteme

Christoph Koch, Katharina Büchse
2015 Workshop Grundlagen von Datenbanken  
Der vorliegende Beitrag dient dazu, die Grundlage für einen derartigen Standard zu bilden und stellt für die am Markt dominierenden Datenbankmanagementsysteme Oracle, MySQL, SQL-Server, PostgreSQL, DB2  ...  Auf Basis dieser Daten bewerten DBMS-spezifische Werkzeuge wie beispielsweise der für DB2 for z/OS im InfoSphere Optim Query Workload Tuner verfügbare Access Path Advisor [1] die Qualität von Zugriffspfaden  ...  Neben der Variante, DB2-Zugriffs- Index-pflege Planumfang MQT-/MV-/IV-Pflege RI-Prüfung Aufwandsabschätzung /Bewertungsmaße I/O proportional CPU zur Anzahl an proportional zur Anzahl Ge-samt Oracle pläne  ... 
dblp:conf/gvd/KochB15 fatcat:4ym7vl2kfbfgbm4mghzp75ro3u
« Previous Showing results 1 — 15 out of 109 results