Actian Corporation

Ian Philip Kirkham

Examples described herein generally relate to database operations including encoding, within a length field for a first value to be stored in a column of a database as a token that includes information for processing a large object, an indicator indicating that the first value is of a token type, and storing, in the column of the database, the first value with the length field including the indicator.

Method and apparatus for storing object tokens in a database

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.

Object data stored out of line vector engine

Database systems handle queries represented in different character sets. A database system allows data stored in the same database column to be represented in different character sets. In response to a query, the database system returns query results in the same character set as the received query even though the data stored in the database column is in a different character set. The database system creates and maintains a metadata table that stores attributes of database columns. The attributes of database columns include, among others, a data type, and a collation attribute. By tracking the collation attributes for data stored in database columns, the database system determines whether to convert data stored in a database column when processing database queries.

Growing community of inventors

Stinchcombe, United Kingdom

Ian Philip Kirkham