Abstract: Methods, systems, and computer program products are provided to efficiently allocate extremely large storage spaces for use by dynamic hash tables. A contiguous storage space is designated from which dynamic hash tables can be created. These dynamic hash tables benefit from rapid allocation by being able to reserve many allocation units (each potentially comprising a large number of pages, e.g., 256 pages) within a short span of time, rather than resorting to reserving individual pages. The efficiency from allocation and the contiguous space significantly improves performance for databases in the 50 GB-100 GB size range.

Abstract: System, methods and computer-readable mediums for generating a visual representation of a continuous computation language (CCL) document. The CCL document includes one or more CCL statements. For each CCL statement, a text-to-visual mapping module converts each CCL statements to visual objects as a representation of instruction logic of the CCL document graphically on a display device.

Abstract: A method and system for facilitating HLR access includes receiving a query request from a query entity, processing the query request to yield an SS7 request message, dispatching the SS7 request message to a HLR, receiving an SS7 response message from the HLR, constructing a query response, and returning the query response to the query entity.

Abstract: A computer software language capable of expressing registered queries that operate on one more or more data streams continuously. The language of the present invention is based on a publish/subscribe model in that queries subscribe to data streams and publish to data streams. Also, the language of the present invention can express queries that operate directly on data streams. Since queries expressed in the language of the present invention may be executed continuously and directly on data streams, the language includes a clause for specifying time-based and/or row-based windows for the input data stream. Operations are then performed on the data within such windows. In one embodiment, the language is also SQL-like and includes a clause for defining named windows (which can be used in any number of queries); a clause for detecting a pattern, and correlated database subqueries for correlating data stream data with database tables.

Abstract: Coincident with the evolution, maturation, etc. of (e.g., Short Message Service, Multimedia Message Service, IP Multimedia Subsystem, etc.) wireless messaging ecosystems an infrastructure that provides, in new and creative ways, enhanced message routing capabilities. The dynamic, flexible, and extensible nature of the enhanced message routing capabilities support, among other things, very large volumes of messaging traffic, numerous billing paradigms, different Quality of Service levels and possible charges for same, improved troubleshooting and problem investigation capabilities, etc. The infrastructure may optionally leverage the capabilities of a centrally-located Messaging Inter-Carrier Vendor.

Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for adaptive locking of retained resources in a distributed database processing environment are provided. An embodiment includes identifying a locking priority for at least a portion of a buffer pool, determining lock requests based upon the identified locking priority, and granting locks for the lock requests.

Abstract: System, method and computer program product for modeling and code generation for SQL-based data transformations. A selection, by a user, of a component to include in a visual representation of a data transformation model (DTM) is received. Logic corresponding to the selected component is arranged in the DTM, wherein the selected component and the logic are compatible with a plurality of implementations of SQL. SQL code corresponding to the logic is generated, wherein the generated SQL code is specific to a selected one of the plurality of SQL implementations. Responsive to the selection, the generated SQL code is provided for rendering in association with the visual representation of the DTM including the selected component.

Abstract: Systems, methods and computer program products for multicast database replication are described herein. An embodiment includes creating a replication group for replication of data. One or more replicate (or target) databases are subscribed to the replication group and the replication group may include one or more subscribed replicate databases. The replication group is associated with a replication group address. Embodiments send (or publish) data that is to be replicated to the replication group multicast address causing automatic replication of the data to the subscribed replicate databases. In this way, by sending data to be replicated once to a replication group address, the data is automatically replicated to several subscribed replicate databases and a replication server need not establish distinct point-to-point connections with each replicate database.

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: As individuals increasingly engage in different types of transactions they face a growing threat from, possibly among other things, identity theft, financial fraud, information misuse, etc. and the serious consequences or repercussions of same. Leveraging the ubiquitous nature of wireless devices and the popularity of (Short Message Service, Multimedia Message Service, etc.) messaging, an infrastructure that enhances the security of the different types of transactions within which a wireless device user may participate through a Second Factor Authentication facility. The infrastructure may optionally leverage the capabilities of a centrally-located Messaging Inter-Carrier Vendor.

Abstract: Systems, methods and computer program products for maintaining data integrity in a database environment are described. In operation, a synchronization process is initiated in a remote database system for synchronization of remote data from the remote database system with consolidated data of a consolidated database. Metadata for each row of the remote data is utilized to allow transactional access to the remote data while the synchronization process occurs.

Abstract: Systems and methods for assigning short codes to provide uniformity among wireless carriers. In the systems and methods, a Universal Short Code (USC) Administrator maintains a list of short codes and their lease status so that SMS messages sent to a particular short code may be routed to the proper holder of the short code. A network facilitator is in communication with both the USC Administrator and at least one wireless carrier to route the SMS message to the proper holder of the short code. The short code may be leased for a specified period of time so that the short code can be reassigned after expiration of the lease.

Abstract: A method for exchanging data concerning an electronic transaction between two entities, includes: a step which consists in determining and booking an origin address (TPOA) in conformity with a bidirectional mobile telephony (GSM) digital messaging service protocol (SMS); a step which consists in sending in accordance with the protocol (SMS), an offer message (OFFER_SMS) of the transaction (TR), the offer message (OFFER_SMS) being sent from the first entity (MW) and addressed to the second entity (CL); and a step which consists in sending, from the second entity (CL) and addressed to the first entity (MW), a reply message comprising an information (REP) representing acceptance or rejection of the transaction.

Abstract: An information messaging and collaboration system is described. In one embodiment, for example, a method is described for interactive content retrieval and display, the method comprises steps of: providing a plurality of portlets for retrieval of content for display in a user interface; mapping a message action to a first portlet to create a messaging portlet for sending a message in response to user interaction with the messaging portlet; creating a listener portlet by registering a second portlet to receive messages from the messaging portlet; and in response to user interaction with the messaging portlet, retrieving particular content for display in the user interface based on the message received by the listener portlet from the messaging portlet.

Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof are provided for optimizing data storage and access of an in-memory database in a database management system. Embodiments include utilizing in-memory storage for hosting an entire database, and storing objects of the database individually in separate portions of the in-memory storage, wherein a portion size is based upon an object element size.

Abstract: A method, system and computer readable storage medium for replicating structured data stored in a database. The method includes identifying the stored structured data, mapping the data to an unstructured data type, and sending the mapped data to one or more replicate databases as unstructured data.

Abstract: System, method and articles of manufacture for filtering a data definition language (DDL) command. The method includes providing a filtering function with one or more rules for filtering the DDL command. The method further includes receiving the DDL command for replication. The method also includes filtering the DDL command from replication based on the one or more rules.

Abstract: A method, system and computer readable storage medium for replicating procedures with unsupported table data type arguments such as Boolean arguments. The method includes identifying the argument of an unsupported table data type in a procedure to be replicated, mapping the argument to an equivalent supported value, and creating a table containing a column representing the argument as the supported table data type and sending data corresponding to the unsupported table data type argument to a replication server.

Abstract: Systems, methods and computer program product embodiments for auto-correction in database replication are disclosed herein. An embodiment includes receiving a log record of one or more database row changes on a table marked for replication. From the received log record, one or more insert operations on the marked table are identified. Each identified insert operation is automatically replaced with a first pair of operations, where each first pair comprises a delete operation associated with a new insert operation. Each first pair, when executed at a replicate database, acts to delete data at a first location identified by each identified insert operation prior to inserting data of the new insert operation at the first location.

Abstract: A system, method, and computer program product are provided for sorting a set of records in a sort run. As the records are sorted, metadata regarding the sort run is gathered, and subsequently used to determine bounds of two or more disjoint subsets of the sort run. This enables the parallelization of several tasks over the sort run data using efficient, dynamic bounds determination, such as the outputting of sorted data from the disjoint subsets in parallel.