公开(公告)号：US09135310B2

公开(公告)日：2015-09-15

申请号：US13754411

申请日：2013-01-30

申请人： Nikita Shamgunov ,  Ankur Goyal ,  Alex Skidanov

发明人： Nikita Shamgunov ,  Ankur Goyal ,  Alex Skidanov

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30545

摘要： A distributed query system includes a distributed collection of dynamically created compiled queries. As each client submits a query, a parameterized query skeleton is identified, which identifies the general form of the query, and the parameters associated with the particular query. If a compiled form of the skeletal query is available within the distributed system, it is executed with the parameters of the current query. If the compiled form of the skeletal query is not available within the distributed system, a compiled form is created, and the location of this compiled skeletal query is stored for subsequent access by this client, or other clients. The executable compiled skeletal queries may be stored at each client system, in a commonly available server storage system, or within one or more database servers. A routing system may be provided to efficiently route parameterized queries to the appropriate location(s) of the compiled skeletal query.

摘要翻译： 分布式查询系统包括动态创建的编译查询的分布式集合。 当每个客户端提交查询时，标识参数化查询框架，其标识查询的一般形式以及与特定查询相关联的参数。 如果骨架查询的编译形式在分布式系统中可用，则使用当前查询的参数执行。 如果骨骼查询的编译形式在分布式系统中不可用，则会创建一个编译表单，并且存储此编译的骨架查询的位置，以供该客户端或其他客户端随后访问。 可执行编译的骨架查询可以存储在每个客户端系统，通常可用的服务器存储系统中，或者在一个或多个数据库服务器内。 可以提供路由系统以有效地将参数化的查询路由到编译的骨架查询的适当位置。

公开(公告)号：US20130198232A1

公开(公告)日：2013-08-01

申请号：US13754411

申请日：2013-01-30

申请人： Nikita SHAMGUNOV ,  Ankur Goyal ,  Alex Skidanov

发明人： Nikita SHAMGUNOV ,  Ankur Goyal ,  Alex Skidanov

IPC分类号： G06F17/30

CPC分类号： G06F17/30545

摘要： A distributed query system includes a distributed collection of dynamically created compiled queries. As each client submits a query, a parameterized query skeleton is identified, which identifies the general form of the query, and the parameters associated with the particular query. If a compiled form of the skeletal query is available within the distributed system, it is executed with the parameters of the current query. If the compiled form of the skeletal query is not available within the distributed system, a compiled form is created, and the location of this compiled skeletal query is stored for subsequent access by this client, or other clients. The executable compiled skeletal queries may be stored at each client system, in a commonly available server storage system, or within one or more database servers. A routing system may be provided to efficiently route parameterized queries to the appropriate location(s) of the compiled skeletal query.

摘要翻译： 分布式查询系统包括动态创建的编译查询的分布式集合。 当每个客户端提交查询时，标识参数化查询框架，其标识查询的一般形式以及与特定查询相关联的参数。 如果骨架查询的编译形式在分布式系统中可用，则使用当前查询的参数执行。 如果骨骼查询的编译形式在分布式系统中不可用，则会创建一个编译表单，并且存储此编译的骨架查询的位置，以供该客户端或其他客户端随后访问。 可执行编译的骨架查询可以存储在每个客户端系统，通常可用的服务器存储系统中，或者在一个或多个数据库服务器内。 可以提供路由系统以有效地将参数化的查询路由到编译的骨架查询的适当位置。

公开(公告)号：US09141678B2

公开(公告)日：2015-09-22

申请号：US13754371

申请日：2013-01-30

申请人： Alex Skidanov ,  Marko Tintor ,  Nikita Shamgunov

发明人： Alex Skidanov ,  Marko Tintor ,  Nikita Shamgunov

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30545

摘要： A distributed query system includes a distributed collection of dynamically created compiled queries. As each client submits a query, a parameterized query skeleton is identified, which identifies the general form of the query, and the parameters associated with the particular query. If a compiled form of the skeletal query is available within the distributed system, it is executed with the parameters of the current query. If the compiled form of the skeletal query is not available within the distributed system, a compiled form is created, and the location of this compiled skeletal query is stored for subsequent access by this client, or other clients. The executable compiled skeletal queries may be stored at each client system, or in a commonly available server storage system.

摘要翻译： 分布式查询系统包括动态创建的编译查询的分布式集合。 当每个客户端提交查询时，标识参数化查询框架，其标识查询的一般形式以及与特定查询相关联的参数。 如果骨架查询的编译形式在分布式系统中可用，则使用当前查询的参数执行。 如果骨骼查询的编译形式在分布式系统中不可用，则会创建一个编译表单，并且存储此编译的骨架查询的位置，以供该客户端或其他客户端随后访问。 可执行编译的骨架查询可以存储在每个客户端系统或者在通常可用的服务器存储系统中。

公开(公告)号：US20130198231A1

公开(公告)日：2013-08-01

申请号：US13754371

申请日：2013-01-30

申请人： Alex Skidanov ,  Marko Tintor ,  Nikita Shamgunov

发明人： Alex Skidanov ,  Marko Tintor ,  Nikita Shamgunov

IPC分类号： G06F17/30

CPC分类号： G06F17/30545

摘要： A distributed query system includes a distributed collection of dynamically created compiled queries. As each client submits a query, a parameterized query skeleton is identified, which identifies the general form of the query, and the parameters associated with the particular query. If a compiled form of the skeletal query is available within the distributed system, it is executed with the parameters of the current query. If the compiled form of the skeletal query is not available within the distributed system, a compiled form is created, and the location of this compiled skeletal query is stored for subsequent access by this client, or other clients. The executable compiled skeletal queries may be stored at each client system, or in a commonly available server storage system.

摘要翻译： 分布式查询系统包括动态创建的编译查询的分布式集合。 当每个客户端提交查询时，标识参数化查询框架，其标识查询的一般形式以及与特定查询相关联的参数。 如果骨架查询的编译形式在分布式系统中可用，则使用当前查询的参数执行。 如果骨骼查询的编译形式在分布式系统中不可用，则会创建一个编译表单，并且存储此编译的骨架查询的位置，以供该客户端或其他客户端随后访问。 可执行编译的骨架查询可以存储在每个客户端系统或者在通常可用的服务器存储系统中。

公开(公告)号：US09223805B2

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

申请号：US13754301

申请日：2013-01-30

申请人： Alex Skidanov ,  Marko Tintor ,  Adam Prout

发明人： Alex Skidanov ,  Marko Tintor ,  Adam Prout

IPC分类号： G06F7/00 ,  G06F17/30 ,  G06F11/14

CPC分类号： G06F17/30289 ,  G06F11/1446 ,  G06F11/1471 ,  G06F2201/80 ,  G06F2201/84

摘要： A database durability implementation records only committed transactions in a log file. A pair of log files and a pair of snapshot files are maintained. When a snapshot of the database is completed, the ‘current’ log becomes the ‘prior’ log and the other log becomes the ‘current’ log. After the next snapshot is completed, the prior log and prior snapshot may be deleted. Transactions that are not committed are not recorded in the current log, thereby avoiding the need to undo aborted transactions. If a given change is reflected in a completed snapshot, it does not appear in either of the logs; if the change is not yet reflected in a completed snapshot, it is guaranteed to be stored in one of the logs. During recovery, the system assesses both snapshots. The most recent of the completed snapshots is used, and the corresponding log(s) is (are) applied.

摘要翻译： 数据库耐久性实现只记录日志文件中提交的事务。 一对日志文件和一对快照文件被维护。 当数据库的快照完成时，“当前”日志成为“先前”日志，其他日志成为“当前”日志。 下一个快照完成后，先前的日志和先前的快照可能会被删除。 未提交的事务不会记录在当前日志中，从而避免了撤消中止事务的需要。 如果给定的更改反映在完成的快照中，则它不会显示在任一日志中; 如果更改尚未反映在完成的快照中，则保证将其存储在其中一个日志中。 在恢复期间，系统会评估两个快照。 最近使用完成的快照，并应用相应的日志。

公开(公告)号：US20130198166A1

公开(公告)日：2013-08-01

申请号：US13754333

申请日：2013-01-30

申请人： Adam PROUT ,  Marko Tintor ,  Alex Skidanov

发明人： Adam PROUT ,  Marko Tintor ,  Alex Skidanov

IPC分类号： G06F17/30

CPC分类号： G06F17/30442 ,  G06F17/30433

摘要： A system and method for executing query plans preprocesses a user's queries to identify and extract select parameters of the query, creates a skeletal query with reference to the extracted parameters, creates and compiles an executable version of the skeletal query, then executes the compiled version of the skeletal query using the particular parameters in the current query. The compiled version of the parameterized skeletal query is stored, and when another query is submitted that matches the skeletal query (but with potentially different parameters), the previously compiled skeleton query is executed with the parameters of this latter query.

摘要翻译： 用于执行查询计划的系统和方法预处理用户的查询以识别和提取查询的选择参数，参考提取的参数创建骨架查询，创建并编译骨架查询的可执行版本，然后执行编译版本 使用当前查询中的特定参数的骨架查询。 存储参数化骨架查询的编译版本，并且当提交与骨架查询匹配（但具有潜在不同参数）的另一个查询时，先前编译的框架查询将使用后一查询的参数执行。

公开(公告)号：US09317552B2

公开(公告)日：2016-04-19

申请号：US13754333

申请日：2013-01-30

申请人： Adam Prout ,  Marko Tintor ,  Alex Skidanov

发明人： Adam Prout ,  Marko Tintor ,  Alex Skidanov

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/30442 ,  G06F17/30433

摘要： A system and method for executing query plans preprocesses a user's queries to identify and extract select parameters of the query, creates a skeletal query with reference to the extracted parameters, creates and compiles an executable version of the skeletal query, then executes the compiled version of the skeletal query using the particular parameters in the current query. The compiled version of the parameterized skeletal query is stored, and when another query is submitted that matches the skeletal query (but with potentially different parameters), the previously compiled skeleton query is executed with the parameters of this latter query.

摘要翻译： 用于执行查询计划的系统和方法预处理用户的查询以识别和提取查询的选择参数，参考提取的参数创建骨架查询，创建和编译骨架查询的可执行版本，然后执行编译版本 使用当前查询中的特定参数的骨架查询。 存储参数化骨架查询的编译版本，并且当提交与骨架查询匹配（但具有潜在不同参数）的另一个查询时，先前编译的框架查询将使用后一查询的参数执行。