1. A computer system including instructions recorded on a non-transitory computer-readable medium and executable by at least one processor, the system comprising: an operator generator configured to generate a new operator to add to a structured query language (SQL) query optimization process of a query by a query optimizer under a generic operator framework, wherein, under the generic operator framework, the new operator has a generic operator data structure that includes specifications for input attributes, output attributes and bypass attributes of the new operator; a knowledge base container configured to hold the generic operator data structure of the new operator; a specification handler configured to build, on query compile, the generic operator data structure of the new operator with reference only to the specifications for input attributes, output attributes and bypass attributes of the new operator; and a rule applicator coupled to the query optimizer, the rule applicator configured to apply optimization rules based on the generic operator data structure of the new operator during the structured query language (SQL) query optimization process of the query optimizer.
1. A computer system including instructions recorded on a non-transitory computer-readable medium and executable by at least one processor, the system comprising: an operator generator configured to generate a new operator to add to a structured query language (SQL) query optimization process of a query by a query optimizer under a generic operator framework, wherein, under the generic operator framework, the new operator has a generic operator data structure that includes specifications for input attributes, output attributes and bypass attributes of the new operator; a knowledge base container configured to hold the generic operator data structure of the new operator; a specification handler configured to build, on query compile, the generic operator data structure of the new operator with reference only to the specifications for input attributes, output attributes and bypass attributes of the new operator; and a rule applicator coupled to the query optimizer, the rule applicator configured to apply optimization rules based on the generic operator data structure of the new operator during the structured query language (SQL) query optimization process of the query optimizer. 9. The system of claim 1 , wherein the system further comprises: a query plan generator to generate at least one query execution plan to access data from a database using the knowledge based container, wherein the generic operator framework extends the query optimizer based on the query execution plan.