Question

Pre-join projection equivalent to ________ as in traditional relational systems

Answer 1

stored procedure is the answer

Answer 2

“Pre-join projection” is equivalent to “materialized view” as in “traditional relational systems”. A "materialized view" is an object in the database which carries the "result set of the query".

This may be a subset of the rows and the columns in the table or local copy of the database which is in a virtual place else it can be a summary. In short, it is a snapshot of the table segment.