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
Old 09-05-2008
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...
 
POSIX_TRACE_GET_FILTER(P)				     POSIX Programmer's Manual					 POSIX_TRACE_GET_FILTER(P)

NAME
posix_trace_get_filter, posix_trace_set_filter - retrieve and set the filter of an initialized trace stream (TRACING) SYNOPSIS
#include <trace.h> int posix_trace_get_filter(trace_id_t trid, trace_event_set_t *set); int posix_trace_set_filter(trace_id_t trid, const trace_event_set_t *set, int how); DESCRIPTION
The posix_trace_get_filter() function shall retrieve, into the argument pointed to by set, the actual trace event filter from the trace stream specified by trid. The posix_trace_set_filter() function shall change the set of filtered trace event types after a trace stream identified by the trid argu- ment is created. This function may be called prior to starting the trace stream, or while the trace stream is active. By default, if no call is made to posix_trace_set_filter(), all trace events shall be recorded (that is, none of the trace event types are filtered out). If this function is called while the trace is in progress, a special system trace event, POSIX_TRACE_FILTER, shall be recorded in the trace indicating both the old and the new sets of filtered trace event types (see Trace and Trace Event Filter Options: System Trace Events and Trace, Trace Log, and Trace Event Filter Options: System Trace Events ). If the posix_trace_set_filter() function is interrupted by a signal, an error shall be returned and the filter shall not be changed. In this case, the state of the trace stream shall not be changed. The value of the argument how indicates the manner in which the set is to be changed and shall have one of the following values, as defined in the <trace.h> header: POSIX_TRACE_SET_EVENTSET The resulting set of trace event types to be filtered shall be the trace event type set pointed to by the argument set. POSIX_TRACE_ADD_EVENTSET The resulting set of trace event types to be filtered shall be the union of the current set and the trace event type set pointed to by the argument set. POSIX_TRACE_SUB_EVENTSET The resulting set of trace event types to be filtered shall be all trace event types in the current set that are not in the set pointed to by the argument set; that is, remove each element of the specified set from the current filter. RETURN VALUE
Upon successful completion, these functions shall return a value of zero. Otherwise, they shall return the corresponding error number. The posix_trace_get_filter() function stores the set of filtered trace event types in set, if successful. ERRORS
These functions shall fail if: EINVAL The value of the trid argument does not correspond to an active trace stream or the value of the argument pointed to by set is invalid. EINTR The operation was interrupted by a signal. The following sections are informative. EXAMPLES
None. APPLICATION USAGE
None. RATIONALE
None. FUTURE DIRECTIONS
None. SEE ALSO
Trace and Trace Event Filter Options: System Trace Events , Trace, Trace Log, and Trace Event Filter Options: System Trace Events , posix_trace_eventset_add() , the Base Definitions volume of IEEE Std 1003.1-2001, <trace.h> COPYRIGHT
Portions of this text are reprinted and reproduced in electronic form from IEEE Std 1003.1, 2003 Edition, Standard for Information Technol- ogy -- Portable Operating System Interface (POSIX), The Open Group Base Specifications Issue 6, Copyright (C) 2001-2003 by the Institute of Electrical and Electronics Engineers, Inc and The Open Group. In the event of any discrepancy between this version and the original IEEE and The Open Group Standard, the original IEEE and The Open Group Standard is the referee document. The original Standard can be obtained online at http://www.opengroup.org/unix/online.html . IEEE
/The Open Group 2003 POSIX_TRACE_GET_FILTER(P)
All times are GMT -4. The time now is 11:11 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy