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.
--
Windows 98: n.
useless extension to a minor patch release for 32-bit
extensions and
a graphical shell for a 16-bit patch to an 8-bit operating
system
originally coded for a 4-bit microprocessor, written by a
2-bit
company that can't stand for 1 bit of competition.
-
(c) 2000 Stan Brown. Redistribution via the Microsoft Network is
prohibited.
-----------------------------------------------------------------------
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]
