Abstract: System, methods and articles of manufacture for replicating relational data on multiple nodes. An embodiment comprises receiving an update request message from a node, wherein the update request message comprises a node identification and an application identification, accessing an application schema based on the application identification, identifying a partition residing in the application schema based on the node identification, accessing a server schema, identifying a second partition residing in the server schema based on the application identification, determining at least one data change stored in the second partition that changes data associated with the first partition, retrieving at least one data change from the second partition, formatting data change in an update response message, and transmitting the update response message to the node.

Abstract: A system, method, and computer program product for synchronizing events between a mobile device and a server are described herein. In an embodiment, the method operates by detecting events to be synchronized between a source and a target, wherein the source and target are one of either a mobile device or a server. The method comprises deducing activities that occurred in order to create the detected event, reading data records corresponding to the deduced activities, and creating packets of operations needed to recreate the deduced activities on the target. The method further comprises queuing the packets of operations and data records and receiving event synchronization results at the source after the queued packets of operations have successfully executed on the target, wherein the synchronization results include a synchronization status and a unique record identifier identifying the event. In an embodiment, personal information manager (PIM) events are synchronized.

Abstract: Systems, methods, and computer program products are provided for synchronizing device settings at a mobile device with settings held at a database in a synchronization server. This settings exchange mechanism is further extended to provide versioning information used in an auto upgrade process, in which the synchronization server is configured to push updates to the mobile device. Additional systems, methods, and computer program products are provided for configuring logging preferences on the mobile device from a server, and further for silently retrieving logs generated on the mobile device to the server.

Abstract: Systems, methods and computer program products for tracking objects in an area of interest are described. According to an embodiment, an object is tracked as follows. First position information relating to the object is received from a first sensor and translated to a coordinate system of a map. The object is displayed on the map in accordance with the translated first position information. Second position information relating to the object is received from a second sensor, where the second sensor is based on a second positioning technology different from the first positioning technology. The second position information is translated to the coordinate system of the map, and the object is displayed on the map in accordance with the translated second position information. In an embodiment, other information relating to the object is also received from sensors.

Abstract: Systems, methods and computer program products for assigning tasks to threads in a server process, where many threads require access to limited resources, are described herein. The system includes one or more programmable queues. Enqueued in each queue are a plurality tuples that correspond to tasks. The invention attempts to match the tuples with command processing resources and database command resources, as needed and available. Once a tuple is fully populated, the tuple is dequeued and assigned to a thread for processing. After processing of the tuple is complete, its command processing resource and any database command resource are enqueued to make them available to other tuples.

Abstract: Systems, methods and computer program products for enabling enforcement of an administrative policy on one or more mobile devices are described herein. In an embodiment, an administrator uses a policy server to create and provide an enforcement policy to a mobile device. An enforcement policy may include information on mobile device resources which may be controlled by an administrator. An enforcement policy also includes information on how mobile device features will be set, configured or disabled. An enforcement device driver and an enforcement monitor on a mobile device use the enforcement policy to control access to resources associated with the mobile device regardless of whether the mobile device is “online” and connected to a network or “offline” and disconnected from a network.

Abstract: Approaches for indexing and retrieving spatial data with a quadtree index in database management systems are described. In an embodiment, data objects are stored without decomposition within a linearized quadtree stored within a B-tree index. In another embodiment, a method determines an optimal execution plan for a spatial query by parsing it to determine a query type and geometry object associated with the query. The method tessellates the query object by recursively decomposing the quadtree blocks that cover it. Cost-based decomposition decisions are made by consulting a cost model furnished by the database management system to minimize the cost of the resulting index range plan on the B-tree storage. Thus, data-directed query decomposition enacted by the method results in the optimal cost index range plan for the current data distribution and system context. In another embodiment, a system identifies and displays an optimal index range plan in a user interface.

Abstract: Systems, methods and computer program products for determining a schedule for synchronizing a server and a client are described herein. The method operates by tracking user usage of the client to develop usage patterns. A sync schedule is generated using the usage patterns, where the sync schedule enhances at least one of sync usefulness and sync transparency. The server and client are synchronized according to the sync schedule. More particularly, a sync fitness measure for an interval t is determined. The sync fitness measure is based on at least one of (a) sync transparency; and (b) sync usefulness. It is determined whether the sync fitness measure satisfies a threshold. If the sync fitness measure satisfies the threshold, then the server and client are synchronized during interval t.

Abstract: A computer-implemented method for updating an object on a mobile device is provided. The computer-implemented method includes maintaining at a server a plurality of channels, the plurality of channels including at least a first representation of the object, generating a modification event when a change to the object is detected, responsive to the modification event, at least updating the representation of the object yielding a second representation of the object, and conveying, during a synchronization process, the second representation of the object to the mobile device.

Abstract: A relay server is located outside a firewall and provides access to a server inside the firewall. Both the server and a client (the client is outside the firewall) initiate a connection with the relay server. The relay server then sets up a connection between the server and client, to thereby enable the server and client to communicate. Such communication is enabled without needing an inbound port in the firewall, thereby enhancing security.

Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for controlling lifetimes of server add-ins are described herein. Embodiments of the invention enable a service module, located at a first server, to externally control lifetime of one or more process add-ins located at a second server. An embodiment includes instantiating the service module at the first server and instantiating, using the service module, a controller add-in at the second server. The service module can instantiate the controller add-in to control the lifetime of (i.e. instantiate or terminate) process add-ins at the second server. In an embodiment, such lifetime control can be performed without shutting down the second server or other operations running on the second server.

Abstract: Described herein are systems, methods, computer program products, and combinations and sub-combinations thereof, for enabling web content (as well as other objects) to be loaded on mobile devices (as well as other types of devices), and for users of mobile devices to operate with such web content on their mobile devices in an interactive manner while in an off-line mode.

Abstract: A system, computer-implemented method, and computer-program product embodiments for generating an access plan. A query optimizer includes an enumeration method which enumerates a plurality of subsets of a query. Each subset in the query has a plurality of partitions. The partitions of each subset are enumerated into enumerated partitions using at least one thread. For each partition, physical access plans are generated, using at least one thread. Physical access plans are generated in parallel with other physical access plans of different partitions and with other enumerating partitions. The number of threads that perform the enumeration and the generation is dynamically adapted according to a pool of threads available during the enumeration of the partitions and the generation of physical access plans, and a complexity of the query. From the generated physical access plans, a final access plan for the query is determined by choosing the most efficient access plan.

Abstract: Systems, methods and articles of manufacture for determining at least one algorithm from a pool of algorithms to optimize a query. An embodiment includes building optimization blocks for the subplan, determining the complexity of the subplan based on the optimization blocks and selecting an algorithm from a pool of search space generation algorithms based on complexity of the subplan and characteristics of the selected algorithm, and optimizing the subplan with the selected algorithm.

Abstract: Systems, methods and computer program products for the centralized control of radio frequency identification (RFID) readers are described herein. An input event control embodiment operates by receiving a signal from a non-RFID input device and commanding an RFID reader associated with the non-RFID input device to begin reading. According to an alternative time coordination embodiment, non-overlapping time slots are assigned to a plurality of RFID readers, and the RFID readers read only during their respective non-overlapping time slots. According to an alternative combined input event control/time coordination embodiment, non-overlapping time slots are assigned to a plurality of RFID readers. A signal from a non-RFID input device is received, and an RFID reader associated with the non-RFID input device is commanded to begin reading. However, such RFID reader only begins to read at the beginning of its next assigned time slot.

Abstract: A system, method, and computer program product are provided for enabling the selective updating of web pages provided to a mobile client using, for example, AJAX technology. The system, method, and computer program product are optionally further extended to harmonize synchronization of data retrieved by other methods with data updated using AJAX. The use of AJAX technology is disclosed within the context of additional technology suites which may be substituted to achieve the same function. Additionally, the use of queuing AJAX updates is discussed.

Abstract: Methods and systems for using algorithms in relational database management systems (RDBMSs) for incremental maintenance of materialized views with outerjoins are disclosed. The algorithms achieve the following goals with respect to a class of materialized outerjoin views and the performance of update operations: relax the requirement for the existence of the primary key attributes in a select list of the view to only some of the relations (i.e., the relations referenced as a preserved side in an outerjoin); relax null-intolerant property requirements for some predicates used in the view definition (i.e., predicates referencing relations which can be null-supplied by more than one outerjoin); and implement maintenance of outerjoin views by using one update statement (e.g., MERGE, UPDATE, INSERT, or DELETE) per view for each relation referenced in the view. The algorithms allow design and implementation of the incremental maintenance of materialized views with outerjoins to be integrated into an RDBMS.

Abstract: A computer-implemented method for updating an object on a mobile device is provided. The computer-implemented method includes maintaining at a server a plurality of channels, the plurality of channels including at least a first representation of the object, generating a modification event when a change to the object is detected, responsive to the modification event, at least updating the representation of the object yielding a second representation of the object, and conveying, during a synchronization process, the second representation of the object to the mobile device.

Abstract: Systems, methods and computer program products for detecting potential architecture and interfacing issues in database applications are described herein. In an embodiment, the invention operates by accessing trace information. The trace information includes database-related information pertaining to interactions of a database application with a production database. The invention detects potential architecture and interfacing issues in the database application by analyzing the trace information. Such architecture and interfacing issues include, but are not limited to, multiple connections simultaneously blocking on the same row of a table, and client-side joins.

Abstract: A system, method, and computer program product are provided for intercepting an e-mail from a backend system and converting the e-mail into a message which can be used by a mobile device to graphically represent a business process. The mobile device can interact with the graphic representation, or invoke a business method from a local graphic representation, in order to send a response message to the backend system for further communications.