Abstract: A system, method, and computer-readable medium having computer-executable instructions for maintaining connections between a mobile device and a server are described herein. In an embodiment, the method operates by receiving a data request from the mobile device, the data request identifying at least a timeout interval. The method comprises sending the data request to a data server and then determining whether the timeout interval has passed. The method also comprises sending a keep alive message to the mobile device indicating that the request has timed out if it is determined that the timeout interval has passed. The method then receives a re post request from the mobile device, the re post request identifying a timeout interval. The method further comprises receiving a response from the data server, the response including at least data requested by the mobile device and then sends the response to the mobile device.

Abstract: A system, method, and computer program product for synchronizing communications, data, application workflow events, and business processes between a mobile device and a server are described herein. In an embodiment, the method operates by determining whether there is a data object to be synchronized between a source and a target, wherein the source and target are one of either a mobile device or a server. An indication is sent to the target when there is a data object to be synchronized from the source. The data object to be synchronized is saved in a cache on the source and it is determined whether the mobile device is connected to the server. The synchronization operation is queued for the target until it is determined that the mobile device is connected to the server, and results are returned to the source after the data object is synchronized on the target.

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: 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 cache management system providing improved page latching methodology. A method providing access to data in a multi-threaded computing system comprises: providing a cache containing data pages and a mapping to pages in memory of the multi-threaded computing system; associating a latch with each page in cache to regulate access, the latch allowing multiple threads to share access to the page for reads and a single thread to obtain exclusive access to the page for writes; in response to a request from a first thread to read a particular page, determining whether the particular page is in cache without acquiring any synchronization object regulating access and without blocking access by other threads; if the particular page is in cache, reading the particular page unless another thread has exclusively latched the particular page; and otherwise, if the particular page is not in cache, bringing the page into cache.

Abstract: A system, method, and computer program product are provided for synchronizing tasks between mobiles device without a native task applications, such as mobile devices running the iPhone operating system, and a server. The method synchronizes tasks between a mobile device and a server with a task application installed. The method receives a plurality of data fields associated with a task from the mobile device, stores the data fields in a database, and transforms the plurality data fields into a task record formatted according to the task application installed on the server. The method communicates the task record to the task application installed on the server. The method operates symmetrically to facilitate synchronization of new and updated tasks between a source and a target, wherein the source may be either a mobile device or a server, and wherein the target may be either a server or a mobile device.

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.

Abstract: A method, system, and apparatus for accessing data-driven websites and applications on a mobile client device are described. A request for a website received from the mobile client device is transmitted to a provider. At least one web page template of the website and application data corresponding to the at least one web page template is received from the provider in response to the request, and is transmitted to the mobile client device. Thereafter, in an offline mode, the mobile client device can display a plurality of web pages corresponding to the website, each web page displaying corresponding data of the application data formatted according to a common format provided by the at least one web page template. Furthermore, a method, system, and apparatus for tracking the usage of applications on a mobile client device is provided. The occurrence of at least one user initiated event on the mobile client device during offline operation is enabled.

Abstract: Methods, systems, and apparatuses for improving performance of parallel database query plans are described. An exchange operator is positioned in a query tree. A child operator of the exchange operator is parallelized into a plurality of parallel child operators, each of the parallel child operators coupled to the exchange operator in a respective branch of a plurality of parallel branches of the query tree. An output of each of the plurality of parallel child operators may be buffered at the exchange operator. Furthermore, child operators of the plurality of parallel child operators may also be parallelized. Query plans of any form and containing any number of operators may be parallelized in this manner. Any number of parallel branches may be used, independent of the number of operators in the original plan. The parallelized query plans achieve effective load balancing across all branches.

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: Described herein are systems, methods, computer program products, and combinations and sub-combinations thereof, for executing scripts that can be loaded on mobile devices (as well as other types of devices), and for users of mobile devices to interact with such scripts on their devices in an interactive manner. According to embodiments, the present invention performs script operations for mobile devices including steps for sending a request for an object and a list of support languages, and receiving the object and any related scripts in the supported languages.

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: Systems, methods and computer program products for efficiently re-starting and/or recovering interrupted synchronizations between a client and a server are described herein. A server transmits sync data to a client during a synchronization operation. The sync is interrupted for some reason prior to the client receiving all of the sync data. The client sends to the server a request to re-start the synchronization operation. The request includes information that identifies a point in the sync data that was received by the client prior to interruption of the sync. Such information may include (a) information identifying the last data received by the client prior to interruption of the sync; and/or (b) information identifying the next data needed by the client upon re-start of the sync. Thereafter, the server re-starts the sync by transmitting to the client the sync data starting from said point in said sync data identified by said request.

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: A computer-implemented method for receiving information at a first device is provided. The method includes storing a first data object on the first device in a first device-specific representation, receiving a batch of information in response to the first device transitioning from an off-line state to an online state, processing the modification event to recover the modification, updating the first data object based on the recovered modification, and transmitting an acknowledgement indicating that the modification event was successfully processed by the first device. The batch of information includes a modification event. The content of the batch was determined based at least on a state of data stored on the first device. The modification event was generated based on at least a modification made to a second data object stored at a second device in a second device-specific representation.

Abstract: A system, method, and computer program product are provided for generating a graphical representation of a query optimization process. The method comprises the steps of parsing a search space log, presenting one or more evaluated access plans on an axis of a timeline, identifying a best access plan on the timeline, and outputting a graphical representation of the timeline. An additional system, method, and computer program product are provided for recording a query optimization process of a query optimizer.

Abstract: A system, method, and computer program product are provided for immediately updating a materialized view in a relational database management system. The method includes the steps of creating a materialized view defined over a base table, executing an update statement on the base table, computing a delta of the base table by comparing images of the base table before execution of the update statement and after execution of the update statement, computing a delta of the materialized view based on the delta of the base table, and updating the materialized view using the delta of the materialized view.

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: The invention is directed to a method, system, and computer program product for the synchronization of similar data objects by exchanging event information to provide new and/or updated data objects to a mobile device or application for use on a device. The invention includes a method, system, computer program product, and combinations and sub-combinations thereof, for enabling similar data objects to be made available to users of mobile devices, and for the users of mobile devices to operate with such objects on their mobile devices in an interactive manner while in an off-line mode, i.e., while not actively connected to a network or external data source.

Abstract: A system providing methodology for cost-based enumeration of subqueries using a left-deep tree join enumeration algorithm is described.