1. Further, there is the push-down, push-up problem.

2. Star join plan utilizes push-down hash join technology.

3. Based on the CMP/A naming convention, the push-down method is called ejbFindByPrimaryKey, as the code snippet in Listing 6 shows.

4. Once all of the push-down methods are mapped for a CMP/A bean, emit the UDPDMI for that bean, so that the deployer can fill this in with the appropriate logic.

5. In this example, for each push-down method(/push-down.html), there is a corresponding CIM operation that needs to be invoked.

6. In a bit-vector pushdown, for each push-down, the database server hashes the keys from the dimension table to create a bit vector, which is shipped to the fact table.

7. The application of push-down accounting in independent financial statement in emerged enterprises can simplify the compiling of the statement and help information users to understand it.

8. The push-down decision is made by the wrapper during the planning phase, while working with the query optimizer.

9. The optimizer chooses the best number of push-downs based on cost estimation, such that the work required to perform push-down does not outweigh the benefit for applying the push-down filter.

10. A star join plan utilizing push-down hash join technology makes hash joins more effective primarily due to reduction of fact table (probe table) rows early on.

11. Listings 7 and 8 show a sample CIM-XML message exchange -- request and response -- with the CIMOM (over HTTP) in the push-down method through the CIM Adapter.

12. IBM Informix Server V11.70 introduces star join optimization that utilizes push-down hash join technology to improve query performance for decision support queries on star and snowflake schemas.

13. The pushed-down join keys can be used in an index pushdown or a bit-vector push-down.

14. Inspect the optimized SQL in the db2exfmt or Visual Explain output, as this is the basis for the planning decision of the relational data source push-down analysis and the query optimizer.

15. Hence, the non-relational portions of the query do not go through the push-down analysis phase.

16. Therefore, as DB2 Connect acts as a federation layer, it can perform predicate push-down or branch-tree elimination to speed up data access.

17. To demonstrate the use of CMP/A entity bean to push-down operations made on a stateful resource, we define the OperatingSystem WS-Resource using WSDL.

18. They feature a silver handle on the oven door, three black knobs for controlling cooking, and a black push-down lever for toasting.