Activation of native operations for distinct-user defined types

A computer program in executable form, stored on a computer-readable tangible storage medium, for use in controlling operations performed on a user-defined type (UDT) in a database system, where the UDT is derived from an underlying type having a set of underlying operations, the computer program including executable instructions that cause a computer to:

• create the UDT from the underlying type in the database system;
• selectively activate one or more underlying operations for the UDT;
• and
• record, in a data dictionary, the activated underlying operations for the UDT.

A database system including:

• a massively parallel processing system including:
• one or more nodes;
• a plurality of CPUs, each of the one or more nodes providing access to one or more CPUs;
• a plurality of data storage facilities each of the one or more CPUs providing access to one or more data storage facilities;
• a process for execution on the massively parallel processing system for controlling operations performed on a user-defined type (UDT) in the database system, where the UDT is derived from an underlying type having a set of underlying operations, the process including:
• creating the UDT from the underlying type in the database system;
• selectively activating one or more underlying operations for the UDT;
• and
• recording, in a data dictionary, the activated underlying operations for the UDT.