Re: Is there a tool to allow users to build algorithms that are then run by database
From: <johnbhurley_at_sbcglobal.net>
Date: Wed, 18 Mar 2009 09:37:58 -0700 (PDT)
Message-ID: <d75f07bb-2bcc-4081-99ca-2ff0ab31a278_at_v15g2000yqn.googlegroups.com>
On Mar 18, 9:28 am, harry martin <harm..._at_grets.com> 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.
Date: Wed, 18 Mar 2009 09:37:58 -0700 (PDT)
Message-ID: <d75f07bb-2bcc-4081-99ca-2ff0ab31a278_at_v15g2000yqn.googlegroups.com>
On Mar 18, 9:28 am, harry martin <harm..._at_grets.com> 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