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

Abstract: Methods, systems, and computer program products are provided to manage a database system. The method includes locking during a database system idle time access by the database system to a data page of a data allocation unit, compressing during the database system idle time a data stored in the locked data page, and recording during the database system idle time an indication that the compressed and locked data page includes free storage space, wherein unlocked data pages of the data allocation unit are accessible by the database system during the compressing of the data stored in the locked data page. Thus, the data page may be compressed during idle time and the space freed therein may be used during a subsequent run time without the need for a reorganization of the data pages within the corresponding table (as in, for example, operation of a reorg+rebuild SQL command combination).

Abstract: A flexible, extensible, and dynamically configurable anti-spam facility that operates on a general quanta of data (such as for example a Short Message Service message, a Multimedia Message Service message, an Internet Protocol Multimedia Subsystem message, a Wireless Application Protocol stream, an Electronic Mail message, an Instant Messaging exchange, streaming (audio, video, etc.) data, etc.), innovatively analyzes various attributes of same (such as for example originating address and destination address), and—when an instance of spam is identified—performs one or more remediation activities (such as for example updating a blacklist, updating a greylist, dropping a message, issuing an alert, etc.). The facility may optionally leverage the capabilities of a centrally-located Messaging Inter-Carrier Vendor.

Abstract: High performance index creation using parallel query plans with repartitioning scan and vector-based repartitioning scan is described. An example method includes extracting index key columns from data rows of the database table to build a set of index rows, wherein the index on the database table is defined by a plurality of index key columns including a first index key column and a second index key column. Partition boundary values are generated to divide up the index rows into range-partitioned sets, and the index rows are sorted based on values of the index key columns. A repartitioning scan, including a SARG-based or a vector-based partitioning scan is performed on the index rows, using a plurality of worker threads executing in parallel to build sub-indexes. Subsequently, each range-partitioned set of index rows are assigned to a worker thread in the plurality of worker threads. Accordingly, the sub-indexes generated from the plurality of work threads are merged to build the index for the database table.

Abstract: Disclosed herein are system, method, and computer program product embodiments for implementing a bitmap for a column store database. An embodiment operates by creating, by at least one processor, a bitmap identifying rows in a column store database. The bitmap may include a list of bit chunks, a bit chunk including an offset being a natural number indicating a chunk size, and a bit specification including one of an ordered row id list, a contiguous row id sequence, and a bit vector. In addition, the embodiment includes performing database operations using the bitmap.

Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for data replication tracing are provided. In an embodiment, the data replication tracing includes identifying a replication environment within a multi-tier infrastructure of an enterprise data processing network, and monitoring operational performance within the replication environment. A path is rendered on a topology to display data flow for the replication environment based upon a configuration of the replication environment. The data flow may be represented relative to a target data node, relative to a source data node, and/or relative to a replication server.

Abstract: A flexible, extensible, and dynamically configurable Advanced IP Messaging Server (AIMS) facility that among other things may leverage various pools of data—including for example routing data, location and presence data, Mobile Subscriber profile data, etc.—to expeditiously process and route, through the use of among other things Feature Tags, a wide range of information including among other things conventional Short Message Service, Multimedia Message Service, IP Multimedia Subsystem, etc. messaging; E-Mail messaging; Instant Messaging communications; Voice Over IP and other (e.g., video conference, etc.) data streams; Session Initiation Protocol-addressed artifacts; etc.

Abstract: Systems, methods, and computer program products are provided for synchronizing data within a native PIM data store in a device an enterprise data. Data modifications generated by mobile applications on the device, or by an enterprise server, are identified and reflected into the native PIM data store. Additionally, a listener is provided to detect modifications to relevant data within the native PIM data store and reflect these modifications in the mobile applications and the enterprise server. The framework which accomplishes this further provides platform-independent access to the native PIM data store.

Abstract: Leveraging the ubiquitous nature of wireless devices and the popularity of (Short Message Service, Multimedia Message Service, etc.) messaging, an infrastructure that supports message-based conversations (with for example the maintenance or preservation of state, context, etc. across or during the message exchanges) allowing users of wireless devices to employ their wireless devices to engage in and complete increasingly more complicated activities. The infrastructure may optionally leverage the capabilities of a centrally-located Messaging Inter-Carrier Vendor.

Abstract: Systems, methods and computer program products for multi-path replication in databases are described herein. A non-limiting embodiment includes instantiating a plurality of replicate connections to a replicate database, providing transactions to the replicate database through a plurality of transaction streams, where the transaction streams associated with respective instantiated replicate connections. Transactions occurring in distinct transaction streams are applied, in parallel, at the replicate database. Another non-limiting embodiment includes instantiating a plurality of replication sender threads, where the replication sender threads communicate in parallel with respective replication servers over respective replication paths. Data sharing one or more attributes can be bound to a replication path in communication with the respective replication servers.

Abstract: Systems, methods and computer program products for testing the stability and efficiency of a database query engine are described herein. In an embodiment, all possible query execution plans considered by a query optimizer are retained in the form of abstract plans (APs). Each AP is then subsequently supplied with a query to test for stack traces and incorrect results that may occur during the execution of the query. An embodiment includes determining an optimizer efficiency index (OEI) by comparing each AP with a query execution plan chosen by the query optimizer and classifying the APs into various performance buckets based on the degree of improvement or degradation in performance with respect to the query execution plan chosen by the query optimizer. In another embodiment to determine the optimizer efficiency index, APs are ranked based on estimated cost and classified into a plurality of categories based on query optimizer estimates and actual execution behavior.

Abstract: Systems and methods for assigning short codes to provide uniformity among wireless carriers. In the systems and methods, a Universal Short Code (USC) Administrator maintains a list of short codes and their lease status so that SMS messages sent to a particular short code may be routed to the proper holder of the short code. A network facilitator is in communication with both the USC Administrator and at least one wireless carrier to route the SMS message to the proper holder of the short code. The short code may be leased for a specified period of time so that the short code can be reassigned after expiration of the lease.

Abstract: Methods, systems, and computer program products for synchronizing data between a mobile application and an enterprise data source are provided. A computer-implemented method may include receiving a request for data from an application executing on a mobile device, receiving a document including the requested data from a data source where the document represents a graph of data having a plurality of nodes, and providing a partial graph of data to the application where the partial graph is derived from the received document and at least includes the requested data.