Real-time event processing system with subscription model

Details Real-time event processing system with subscription model Real-time event processing system with subscription model

1999-03-25

2002-09-10

Corrielus, Jean M. (Department: 2172)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

06449618

ABSTRACT:

FIELD OF THE INVENTION
The present invention relates generally to real-time event processing, and more particularly to methods, apparatus and systems for processing real-time events in applications such as telecommunications and computer networks.
BACKGROUND OF THE INVENTION
Many event-processing systems have real-time performance requirements that cannot be met by conventional general-purpose database management systems. In telecommunications applications, for example, a variety of adjunct switching services such as debit-based billing, number mapping, call forwarding, and local-number portability involve event processing during the critical call-connection phase of a telephone call. To meet the real-time requirements of the network, the service time for such events generally must not exceed a few milliseconds. However, with conventional database technology, the costs of invoking a structured query language (SQL) operation over a client-server interface, or the costs associated with a single access to secondary storage, can account for hundreds of milliseconds. As a consequence, performance goals on the order of a few milliseconds may already be unattainable even before the costs of the event processing logic are taken into account.
These limitations have led to the use of custom database systems for many high-performance real-time event processing applications. Custom systems are typically tightly coupled to their particular applications, and are tuned to the specific requirements of those applications. These solutions generally work well in practice, and can provide close to optimal performance. However, they also have a number of serious disadvantages. For example, the cost of developing and maintaining custom systems can be high, and generally cannot be amortized across a number of different applications. Moreover, custom systems are frequently inflexible. It can become difficult or even iimpossible to adapt a custom system to unforeseen or evolving requirements.
A need therefore exists for an improved real-time event processing system which provides the performance benefits of custom database systems, without sacrificing the flexibility and maintainability typically associated with conventional general-purpose database systems.
SUMMARY OF THE INVENTION
The invention provides a general-purpose real-time event processing system (EPS) which avoids the problems associated with custom systems. The EPS in an illustrative embodiment meets real-time performance goals through the use of one or more real-time analysis engines (RAEs) operating in conjunction with a main-memory storage manager as its underlying database system. The main-memory storage manager offers transactional access to persistent data, but at the speed of a main-memory system. The RAEs store subscription information in accordance with a subscription model that serves as a basis for flexible, low-overhead, real-time event processing.
In accordance with the invention, the subscription information indicating the service or services that should be executed for a given event is stored in the form of a subscription table in the memory portion of the main-memory database system. The subscription table may be in the form of a compact subscription table which includes a subscriber identifier, a start timestamp, an end timestamp, and a subscription term specified using a run-time interpretable subscription language. At any particular point in time, the compact subscription table includes at most one relevant entry for each subscriber. The compact subscription table may be generated by applying translation and update propagation operations to a more complex subscription table generated by the system application. In operation, a RAE determines if a given event is a non-subscribed event or a subscribed event, directly invokes a corresponding event handler if the event is a non-subscribed event, and accesses the stored subscription information to determine at least one event handler if the event is a subscribed event. If the event is a subscribed event, the RAE may use the stored subscription information to determine a set of event handlers and an order in which to call them to process the event.
A real-time EPS in accordance with the invention provides a critical path for event processing that is specifically designed for high performance, while also retaining many desirable features of conventional database systems, including high-level, declarative programming interfaces, and the well-known transactional correctness properties of atomicity, consistency, isolation and durability (ACID). These features of the invention enhance the reliability, robustness, usability and maintainability of the real-time EPS and the applications built thereon.
The invention can be used in conjunction with any event processing application, including, for example, telecommunications, electronic commerce, and Internet service provisioning applications. For example, in a telecommunications application, the invention can be configured to provide a basis for features such as enhanced billing systems, fraud detection and prevention, local-number portability, settlements among service providers and real-time traffic analysis.


REFERENCES:
patent: 5740423 (1998-04-01), Logan et al.
patent: 5751798 (1998-05-01), Mumick et al.
patent: 5828845 (1998-10-01), Jagadish et al.
patent: 5878126 (1999-03-01), Velamuri et al.
patent: 0809387 (1997-11-01), None
patent: 0809410 (1997-11-01), None
Harrison et al. (The design and performance of a real-time CORBA event service, ACM, 1997, pp. 184-200).*
Boasson (Subscription as a model for the architecture of embedded systems, IEEE, 1996, pp. 130-133).*
Gyllensward et al. (A software architecture for complex real-time systems, IEEE, 1994, pp. 110-115).*
Seraj et al. (RPM real time performance management, IEEE, 1998, pp. 840-848, vol. 3).*
Smith (An approach to customer-centered interface, IEEE, 1994, pp. 619-623).*
Combes et al. (Service animation integrating call processing and management scripts, IEEE, 1998, pp. 327-343).*
G.D. Baulier et al., “Sunrise: A Real-Time Event-Processing System,” Bell Labs Technical Journal, pp. 3-18, Jan.-Mar., 1998.
J. Baulier et al., “A Database System for Real-Time Event Aggregation in Telecommunication,” Proceedings of the 24th VLDB Conference, New York, USA, 3 pages, 1998.
H.V. Jagadish et al., “View Maintenance Issues for the Chronicle Data Model,” Proc. ACM SIGACT-SIGMOD-SIGART Symp. on Principles of Database Systems (PODS), San Jose, Calif., pp. 113-124, May 1995.
N.H. Gehani et al., “Event Specification in an Active Object-Oriented Database,” AT&T Bell Labs Technical Journal, pp. 81-90, 1992.
X. Qian et al., “Incremental Recomputation of Active Relational Expressions,” IEEE Transactions on Knowledge and Date Engineering, vol. 3, No. 3, pp. 337-341, Sep. 1991.
P.L. Bohannon et al., “The Architecture of the Dali Main Memory Storage Manager,” Bell Labs Tech. J., vol. 2, No. 1, pp. 1-36, 1997.
H.V. Jagadish et al., “Dali: A High Performance Main Memory Storage Manager,” Proc. Intl. Conf. on Very Large Databases (VLDB), Santiago, Chile, pp. 1-12, Sep. 1994.
D. DeWitt et al., “Implementation Techniques for Main-Memory Database Systems,” Proc. ACM SIGMOD Intl. Conf. on Management of Data, Boston, Mass., pp. 1-8, Jun. 1984.
T.J. Lehman and M.J. Carey, “A Study of Index Structures for Main-Memory Database Management Systems,” Proc. Intl. Conf. on Very Large Databases (VLDB), Kyoto, Japan, Aug. pp. 294-303, 1986.
T.J. Lehman et al., “An Evaluation of Starburst's Memory-Resident Storage Component,” IEEE Transactions on Knowledge and Data Engineering, vol. 4, No. 6, pp. 555-566, Dec. 1992.
K. Salem et al., “System M: A Transaction Processing Testbed for Memory Resident Data,” IEEE Transactions on Knowledge and Data Engineering, vol. 2, No. 1, pp. 161-172, Mar. 1990.
Baulier et al, Sunrise: A Real-Time Event-Processing System, Bell Labs Technical Journal, Jan.-Mar. 1998, pp. 3-18.*
Cha et al., Object-Oriented Design of Main-Memory DBMS for Real-Time Applications, IEEE, 1995, pp. 109-11

Affiliated with

Also associated with

Rating

Real-time event processing system with subscription model does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Real-time event processing system with subscription model, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Real-time event processing system with subscription model will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2878677