Teradata Us, Inc.

Elizabeth J Brealey

Michael Leon Reed

Kevin Dean Virgil

Angelica Garcia-Gutierrez

Cameron Lewis

A data store system may include a storage device that may store a plurality of data. The data store system may also include a processor in communication with the storage device. The processor may receive a request that references at least one input array having an element type, a size, and a dimension. The processor may further generate an array based on the request. The array may have an element type, a size, and a dimension and at least one of the element type, the size, and the dimension of the array may be different than the element type, the size, and the dimension of the input array. The processor may further generate, using the array, an output in response to the request. A method and computer-readable medium may also be implemented.

Dynamic array type in a data store system

Timing data associated with a database or database system can be stored in a reduced or compressed form which can be decompressed back to a full or original form. In doing so, timing data can be compressed by using a subset of a full set of possible values (e.g., a determined range which is more likely to occur) instead of using a full set of possible values. Timing data can also be compressed by eliminating redundant, insignificant duplicate and/or common values, for example, between one or more components (e.g., start and end times of a period of time) of the timing data.

Compression of timing data of database systems and environments

A system, method, and computer-readable medium for the calculation of execution time estimates of user defined functions/user defined methods are provided. The execution of a UDF or UDM is timed several times at the time of the UDF/UDM creation, and an average execution time of the UDF/UDM is obtained. The resulting average execution time is then stored in a data dictionary where the optimizer may consult this value to factor it into the cost of execution of a query.

Growing community of inventors

San Diego, CA, United States of America

Elizabeth J Brealey