公开(公告)号：US08606749B1

公开(公告)日：2013-12-10

申请号：US12701670

申请日：2010-02-08

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

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

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

CPC分类号： G06F9/5038 ,  G06F2209/5021

摘要： A request is received at a computer programmed as a database system. The request is a request selected from the group consisting of a query and a utility. A business concept is associated with the request. The business concept is a business concept selected from the group consisting of “who” information defining the source of the request, “what” information defining the processing to be performed by the request, “where” information defining a database object that the request will affect. The computer maps the received request to a database feature setting by mapping the business concept associated with the request to a workload. The workload is defined by a workload definition including a workload classification attribute that maps to the business concept of the request, a workload throttling attribute that defines conditions under which requests assigned to the workload are throttled. Submission of the request to the database system for processing is delayed based on the workload definition.

摘要翻译： 在作为数据库系统编程的计算机上接收到请求。 请求是从由查询和实用程序组成的组中选择的请求。 业务概念与请求相关联。 业务概念是从由定义请求的源的“谁”信息组成的组中选择的业务概念，“什么”定义要由请求执行的处理的信息，其中“定义请求将要的数据库对象的信息 影响。 计算机通过将与请求相关联的业务概念映射到工作负载来将接收的请求映射到数据库特征设置。 工作负载由工作负载定义（包括映射到请求的业务概念的工作负载分类属性）定义，工作负载限制属性定义了分配给工作负载的请求受到限制的条件。 基于工作负载定义，将数据库系统提交的请求提交到处理中。

公开(公告)号：US08396860B1

公开(公告)日：2013-03-12

申请号：US12967217

申请日：2010-12-14

申请人： Bhashyam Ramesh ,  Jalprakash G. Chimanchode ,  Sai Pavan Kumar Pakala

发明人： Bhashyam Ramesh ,  Jalprakash G. Chimanchode ,  Sai Pavan Kumar Pakala

IPC分类号： G06F7/00 ,  G06F17/301

CPC分类号： G06F17/30454

摘要： A computer receives a query for optimization. The query includes a SEQUENCED join between a temporal parent table and a temporal child table. The parent table has one or more rows. The child table has one or more rows. The parent table has a Primary Key (“PK”) column having a value for each row. The parent table has a temporal dimension having a value for each row. The child table has a Foreign Key (“FK”) column having a value for each row. The child table has a temporal dimension. The child table's temporal dimension has a value for each row. The computer determines that the query, the parent table, the child table, and the join satisfy a set of CURRENT temporal join elimination criteria. The computer determines that the query, the parent table, the child table, and the join satisfy a set of SEQUENCED temporal join elimination criteria. In response, the computer eliminates the join from the query to produce an optimized form of the query. In further response, the computer executes the optimized form of the query to produce a result. The result has one or more rows. The result has one or more projected columns. The projected columns have values. The result has a temporal dimension. The result's temporal dimension has a value. In further response, the computer stores the result in a memory.

摘要翻译： 计算机接收优化查询。 该查询包括时间父表和时间子表之间的SEQUENCED连接。 父表有一行或多行。 子表具有一行或多行。 父表具有一个主键（PK）列，每列具有一个值。 父表具有每行具有值的时间维度。 子表具有每行的外键（FK）列。 小时表具有时间维度。 子表的时间维度每行都有一个值。 计算机确定查询，父表，子表和连接满足一组CURRENT时间连接消除条件。 计算机确定查询，父表，子表和连接满足一组SEQUENCED时间连接消除条件。 作为响应，计算机从查询中消除了连接以产生查询的优化形式。 在进一步的响应中，计算机执行查询的优化形式以产生结果。 结果有一行或多行。 结果有一个或多个投影柱。 投影柱有值。 结果具有时间维度。 结果的时间维度有一个价值。 在进一步的响应中，计算机将结果存储在存储器中。

公开(公告)号：US07814094B2

公开(公告)日：2010-10-12

申请号：US11535615

申请日：2006-09-27

申请人： Grace Au ,  Bhashyam Ramesh ,  Haiyan Chen

发明人： Grace Au ,  Bhashyam Ramesh ,  Haiyan Chen

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

CPC分类号： G06F17/30466

摘要： A database query is optimized for a star database schema that includes at least one fact table and at least one dimension table, where the database query includes an IN-List condition. During optimization, the IN-List is transformed into a relation and the relation is joined with the dimension table to produce a join result. The join result is then joined to the fact table.

摘要翻译： 为包含至少一个事实表和至少一个维度表的星型数据库模式优化数据库查询，其中数据库查询包含IN-List条件。 在优化期间，将IN列表转换为关系，并将关系与维度表相结合以产生连接结果。 连接结果然后被加入到事实表中。

公开(公告)号：US07647280B1

公开(公告)日：2010-01-12

申请号：US10730629

申请日：2003-12-08

申请人： Bhashyam Ramesh ,  Douglas P. Brown

发明人： Bhashyam Ramesh ,  Douglas P. Brown

IPC分类号： G06Q99/00

CPC分类号： G06F17/30424 ,  G06F17/30442 ,  G06Q30/0283

摘要： Request processing is optimized. The request has elements. The method, computer program and database system includes selecting an access path for the request taking into consideration a stored actual request element cost, processing the request using the selected access path, producing one or more actual request element costs, and storing the one or more actual request element costs.

摘要翻译： 请求处理优化。 请求有元素。 所述方法，计算机程序和数据库系统包括：考虑所存储的实际请求单元成本，使用所选择的访问路径处理所述请求，产生一个或多个实际请求单元成本，以及存储所述一个或多个 实际请求元素成本。

公开(公告)号：US07565373B2

公开(公告)日：2009-07-21

申请号：US11295777

申请日：2005-12-07

申请人： Bhashyam Ramesh ,  Pekka Kostamaa

发明人： Bhashyam Ramesh ,  Pekka Kostamaa

IPC分类号： G06F17/30

CPC分类号： G06Q10/10 ,  G06Q10/06316 ,  G06Q40/04 ,  Y10S707/99943 ,  Y10S707/99945

摘要： A method, computer system, and database system for automating a business rule in a database are disclosed. One or more database triggers associated with a business rule state machine are enabled and the business rule state machine is initialized.

摘要翻译： 公开了一种用于使数据库中的业务规则自动化的方法，计算机系统和数据库系统。 启用与业务规则状态机关联的一个或多个数据库触发器，并初始化业务规则状态机。

公开(公告)号：US20080120273A1

公开(公告)日：2008-05-22

申请号：US11600653

申请日：2006-11-16

申请人： Bhashyam Ramesh ,  Michael Warren Watzke

发明人： Bhashyam Ramesh ,  Michael Warren Watzke

IPC分类号： G06F7/00

CPC分类号： G06F16/24545 ,  G06F16/24549

摘要： A method, computer program, and system for optimizing the execution of a SQL request on a database system are disclosed. The database system has a state. The request has characteristics and the state has characteristics. The SQL request is parsed to create a logical plan. The logical plan is enumerated into a plurality of physical plans. The plurality of physical plans are costed using current environmental and data demographics of the database system to produce cost information. One of the plurality of physical plans is selected using the cost information and workload profile information to execute the request. Workload profile information includes one or more characteristics of the request and the state of the database system. The request is executed using the selected physical plan to produce results.

摘要翻译： 公开了一种用于优化数据库系统上的SQL请求的执行的方法，计算机程序和系统。 数据库系统有一个状态。 请求具有特点，状态有特点。 解析SQL请求以创建逻辑计划。 逻辑计划被列举为多个物理计划。 使用数据库系统的当前环境和数据人口统计学来计算多个物理计划以产生成本信息。 使用成本信息和工作负载配置文件信息来选择多个物理计划中的一个来执行请求。 工作负载配置文件信息包括请求的一个或多个特性和数据库系统的状态。 使用所选择的物理计划执行请求以产生结果。

公开(公告)号：US20070174278A1

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

申请号：US11622595

申请日：2007-01-12

申请人： Bhashyam Ramesh ,  Michael Watzke

发明人： Bhashyam Ramesh ,  Michael Watzke

IPC分类号： G06F7/00

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来定义逻辑分区。

公开(公告)号：US20070156724A1

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

申请号：US11608278

申请日：2006-12-08

申请人： Pekka Kostamaa ,  Bhashyam Ramesh

发明人： Pekka Kostamaa ,  Bhashyam Ramesh

IPC分类号： G06F7/00

CPC分类号： G06F16/2471

摘要： FIG. 1 illustrates a database system 1 including a storage device 2. Device 2 stores table data 3 indicative of a plurality of rows 4. A source access module 5 is assigned to access one of rows 4, this particular row being designated by reference numeral 6. Module 5 is responsive to a command 7 for reading row 6 from device 2. Subsequently, module 5 writes row 6 to device 2 in a packet accessible by a target module 8, this packet presently taking the form of a shared spool file 9.

摘要翻译： 图。 图1示出了包括存储装置2的数据库系统1。 设备2存储指示多行4的表数据3。 源访问模块5被分配用于访问行4之一，该特定行由附图标记6指定。 模块5响应于用于从设备2读取行6的命令7。 随后，模块5将第6行写入到目标模块8可访问的分组中，该分组目前采用共享的假脱机文件9的形式。

公开(公告)号：US20070067575A1

公开(公告)日：2007-03-22

申请号：US11470710

申请日：2006-09-07

申请人： John Morris ,  Bhashyam Ramesh

发明人： John Morris ,  Bhashyam Ramesh

IPC分类号： G06F12/00

CPC分类号： G06F12/0888 ,  G06F12/0866 ,  G06F12/121

摘要： A technique for use in managing a data cache involves receiving one or more data objects to be written to a storage device. A temperature value is assigned to the one or more data objects before storing the data objects in the data cache. The temperature value assigned to the one or more data objects is compared with a threshold value. A copy of the one or more data objects is stored in the data cache if the assigned temperature value exceeds the threshold value.

摘要翻译： 用于管理数据高速缓存的技术包括接收要写入存储设备的一个或多个数据对象。 在将数据对象存储在数据高速缓存中之前，将温度值分配给一个或多个数据对象。 分配给一个或多个数据对象的温度值与阈值进行比较。 如果分配的温度值超过阈值，则一个或多个数据对象的副本被存储在数据高速缓存中。

公开(公告)号：US08706769B1

公开(公告)日：2014-04-22

申请号：US12650706

申请日：2009-12-31

申请人： Like Gao ,  Bhashyam Ramesh ,  John A. Greene ,  Michael Leon Reed

发明人： Like Gao ,  Bhashyam Ramesh ,  John A. Greene ,  Michael Leon Reed

IPC分类号： G06F7/00

CPC分类号： G06F17/30339

摘要： A temporal target table stored on a computer is scanned using the computer. The temporal target table has a ValidTime dimension and a value dimension. A qualifying-row having a value dimension having a value equal to a value of a value dimension in a row-to-be-inserted is found during the scanning. The row-to-be-inserted has a ValidTime dimension and the value dimension. The qualifying-row is processed. The row-to-be-inserted is inserted in the temporal target table. A ValidTime dimension of the inserted row-to-be-inserted is set to be as the union of the ValidTime dimension of the row-to-be-inserted and the ValidTime dimension of the qualifying-row.

摘要翻译： 使用计算机扫描存储在计算机上的时间目标表。 时间目标表具有ValidTime维度和值维度。 在扫描期间发现具有值尺寸具有等于待插入行中的值尺寸的值的限定行。 要插入的行具有ValidTime维度和值维度。 合格行被处理。 要插入的行被插入到时间目标表中。 插入的待插入行的ValidTime维度被设置为被排行行的ValidTime维度与限定行的ValidTime维度的并集。