Inferred knowledge

It was indicated (see Section 10.5) that Jelly Relations are created before the rewritten query is sent to the database, and they exist only for the time of query execution. They are implemented as temporary tables. Such tables exist for particular session only, so there is no threat of a name conflict if different sessions use the same Jelly Relation name.

Even if the Jelly Relation names are the same for different users (sessions), which issue their queries simultaneously, they will coexist. Each user will see only his or her own relation, not even knowing about other temporary tables created by other users. After the rewritten query is executed and all the results passed back to the user, the temporary tables are dropped.



Igor Wojnicki 2005-11-07