Embodiments allow a primary database system (primary) to automatically detect queries directed to the primary database that may be offloaded to a standby database system (standby), and then to automatically offload the offload-eligible queries to a standby. The primary identifies offload-eligible queries based on a record of up-to-date database objects within each standby that replicates the primary database. The record of up-to-date standby objects is updated based on heartbeat messages from each standby, and commit timestamps for transactions on the primary. Evaluation of whether a query is offload-eligible is triggered by one or more trigger conditions that include: inclusion of an offload optimizer hint in the query, an estimated run-time of the query, etc. Embodiments further allow an offloaded query over particular changed data in the primary database to access, on a standby database, uncommitted changes made to the particular data in the primary database.

A method, system and computer program product are provided for implementing intelligent standard deviation inserts into a relational database management system (RDBMS). A trigger program type logic is provided within a database for processing outlier data based upon deviation constraints. The processed outlier data is used for automatically taking appropriate action including preventing insertion of outliers into the Relational Database Management System (RDBMS).

A non-transitory computer-readable recording medium stores therein an index generating program that causes a computer to execute a process including: inputting control statements including plural phrases and having contents that change according to description positions of the plural phrases; generating first index information related to positional information of each of the phrases in the control statements; and generating, from the first index information, a second index information group related to the phrases targeted by each of reserved words included in the control statements.

The embodiments of the present application disclose an image search method, apparatus and storage medium. The image search method comprises: displaying an image; identifying, based on a sliding trace caused by a user on the image, a selected region; determining, based on the selected region, a search target in the image; transmitting, based on the search instruction entered by the user, a search request based on the search target. The image search method and apparatus according to the embodiments of the present disclosure may easily identify the pictorial image corresponding to the to-be searched object from the search image.

The present disclosure provides improved systems, methods, and computer program products suited to address the issues with legacy approaches. Specifically, the present disclosure provides a detailed description of techniques used in systems, methods, and in computer program products for interpreting relational database statements using a virtual multidimensional data model. Certain embodiments are directed to technological solutions for receiving a relational database statement comprising relational metadata mapped to a virtual multidimensional representation of a subject database, and generating a subject database statement based at least in part on the relational database statement and the virtual multidimensional representation, and configurable to operate on the subject database to produce a visualization result set, which embodiments advance the technical fields for addressing the problem of projecting a multidimensional data view of a subject database on to a relational data analysis environment to enable real time data analyses, as well as advancing peripheral technical fields.

An improved method of facilitating contact between mutually interested people takes advantage of existing contact lists such as those on social networking sites, instant messaging programs, or cell phones. A program is integrated into one or more of those technologies, allowing the user to characterize each contact on the basis of the user's level of interest in that contact as a date. The program keeps these rankings secret until two users indicate an interest in each other that surpasses a certain threshold. The users are then notified of the mutual interest. Ads and dating advice are sent along with the notification.

A database system searches for any statements that satisfy one or more of a set of filtering criteria. When a given dynamic query statement fully satisfies the set of filtering criteria, the given statement is stabilized by persistently storing a bound form of the given dynamic query statement. When the given dynamic query statement partly satisfies the set of filtering criteria, a monitoring request is created with the set of filtering criteria to begin monitoring subsequent executions of the statement, and the statement is linked to the monitoring request. When the given dynamic query statement subsequently fully satisfies the set of filtering criteria, the statement is stabilized by persistently storing the bound form of the statement. When the given dynamic query is re-executed, the stabilized statement is loaded, and the PREPARE process is bypassed.

The present disclosure provides improved systems, methods, and computer program products suited to address the issues with legacy approaches. Specifically, the present disclosure provides a detailed description of techniques used in systems, methods, and in computer program products for interpreting relational database statements using a virtual multidimensional data model. Certain embodiments are directed to technological solutions for receiving a relational database statement comprising relational metadata mapped to a virtual multidimensional representation of a subject database, and generating a subject database statement based at least in part on the relational database statement and the virtual multidimensional representation, and configurable to operate on the subject database to produce a visualization result set, which embodiments advance the technical fields for addressing the problem of projecting a multidimensional data view of a subject database on to a relational data analysis environment to enable real time data analyses, as well as advancing peripheral technical fields.

The present disclosure provides improved systems, methods, and computer program products suited to address the issues with legacy approaches. Specifically, the present disclosure provides a detailed description of techniques used in systems, methods, and in computer program products for interpreting relational database statements using a virtual multidimensional data model. Certain embodiments are directed to technological solutions for receiving a relational database statement comprising relational metadata mapped to a virtual multidimensional representation of a subject database, and generating a subject database statement based at least in part on the relational database statement and the virtual multidimensional representation, and configurable to operate on the subject database to produce a visualization result set, which embodiments advance the technical fields for addressing the problem of projecting a multidimensional data view of a subject database on to a relational data analysis environment to enable real time data analyses, as well as advancing peripheral technical fields.

A computer-readable non-transitory physical storage medium having stored thereon machine-executable code for electronically facilitating contact between mutually interested entities, said machine-executable code to be executed by a microprocessor, said machine executable code which when executed by said microprocessor causes the microprocessor to perform operations including suggesting to a first user other users that first user may be interested in, where the suggested other users are filtered based on their location, causing a device to display a graphical user interface (GUI) for the first user to input a rating of the first user's level of interest in one or more respects in at least one other user, accepting the first user's level of interest rating via the GUI while not displaying the first user's rating to the at least one other user, and electronically notifying a pair of users that have rated each other above a threshold level.