Re: Real world issue: How to "split" queries in presence of record replication and replication sensitive aggregate functions ?

<pamelafluente_at_libero.it> wrote in message news:1158224084.007892.62800_at_d34g2000cwd.googlegroups.com...
> I 'd like to repropose my original problem which got lost among vain
> fights
> and pollution.
>
> I am infact trying to write as an exercise a "reporting" program. Or
> more
> precisely a program which is capable to generate queries useful to make
> reports.
>
> This can be useful in OLAP systems as well as for classical dbms's.
>
>
> I'd like to get 2 pieces of information:
>
> 1. First what is the relevant literature and how this problem is
> called in the theory
> 2. Most importantly, I need the actual "algorithm", that is a
> systematic way to produce
> these queries

[great big snip]

Given that any body of data whatsoever can be exressed in a suitable schema of tables.
And given that any body of data whatsoever can be expressed in a suitable report.

It follows that, in order to create a completely general query creator, you need to produce an algorithm that will produce an algorithm for any given required transformation from the supplied inputs into the required outputs. In order to come up with such an algorithm in full generality you are going to have to solve the general problem of automatic programming.

Such a project is considerably more ambitious than "writing a reporting program as an exercise".

I suggest you define the scope of what you are trying to achieve more precisely. Received on Sat Sep 16 2006 - 16:18:16 CEST