MBB (Teradata Database) - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
gxn1538171534877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

This SQL element is a shortcut for the User Defined Method SQL element with the User Defined Type field set to MBB (Minimum Bounding Box). An MBB defines the minimum sized box that can surround a three-dimensional geometric object. Selecting this element will display a listing of methods for the MBB type, described in the following table.

MBB Functions
Function Description
Constructor Method(s) Returns an MBB value.
INTERSECTS Tests if an MBB value spatially intersects another value of the same data type.
XMIN Returns the minimum x coordinate value of an MBB. This is the x coordinate of the lower left front corner.
YMIN Returns the minimum y coordinate value of an MBB. This is the y coordinate of the lower left front corner.
ZMIN Returns the minimum z coordinate value of an MBB. This is the z coordinate of the lower left front corner.
XMAX Returns the maximum x coordinate value of an MBB. This is the x coordinate of the upper right back corner.
YMAX Returns the maximum y coordinate value of an MBB. This is the y coordinate of the upper right back corner.
ZMAX Returns the maximum z coordinate value of an MBB. This is the z coordinate of the upper right back corner.
This feature requires Teradata 15.00 or later.