We have had a lot of success with Aspen's InfoPlus/21 Data Historian. It is
a true realtime relational database and SQL works superbly with it. It also
works great with other ODBC compliant programs such as Excel and Access as
well as DB to DB connectivity.
Chad Airhart
Instrumentation & Control Engineer
Equistar Chemicals, LP.
Victoria, TX
Wk. (361) 572-2568
Pgr. (361) 270-2214 alpha messaging at www.arch.com
Fx. (361) 572-2541
> -----Original Message-----
> From: Johnson,Alex [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 02, 2000 1:42 PM
> To: Foxboro DCS Mail List
> Subject: RE: Classic historian data location(s)
>
> Re: ODBC
>
> I don't know how sophisticated a query it can support, but AIM* is
> definitely not a relational database.
>
> [Do you really want to do a join of pressure and temperature using time as
> the key? That's about the only type of query that you could do. I guess a
> pressure vs. temperature curve would be interesting, but is it really that
> much better than two time plots of the P and T?]
>
>
> Re: I/A Series Messages
>
> AIM* records its messages in a flat file and provides an API to retrieve
> them. It does not have a GUI equivalent to the FoxAMI GUI at this time.
>
>
> Regards,
>
> Alex Johnson
> The Foxboro Company
> 10707 Haddington
> Houston, TX 77043
> 713.722.2859 (v)
> 713.722.2700 (sb)
> 713.932.0222 (f)
> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
>
> -----Original Message-----
> From: Stan Brown [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 02, 2000 12:22 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Classic historian data location(s)
>
> On Tue May 2 12:38:07 2000 Johnson,Alex wrote...
> >
> >AIM*Historian uses flat files to store all of its data since they
> provide
> >much faster insertion and query support.
> >
> >AIM*Historian does supply an ODBC front-end that makes the data
> appear as if
> >it is in a simple relational database.
>
> Sorry to keep asking questions :-)
>
> Does this ODBC interface provide a good SQL interface? By
> good I mean
> supporting joins etc. And are teh system manager alarms
> also stored in
> the new historian, or are they kept somwhere else?
>
> And again, thanks for the eduaction.
>
> We are contemplating upgradeing to the new historian, and
> are just
> trying to learn about the relatives strngths, and weakness
> of the two.
>
>
> --
> Stan Brown [EMAIL PROTECTED]
> 843-745-3154
> Charleston SC.
> --
-----------------------------------------------------------------------
This list is neither sponsored nor endorsed by the Foxboro Company. All
postings from this list are the work of list subscribers and no warranty
is made or implied as to the accuracy of any information disseminated
through this medium. By subscribing to this list you agree to hold the
list sponsor(s) blameless for any and all mishaps which might occur due to
your application of information received from this mailing list.
To be removed from this list, send mail to
[EMAIL PROTECTED]
with "unsubscribe foxboro" in the Subject. Or, send any mail to
[EMAIL PROTECTED]
