Patent ID: 6697794
Filing Date: 2004-02-24
Classification: G06F,Y10S

Abstract:
A database system for accessing a database with a data element which has a user defined data type (UDT), the database system comprisinga massively parallel processing system comprising 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 virtual processes each of the one or more CPUs providing access to one or more virtual processes; each virtual process configured to manage data stored in one of a plurality of data-storage facilities; a parsing engine comprising a session control, which controls access to the plurality of virtual processes; a parcer, which interprets and optimizes a command for access to a database to produce a series of steps to be performed; and a dispatcher, which controls the sequence of the series of steps and determines which of the plurality of virtual processes will perform each of the series of steps; where the parcer includes an optimizer which optimizes a plan for executing the series of steps; where the optimizer includes a process for getting a type for an alias for the UDT data element; and a process for getting the alias for the UDT data element.