Abstract: A system, method, and computer program product are provided for interfacing a user device to a transaction system. An interface is provided in order to call a function on the transaction system for performing the transaction.

Abstract: A system, method, and computer program product are provided for replicating a table in a source database to a target database. In accordance with an embodiment of the present invention, a subscription to the table is defined and a query is executed on the source database. The query is then normalized, and it is determined whether the query would cause semantically appropriate changes to the target database. If so, the normalized query is sent to the target database for execution, in accordance with an additional embodiment of the present invention.

Abstract: A system, method, and computer program product are provided for developing a portable software application. The method includes the steps of defining a project, adding a screen to the project, the screen being defined as a generic screen or a platform-specific screen, adding a component to the screen, the component being defined as a generic component or a platform-specific component, redefining the screen as a platform-specific screen when it is defined as a generic screen and one or more platform-specific components have been added to the screen, and defining an application flow from the screen to one or more additional screens.

Abstract: A system, method, and computer program product are provided for compiling a stored procedure in a database. The compiling includes the steps of invoking the stored procedure, the stored procedure comprising one or more statements, substituting run-time values for one or more variables in the statements, and creating an access plan for the statements having the substituted run-time values.

Abstract: A system, method, and computer program product are provided for performing a join operation between a local table at a local server and a remote table at a remote server. In accordance with an embodiment of the present invention, a query instruction to join the local table and the remote table is received at the remote server. Qualifying rows of the local table are then retrieved to the remote server, and the remote table is joined with the qualifying rows to generate a result table, which is then sent to the local server.

Abstract: Methods, systems, and computer program products for dynamically monitoring, processing, and managing alerts are described herein. In an embodiment, the method operates by receiving messages that are either alerts or responses to existing alerts. The messages are parsed to determine if whether they are alerts or responses to alerts. Actions including updating alert states and storing alert data are executed, and then the method sends notifications regarding the alert messages and responses to a collaboration list of registered subscribers that dynamically expands over time based upon alert escalations. The method then determines whether additional messages have been received; and performs actions associated with these additional messages until there are no remaining alerts or alert responses to process. The method stores updated alert and response data in a repository so that the alerts and responses can be monitored and managed.

Abstract: A system, method, and computer program product for improving physical lock acquisition for database transaction logs are described herein. In an embodiment, the method operates by receiving a request for a transaction log page and determining whether a requested log page is newly-allocated or already exists. A determination is made regarding whether the last log page is being modified. A physical lock is taken on the requested log page when it has been determined that the requested log page is not newly-allocated and that the last log page is not being modified. Operations on the last log page are synchronized without a physical lock when it is determined that the requested log page is newly-allocated or that the last log page is being modified.

Abstract: Replication system with methodology for replicating database sequences is described. In one embodiment, for example, in a database system, a method of the present invention is described for replicating a sequence object from a primary database to a replicate database, the method comprises steps of: monitoring changes to table data at the primary database for capturing information sufficiently characterizing the sequence object to allow its replication, the table data being logged to a log file; reading the log file, for determining changes to apply to the replicate database for replicating the sequence object; and reconstructing the sequence object at the replicate database based on the determined changes.

Abstract: A database system with methodology for parallel schedule generation in a query optimizer is described. In one embodiment, for example, in a database system, a method is described for parallel optimization of a query, the method comprises steps of: generating a plurality of parallel plans for obtaining data requested by the query, the parallel plans including parallel operators for executing portions of the query in parallel; adjusting parallel operators of each parallel plan if necessary based on resources available for executing the query; creating a schedule for each parallel plan indicating a sequence for execution of operators of each parallel plan; determining execution cost of each parallel plan based on its schedule; and selecting a particular parallel plan having lowest execution cost for obtaining data requested by the query.

Abstract: Roughly described, a context reactive user interface which offers user-selectable on-screen choices or hints to help the user follow up in the context of his or her previous interactions. Alternatively or additionally, the system can offer on-screen choices which, when selected by the user, can invoke one or more back-end applications with entry fields pre-filled from the user's previous interactions or from other contextual information.

Abstract: Roughly described, a natural language interpretation system develops its interpretation in response to user input, and also in dependence upon the interpretation, rather than the claims, made in response to prior input. In policy conditions, an agent can check whether any specified agent contributed to the prior interpretation and adjust its claiming of the present input accordingly. In policy actions, a policy or agent can reference the prior interpretation both for conditioning the policy's or agent's contribution to the current interpretation, and also for incorporating part or all of the prior interpretation in the policy's or agent's contribution to the current interpretation. The resulting system thus implements dialoging in a distributed manner as part of the various agents in the interpretation network, and allows much more flexibility to better respond in accordance with users' expectations.

Abstract: Roughly described, a context reactive user interface which offers user-selectable on-screen choices or hints to help the user follow up in the context of his or her previous interactions. Alternatively or additionally, the system can offer on-screen choices which, when selected by the user, can invoke one or more back-end applications with entry fields pre-filled from the user's previous interactions or from other contextual information.

Abstract: A system, method, and computer program product are provided for optimizing LIKE-condition based queries on a table in a database system.

Abstract: A system, method, and computer program product are provided for optimizing a range-based query on a table in a database system.

Abstract: A method, computer program product, and system are provided for accelerating a query in a database system. For example, an embodiment of the method may include generating a data structure identifying a set of rows that satisfy conditions local to a table prior to an evaluation of a query and modifying the query based on the data structure. In addition, the method may include repeating the steps with respect to generating the data structure and modifying the query, if one or more additional local conditions are inferred from modifying the query based on the data structure. With respect to the step of modifying the query based on the data structure, in the case where no rows satisfy the local conditions in the data structure, an always false prefilter condition may be migrated as high as possible within the query. When only one row satisfies the local conditions in the data structure, a column may be replaced by a constant value from within that column in that one row.

Abstract: Systems, methods for computer program products for securely storing data in a data store or in an external data store associated with a mobile device are described herein. Data that is being sent from an application module to a data store, on the mobile device or an external data store used by the mobile device is first encrypted by a security manager. The security manager encrypts data based on an encryption algorithm that may be selected by a user. Data received from an application module is thus stored in an encrypted form on a data store. When an application requests data from the data store, the security manager decrypts the data and provides the data to the application module in its decrypted form. All data that is transmitted to or received from a data store or an external data store is intercepted by the security manager for encryption and decryption respectively.

Abstract: Methods, systems, and computer program products to secure data stored on mobile client devices are provided. In an embodiment, the method operates by defining one or more security policies. Each security policy comprises a plurality of security policy parameters. The method stores the security policies in a data store, and selects a security policy from among the stored security policies for a mobile client device. The selected security policy is applied to the mobile client device. The mobile client device determines whether it is compliance with parameters of said selected security policy, and performs data fade actions if it is determined that it is out of compliance with said security policy parameters.

Abstract: Methods, systems, and computer program products for monitoring, aggregating, and correlating business events in real time and acting on the results with near zero latency, wherein each event is processed in the first order relative to the event density, are described herein. In an embodiment, the method operates by receiving historical values comprising keys and data fields at an analytic model. Rules associated with actions are applied to the historical values. Actions including updating data are executed pursuant to the rules, and then the method determines whether additional rules are to be applied; and performs actions associated with these additional rules until there are no remaining rules to apply. The method stores updated data in a database.

Abstract: System and methodology for automatic tuning of database query optimizer is described.

Abstract: A system, method, and computer program product are provided for synchronizing a local database with a remote database. Additionally, a system, method, and computer program product are provided for performing a service operation on a database, the database located on a database system.