Direct loading of semistructured data
    31.
    发明申请
    Direct loading of semistructured data 有权
    直接加载半结构化数据

    公开(公告)号:US20050050092A1

    公开(公告)日:2005-03-03

    申请号:US10648600

    申请日:2003-08-25

    IPC分类号: G06F17/00 G06F17/30

    CPC分类号: G06F17/30917

    摘要: Techniques and systems are disclosed for directly storing semistructured data in a database. According to one aspect, a client application reads data that comprises instances of a parent type. The client application invokes routines associated with the parent type. An array is created for storing instances of the parent type. These routines invoke routines associated with a child type of the parent type. An array is created for storing instances of the child type. The arrays are populated with values specified in the data. According to one aspect, some columns of the arrays may be populated with other values to be stored in hidden columns of database tables. The client application converts the arrays into a data stream that conforms to the format of the database's data blocks. The client application then streams the data to a database server, which writes the data blocks directly into one or more data blocks in the database.

    摘要翻译: 公开了用于将半结构化数据直接存储在数据库中的技术和系统。 根据一个方面,客户端应用读取包含父类型的实例的数据。 客户端应用程序调用与父类型相关联的例程。 创建一个数组来存储父类型的实例。 这些例程调用与父类型的子类型相关联的例程。 创建一个数组来存储子类型的实例。 数组用数据中指定的值填充。 根据一个方面,阵列的一些列可以用其他值填充以存储在数据库表的隐藏列中。 客户端应用程序将阵列转换为符合数据库数据块格式的数据流。 然后,客户端应用程序将数据流传输到数据库服务器,数据库服务器将数据块直接写入数据库中的一个或多个数据块。

    Method and mechanism for supporting virtual content in performing file operations at a RDBMS
    32.
    发明授权
    Method and mechanism for supporting virtual content in performing file operations at a RDBMS 有权
    在RDBMS执行文件操作时支持虚拟内容的方法和机制

    公开(公告)号:US08224837B2

    公开(公告)日:2012-07-17

    申请号:US11172088

    申请日:2005-06-29

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30171 G06F17/30233

    摘要: Techniques are provided for accessing and storing files within a virtual folder. A virtual folder is a folder that is logically a part of a hierarchical folder structure of a file system repository, but the contents of the virtual folder are not physically stored in the file system repository. A client may issue, to an access mechanism, a request to perform a file operation on a file in a virtual folder. The access mechanism, which may be a database server or a component therein, may perform the file operation on the file in the virtual folder as if the file was stored in a particular folder within the hierarchical folder structure implemented by the file system repository. Advantageously, files may be physically stored outside of the file system repository, but still be a part of the hierarchical folder structure implemented by the file system repository.

    摘要翻译: 提供技术来访问和存储虚拟文件夹中的文件。 虚拟文件夹是逻辑上是文件系统存储库的分层文件夹结构的一部分的文件夹,但虚拟文件夹的内容不会物理存储在文件系统存储库中。 客户端可以向访问机制发出对虚拟文件夹中的文件执行文件操作的请求。 可以是数据库服务器或其中的组件的访问机制可以对虚拟文件夹中的文件执行文件操作,就好像该文件被存储在由文件系统存储库实现的分层文件夹结构内的特定文件夹中。 有利地,文件可以物理地存储在文件系统存储库之外,但仍然是由文件系统存储库实现的分层文件夹结构的一部分。

    Direct loading of opaque types
    33.
    发明授权
    Direct loading of opaque types 有权
    直接加载不透明类型

    公开(公告)号:US07747580B2

    公开(公告)日:2010-06-29

    申请号:US10648577

    申请日:2003-08-25

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30286

    摘要: Techniques and systems are disclosed for storing instances of an opaque type in a database according to a direct path loading approach. According to one aspect, an opaque type implementor registers, with a loader application, routines that the opaque type implementor implements. In response, the loader application associates the opaque type with the routines. The loader application reads data that comprises instances of the opaque type. The loader application determines which routines are associated with the opaque type. The loader application invokes the routines, which create an array for storing instances of the opaque type and populate the array with values specified in the data. The loader application converts the array into a data stream that conforms to the format of the database's data blocks. The loader application then streams the data to a database server, which writes the data directly into data blocks in the database.

    摘要翻译: 公开了根据直接路径加载方法在数据库中存储不透明类型的实例的技术和系统。 根据一个方面,不透明类型的实现者使用加载器应用程序来注册不透明类型实现者实现的例程。 作为响应,加载程序应用程序将不透明类型与例程相关联。 加载程序应用程序读取包含不透明类型实例的数据。 加载程序应用程序确定哪些程序与不透明类型相关联。 加载程序应用程序调用例程,它创建一个数组来存储不透明类型的实例,并使用数据中指定的值填充数组。 加载程序应用程序将阵列转换为符合数据库数据块格式的数据流。 然后,加载器应用程序将数据流传输到数据库服务器,数据库服务器将数据直接写入数据库中的数据块。

    Direct loading of opaque types
    34.
    发明申请
    Direct loading of opaque types 有权
    直接加载不透明类型

    公开(公告)号:US20050050058A1

    公开(公告)日:2005-03-03

    申请号:US10648577

    申请日:2003-08-25

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30286

    摘要: Techniques and systems are disclosed for storing instances of an opaque type in a database according to a direct path loading approach. According to one aspect, an opaque type implementor registers, with a loader application, routines that the opaque type implementor implements. In response, the loader application associates the opaque type with the routines. The loader application reads data that comprises instances of the opaque type. The loader application determines which routines are associated with the opaque type. The loader application invokes the routines, which create an array for storing instances of the opaque type and populate the array with values specified in the data. The loader application converts the array into a data stream that conforms to the format of the database's data blocks. The loader application then streams the data to a database server, which writes the data directly into data blocks in the database.

    摘要翻译: 公开了根据直接路径加载方法在数据库中存储不透明类型的实例的技术和系统。 根据一个方面,不透明类型的实现者使用加载器应用程序来注册不透明类型实现者实现的例程。 作为响应,加载程序应用程序将不透明类型与例程相关联。 加载程序应用程序读取包含不透明类型实例的数据。 加载程序应用程序确定哪些程序与不透明类型相关联。 加载程序应用程序调用例程,它创建一个数组来存储不透明类型的实例,并使用数据中指定的值填充数组。 加载程序应用程序将阵列转换为符合数据库数据块格式的数据流。 然后,加载器应用程序将数据流传输到数据库服务器,数据库服务器将数据直接写入数据库中的数据块。

    Framework for supporting regular expression-based pattern matching in data streams
    35.
    发明授权
    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
    36.
    发明授权
    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
    38.
    发明授权
    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.

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

    System and method for providing highly available database performance
    39.
    发明授权
    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.

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

    FRAMEWORK FOR SUPPORTING REGULAR EXPRESSION-BASED PATTERN MATCHING IN DATA STREAMS
    40.
    发明申请
    FRAMEWORK FOR SUPPORTING REGULAR EXPRESSION-BASED PATTERN MATCHING IN DATA STREAMS 有权
    支持数据流中基于正则表达式的模式匹配的框架

    公开(公告)号:US20100057735A1

    公开(公告)日:2010-03-04

    申请号:US12548187

    申请日:2009-08-26

    IPC分类号: G06F7/06 G06F17/30

    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.

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