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

1. 发明授权

US10007698B2 Table parameterized functions in database 有权
公开(公告)号：US10007698B2
公开(公告)日：2018-06-26
申请号：US13687157
申请日：2012-11-28
申请人： Mark Delafranier , Jeffrey J. Plager , Muhammed Sharique , Vipul Sharma , Ivan T. Bowman , Anisoara Nica , Anil K. Goel , Steven A. Kirk
发明人： Mark Delafranier , Jeffrey J. Plager , Muhammed Sharique , Vipul Sharma , Ivan T. Bowman , Anisoara Nica , Anil K. Goel , Steven A. Kirk
IPC分类号： G06F17/30 , G06F3/0484
CPC分类号： G06F16/2453 , G06F3/0484 , G06F16/2448 , G06F16/90324 , G06F16/951
摘要： Systems, methods and computer program product embodiments for providing table parameterized function (TPF) functionality in a database are disclosed herein. An embodiment includes defining a TPF in a database, wherein the definition of the TPF defines one or more parameters of the TPF, at least one of the parameters being a table parameter. A query is received that operates to call the TPF, wherein the query defines one or more input parameters, the input parameters comprising at least one table input parameter to be used as input for calling the TPF. The query is processed to produce a result, and the result of the query is returned.

2. 发明申请

US20130138626A1 Table Parameterized Functions in Database 有权
标题翻译：数据库中的表参数化函数
公开(公告)号：US20130138626A1
公开(公告)日：2013-05-30
申请号：US13687157
申请日：2012-11-28
申请人： Mark DELAFRANIER , Jeffrey J. Plager , Muhammed Sharique , Vipul Sharma , Ivan T. Bowman , Anisoara Nica , Anil K. Goel , Steven A. Kirk
发明人： Mark DELAFRANIER , Jeffrey J. Plager , Muhammed Sharique , Vipul Sharma , Ivan T. Bowman , Anisoara Nica , Anil K. Goel , Steven A. Kirk
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , G06F3/0484 , G06F17/30421 , G06F17/30864 , G06F17/3097
摘要： Systems, methods and computer program product embodiments for providing table parameterized function (TPF) functionality in a database are disclosed herein. An embodiment includes defining a TPF in a database, wherein the definition of the TPF defines one or more parameters of the TPF, at least one of the parameters being a table parameter. A query is received that operates to call the TPF, wherein the query defines one or more input parameters, the input parameters comprising at least one table input parameter to be used as input for calling the TPF. The query is processed to produce a result, and the result of the query is returned.
摘要翻译：本文公开了用于在数据库中提供表参数化功能（TPF）功能的系统，方法和计算机程序产品实施例。实施例包括在数据库中定义TPF，其中TPF的定义定义TPF的一个或多个参数，至少一个参数是表参数。接收到操作以调用TPF的查询，其中查询定义一个或多个输入参数，输入参数包括至少一个表输入参数，以用作调用TPF的输入。处理查询以生成结果，并返回查询的结果。

3. 发明授权

US08843499B2 Accelerating database queries comprising positional text conditions plus bitmap-based conditions 有权
标题翻译：加速数据库查询，包括位置文本条件加上基于位图的条件
公开(公告)号：US08843499B2
公开(公告)日：2014-09-23
申请号：US12980446
申请日：2010-12-29
申请人： Steven A. Kirk , Roland F. McKenney , Anil K. Goel , Evguenia A. Eflov
发明人： Steven A. Kirk , Roland F. McKenney , Anil K. Goel , Evguenia A. Eflov
IPC分类号： G06F7/00
CPC分类号： G06F17/3033
摘要： A system, method, and computer program product are provided for improving performance of positional text conditions in concert with bitmap-based conditions. This is accomplished, for example, by focusing positional text condition evaluation to candidate rows based on a bitmap resulting from application of a prior condition. Additionally, the result of a positional text condition may itself be provided in the form of a bitmap to accelerate further bitmap-based condition processing.
摘要翻译：提供了一种系统，方法和计算机程序产品，用于与基于位图的条件一致地提高位置文本条件的性能。这是通过例如基于从应用先前条件导致的位图将位置文本条件评估聚焦到候选行来实现的。此外，位置文本条件的结果本身可以以位图的形式提供，以加速进一步的基于位图的条件处理。

4. 发明申请

US20120173540A1 Accelerating Database Queries Comprising Positional Text Conditions Plus Bitmap-Based Conditions 有权
标题翻译：加速数据库查询，包括位置文本条件以及基于位图的条件
公开(公告)号：US20120173540A1
公开(公告)日：2012-07-05
申请号：US12980446
申请日：2010-12-29
申请人： Steven A. Kirk , Roland F. McKenney , Anil K. Goel , Evguenia A. Eflov
发明人： Steven A. Kirk , Roland F. McKenney , Anil K. Goel , Evguenia A. Eflov
IPC分类号： G06F17/30
CPC分类号： G06F17/3033
摘要： A system, method, and computer program product are provided for improving performance of positional text conditions in concert with bitmap-based conditions. This is accomplished, for example, by focusing positional text condition evaluation to candidate rows based on a bitmap resulting from application of a prior condition. Additionally, the result of a positional text condition may itself be provided in the form of a bitmap to accelerate further bitmap-based condition processing.
摘要翻译：提供了一种系统，方法和计算机程序产品，用于与基于位图的条件一致地提高位置文本条件的性能。这是通过例如基于从应用先前条件导致的位图将位置文本条件评估聚焦到候选行来实现的。此外，位置文本条件的结果本身可以以位图的形式提供，以加速进一步的基于位图的条件处理。

5. 发明授权

US09442858B2 Solid state drives as a persistent cache for database systems 有权
标题翻译：固态驱动器作为数据库系统的持久缓存
公开(公告)号：US09442858B2
公开(公告)日：2016-09-13
申请号：US13548704
申请日：2012-07-13
申请人： Pedram Ghodsnia , Reza Sherkat , John C. Smirnios , Peter Bumbulis , Anil K. Goel
发明人： Pedram Ghodsnia , Reza Sherkat , John C. Smirnios , Peter Bumbulis , Anil K. Goel
IPC分类号： G06F12/00 , G06F12/08
CPC分类号： G06F12/0866 , G06F12/0897 , G06F2212/225
摘要： Disclosed herein are systems, methods, and computer readable storage media for a database system using solid state drives as a second level cache. A database system includes random access memory configured to operate as a first level cache, solid state disk drives configured to operate as a persistent second level cache, and hard disk drives configured to operate as disk storage. The database system also includes a cache manager configured to receive a request for a data page and determine whether the data page is in cache or disk storage. If the data page is on disk, or in the second level cache, it is copied to the first level cache. If copying the data page results in an eviction, the evicted data page is copied to the second level cache. At checkpoint, dirty pages stored in the second level cache are flushed in place in the second level cache.
摘要翻译：这里公开了用于使用固态驱动器作为第二级高速缓存的数据库系统的系统，方法和计算机可读存储介质。数据库系统包括配置为作为第一级高速缓存操作的随机存取存储器，被配置为作为持久性第二级高速缓存操作的固态磁盘驱动器和被配置为作为磁盘存储器操作的硬盘驱动器。数据库系统还包括配置为接收对数据页的请求并确定数据页是处于高速缓存还是磁盘存储中的高速缓存管理器。如果数据页面位于磁盘或二级缓存中，则将其复制到第一级缓存。如果复制数据页面导致逐出，则将逐出的数据页复制到第二级缓存。在检查点，存储在第二级缓存中的脏页被刷新到第二级缓存中。

6. 发明授权

US4742045A Glycopeptide antibiotics 失效
标题翻译：糖肽抗生素
公开(公告)号：US4742045A
公开(公告)日：1988-05-03
申请号：US891931
申请日：1986-07-30
申请人： Ashok K. Verma , Anil K. Goel , V. Arjuna Rao , Akella Venkateswarlu , Robert D. Sitrin
发明人： Ashok K. Verma , Anil K. Goel , V. Arjuna Rao , Akella Venkateswarlu , Robert D. Sitrin
IPC分类号： A61K35/74 , A61P15/00 , A61P31/04 , C07K9/00 , C12P21/02 , C12R1/01 , A61K37/00 , A23K1/00
CPC分类号： C12R1/01 , C07K9/008 , C12P21/02 , Y10S930/19 , Y10S930/27
摘要： Novel glycopeptide antibiotics of the CWI-785 complex are produced by the Actinomycete SKF-CWI-785.
摘要翻译： CWI-785复合物的新型糖肽抗生素由放线菌SKF-CWI-785生产。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式