Abstract: Systems and methods for the integration of an effects framework pipeline with one or more programmable shaders of a computer graphics pipeline is provided. In an illustrative implementation, one ore more component interfaces is provided that allow for the communication and processing of data by one or more cooperating components of a computer graphics pipeline. The component interfaces operate on a data file having high level programming computer instruction sets that, inter alia, provide a manner to express one or more constraints and/or variables for desired constraints. In operation, the cooperating components, such as programmable shaders, of the computer graphics pipeline perform one or more steps according to the instruction sets found in the effects data file. The instruction sets are designed to allow a plain language expression of a desired effect without requiring knowledge of the machine level operations of the computer graphics pipeline.

Abstract: An auto-parameterization process transforms a database query into a parameterized basic query form by replacing any constant values in the query with parameters. The auto-parameterization process attempts to generate a safe execution plan from the basic query form if there is currently no such plan available. A safe execution plan is defined as an execution plan that is optimal over a range of values for the parameters. If a safe execution plan can be generated, it is passed for execution, along with the constant values that were present in the query. If a safe execution plan cannot be generated, the auto-parameterization process passes a specific execution plan for execution. The safe execution plan is cached either at the time it is created or at the time it is executed. The cache is searched each time a parameterized basic query plan is generated by the auto-parameterization process.