摘要:
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.
摘要:
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.
摘要:
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 system, method and article of manufacture for query execution management in a data processing system and more particularly for scheduling execution of queries against one or more databases in a data processing system. One embodiment provides a method for managing query execution in a data processing system. The method comprises providing at least one query execution schedule configured to schedule specific queries against a database in the data processing system, receiving a query against the database, and managing execution of the received query on the basis of the at least one query execution schedule.
摘要:
Methods, apparatus and article of manufacture for modifying query elements to produce a desired result size. A requesting entity specifies a desired result set size to be returned for a given query. One or more elements specified in the query are modified until a resulting modified query is produced which, when executed produces the desired result set size.
摘要:
Methods, systems and articles of manufacture for performing multiple request processing. Redundant instances of executing entities service requests in a time-delayed fashion, relative to one another. In this way, a user can be returned to an earlier state by switching to the execution flow of one of the other executing entities.
摘要:
The present invention is generally directed to a system, method and article of manufacture for accessing data represented abstractly through an abstraction model. In one embodiment, a data repository abstraction layer provides a logical view of an underlying data repository that is independent of the particular manner of data representation. For each successive query, the data repository abstraction layer is replaced or redefined to provide a restricted logical view of the underlying data repository.
摘要:
A method and apparatus for representing a continuum of data as a rolling column within a relational model is disclosed. Data from a continuous data source may be used to populate a rolling column. Metadata defining the rolling column specifies the correct portion of data from the continuum of data that should be used to populate the rolling column. Whenever data from the rolling column is included in a data access request, such as a database query, a database management system may be configured to update the rolling column, according to the metadata.
摘要:
A method, apparatus, and article of manufacture are provided to optimize the time and effort required to locate all data on a given entity that may span multiple data nodes in a distributed environment. For example, embodiments of the invention may be used to locate nodes within the distributed environment that store electronic healthcare records. A poll request from a first node to a second node may include electronic records existence data indicating data nodes known to have, or not have, records related to a given individual. This information is used to minimize the number of nodes that need to be polled to arrive at the complete aggregation of patient records that exist within a given set of nodes.
摘要:
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.