-
公开(公告)号：US20060271504A1
公开(公告)日：2006-11-30
申请号：US11138832
申请日：2005-05-26
IPC分类号： G06F17/30
CPC分类号： G06F17/30312
摘要： A method, apparatus, system, and signal-bearing medium that, in an embodiment, determine performance data for query optimization of a query directed to a database table having multiple partitions. The performance data for the query optimization is presented in a user interface, and an option is provided in the user interface to create a non-spanning index for any of the partitions mentioned in the performance data. In various embodiments, determining the performance data may include: determining the partitions that were unexpanded by the query optimization, determining the partitions that had a runtime estimate that was different from an actual query runtime by a threshold, determining whether any of the partitions had expansion forced by a client request, determining whether the query performed partition elimination, determining whether any of the partitions has an associated index that is unused by the query and that also has a key that is not present in all of the partitions, and determining a constraint for partition elimination.
摘要翻译： 一种方法，装置，系统和信号承载介质，其在一个实施例中确定用于针对具有多个分区的数据库表的查询的查询优化的性能数据。 查询优化的性能数据在用户界面中呈现，并且在用户界面中提供了一个选项，以便为演奏数据中提到的任何分区创建非跨度索引。 在各种实施例中，确定性能数据可以包括：确定由查询优化未展开的分区，将具有与实际查询运行时间不同的运行时间估计的分区确定为阈值，确定是否有任何分区具有扩展 通过客户端请求强制，确定查询是否执行分区消除，确定任何分区是否具有由查询未使用的关联索引，并且还具有不存在于所有分区中的密钥，以及确定约束 用于分区消除。
-
2.发明申请Method and apparatus for dynamically associating different query execution strategies with selective portions of a database table 失效用于将不同查询执行策略与数据库表的选择性部分动态关联的方法和装置公开(公告)号：US20070016558A1
公开(公告)日：2007-01-18
申请号：US11181713
申请日：2005-07-14
IPC分类号： G06F17/30
CPC分类号： G06F17/3053 , G06F17/30545
摘要： A query facility for database queries dynamically determines whether selective portions of a database table are likely to benefit from separate query execution strategies, and constructs an appropriate separate execution strategies accordingly. Preferably, the database contains at least one relatively large table comprising multiple partitions, each sharing the definitional structure of the table and containing a different respective discrete subset of the table records. The query facility compares metadata for different partitions to determine whether sufficiently large differences exist among the partitions, and in appropriate cases selects one or more partitions for separate execution strategies. Preferably, partitions are ranked for separate evaluation using a weighting formula which takes into account: (a) the number of indexes for the partition, (b) recency of change activity, and (c) the size of the partition.
摘要翻译： 用于数据库查询的查询工具动态地确定数据库表的选择性部分是否可能受益于单独的查询执行策略，并相应地构建适当的单独的执行策略。 优选地，数据库包含至少一个包括多个分区的相对较大的表，每个分区共享表的定义结构，并且包含表记录的不同相应离散子集。 查询设施比较不同分区的元数据，以确定分区之间是否存在足够大的差异，并且在适当的情况下选择一个或多个分区用于单独的执行策略。 优选地，使用考虑到的加权公式对分区进行分级评估：（a）分区的索引的数量，（b）更改活动的新近度，以及（c）分区的大小。
-
3.发明申请Method and apparatus for eliminating partitions of a database table from a join query using implicit limitations on a partition key value 审中-公开使用对分区键值的隐含限制，从连接查询中消除数据库表的分区的方法和装置公开(公告)号：US20070027860A1
公开(公告)日：2007-02-01
申请号：US11191470
申请日：2005-07-28
IPC分类号： G06F17/30
CPC分类号： G06F16/24544 , G06F16/24524
摘要： A database facility supports database join queries in a database environment having at least one database table divided into multiple partitions based on a partition key value. The facility determines whether the values in a table joined to the partitioned table place an implicit limitation on the partition key, and eliminates from query evaluation any partitions which do not satisfy the implicit limitation. Preferably, the database uses a star schema organization, in which implicit limitations in a relatively small dimension table are used to eliminate partitions in a relatively large fact table.
摘要翻译： 数据库设施支持数据库环境中的数据库连接查询，其中至少有一个基于分区键值划分成多个分区的数据库表。 该设施确定连接到分区表的表中的值是否对分区关键字产生隐式限制，并且从查询评估中排除不满足隐式限制的任何分区。 优选地，数据库使用星型模式组织，其中使用相对较小维度表中的隐含限制来消除较大事实表中的分区。
-
4.发明申请Method and apparatus for associating logical conditions with the re-use of a database query execution strategy 有权将逻辑条件与数据库查询执行策略的重用相关联的方法和装置公开(公告)号：US20060224561A1
公开(公告)日：2006-10-05
申请号：US11094655
申请日：2005-03-30
申请人： Robert Bestgen , Carol Ramler , Jeffrey Tenner
发明人： Robert Bestgen , Carol Ramler , Jeffrey Tenner
IPC分类号： G06F17/30
CPC分类号： G06F17/30457 , Y10S707/99932 , Y10S707/99933 , Y10S707/99943
摘要： A query facility for database queries saves and re-uses query execution strategies, and automatically determines whether a strategy can be re-used when an imported variable changes. The query facility automatically saves one or more logical conditions associated with the one or more imported variables in the query. When the query is reused, the logical conditions are evaluated using the imported variable values, and the previously saved execution strategy is used only if the condition or conditions are met. Preferably, the logical conditions express a range of imported variable values which are included in a database subset data structure used by the saved query execution strategy, such as a materialized query table or partitioned table. Logical conditions are preferably generated by negating the predicates from a logical expression defining the applicability of the execution strategy, inserting the negated predicates into the query, and performing a transitive closure.
摘要翻译： 数据库查询的查询功能可以保存并重新使用查询执行策略，并自动确定在导入的变量更改时是否可以重新使用策略。 查询设备自动保存与查询中的一个或多个导入的变量相关联的一个或多个逻辑条件。 当重新使用查询时，使用导入的变量值来评估逻辑条件，并且仅当满足条件或条件时才使用先前保存的执行策略。 优选地，逻辑条件表示包括在由保存的查询执行策略（例如物化查询表或分区表）使用的数据库子集数据结构中的导入变量值的范围。 逻辑条件优选地通过从定义执行策略的适用性，将否定的谓词插入到查询中并且执行传递闭包的逻辑表达式来取消谓词来产生。
-
公开(公告)号：US20080059438A1
公开(公告)日：2008-03-06
申请号：US11931900
申请日：2007-10-31
申请人： Paul Day , Robert Driesch , Randy Egan , Jeffrey Tenner
发明人： Paul Day , Robert Driesch , Randy Egan , Jeffrey Tenner
IPC分类号： G06F7/10
CPC分类号： G06F17/30445 , G06F17/30442 , G06F17/30474 , Y10S707/99932 , Y10S707/99933
摘要： A database query optimizer for a computer system having dynamically configurable logical partitions generates an optimized query strategy which is dependent on a logical partition configuration. When the query is executed, the configuration of the logical partition in which the query is executed is compared to the logical partition configuration for which the query was optimized. If the configurations are different, a new query can be automatically generated. Optimizing database queries to the current system configuration of a dynamic, logically partitioned system potentially offers greater efficiency in the execution of database queries for complex, logically partitioned systems.
-
6.发明申请公开(公告)号：US20060155830A1
公开(公告)日：2006-07-13
申请号：US10988224
申请日：2004-11-12
IPC分类号： G06F15/177 , G06F15/173
CPC分类号： G06F9/44505
摘要： 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.
摘要翻译： 提供了方法，计算机可读介质和计算机系统，用于协调多组件环境中的组件之间的配置更改。 在一个实施例中，提供了一种用于改变多组件环境中的组件的配置的方法，所述方法包括：接收对所述组件的配置改变请求; 访问在多组件环境中定义组件关系的一组中介规则; 基于接收的配置更改请求和中介规则，确定在多组件环境中的一个或多个其他组件中是否保证一个或多个相应的配置更改; 并且如果所述一个或多个相应的配置改变是有必要的，则向所述一个或多个其他组件发送一个或多个配置改变通知; 从所述一个或多个其他组件接收关于所述一个或多个配置改变通知的一个或多个响应; 以及基于从所述一个或多个其他组件接收的所述一个或多个响应，向所述组件发送配置改变响应。
-
公开(公告)号：US20060116999A1
公开(公告)日：2006-06-01
申请号：US10999487
申请日：2004-11-30
IPC分类号： G06F7/00
CPC分类号： G06F16/2428
摘要： 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.
摘要翻译： 用于查询构建的方法，系统和制品，更具体地，用于建立针对数据库中的数据的查询的查询条件。 一个实施例包括接收用于构建查询的第一查询条件的用户输入。 然后，识别用于显示用于构建查询的第二查询条件的用户可选元素。 识别哪些用户可选元素取决于第一个查询条件。 显示用于构建第二查询条件的所识别的用户可选元素。 然后，接收用户选择用于构建第二查询条件的一个或多个所显示的用户可选择元素。 第一和第二查询条件定义了用于从数据库中选择特定数据集的选择标准。 响应于基于一个或多个预定义的修改规则的第二查询条件的构建，编程地修改选择标准，从而改变特定数据集。
-
8.发明申请公开(公告)号：US20060085436A1
公开(公告)日：2006-04-20
申请号：US10965183
申请日：2004-10-14
IPC分类号： G06F7/00
CPC分类号： G06F17/30389 , G06F17/30427
摘要： 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.
摘要翻译： 提供了通过使用具有逻辑字段的条件修饰符来增强抽象查询的方法，系统和制品。 条件修饰符允许通过单个逻辑字段引用多个物理字段。 此外，条件修改器有助于在实例的基础上指定特定逻辑字段应当引用哪个物理字段或物理字段的组合的能力。
-
公开(公告)号：US20050278306A1
公开(公告)日：2005-12-15
申请号：US10857746
申请日：2004-05-28
CPC分类号： G06F16/242 , G06F16/2452
摘要： A method, system and article of manufacture for linking logical fields abstractly describing data in a database and, more particularly, for creating an abstract query using linked logical fields. One embodiment provides a method of linking logical fields abstractly describing data in a database. The method includes creating link information for a first logical field from the plurality of logical fields. The link information identifies at least one second logical field from the plurality of logical fields and an associated link type operation. The first and second logical fields are linked using the link information.
摘要翻译： 用于链接逻辑领域的方法，系统和制品，用于抽象地描述数据库中的数据，更具体地，用于使用链接的逻辑字段创建抽象查询。 一个实施例提供了一种将抽象地描述数据库中的数据的逻辑域相关联的方法。 该方法包括从多个逻辑字段创建用于第一逻辑字段的链接信息。 链接信息从多个逻辑字段和相关联的链接类型操作中识别至少一个第二逻辑字段。 使用链接信息链接第一和第二逻辑字段。
-
公开(公告)号：US20050114318A1
公开(公告)日：2005-05-26
申请号：US10723759
申请日：2003-11-26
IPC分类号： G06F7/00
CPC分类号： G06F17/30412 , G06F17/30489 , Y10S707/99932 , Y10S707/99933
摘要： 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.
摘要翻译： 一种用于处理针对数据库执行的查询的方法，系统和制品，更具体地，用于处理针对数据库执行的聚合查询。 一个实施例提供了一种构建查询的方法，所述查询选择性地能够返回与数据库中的数据相关的聚合信息。 该方法包括接收用户输入，其指定包括一个或多个逻辑字段的抽象查询的至少一个结果标准，每个逻辑字段对应于抽象地描述数据库中的数据的数据抽象模型的逻辑字段规范，每个结果标准对应于逻辑 接收用户输入，指定抽象查询的选择标准;接收用户输入，指定要针对所述至少一个结果标准执行的聚合操作，以生成聚合信息，以及将至少一个 结果标准以允许用户选择是否针对至少一个结果标准执行聚合操作的方式进行聚合操作，而不需要对抽象查询进行用户改变。
-
-
-
-
-
-
-
-
-
搜索结果
37 条记录 (耗时 0.03 秒)
