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 for organizing a visual representation of data into a structured data format are presented. Steps for identifying cell data structures from raw data and creating a structured data format are disclosed.

Abstract: Multi-control password changing includes initiating a password change cycle to change a target user's password, selecting a plurality of administrators to provide password part inputs, receiving password part inputs separately and confidentially from the plurality of administrators, generating a multi-control password comprised of multiple password part inputs, changing the target user's password to the multi-control password, and transmitting either the single multi-control password or multiple password parts each separately to target user.

Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for temporary storage management in a shared disk database cluster are provided. Included is the reserving of units on-demand and of variable size from shared temporary storage space in the SDC. The utilization of the reserved units of the shared temporary storage space is tracked, and the shared temporary storage space is administered based on the tracking.

Abstract: Systems, methods and computer program products for statement categorization and normalization are described herein. An embodiment includes a statement categorizer and a statement normalizer. The statement categorizer categorizes statements to reduce or even eliminate inconsistencies that may arise between primary and replicate databases as a result of executing certain statements. Categorized statements are normalized by the statement normalizer to generate normalized statements, which are provided to a replication server. Normalized statements assist replication server to regenerate a statement to be executed on a replicate database.

Abstract: A system, method, and computer program product are provided for optimizing a range-based query on a table in a database system.

Abstract: Various embodiments of systems and methods for enhancing consumer engagement using advanced communication exchange services are described herein. The method involves receiving by a consumer device an address book entry from an enterprise device. The consumer device is enabled with enhanced address book capability provided by any advanced communication exchange systems. Further, in an aspect, the received address book entry is activated to enable the enterprise device to push business information to the consumer device. In another aspect, selecting the address book entry invokes the advanced communication services supported by the enterprise device. By accessing one or more of the advanced communication services, business information from the enterprise device is received via the selected communication exchange service. In an aspect, the received business information is customized based on online presence information of the consumer device.

Abstract: Various embodiments of systems and methods for recommending applications to portable electronic devices are described herein. Initially a context change of an application identification parameter is detected. Based on the detected context change, a target application, from a plurality of applications, may be identified. A similarity value is then computed between the identified target application and another application. Finally, an application to be recommended to a portable electronic device is determined based on the computed similarity value and a rate value of another application.

Abstract: Methods, systems, and computer program products for context-based data pre-fetching and notification for applications are described herein. In an embodiment, the method operates by creating a context model that includes context variables and events. The method populates context variables based upon the context of an application and instantiates a context based upon the context model. The method determines whether the context is active or inactive and infers a likely set of data needed by the application. The method executes a data selection function to generate a dataset for the application. In an embodiment, the system includes a module to create and maintain a context model. The system includes modules to: populate context variables within the context model; calculate a dataset for the application; maintain an inference engine; subscribe to changes in the context variables; and generate notifications including a dataset with associated metadata that assists with display of the dataset.

Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for reducing contention of transaction logging in a database management system (DBMS) are provided. An embodiment includes creating a dependency relationship among private log caches (PLCs) having individual associations with tasks in a DBMS. The dependency relationship is utilized to control buffer pinning and unpinning among the PLCs without involving a flushing of the PLCs during transactions of the tasks.

Abstract: Freeing memory safely with low performance overhead in a concurrent environment is described. An example method includes creating a reference count for each sub block in a global memory block, and each global memory block includes a plurality of sub blocks aged based on respective allocation time. A reference count for a first sub block is incremented when a thread operates a collection of data items and accesses the first sub block for a first time. Reference counts for the first sub block and a second sub block are lazily updated. Subsequently, the sub blocks are scanned through in the order of their age until a sub block with a non-zero reference count is encountered. Accordingly, one or more sub blocks whose corresponding reference counts are equal to zero are freed safely and with low performance overhead.

Abstract: For the purpose of mapping an inbound Electronic Data Interchange (EDI) transaction to one or more outputs there are operations comprising receiving an inbound EDI transaction, and translating the inbound EDI transaction to any combination of EDI outbound transactions and non-EDI outbound transactions. Such translation is performed according to a map file, which is generated as follows. The inbound and any outbound EDI transactions are defined, and templates of the inbound and outbound EDI transactions are also defined. Then, mappings between the template of the inbound EDI transaction and the templates of the outbound EDI transactions are defined. A mapping between the inbound EDI transaction and application data may also be defined, where the application data may include a text file, a XML file, and/or a table of a database. Rules relating to or governing the mapping of the inbound EDI transaction to outputs may also be created. These definitions, mappings and rules are stored in the map file.

Abstract: System, methods and articles of manufacture for optimizing a query plan reuse in a database server system accessible by a plurality of client connections. An embodiment comprises providing at least one global cache storage and a private cache storage to a plurality of client connections, and coordinating utilization of the at least one global cache storage and the private cache storage to share light weight stored procedures and query plans for prepared SQL statements across the plurality of client connections via the at least one global cache storage while avoiding a spinlock access for executing the prepared SQL statements.

Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for data replication in a database system environment are described. In an aspect, the data replication includes grouping, in-memory, a plurality of transactions to be replicated as a single transaction from a source database system to a target database system. A plurality of net row changes is compiled for the plurality of transactions, and data inconsistency detection and resolution within a command application order are performed. Further included is bulk application of the plurality of net row changes to the target database system.

Abstract: A system, method, and computer program product are provided for producing aspects of a generation model. These include a domain model having one or more elements, and templates defined for the elements. The generation model is used to compile a code generator, which can be used to generate code from an input conforming to the domain model.

Abstract: A query plan predictor receives a query instance according to a query template having a set of parameters. The query plan predictor determines a plan space point for the query instance which is based upon the set of parameters. The query plan predictor predicts a predicted query plan for the plan space point, which is selected from a map of query plans according to a confidence threshold from a plan cache that includes at least one histogram. Each histogram is representative of a cached query plan in the plan cache combined with a previously-selected locality-sensitive hashing function. The histogram stores a frequency distribution of a mapping of sample plan points for the cached query plan by the locality-sensitive hashing function.

Abstract: A method, system and computer readable storage medium for replicating structured data stored in a database. The method includes identifying the stored structured data, mapping the data to an unstructured data type, and sending the mapped data to one or more replicate databases as unstructured data.

Abstract: Embodiments relate to a computer-implemented method for graphically displaying or presenting a fisheye-based view of a large data list on the limited content viewing area of a mobile device. At least a subset of data rows within the data list and graphical representations of a plurality of data fields of at least the subset of data rows are generated and graphically displayed using a graphical user interface of the mobile device. When a user selects a focus row from the displayed data rows, a fisheye-based view of the selected focus row is presented. The fisheye-based view and the graphical representations of the data fields provide the user with a focus-plus-context view of a large data list. Further, the graphical representations provide the user with meaningful information even when particular data items are too small to read specific values.

Abstract: Systems, methods, and computer program product embodiments are provided for path-based query evaluation. The embodiments include representing a markup language document as a descriptive catalog, and capturing relationships in the descriptive catalog as an index summary. The index summary is utilized for evaluating a path-based query.

Abstract: System, methods and computer-readable mediums for generating a visual representation of a continuous computation language (CCL) document. The CCL document includes one or more CCL statements. For each CCL statement, a text-to-visual mapping module converts each CCL statements to visual objects as a representation of instruction logic of the CCL document graphically on a display device.