SYSTEM AND METHOD FOR EXECUTING COMPILED USER DEFINED FUNCTIONS IN VECTORIZED DATABASES

    公开(公告)号:US20230080220A1

    公开(公告)日:2023-03-16

    申请号:US17873906

    申请日:2022-07-26

    IPC分类号: G06F16/2453

    摘要: Aspects described herein relate to executing a compiled user defined function (UDF) in an interpreted database query engine. A database query that invokes a UDF defined in an interpreted programming language can be received, and a shared library produced by compiling the UDF can be loaded during database runtime. The UDF can be executed via the shared library during the invocation of the database query, or another database query, in the interpreted database query engine.

    OBJECT DATA STORED OUT OF LINE VECTOR ENGINE

    公开(公告)号:US20220405257A1

    公开(公告)日:2022-12-22

    申请号:US17830015

    申请日:2022-06-01

    IPC分类号: G06F16/22

    摘要: Examples described herein generally relate to database systems for storing and processing both small values that are smaller than size of a database column and large objects that exceed the size of the database column. A database management system (DBMS) determines that a value to be stored in a database is a large object having a size larger than a column of the database. The DBMS stores the value as a large object in an external storage associated with a token stored in the column of the database. The token includes information for processing the large object. A vector processing engine associated with the external storage processes the large object based on the information in the token in response to a database command from the DBMS on multiple records represented as a vector.

    Processing database queries based on external tables

    公开(公告)号:US11347734B1

    公开(公告)日:2022-05-31

    申请号:US15666500

    申请日:2017-08-01

    摘要: A database system processes database queries that process external tables representing data obtained from an external systems. The database system generates an execution plan to execute the database query. The database system sends a request for data of the external table to an external system. The request provides connection information to the external system. The external system sends a request to connect to the database system and provides data of the external table as a data stream. If the database system reaches an operator that processes the data of the external table, the database system waits for data from the external system. The database system processes the database query using the data of the data stream. The database system provides the result of the database query to a requestor, for example, a client device.

    System and method for software application usage metering using data store

    公开(公告)号:US10026069B2

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

    申请号:US14136508

    申请日:2013-12-20

    摘要: A system and method for usage metering software applications (or features or functions) by monitoring the data store underlying the software application. The data store function may be implemented in many ways, such as a Relational Database, Transactional Database, Network and Graph Database, Object-Oriented Database, Embedded Database, In-memory Database, Schema-less Database, Files and Directories, whether structured or unstructured, Configuration Registries, or Non-traditional Repositories. Business activities performed by the software application are tracked and are independent of hardware usage. Such usage data is valuable in a variety of contexts, including billing based on business activity.