Multiple Query Optimization

Post Reply
Alireza
Posts: 3
Joined: Sat Aug 02, 2014 6:14 am

Multiple Query Optimization

Post by Alireza » Sun Jan 18, 2015 5:01 am

Hello,

I got two questions:
1) Is there is any documentation about the multi-layer optimization strategies that Odysseus perform?
2) Does Odysseus show the different Query execution plans with their associated cost as we have in DBMSs (like SQL Server or Oracle)?

Thank you very much,
Alireza

User avatar
Marco Grawunder
Posts: 269
Joined: Tue Jul 29, 2014 10:29 am
Location: Oldenburg, Germany
Contact:

Re: Multiple Query Optimization

Post by Marco Grawunder » Mon Jan 19, 2015 10:29 am

1) Not really. Currently, Odysseus performs the following to optimizations:
a) Query rewrite: e.g. Selection and projection pushdown
b) Query sharing: Along as the way from the sources to the sinks are the same in different queries, only one operator for each query is used.
2) Currently, different execution plans are not generated. It is not that necessary in stream system because we do not have mulitple data access paths to choose from. Only join order could be relevant, but for this meta data about the sources is needed. There are first approaches but not in the current release.

Alireza
Posts: 3
Joined: Sat Aug 02, 2014 6:14 am

Re: Multiple Query Optimization

Post by Alireza » Fri Jan 23, 2015 5:39 am

Thank you very much for the information.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest