System and method for pre-compiling a source cursor into a target library cache
    1.
    发明授权
    System and method for pre-compiling a source cursor into a target library cache 有权
    将源光标预编译为目标库缓存的系统和方法

    公开(公告)号:US06892205B1

    公开(公告)日:2005-05-10

    申请号:US10086842

    申请日:2002-02-28

    IPC分类号: G06F17/00 G06F17/30

    摘要: A system and method for enabling a second database instance to more quickly process a request to execute a database statement that has previously been executed by a first database instance is described. In one embodiment, the method involves sending the database statement from the first database instance to the second database instance, and generating by the second database instance one or more structures needed to prepare the statement for execution, such as a parse tree and an execution plan for the statement. If at some point in the future, the second database instance receives a request to execute the same statement, the above structures can be used for execution, thereby eliminating the need for one or more potentially time-consuming operations, such as generation of a parse tree or execution plan for the statement.

    摘要翻译: 描述了使得第二数据库实例能够更快速地处理执行先前由第一数据库实例执行的数据库语句的请求的系统和方法。 在一个实施例中,该方法涉及将数据库语句从第一数据库实例发送到第二数据库实例,并且由第二数据库实例生成准备执行语句所需的一个或多个结构,诸如解析树和执行计划 为声明。 如果在将来的某个时刻,第二个数据库实例接收到执行相同语句的请求,上述结构可以用于执行,从而不需要一个或多个潜在的耗时的操作,比如生成解析 树或执行计划。

    System and method for providing highly available database performance
    2.
    发明授权
    System and method for providing highly available database performance 有权
    提供高可用数据库性能的系统和方法

    公开(公告)号:US07984042B2

    公开(公告)日:2011-07-19

    申请号:US11088340

    申请日:2005-03-23

    IPC分类号: G06F7/00

    摘要: A system and method for enabling a second database instance to more quickly process a request to execute a database statement that has previously been executed by a first database instance is described. In one embodiment, the method involves sending the database statement from the first database instance to the second database instance, and generating by the second database instance one or more structures needed to prepare the statement for execution, such as a parse tree and an execution plan for the statement. If at some point in the future, the second database instance receives a request to execute the same statement, the above structures can be used for execution, thereby eliminating the need for one or more potentially time-consuming operations, such as generation of a parse tree or execution plan for the statement.

    摘要翻译: 描述了使得第二数据库实例能够更快速地处理执行先前由第一数据库实例执行的数据库语句的请求的系统和方法。 在一个实施例中,该方法涉及将数据库语句从第一数据库实例发送到第二数据库实例,并且由第二数据库实例生成准备执行语句所需的一个或多个结构,诸如解析树和执行计划 为声明。 如果在将来的某个时刻,第二个数据库实例接收到执行相同语句的请求,上述结构可以用于执行,从而不需要一个或多个潜在的耗时的操作,比如生成解析 树或执行计划。

    System and method for providing highly available database performance
    3.
    发明授权
    System and method for providing highly available database performance 有权
    提供高可用数据库性能的系统和方法

    公开(公告)号:US08200658B2

    公开(公告)日:2012-06-12

    申请号:US13158808

    申请日:2011-06-13

    IPC分类号: G06F17/30

    摘要: A system and method for enabling a second database instance to more quickly process a request to execute a database statement that has previously been executed by a first database instance is described. In one embodiment, the method involves sending the database statement from the first database instance to the second database instance, and generating by the second database instance one or more structures needed to prepare the statement for execution, such as a parse tree and an execution plan for the statement. If at some point in the future, the second database instance receives a request to execute the same statement, the above structures can be used for execution, thereby eliminating the need for one or more potentially time-consuming operations, such as generation of a parse tree or execution plan for the statement.

    摘要翻译: 描述了使得第二数据库实例能够更快速地处理执行先前由第一数据库实例执行的数据库语句的请求的系统和方法。 在一个实施例中,该方法涉及将数据库语句从第一数据库实例发送到第二数据库实例,并且由第二数据库实例生成准备执行语句所需的一个或多个结构,诸如解析树和执行计划 为声明。 如果在将来的某个时刻,第二个数据库实例接收到执行相同语句的请求,上述结构可以用于执行,从而不需要一个或多个潜在的耗时的操作,比如生成解析 树或执行计划。

    SYSTEM AND METHOD FOR PROVIDING HIGHLY AVAILABLE DATABASE PERFORMANCE
    4.
    发明申请
    SYSTEM AND METHOD FOR PROVIDING HIGHLY AVAILABLE DATABASE PERFORMANCE 有权
    提供高可用性数据库性能的系统和方法

    公开(公告)号:US20110238655A1

    公开(公告)日:2011-09-29

    申请号:US13158808

    申请日:2011-06-13

    IPC分类号: G06F17/30 G06F7/00

    摘要: A system and method for enabling a second database instance to more quickly process a request to execute a database statement that has previously been executed by a first database instance is described. In one embodiment, the method involves sending the database statement from the first database instance to the second database instance, and generating by the second database instance one or more structures needed to prepare the statement for execution, such as a parse tree and an execution plan for the statement. If at some point in the future, the second database instance receives a request to execute the same statement, the above structures can be used for execution, thereby eliminating the need for one or more potentially time-consuming operations, such as generation of a parse tree or execution plan for the statement.

    摘要翻译: 描述了使得第二数据库实例能够更快速地处理执行先前由第一数据库实例执行的数据库语句的请求的系统和方法。 在一个实施例中,该方法涉及将数据库语句从第一数据库实例发送到第二数据库实例,并且由第二数据库实例生成准备执行语句所需的一个或多个结构,诸如解析树和执行计划 为声明。 如果在将来的某个时刻,第二个数据库实例接收到执行相同语句的请求,上述结构可以用于执行,从而不需要一个或多个潜在的耗时的操作,比如生成解析 树或执行计划。

    Framework for supporting regular expression-based pattern matching in data streams
    5.
    发明授权
    Framework for supporting regular expression-based pattern matching in data streams 有权
    支持数据流中基于正则表达式的模式匹配的框架

    公开(公告)号:US09305238B2

    公开(公告)日:2016-04-05

    申请号:US12548187

    申请日:2009-08-26

    IPC分类号: G06F17/30 G06K9/62

    CPC分类号: G06K9/62

    摘要: Techniques for detecting patterns in one or more data or event streams. A pattern to be detected may be specified using a regular expression. Events received in a data stream are processed during runtime to detect occurrences of the specified pattern in the data stream. In one embodiment, a pattern type or class is determined for the specified pattern and pattern matching is performed using a technique selected based upon the type or class determined for the specified pattern.

    摘要翻译: 用于检测一个或多个数据或事件流中的模式的技术。 可以使用正则表达式来指定要检测的模式。 在运行期间处理在数据流中接收的事件,以检测数据流中指定模式的出现。 在一个实施例中,对于指定的图案确定图案类型或类别,并且使用基于为指定图案确定的类型或类别而选择的技术来执行图案匹配。

    Compile time opcodes for efficient runtime interpretation of variables for database queries and DML statements
    6.
    发明授权
    Compile time opcodes for efficient runtime interpretation of variables for database queries and DML statements 有权
    用于数据库查询和DML语句的变量的有效运行时解释的编译时间操作码

    公开(公告)号:US08849794B2

    公开(公告)日:2014-09-30

    申请号:US13052928

    申请日:2011-03-21

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30433

    摘要: A method system and program for performing a query in which context and information including opcodes accompanies an execution plan for the query. The opcodes determine operations to retrieve a set of bind variables. The execution plan and context information shared by a plurality of application programs.

    摘要翻译: 一种用于执行查询的方法系统和程序,其中包括操作码的上下文和信息伴随着查询的执行计划。 操作码确定检索一组绑定变量的操作。 由多个应用程序共享的执行计划和上下文信息。

    Facilitating flexible windows in data stream management systems
    8.
    发明授权
    Facilitating flexible windows in data stream management systems 有权
    促进数据流管理系统中的灵活窗口

    公开(公告)号:US08019747B2

    公开(公告)日:2011-09-13

    申请号:US11927681

    申请日:2007-10-30

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30964

    摘要: Facilitating flexible windows in querying continuous data streams. In one embodiment, a software code is associated with a window, wherein execution of the software code determines the values to be included in the window. On receiving a query indicating the window, the result of the query is generated based on the values in the window determined by execution of the software code. The software code may be identified by an identifier and thus used for different queries on the same or different continuous data streams.

    摘要翻译: 方便灵活的窗口查询连续的数据流。 在一个实施例中,软件代码与窗口相关联,其中软件代码的执行确定要包括在窗口中的值。 在接收到指示窗口的查询时,基于通过执行软件代码确定的窗口中的值来生成查询结果。 软件代码可以由标识符标识,并且因此用于相同或不同连续数据流上的不同查询。

    Method and mechanism for loading XML documents into memory
    9.
    发明授权
    Method and mechanism for loading XML documents into memory 有权
    将XML文档加载到内存中的方法和机制

    公开(公告)号:US07933928B2

    公开(公告)日:2011-04-26

    申请号:US11317101

    申请日:2005-12-22

    IPC分类号: G06F7/00 G06F17/30 G06F12/00

    CPC分类号: G06F17/2247 G06F17/30908

    摘要: A method and apparatus for loading an XML document into memory is provided. A client loads one or more array elements into a first partition of an array that is maintained in memory. Each array element represents an XML element of an XML document. Upon determining that an amount of data maintained in the first partition exceeds a first threshold, the client subsequently loads array elements into a new partition of the array. Upon determining that an amount of data maintained in the memory of the client exceeds a second threshold, the array elements of the least recently used partition are persistently stored in a database without persistently storing the entire XML document. When the last XML element of the XML document is loaded into a partition of the array, that partition is persistently stored in the database, thereby causing the entire XML document to be stored in the database.

    摘要翻译: 提供了一种将XML文档加载到存储器中的方法和装置。 客户端将一个或多个数组元素加载到内存中维护的数组的第一个分区中。 每个数组元素表示XML文档的XML元素。 在确定在第一分区中维护的数据量超过第一阈值时,客户端随后将数组元素加载到阵列的新分区中。 在确定在客户端的存储器中维护的数据量超过第二阈值时,最近最少使用的分区的数组元素被持久地存储在数据库中,而不会持续存储整个XML文档。 当XML文档的最后一个XML元素加载到数组的分区中时,该分区将永久存储在数据库中,从而使整个XML文档存储在数据库中。

    Techniques for transaction semantics for a database server performing file operations
    10.
    发明授权
    Techniques for transaction semantics for a database server performing file operations 有权
    用于执行文件操作的数据库服务器的事务语义的技术

    公开(公告)号:US07716260B2

    公开(公告)日:2010-05-11

    申请号:US11013889

    申请日:2004-12-16

    IPC分类号: G06F17/30

    摘要: A method and apparatus for reverting a resource to a prior state in time is provided. Changes are committed to a resource at a particular point in time. After the particular point in time, a request, which may be a file system operation request, to revert the resource to a state prior to the particular point in time is received at a database server. In response to the request, the resource is reverted to the state prior to the particular point in time. The current state of the resource ceases to reflect the plurality of changes. Advantageously, if a requestor creates an incorrect version of a resource, the changes made to a schema-based resource are not compatible with the schema, or the changes of multiple requesters are not compatible with each other, the resource may be reverted to the earlier point in time.

    摘要翻译: 提供了一种用于将资源恢复到先前状态的方法和装置。 更改在特定时间点致力于资源。 在特定时间点之后,在数据库服务器处接收到可能是文件系统操作请求的将资源恢复到特定时间点之前的状态的请求。 响应于该请求,资源被恢复到特定时间点之前的状态。 资源的当前状态不再反映多种变化。 有利的是,如果请求者创建资源的不正确版本,对基于模式的资源所做的更改与模式不兼容,或者多个请求者的更改彼此不兼容,则该资源可能还原到较早 时间点。