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

1. 发明申请

US20080208822A1 ANALYTIC ENHANCEMENTS TO MODEL CLAUSE IN STRUCTURED QUERY LANGUAGE (SQL) 有权
标题翻译：对结构化查询语言（SQL）中的模型分析的分析增强
公开(公告)号：US20080208822A1
公开(公告)日：2008-08-28
申请号：US12113889
申请日：2008-05-01
申请人： Tolga Bozkaya , Andrew Witkowski
发明人： Tolga Bozkaya , Andrew Witkowski
IPC分类号： G06F7/06
CPC分类号： G06F17/30442 , G06F17/3066
摘要： A method for processing queries is provided. A database server receives and executes a query to generate a relation. The query comprises first one or more clauses and a model clause. The model clause comprises a rule that has a left-side expression and a right-side expression. In one embodiment, the right-side expression of the rule includes a window function, which specifies one or more partition columns. In an embodiment, the left-side expression comprises a for-loop predicate. The for-loop predicate is unfolded after the database server compiles the query. In one embodiment, the left-side expression of the rule comprises one or more existential predicates, where each existential predicate evaluates to a Boolean value.
摘要翻译：提供了一种处理查询的方法。数据库服务器接收并执行查询以生成关系。该查询包括第一个或多个子句和一个模型子句。模型子句包含具有左侧表达式和右侧表达式的规则。在一个实施例中，规则的右侧表达包括指定一个或多个分区列的窗口函数。在一个实施例中，左侧表达式包括for循环谓词。在数据库服务器编译查询之后展开for循环谓词。在一个实施例中，规则的左侧表达式包括一个或多个存在谓词，其中每个存在性谓词计算为布尔值。

2. 发明授权

US08037024B1 Data propagation in a multi-shard database system 有权
标题翻译：数据传播在多分片数据库系统中
公开(公告)号：US08037024B1
公开(公告)日：2011-10-11
申请号：US12133193
申请日：2008-06-04
申请人： Tolga Bozkaya , David L. Butcher , Andrew Chang Huang , Wendy Tobagus , Dan Moisa
发明人： Tolga Bozkaya , David L. Butcher , Andrew Chang Huang , Wendy Tobagus , Dan Moisa
IPC分类号： G06F17/30
CPC分类号： G06F17/30581
摘要： Methods, systems and apparatus, including computer program products, for propagating data across shards of a database system are described. According to one method, a first request that includes instructions to place a second request in a queue of a second shard is placed in a queue of a first database shard, and the change is committed to the records of the first shard. A queue processor polling the queue fetches and dispatches the first request, placing the second request in a queue of a second database shard. The second request includes instructions for making the change to the second shard. A queue processor of the second database shard polls the queue of the second database, fetches the second request, and dispatches it to make the change on the second database shard.
摘要翻译：描述了用于在数据库系统的分片上传播数据的方法，系统和装置，包括计算机程序产品。根据一种方法，包括将第二请求放置在第二分片的队列中的指令的第一请求被放置在第一数据库分片的队列中，并且改变被提交到第一分片的记录。轮询队列的队列处理器提取并分派第一个请求，将第二个请求放在第二个数据库分片的队列中。第二个请求包括对第二个分片进行更改的指令。第二数据库分片的队列处理器轮询第二个数据库的队列，获取第二个请求，并对其进行调度，以便对第二个数据库分片进行更改。

3. 发明授权

US08209284B1 Data propagation in a multi-shard database system 有权
标题翻译：数据传播在多分片数据库系统中
公开(公告)号：US08209284B1
公开(公告)日：2012-06-26
申请号：US13210511
申请日：2011-08-16
申请人： Tolga Bozkaya , David L. Butcher , Andrew Chang Huang , Wendy Tobagus , Dan Moisa
发明人： Tolga Bozkaya , David L. Butcher , Andrew Chang Huang , Wendy Tobagus , Dan Moisa
IPC分类号： G06F17/30
CPC分类号： G06F17/30581
摘要： Methods, systems and apparatus, including computer program products, for propagating data across shards of a database system are described. According to one method, a first request that includes instructions to place a second request in a queue of a second shard is placed in a queue of a first database shard, and the change is committed to the records of the first shard. A queue processor polling the queue fetches and dispatches the first request, placing the second request in a queue of a second database shard. The second request includes instructions for making the change to the second shard. A queue processor of the second database shard polls the queue of the second database, fetches the second request, and dispatches it to make the change on the second database shard.
摘要翻译：描述了用于在数据库系统的分片上传播数据的方法，系统和装置，包括计算机程序产品。根据一种方法，包括将第二请求放置在第二分片的队列中的指令的第一请求被放置在第一数据库分片的队列中，并且改变被提交到第一分片的记录。轮询队列的队列处理器提取并分派第一个请求，将第二个请求放在第二个数据库分片的队列中。第二个请求包括对第二个分片进行更改的指令。第二数据库分片的队列处理器轮询第二个数据库的队列，获取第二个请求，并对其进行调度，以便对第二个数据库分片进行更改。

4. 发明申请

US20110167094A1 ANALYTIC ENHANCEMENTS TO MODEL CLAUSE IN STRUCTURED QUERY LANGUAGE (SQL) 有权
标题翻译：对结构化查询语言（SQL）中的模型分析的分析增强
公开(公告)号：US20110167094A1
公开(公告)日：2011-07-07
申请号：US13050881
申请日：2011-03-17
申请人： Tolga Bozkaya , Andrew Witowski
发明人： Tolga Bozkaya , Andrew Witowski
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , G06F17/3066
摘要： A method for processing queries is provided. A database server receives and executes a query to generate a relation. The query comprises first one or more clauses and a model clause. The model clause comprises a rule that has a left-side expression and a right-side expression. In one embodiment, the right-side expression of the rule includes a window function, which specifies one or more partition columns. In an embodiment, the left-side expression comprises a for-loop predicate. The for-loop predicate is unfolded after the database server compiles the query. In one embodiment, the left-side expression of the rule comprises one or more existential predicates, where each existential predicate evaluates to a Boolean value.
摘要翻译：提供了一种处理查询的方法。数据库服务器接收并执行查询以生成关系。该查询包括第一个或多个子句和一个模型子句。模型子句包含具有左侧表达式和右侧表达式的规则。在一个实施例中，规则的右侧表达包括指定一个或多个分区列的窗口函数。在一个实施例中，左侧表达式包括for循环谓词。在数据库服务器编译查询之后展开for循环谓词。在一个实施例中，规则的左侧表达式包括一个或多个存在谓词，其中每个存在性谓词计算为布尔值。

5. 发明申请

US20110167091A1 ANALYTIC ENHANCEMENTS TO MODEL CLAUSE IN STRUCTURED QUERY LANGUAGE (SQL) 有权
公开(公告)号：US20110167091A1
公开(公告)日：2011-07-07
申请号：US13050883
申请日：2011-03-17
申请人： Tolga Bozkaya , Andrew Witkowski
发明人： Tolga Bozkaya , Andrew Witkowski
IPC分类号： G06F17/30
CPC分类号： G06F17/30442 , G06F17/3066
摘要： A method for processing queries is provided. A database server receives and executes a query to generate a relation. The query comprises first one or more clauses and a model clause. The model clause comprises a rule that has a left-side expression and a right-side expression. In one embodiment, the right-side expression of the rule includes a window function, which specifies one or more partition columns. In an embodiment, the left-side expression comprises a for-loop predicate. The for-loop predicate is unfolded after the database server compiles the query. In one embodiment, the left-side expression of the rule comprises one or more existential predicates, where each existential predicate evaluates to a Boolean value.

6. 发明授权

US07761403B2 Run-time optimizations of queries with SQL spreadsheet 有权
标题翻译：使用SQL电子表格对查询的运行时优化
公开(公告)号：US07761403B2
公开(公告)日：2010-07-20
申请号：US10703412
申请日：2003-11-06
申请人： Andrew Witkowski , Srikanth Bellamkonda , Tolga Bozkaya , Abhinav Gupta , Nathan Folkert , Sankar Subramanian
发明人： Andrew Witkowski , Srikanth Bellamkonda , Tolga Bozkaya , Abhinav Gupta , Nathan Folkert , Sankar Subramanian
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , Y10S707/99932 , Y10S707/99934 , Y10S707/99937 , Y10S707/99938 , Y10S707/99939
摘要： Described herein are optimizations and execution strategies for spreadsheet extensions to SQL. The partitioning of data, as specified in a spreadsheet clause, provides a way to parallelize the computation of spreadsheet and to provide and improve scalability. Even if the partitioning is not explicitly specified in the spreadsheet clause, the database optimizer can automatically infer the partitioning in some cases. Efficient hash based access structures on relations can be used for symbolic array addressing, enabling fast computation of formulas. When rewriting SQL statements, formulas whose results are not referenced in outer blocks can be removed from the spreadsheet clause, thus removing unnecessary computations. The predicates from other query blocks can be moved inside query blocks with spreadsheets clauses, thus considerably reducing the amount of data to be processed. Conditions for validity of this transformation are given.
摘要翻译：这里描述的是针对SQL的电子表格扩展的优化和执行策略。如电子表格条款中规定的数据分区提供了一种并行化电子表格计算并提供和提高可扩展性的方法。即使在电子表格子句中未明确指定分区，数据库优化器也可以在某些情况下自动推断分区。关于关系的高效的基于散列的访问结构可以用于符号阵列寻址，从而能够快速计算公式。重写SQL语句时，可以从spreadsheet子句中删除其外部块中未引用其结果的公式，从而消除不必要的计算。来自其他查询块的谓词可以使用电子表格子句移动到查询块内，从而大大减少要处理的数据量。给出了这种转换的有效性条件。

7. 发明授权

US07177855B2 Compile-time optimizations of queries with SQL spreadsheet 有权
标题翻译：使用SQL电子表格对查询进行编译时优化
公开(公告)号：US07177855B2
公开(公告)日：2007-02-13
申请号：US10704192
申请日：2003-11-06
申请人： Andrew Witkowski , Srikanth Bellamkonda , Tolga Bozkaya , Abhinav Gupta , Nathan Folkert , Sankar Subramanian
发明人： Andrew Witkowski , Srikanth Bellamkonda , Tolga Bozkaya , Abhinav Gupta , Nathan Folkert , Sankar Subramanian
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/246 , G06F17/30386 , G06F17/30412 , G06F17/30592 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935
摘要： Described herein are optimizations and execution strategies for spreadsheet extensions to SQL. The partitioning of data, as specified in a spreadsheet clause, provides a way to parallelize the computation of spreadsheet and to provide and improve scalability. Even if the partitioning is not explicitly specified in the spreadsheet clause, the database optimizer can automatically infer the partitioning in some cases. Efficient hash based access structures on relations can be used for symbolic array addressing, enabling fast computation of formulas. When rewriting SQL statements, formulas whose results are not referenced in outer blocks can be removed from the spreadsheet clause, thus removing unnecessary computations. The predicates from other query blocks can be moved inside query blocks with spreadsheets clauses, thus considerably reducing the amount of data to be processed. Conditions for validity of this transformation are given.
摘要翻译：这里描述的是针对SQL的电子表格扩展的优化和执行策略。如电子表格条款中规定的数据分区提供了一种并行化电子表格计算并提供和提高可扩展性的方法。即使在电子表格子句中未明确指定分区，数据库优化器也可以在某些情况下自动推断分区。关于关系的高效的基于散列的访问结构可以用于符号阵列寻址，从而能够快速计算公式。重写SQL语句时，可以从spreadsheet子句中删除其外部块中未引用其结果的公式，从而消除不必要的计算。来自其他查询块的谓词可以使用电子表格子句移动到查询块内，从而大大减少要处理的数据量。给出了这种转换的有效性条件。

8. 发明授权

US08468166B2 Analytic enhancements to model clause in structured query language (SQL) 有权
标题翻译：结构化查询语言（SQL）中的模型子句的分析增强
公开(公告)号：US08468166B2
公开(公告)日：2013-06-18
申请号：US13050883
申请日：2011-03-17
申请人： Tolga Bozkaya , Andrew Witkowski
发明人： Tolga Bozkaya , Andrew Witkowski
IPC分类号： G06F7/00 , G06F17/30 , G06F17/00
CPC分类号： G06F17/30442 , G06F17/3066
摘要： A method for processing queries is provided. A database server receives and executes a query to generate a relation. The query comprises first one or more clauses and a model clause. The model clause comprises a rule that has a left-side expression and a right-side expression. In one embodiment, the right-side expression of the rule includes a window function, which specifies one or more partition columns. In an embodiment, the left-side expression comprises a for-loop predicate. The for-loop predicate is unfolded after the database server compiles the query. In one embodiment, the left-side expression of the rule comprises one or more existential predicates, where each existential predicate evaluates to a Boolean value.
摘要翻译：提供了一种处理查询的方法。数据库服务器接收并执行查询以生成关系。该查询包括第一个或多个子句和一个模型子句。模型子句包含具有左侧表达式和右侧表达式的规则。在一个实施例中，规则的右侧表达包括指定一个或多个分区列的窗口函数。在一个实施例中，左侧表达式包括for循环谓词。在数据库服务器编译查询之后展开for循环谓词。在一个实施例中，规则的左侧表达式包括一个或多个存在谓词，其中每个存在性谓词计算为布尔值。

9. 发明授权

US08443006B1 Data propagation in a multi-shard database system 有权
标题翻译：数据传播在多分片数据库系统中
公开(公告)号：US08443006B1
公开(公告)日：2013-05-14
申请号：US13525561
申请日：2012-06-18
申请人： Tolga Bozkaya , David L. Butcher , Andrew Chang Huang , Wendy Tobagus , Dan Moisa
发明人： Tolga Bozkaya , David L. Butcher , Andrew Chang Huang , Wendy Tobagus , Dan Moisa
IPC分类号： G06F17/30
CPC分类号： G06F17/30581
摘要： Methods, systems and apparatus, including computer program products, for propagating data across shards of a database system are described. According to one method, a first request that includes instructions to place a second request in a queue of a second shard is placed in a queue of a first database shard, and the change is committed to the records of the first shard. A queue processor polling the queue fetches and dispatches the first request, placing the second request in a queue of a second database shard. The second request includes instructions for making the change to the second shard. A queue processor of the second database shard polls the queue of the second database, fetches the second request, and dispatches it to make the change on the second database shard.
摘要翻译：描述了用于在数据库系统的分片上传播数据的方法，系统和装置，包括计算机程序产品。根据一种方法，包括将第二请求放置在第二分片的队列中的指令的第一请求被放置在第一数据库分片的队列中，并且改变被提交到第一分片的记录。轮询队列的队列处理器提取并分派第一个请求，将第二个请求放在第二个数据库分片的队列中。第二个请求包括对第二个分片进行更改的指令。第二数据库分片的队列处理器轮询第二个数据库的队列，获取第二个请求，并对其进行调度，以便对第二个数据库分片进行更改。

10. 发明授权

US08156145B2 Analytic enhancements to model clause in structured query language (SQL) 有权
标题翻译：结构化查询语言（SQL）中的模型子句的分析增强
公开(公告)号：US08156145B2
公开(公告)日：2012-04-10
申请号：US13050881
申请日：2011-03-17
申请人： Tolga Bozkaya , Andrew Witkowski
发明人： Tolga Bozkaya , Andrew Witkowski
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30442 , G06F17/3066
摘要： A method for processing queries is provided. A database server receives and executes a query to generate a relation. The query comprises first one or more clauses and a model clause. The model clause comprises a rule that has a left-side expression and a right-side expression. In one embodiment, the right-side expression of the rule includes a window function, which specifies one or more partition columns. In an embodiment, the left-side expression comprises a for-loop predicate. The for-loop predicate is unfolded after the database server compiles the query. In one embodiment, the left-side expression of the rule comprises one or more existential predicates, where each existential predicate evaluates to a Boolean value.
摘要翻译：提供了一种处理查询的方法。数据库服务器接收并执行查询以生成关系。该查询包括第一个或多个子句和一个模型子句。模型子句包含具有左侧表达式和右侧表达式的规则。在一个实施例中，规则的右侧表达包括指定一个或多个分区列的窗口函数。在一个实施例中，左侧表达式包括for循环谓词。在数据库服务器编译查询之后展开for循环谓词。在一个实施例中，规则的左侧表达式包括一个或多个存在谓词，其中每个存在性谓词计算为布尔值。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式