Abstract: System, methods and articles of manufacture for optimizing a query plan reuse in a database server system accessible by a plurality of client connections. An embodiment comprises providing at least one global cache storage and a private cache storage to a plurality of client connections, and coordinating utilization of the at least one global cache storage and the private cache storage to share light weight stored procedures and query plans for prepared SQL statements across the plurality of client connections via the at least one global cache storage while avoiding a spinlock access for executing the prepared SQL statements.

Abstract: Systems, methods and articles of manufacture for accelerating database queries containing bitmap-based conditions are described herein. An embodiment includes determining a bitmap, where the bitmap represents a set of rows that have satisfied one or more conjunctive conditions which preceded a conjunct that is a disjunction in a query expression and restricting evaluation of a disjunct within the disjunction to the set of rows represented by the bitmap. Another embodiment includes determining a satisfaction bitmap, where the bitmap represents the result of one or more preceding disjuncts in a disjunction within a query expression and restricting scope of evaluation of a disjunct to a set of rows that are not within the determined satisfaction bitmap. In this way, embodiments of the present invention enable the acceleration of queries containing disjunctions of conditions on a database table, as well as reduce the temporary resources consumed for such queries.

Abstract: An intelligent routeback mechanism that may inter alia receive from an entity (such as for example a wireless carrier) aspects of the entity's messaging traffic, data, etc. with the intelligent routeback mechanism aiding the (1) return (optionally augmented, optionally transformed, etc.) to the entity of that portion of the traffic, data, etc. that the entity is able to deliver itself and (2) delivery of that portion of the traffic, data, etc. that the entity is unable to deliver itself. Such an intelligent routeback mechanism may reside in inter alia a Messaging Inter-Carrier Vendor.

Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for incremental data transfer in a database management system (DBMS) are provided. In an embodiment, a database table enabled for partial export from a database management system is identified. Data within the database table to be exported is also identified, and the identified data is transferred in a chosen format from the database table to an export location.

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: A user feedback generation and management capability, operating possibly within a Value-Added Service Provider, provides key feedback (e.g., information, updates, etc.) to a Mobile Subscriber (MS) during, for example, the MS? receipt of rich content on the MS? Wireless Device (WD). The feedback may be conveyed to a MS? WD through, possibly inter alia, one or more Short Message Service messages. Such feedback may, possibly inter alia, provide details as to why certain content might not be received, suggest one or more alternative content delivery means, etc. and thus serve to obviate what would otherwise be (1) a frustrating, disappointing, etc. user experience for the MS and (2) increased customer service costs for the different content and service providers.

Abstract: A subscription manager module or message processing engine operating within a messaging inter-carrier vendor (MICV) provides value added services to both service users (e.g., mobile telephone users) and service providers (e.g., information brokers, vendors, news sources, etc.). The MICV is disposed between a plurality of service users and a plurality of service providers and messages sent between these parties are processed by a subscription manager module, or message processing engine, which is configured to, among other things, manage short codes, detect undesirable spam messages, operate service user opt-in and opt-out processes, and perform billing functions.

Abstract: A method for detecting an undesirable condition within a messaging network. A message is received and a source of the message is identified. If an entry in a database for the source has not been created, an entry is created. A source counter for the source is then set to one and a timestamp is created for the source. If an entry in the database for the source has been previously created, the source counter is incremented by one and the timestamp is updated. The source counter is then compared to a source threshold, and if the source counter exceeds the source threshold over the course of predetermined amount of time, a source alarm is triggered. A sliding with respect to the predetermined amount of time may also be implemented to account for total counts that may fall across or be split by set periods of time. The invention is particularly useful for detecting “spam” events and undesirable routing loops.

Abstract: A system and methodology for parallel query optimization using semantic-based partitioning is described. In one embodiment, for example, in a database system comprising a database storing data in database tables, a method is described for improving query performance by dynamically partitioning the data, the method comprises steps of: receiving a query requesting data from the database; generating a plurality of subplans for executing the query, each subplan including one or more operators for performing relational operations; adding operators for partitioning data and performing a given relational operation in parallel to at least some of the plurality of subplans; and building a plan for execution of the query based, at least in part, upon selecting subplans having favorable execution costs.

Abstract: A system and methodology for real-time content aggregation and syndication is described. In one embodiment, for example, a method is described for assisting a user with extracting items relevant to search queries from documents including items of various types, the method comprises steps of: receiving a search query specifying a search phrase and a particular item type; identifying documents matching the search phrase; for each matching document, determining whether the document includes an item having the particular item type; and extracting items having the particular item type from the matching documents for display to the user. The solution enables a user to aggregate and syndicate content without a professional content manager or complicated content management software tools.

Abstract: A system providing improved methods for data replication is described. A method for replicating a transaction from a primary database to a replicate database while the replicate database remains available for use comprises: recording information about a transaction being performed at a primary database in a transaction log; synchronously copying the information about the transaction in the transaction log to a mirrored transaction log; generating a reconstructed transaction based on the information about the transaction copied to the mirrored transaction log; and applying the reconstructed transaction at the replicate database while the replicate database remains available for use.

Abstract: Enhanced interoperability (e.g., connectivity, communication, processing, routing, billing, etc.) capabilities are provided through an IP eXchange (IPX) facility that among other things may offer a simple, consolidated, etc. interface mechanism and which may leverage various pools of data to expeditiously process and route a quanta of data (including conventional SMS, MMS, etc. messaging; VoIP and other audio/video data streams; SIP-addressed artifacts; signaling data; voice call data; application data; etc.).

Abstract: A method and system for providing message-based interactive services includes receiving a short code message from a mobile subscriber relating to a service desired by the mobile subscriber from an interactive service device, routing the short code message for processing, and instructing the interactive service device to operate in accordance with the short code message.

Abstract: Embodiments relate to a computer-implemented method for graphically displaying or presenting a fisheye-based view of a large data list on the limited content viewing area of a mobile device. At least a subset of data rows within the data list and graphical representations of a plurality of data fields of at least the subset of data rows are generated and graphically displayed using a graphical user interface of the mobile device. When a user selects a focus row from the displayed data rows, a fisheye-based view of the selected focus row is presented. The fisheye-based view and the graphical representations of the data fields provide the user with a focus-plus-context view of a large data list. Further, the graphical representations provide the user with meaningful information even when particular data items are too small to read specific values.

Abstract: A system, method, and computer program product are provided for facilitating interaction between front-end mobile business objects and back-end enterprise information system data. The approaches described reduce the need for client-visible parameters needed by the enterprise information system, but that can be handled without being directly supplied by a developed of a client application on a mobile device interacting with the enterprise information system via a synchronization server.

Abstract: A system, method, and computer program product for forming and transmitting a TCP/SMS message are presented. Steps for forming a TCP message, encoding the TCP message, and wrapping the TCP message in an SMS message are disclosed.

Abstract: Embodiments relate to a computer-implemented method for visualizing expressions for dynamic analytics. A graphical user interface control is generated for each of one or more variables of an expression. Each of the one or more variables is bound to the corresponding graphical interface control generated previously. Then, the generated graphical user interface control for each of the one or more variables of the expression is graphically output using a display device. A user may input an adjusted value of each of the one or more variables of the expression using the corresponding graphical user interface control.

Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for reducing contention of transaction logging in a database management system (DBMS) are provided. An embodiment includes creating a dependency relationship among private log caches (PLCs) having individual associations with tasks in a DBMS. The dependency relationship is utilized to control buffer pinning and unpinning among the PLCs without involving a flushing of the PLCs during transactions of the tasks.

Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for moving a project in a complex event processing cluster are provided. In an embodiment, project movement in a complex event processing cluster initiates once project persistence capability exists. A handoff of the project from a source node to a destination node in the complex event processing cluster is coordinated by a manager without losing messages and without relying on a message guarantee delivery protocol.

Abstract: Leveraging the ubiquitous nature of Wireless Devices (WDs), the popularity of different messaging paradigms, and the advantageous response rate that is associated with messaging-based advertising, an infrastructure that augments messages with advertising in dynamic, intelligent, etc. ways (based on various constraints including for example the body of a message, characteristics of a Mobile Subscriber [MS], the current physical location of a MS' WD, a particular advertising campaign's characteristics, etc.). The infrastructure may optionally leverage the capabilities of a centrally-located Messaging Inter-Carrier Vendor.