摘要:
Embodiments of the present invention provide methods for constructing a database abstraction model that includes logical fields that map to a logical table. The logical table is constructed using data extracted from multiple, differently formatted physical tables. The logical table allows logically related data stored in multiple databases to appear as data from a single table. Relationships between data stored in multiple, differently formatted databases are maintained and logical fields that include multiple access methods that map to the multiple databases are replaced with a single access method that maps to the logical table. Data relationships that are defined for the database abstraction model are modified to reflect the logical table.
摘要:
A method, system and article of manufacture for query processing and, more particularly, for determining that Cartesian Products will occur in query results without executing corresponding queries. One embodiment provides a method for detecting Cartesian Products in query results. The method comprises identifying, from a query against one or more databases, joins between different tables of the one or more databases. Without executing the query against the one or more databases, it is determined on the basis of cardinalities of the identified joins whether a Cartesian Product will occur in a query result corresponding to the query.
摘要:
Method, computer readable medium and computer system are provided for coordinating configuration changes among components in a multi-component environment. In one embodiment, a method for changing a configuration of a component in a multi-component environment is provided, the method comprising: receiving a configuration change request for the component; accessing a set of mediation rules which define component relationships in the multi-component environment; based on the received configuration change request and the mediation rules, determining whether one or more corresponding configuration changes are warranted in one or more other components in the multi-component environment; and if the one or more corresponding configuration changes are warranted, sending one or more configuration change notifications to the one or more other components; receiving one or more responses from the one or more other components regarding the one or more configuration change notifications; and sending a configuration change response to the component based on the one or more responses received from the one or more other components.
摘要:
A method, system and article of manufacture for query building and, more particularly, for building query conditions for queries against data in a database. One embodiment comprises receiving user input for constructing a first query condition of a query. Then, user-selectable elements to display for constructing a second query condition of the query are identified. Which user-selectable elements are identified is dependent on the first query condition. The identified user-selectable elements for constructing the second query condition are displayed. Then, user selection of one or more of the displayed user-selectable elements for constructing the second query condition is received. The first and second query conditions define selection criteria for selection of a specific set of the data from the database. The selection criteria are programmatically modified in response to construction of the second query condition on the basis of one or more predefined modification rules, whereby the specific set of the data is altered.
摘要:
Methods, systems, and articles of manufacture for enhancing abstract queries by utilizing conditional modifiers with logical fields are provided. Conditional modifiers allow for the referencing of multiple physical fields via a single logical field. Further, conditional modifiers facilitate the ability to specify, on an instance by instance basis, which physical field or combination of physical fields a particular logical field should reference.
摘要:
A method, system and article of manufacture for processing queries that are executed against a database and, more particularly, for processing aggregation queries that are executed against a database. One embodiment provides a method of constructing queries selectively capable of returning aggregation information related to data in a database. The method comprises receiving user input specifying at least one result criterion for an abstract query comprising one or more logical fields, each corresponding to a logical field specification of a data abstraction model abstractly describing the data in the database, each result criterion corresponding to a logical field for which data is to be returned, receiving user input specifying selection criteria for the abstract query, receiving user input specifying an aggregation operation to be performed with respect to the at least one result criterion for generating aggregation information, and associating the at least one result criterion with the aggregation operation in a manner allowing user selection of whether to perform the aggregation operation with respect to the at least one result criterion without requiring user-made changes to the abstract query.
摘要:
An abstract database is an effective way to reduce the complexity of a large database management system. Abstract databases allow a user to compose queries based on the logical relationships among data items, without requiring a user to understand the underlying database schema used to store the data in the database system. Embodiments of the invention generally provide methods, systems, and articles of manufacture that extend the capabilities of an abstract database to include “late bound” polymorphic functions in an abstract data layer. Abstract functions are “late bound” because the function definition (i.e., the execution logic) is not determined until the function is actually invoked. They are polymorphic because same function may operate using many different many data input types. Additionally, abstract functions are generally transparent to the end user. That is, they are presented to the user as an additional object that may be used to compose queries of data represented by the abstract data layer undifferentiated from other data elements used to compose an abstract query.
摘要:
The present invention generally is directed to a method, system and article of manufacture for controlling the access to data granted to a requesting entity based upon data accessed by the entity in the past. Additionally, embodiments of the present invention allow for access control independent from the particular manner in which the data is physically represented. Generally, abstraction layers are provided to represent various data sources available for use by an application and to compose queries used by the application to access and/or update information contained in these data sources. A runtime component is responsible for resolving an abstract query into concrete data access requests to one or more data repositories using information contained in a data repository abstraction component (one of the abstraction layers). Typically, data is organized into a series of domains. Within each domain, data is associated with an account. User activity is monitored, and when data associated with one account is accessed, a user may subsequently be prohibited from accessing data from a related account within the same domain.
摘要:
Methods, systems, and articles of manufacture for accessing data stored in multiple data sources. Such methods employ an automated software agent to maintain a collection of data sources available for querying. The data sources may all reside within a single local network or may be distributed throughout multiple locations. Generally, the automated software agent searches a given domain for additional data sources according to a defined set of selection criteria. After discovering an additional data source, the automated software agent configures a query application to reflect the availability the additional data source. Further, the automated software agent may periodically evaluate the collection of data sources against the selection criteria and remove those that are either no longer available or no longer satisfy the selection criteria.
摘要:
The present invention generally is directed to a method, system and article of manufacture for controlling the access to data granted to a requesting entity based upon data accessed by the entity in the past. Additionally, embodiments of the present invention allow for access control independent from the particular manner in which the data is physically represented. Generally, abstraction layers are provided to represent various data sources available for use by an application and to compose queries used by the application to access and/or update information contained in these data sources. A runtime component is responsible for resolving an abstract query into concrete data access requests to one or more data repositories using information contained in a data repository abstraction component (one of the abstraction layers). Typically, data is organized into a series of domains. Within each domain, data is associated with an account. User activity is monitored, and when data associated with one account is accessed, a user may subsequently be prohibited from accessing data from a related account within the same domain.