摘要:
Methods for comparing query-related objects are provided. In one embodiment, a first plurality of query-related objects for a first user is compared to a second plurality of query-related objects for a second user to determine a degree of similarity between the first and second plurality of query-related objects. A notification of the degree of similarity is issued.
摘要:
Techniques are disclosed for managing execution of queries against databases and more particularly for restricting access to sensitive data in underlying databases. One embodiment includes an operation for managing access to sensitive data in a database. The operation includes receiving, from a requesting entity, a query against the data in the database. The query is executed against the database to obtain a result set. The operation further includes determining whether the result set includes sensitive data based on predefined sensitivity attributes associated with data in the result set. If so, a sensitivity rating is determined for the result set, and a predefined security action is performed with respect to the result set on the basis of the determined sensitivity rating.
摘要:
Method, system and article of manufacture for scheduling queries. In particular, the scheduling options made available to a user for a particular unit of work are determined dynamically at the time of scheduling. In this way, the execution cost, for example, of a particular unit of work can be taken into account when determining which scheduling options to make available. In addition, or alternatively, system availability and/or user parameters may be accounted for when determining which scheduling options to make available.
摘要:
The present invention provides for aging queries. Queries are aged by, for example, adding temporal conditions to the queries. The temporal conditions include temporal fields having a time-based association with one or more other conditions of the respective queries. In one embodiment, each temporal condition includes a temporal field and corresponding time value, where the time value is set to the time when the respective query was last run.
摘要:
Methods for comparing query-related objects are provided. In one embodiment, a first plurality of query-related objects for a first user is compared to a second plurality of query-related objects for a second user to determine a degree of similarity between the first and second plurality of query-related objects. A notification of the degree of similarity is issued.
摘要:
A method, apparatus, and article of manufacture for managing access to an abstract database are provided. The abstract database may include a data abstraction model comprising a plurality of logical field definitions, each of the definitions comprising a logical field name, and an access method maps the logical field to a physical data field. Collectively, the physical data fields provide an indirection layer logically disposed between the data abstraction model and the underlying physical database. By providing this layer of indirection using the physical data fields, a number of enhancements to the data abstraction model may be provided. This includes providing enhancements to the security, administration, and usability of an abstract database.
摘要:
A method for comparing query-related objects is provided. In one embodiment, a first plurality of query-related objects for a first user is compared to a second plurality of query-related objects for a second user to determine a degree of similarity between the first and second plurality of query-related objects. A notification of the degree of similarity is issued.
摘要:
A method, system and article of manufacture for processing queries and, more particularly, for graphically representing relationships between different queries. One embodiment provides a method for graphically representing a relationship between a first and a second query. The method includes selecting, from the first and second queries, elements to be compared. On the basis of the selected elements, a degree of similarity between the first and second queries is calculated. The method further includes displaying a first query object representative of the first query and a second query object representative of the second query in a user interface. The first and second query objects are positionally arranged on the basis of the calculated degree of similarity. The positional arrangement reflects the relationship between the first and second queries.
摘要:
Embodiments of the invention allow for managing execution of queries with respect to different data sources. The different data sources are logically represented by data abstraction models. One embodiment comprises receiving a first abstract query against physical data in a first data source. The first abstract query has result fields configured to return requested data from the first data source. In response it is detected whether the first data source is available. If the first data source is unavailable, a second abstract query against physical data in a second data source containing a portion of the requested data is created on the basis of the first abstract query. The second abstract query has result fields configured to return the portion of the requested data from the second data source. The second abstract query is executed against the second data source to obtain the portion of the requested data.
摘要:
Embodiments of the present invention allow the results of a query to an operational datastore to be augmented with relevant data that may be stored in a staging area datastore. Upon receiving a query to the operational datastore, it is determined whether data relevant to the query is present in the staging area datastore. If relevant data is present, such data may be transformed, transferred and combined with data in the operational datastore. The query is then run against the combined data and the results displayed to the user.