Towards a Streaming SQL Standard Post: 302232915

Sponsored Content

Special Forums News, Links, Events and Announcements Complex Event Processing RSS News Towards a Streaming SQL Standard Post 302232915 by Linux Bot on Friday 5th of September 2008 01:40:04 PM

09-05-2008

Registered User

Towards a Streaming SQL Standard

Tim Bass
09-05-2008 10:39 AM
In More Towards a Streaming SQL Standard, Marc Adler says, “Despite what I think about Streambase’s marketing and sales organization, you must admit that Zdonik and Cherniack are first-class researchers, and have contributed a lot to the field of CEP.”

I agree that these gentlement*are top notch researchers, witnessed by the fact that the authors do not mention nor claim to be “complex event processing” anywhere in their paper!* This paper is not about CEP, nor does it*claim to be about CEP,*it is about stream processing and unifying SQL standards.

ABSTRACT: This paper describes a unification of two different SQL extensions for streams and its associated semantics. We use the data models from Oracle and StreamBase as our examples. Oracle uses a time-based execution model while StreamBase uses a tuple-based execution model. Time-based execution provides a way to model simultaneity while tuple-based execution provides a way to react to primitive events as soon as they are seen by the system.

Asmentioned on numerous occasions, stream processing is*a very important area in CEP/EP.** It is important not to confuse the higher situational knowledge from object-object correlation and state management*with the single-object event refinement that occurs in stream processsing.*** Event stream processing is fundamentally different than complex event processing.*

Event stream processing performs operations on streaming event objects.** In almost all advanced CEP/EP applications is is necessary to perform robust track and trace operations on streaming event objects, like tracking the position of an airplane.*** Tracking the position of an aircraft can be modelled very nicely with event stream processing.* Tracking individual event objects is a precuror to multiclass object situation refinement.

When we manage the state of all the aircraft in the skies over New York, you need more than a stream processing construct.* You need to manage the state of all the aircraft.* Paul Vincent of TIBCO Software*being to address*this important point in The Value of State...**

Again, we will be better equiped to solve complex distributed event processing problems if we do not confuse the notion of event stream processing and complex event processing.** These technologies are indeed complimentary, both very important, but they are not the same.

I applaud Oracle and StreamBase’s work toward a unified standard for SQL extensions for streams.

Source...

Linux Bot

View Public Profile for Linux Bot

Find all posts by Linux Bot

LEARN ABOUT DEBIAN

sql::reservedwords::sqlite

SQL::ReservedWords::SQLite(3pm) 			User Contributed Perl Documentation			   SQL::ReservedWords::SQLite(3pm)

NAME

       SQL::ReservedWords::SQLite - Reserved SQL words by SQLite

SYNOPSIS

	  if ( SQL::ReservedWords::SQLite->is_reserved( $word ) ) {
	      print "$word is a reserved SQLite word!";
	  }

DESCRIPTION

       Determine if words are reserved by SQLite.

METHODS

       is_reserved( $word )
	   Returns a boolean indicating if $word is reserved by either SQLite 2 or 3.

       is_reserved_by_sqlite2( $word )
	   Returns a boolean indicating if $word is reserved by SQLite 2.

       is_reserved_by_sqlite3( $word )
	   Returns a boolean indicating if $word is reserved by SQLite 3.

       reserved_by( $word )
	   Returns a list with SQLite versions that reserves $word.

       words
	   Returns a list with all reserved words.

EXPORTS

       Nothing by default. Following subroutines can be exported:

       is_reserved
       is_reserved_by_sqlite2
       is_reserved_by_sqlite3
       reserved_by
       words

SEE ALSO

       SQL::ReservedWords

       <http://www.sqlite.org/docs.html>

AUTHOR

       Christian Hansen "chansen@cpan.org"

COPYRIGHT

       This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.8.8							    2008-03-28					   SQL::ReservedWords::SQLite(3pm)