Multi-input, multi-output-per-input user-defined-function-based database operations
    3.
    发明授权
    Multi-input, multi-output-per-input user-defined-function-based database operations 有权
    多输入,多输出输入的基于用户定义功能的数据库操作

    公开(公告)号:US08805870B2

    公开(公告)日:2014-08-12

    申请号:US13192373

    申请日:2011-07-27

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30415

    摘要: The current application discloses a database management system that provides multiple-input, multiple-output-per-input user-defined-function-based operations. The database management system comprises at least one processor and electronic memory, a database-query processor, executed on a computer processor controlled by computer instructions stored in a computer-readable memory, that makes multiple calls to a multiple-input, multiple-output-per-input user-defined-function, in each call transmitting a next input to the multiple-input, multiple-output-per-input user-defined-function, and the multiple-input, multiple-output-per-input user-defined-function, executed on a computer processor controlled by computer instructions stored in a computer-readable memory, that uses three different memory buffers, the contents of which are maintained for three different time periods, to compute and return to the database-query processor multiple outputs in response to at least one of the multiple inputs.

    摘要翻译: 当前的应用公开了一种数据库管理系统,其提供多输入多输出用户定义的基于功能的操作。 数据库管理系统包括至少一个处理器和电子存储器,数据库查询处理器,其在由存储在计算机可读存储器中的计算机指令控制的计算机处理器上执行,其对多输入多输出 - 每个输入用户定义的功能,在每次呼叫中传送下一个输入到多输入多输出用户定义函数,以及多输入多输出用户定义函数, 定义的功能,在由存储在计算机可读存储器中的计算机指令控制的计算机处理器上执行,其使用三个不同的存储器缓冲器,其内容维持三个不同的时间段,以计算并返回到数据库查询处理器 多个输出响应多个输入中的至少一个。

    COMBINING DATA VALUES THROUGH ASSOCIATIVE OPERATIONS
    4.
    发明申请
    COMBINING DATA VALUES THROUGH ASSOCIATIVE OPERATIONS 有权
    通过相关操作组合数据值

    公开(公告)号:US20130061023A1

    公开(公告)日:2013-03-07

    申请号:US13224090

    申请日:2011-09-01

    IPC分类号: G06F9/318

    摘要: A method for combining data values through associative operations. The method includes, with a processor, arranging any number of data values into a plurality of columns according to natural parallelism of the associative operations and reading each column to a register of an individual processor. The processors are directed to combine the data values in the columns in parallel using a first associative operation. The results of the first associative operation for each column are stored in a register of each processor.

    摘要翻译: 一种通过关联操作组合数据值的方法。 该方法包括与处理器根据关联操作的自然并行性将多个数据值排列到多个列中,并将每列读取到单个处理器的寄存器。 处理器旨在使用第一关联操作来并行地并列列中的数据值。 每列的第一个关联操作的结果存储在每个处理器的寄存器中。

    Processing a data stream
    6.
    发明授权
    Processing a data stream 有权
    处理数据流

    公开(公告)号:US09405801B2

    公开(公告)日:2016-08-02

    申请号:US12703574

    申请日:2010-02-10

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30516

    摘要: Methods, database management systems (“DBMS”) and computer-readable media are provided for processing unbounded stream data using a traditional DBMS. Execution of a query that includes a data stream as a data source may be initiated. Tuples may be processed in accordance with the query as the tuples are received through the data stream until an indication is received that execution of the query should cease.

    摘要翻译: 提供方法,数据库管理系统(“DBMS”)和计算机可读介质用于使用传统的DBMS来处理无界流数据。 可以启动包括数据流作为数据源的查询的执行。 可以根据查询来处理元组,因为通过数据流接收元组,直到接收到指示才能停止查询的执行。

    PROCESSING A DATA STREAM
    7.
    发明申请
    PROCESSING A DATA STREAM 有权
    处理数据流

    公开(公告)号:US20110196856A1

    公开(公告)日:2011-08-11

    申请号:US12703574

    申请日:2010-02-10

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30516

    摘要: Methods, database management systems (“DBMS”) and computer-readable media are provided for processing unbounded stream data using a traditional DBMS. Execution of a query that includes a data stream as a data source may be initiated. Tuples may be processed in accordance with the query as the tuples are received through the data stream until an indication is received that execution of the query should cease.

    摘要翻译: 提供方法,数据库管理系统(“DBMS”)和计算机可读介质用于使用传统的DBMS来处理无界流数据。 可以启动包括数据流作为数据源的查询的执行。 可以根据查询来处理元组,因为通过数据流接收元组,直到接收到指示才能停止查询的执行。

    Identifying a sequence of blocks of data to retrieve based on a query
    8.
    发明授权
    Identifying a sequence of blocks of data to retrieve based on a query 有权
    根据查询识别要检索的数据块序列

    公开(公告)号:US07761444B2

    公开(公告)日:2010-07-20

    申请号:US11543494

    申请日:2006-10-05

    IPC分类号: G06F19/00

    CPC分类号: G06F17/30442

    摘要: A computer-executable method receives at least one query that specifies requests involving blocks of data. Based on information associated with at least one query, a sequence is identified relating to an order in which the blocks are to be retrieved into a storage for processing the requests. An output is provided for the at least one query based on retrieving the blocks into the storage according to the identified sequence. According to another implementation, a method includes caching blocks of data associated with processing a database query in a temporary storage, and replacing at least some of the blocks of data in the temporary storage using a first replacement algorithm this is based on information associated with processing the database query, and where the first algorithm is different from a second replacement algorithm used by an operating system of the database system.

    摘要翻译: 计算机可执行方法接收至少一个指定涉及数据块的请求的查询。 基于与至少一个查询相关联的信息,识别与要将数据块检索到用于处理请求的存储器中的顺序有关的序列。 基于根据所识别的序列将块检索到存储器中,为至少一个查询提供输出。 根据另一实施方式,一种方法包括缓存与临时存储器中处理数据库查询相关联的数据块,并且使用基于与处理相关联的信息的第一替换算法来替换临时存储器中的至少一些数据块 数据库查询,以及第一种算法与数据库系统的操作系统使用的第二种替换算法的不同之处。

    MANAGING MEMORY
    9.
    发明申请
    MANAGING MEMORY 审中-公开
    管理记忆

    公开(公告)号:US20130290636A1

    公开(公告)日:2013-10-31

    申请号:US13459362

    申请日:2012-04-30

    IPC分类号: G06F12/08

    摘要: Methods, and apparatus to cause performance of such methods, for managing memory. The methods include requesting a particular unit of data from a first level of memory. If the particular unit of data is not available from the first level of memory, the methods further include determining whether a free unit of data exists in the first level of memory, evicting a unit of data from the first level of memory if a free unit of data does not exist in the first level of memory, and requesting the particular unit of data from a second level of memory. If the particular unit of data is not available from the second level of memory, the methods further include reading the particular unit of data from a third level of memory. The methods still further include writing the particular unit of data to the first level of memory.

    摘要翻译: 用于执行这些方法的方法和装置,用于管理存储器。 所述方法包括从第一级存储器请求特定数据单元。 如果数据的特定单元不能从第一级存储器获得,则所述方法还包括确定存储器的第一级是否存在空闲数据单元,如果存储器的空闲单元从第一级存储器驱逐数据单元 的数据在第一级存储器中不存在,并从第二级存储器请求特定数据单元。 如果特定的数据单元不能从第二级存储器获得,则该方法还包括从第三层存储器读取特定的数据单元。 该方法还包括将特定数据单元写入第一级存储器。

    Generating discrete event simulation data
    10.
    发明授权
    Generating discrete event simulation data 有权
    生成离散事件仿真数据

    公开(公告)号:US08751205B2

    公开(公告)日:2014-06-10

    申请号:US13172553

    申请日:2011-06-29

    IPC分类号: G06G7/48

    CPC分类号: G06F17/30516 G06F17/30289

    摘要: A method of generating discrete event simulation data using a query is provided herein. The method includes retrieving a trajectory specifying a service access event for a customer accessing a service in a simulation. The method also includes processing, in a relational database query, one or more pending events corresponding to one or more customers accessing the service before the customer. Additionally, the method includes processing, in the relational database query, the service access event. Processing the service access event occurs after processing the one or more pending events. The method also includes providing a result for the relational database query. The result comprises the trajectory, and the one or more trajectories.

    摘要翻译: 本文提供了使用查询产生离散事件仿真数据的方法。 该方法包括检索在模拟中为访问服务的客户指定服务访问事件的轨迹。 该方法还包括在关系数据库查询中处理与客户之前访问服务的一个或多个客户相对应的一个或多个未决事件。 另外,该方法包括在关系数据库查询中处理服务访问事件。 在处理一个或多个未决事件之后,处理服务访问事件。 该方法还包括提供关系数据库查询的结果。 结果包括轨迹和一个或多个轨迹。