A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2013; you can also visit the original URL.
The file type is application/pdf.
Filters
An xml index advisor for DB2
2008
Proceedings of the 2008 ACM SIGMOD international conference on Management of data - SIGMOD '08
Preserved Fulltext
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
2008
2008 IEEE 24th International Conference on Data Engineering
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2013; you can also visit the original URL.
The file type is application/pdf.
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]
2009
Lecture Notes in Computer Science
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2011; you can also visit the original URL.
The file type is application/pdf.
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
2012
The VLDB journal
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2013; you can also visit the original URL.
The file type is application/pdf.
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
2006
IBM Systems Journal
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2006; you can also visit the original URL.
The file type is application/pdf.
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
2006
IBM Systems Journal
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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]
2008
arXiv
pre-print
Preserved Fulltext
The Internet Archive has a preservation copy of this work in our general collections.
The file type is application/pdf.
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®
2008
Proceedings of the 2008 EDBT Ph.D. workshop on - Ph.D. '08
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
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
2007
Proceedings of the 2007 ACM SIGMOD international conference on Management of data - SIGMOD '07
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2007; you can also visit the original URL.
The file type is application/pdf.
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)
2010
Proceedings of the 13th International Conference on Extending Database Technology - EDBT '10
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
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
2002
SIGMOD record
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2011; you can also visit the original URL.
The file type is application/pdf.
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]
2006
Lecture Notes in Computer Science
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2011; you can also visit the original URL.
The file type is application/pdf.
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
2007
Proceedings of the 2007 ACM SIGMOD international conference on Management of data - SIGMOD '07
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2011; you can also visit the original URL.
The file type is application/pdf.
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]
2004
Proceedings 2004 VLDB Conference
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
2015
Workshop Grundlagen von Datenbanken
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2022; you can also visit the original URL.
The file type is application/pdf.
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