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: Systems, methods, computer program product embodiments for an active/push notification façade for a passive database are described herein. An embodiment includes an event listener configured to poll (or query) a passive database and selectively retrieve data objects based on the poll results. Such a selective database read operation may be based on the priority of an event occurring in the passive database. If events of a low priority occur, the event listener does not open the passive database immediately to retrieve additional information related to the low priority event but defers reading the passive database by a pre-determined amount of time. If a higher priority event occurs, the passive database is immediately read to retrieve details related to the high priority event from the passive database. In another embodiment, event listener reads the passive database based on event timestamp information in the passive database and stored timestamp information.

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: Disclosed herein are systems, methods, and computer readable storage media for a database system using solid state drives as a second level cache. A database system includes random access memory configured to operate as a first level cache, solid state disk drives configured to operate as a persistent second level cache, and hard disk drives configured to operate as disk storage. The database system also includes a cache manager configured to receive a request for a data page and determine whether the data page is in cache or disk storage. If the data page is on disk, or in the second level cache, it is copied to the first level cache. If copying the data page results in an eviction, the evicted data page is copied to the second level cache. At checkpoint, dirty pages stored in the second level cache are flushed in place in the second level cache.

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: A flexible, extensible and efficient compile-time mechanism that leverages native high-level application programming language constructs (e.g., the template and macro features of C++), thus minimizing any programmer or a software developer learning curve and eliminating the need for programming tool (e.g., compiler) changes, to identify and control aspects of shared resource access in concurrent software at the time of source code compilation.

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: Methods, apparatus and computer program products for allocating a number of workers to a worker pool in a multiprogrammable computer are provided, to thereby tune server multiprogramming level. The method includes the steps of monitoring throughput in relation to a workload concurrency level and dynamically tuning a multiprogramming level based upon the monitoring. The dynamic tuning includes adjusting with a first adjustment for a first interval and with a second adjustment for a second interval, wherein the second adjustment utilizes data stored from the first adjustment.

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 compression of database indexes are described herein. A system embodiment includes a sequence determiner to scan a database index and to determine a start of a range and end of a range of consistently changing values in one or more index pages of said database index and an index updater to update said database index based on a sequence determined by said sequence determiner, while suspending writing of one or more values that lie within start of said range and end of said range of values. A method embodiment includes scanning an index, determining a pattern of changing values in one or more index pages of said index and selectively updating said index based on said determining step to minimize index insertions.

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: 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: 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.