公开(公告)号：US20160378829A1

公开(公告)日：2016-12-29

申请号：US14753179

申请日：2015-06-29

Applicant: Oracle International Corporation

Inventor： David VENGEROV ,  Mohamed ZAIT ,  Sunil P. CHAKKAPPEN ,  Andre MENCK

IPC: G06F17/30

CPC classification number: G06F16/24545

Abstract: A system performs database management. The system receives a request for a query of a plurality of tables under a join condition on an attribute and determines a uniform mapping that maps a domain of the attribute into a set of numbers, where the domain of the attribute includes all attribute values taken by the attribute in the tables. Then, for a row in a table, the system includes the row into a synopsis of the table if the row includes an attribute value that is mapped by the uniform mapping to a number less than an inclusion probability associated with the table. The system obtains a plurality of synopsis for the tables by repeating the including for all rows in the table and for all tables, and determines, based on the plurality of synopsis, an estimate join size of the tables under the join condition.

Abstract translation: 系统执行数据库管理。 系统在属性的接合条件下接收对多个表的查询的请求，并且确定将属性的域映射成一组数字的统一映射，其中属性的域包括由 表中的属性。 然后，对于表中的一行，如果行包含通过统一映射映射到小于与表相关联的包含概率的数字的属性值，则系统将行包含在表的概要中。 系统通过对表中的所有行重复包括表和所有表来获得表的多个概要，并且基于多个概要确定在连接条件下的表的估计连接大小。

公开(公告)号：US20150363291A1

公开(公告)日：2015-12-17

申请号：US14302675

申请日：2014-06-12

Applicant: Oracle International Corporation

Inventor： David VENGEROV ,  Douglas NEALE

IPC: G06F11/34 ,  G06F11/30 ,  G06F9/50

CPC classification number: G06F11/3433 ,  G06F11/3452 ,  G06F17/30 ,  G06F17/30424 ,  G06F2201/875

Abstract: A system optimizes a number of shared server processes executing on a processor. The system creates, in a memory, a data array for storing a plurality of performance metric values, each associated with a number of shared server processes. The system selects a value for an optimized number of shared server processes according to a first procedure based on the performance metric, observes a performance metric associated with the selected optimized number, and stores, in the data array, the observed performance metric. The system repeats the selecting, observing and storing until at least a predetermined number of contiguous data values are stored in the data array. The system selects the value for the optimized number according to a second procedure based on a slope of the performance metric. The system observes the performance metric associated with the selected optimized number, and stores, in the data array, the observed performance metric.

Abstract translation: 系统优化在处理器上执行的多个共享服务器进程。 该系统在存储器中创建用于存储多个性能度量值的数据阵列，每个与多个共享服务器进程相关联。 系统根据性能度量根据第一过程选择优化数量的共享服务器进程的值，观察与所选择的优化数量相关联的性能度量，并在数据阵列中存储观察到的性能度量。 系统重复选择，观察和存储，直到至少预定数量的连续数据值被存储在数据阵列中。 系统根据性能度量的斜率根据第二个过程选择优化数量的值。 系统观察与所选优化数字相关联的性能度量，并在数据阵列中存储观察到的性能指标。

公开(公告)号：US20140358600A1

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

申请号：US13905256

申请日：2013-05-30

Applicant: Oracle International Corporation

Inventor： David VENGEROV

IPC: G06Q10/06

CPC classification number: G06Q10/043

Abstract: A system is provided that that generates an optimal item placement for one or more items. The system receives one or more items, where each item includes an item height and an item width. The system further receives a container, where the container comprises a container height and a container width. The system further generates a number of copies for each item and a position within the container for each copy of each item, where each copy of each item is placed at the corresponding position within the container. The system further outputs the number of copies for each item and the position within the container for each copy of each item.

Abstract translation: 提供一种系统，其为一个或多个项目生成最佳项目位置。 系统接收一个或多个项目，其中每个项目包括项目高度和项目宽度。 该系统还容纳容器，其中容器包括容器高​​度和容器宽度。 该系统还为每个物品的每个副本生成多个副本以及每个物品的每个副本的容器内的位置，其中每个物品的每个副本都放置在容器内的对应位置。 系统还会为每个项目的每个副本输出每个项目的份数和容器内的位置。

公开(公告)号：US20180089275A1

公开(公告)日：2018-03-29

申请号：US15275711

申请日：2016-09-26

Applicant: Oracle International Corporation

Inventor： David VENGEROV

IPC: G06F17/30 ,  G06F11/30

CPC classification number: G06F11/3075 ,  G06F16/2358 ,  G06Q30/0201

Abstract: A system is provided that generates a list of most common items and respective item frequencies from a data set that includes a plurality of items. The system creates a first list of items from the data set and monitors an estimate count for each item in the first list, where the first list is sorted by the estimate count. The system further transfers items that exceed a threshold hit count from the first list to a second list. The system further monitors a hit count for the items in the second list, where the items in the second list are sorted by the hit count. The system further transfers the items that are displaced from the second list back to the first list.

公开(公告)号：US20130275277A1

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

申请号：US13673347

申请日：2012-11-09

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Kresimir MIHIC ,  Andrew VAKHUTINSKY ,  David VENGEROV

IPC: G06Q10/06

CPC classification number: G06Q10/06313 ,  G06Q10/04 ,  G06Q30/06

Abstract: A system for optimizing shelf space placement for a product receives decision variables and constraints, and executes a Randomized Search (“RS”) using the decision variables and constraints until an RS solution is below a pre-determined improvement threshold. The system then solves a Mixed-Integer Linear Program (“MILP”) problem using the decision variables and constraints, and using the RS solution as a starting point, to generate a MILP solution. The system repeats the RS executing and MILP solving as long as the MILP solution is not within a predetermined accuracy or does not exceed a predetermined time duration. The system then, based on the final MILP solution, outputs a shelf position and a number of facings for the product.

Abstract translation: 用于优化产品的货架空间布局的系统接收决策变量和约束，并且使用决策变量和约束来执行随机搜索（“RS”），直到RS解低于预定的改进阈值。 系统然后使用决策变量和约束解决混合整数线性规划（“MILP”）问题，并使用RS解决方案作为起点，以生成MILP解决方案。 只要MILP解决方案不在预定精度内或者不超过预定的持续时间，则该系统重复RS执行和MILP求解。 然后，系统基于最终的MILP解决方案，输出产品的货架位置和多个面板。