Continuously querying a datastream using SQL Server 2005

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • paulb
    #1

    Continuously querying a datastream using SQL Server 2005

    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.

    Tags: None
    • Erland Sommarskog
      #2
      Re: Continuously querying a datastream using SQL Server 2005

      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@sommarsk og.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

        Comment

        • paulb
          #3
          Re: Continuously querying a datastream using SQL Server 2005

          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.





          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@sommarsk og.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/prodinf...ons/books.mspx

            Comment

            • Erland Sommarskog
              #4
              Re: Continuously querying a datastream using SQL Server 2005

              paulb (paulbermingham @gmail.com) writes:
              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@sommarsk og.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

                Comment

                • paulb
                  #5
                  Re: Continuously querying a datastream using SQL Server 2005

                  Well, I thought SQL Server may have some real time data analysis
                  capability. Obviously it is not equiped for this. I guess I'll have to
                  stick to the LINUX based packages I am currently using. Probably faster
                  anyway.

                  Thanks,

                  Paul.

                  Erland Sommarskog wrote:
                  paulb (paulbermingham @gmail.com) writes:
                  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@sommarsk og.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/prodinf...ons/books.mspx

                    Comment

                    Previous template Next
                    Working...