摘要:
A system, method and article of manufacture for identifying mergeable data in a data processing system and, more particularly, for identifying correlated columns from one or more database tables. One embodiment comprises determining correlation attributes for a first column and a second column from one or more database tables. The correlation attributes describe for each column at least one of the column and content of the column. The correlation attributes from the first and second column are compared and similarities between the first and second column are identified on the basis of the comparison. Then, on the basis of the identified similarities, it is determined whether the first and second columns are correlated. Only if the columns are determined to be correlated, the first and second columns are merged.
摘要:
A system, method and article of manufacture for identification of mergeable data in a data processing system and, more particularly, for providing mechanisms for facilitating identification of correlated columns from one or more database tables. One embodiment provides a computer-implemented method for managing storage of data having an associated measurement unit in a database table. The method includes storing the data in a column of the database table and generating units metadata describing the measurement unit. The units metadata is associated with the column of the database table.
摘要:
Methods, systems, and computer program products for dynamically adjusting computer resources, as appropriate, in response to predictions of batch runtimes as well as for rendering costs of the computer resources actually utilized, which costs are consistent with customer demands.
摘要:
Methods, systems, and computer program products for dynamically adjusting computer resources, as appropriate, in response to predictions of query runtimes as well as for rendering costs of the computer resources actually utilized, which costs are consistent with consumer demands.
摘要:
A method, apparatus, system, and signal-bearing medium that in an embodiment replace an element in a query with a backup if the element is not available, but the backup is available. An element may also be removed from the query if the element is not required. In various embodiments, the element may be a table or a user-defined function. In this way, the query may still execute even if the element is not available.
摘要:
A computer-implemented method, system and computer product including a scheduling manager residing in memory; whereby the scheduling manager dynamically manages access of additional computer resources to be applied to work items of a program based on their valuations relative to the processing costs thereof.
摘要:
A system, method and article of manufacture for presentation of data on a display device and, more particularly, for managing presentation of data in a tabular form on a display device. One embodiment provides a method of managing display of requested data on a display device. The method comprises, in response to a request for data, receiving the requested data in a tabular form having a plurality of columns and rows ordered according to an initial order; re-ordering at least one of the columns and rows, wherein the re-ordering is done on the basis of rules configured to intelligently arrange presentation of the requested data to a user; and outputting the re-ordered requested data for display on the display device.
摘要:
A method, apparatus, system, and signal-bearing medium that in an embodiment replace an element in a query with a backup if the element is not available, but the backup is available. An element may also be removed from the query if the element is not required. In various embodiments, the element may be a table or a user-defined function. In this way, the query may still execute even if the element is not available.
摘要:
A method, apparatus, system, and signal-bearing medium that in an embodiment track a history of statements that query data from a database. When a new statement is received, the history is searched for a correlation between the new statement and previous statements. The correlation is based on host variables in the history and the new statement. When a correlation is found, a prediction is made for the next statement to be received based on the previous statement in the history for which the correlation was found. The prediction is then used to retrieve pages from the database into a cache, which may be used by a subsequent statement.
摘要:
There are disclosed improved methods, systems, and computer program products for enhancing query optimization. More particularly, it relates to dynamically selecting alternative query access plans.