Microsoft Technology Licensing, LLC

Microsoft Corporation

Beysim Sezgin

Ramachandran Venkatesh

Jose A Blakeley

Torsten Walther Grabs

Balan Sethu Raman

Roman Schindlauer

Peter Alan Carlin

Denis Y Altudov

Balaji Rathakrishnan

Tomer Verona

Jun Fang

Christopher Wellington Brumme

Jonathan David Goldstein

Conor J Cunningham

Wei Yu

Steven J Pratschner

Ciprian Gerea

Ian H Carmichael

Ramkumar Krishnan

Mason K Bendixen

WeiWen Liu

Stefano Stefani

Cesar Alejandro Galindo-Legaria

Raja Krishnaswamy

Badrish Chandramouli

Christopher David Brown

Sean Edwin Trowbridge

Tihomir Tsvetkov Tarnavski

Mahesh Prakriya

Alan C Shi

Peter Zabback

Oliver Nicholas Seeliger

Suzanne Maurine Cook

Bruno H M Denuit

Mei-Chin Tsai

Mohamed Hassan Ali

Dragan Tomic

Denis Churin

Ping Wang

Alexios Boukouvalas

Hongang Zhang

Asvin Ananthanarayan

Mathieu Henaire

Ramachandron Venkatesh

The disclosed architecture leverages realtime continuous event processing (CEP) to address using a general input interface framework to import a dynamic set of event types (e.g., assets), and using a declarative, expressive query model to implement monitoring and management tasks on an asset level. This is in contrast to looking separately at single values from static databases and/or realtime streams as is common conventionally. The architecture uses the CEP data model to model assets as realtime event types. Thus, queries can be formulated per asset and not just per single stream. The architecture uses the query capabilities of CEP to formulate asset management and monitoring tasks as standing, declarative queries, and uses the input interface of a CEP platform to correlate data from different data sources with different dynamic properties.

Dynamic asset monitoring and management using a continuous event processing platform

The disclosed architecture utilizes realtime continuous event processing (CEP) to address the use of a general input interface framework to import a dynamic set of event types (e.g., assets), and a declarative, expressive query model to implement monitoring and management tasks on an asset level. In one implementation, a realtime event processing system is provided, comprising a synchronization component configured to synchronize realtime event data and static event data of assets, and a realtime merge component configured to merge the synchronized realtime event data and static event data into a realtime event stream using one or more operators. The merged synchronized realtime event data and static event data is queriable as a single event type using a query to return related asset items.

Methods, systems, and computer-readable media are disclosed for event processing with a query based on a reusable XML query template. A particular method includes receiving a plurality of events from a source and generating a plurality of event objects based on the plurality of events. A query represented by an XML file based on a reusable XML query template is executed with respect to the plurality of event objects to produce a plurality of result objects. Each result object is produced based on an application of at least one operator of the query. A plurality of results is generated based on the plurality of result objects, and the plurality of results is transmitted to a sink.

Event processing with XML query based on reusable XML query template

Methods, systems, and computer-readable media are disclosed for time-based event processing using punctuation events. A particular method includes receiving a first event object comprising a first validity start time and a first validity end time, where the first validity end time is initially undefined. A punctuation object is received after the first event object. The punctuation event object has a punctuation timestamp indicating a time subsequent to the first validity start time. The punctuation event object indicates that event objects to be received at the computer system after the punctuation event object have validity start times later than the time indicated by the punctuation timestamp. The method includes setting the first validity end time to a value later than or equal to the time indicated by the punctuation timestamp.

Time-based event processing using punctuation events

Methods, systems, and computer-readable media are disclosed for implementing adapters for event processing systems. A particular system includes an input adapter configured to store event objects received from a source at an input queue. The system also includes a query engine configured to remove event objects from the input queue, to perform a query with respect to the removed event objects to generate result objects, and to insert result objects into an output queue. The system also includes an output adapter configured to remove result objects from the output queue and to transmit the result objects to a sink.

Complex event processing (CEP) adapters for CEP systems for receiving objects from a source and outputing objects to a sink

An extensibility framework that allows a user to write user-defined modules that include user-defined operators (UDO) and user-defined aggregators (UDA) in a non-temporal fashion without the need to worry about temporal attributes of events (or event types). The temporal domain is managed on behalf of the user, and allows the user to write operators and aggregates in the temporal data streaming domain as well as to port existing libraries of non-temporal UDOs/UDAs to the temporal data streaming domain. Temporal attributes and event types are managed for non-temporal UDOs/UDAs by the extensibility framework on behalf of the UDO/UDA writer. Windows can be employed to bridge the gap between the non-temporal domains and temporal domains. Support for complex event processing (CEP) is provided in UDOs/UDAs for base classes related to a CEP operator, CEP aggregate, CEP time sensitive operator, and CEP time sensitive aggregate.

Extensibility model for stream-based operators and aggregates

Methods, systems, and computer-readable media are disclosed for partitioned query execution in event processing systems. A particular method includes receiving a plurality of events via an input stream. The plurality of events is partitioned into one or more groups, and a query application module is instantiated for each of the one or more groups based on a compiled query application plan. Each particular query application module for a particular group is configured to apply a query to events of the particular group to generate partial results. The method includes merging the partial results of each of the query application modules to generate merged output results and providing the output results to an output stream.

Partitioned query execution in event processing systems

A system that facilitates checking the consistency of a user-defined data type in relation to a database environment. The invention can employ a user-defined type (UDT) storage format whereby values can be self-describing, including the runtime type of the value. The invention can take the type definition that is persisted in the metadata catalogs as a streaming input and generate a type-specific state machine thereafter. At every point in the checking process, the type-specific state machine can be aware of the next data type that is to be encountered in the check. Whenever an embedded UDT is encountered, the current type-specific state machine can be suspended and saved. The embedded UDT can be checked before proceeding. In this way, the complex check can be effected using memory space proportional to the number of levels in the UDT as opposed to the number of bytes in the object.

User-defined type consistency checker

The present invention describes an efficient and fast framework for implementing table-valued functions (TVF's) in a relational database server. The framework provides desirable extensibility properties and has the ability to minimize performance degradations by integrating tightly with the optimization infrastructure in a query processor. The present invention also enables a managed execution environment (MEE) such as the Common-Language-Runtime (CLR), to efficiently and dynamically extend the logic of the database engine with user-supplied code.

System and method for efficient evaluation of a query that invokes a table valued function

A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined type and methods that can be invoked on instances of the type. The class is then registered with the database system, which enforces a specific contract for user-defined types against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined type in a database store. Second, the class must be capable of returning a null value for the user-defined type. Third, the class must provide a method for converting the user-defined type to another type. Once these requirements are satisfied, the database system enables instances of the user-defined type to be created. A user-defined type can be used in all contexts where any other built-in type can be used. This includes defining columns of tables, declaring variables and parameters to functions and stored procedures, and evaluating expressions of the user-defined type in SQL queries and updates. Preferably, the database system stores metadata about the user-defined type for subsequent use in creating instances of the type.

System and method for providing user defined types in a database system

Growing community of inventors

Redmond, WA, United States of America

Beysim Sezgin