Re: Is there a tool to allow users to build algorithms that are then run by database

From: <>
Date: Wed, 18 Mar 2009 09:37:58 -0700 (PDT)
Message-ID: <>

On Mar 18, 9:28 am, harry martin <> wrote:
> Using Oracle 10gR2 on unix Solaris.
> We have a database that has equipment tables, readings tables, and lookup
> tables associated with equipment.  we will take both join them, apply
> algorithms to create a health index for each piece of equipment (e.g. take
> age, oil readings, etc, add, substract, mulitply various factors etc).  The
> algorithms will be in form of SQL select statements with some functions
> etc.  We can hardcode them, but the users are requesting the ability to
> view the algorithm, modify them, copy them and modify them, create new ones
> etc, and then have scritps use those algorithm to generate healt indexes.
> Is there a tool to allow non-programmers the ability to do that, that is
> create complex quieres that will populate columns and have those stored in
> the database and used by scripts or stored procedures.

Maybe deliver an excel spreadsheet to them? Have VB or VBA script in the spreadsheet?

Not a big fan though of supporting ODBC type access into a production system myself. Received on Wed Mar 18 2009 - 11:37:58 CDT

Original text of this message