摘要:
Embodiments of the invention provide techniques for processing abstract rules with query results having rows with multiple data values per column. In general, value fields are created to store the multiple data values of each attribute contained in each row of the query results. The abstract rule is transformed, resulting in a single executable rule corresponding to each row of the query results. Each executable rule references the value fields created to store the multiple data values. Each executable rule is then processed, utilizing the value fields of the corresponding row as rule inputs.
摘要:
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.
摘要:
Embodiments of the invention are generally related to data processing, and more specifically to retrieving results for a query from one or more devices coupled to a network. A first device may receive an abstract query including logical fields defined by a first data abstraction model and retrieve query results stored in the first device. The query may be sent to one or more other devices via the network. The one or more other devices may be configured to convert the abstract query to local abstract queries including logical fields defined in local data abstraction models. The local queries may be issued against local databases to retrieve additional results for the query.
摘要:
Embodiments of the invention provide techniques for determining query entities in physical tables for an abstract database. A query entity may be created to store a particular set of data. The query entity may be defined in terms of the structure of the physical database, such as an SQL statement, used to generate the query entity as needed. The fields included in a given query entities may be determined based on the presence (or absence) of values in the columns of a physical database table. In addition, logical fields having access method which map to the fields included in a query entity may be generated.
摘要:
Embodiments of the invention provide techniques for temporarily disabling conditions in abstract queries. In one embodiment, a query interface is configured to present an abstract query, and to allow a user to select conditions of the abstract query to be temporarily disabled. By executing an abstract query having disabled conditions, the user may be able to determine the effect of individual changes to the abstract query without having to re-compose the abstract query after each change. The conditions to be disabled may be selected individually, by field, or by value. Each disabled element may be displayed with a visual indicator communicating that it is disabled. The user may then select specific disabled conditions to be re-enabled.
摘要:
Embodiments of the invention provide techniques for temporarily disabling conditions in abstract queries. In one embodiment, a query interface is configured to present an abstract query, and to allow a user to select conditions of the abstract query to be temporarily disabled. By executing an abstract query having disabled conditions, the user may be able to determine the effect of individual changes to the abstract query without having to re-compose the abstract query after each change. The conditions to be disabled may be selected individually, by field, or by value. Each disabled element may be displayed with a visual indicator communicating that it is disabled. The user may then select specific disabled conditions to be re-enabled.
摘要:
The present invention generally is directed to systems, methods, and articles of manufacture for securing sensitive information involved in database transactions. Embodiments of the present invention selectively encrypt only portions of transactions involving sensitive data, thereby reducing or eliminating the processing overhead resulting from wastefully encrypting non-sensitive data. The sensitive data may be identified by a document. The document may be accessed by a requesting entity to determine which portions of a query should be encrypted prior to sending the query to a database server over a network. The document may also be accessed by a database server to determine which portions of query results should be encrypted prior to sending the query results to the requesting entity over the network.
摘要:
A method, system and article of manufacture for data processing in databases and, more particularly, for providing natural language support in a database environment. One embodiment provides a method of providing natural language support for users running queries against a database. The method comprises providing a data abstraction model comprising a plurality of logical fields abstractly describing physical data residing in the database, and associating the data abstraction model with a language resource component defining a natural language expression for each of the plurality of logical fields.
摘要:
A method, system and article of manufacture for providing natural language support for users running queries against a multilingual database. One embodiment comprises identifying one or more physical values defined by physical data in the multilingual database for a query result associated with an executed query. At least one translation function configured to transform at least a portion of the identified physical values defined in one or more different natural languages into alternative values defined in a selected language is executed. From each executed translation function, a data structure mapping at least a portion of the identified physical values to translated values defined in the selected language is identified and the translated values defining the alternative values defined in the selected language are retrieved from each identified data structure. The query result associated with the executed query including the alternative values defined in the selected language is output.
摘要:
Embodiments of the invention may be used to improve enforcement and compliance with publishing rules in an automated and provable manner. Prior to publication, documents may be processed using publishing rules (workflows) based on conceptual analysis of document content. Additionally, embodiments of the invention include a content creation system configured to provide prompt feedback on content coverage. Such a system enables the creator of information to better understand what approval requirements apply to content they create and intend to publish, as the content is being created.