|
PICASSO_XML
Database Systems Lab Indian Institute of Science | ||||
| ||||
| | ||||
|
Background
| ||||
|
Picasso database query optimizer visualizer software
developed at the Database Systems Lab, Indian Institute of Science,
is a tool, written entirely in Java, and operational on a suite of
industrial-strength database query optimizers.
The details about Picasso can be found here.
| ||||
| PICASSO_XML | ||||
|
Currently, given a query template that defines a relational selectivity space and a
choice of database engine, the Picasso tool automatically generates a variety
of diagrams that characterize the behavior of the engine's optimizer over this
relational selectivity space.
In recent years, data represented in the hierarchically-structured XML document format has found its way into mainstream database technology. To cater to the XML needs, over the past year, we have worked on extending Picasso, which currently caters only to SQL-based optimizers, to also support XML features i.e., XML documents and XQuery which is used to query XML docs, and we have successfully completed the porting. | ||||
| Plan Trees | ||||
|
The plan trees for the TPCH_X templates are made available in
the following links.
| ||||
| Download | ||||
|
The TPCH_X data sets, for which the selectvity errors were encountered
for the case of negative numbers can be downloaded from the links below.
The linearly translated version is also made available (Only the relations
which were translated are given. The data for the rest of the relations
are as given in the negative numbers case itself).
All the data files are in the DEL (Delimited ASCII format).
|