公开(公告)号：US08280867B2

公开(公告)日：2012-10-02

申请号：US11254374

申请日：2005-10-20

申请人： Douglas P. Brown ,  Bhashyam Ramesh ,  Anita Richards

发明人： Douglas P. Brown ,  Bhashyam Ramesh ,  Anita Richards

IPC分类号： G06F17/30 ,  G06F15/163 ,  G06F9/54 ,  G06F13/14

CPC分类号： G06F17/30557

摘要： A method, computer program, and database system are disclosed for identifying a second source of a request sent to a database management system by a first source. A database message is received from the first source. The database message includes a second value for a second source-identifying parameter. The second value identifies a second source. The second value for the second source-identifying parameter is stored in a log.

摘要翻译： 公开了一种用于识别由第一来源发送到数据库管理系统的请求的第二来源的方法，计算机程序和数据库系统。 从第一个源接收数据库消息。 数据库消息包括用于第二源标识参数的第二值。 第二个值标识第二个来源。 第二个源识别参数的第二个值存储在日志中。

公开(公告)号：US08005836B2

公开(公告)日：2011-08-23

申请号：US11622595

申请日：2007-01-12

申请人： Bhashyam Ramesh ,  Michael Watzke

发明人： Bhashyam Ramesh ,  Michael Watzke

IPC分类号： G06F17/30

CPC分类号： G06F17/30584 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99936

摘要： A method and system for performing logical partial declustering in a shared-nothing database environment. The solution defines a partial declustering technique that can be used to dynamically adapt the declustering of base tables or intermediate result sets. The partial declustering technique is defined to limit the number of partitions (P) involved in an operation. The technique is defined to limit the operation to a subset of the system partitioning map (SPM). There are two components: the association between the data values and partitions is altered by restricting the data values to P′ partition values where P′ is less than P; and the actual partitions of the SPM selected are then derived based on a seed derived from a dynamic parameter, such as a session number, or a static parameter, such as a table identifier. In the case of intermediate result sets the number of P′ partitions selected is a cost based decision based on the estimated number of rows in the input intermediate result sets. In the case of a base table the number of P′ partitions is selected based on the table DDL. There is no physical partitioning definitions, rather logical partitions are defined based on subsetting the SPM.

摘要翻译： 一种用于在无共享数据库环境中执行逻辑部分去聚簇的方法和系统。 该解决方案定义了一种部分去聚簇技术，可用于动态调整基表或中间结果集的去聚类。 定义了部分去聚类技术来限制操作中涉及的分区（P）的数量。 该技术被定义为将操作限制为系统分区映射（SPM）的子集。 有两个组件：通过将数据值限制为P'小于P的P'分区值来改变数据值和分区之间的关联; 并且然后基于从诸如会话号码的动态参数或诸如表标识符的静态参数导出的种子导出所选择的SPM的实际分区。 在中间结果集的情况下，所选择的P'分区的数量是基于输入中间结果集中的估计行数的基于成本的决定。 在基表的情况下，根据表DDL选择P'分区的数量。 没有物理分区定义，而是基于子集SPM来定义逻辑分区。

公开(公告)号：US07792809B2

公开(公告)日：2010-09-07

申请号：US11608407

申请日：2006-12-08

申请人： Pekka Kostamaa ,  Bhashyam Ramesh

发明人： Pekka Kostamaa ,  Bhashyam Ramesh

IPC分类号： G06F17/30

CPC分类号： G06F17/30445

摘要： There is provided a parallel database system 1. System 1 includes a storage device 2 for maintaining a plurality of rows 3. System 1 also includes a plurality of access modules 4 for accessing in parallel a respectively assigned one or more of rows 3. An interface 5 receives data 6 indicative of a table 7 defined by a selection 8 of rows 3. A processor 9 is responsive to data 6 for selectively designating table 7 to be a single-module table. In this single module table, selection 8 is collectively assigned to an owning one of modules 4, indicated by reference numeral 10.

摘要翻译： 提供了并行数据库系统1.系统1包括用于维持多行3的存储装置2.系统1还包括多个访问模块4，用于并行地访问分配给一个或多个行3的接口 5接收指示由行3的选择8定义的表7的数据6.处理器9响应于数据6，用于选择性地将表7指定为单模块表。 在该单个模块表中，选择8被共同地分配给由附图标记10表示的模块4中的所有一个。

公开(公告)号：US07613683B2

公开(公告)日：2009-11-03

申请号：US11684255

申请日：2007-03-09

申请人： Bhashyam Ramesh ,  Steven B. Cohen ,  John R. Catozzi

发明人： Bhashyam Ramesh ,  Steven B. Cohen ,  John R. Catozzi

IPC分类号： G06F17/30

CPC分类号： G06F17/3048 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99936 ,  Y10S707/99942 ,  Y10S707/99943

摘要： A method for retrieving information from a database includes identifying a cylinder. The cylinder includes a plurality of data segments. The method also includes retrieving the plurality of data segments from the cylinder during a single retrieval operation. In addition, the method includes storing the plurality of data segments in a cache.

摘要翻译： 从数据库检索信息的方法包括识别圆筒。 气缸包括多个数据段。 该方法还包括在单次检索操作期间从圆筒检索多个数据段。 此外，该方法包括将多个数据段存储在高速缓存中。

公开(公告)号：US20090064123A1

公开(公告)日：2009-03-05

申请号：US11849500

申请日：2007-09-04

申请人： Bhashyam Ramesh ,  Michael Watzke

发明人： Bhashyam Ramesh ,  Michael Watzke

IPC分类号： G06F9/44

CPC分类号： G06F8/65

摘要： There is provided a method, system and computer program for updating at least one component in a multi-component software application. The method includes receiving application data describing characteristics of the software application, receiving update data describing at least one update applicable to the software application and reviewing the application data and update data to determine whether the at least one update is applied to the software application.

摘要翻译： 提供了一种用于在多组件软件应用程序中更新至少一个组件的方法，系统和计算机程序。 所述方法包括接收描述所述软件应用的特征的应用数据，接收描述适用于所述软件应用的至少一个更新的更新数据，以及查看所述应用数据和更新数据以确定所述至少一个更新是否应用于所述软件应用。

公开(公告)号：US07395537B1

公开(公告)日：2008-07-01

申请号：US10730348

申请日：2003-12-08

申请人： Douglas P. Brown ,  Anita Richards ,  Bhashyam Ramesh ,  Caroline M. Ballinger ,  Richard D. Glick

发明人： Douglas P. Brown ,  Anita Richards ,  Bhashyam Ramesh ,  Caroline M. Ballinger ,  Richard D. Glick

IPC分类号： G06F9/46 ,  G06F7/00 ,  G06F15/16

CPC分类号： G06F17/30306 ,  Y10S707/99931 ,  Y10S707/99932

摘要： In a method, computer program and process for administering the workload of a database system as it executes one or more requests the one or more requests are sorted into one or more workload groups. Each workload group has an associated level of service desired from the database system. The one or more requests are executed in an order intended to achieve the levels of service associated with each of the workload groups. The system resources are assigned to the one or more workload groups as necessary to provide the level of service associated with each workload group. The execution of requests is monitored on a short-term basis to detect a deviation from the level of service greater than a short-term threshold. If such a deviation is detected, the assignment of system resources to workload groups is adjusted to reduce the deviation. Monitoring is also performed on a long-term basis to detect deviations from the expected level of service greater than a long-term threshold. If such a deviation is detected, the execution of requests is adjusted to better provide the expected level of service.

摘要翻译： 在一种方法中，用于在数据库系统执行一个或多个请求时管理数据库系统的工作负荷的计算机程序和过程被分类到一个或多个工作负载组中。 每个工作负载组都具有从数据库系统所需的相关级别的服务。 一个或多个请求按照旨在实现与每个工作负载组相关联的服务级别的顺序来执行。 根据需要将系统资源分配给一个或多个工作负载组，以提供与每个工作负荷组相关联的服务级别。 在短时间内监视请求的执行以检测与服务水平的偏差大于短期阈值。 如果检测到这种偏差，则调整系统资源到工作负载组的分配以减少偏差。 监测也是长期执行的，以检测与预期服务水平的偏差大于长期阈值。 如果检测到这种偏差，则调整请求的执行以更好地提供预期的服务水平。

公开(公告)号：US20070174346A1

公开(公告)日：2007-07-26

申请号：US11334615

申请日：2006-01-18

申请人： Douglas Brown ,  Anita Richards ,  Bhashyam Ramesh

发明人： Douglas Brown ,  Anita Richards ,  Bhashyam Ramesh

IPC分类号： G06F17/30

CPC分类号： G06F16/20

摘要： A method, computer program, and database system for configuring a model of a database system are disclosed. The database system has a configuration. Two or more ordered levels of configuration assistance are provided. Each of the levels offers a different combination of the following forms of assistance: no assistance, workload analysis, cost-based performance analysis, and simulation.

摘要翻译： 公开了一种用于配置数据库系统的模型的方法，计算机程序和数据库系统。 数据库系统有一个配置。 提供了两个或多个有序级别的配置帮助。 每个级别提供以下形式的帮助的不同组合：无需帮助，工作负载分析，基于成本的性能分析和模拟。

公开(公告)号：US20070143244A1

公开(公告)日：2007-06-21

申请号：US11608362

申请日：2006-12-08

申请人： Pekka Kostamaa ,  Bhashyam Ramesh

发明人： Pekka Kostamaa ,  Bhashyam Ramesh

IPC分类号： G06F17/30

CPC分类号： G06F16/24561

摘要： There is provided a database system 1 including a source cluster, in the form of a source clique 2, for providing a clique shared spool file 3. This spool file is provided for consumption by a target module 4 belonging to a target cluster, in the form of a target clique 5. A node interconnect 6 receives of spool 3, and exports the spool for consumption by module 4.

摘要翻译： 提供了数据库系统1，其包括以源组2的形式的源集群，用于提供集体共享假脱机文件3。 该假脱机文件被提供为目标组5的形式的属于目标集群的目标模块4的消耗。 节点互连6接收线轴3，并且导出线轴以供模块4消耗。

公开(公告)号：US07092954B1

公开(公告)日：2006-08-15

申请号：US10038673

申请日：2001-12-31

申请人： Bhashyam Ramesh

发明人： Bhashyam Ramesh

IPC分类号： G06F17/00

CPC分类号： G06F17/30498 ,  Y10S707/99942

摘要： A method, computer program and database system are disclosed for joining a plurality of tables T1 through TN, where each of the tables has an associated Star Map, S1 through SN, respectively. Each Star Map includes bitmap entries having locations indexed by the hash of one or more values associated with one or more join key columns of its associated table. A bitmap entry in a Star Map, if set, indicates the presence of a row in its associated table that has entries in the one or more join key columns that together hash to the location of the bitmap entry. The method includes a) performing a Boolean operation using the bitmap entries of the Star Maps S1 through SN to produce a join Star Map SJ, b) using SJ to select rows from the tables T1 through TN, and c) joining the resulting rows to produce a join result.

摘要翻译： 公开了一种用于连接多个表T 1至TN的方法，计算机程序和数据库系统，其中每个表分别具有相关联的星图，S1至SN。 每个星图包括位图条目，其位置由与其关联表的一个或多个连接键列相关联的一个或多个值的散列值索引。 星图中的位图条目（如果设置）指示在其关联表中存在一行，该行中的一个或多个连接键列中的条目一起哈希到位图条目的位置。 该方法包括：a）使用星图S 1至SN的位图条目执行布尔运算以产生连接星图SJ，b）使用SJ从表T 1至TN中选择行，以及c）将所得到的结果 行以产生连接结果。

公开(公告)号：US06957222B1

公开(公告)日：2005-10-18

申请号：US10038849

申请日：2001-12-31

申请人： Bhashyam Ramesh

发明人： Bhashyam Ramesh

IPC分类号： G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30466 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99942

摘要： A method, computer program and database system are disclosed for performing an outer join of at least a first table T1 and a second table T2. The join has join conditions. Each of the tables has an associated Star Map, S1 and S2, respectively. Each Star Map includes bitmap entries which have locations indexed by the hash of one or more values associated with one or more join key columns of its associated table. A bitmap entry in a Star Map, if set, indicates the presence of a row in its associated table that has entries in the one or more join key columns that together hash to the location of the bitmap entry. The method, computer program and database system include a) performing one or more Boolean operations using the bitmap entries of the Star Maps S1 and S2 to produce set bitmap entries in a Star Map SJ where there is a corresponding set bitmap entry in S1 and a corresponding set bitmap entry in S2, b) selecting a row from table T1 and hashing the combined entries in the one or more join key columns of the selected T1 row to identify a bitmap entry in SJ, and c) if the identified bitmap entry in SJ is not set, projecting the selected T1 row with a NULL corresponding to data from table T2. If d) the identified bitmap entry in SJ is set, performing the following: d1) if no row in T2 satisfies the join conditions and has entries in its one or more join key columns that together hash to the location of the identified set bitmap entry in SJ, projecting the selected T1 row and a NULL corresponding to data from table T2, d2) otherwise, for each row from T2 that satisfies the join condition and has entries in its one or more join key columns that together hash to the location of the identified set bitmap entry in SJ, projecting the selected T1 row with data from the row from T2, and e) repeating b)-d) for all rows in T1.

摘要翻译： 公开了一种用于执行至少第一表T1和第二表T2的外连接的方法，计算机程序和数据库系统。 连接有连接条件。 每个表分别具有相关联的星图，S1和S2。 每个星图包括位图条目，其位置由与关联表的一个或多个连接键列相关联的一个或多个值的散列进行索引。 星图中的位图条目（如果设置）指示在其关联表中存在一行，该行中的一个或多个连接键列中的条目一起哈希到位图条目的位置。 方法，计算机程序和数据库系统包括：a）使用星图S1和S2的位图条目执行一个或多个布尔运算，以在星图SJ中产生设置的位图条目，其中S1中存在相应的设置位图条目， b）从表T1中选择一行，并在所选择的T1行的一个或多个连接密钥列中散列组合的条目，以标识SJ中的位图条目，以及c）如果识别的位图条目在 未设置SJ，将所选择的T1行与对应于表T2的数据的NULL进行投影。 如果d）设置了SJ中识别的位图条目，则执行以下操作：d1）如果T2中没有行满足连接条件，并且在其一个或多个连接键列中的条目一起散列到所标识的集合位图条目的位置 在SJ中投影所选择的T1行和对应于来自表T2的数据的空值d2）否则，对于满足连接条件的T2的每一行，并且在其一个或多个连接键列中的条目一起散列到 在SJ中识别的设置位图条目，将来自T2的行的数据投影到所选择的T1行，以及e）对T1中的所有行重复b）-d）。