Re: No Dynamic SQL in Function or Trigger Frustration
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.
Subject
Views
Written By
Posted
2776
February 27, 2014 06:47PM
1160
February 27, 2014 08:47PM
1126
February 27, 2014 09:11PM
1099
March 14, 2014 07:43PM
1225
March 15, 2014 02:26AM
1073
March 15, 2014 10:47AM
1056
March 17, 2014 12:29AM
1041
March 17, 2014 10:38PM
Re: No Dynamic SQL in Function or Trigger Frustration
1202
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.