摘要:
A method, system and article of manufacture for protecting sensitive data in databases and, more particularly, for managing access to sensitive data in a database. One embodiment comprises receiving a query against the data in the database comprising at least (i) a result field specification, and (ii) a sorting instruction. The method further comprises retrieving a result set from the database, and filtering the retrieved result set on the basis of predefined filtering rules to remove selected data from a selected result field of at least one data record included with the retrieved result set. The filtered result set is sorted according to the sorting instruction to produce the sorted result set, whereby the sorting is done independently of the removed selected data so that the sorted result set places the at least one data record at a position which is non-indicative of a value of the removed selected data.
摘要:
A method, system and article of manufacture for managing presentation of query results. One embodiment comprises receiving, from a requesting entity, a query having at least (i) one result field for which data from one or more databases is to be returned, (ii) one or more conditions for filtering which of the data contained in the one or more databases is returned for each result field, and (iii) a conditions object defining at least one expression for at least one of the conditions. The query is executed against the one or more databases to obtain a query result having one or more data records. The query result is returned in a format relating the data records to respective expressions on the basis of which conditions the data records satisfy. Thereby, it is exposed which of the data records satisfy respective conditions having defined expressions in the conditions object.
摘要:
A method, system and article of manufacture for managing execution of queries against databases and more particularly for restricting access to sensitive data in underlying databases. One embodiment provides a method for managing access to sensitive data in a database. The method comprises 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 method further comprises 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 preformed with respect to the result set on the basis of the determined sensitivity rating.
摘要:
Embodiments of the present invention provide methods and systems for increasing the flexibility and reusability of parameterized queries. A user may be allowed to select and run a predefined query. If the query is a parameterized query, the user may be prompted to input one or more parameters. Embodiments of the invention allow the user to recommend a parameter that retrieves maximum or minimum results for the query instead of specifying a parameter. In response to such a user selection, a predefined parameter may be inserted as a parameter for the query. Alternatively, the query may be modified by changing or removing one or more query conditions to achieve the desired results.
摘要:
An apparatus and method for a graphical user interface allow performing operations simply by dragging a first object over a second object. One or more attributes of the second object are effectively “picked up” by virtue of dragging over the second object. In this manner, the user interface is more friendly, more intuitive, and reduces the number of pointer clicks to implement a particular function, thereby enhancing the efficiency of the user.
摘要:
Methods, systems, and articles of manufacture are provided for composing abstract queries by referencing previously defined abstract queries and combining the queries based on mathematic operations, referred to as “query math”. Composing queries by performing query math, such as addition and subtraction, with whole abstract queries facilitates and encourages reuse of existing abstract queries.
摘要:
Methods, articles of manufacture and systems for managing execution of workflows. One embodiment provides a computer-implemented method for managing execution of a data driven multi-step workflow. The method includes receiving input data for a step of the workflow and performing the step of the workflow on the input data to obtain a result set. Then, at least one rule is applied to the result set for determining whether one or more associated conditions are satisfied. The at least one rule defines the one or more associated conditions and an associated process. If the one or more associated conditions are satisfied, the associated process is performed on the result set.
摘要:
A method, computer-readable medium and system 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, computer-readable medium, and apparatus for programmatically providing a graphical user interface for creating queries are provided. Generally, the graphical user interface includes a first-level region for displaying one or more first-level query conditions and a first-level operator selection element, the selected first-level operator being applied to logically relate the one or more first-level query conditions. The graphical user interface also contains a second-level region for displaying two or more second-level query conditions and contains a second-level operator selection element, the selected second-level operator being applied to the two or more second-level query conditions within the second-level region to form a second-level query portion. The selected first-level operator is applied to the second-level query portion and the one or more query conditions of the first-level region to form a first-level query portion.
摘要:
An apparatus and method for a graphical user interface allow performing operations simply by dragging a first object to touch a second object. The selection of the first object places a corresponding first object in a chain of objects. When the selected first object touches a second object, a corresponding second object is added to the chain of objects. This process may continue for the selection of many objects by merely touching each object with the selected first object, which causes a corresponding object to be added to the chain of objects. The chain of objects may then be processed as an atomic group of operations that may be rolled back if any of the operations in the group fail.