Padraig O'Sullivan wrote: > On Mon, May 4, 2009 at 1:15 AM, Brian Aker <[email protected]> wrote: >> Hi! >> >> On May 3, 2009, at 10:12 PM, Alex Esterkin wrote: >> >>> The query optimizer and the transaction/lock manager need to process >>> views. I don't see how you could implement something like view support as a >>> plugin... >> >> Views are just a rewrite, and typically are designed as some piece of a >> rewrite engine. > > Like Brian said, view's are normally handled by a query rewriter > module. Lots more information on this can be found in section 4.2 of a > paper by Stonebraker > (http://db.cs.berkeley.edu/papers/fntdb07-architecture.pdf) where he > goes in to some detail on query rewriting along with providing ample > references to more papers for further information. > > I'm curious, are there plans for query rewriting to be supported as a > plugin? I think it would be kind of cool to implement your own query > rewriter which is as complex or simple as you want it to be. I'm > guessing a lot of refactoring still needs to be done around the query > parser and the optimizer before this is possible though.
I don't know about plans, but once there is a good query tree format (and an interface to the symbol table for some really useful rewrites), query rewrite is just a hook away. I didn't say that is was easy or simple... /Matz > > -Padraig > >> Cheers, >> -Brian >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~drizzle-discuss >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~drizzle-discuss >> More help : https://help.launchpad.net/ListHelp >> > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp -- Mats Kindahl Senior Software Engineer Database Technology Group Sun Microsystems _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
