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. -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
