Erland,
Query Notifications look like they would do the job alright but it
would mean writing each new piece of data to a table, querying it, and
then pulling the result back into my program. If this is the only
solution then I would probably be better dealing with the data-stream
within the program as speed is a huge factor and recording the data is
a secondary concern. My main question was whether there is specific
functionality within SQL Server to deal with real time analysis of data
streams?
Thanks,
Paul.
[quoted text, click to view] Erland Sommarskog wrote:
> paulb (paulbermingham@gmail.com) writes:
> > I was wondering if it is possible to continuously query a real-time
> > datastream using SQL Server. Does anyone have any experience of this? I
> > have found LINUX based systems such as Borealis and STREAM. I would
> > prefer to use a Windows based system as the program using the query
> > results is Windows based.
>
> What more exactly what you want to achieve? Query notification is the first
> thing that comes to mind, but it may not be exactly what you are looking
> for.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
>
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx > Books Online for SQL Server 2000 at
>
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
paulb (paulbermingham@gmail.com) writes:
[quoted text, click to view] > Query Notifications look like they would do the job alright but it
> would mean writing each new piece of data to a table, querying it, and
> then pulling the result back into my program. If this is the only
> solution then I would probably be better dealing with the data-stream
> within the program as speed is a huge factor and recording the data is
> a secondary concern.
Well, the main purpose of a database engine is to record the data. To me
it sounds like you are looking for a solution without an RDBMS.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at
