Abstract: Given the growing number of Wireless Devices, and the increasingly varied characteristics (including for example screen size, color depth support, audio and video support, etc.) that Wireless Device vendors or manufacturers provide within their Wireless Devices, an infrastructure that various entities (such as for example Content Providers, Service Providers, etc.) may use to quickly retrieve a quality-controlled User Agent Profile based just on a Wireless Device's Telephone Number. The infrastructure may optionally leverage the capabilities of a centrally-located Messaging Inter-Carrier Vendor.

Abstract: Coincident with the evolution, maturation, etc. of wireless messaging ecosystems, today and in the future the addressing of a message needs to include—and all of the different entities that process messages (e.g., Wireless Carriers, intermediaries, enterprises, Content Providers, Service Providers, etc.) need to support—additional (i.e., enhanced, flexible, extensible, etc.) message addressing capabilities. The present invention provides an infrastructure that supports such additional (i.e., enhanced, flexible, extensible, etc.) message addressing capabilities through, among other things, the availability of Dynamic Tags (DynaTags). The infrastructure may optionally leverage the capabilities of a centrally-located Messaging Inter-Carrier Vendor.

Abstract: A system, method, and computer program product are provided for improving performance of positional text conditions in concert with bitmap-based conditions. This is accomplished, for example, by focusing positional text condition evaluation to candidate rows based on a bitmap resulting from application of a prior condition. Additionally, the result of a positional text condition may itself be provided in the form of a bitmap to accelerate further bitmap-based condition processing.

Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for a distributed data cache database architecture are provided. An embodiment includes providing a scalable distribution of in-memory database (IMDB) system nodes organized as one or more data fabrics. Further included is providing a plurality of data granularity types for storing data within the one or more data fabrics. Database executions are managed via the one or more data fabrics for a plurality of applications compatible with at least one data granularity type.

Abstract: A system, method, and computer program product are provided for efficiently fetching and displaying large datasets on mobile devices, such as devices running the iPhone™ operating system. The method fetches data for a mobile device from a server and displays a plurality of data rows in a ListView within a user interface on the mobile device. The method stores primary keys on the mobile device until their corresponding data rows are to be displayed. The method reacts to user inputs such as scrolling actions and touch screen gestures to efficiently fetch and display list view subsets of large datasets. The method facilitates quick response times when navigating through large lists of data on a mobile device by: fetching displayable or visible rows of data in a data list view, preloading the visible rows on the mobile device; and binding the visible rows to user interface elements on the mobile device.

Abstract: A system and method to generate an improved layout of a data grid in a database environment is provided. The data grid is a clustered in-memory database cache comprising one or more data fabrics, where each data fabric includes multiple in-memory database cache nodes. A data grid advisor capability can be used by application developers and database administrators to evaluate and design the data grid layout so as to optimize performance based on resource constraints and the needs of particular database applications.

Abstract: Systems and methods for non-disruptive cache startup, shutdown, data partition movement, and node rebalancing for a data fabric within a data grid in a database environment. The data grid is a clustered in-memory database (IMDB) cache comprising one or more data fabrics including multiple IMDB cache nodes. The method takes a time tag and moves data from source to destination nodes while allowing updates to data on the source nodes. The method propagates updates occurring after the time tag to destination nodes from source nodes and switches applications and ownership to the destination nodes. Another method slices data for a partitioned fabric and stores slices on nodes. Another method starts a data fabric by moving data from a grid backend to the nodes. In an embodiment, another method rebalances nodes in a non-disruptive manner. When a fabric is shutdown, the method saves data from the nodes to the grid backend.

Abstract: A system, method, and computer program product are provided for handling bulk initial downloads of databases to mobile devices. Rather than straining the resources of a mobile device to recreate the database locally, a server can construct the database to the mobile device's requirements at the server by impersonating the mobile device. The server can then send the database, compressed and over an encrypted session, to the mobile device. The mobile device can then decrypt and uncompress the pages received, and then encrypt them using a local key for secure storage on a local storage device.

Abstract: Embodiments include a method, apparatus and computer program product for providing instructions from a database client to a database server. The method includes the steps of receiving from a database a representation of a first instruction and an associated identifier. The representation of the first instruction and the associated identifier are stored in a cache. A second instruction, from an application, is matched with the representation of the first instruction stored in the cache. The associated identifier is retrieved from the cache based on the matching and the associated identifier is sent to the database server. Upon receipt of the associated identifier, the database server executes the first instruction.

Abstract: A system, method, and computer program product are provided for implementing materialized views on a mobile device in synchronization with an enterprise information system. Changes to an underlying local database, on which the materialized view is based, may originate from the enterprise system or from the client. A solution needs to account for each of these potential sources of changes, and update the materialized view accordingly.

Abstract: Systems, methods and computer program products for inherently integrating mobility with an enterprise are described herein. Enterprise data is accessed from one or more data sources, wherein such data sources may comprise structured and unstructured data sources. The data is transferred from the enterprise to a plurality of mobile devices over a plurality of diverse networks. In an embodiment, such transfer takes into consideration characteristics of the diverse networks. The enterprise receives data generated by mobile devices while performing enterprise-related operations at the wireless edge. The enterprise responds to environmental changes using the received data.

Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for replication resynchronization are provided. An embodiment includes providing a mode of operation in a replication control system for repopulating a replicated version of a primary database that does not affect an ability to continue activity in the primary database. Further included is managing the repopulating of the replicated version with attention to at least a resynchronization marker.

Abstract: Systems, methods, and computer program products are provided for ensuring coherency between user data in a client and their corresponding state in enterprise information systems (EIS) wherein data migrates and subscriptions change over time. A mobile business object (MBO) identifies an update to a subscription or a change in set membership in order to provide updates to a client device and EIS systems. Cached data is filtered for client device users who synchronize data they are interested in (i.e., subscribed to). In an embodiment, the method keeps track of set membership by remembering on a per remote identifier/business object basis the set membership for a parent business object. When set membership changes, the method sends delete notifications to the device to remove ex-members. The method recognizes common relationship types in a business scenario and handles reference-type relationships as well as containment-type relationships. The methods include key tracking and membership tracking.

Abstract: Systems, methods, computer program product embodiments for deferred reading of email databases are described herein. An embodiment includes an event listener configured to poll (or query) the email server and selectively read an email database associated with the email server. Such a selective database read operation is based on the priority of an event occurring in the email server. If events of a low priority occur, the event listener does not open the email database immediately to retrieve additional information related to the low priority event but defers reading the email database by a pre-determined amount of time. If a higher priority event occurs, the email database is immediately read to retrieve details related to the high priority event from the mail server database. In another embodiment, event listener reads the email database based on when event timestamp information is updated by the email server.

Abstract: A method and system for providing message-based access to services includes receiving a request message from a mobile subscriber relating to a service that is desired by the mobile subscriber, routing the request message for processing, performing one or more activities in accordance with the requested service, returning a response message to the mobile subscriber, and facilitating/enabling/etc. access to the requested service.

Abstract: System, methods and articles of manufacture for joining data in the database tables comprising, performing an index scan on a global index of a first database table, determining rows in the first database table that may be joined with a second database table based on a needed partitioning, wherein the needed partitioning is determined using an index scan, determining a number of partitions in the second database table, and joining each of the corresponding partitions in the first database table with a corresponding partitions in the second database table.

Abstract: Ranking database query results using an efficient method for N-ary summation is provided. Such operation, referred to herein as “mid-fold N-ary summation” significantly reduces costs of computation for large numbers of queries, as are common in enterprise database applications. Thus, ranking query results using mid-fold N-ary summation offers improved runtime performance and reduced latency relative to using conventional N-ary summation.

Abstract: Coincident with the evolution, maturation, etc. of wireless messaging ecosystems an infrastructure that supports offering to mobile subscribers different types of rewards (for example, possibly inter alia, cash, free service offerings, product coupons and/or discounts, popularity indicators, etc.) for specific mobile subscriber behaviors including, possibly inter alia, a mobile subscribers' creation and sending of increasing numbers of certain types of messages. The infrastructure may optionally leverage the capabilities of a centrally-located Messaging Inter-Carrier Vendor.

Abstract: An intermediary infrastructure that facilitates the interconnection of multiple IP Multimedia Subsystem (IMS) networks. The interconnections may span one or more of the IMS logical planes Services Plane, Control Plane, and Network or Transport Plane. The intermediary offers among other things a process, routing, and switching complex that is able to among other things process incoming messages including using a comprehensive routing repository to complete message routing operations.

Abstract: System and methods for temporary data management in shared disk cluster configurations is described. In one embodiment, a method for managing temporary data storage comprises: creating a global temporary database accessible to all nodes of the cluster on shared storage; creating a local temporary database accessible to only a single node (owner node) of the cluster; providing failure recovery for the global temporary database without providing failure recovery for the local temporary database, so that changes to the global temporary database are transactionally recovered upon failure of a node; binding an application or database login to the local temporary database on the owner node for providing the application with local temporary storage when connected to the owner node; and storing temporary data used by the application or database login in the local temporary database without requiring use of write ahead logging for transactional recovery of the temporary data.