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.

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: Methods and apparatuses for communications between web service applications and web services are described. A first interface is coupled between the application and a messaging system. A second interface is coupled between the messaging system and the web service. The first interface is configured to receive a web service request from the application, to format the web service request into a Simple Object Access Protocol (SOAP) request message, to include the SOAP request message in a first electronic message, and to transmit the first electronic message to the messaging system. The messaging system is configured to receive the first electronic message at a first node, to transmit the first electronic message across a communications network to a second node, and to couple the first electronic message from the second node to the second interface.

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 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 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: Methods, systems, apparatuses, and computer program products for servicing advertisements for offline display on mobile devices are provided. In a first aspect, a channel is received at a mobile device server from one or more providers, including a first web page, an advertiser web page, and an advertisement image file. The received channel is transmitted to the mobile device. In an offline mode, when displayed, the first web page includes an image contained by the advertisement image file. A user viewing the first web page on the mobile device can select the displayed image of the advertisement image file to traverse a link to cause the advertiser page to be displayed on the mobile device. In another aspect, a plurality of advertisement image files are received and stored at a mobile device. The display of the advertisement images on a first web page is cycled each time the first web page is displayed on the mobile device.

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: Methods, systems, apparatuses, and computer program products for servicing advertisements for offline display on mobile devices are provided. In a first aspect, a channel is received at a mobile device server from one or more providers, including a first web page, an advertiser web page, and an advertisement image file. The received channel is transmitted to the mobile device. In an offline mode, when displayed, the first web page includes an image contained by the advertisement image file. A user viewing the first web page on the mobile device can select the displayed image of the advertisement image file to traverse a link to cause the advertiser page to be displayed on the mobile device. In another aspect, a plurality of advertisement image files are received and stored at a mobile device. The display of the advertisement images on a first web page is cycled each time the first web page is displayed on the mobile device.

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