Re: Fragmentation project

On 4/23/07, Heikki Linnakangas <heikki@enterprisedb.com> wrote:
> Gustavo Tonini wrote:
> > Well, I'm thinking in define (maybe via SQL) a set of servers as a
> > cluster and make the fragmentation rules based on "select clauses",
> > storing this "configuration" in a specific catalog in global schema.
> > For example: when a record is inserted in a server which not store
> > this fragment (no rule matches), it will be automatically moved do the
> > correct server (the server who matches that record), transparently to
> > the user. This process involves transaction management and a lot more
> > validations.
> >
> > A propose is:
> >
> > create partition <name> on <site> as <select clause>
> >
> > This create a replication in this site with the rules of the select clause.
> >
> > We can provide, for example, users create a foreign key in a site
> > referencing a table who stored in other(s). In this case, the foreign
> > key will be created in global schema but the validations of the local
> > schema's would be managed by DRDBMS.
> >
> > These are my ideas. Is this supported today?
>
> Oh, you're talking about distributing partitions across different nodes
> and parallelizing queries. No, we don't do that today.

Yes.This is the goal. Well, I will try it. I'll send the project
reports to this list. Comments will be valuable. Desire me good
luck...

Thanks,
Gustavo.