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

1. 发明授权

US07376656B2 System and method for providing user defined aggregates in a database system 有权
标题翻译：在数据库系统中提供用户定义的聚合的系统和方法
公开(公告)号：US07376656B2
公开(公告)日：2008-05-20
申请号：US10775982
申请日：2004-02-10
申请人： Jose A. Blakeley , Hongang Zhang , Balaji Rathakrishnan , Ramachandran Venkatesh , Beysim Sezgin , Alexios Boukouvalas , Cesar A. Galindo-Legaria , Peter A. Carlin
发明人： Jose A. Blakeley , Hongang Zhang , Balaji Rathakrishnan , Ramachandran Venkatesh , Beysim Sezgin , Alexios Boukouvalas , Cesar A. Galindo-Legaria , Peter A. Carlin
IPC分类号： G06F7/00 , G07F17/00
CPC分类号： G06F17/30607 , G06F17/30412 , G06F17/30421 , Y10S707/955 , Y10S707/99944
摘要： A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined aggregate and methods that can be invoked on instances of the user-defined aggregate. The class is then registered with the database system, which enforces a specific contract for user-defined aggregates against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined aggregate in a database store. Second, the class must comprise certain specified methods that can be invoked on an instance of the class. Once these requirements are satisfied, the database system enables instances of the user-defined aggregate to be created. Preferably, the database system stores metadata about the user-defined aggregate for subsequent use in creating instances of the aggregate.
摘要翻译：数据库系统和方法允许用户以高级编程语言编写程序代码，该语言实现定义用户定义聚合的结构的类，以及可以在用户定义聚合的实例上调用的方法。该类然后向数据库系统注册，该数据库系统针对类强制执行用户定义的聚合的特定合同。合同包括以下要求。首先，类必须为数据库存储中用户定义聚合的持久化实例指定多种不同格式之一。第二，类必须包含可以在类的实例上调用的某些指定方法。一旦满足这些要求，数据库系统就可以创建用户定义聚合的实例。优选地，数据库系统存储关于用户定义聚合的元数据，用于随后用于创建聚合的实例。

2. 发明申请

US20050177579A1 System and method for providing user defined aggregates in a database system 有权
标题翻译：在数据库系统中提供用户定义的聚合的系统和方法
公开(公告)号：US20050177579A1
公开(公告)日：2005-08-11
申请号：US10775982
申请日：2004-02-10
申请人： Jose Blakeley , Hongang Zhang , Balaji Rathakrishnan , Ramachandran Venkatesh , Beysim Sezgin , Alexios Boukouvalas , Cesar Galindo-Legaria , Peter Carlin
发明人： Jose Blakeley , Hongang Zhang , Balaji Rathakrishnan , Ramachandran Venkatesh , Beysim Sezgin , Alexios Boukouvalas , Cesar Galindo-Legaria , Peter Carlin
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30607 , G06F17/30412 , G06F17/30421 , Y10S707/955 , Y10S707/99944
摘要： A database system and method allows a user to write program code in a high-level programming language that implements a class that defines the structure of a user-defined aggregate and methods that can be invoked on instances of the user-defined aggregate. The class is then registered with the database system, which enforces a specific contract for user-defined aggregates against the class. The contract comprises the following requirements. First, the class must specify one of a plurality of different formats for persisting instances of the user-defined aggregate in a database store. Second, the class must comprise a first method that can be invoked to initialize the computation of an instance of the user-defined aggregate, a second method that can be invoked to accumulate a plurality of values to be aggregated with the user-defined aggregate, a third method that can be invoked to merge an instance of the user-defined aggregate with another partial aggregation, and a fourth method that can be invoked to compute a final result of an instance of the user-defined aggregate. Once these requirements are satisfied, the database system enables instances of the user-defined aggregate to be created. Preferably, the database system stores metadata about the user-defined aggregate for subsequent use in creating instances of the aggregate.
摘要翻译：数据库系统和方法允许用户以高级编程语言编写程序代码，该语言实现定义用户定义聚合的结构的类，以及可以在用户定义聚合的实例上调用的方法。该类然后向数据库系统注册，该数据库系统针对类强制执行用户定义的聚合的特定合同。合同包括以下要求。首先，类必须为数据库存储中用户定义聚合的持久化实例指定多种不同格式之一。第二，类必须包括可被调用以初始化用户定义聚合的实例的计算的第一方法，可以被调用以累积要与用户定义的聚合聚合的多个值的第二方法，可以调用以将用户定义聚合的实例与另一部分聚合合并的第三种方法，以及可以调用以计算用户定义聚合的实例的最终结果的第四种方法。一旦满足这些要求，数据库系统就可以创建用户定义聚合的实例。优选地，数据库系统存储关于用户定义聚合的元数据，用于随后用于创建聚合的实例。

3. 发明申请

US20050102613A1 Generating a hierarchical plain-text execution plan from a database query 有权
标题翻译：从数据库查询生成分层明文执行计划
公开(公告)号：US20050102613A1
公开(公告)日：2005-05-12
申请号：US10704480
申请日：2003-11-07
申请人： Alexios Boukouvalas , Lubor Kollar , Jinghao Liu , Arunprasad Marathe
发明人： Alexios Boukouvalas , Lubor Kollar , Jinghao Liu , Arunprasad Marathe
IPC分类号： G06F17/22 , G06F17/30 , G06F17/21
CPC分类号： G06F17/30436 , G06F17/2247 , Y10S707/99934
摘要： A system, method and computer-readable medium containing computer-executable instructions for tuning queries is provided. A query processor converts a query into an execution plan in a hierarchical format that conforms to a standardized schema. In one embodiment of the invention, the hierarchical format employed is XML.
摘要翻译：提供了一种包含用于调优查询的计算机可执行指令的系统，方法和计算机可读介质。查询处理器将查询转换为符合标准模式的分层格式的执行计划。在本发明的一个实施例中，采用的分层格式是XML。

4. 发明授权

US07167848B2 Generating a hierarchical plain-text execution plan from a database query 有权
标题翻译：从数据库查询生成分层明文执行计划
公开(公告)号：US07167848B2
公开(公告)日：2007-01-23
申请号：US10704480
申请日：2003-11-07
申请人： Alexios Boukouvalas , Lubor J. Kollar , Jinghao Liu , Arunprasad P. Marathe
发明人： Alexios Boukouvalas , Lubor J. Kollar , Jinghao Liu , Arunprasad P. Marathe
IPC分类号： G06F17/00 , G06N5/00
CPC分类号： G06F17/30436 , G06F17/2247 , Y10S707/99934
摘要： A system, method and computer-readable medium containing computer-executable instructions for tuning queries is provided. A query processor converts a query into an execution plan in a hierarchical format that conforms to a standardized schema. In one embodiment of the invention, the hierarchical format employed is XML.
摘要翻译：提供了一种包含用于调优查询的计算机可执行指令的系统，方法和计算机可读介质。查询处理器将查询转换为符合标准模式的分层格式的执行计划。在本发明的一个实施例中，采用的分层格式是XML。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式