Abstract: A spatial feature is considered for storage in a database system running on a computer. The spatial feature includes a polygon, P. The polygon includes an outer ring, OR, and the area within the outer ring. The polygon includes an interior ring contained within the polygon. The computer removes the interior ring from the polygon. The computer determines a line along which to split the polygon without regard for the location of the inner ring within the polygon. The computer splits the polygon into two polygons, SP1 and SP2, along the line. The computer applies the interior ring to the two split polygons by invoking a point set difference between the interior ring and the two split polygons. The computer stores the split polygons in the database system on the computer.

Abstract: In a database system, compression user-defined data types (UDTs) are defined to enable compression of data. Each compression UDT is associated with one or more UDT methods to compress data according to one or more respective compression algorithms. Also, one or more data structures are associated with data stored according to each compression UDT to store values pertaining to the compression of the data.

Abstract: Methods and apparatus for moving data objects in a database system. In one implementation, a database system includes: one or more data storage facilities for use in storing data composing records in tables of a database, where at least one data storage facility includes at least two types of data storage devices each belonging to a respective data storage class, and at least one data storage facility stores one or more data objects each including one or more migration parameters; one or more processing modules configured to manage the data stored in the data-storage facilities and to move data objects among data storage devices in different data storage classes according to the migration parameters of the data objects; and a database management component configured to coordinate the operation of the processing modules.

Abstract: Methods and apparatus for loading data into a database system using links to data. In one implementation, a database system includes: one or more data storage facilities for use in storing data composing records in tables of a database; one or more processing modules configured to manage the data stored in the data-storage facilities; and a database management component configured to load data into the data storage facilities using one or more links received in a request from a client system, where each link indicates a server connection and a storage location for data corresponding to the link.

Abstract: Methods and apparatus for parallel execution in a database system. In one implementation, a database system includes: one or more data storage facilities for use in storing data composing records in tables of a database; one or more processing modules configured to manage the data stored in the data-storage facilities, where at least one processing module is configured to: open a memory pipe for a pipe operator, run a first thread to execute a pipe source operation providing output data to the memory pipe, and run a second thread to execute a pipe sink operation receiving input data from the memory pipe while the first thread is running; and a database management component configured to parse an expression and recognize a pipe operator and a pipe source operation and a pipe sink operation for the pipe operator.