Techniques for identifying mergeable data
    1.
    发明申请
    Techniques for identifying mergeable data 有权
    识别可合并数据的技术

    公开(公告)号:US20050240615A1

    公开(公告)日:2005-10-27

    申请号:US10829624

    申请日:2004-04-22

    IPC分类号: G06F17/00 G06F17/30

    CPC分类号: G06F17/30498 G06F17/30315

    摘要: 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.

    摘要翻译: 一种用于识别数据处理系统中的可合并数据的系统,方法和制品,更具体地,用于从一个或多个数据库表中识别相关列。 一个实施例包括从一个或多个数据库表确定第一列和第二列的相关属性。 相关性属性描述列的列和内容中的至少一个的每列。 比较来自第一列和第二列的相关属性,并且基于比较来识别第一列和第二列之间的相似性。 然后,基于所识别的相似度,确定第一列和第二列是否相关。 仅当列被确定为相关时,才合并第一列和第二列。

    Techniques for providing measurement units metadata
    2.
    发明申请
    Techniques for providing measurement units metadata 有权
    提供测量单元元数据的技术

    公开(公告)号:US20050240614A1

    公开(公告)日:2005-10-27

    申请号:US10829613

    申请日:2004-04-22

    IPC分类号: G06F17/00 G06F17/30

    摘要: 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.

    摘要翻译: 一种用于识别数据处理系统中的可合并数据的系统,方法和制品,更具体地,涉及用于提供用于便于从一个或多个数据库表中识别相关列的机制。 一个实施例提供了一种用于在数据库表中管理具有相关测量单元的数据的存储的计算机实现的方法。 该方法包括将数据存储在数据库表的列中,以及描述测量单元的生成单位元数据。 单位元数据与数据库表的列相关联。

    Replacing an unavailable element in a query
    5.
    发明申请
    Replacing an unavailable element in a query 有权
    替换查询中不可用的元素

    公开(公告)号:US20080046420A1

    公开(公告)日:2008-02-21

    申请号:US11974073

    申请日:2007-10-11

    IPC分类号: G06F17/30

    摘要: 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.

    摘要翻译: 一种方法,装置,系统和信号承载介质,其在一个实施例中,如果所述元件不可用,但所述备份是可用的,则用查询中的元素代替备份。 如果不需要元素,也可以从查询中删除元素。 在各种实施例中,元件可以是表或用户定义的功能。 以这种方式,即使该元素不可用,查询仍然可以执行。

    System and method for managing presentation of data
    7.
    发明申请
    System and method for managing presentation of data 失效
    用于管理数据呈现的系统和方法

    公开(公告)号:US20050198011A1

    公开(公告)日:2005-09-08

    申请号:US10793417

    申请日:2004-03-04

    IPC分类号: G06F17/30

    摘要: 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.

    摘要翻译: 一种用于在显示设备上呈现数据的系统,方法和制品,更具体地,用于在显示设备上管理表格形式的数据呈现。 一个实施例提供了一种在显示设备上管理所请求数据的显示的方法。 该方法包括响应于对数据的请求,以具有根据初始顺序排列的多个列和行的表格形式接收所请求的数据; 重新排序列和行中的至少一个,其中重新排序是基于被配置为智能地布置所请求的数据到用户的规则来完成的; 并输出重新排序的请求数据以在显示装置上显示。

    Replacing an unavailable element in a query
    8.
    发明申请
    Replacing an unavailable element in a query 失效
    替换查询中不可用的元素

    公开(公告)号:US20050154709A1

    公开(公告)日:2005-07-14

    申请号:US10753514

    申请日:2004-01-08

    IPC分类号: G06F17/30

    摘要: 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.

    摘要翻译: 一种方法,装置,系统和信号承载介质,其在一个实施例中,如果所述元件不可用,但所述备份是可用的,则用查询中的元素代替备份。 如果不需要元素,也可以从查询中删除元素。 在各种实施例中,元件可以是表或用户定义的功能。 以这种方式,即使该元素不可用,查询仍然可以执行。

    Caching pages via host variable correlation
    9.
    发明申请
    Caching pages via host variable correlation 失效
    通过主机变量相关来缓存页面

    公开(公告)号:US20050114303A1

    公开(公告)日:2005-05-26

    申请号:US10691295

    申请日:2003-10-22

    IPC分类号: G06F17/30 G06F7/00

    CPC分类号: G06F17/30902

    摘要: 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.

    摘要翻译: 一种方法,装置,系统和信号承载介质,其在一个实施例中跟踪从数据库查询数据的语句的历史。 当接收到新的语句时,将搜索历史记录以查找新语句和前一语句之间的相关性。 相关性基于历史记录中的主机变量和新语句。 当找到相关性时,根据发现相关性的历史中的先前语句对下一个要接收的语句进行预测。 然后,该预测用于将数据库中的页面检索到高速缓存中,这可以由后续语句使用。