Abstract: Systems and methods of stream technologies are disclosed. In some example embodiments, a method and system for a database stream switchover from one data center to another with notification at each component is provided.

Abstract: Systems and methods of stream technologies are disclosed. In some example embodiments, a method and system for a database stream switchover from one data center to another with notification at each component is provided.

Abstract: Systems and methods of stream technologies are disclosed. In some example embodiments, a method and system for a database stream switchover from one data center to another with notification at each component is provided.

Abstract: A metadata validation process that allows for deferring object model validation until after the objects are created. The process also allows for multi-threaded processing of the validation rules, thus increasing overall performance. Validation is performed by enforcing a series of validation rules on an appropriate subject. Rules are specified according to the subject that they are validating (i.e., attribute level, association level, object level or collection level). The metadata driven validation process implements several validation types on different validation units. Correctness validation rule types ensure that a validation unit satisfies all semantic rules defined for it. Completeness validation rule types ensure that a validation unit contains all the necessary data and is ready for further use. At design time, only correctness type validation is performed. Thus, the present invention advantageously allows for incomplete objects to be created at design time.

Abstract: The present invention is directed to a method and mechanism for calling on external procedure in a database system in which the external procedure contains embedded database query language statements. According to an aspect of the invention, the external procedure executes using the same database connection and transaction as the original calling entity for that external procedure.

Abstract: A multithreaded client application initiates multiple database operations associated with at least one transaction. The client application allocates and stores a separate runtime context for each of the database transactions. These transaction runtime contexts are also distinct from the state information, or runtime context, of the thread initiating a particular operation of the transaction. As a result, operations started by a thread that terminates may be continued, or resumed, by a subsequent thread without having to reperform previously executed operations. The duration of the transactions' runtime context is thus decoupled from the duration of the thread's runtime context. Special syntax and routines are provided for explicitly allocating a runtime context and deallocating a runtime context.

Abstract: A method and apparatus for passing runtime contexts between threads in a multithreading application is provided. A precompiler is provided which allows programmers to declare and use runtime contexts in the same manner as other conventional variable types are declared and used. Special syntax and routines are provided for explicitly allocating a runtime context and deallocating a runtime context, thus decoupling the duration of a runtime context from the duration of the thread that initiated the operations whose states are stored in the runtime context. Consequently, operations started by a thread that terminates may be continued by a subsequent thread without having to re-perform previously executed operations. Precompiler directives are provided to explicitly state which runtime contexts will be used for certain operations. A single thread can therefore use one or more runtime contexts.