Postgres Pro
Downloads
Home   >   mailing lists

Thread: Automation Using Databases.

Automation Using Databases.

From
"Jasbinder Singh Bali"
Date:
Hello,
 
I'm going to give you all an overview of my system which is as follows:
 
A record gets inserted in a table, trigger is fired (after insert) and this tirggers calls a function written in perl.
This function is a client socket implementation and opens a socket connection between the database server and the Unix tools server.
 
Unix tools server runs tools like traceroute etc, fetches the result, opens an ODBC connection with the same database server and stores tools result in a table.
So, one can conclude that in my case database is not only a data storing engine but an automation engine as well that automates the start of unix tools.
 
I am wondering if someone else has done this kind of stuff or related to it. Also, if someone has accomplished the same thing without using triggers.
In short, I'm looking for any related work. Anything directly or indirectly.
 
I need some pointers and any kind of help would be highly appreciated.
I'm trying to compare my work with what people have already done.
 
Also, It would be great if someone could give me some pointers for any papers published in this regard. I'm basically looking for some technical papers in this field of databases and then compare my work with them.
 
I tried finding something on internet. No success so far.
 
Thanks alot in advance
Jas

Re: Automation Using Databases.

From
"Andrej Ricnik-Bay"
Date:
On 8/13/07, Jasbinder Singh Bali <jsbali@gmail.com> wrote:

> A record gets inserted in a table, trigger is fired (after insert) and this
> tirggers calls a function written in perl.
What kind of event inserts the record?  And what's the purpose of
the whole "automation tool"?

> Thanks alot in advance
> Jas
Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

Re: Automation Using Databases.

From
"Andrej Ricnik-Bay"
Date:
On 8/13/07, Harpreet Dhaliwal <harpreet.dhaliwal01@gmail.com> wrote:
> There's a table in which data gets inserted. a simple table insert.
> I really can't leak out the purpose of the tool because I'm not supposed to
Well ... if you guys don't say what you're doing how
do you expect to get feedback of others who may be
doing the same thing?  Secret squirrels doesn't work
for me - sorry.


Cheers,
Andrej