专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US06778976B2 Selectivity estimation for processing SQL queries containing having clauses 失效
标题翻译：用于处理包含有子句的SQL查询的选择性估计
公开(公告)号：US06778976B2
公开(公告)日：2004-08-17
申请号：US09757434
申请日：2001-01-10
申请人： Peter J. Haas , John E. Lumby , Calisto P. Zuzarte
发明人： Peter J. Haas , John E. Lumby , Calisto P. Zuzarte
IPC分类号： G06F1730
CPC分类号： G06F17/30595 , G06F17/30469 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934
摘要： The estimate of the selectivity of a HAVING clause in an SQL query is carried out within a specified time constraint by determining a selectivity estimate for each member in a sample set of group sizes for the HAVING clause using a probabilistic model based on an assumed value distribution. The selectivity estimates for the groups in the sample set are used to interpolate estimates for all possible group sizes and the estimates are combined based on an assumed known group size distribution to provide an estimation of the selectivity for the HAVING clause. Different selectivity estimating approaches are used for each group size based on available time for estimating and on the estimated time to complete the estimate using different techniques.
摘要翻译：通过使用基于假定值分布的概率模型，通过确定HAVING子句的组大小的样本集合中每个成员的选择性估计，在指定时间约束内执行SQL查询中HAVING子句的选择性估计。样本集中的组的选择性估计用于内插所有可能组大小的估计，并且基于假设的已知组大小分布来组合估计，以提供对HAVING子句的选择性的估计。基于可用的估计时间和使用不同技术完成估计的估计时间，对于每个组大小使用不同的选择性估计方法。

2. 发明授权

US09107504B2 Reclining loop frame stacking / swivel chair 有权
标题翻译：倾斜环架堆叠/转椅
公开(公告)号：US09107504B2
公开(公告)日：2015-08-18
申请号：US13894030
申请日：2013-05-14
申请人： Peter J. Haas
发明人： Peter J. Haas
IPC分类号： A47C1/023 , A47C3/04 , B62B3/00 , A47C3/021 , A47C7/44
CPC分类号： A47C1/023 , A47C3/021 , A47C3/04 , A47C7/44 , B62B3/00
摘要： A chair with a seating surface and a link with two ends connected to the seating surface. A frame with two supporting portions connected to the link and the frame can displace against a bias to allow one of the two supporting portions to move, allowing the seating surface to tilt. A flexible front is attached to a front member on the frame, the flexible front bends when the seating surface tilts. The link rotates when the supporting portions displace. The supporting portions are round and pass through round holes in the link, allowing the supporting portions to rotate within the link when the seating surface tilts. A stop connected to the seating surface and a stop connected to the frame limits the maximum tilt angle of the seating surface.
摘要翻译：具有座位表面的椅子和连接到座位表面的两端的连杆。具有连接到连杆和框架的两个支撑部分的框架可抵靠偏压移动，以允许两个支撑部分之一移动，允许就座表面倾斜。柔性前部连接到框架上的前部构件，当座椅表面倾斜时，柔性前部弯曲。当支撑部分移动时，连杆旋转。支撑部分是圆形的，并且穿过连杆中的圆形孔，当座位表面倾斜时允许支撑部分在连杆内旋转。连接到座位表面的止动件和连接到框架的止动件限制了座面的最大倾斜角度。

3. 发明授权

US08341180B1 Risk analysis for data-intensive stochastic models 失效
标题翻译：数据密集随机模型的风险分析
公开(公告)号：US08341180B1
公开(公告)日：2012-12-25
申请号：US13231792
申请日：2011-09-13
申请人： Subramanian Arumugam , Peter J. Haas , Ravindranath Chowdary Jampani , Christopher Jermaine , Luis L Perez , Fei Xu
发明人： Subramanian Arumugam , Peter J. Haas , Ravindranath Chowdary Jampani , Christopher Jermaine , Luis L Perez , Fei Xu
IPC分类号： G06F17/30
CPC分类号： G06Q10/04
摘要： A risk analysis system and method are provided. The system includes an analyzer for analyzing database instances by executing a query on each database instance and selecting a cutoff value. The analyzer also discards the sets of uncertainty data that yield query-result values below the cutoff value and retains the database instances that yield query-result values above the cutoff value as elite sets. The system also includes a cloner to replicate the elite sets, and a sampler to modify the elite sets so that each elite set is mutually statistically independent while still yielding query-result values above the cutoff value.
摘要翻译：提供了风险分析系统和方法。该系统包括一个分析器，用于通过对每个数据库实例执行查询并选择一个截止值来分析数据库实例。分析器还丢弃了不确定性数据集，这些数据使得查询结果值低于截止值，并保留了数据库实例，将查询结果值高于截止值作为精英集。该系统还包括复制精英集的克隆，以及修改精英集的采样器，使得每个精英集相互统计独立，同时仍然产生高于截止值的查询结果值。

4. 发明授权

US07827211B2 Method for maintaining a sample synopsis under arbitrary insertions and deletions 有权
标题翻译：在任意插入和缺失下维护样品概要的方法
公开(公告)号：US07827211B2
公开(公告)日：2010-11-02
申请号：US12054298
申请日：2008-03-24
申请人： Rainer Gemulla , Peter J. Haas , Wolfgang Lehner
发明人： Rainer Gemulla , Peter J. Haas , Wolfgang Lehner
IPC分类号： G06F17/30
CPC分类号： G06F17/30536 , Y10S707/99942
摘要： A method of incrementally maintaining a stable, bounded, uniform random sample S from a dataset R, in the presence of arbitrary insertions and deletions to the dataset R, and without accesses to the dataset R, comprises a random pairing method in which deletions are uncompensated until compensated by a subsequent insertion (randomly paired to the deletion) by including the insertion's item into S if and only if the uncompensated deletion's item was removed from S (i.e., was in S so that it could be removed). A method for resizing a sample to a new uniform sample of increased size while maintaining a bound on the sample size and balancing cost between dataset accesses and transactions to the dataset is also disclosed. A method for maintaining uniform, bounded samples for a dataset in the presence of growth in size of the dataset is additionally disclosed.
摘要翻译：在数据集R的任意插入和删除的存在下，并且不访问数据集R的情况下，从数据集R中增加维持稳定的，有界的均匀随机样本S的方法包括其中缺失被补偿的随机配对方法直到通过随后的插入（随机配对删除）来补偿，通过将插入的项目包含在S中，并且仅当未经补偿的删除项目从S中移除（即，在S中才能将其删除）。还公开了一种将样本调整到增加大小的新的统一样本的方法，同时保持对样本大小的限制并且将数据集访问和事务之间的成本平衡到数据集。另外公开了一种在存在数据集大小的情况下为数据集维持统一的有界样本的方法。

5. 发明授权

US07558425B1 Finding structures in multi-dimensional spaces using image-guided clustering 失效
标题翻译：使用图像引导聚类在多维空间中寻找结构
公开(公告)号：US07558425B1
公开(公告)日：2009-07-07
申请号：US12143131
申请日：2008-06-20
申请人： Tanveer Syeda-Mahmood , Peter J. Haas , John M. Lake , Guy M. Lohman
发明人： Tanveer Syeda-Mahmood , Peter J. Haas , John M. Lake , Guy M. Lohman
IPC分类号： G06K9/62 , G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06K9/6219 , Y10S707/99933 , Y10S707/99945
摘要： A data processing system is provided that comprises a processor, a random access memory for storing data and programs for execution by the processor, and computer readable instructions stored in the random access memory for execution by the processor to perform a method for clustering data points in a multidimensional dataset in a multidimensional image space. The method comprises generating a multidimensional image from the multidimensional dataset; generating a pyramid of multidimensional images having varying resolution levels by successively performing a pyramidal sub-sampling of the multidimensional image; identifying data clusters at each resolution level of the pyramid by applying a set of perceptual grouping constraints; and determining levels of a clustering hierarchy by identifying each salient bend in a variation curve of a magnitude of identified data clusters as a function of pyramid resolution level.
摘要翻译：提供了一种数据处理系统，其包括处理器，用于存储用于由处理器执行的数据和程序的随机存取存储器，以及存储在随机存取存储器中的计算机可读指令，用于由处理器执行以执行将数据点聚类的方法多维图像空间中的多维数据集。该方法包括从多维数据集生成多维图像; 通过连续执行所述多维图像的锥体子采样来生成具有不同分辨率水平的多维图像的金字塔; 通过应用一组感知分组约束来识别金字塔的每个分辨率级别的数据集群; 以及通过将所识别的数据簇的幅度的变化曲线中的每个显着弯曲值确定为金字塔分辨率级别的函数来确定聚类层级的水平。

6. 发明授权

US07542953B1 Data classification by kernel density shape interpolation of clusters 有权
标题翻译：通过核心密度形状插值进行数据分类
公开(公告)号：US07542953B1
公开(公告)日：2009-06-02
申请号：US12142949
申请日：2008-06-20
申请人： Tanveer Syeda-Mahmood , Peter J. Haas , John M. Lake , Guy M. Lohman
发明人： Tanveer Syeda-Mahmood , Peter J. Haas , John M. Lake , Guy M. Lohman
IPC分类号： G06F17/00 , G06F15/00 , G06F15/18 , G06N5/00
CPC分类号： G06K9/6273 , G06K9/6226 , G06N99/005
摘要： A data processing system is provided that comprises a processor, a random access memory for storing data and programs for execution by the processor, and computer readable instructions stored in the random access memory for execution by the processor to perform a method for obtaining a shape interpolated representation of shapes of clusters in an image of a clustered dataset. The method comprises generating a density estimate value of each grid point of a set of grid points sampled from the image at a specified resolution for each cluster using a kernel density function; evaluating the density estimate value of each grid point for each cluster to identify a maximum density estimate value of each grid point and a cluster associated with the maximum density estimate value; and adding each grid point for which the maximum density estimate value exceeds a specified threshold to the associated cluster to form a shape interpolated representation.
摘要翻译：提供了一种数据处理系统，其包括处理器，用于存储用于由处理器执行的数据和程序的随机存取存储器以及存储在随机存取存储器中的计算机可读指令，以供处理器执行以执行用于获得内插形状的方法聚类数据集的图像中的聚类形状的表示。该方法包括使用核密度函数，以每个簇的特定分辨率从图像采样的一组网格点的每个网格点的密度估计值; 评估每个簇的每个网格点的密度估计值，以识别每个网格点的最大密度估计值和与最大密度估计值相关联的簇; 并将最大密度估计值超过规定阈值的每个网格点添加到相关联的簇以形成形状插值表示。

7. 发明授权

US07536403B2 Method for maintaining a sample synopsis under arbitrary insertions and deletions 有权
标题翻译：在任意插入和缺失下维护样品概要的方法
公开(公告)号：US07536403B2
公开(公告)日：2009-05-19
申请号：US11615481
申请日：2006-12-22
申请人： Rainer Gemulla , Peter J. Haas , Wolfgang Lehner
发明人： Rainer Gemulla , Peter J. Haas , Wolfgang Lehner
IPC分类号： G06F17/30
CPC分类号： G06F17/30536 , Y10S707/99942
摘要： A method of incrementally maintaining a stable, bounded, uniform random sample S from a dataset R, in the presence of arbitrary insertions and deletions to the dataset R, and without accesses to the dataset R, comprises a random pairing method in which deletions are uncompensated until compensated by a subsequent insertion (randomly paired to the deletion) by including the insertion's item into S if and only if the uncompensated deletion's item was removed from S (i.e., was in S so that it could be removed). A method for resizing a sample to a new uniform sample of increased size while maintaining a bound on the sample size and balancing cost between dataset accesses and transactions to the dataset is also disclosed. A method for maintaining uniform, bounded samples for a dataset in the presence of growth in size of the dataset is additionally disclosed.
摘要翻译：在数据集R的任意插入和删除的存在下，并且不访问数据集R的情况下，从数据集R中增加维持稳定的，有界的均匀随机样本S的方法包括其中缺失被补偿的随机配对方法直到通过随后的插入（随机配对删除）来补偿，通过将插入的项目包含在S中，并且仅当未经补偿的删除项目从S中移除（即，在S中才能将其删除）。还公开了一种将样本调整到增加大小的新的统一样本的方法，同时保持对样本大小的限制并且将数据集访问和事务之间的成本平衡到数据集。另外公开了一种在存在数据集大小的情况下为数据集维持统一的有界样本的方法。

8. 发明授权

US07412429B1 Method for data classification by kernel density shape interpolation of clusters 有权
标题翻译：通过核心密度形状插值进行数据分类的方法
公开(公告)号：US07412429B1
公开(公告)日：2008-08-12
申请号：US11940739
申请日：2007-11-15
申请人： Tanveer Syeda-Mahmood , Peter J. Haas , John M. Lake , Guy M. Lohman
发明人： Tanveer Syeda-Mahmood , Peter J. Haas , John M. Lake , Guy M. Lohman
IPC分类号： G06F17/00 , G06N5/00
CPC分类号： G06K9/6273 , G06K9/6226 , G06N99/005
摘要： A method for obtaining a shape interpolated representation of shapes of one or more clusters in an image of a dataset that has been clustered comprises generating a density estimate value of each grid point of a set of grid points sampled from the image at a specified resolution for each cluster in the image using a kernel density function; evaluating the density estimate value of each grid point for each cluster to identify a maximum density estimate value of each grid point and a cluster associated with the maximum density estimate value of each grid point; and adding each grid point for which the maximum density estimate value exceeds a specified threshold to the cluster associated with the maximum density estimate value for the grid point to form a shape interpolated representation of the one or more clusters.
摘要翻译：一种用于获得已经聚类的数据集的图像中的一个或多个聚类的形状的形状插值表示的方法包括：以指定的分辨率生成从图像采样的一组网格点的每个网格点的密度估计值，图像中的每个簇使用核密度函数; 评估每个簇的每个网格点的密度估计值，以识别每个网格点的最大密度估计值和与每个网格点的最大密度估计值相关联的聚类; 以及将最大密度估计值超过特定阈值的每个网格点添加到与所述网格点的最大密度估计值相关联的聚类，以形成所述一个或多个聚类的形状插值表示。

9. 发明申请

US20130300079A1 Reclining loop frame stacking / swivel chair 审中-公开
公开(公告)号：US20130300079A1
公开(公告)日：2013-11-14
申请号：US13894030
申请日：2013-05-14
申请人： Peter J. Haas
发明人： Peter J. Haas
IPC分类号： A47C1/023 , B62B3/00 , A47C3/04
CPC分类号： A47C1/023 , A47C3/021 , A47C3/04 , A47C7/44 , B62B3/00
摘要： A chair with a seating surface and a link with two ends connected to the seating surface. A frame with two supporting portions connected to the link and the frame can displace against a bias to allow one of the two supporting portions to move, allowing the seating surface to tilt. A flexible front is attached to a front member on the frame, the flexible front bends when the seating surface tilts. The link rotates when the supporting portions displace. The supporting portions are round and pass through round holes in the link, allowing the supporting portions to rotate within the link when the seating surface tilts. A stop connected to the seating surface and a stop connected to the frame limits the maximum tilt angle of the seating surface.

10. 发明申请

US20110040744A1 SYSTEM, METHOD, AND APPARATUS FOR SCAN-SHARING FOR BUSINESS INTELLIGENCE QUERIES IN AN IN-MEMORY DATABASE 失效
标题翻译：用于在内存数据库中进行业务智能扫描的扫描共享的系统，方法和装置
公开(公告)号：US20110040744A1
公开(公告)日：2011-02-17
申请号：US12539471
申请日：2009-08-11
申请人： Peter J. Haas , Lin Qiao , Vijayshankar Raman , Frederick R. Reiss
发明人： Peter J. Haas , Lin Qiao , Vijayshankar Raman , Frederick R. Reiss
IPC分类号： G06F17/30
CPC分类号： G06F17/30445
摘要： A computer-implemented method for scan sharing across multiple cores in a business intelligence (BI) query. The method includes receiving a plurality of BI queries, storing a block of data in a first cache, scanning the block of data in the first cache against a first batch of queries on a first processor core, and scanning the block of data against a second batch of queries on a second processor core. The first cache is associated with a first processor core. The block of data includes a subset of data stored in an in-memory database (IMDB). The first batch of queries includes two or more of the BI queries. The second batch of queries includes one or more of the BI queries that are not included in the first batch of queries.
摘要翻译：一种用于在商业智能（BI）查询中跨多个核心进行扫描共享的计算机实现的方法。该方法包括接收多个BI查询，将数据块存储在第一高速缓存中，针对第一处理器核心上的第一批查询扫描第一高速缓存中的数据块，并且针对第二缓冲区扫描数据块批次在第二个处理器核心上的查询。第一缓存与第一处理器核心相关联。数据块包括存储在内存数据库（IMDB）中的数据子集。第一批查询包括两个或多个BI查询。第二批查询包括未包含在第一批查询中的一个或多个BI查询。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式