Abstract: A method, system and article of manufacture for performing a clean operation on a query result. One embodiment comprises receiving a query result for an abstract query composed on the basis of a data abstraction model that models physical data in one or more databases in a manner making a schema of the physical data transparent to a user of the abstraction model. The query result has result data that is based on the physical data for at least one logical result field included in the abstract query. The logical result field has a corresponding logical field definition in the abstraction model. One or more value constraints specified in the logical field definition are applied to determine whether the result data of the query result includes invalid data that does not satisfy the value constraints. If so, a data structure is created that uniquely identifies the invalid data.

Abstract: A method, apparatus, and program product for tiered, multi-state intelligent detection and enforcement of security on a pervasive device is provided. The method/apparatus first monitors the pervasive device for the presence of a security identifier, then establishes a current security level chosen from a plurality of security levels for the pervasive device based on the presence of the security identifier.

Abstract: A method, article of manufacture and apparatus for decomposing an initial query into smaller conditional groups for execution on a database is disclosed. A separate database query may be generated for each of the conditional groups, and the results of executing these separate database queries may be combined and returned as the result of the initial query. Typically, the initial query may be decomposed because it is otherwise too large and/or too complex to be executed directly.

Abstract: A method, system and article of manufacture for managing execution of an abstract query against an underlying database. One embodiment comprises receiving an abstract query against one or more databases having physical data and receiving a user-selection specifying how to apply an abstract filter for filtering data. The abstract query is defined using logical fields of an abstraction model that models physical data of the database(s). If the abstract filter should be applied to the abstract query, the abstract query is submitted to a runtime unit configured to (i) modify the abstract query on the basis of the abstract filter, and (ii) transform the modified abstract query into a physical query suitable for execution against the one or more databases to determine a result set. As a result of executing the physical query, the result set containing data from the one or more databases is received.

Abstract: A method, system and article of manufacture for managing execution of queries against heterogeneous data structures are disclosed. One embodiment provides a method of processing a database query. The method comprises receiving, from a requesting entity, an abstract query of data contained in a database and an external data source. From the abstract query, an executable query is generated that is configured to access the database and a temporary data structure generated using data from the external data source. From the executable query, a data request configured to identify the data from the external data source to be included with the temporary data structure is generated. Then, the temporary data structure is generated using the data request. The executable query is executed against the database and the temporary data structure to obtain a result set. The obtained result set is returned to the requesting entity.

Abstract: A method, system and article of manufacture for executing database queries where the data being queried resides in both relational databases and other external data sources, and, more particularly, for creating a dynamic, just in time, database table using data retrieved from an external source. One embodiment provides a method of processing a database query. The method includes receiving, from a requesting entity, an abstract query of data contained in a database and an external data source, the abstract query being defined using logical fields of a data abstraction model abstractly describing the data in the database and the external data source.

Abstract: A method, system and article of manufacture for providing language transformation support for a query result obtained in response to execution of a query against an underlying database containing physical data. The method comprises identifying one or more physical values defined by the physical data for the query result for the executed query. The method further comprises retrieving a user-defined function configured to transform the one or more identified physical values from a first language defined by the physical data in the underlying database into alternative values defined in a second language. The query result is outputted in the second language on the basis of the user-defined function.

Abstract: An apparatus and method provide simple and secure financial transactions in an instant messaging (IM) environment. Two users may engage in an IM session (chat session), with negotiations for a product or service taking place during the chat session. One or both of the users may activate an IM financial transaction mechanism during the chat session. The IM financial transaction mechanism analyzes the chat text, and presents a draft transaction to both buyer and seller, with options based on the analyzed chat text. The draft transaction may be modified by both buyer and seller, who both confirm the draft transaction when all of the details are correct. The confirmed transaction is then sent to a web server that includes an interface to the buyer's online account, and payment is made by transferring the funds for the confirmed transaction from the buyer's online account to an account for the seller.

Abstract: Embodiments of the invention allow a user to obtain information regarding the possible effects of invoking a user-selectable component provided by a software application, such as a user selected menu function or a database query element that may be added to a database query. Generally, a user selected component is analyzed to determine the expected execution characteristic of the component, and an expected execution characteristic may be associated with a graphical display component used to access the user-selectable component.

Abstract: A semantic link is established in a document in connection with content being inserted into first and second portions of a document. Content in the first portion includes a linguistic expression, and is logically related to the content in the second portion. A semantic link is generated in the document that logically links the content of the first portion of the document to the content of the second portion of the document. The semantic link is configured to initiate performance of an action on content in either of the first or second portions of the document in response to a determination that a content modification made to content in the other of the first or second portions of the document is a semantic modification that creates a semantic inconsistency, based at least in part upon a meaning of the linguistic expression, between the first and second portions of the document.

Abstract: A method, apparatus, system, and signal-bearing medium that, in an embodiment, create a viewport based on a selected region of a source window, determine data that is within the selected region, and display the data in the viewport. The source window is minimized to an icon, which represents the source window, but which is different from the data displayed in the viewport. In response to additional data being received, the additional data is displayed in the viewport if the additional data is within the selected region. In an embodiment, the additional data is compared to the data already displayed in the viewport, and if the additional data fulfills a notification criteria, a notification that the criteria was fulfilled is presented via a notification technique.

Abstract: A method, apparatus, and program product for tiered, multi-state intelligent detection and enforcement of security on a pervasive device is provided. The method/apparatus first monitors the pervasive device for the presence of a security identifier, then establishes a current security level chosen from a plurality of security levels for the pervasive device based on the presence of the security identifier.

Abstract: Methods, systems and articles of manufacture are provided for query evaluation. The query is evaluated upon inputting each incremental query element (or combination of element). Generally, for each incremental query element added, a query performance analysis is performed with respect to one or more runtime metrics such as total execution time and runtime resource consumption. The results of the analysis are provided as feedback to the user constructing the query.

Abstract: A method, system and article of manufacture for accessing data in a database independent of the particular manner in which the data is physically represented and for modeling a physical representation of the data in the database for architecting a relationship between the physical representation of the data in the database and a logical representation of the data. One embodiment provides a method for architecting a relationship between a physical representation of data in a database and a logical representation of the data. The method comprises providing the logical representation defining logical fields; and then providing, on the basis of the logical representation, the physical representation for the data, whereby the logical fields defined by the logical representation provide an abstract view of the data and map logical fields of abstract queries to respective data in the database.

Abstract: The present invention generally is directed to methods, articles of manufacture and systems for automatically generating abstract representations of a limited subset of data repository fields accessed by a particular application. The limited subset of fields may be identified by monitoring queries issued against the data repository by the application. The abstract representations may be grouped in a data repository abstraction (DRA) component that serves as a data definition framework allowing data from the fields to be accessed independent of the particular manner in which the data is physically represented in the data repository. By limiting the fields exposed to the application to the limited subset of fields actually accessed by the application, the DRA component, in effect, provides the application with a custom database tailored to its particular needs.

Abstract: The present invention generally is directed to methods, articles of manufacture and systems for automatically generating abstract representations of a limited subset of data repository fields accessed by a particular application. The limited subset of fields may be identified by monitoring queries issued against the data repository by the application. The abstract representations may be grouped in a data repository abstraction (DRA) component that serves as a data definition framework allowing data from the fields to be accessed independent of the particular in which the data is physically represented in the data repository. By limiting the fields exposed to the application to the limited subset of fields actually accessed by the application, the DRA component, in effect, provides the application with a custom database tailored to its particular needs.

Abstract: Methods, systems and articles of manufacture are provided for query evaluation. The query is evaluated upon inputting each incremental query element (or combination of element). Generally, for each incremental query element added, a query performance analysis is performed with respect to one or more runtime metrics such as total execution time and runtime resource consumption. The results of the analysis are provided as feedback to the user constructing the query.

Abstract: A method, apparatus, system, and signal-bearing medium that, in an embodiment, detect a first user, detect a second user, determine a presentation rule based on the detection of the first and second user, and send the presentation rule to an application. The presentation rule instructs the application to modify data presented by the application. In an embodiment, the presentation rule contains an action that the application is to take. In another embodiment, the presentation rule includes categories of the users, and the application determines the action to take to modify the data in response to the categories. In various embodiments, the rule may instruct the application to remove information from the presented data, exclude information from a directory from the presented data, remove a window from the presented data, remove a portion of the window from the presented data, or restrict a user interface element.

Abstract: The present invention generally is directed to a system, method and article of manufacture for generating a data repository abstraction (DRA) component that may be used to access data independent of the particular manner in which the data is physically represented. In one embodiment, a DRA generator identifies a set of logical field candidates for possible use in generating the DRA component. The DRA generator may then generate the DRA component with a subset of the logical field candidates determined by a weighting algorithm based on usage information collected from available database schema and associated objects.

Abstract: A system, method and article of manufacture for managing query results and, more particularly, for sorting data records contained in a query result obtained in response to execution of a query against a database. In one embodiment, the data records in the query result are sorted on the basis of related information which is retrieved from a corresponding data source. In another embodiment, the sorting is performed on the basis of a value variance which is determined for each of the data records in the query result. In still another embodiment, the sorting is performed on the basis of a requested value range coverage. In yet another embodiment, the sorting is performed on the basis of suitability scores which are determined with respect to analysis routines which are configured for processing the query result.