MySQL Forums
Forum List  »  Stored Procedures

Re: No Dynamic SQL in Function or Trigger Frustration
Posted by: Mike Jonsson
Date: March 18, 2014 04:13PM

Rick James Wrote:
> "retained immediately"??
> Perhaps you mean "retained indefinitely"?

Perhaps both, but not necessarily indefinitely as the results vary from one day to another.
Each day presents a new subset of variables for validation.

> Have a look at Eureqa. It is good at discovering
> formulas.

Will do.

> Can the processing be broken into chunks? And the
> data in the chunks "summarized" as an intermediate
> step toward the goal? This is very effective in
> Data Warehousing, and in Distributed computing.

> Can the results be derived via "sampling"? That
> is a very effective of getting reasonably accruate
> answers from huge amounts of data without spending
> huge amounts of time.

Not feasible. Subsets are derived from a variety of statistical predefined formulas. These change for every event date and will need to be validated based on such narrow statistical margins to reduce the possible results which may be presented as "valid options".

A strict mathematical formula cannot be applied.

As such sampling only serves to implement uncertainty in "valid options" which "could be" valid instead of checking each option set which actually falls within the statistical margins.

Options: ReplyQuote

Written By
Re: No Dynamic SQL in Function or Trigger Frustration
March 18, 2014 04:13PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.